R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

getwd()
## [1] "C:/Users/csd77/Drexel University/Nowak Metro Finance Lab - Documents/NMFL_PROJECTS/2022_Kauffman_SSBCI/SSBCI Map"
#setwd("~/Documents/Nowak Metro/ssbci")
loans <- readxl::read_xlsx("data/ssbci_update.xlsx")
library(rgdal)
## Loading required package: sp
## Warning: package 'sp' was built under R version 4.3.2
## Please note that rgdal will be retired during October 2023,
## plan transition to sf/stars/terra functions using GDAL and PROJ
## at your earliest convenience.
## See https://r-spatial.org/r/2023/05/15/evolution4.html and https://github.com/r-spatial/evolution
## rgdal: version: 1.6-7, (SVN revision 1203)
## Geospatial Data Abstraction Library extensions to R successfully loaded
## Loaded GDAL runtime: GDAL 3.6.2, released 2023/01/02
## Path to GDAL shared files: C:/Users/csd77/AppData/Local/R/win-library/4.3/rgdal/gdal
##  GDAL does not use iconv for recoding strings.
## GDAL binary built with GEOS: TRUE 
## Loaded PROJ runtime: Rel. 9.2.0, March 1st, 2023, [PJ_VERSION: 920]
## Path to PROJ shared files: C:/Users/csd77/AppData/Local/R/win-library/4.3/rgdal/proj
## PROJ CDN enabled: FALSE
## Linking to sp version:2.1-0
## To mute warnings of possible GDAL/OSR exportToProj4() degradation,
## use options("rgdal_show_exportToProj4_warnings"="none") before loading sp or rgdal.
states = readOGR(dsn="data/cb_2018_us_state_500k/.", verbose=FALSE)
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
#merging loans with zip, long lat cross walk
zip<- read.csv("data/zip_lat_long.csv")
library(dplyr)
## Warning: package 'dplyr' was built under R version 4.3.2
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
zip <- zip %>% 
  rename(zipcode=ZIP)

ssbci<- merge (loans, zip, by ="zipcode")
names(ssbci)
##  [1] "zipcode"             "Date"                "State or Territory" 
##  [4] "City"                "Amount"              "Type"               
##  [7] "Innovative Finance?" "Program Type"        "Program/Fund Name"  
## [10] "Business Name"       "Sector"              "Industry"           
## [13] "NAICS"               "Macro Trends?"       "SEDI?"              
## [16] "Link"                "Notes"               "Company Description"
## [19] "LAT"                 "LNG"
library(dplyr)

# Assuming 'ssbci' is your dataset

# Replace all occurrences of a specific character (e.g., empty string) with NA
ssbci <- ssbci %>%
  mutate_all(~ ifelse(. %in% c("", " "), NA, .))

# Print or use the modified dataset
print(ssbci)
##     zipcode       Date State or Territory               City  Amount
## 1       603 1691539200                 PR          Aguadilla 3800000
## 2       801 1704412800                 VI         St. Thomas      NA
## 3       824 1704412800                 VI          St. Croix      NA
## 4      1001 1687910400                 NY               <NA>  200000
## 5      1460 1670544000                 MA          Littleton      NA
## 6      2032 1700179200                 MA            Walpole      NA
## 7      2136 1670544000                 MA          Hyde Park      NA
## 8      2143 1670544000                 MA         Somerville      NA
## 9      4950 1686096000                 ME            Madison 3500000
## 10     6902 1707868800                 CT               <NA>      NA
## 11     7960 1698278400                 NJ         Morristown      NA
## 12    10003 1687910400                 NY           New York   90000
## 13    10017 1687910400                 NY           New York  250000
## 14    10023 1687910400                 NY           New York  200000
## 15    10024 1687910400                 NY           New York  250000
## 16    10918 1684972800                 NY            Chester 1300000
## 17    15143 1677715200                 PA          Sewickley      NA
## 18    15208 1681776000                 PA         Pittsburgh      NA
## 19    17110 1694390400                 PA         Harrisburg   97000
## 20    17111 1692144000                 PA         Harrisburg  250000
## 21    17602         NA                 PA          Lancaster 1400000
## 22    17701 1690588800                 PA       Williamsport  200000
## 23    18015 1679356800                 PA Northampton County  400000
## 24    18015 1690502400                 PA          Bethlehem  100000
## 25    18015 1684886400                 PA          Bethlehem  200000
## 26    18106 1679356800                 PA          Allentown  340000
## 27    19103 1684886400                 PA       Philadelphia  250000
## 28    19107 1682899200                 PA       Philadelphia  200000
## 29    19122 1682899200                 PA       Philadelphia  250000
## 30    19606 1687996800                 PA            Reading   50000
## 31    20110 1685577600                 VA           Manassas      NA
## 32    20151 1698192000                 VA          Chantilly      NA
## 33    20166 1695859200                 VA           Richmond      NA
## 34    20166 1702944000                 VA           Sterling      NA
## 35    20723 1677542400                 MD           Columbia  250000
## 36    20737 1662595200                 MD          Riverdale 1000000
## 37    20740 1695859200                 MD       College Park  200000
## 38    20814 1695686400                 MD           Bethesda  500000
## 39    20850 1684713600                 MD          Rockville  400000
## 40    20878 1684368000                 MD       Gaithersburg  200000
## 41    20879 1686096000                 MD       Gaithersburg  500000
## 42    20912 1678924800                 MD        Takoma Park      NA
## 43    21030 1687737600                 MD        Hunt Valley  500000
## 44    21201 1689552000                 MD          Baltimore  500000
## 45    21201 1689638400                 MD          Baltimore 1000000
## 46    21201 1676505600                 MD          Baltimore  150000
## 47    21217 1678665600                 MD          Baltimore  200000
## 48    21224 1682899200                 MD          Baltimore  200000
## 49    21231 1679961600                 MD          Baltimore  150000
## 50    21704 1686182400                 MD          Frederick  300000
## 51    21804 1677110400                 MD           Columbia  200000
## 52    21901 1667174400                 MD             Elkton 5000000
## 53    22031 1684713600                 VA            Fairfax      NA
## 54    22041 1682899200                 VA       Falls Church      NA
## 55    22101 1690329600                 VA             Mclean      NA
## 56    22102 1702512000                 VA             McLean      NA
## 57    22202 1705363200                 VA          Arlington      NA
## 58    22203 1701043200                 VA          Arlington      NA
## 59    22209 1690243200                 VA          Arlington      NA
## 60    22209 1685404800                 VA          Arlington      NA
## 61    22209 1680652800                 VA          Arlington      NA
## 62    22314 1688947200                 VA         Alexandria      NA
## 63    22901 1698278400                 VA    Charlottesville      NA
## 64    22902 1686009600                 VA    Charlottesville      NA
## 65    22902 1692144000                 VA    Charlottesville      NA
## 66    22902 1698364800                 VA    Charlottesville      NA
## 67    22980 1695772800                 VA         Waynesboro      NA
## 68    23059 1688601600                 VA         Glen Allen      NA
## 69    23060 1697068800                 VA           Richmond      NA
## 70    23219 1682899200                 VA           Richmond      NA
## 71    23224 1701734400                 VA           Richmond      NA
## 72    23230 1684886400                 VA           Richmond  150000
## 73    23236 1698883200                 VA           Richmond      NA
## 74    25301         NA                 WV         Charleston  500000
## 75    25801 1698624000                 WV         Charleston   55000
## 76    26508 1694476800                 WV    Mongolia County  500000
## 77    32303 1696896000                 FL        Tallahassee      NA
## 78    49286 1707868800                 MI           Tecumseh      NA
## 79    50010 1684972800                 IA               Ames  250000
## 80    50010 1681084800                 IA               Ames  250000
## 81    50014 1684972800                 IA               Ames  250000
## 82    50023 1679011200                 IA             Ankeny  100000
## 83    50023 1679011200                 IA             Ankeny  100000
## 84    50263 1676505600                 IA             Waukee  175000
## 85    50265 1679011200                 IA         Des Moines   50000
## 86    50266 1695945600                 IA    West Des Moines 1000000
## 87    50309 1684972800                 IA         Des Moines 1000000
## 88    50312 1700179200                 IA         Des Moines  250000
## 89    50323 1695945600                 IA          Urbandale  250000
## 90    50325 1674172800                 IA              Clive  100000
## 91    50511 1676505600                 IA             Algona  175000
## 92    51401 1674172800                 IA            Carroll  100000
## 93    52233 1679011200                 IA           Hiawatha  100000
## 94    52241 1676505600                 IA         Coralville  500000
## 95    52241 1689897600                 IA         Coralville 1000000
## 96    52245 1681084800                 IA          Iowa City 1000000
## 97    52328 1674172800                 IA       Cedar Rapids   50000
## 98    52333 1684972800                 IA              Solon  250000
## 99    52353 1681084800                 IA         Washington  240000
## 100   55066 1685491200                 MN           Red Wing  500000
## 101   55104 1685491200                 MN            St Paul  400000
## 102   55113 1685491200                 MN          Roseville  400000
## 103   55311 1685491200                 MN        Maple Grove  100000
## 104   55331 1685491200                 MN          Excelsior  200000
## 105   55345 1685491200                 MN         Minnetonka  100000
## 106   55391 1685491200                 MN          Deephaven  100000
## 107   55401 1685491200                 MN        Minneapolis  100000
## 108   55410 1685491200                 MN        Minneapolis  160000
## 109   55410 1685491200                 MN        Minneapolis  250000
## 110   55413 1685491200                 MN        Minneapolis  100000
## 111   55415 1685491200                 MN        Minneapolis  400000
## 112   55418 1685491200                 MN        Minneapolis  143903
## 113   55428 1685491200                 MN           New Hope   95835
## 114   55438 1685491200                 MN        Bloomington  200000
## 115   55439 1685491200                 MN       Eden Prairie  400000
## 116   55901 1685491200                 MN          Rochester  120000
## 117   55954 1685491200                 MN              Mabel  500000
## 118   56001 1686096000                 MN            Mankato  492000
## 119   56292 1685491200                 MN              Vesta   63988
## 120   56573 1686096000                 MN             Perham   90225
## 121   57104 1681257600                 SD        Sioux Falls 3000000
## 122   58047 1680912000                 ND             Horace      NA
## 123   58078 1689206400                 ND         West Fargo      NA
## 124   58102 1678320000                 ND              Fargo      NA
## 125   58102 1689206400                 ND              Fargo      NA
## 126   58102 1679529600                 ND              Fargo      NA
## 127   58103 1677628800                 ND              Fargo 1250000
## 128   58104 1679529600                 ND              Fargo      NA
## 129   58201 1680912000                 ND        Grand Forks      NA
## 130   58201 1679529600                 ND        Grand Forks      NA
## 131   58202 1683590400                 ND        Grand Forks 2500000
## 132   58503 1689206400                 ND           Bismarck      NA
## 133   58801 1696377600                 ND          Williston      NA
## 134   63102 1682985600                 MO          St. Louis      NA
## 135   63102 1691625600                 MO          St. Louis      NA
## 136   63103 1682985600                 MO          St. Louis      NA
## 137   63103 1682985600                 MO          St. Louis      NA
## 138   63103 1677024000                 MO          St. Louis      NA
## 139   63108 1677024000                 MO          St. Louis      NA
## 140   63110 1682985600                 MO          St. Louis      NA
## 141   63110 1691625600                 MO          St. Louis      NA
## 142   63110 1691625600                 MO          St. Louis      NA
## 143   63112 1691625600                 MO          St. Louis      NA
## 144   63130 1691625600                 MO          St. Louis      NA
## 145   63132 1677024000                 MO        Creve Coeur      NA
## 146   63132 1677024000                 MO          St. Louis      NA
## 147   63139 1677024000                 MO          St. Louis      NA
## 148   63141 1682985600                 MO          St. Louis      NA
## 149   64105 1668470400                 KS        Kansas City      NA
## 150   64108 1691625600                 MO        Kansas City      NA
## 151   64108 1691625600                 MO        Kansas City      NA
## 152   64113 1682985600                 MO        Kansas City      NA
## 153   64114 1686873600                 KS             Olathe      NA
## 154   64119 1691625600                 MO        Kansas City      NA
## 155   65203 1676851200                 MO           Columbia      NA
## 156   65810 1677024000                 MO        Springfield      NA
## 157   66002 1681257600                 KS               Hays      NA
## 158   66006 1688515200                 KS       Baldwin City      NA
## 159   66006 1678060800                 KS       Baldwin City      NA
## 160   66013 1678060800                 KS            Bucyrus      NA
## 161   66044 1688428800                 KS           Lawrence      NA
## 162   66049 1688515200                 KS           Lawrence      NA
## 163   66049 1688428800                 KS           Lawrence      NA
## 164   66061 1668470400                 KS             Olathe      NA
## 165   66061 1688428800                 KS             Olathe      NA
## 166   66061 1670889600                 KS            Wichita      NA
## 167   66062 1688515200                 KS             Olathe      NA
## 168   66102 1688515200                 KS        Kansas City      NA
## 169   66210 1681430400                 KS             Olathe      NA
## 170   66210 1688428800                 KS              Ellis      NA
## 171   66211 1681257600                 KS      Overland Park      NA
## 172   66211 1688428800                 KS      Overland Park      NA
## 173   66214 1681257600                 KS            Shawnee      NA
## 174   66215 1681257600                 KS             Lenexa      NA
## 175   66216 1686873600                 KS            Shawnee      NA
## 176   66221 1677024000                 MO      Overland Park      NA
## 177   66401 1692489600                 KS               Alma      NA
## 178   66409 1678060800                 KS           Berryton      NA
## 179   66441 1688428800                 KS      Junction City      NA
## 180   66502 1688515200                 KS          Manhattan      NA
## 181   66502 1678060800                 KS          Manhattan      NA
## 182   66502 1679961600                 KS          Manhattan      NA
## 183   66502 1688515200                 KS          Manhattan      NA
## 184   66608 1681257600                 KS             Topeka      NA
## 185   66610 1678060800                 KS             Topeka      NA
## 186   66801 1692489600                 KS            Emporia      NA
## 187   66968 1688428800                 KS         Washington      NA
## 188   67010 1668470400                 KS           Neodesha      NA
## 189   67202 1692489600                 KS            Wichita      NA
## 190   67214 1681257600                 KS              Derby      NA
## 191   67226 1688515200                 KS            Wichita      NA
## 192   67226 1688515200                 KS            Wichita      NA
## 193   67226 1692489600                 KS            Wichita      NA
## 194   67226 1688428800                 KS            Wichita      NA
## 195   67401 1681257600                 KS             Salina      NA
## 196   67401 1667865600                 KS             Salina      NA
## 197   67401 1678060800                 KS             Salina      NA
## 198   67432 1681257600                 KS        Clay Center      NA
## 199   67473 1686873600                 KS            Osborne      NA
## 200   67501 1681257600                 KS         Hutchinson   89000
## 201   67502 1686873600                 KS         Hutchinson      NA
## 202   67529 1692489600                 KS           Garfield      NA
## 203   67530 1688428800                 KS         Great Bend      NA
## 204   67601 1681257600                 KS               Hays      NA
## 205   67601 1686873600                 KS               Hays      NA
## 206   67642 1688428800                 KS          Hill City      NA
## 207   67756 1692489600                 KS        St. Francis      NA
## 208   67761 1688428800                 KS            Wallace      NA
## 209   67801 1686873600                 KS         Dodge City      NA
## 210   67801 1686873600                 KS         Dodge City      NA
## 211   67861 1688515200                 KS              Leoti      NA
## 212   67879 1692489600                 KS            Tribune      NA
## 213   68504 1681689600                 NE            Lincoln  500000
## 214   72417 1687910400                 NY           New York  250000
## 215   81211 1681689600                 CO        Buena Vista 2500000
## 216   82001 1691020800                 WY           Cheyenne      NA
## 217   82001 1697068800                 WY           Cheyenne      NA
## 218   89104 1682985600                 NV          Las Vegas  150000
## 219   89113 1699833600                 NV          Las Vegas      NA
##                                                 Type
## 1                                               Loan
## 2                                               <NA>
## 3                                               <NA>
## 4                         Equity or Convertible Note
## 5                                             Equity
## 6                                               Loan
## 7                                             Equity
## 8                                             Equity
## 9   Convertible Note or convertible preferred equity
## 10                                              <NA>
## 11                                              <NA>
## 12                        Equity or Convertible Note
## 13                        Equity or Convertible Note
## 14                        Equity or Convertible Note
## 15                        Equity or Convertible Note
## 16                                              Loan
## 17                                              Loan
## 18                                              Loan
## 19                                              Loan
## 20                                              Loan
## 21                                              Loan
## 22                                            Equity
## 23                                            Equity
## 24                                            Equity
## 25                                            Equity
## 26                                            Equity
## 27                                            Equity
## 28                                            Equity
## 29                                            Equity
## 30                                              Loan
## 31                                            Equity
## 32                                            Equity
## 33                                            Equity
## 34                                            Equity
## 35                        Equity or Convertible Note
## 36                                            Equity
## 37                                            Equity
## 38                                            Equity
## 39                                            Equity
## 40                        Equity or Convertible Note
## 41                                            Equity
## 42                                              Loan
## 43                                            Equity
## 44                                            Equity
## 45                                            Equity
## 46                        Equity or Convertible Note
## 47                        Equity or Convertible Note
## 48                        Equity or Convertible Note
## 49                                  Convertible Note
## 50                                            Equity
## 51                        Equity or Convertible Note
## 52                                            Equity
## 53                                            Equity
## 54                                            Equity
## 55                                            Equity
## 56                                            Equity
## 57                                            Equity
## 58                                            Equity
## 59                                            Equity
## 60                                            Equity
## 61                                            Equity
## 62                                            Equity
## 63                                            Equity
## 64                                            Equity
## 65                                            Equity
## 66                                            Equity
## 67                                            Equity
## 68                                            Equity
## 69                                            Equity
## 70                                            Equity
## 71                                            Equity
## 72                                            Equity
## 73                                            Equity
## 74                                              Loan
## 75                                            Equity
## 76                                              Loan
## 77                                              Loan
## 78                    Loan (Cash Collatoral Account)
## 79                                              Loan
## 80                                              Loan
## 81                                              Loan
## 82                                              Loan
## 83                                              Loan
## 84                                              Loan
## 85                                              Loan
## 86                                              Loan
## 87                                              Loan
## 88                                              Loan
## 89                                              Loan
## 90                                              Loan
## 91                                              Loan
## 92                                              Loan
## 93                                              Loan
## 94                                              Loan
## 95                                              Loan
## 96                                              Loan
## 97                                              Loan
## 98                                              Loan
## 99                                              Loan
## 100                                             Loan
## 101                                             Loan
## 102                                             Loan
## 103                                             Loan
## 104                                             Loan
## 105                                             Loan
## 106                                             Loan
## 107                                             Loan
## 108                                             Loan
## 109                                             Loan
## 110                                             Loan
## 111                                             Loan
## 112                                             Loan
## 113                                             Loan
## 114                                             Loan
## 115                                             Loan
## 116                                             Loan
## 117                                             Loan
## 118                                             Loan
## 119                                             Loan
## 120                                             Loan
## 121                                             Loan
## 122                       Equity or Convertible Note
## 123                       Equity or Convertible Note
## 124                       Equity or Convertible Note
## 125                       Equity or Convertible Note
## 126                       Equity or Convertible Note
## 127                                           Equity
## 128                       Equity or Convertible Note
## 129                       Equity or Convertible Note
## 130                       Equity or Convertible Note
## 131                                           Equity
## 132                       Equity or Convertible Note
## 133                                           Equity
## 134                       Equity or Convertible Note
## 135                       Equity or Convertible Note
## 136                       Equity or Convertible Note
## 137                       Equity or Convertible Note
## 138                       Equity or Convertible Note
## 139                       Equity or Convertible Note
## 140                       Equity or Convertible Note
## 141                       Equity or Convertible Note
## 142                       Equity or Convertible Note
## 143                       Equity or Convertible Note
## 144                       Equity or Convertible Note
## 145                       Equity or Convertible Note
## 146                       Equity or Convertible Note
## 147                       Equity or Convertible Note
## 148                       Equity or Convertible Note
## 149                                           Equity
## 150                       Equity or Convertible Note
## 151                       Equity or Convertible Note
## 152                       Equity or Convertible Note
## 153                                             Loan
## 154                       Equity or Convertible Note
## 155                       Equity or Convertible Note
## 156                       Equity or Convertible Note
## 157                                             Loan
## 158                                             Loan
## 159                                             Loan
## 160                                             Loan
## 161                                             Loan
## 162                                           Equity
## 163                                             Loan
## 164                                           Equity
## 165                                             Loan
## 166                                           Equity
## 167                                             Loan
## 168                                             Loan
## 169                                             <NA>
## 170                                             Loan
## 171                                           Equity
## 172                                             Loan
## 173                                             Loan
## 174                                           Equity
## 175                                             Loan
## 176                       Equity or Convertible Note
## 177                                             Loan
## 178                                             Loan
## 179                                             Loan
## 180                                             Loan
## 181                                             Loan
## 182                                           Equity
## 183                                             Loan
## 184                                             Loan
## 185                                             Loan
## 186                                             Loan
## 187                                             Loan
## 188                                             <NA>
## 189                                             Loan
## 190                                             Loan
## 191                                           Equity
## 192                                             Loan
## 193                                             Loan
## 194                                             Loan
## 195                                             Loan
## 196                                             <NA>
## 197                                             Loan
## 198                                             Loan
## 199                                             Loan
## 200                                             Loan
## 201                                             Loan
## 202                                             Loan
## 203                                             Loan
## 204                                             Loan
## 205                                             Loan
## 206                                             Loan
## 207                                             Loan
## 208                                             Loan
## 209                                             Loan
## 210                                             Loan
## 211                                           Equity
## 212                                             Loan
## 213                                             Loan
## 214                       Equity or Convertible Note
## 215                                             Loan
## 216                                           Equity
## 217                                           Equity
## 218                                             <NA>
## 219                                           Equity
##                                  Innovative Finance?             Program Type
## 1                                               <NA>                     <NA>
## 2                                               <NA>                     <NA>
## 3                                               <NA>                     <NA>
## 4                                               <NA>                Direct VC
## 5                                               <NA>                Direct VC
## 6                                               <NA>                     <NA>
## 7                                               <NA>                Direct VC
## 8                                               <NA>                Direct VC
## 9   Convertible Note or convertible preferred equity                Direct VC
## 10                                              <NA>                     <NA>
## 11                                              <NA>             OCSP - Other
## 12                                              <NA>                Direct VC
## 13                                              <NA>                Direct VC
## 14                                              <NA>                Direct VC
## 15                                              <NA>                Direct VC
## 16                                              <NA>                      LPP
## 17                                              <NA>                     <NA>
## 18                                              <NA>                     <NA>
## 19                                              <NA>                      LPP
## 20                                              <NA>                      LPP
## 21                                              <NA>                      LPP
## 22                                              BFTP                Direct VC
## 23                                              BFTP                Direct VC
## 24                                              BFTP                Direct VC
## 25                                              BFTP                Direct VC
## 26                                              BFTP                Direct VC
## 27                                              BFTP                Direct VC
## 28                                              BFTP                Direct VC
## 29                                              BFTP                Direct VC
## 30                                              <NA>                     <NA>
## 31                                              <NA>                Direct VC
## 32                                              <NA>                Direct VC
## 33                                              <NA>                Direct VC
## 34                                              <NA>                Direct VC
## 35                                              <NA>                Direct VC
## 36                                              <NA>                     <NA>
## 37                                              <NA>                Direct VC
## 38                                              <NA>                Direct VC
## 39                                              <NA>                Direct VC
## 40                                              <NA>                Direct VC
## 41                                              <NA>                Direct VC
## 42                                              <NA>                     <NA>
## 43                                              <NA>                Direct VC
## 44                                              <NA>                Direct VC
## 45                                              <NA>                Direct VC
## 46                                              <NA>                Direct VC
## 47                                              <NA>                Direct VC
## 48                                              <NA>                Direct VC
## 49                                  Convertible Note                Direct VC
## 50                                              <NA>                Direct VC
## 51                                              <NA>                Direct VC
## 52                                              <NA>                Direct VC
## 53                                              <NA>                Direct VC
## 54                                              <NA>                Direct VC
## 55                                              <NA>                Direct VC
## 56                                              <NA>                Direct VC
## 57                                              <NA>                Direct VC
## 58                                              <NA>                Direct VC
## 59                                              <NA>                Direct VC
## 60                                              <NA>                Direct VC
## 61                                              <NA>                Direct VC
## 62                                              <NA>                Direct VC
## 63                                              <NA>                Direct VC
## 64                                              <NA>                Direct VC
## 65                                              <NA>                Direct VC
## 66                                              <NA>                Direct VC
## 67                                              <NA>                Direct VC
## 68                                              <NA>                Direct VC
## 69                                              <NA>                Direct VC
## 70                                              <NA>                Direct VC
## 71                                              <NA>                Direct VC
## 72                                              <NA>                Direct VC
## 73                                              <NA>                Direct VC
## 74                                              <NA>                      LPP
## 75                                              <NA>                Direct VC
## 76                                              <NA>                      LPP
## 77                                              <NA>                     <NA>
## 78                                              <NA>                     <NA>
## 79                                 RBF (potentially)                     OCSP
## 80                                              <NA>                     OCSP
## 81                                 RBF (potentially)                     OCSP
## 82                                 RBF (potentially)                     OCSP
## 83                                 RBF (potentially)                     OCSP
## 84                                 RBF (potentially)                     OCSP
## 85                                 Royalty financing                     OCSP
## 86                                              <NA>                     OCSP
## 87                                              <NA>                     OCSP
## 88                                              <NA>                     OCSP
## 89                                              <NA>                     OCSP
## 90                                 RBF (potentially)                     OCSP
## 91                                    Likely not RBF                     OCSP
## 92                                 RBF (potentially)                     OCSP
## 93                                 RBF (potentially)                     OCSP
## 94                                 RBF (potentially)                     OCSP
## 95                                              <NA>                     OCSP
## 96                                              <NA>                     OCSP
## 97                                 Royalty financing                     OCSP
## 98                                 RBF (potentially)                     OCSP
## 99                                              <NA>                     OCSP
## 100                                             <NA>                      LPP
## 101                                             <NA>                     OCSP
## 102                                             <NA>                     OCSP
## 103                                             <NA>                     OCSP
## 104                                             <NA>                     OCSP
## 105                                             <NA>                     OCSP
## 106                                             <NA>                     OCSP
## 107                                             <NA>                     OCSP
## 108                                             <NA>                     OCSP
## 109                                             <NA>                     OCSP
## 110                                             <NA>                     OCSP
## 111                                             <NA>                     OCSP
## 112                                             <NA>                      LPP
## 113                                             <NA>                      LPP
## 114                                             <NA>                     OCSP
## 115                                             <NA>                     OCSP
## 116                                             <NA>                     OCSP
## 117                                             <NA>                      LPP
## 118                                             <NA>                      LPP
## 119                                             <NA>                      LPP
## 120                                             <NA>                      LPP
## 121                                             <NA>                      LPP
## 122                                             <NA>                Direct VC
## 123                                             <NA>                Direct VC
## 124                                             <NA>                Direct VC
## 125                                             <NA>                Direct VC
## 126                                             <NA>                Direct VC
## 127                                             <NA>                Direct VC
## 128                                             <NA>                Direct VC
## 129                                             <NA>                Direct VC
## 130                                             <NA>                Direct VC
## 131                                             <NA>                Direct VC
## 132                                             <NA>                Direct VC
## 133                                             <NA>                Direct VC
## 134                                             <NA>                Direct VC
## 135                                             <NA>                Direct VC
## 136                                             <NA>                Direct VC
## 137                                             <NA>                Direct VC
## 138                                             <NA>                Direct VC
## 139                                             <NA>                Direct VC
## 140                                             <NA>                Direct VC
## 141                                             <NA>                Direct VC
## 142                                             <NA>                Direct VC
## 143                                             <NA>                Direct VC
## 144                                             <NA>                Direct VC
## 145                                             <NA>                Direct VC
## 146                                             <NA>                Direct VC
## 147                                             <NA>                Direct VC
## 148                                             <NA>                Direct VC
## 149                                             <NA>                Direct VC
## 150                                             <NA>                Direct VC
## 151                                             <NA>                Direct VC
## 152                                             <NA>                Direct VC
## 153                                             <NA>                      LPP
## 154                                             <NA>                Direct VC
## 155                                             <NA>                Direct VC
## 156                                             <NA>                Direct VC
## 157                                             <NA>                      LPP
## 158                                             <NA>                      LPP
## 159                                             <NA>                      LPP
## 160                                             <NA>                      LPP
## 161                                             <NA>                      LPP
## 162                                             <NA>                Direct VC
## 163                                             <NA>                      LPP
## 164                                             <NA>                Direct VC
## 165                                             <NA>                      LPP
## 166                                             <NA>                Direct VC
## 167                                             <NA>                      LPP
## 168                                             <NA>                      LPP
## 169                                             <NA>                     <NA>
## 170                                             <NA>                      LPP
## 171                                             <NA>                Direct VC
## 172                                             <NA>                      LPP
## 173                                             <NA>                      LPP
## 174                                             <NA>                Direct VC
## 175                                             <NA>                      LPP
## 176                                             <NA>                Direct VC
## 177                                             <NA>                     <NA>
## 178                                             <NA>                      LPP
## 179                                             <NA>                      LPP
## 180                                             <NA>                      LPP
## 181                                             <NA>                      LPP
## 182                                             <NA>                Direct VC
## 183                                             <NA>                      LPP
## 184                                             <NA>                      LPP
## 185                                             <NA>                      LPP
## 186                                             <NA>                     <NA>
## 187                                             <NA>                      LPP
## 188                                             <NA>                     <NA>
## 189                                             <NA>                     <NA>
## 190                                             <NA>                      LPP
## 191                                             <NA>                Direct VC
## 192                                             <NA>                      LPP
## 193                                             <NA>                     <NA>
## 194                                             <NA>                      LPP
## 195                                             <NA>                      LPP
## 196                                             <NA>                     <NA>
## 197                                             <NA>                      LPP
## 198                                             <NA>                      LPP
## 199                                             <NA>                      LPP
## 200                                             <NA>                      LPP
## 201                                             <NA>                      LPP
## 202                                             <NA>                     <NA>
## 203                                             <NA>                      LPP
## 204                                             <NA>                      LPP
## 205                                             <NA>                      LPP
## 206                                             <NA>                      LPP
## 207                                             <NA>                     <NA>
## 208                                             <NA>                      LPP
## 209                                             <NA>                      LPP
## 210                                             <NA>                      LPP
## 211                                             <NA>                Direct VC
## 212                                             <NA>                     <NA>
## 213                                             <NA>                      LPP
## 214                                             <NA>                Direct VC
## 215                Evergreen Cash Collateral Support                      CSP
## 216                                             <NA>                Direct VC
## 217                                             <NA>                Direct VC
## 218                                             <NA>                     <NA>
## 219                                             <NA> Pre-Seed Venture Capital
##                                Program/Fund Name
## 1                                           <NA>
## 2                         Loan Guarantee Program
## 3                         Loan Guarantee Program
## 4                          Pre-Seed or Seed Fund
## 5               Deep Tech Diversity Venture Fund
## 6                                           <NA>
## 7               Deep Tech Diversity Venture Fund
## 8               Deep Tech Diversity Venture Fund
## 9                             Maine Venture Fund
## 10                                          <NA>
## 11                   NJEDA’s Angel Match Program
## 12                         Pre-Seed or Seed Fund
## 13                         Pre-Seed or Seed Fund
## 14                         Pre-Seed or Seed Fund
## 15                         Pre-Seed or Seed Fund
## 16                     Capital Project Loan Fund
## 17                                          <NA>
## 18                                          <NA>
## 19          PA-SSBCI Revolving Loan Fund Program
## 20          PA-SSBCI Revolving Loan Fund Program
## 21             PA-SSBCI Revoloving Loan Fund LPP
## 22               PA-SSBCI Equity Capital Program
## 23               PA-SSBCI Equity Capital Program
## 24               PA-SSBCI Equity Capital Program
## 25               PA-SSBCI Equity Capital Program
## 26               PA-SSBCI Equity Capital Program
## 27               PA-SSBCI Equity Capital Program
## 28               PA-SSBCI Equity Capital Program
## 29               PA-SSBCI Equity Capital Program
## 30                                          <NA>
## 31        SSBCI Venture Capital Program (Direct)
## 32        SSBCI Venture Capital Program (Direct)
## 33                        Equity Capital Program
## 34                        Equity Capital Program
## 35                            Social Impact Fund
## 36                                          <NA>
## 37                                     Seed Fund
## 38                                     Seed Fund
## 39                                     Seed Fund
## 40                            Social Impact Fund
## 41                                 Venture Funds
## 42                                          <NA>
## 43                                 Venture Funds
## 44                                 Venture Funds
## 45                                 Venture Funds
## 46                            Social Impact Fund
## 47                            Social Impact Fund
## 48                            Social Impact Fund
## 49           Social Impact Pre-Seed Builder Fund
## 50                                     Seed Fund
## 51                            Social Impact Fund
## 52                                 Venture Funds
## 53        SSBCI Venture Capital Program (Direct)
## 54        SSBCI Venture Capital Program (Direct)
## 55        SSBCI Venture Capital Program (Direct)
## 56                        Equity Capital Program
## 57                        Equity Capital Program
## 58                        Equity Capital Program
## 59        SSBCI Venture Capital Program (Direct)
## 60        SSBCI Venture Capital Program (Direct)
## 61        SSBCI Venture Capital Program (Direct)
## 62        SSBCI Venture Capital Program (Direct)
## 63                        Equity Capital Program
## 64        SSBCI Venture Capital Program (Direct)
## 65        SSBCI Venture Capital Program (Direct)
## 66                        Equity Capital Program
## 67                        Equity Capital Program
## 68        SSBCI Venture Capital Program (Direct)
## 69                        Equity Capital Program
## 70        SSBCI Venture Capital Program (Direct)
## 71                        Equity Capital Program
## 72        SSBCI Venture Capital Program (Direct)
## 73                        Equity Capital Program
## 74                        Subordinated Debt Fund
## 75  West Virginia Capital Access Program (WVCAP)
## 76          West Virginia Capital Access Program
## 77                                          <NA>
## 78                                          <NA>
## 79      Innovation Acceleration Launch Fund Loan
## 80   Innovation Acceleration Expansion Fund Loan
## 81      Innovation Acceleration Launch Fund Loan
## 82                       Demonstration Loan Fund
## 83                       Demonstration Loan Fund
## 84                       Demonstration Loan Fund
## 85            Proof of Commerical Relevance Loan
## 86   Innovation Acceleration Expansion Fund Loan
## 87   Innovation Acceleration Expansion Fund Loan
## 88   Innovation Acceleration Expansion Fund Loan
## 89      Innovation Acceleration Launch Fund Loan
## 90                       Demonstration Loan Fund
## 91                       Demonstration Loan Fund
## 92                       Demonstration Loan Fund
## 93                       Demonstration Loan Fund
## 94           Innovation Acceleration Propel Loan
## 95        Innovation Acceleration Expansion Fund
## 96   Innovation Acceleration Expansion Fund Loan
## 97            Proof of Commerical Relevance Loan
## 98      Innovation Acceleration Launch Fund Loan
## 99   Innovation Acceleration Expansion Fund Loan
## 100        Automation Loan Participation Program
## 101                             Growth Loan Fund
## 102                             Growth Loan Fund
## 103                             Growth Loan Fund
## 104                             Growth Loan Fund
## 105                             Growth Loan Fund
## 106                             Growth Loan Fund
## 107                             Growth Loan Fund
## 108                             Growth Loan Fund
## 109                             Growth Loan Fund
## 110                             Growth Loan Fund
## 111                             Growth Loan Fund
## 112        Automation Loan Participation Program
## 113        Automation Loan Participation Program
## 114                             Growth Loan Fund
## 115                             Growth Loan Fund
## 116                             Growth Loan Fund
## 117        Automation Loan Participation Program
## 118        Automation Loan Participation Program
## 119        Automation Loan Participation Program
## 120        Automation Loan Participation Program
## 121                           South Dakota Works
## 122                          Angel Match Program
## 123                          Angel Match Program
## 124                          Angel Match Program
## 125                          Angel Match Program
## 126                          Angel Match Program
## 127                                  Wonder Fund
## 128                          Angel Match Program
## 129                          Angel Match Program
## 130                          Angel Match Program
## 131                                  Wonder Fund
## 132                          Angel Match Program
## 133                          Angel Match Program
## 134                                    IDEA Fund
## 135                                    IDEA Fund
## 136                                    IDEA Fund
## 137                                    IDEA Fund
## 138                                    IDEA Fund
## 139                                    IDEA Fund
## 140                                    IDEA Fund
## 141                                    IDEA Fund
## 142                                    IDEA Fund
## 143                                    IDEA Fund
## 144                                    IDEA Fund
## 145                                    IDEA Fund
## 146                                    IDEA Fund
## 147                                    IDEA Fund
## 148                                    IDEA Fund
## 149         GROWKS Angel Capital Support Program
## 150                                    IDEA Fund
## 151                                    IDEA Fund
## 152                                    IDEA Fund
## 153                             GROWKS Loan Fund
## 154                                    IDEA Fund
## 155                                    IDEA Fund
## 156                                    IDEA Fund
## 157                             GROWKS Loan Fund
## 158                             GROWKS Loan Fund
## 159                             GROWKS Loan Fund
## 160                             GROWKS Loan Fund
## 161                             GROWKS Loan Fund
## 162         GROWKS Angel Capital Support Program
## 163                             GROWKS Loan Fund
## 164         GROWKS Angel Capital Support Program
## 165                             GROWKS Loan Fund
## 166         GROWKS Angel Capital Support Program
## 167                             GROWKS Loan Fund
## 168                             GROWKS Loan Fund
## 169                                         <NA>
## 170                             GROWKS Loan Fund
## 171         GROWKS Angel Capital Support Program
## 172                             GROWKS Loan Fund
## 173                             GROWKS Loan Fund
## 174         GROWKS Angel Capital Support Program
## 175                             GROWKS Loan Fund
## 176                                    IDEA Fund
## 177                             GROWKS Loan Fund
## 178                             GROWKS Loan Fund
## 179                             GROWKS Loan Fund
## 180                             GROWKS Loan Fund
## 181                             GROWKS Loan Fund
## 182         GROWKS Angel Capital Support Program
## 183                             GROWKS Loan Fund
## 184                             GROWKS Loan Fund
## 185                             GROWKS Loan Fund
## 186                             GROWKS Loan Fund
## 187                             GROWKS Loan Fund
## 188                                         <NA>
## 189                             GROWKS Loan Fund
## 190                             GROWKS Loan Fund
## 191         GROWKS Angel Capital Support Program
## 192                             GROWKS Loan Fund
## 193                             GROWKS Loan Fund
## 194                             GROWKS Loan Fund
## 195                             GROWKS Loan Fund
## 196                                         <NA>
## 197                             GROWKS Loan Fund
## 198                             GROWKS Loan Fund
## 199                             GROWKS Loan Fund
## 200                             GROWKS Loan Fund
## 201                             GROWKS Loan Fund
## 202                             GROWKS Loan Fund
## 203                             GROWKS Loan Fund
## 204                             GROWKS Loan Fund
## 205                             GROWKS Loan Fund
## 206                             GROWKS Loan Fund
## 207                             GROWKS Loan Fund
## 208                             GROWKS Loan Fund
## 209                             GROWKS Loan Fund
## 210                             GROWKS Loan Fund
## 211         GROWKS Angel Capital Support Program
## 212                             GROWKS Loan Fund
## 213                    Nebraska Growth Loan Fund
## 214                        Pre-Seed or Seed Fund
## 215                                     Cash CSP
## 216                 Wyoming Venture Capital Fund
## 217                 Wyoming Venture Capital Fund
## 218                                         <NA>
## 219                                       FundNV
##                                         Business Name        Sector
## 1                     Biosimilar Sciences & Ocyon Bio Manufacturing
## 2                                                <NA>   Main Street
## 3                                                <NA>   Main Street
## 4                                          Osteologic   High Growth
## 5                                             JetCool      Supplier
## 6                Advanced Veterinary Specialty Center   Main Street
## 7                                          Aeroshield      Supplier
## 8                                             Cyvl.ai   High Growth
## 9                                            TimberHP      Supplier
## 10                             Roundtrip EV Solutions          <NA>
## 11                         vipHomeLink Holdings, Inc.   High Growth
## 12  WATS (Waste Administration and Tracking Software)   High Growth
## 13                                          Neon Wild   High Growth
## 14                                            Upfront   High Growth
## 15                                           Ubiquitx   High Growth
## 16                        Chester Agricultural Center          <NA>
## 17                                      Café Des Amis   Main Street
## 18                            St. Paul Baptist Church   Main Street
## 19              Idea, LLC/Lonely Monk Coffee Roasting   Main Street
## 20                             Latino Connection, LLC   Main Street
## 21                                               <NA>   Main Street
## 22                                    MXTR Automation   High Growth
## 23                                 Spoke Sciences Inc   High Growth
## 24                                               UBMe   High Growth
## 25                                 Saladax Biomedical   High Growth
## 26                                   LifeAire Systems Manufacturing
## 27                                            Grovara      Supplier
## 28                                          PolicyMap   High Growth
## 29                              Hanimune Therapeutics   High Growth
## 30                                      Odds and Ends   Main Street
## 31                                       Electra.aero   High Growth
## 32            Green Tech Ventures, Inc. dba TrueAlgae   High Growth
## 33                                    Blue Vigil, LLC   High Growth
## 34                       Applied Impact Robotics Inc.   High Growth
## 35                                           NasaClip   High Growth
## 36                                       Medcura, Inc   High Growth
## 37                                   AGED Diagnostics   High Growth
## 38                                     Flexnode, Inc.   High Growth
## 39                                         N5 Sensors   High Growth
## 40                                            Givhero   High Growth
## 41                           Hememics Biotechnologies   High Growth
## 42                                    One Leg Up Pets   Main Street
## 43                          Longeviti Neuro Solutions   High Growth
## 44                                           KaloCyte   High Growth
## 45                                    Cerebro Capital   High Growth
## 46                                      JuneBrain Inc   High Growth
## 47                                 Equity Brain Trust   High Growth
## 48                                 Novel Microdevices   High Growth
## 49                                           CyDeploy   High Growth
## 50                                          Nanocrine   High Growth
## 51                                  Elite Gaming Live   High Growth
## 52                            Clene Nanomedicine Inc.   High Growth
## 53                                         Kinometrix   High Growth
## 54                           Sunny Day Fund Solutions   High Growth
## 55                                             8Myles   Main Street
## 56                            FourStay Inc. dba 4stay   High Growth
## 57                                 ElectroTempo, Inc.          <NA>
## 58                                Sedaro Corporation.   High Growth
## 59                                     Predict Health   High Growth
## 60                                            Wellthi   High Growth
## 61                                     AtWork Systems   High Growth
## 62                                          OpsCanvas   High Growth
## 63                                      NoBull Burger  Main Street?
## 64                                             Novela   Main Street
## 65                                           Luminoah   High Growth
## 66                        Owl Peak Technologies, Inc.   High Growth
## 67                                  ThinkGenetic, Inc   High Growth
## 68                                     Liquet Medical   High Growth
## 69                             Trubit, Inc. dba Joltz   High Growth
## 70                                           BrainBox   High Growth
## 71                                     MedPhlow, LLC.   High Growth
## 72                                Babylon Micro-Farms   Main Street
## 73                                      Warehowz Inc.   High Growth
## 74                                               <NA>   Main Street
## 75            Blankenship Real Estate Properties, LLC   Main Street
## 76                               RealX Ventures, Inc.   High Growth
## 77                                     Miracles in Me   Main Street
## 78                                   Extrunet America          <NA>
## 79                                       Distynct Inc          <NA>
## 80                                       Nebullam Inc   Main Street
## 81                                 Haber Technologies          <NA>
## 82                                              AxisU   High Growth
## 83                                Enceinte Health Inc   High Growth
## 84                                           Bristola   High Growth
## 85                                           MetaFuel   High Growth
## 86                             Mach Acquisition, Inc.   High Growth
## 87                                        Pitchly inc   High Growth
## 88                                       Hummingbirds   High Growth
## 89                                         ClinicNote   High Growth
## 90                             Above Par Tech of Iowa   High Growth
## 91                          Kinetic Technologies Inc.      Supplier
## 92                                   Classroom Clinic   High Growth
## 93                                  Shaka Culture Inc   High Growth
## 94                                          InteliSee   High Growth
## 95                                   VIDA Diagnostics   High Growth
## 96                              SmartScripts Holdings   High Growth
## 97                                     Cavergence Inc   High Growth
## 98                                          SwineTech          <NA>
## 99                                       Continuum Ag          <NA>
## 100                          Food Service Specialties Manufacturing
## 101                           Nucleic Sensing Systems   High Growth
## 102                   Martell Diagnostic Laboratories   High Growth
## 103                                    Morari Medical   High Growth
## 104                    Neuraworx Medical Technologies   High Growth
## 105                                       ProcessBolt   High Growth
## 106                                      Raise a Hood   High Growth
## 107                                   SAB Co Software   High Growth
## 108                               Renew Power Systems          <NA>
## 109                                            NETZRO Manufacturing
## 110                                             DOCSI   High Growth
## 111                                              ZeSa   Main Street
## 112                                       Fit Butters   Main Street
## 113                              The Amazing Chickpea   Main Street
## 114                                        Eva Medtec   High Growth
## 115                              BioMagnetic Sciences   High Growth
## 116                                       Nanodropper Manufacturing
## 117                        Steuart Contract Packaging      Supplier
## 118                           AmeriStar Manufacturing Manufacturing
## 119                                        TigerTough Manufacturing
## 120               Industrial Finishing Services, Inc.      Supplier
## 121                          Engineered Truss Systems      Supplier
## 122                                    TheraTec, Inc.   High Growth
## 123          Homekeepr (Preferred Partners Community)   High Growth
## 124              Project Phoenix Technoligies (Devii)   High Growth
## 125                                          WalkWise   High Growth
## 126                                            FarmQA          <NA>
## 127                                         LandTrust          <NA>
## 128                                   BWR Innovations Manufacturing
## 129                                    Fenworks, Inc.   High Growth
## 130                                          Tailorie   High Growth
## 131                                            Thread   High Growth
## 132                                          Learnery   High Growth
## 133                                  Wheelhouse Games          <NA>
## 134                                          Advocado   High Growth
## 135                                           CapyBio   High Growth
## 136                                           Amptify   High Growth
## 137                                  Echelon Med Tech   High Growth
## 138                                     Readout, Inc.   High Growth
## 139                               NuPeak Therapeutics   High Growth
## 140                              Aegis Digital Health   High Growth
## 141                                Caeli Vascular Inc   High Growth
## 142                                          RevivBio   High Growth
## 143                                  Rezilient Health   High Growth
## 144                                   Whistle Systems   High Growth
## 145                               Edison Agrosciences   High Growth
## 146                                Solis Agrosciences   High Growth
## 147                       Navigate Oncology Solutions   High Growth
## 148                                          InUnison   High Growth
## 149                              Celerity Enterprises   High Growth
## 150                                       SaRA Health   High Growth
## 151                              Serviam Care Network   High Growth
## 152                                   Marma Nutrition   High Growth
## 153                                       Collar Club   Main Street
## 154                                            Sailes   High Growth
## 155                                           Healium   High Growth
## 156                                          Allumin8   High Growth
## 157                        Carrigan Lumber Company II      Supplier
## 158                              Rodrock Chiropractic   Main Street
## 159                                    Axiom Partners   Main Street
## 160                                A&M Powder Coating      Supplier
## 161                Foundations Commercial Real Estate          <NA>
## 162   Ad Astra Integrity Measurement Systems (Invary)   High Growth
## 163                              Sound Speech Therapy   Main Street
## 164                               Elias Animal Health   High Growth
## 165                    Shine Institute of Cosmetology   Main Street
## 166                    WorkTorch (formerly QuickHire)   High Growth
## 167                                 Love Lifesciences   High Growth
## 168                                      Story Salons   Main Street
## 169                                    Grad Cap Remix   Main Street
## 170             Gurkirpa Real Estate Investment Group   Main Street
## 171                                     DataAppraisal   High Growth
## 172                                  SnapIT Solutions   High Growth
## 173                           Arrow Foundation Repair   Main Street
## 174                                      Transportant   High Growth
## 175                           SMS Veterinary Partners   Main Street
## 176                                  Bryght Labs, Inc   High Growth
## 177                            The Heritage Home, LLC   Main Street
## 178                                   Vector Electric          <NA>
## 179                 Honor Screenprinting & Embroidery      Supplier
## 180                                  Parkside Station   Main Street
## 181                       Razer Precision Instruments          <NA>
## 182                                          GovBuilt   High Growth
## 183                                     Old Danger II          <NA>
## 184                          Norseman Brewing Company   Main Street
## 185                         Sommerset Cafe & Catering   Main Street
## 186                              High Plains Wellness   Main Street
## 187                                Schomaker Holdings          <NA>
## 188                            SoHome Kids Foundation   Main Street
## 189            Lucky Dogs Boarding Daycare & Grooming   Main Street
## 190                                  Poise Aesthetics   Main Street
## 191                                  West Restaurants   Main Street
## 192                                         Minks LLC   Main Street
## 193                        Utopia Modern Salon Suites   Main Street
## 194                                    Wichita Bakery   Main Street
## 195                                     Kings Truckin          <NA>
## 196                                Pho Superman To Go   Main Street
## 197                                     Rios Ventures          <NA>
## 198                     Joshua B. Girard Chiropractic   Main Street
## 199                       Sturgeon's Tire & Alignment   Main Street
## 200                               West 5th Pet Resort   Main Street
## 201                                Thomas Tea Company   Main Street
## 202                                     Snodgrass Hay   Main Street
## 203                             Iron Therapy Training   Main Street
## 204                                 Cielo (Las Hefas)          <NA>
## 205                             JDR Painting Services   Main Street
## 206                                Mikkelson's Tavern   Main Street
## 207                                           Kingdom   Main Street
## 208                              Martinek Metal Works Manufacturing
## 209                                  Chihuas Trucking          <NA>
## 210                                  Red Beard Coffee   Main Street
## 211                                   Sedona Trucking          <NA>
## 212               Walk Transport dba Thumper Hardware   Main Street
## 213                                         RealmFive          <NA>
## 214                                          Highnote   High Growth
## 215                                 Fading West Homes Manufacturing
## 216                                      Language I/O   High Growth
## 217                        Frontline Wildfire Defense   High Growth
## 218                                       SurgiStream   High Growth
## 219                                           Lucihub   High Growth
##                                                    Industry  NAICS
## 1                                     Biotech manufacturing     NA
## 2                                  Fishing Supply Operation     NA
## 3                                                Restaurant     NA
## 4                                                PharmaTech     NA
## 5   Advanced Materials for Industry - computer chip cooling     NA
## 6                                         Animal Healthcare     NA
## 7                              Advanced Materials - Windows     NA
## 8                                  AI for civil engineering     NA
## 9                                  Wood fiber manufacturing     NA
## 10                                    EV & Waste Management     NA
## 11                                 Smart Home Tech Industry     NA
## 12              Software - waste carbon footprint reduction     NA
## 13                       AI - family entertainment platform     NA
## 14                                    SaaS - childcare data     NA
## 15                                             AI - BioTech     NA
## 16                                     Ag - farmland lender     NA
## 17                                               Restaurant     NA
## 18                                                   Church     NA
## 19                                        Coffee/Bagel Shop     NA
## 20                                              Real Estate     NA
## 21                                               Restaurant     NA
## 22                                       Marketing software     NA
## 23                                               PharmaTech     NA
## 24                           Experience management platform     NA
## 25                                    BioTech manufacturing     NA
## 26                           Air purification manufacturing     NA
## 27                                    B2B food/bev platform     NA
## 28                                                 Software     NA
## 29                              Biotech - allergy therapies     NA
## 30                           Commerical janitorial services     NA
## 31                                          eSTOL Aerospace     NA
## 32                                                   AgTech     NA
## 33                                      Construction/Drones     NA
## 34                                               EnergyTech     NA
## 35                            MedTech - nosebleed treatment     NA
## 36                                 BioTech - surgery device     NA
## 37                                                  BioTech     NA
## 38                                  Digitial Infrastructure     NA
## 39             Sensor manufacturing - ecological monitoring     NA
## 40                                            Software - HR     NA
## 41                                                  BioTech     NA
## 42                                                 Pet Care     NA
## 43                           MedTech - neurosurgery devices     NA
## 44                      BioTech - artificial red blood cell     NA
## 45                            FinTech - lending marketplace     NA
## 46                                Remote patient monitoring     NA
## 47                                                 DEI Tech     NA
## 48                                           Medical device     NA
## 49                                Business Security Systems     NA
## 50                                                  BioTech     NA
## 51                                                   EdTech     NA
## 52                    Biopharma - Neurodegenerative Disease     NA
## 53                             MedTech/AI - fall prevention     NA
## 54                        Employee benefit/savings platform     NA
## 55                                   B2C subscription meals     NA
## 56                                                   EdTech     NA
## 57                                  SaaS TransportationTech     NA
## 58                              Engineering Software & Tech     NA
## 59              HealthTech - healthcare navigation platform     NA
## 60                                  FinTech - mobile baking     NA
## 61                              Government Contracting SaaS     NA
## 62                            Software deployment interface     NA
## 63                                        FoodTech Industry     NA
## 64                               Wedding vendor marketplace     NA
## 65                           MedTech - nutrition monitoring     NA
## 66                                                  MedTech     NA
## 67                                     Healthcare tech / AI     NA
## 68                         HealthTech - blood clot catheter     NA
## 69                                       FinTech/E-Commerce     NA
## 70                                   MedTech - AI diagnoses     NA
## 71                                           HealthcareTech     NA
## 72                                            Gardening app     NA
## 73                                            LogisticsTech     NA
## 74                             Food distributor & processor     NA
## 75                                              Real Estate     NA
## 76                                           Solar Industry     NA
## 77                                        Child Care Center     NA
## 78                                    Machinery and tooling     NA
## 79                               AgTech - livestock systems     NA
## 80                                 B2C subscription produce     NA
## 81                     AgTech - grain management automation 115116
## 82                       Software - job matching & training     NA
## 83                          HealthTech - healthcare monitor     NA
## 84                 Renewable Energy Tech and Liquid Storage     NA
## 85                 Software - transportation tax management     NA
## 86                     Vehicle Automation Software/Hardware     NA
## 87                                                     SaaS     NA
## 88                                                     SaaS     NA
## 89                               Clinic Management Software     NA
## 90                                    Tech - turf spray GPS     NA
## 91                                           Welding Robots     NA
## 92               HealthTech - school mental health platform     NA
## 93                         Software - work culture programs  51518
## 94                                AI for Surveillance Video     NA
## 95                          MedTech - Lung therapy services     NA
## 96                                      Pharmaceutical Data     NA
## 97               Software - construction project management     NA
## 98                                        AgTech - software     NA
## 99                     AgTech - Soil Health/Regenerative Ag     NA
## 100                                         Food production     NA
## 101                         BioTech - ecological monitoring     NA
## 102                            MedTech - cancer blood tests     NA
## 103                                      MedTech - wearable     NA
## 104                                                 MedTech     NA
## 105                                Software - cybersecurity     NA
## 106                           AI - vehicle maintence system     NA
## 107                            Software - company insurance     NA
## 108                            Electricity tech - inverters     NA
## 109                           Food upcycling equipment/tech     NA
## 110                        Software - healthcare management     NA
## 111                                         Fitness program     NA
## 112                                                    Food     NA
## 113                                                    Food     NA
## 114                                                 MedTech     NA
## 115                            Medical device manufacturing     NA
## 116                            Medical device manufacturing     NA
## 117                                    Supplement packaging     NA
## 118                         Metal fabrication manufacturing     NA
## 119                                Seat Cover Manufacturing     NA
## 120                            Industrial coating/finishing     NA
## 121                     Construction/Building Manufacturing     NA
## 122                                  HealthTech - Wearables     NA
## 123                                  Online moving services     NA
## 124                                       Software - coding     NA
## 125                 MedTech - remote monitoring for walkers     NA
## 126                                                  AgTech     NA
## 127                    Land sharing marketplace for hunting     NA
## 128                     Manufacturing - hydrogen generators     NA
## 129                                   EdTech - Drone Racing     NA
## 130                                      Marketing software     NA
## 131                   Software - robotics inspection system     NA
## 132                             Workplace training software     NA
## 133                                 Application Development     NA
## 134                                                  AdTech     NA
## 135                                                 BioTech     NA
## 136                                                 MedTech     NA
## 137                                                 MedTech     NA
## 138                                              HealthTech     NA
## 139                                               BioPharma     NA
## 140                                                 MedTech     NA
## 141                                                 MedTech     NA
## 142                                                 BioTech     NA
## 143                                                 MedTech     NA
## 144                               Workforce Management Tech     NA
## 145                                          AgTech/BioTech     NA
## 146                                                  AgTech     NA
## 147                                                 MedTech     NA
## 148                                  Social Networking/Tech     NA
## 149                                 SaaS financial platform     NA
## 150                                              HealthTech     NA
## 151                                              HealthTech     NA
## 152                                                 MedTech     NA
## 153                                                Pet care     NA
## 154                                    Sales/Marketing Tech     NA
## 155                                HealthTech/DigitalHealth     NA
## 156                                                 MedTech     NA
## 157                         Lumber & construction materials     NA
## 158                                            Chiropractor     NA
## 159             Legal & law enforcement consulting services     NA
## 160                                         Vehicle coating     NA
## 161                                  Commerical real estate     NA
## 162                            Academic planning programing     NA
## 163                                              Healthcare     NA
## 164                                      Med/BioTech - pets     NA
## 165                                      Cosmetology school     NA
## 166                                                 SaaS HR     NA
## 167                              MedTech - injection device 541714
## 168                                                   Salon     NA
## 169                                Apparel - Graduation Cap     NA
## 170                              Restaurant - A&W franchise     NA
## 171                    AI appraisal software for healthcare     NA
## 172                            Tech training & IT solutions     NA
## 173                              Building foundation repair     NA
## 174                           School bus information system     NA
## 175                                            Veterinarian     NA
## 176                     Consumer Electronics / Software Dev     NA
## 177                                           Senior Living     NA
## 178                Electric system maintance & construction     NA
## 179                    Commerical & consumer screenprinting     NA
## 180                                              Restaurant     NA
## 181                                                    <NA>     NA
## 182                                                 GovTech     NA
## 183                                                    <NA>     NA
## 184                                                 Brewery     NA
## 185                                              Restaurant     NA
## 186                                         Wellness Center     NA
## 187                                                    <NA>     NA
## 188                                  Foster care facilities     NA
## 189                                                Pet care     NA
## 190                                            Aesthetician     NA
## 191                                              Restaurant     NA
## 192                                            Beauty salon     NA
## 193                                                   Salon     NA
## 194                                                  Bakery     NA
## 195                                                Trucking     NA
## 196                                              Restaurant     NA
## 197                                                    <NA>     NA
## 198                                            Chiropractor     NA
## 199                                           Auto mechanic     NA
## 200                                                Pet Care     NA
## 201                                     Beverage storefront     NA
## 202                                             Agriculture     NA
## 203                                         Fitness program     NA
## 204                                                    <NA>     NA
## 205                           Residential painting services     NA
## 206                                              Restaurant     NA
## 207                                                    <NA>     NA
## 208                                       Metal fabrication     NA
## 209                                                Trucking     NA
## 210                                             Coffee shop 722515
## 211                                                Trucking     NA
## 212                                          Hardware Store     NA
## 213                                                  AgTech     NA
## 214                             Software - audio production     NA
## 215                              Modular home manufacturing     NA
## 216        Software - customer service language translation     NA
## 217                                        Wildfire Defense     NA
## 218                                    MedTech - scheduling     NA
## 219                               Video Production and Tech     NA
##                  Macro Trends?  SEDI?
## 1                         <NA>    Yes
## 2                         <NA>   <NA>
## 3                         <NA>   <NA>
## 4                         <NA>   <NA>
## 5   Semiconductor supply chain     No
## 6                         <NA>   <NA>
## 7                         <NA>    Yes
## 8                         <NA>    Yes
## 9         Climate/Green Energy No; OZ
## 10                        <NA>   <NA>
## 11                        <NA>   <NA>
## 12        Climate/Green Energy    Yes
## 13                        <NA>     No
## 14                        <NA>    Yes
## 15                        <NA>    Yes
## 16        Climate/Green Energy    Yes
## 17                        <NA>    Yes
## 18                        <NA>    Yes
## 19                        <NA>   <NA>
## 20                        <NA>    Yes
## 21                        <NA>   <NA>
## 22                        <NA>     No
## 23                        <NA>     No
## 24                        <NA>    Yes
## 25                        <NA> No; OZ
## 26                        <NA>    Yes
## 27                        <NA>    Yes
## 28                        <NA>    Yes
## 29                        <NA>    Yes
## 30                        <NA>    Yes
## 31                        <NA>     No
## 32                        <NA>     No
## 33                        <NA>     No
## 34                        <NA>     No
## 35                        <NA>    Yes
## 36                        <NA>     No
## 37                        <NA>     No
## 38                        <NA>     No
## 39        Climate/Green Energy    Yes
## 40                        <NA>    Yes
## 41                        <NA>   <NA>
## 42                        <NA>    Yes
## 43                        <NA>     No
## 44                        <NA>    Yes
## 45                        <NA>     No
## 46                        <NA>    Yes
## 47                        <NA>    Yes
## 48                        <NA>    Yes
## 49                        <NA>    Yes
## 50                        <NA>   <NA>
## 51                        <NA>    Yes
## 52                        <NA> No; OZ
## 53                        <NA>    Yes
## 54                        <NA>    Yes
## 55                        <NA>    Yes
## 56                        <NA>   <NA>
## 57                        <NA>    Yes
## 58                        <NA>   <NA>
## 59                        <NA>    Yes
## 60                        <NA>    Yes
## 61                        <NA>    Yes
## 62                        <NA>     No
## 63                        <NA>    Yes
## 64                        <NA>     No
## 65                        <NA>     No
## 66                        <NA>   <NA>
## 67                        <NA>     No
## 68                        <NA>     No
## 69                        <NA>   <NA>
## 70                        <NA>    Yes
## 71                        <NA>   <NA>
## 72                        <NA>     No
## 73                        <NA>   <NA>
## 74                        <NA>   <NA>
## 75                        <NA>     No
## 76                        <NA>   <NA>
## 77                        <NA>   <NA>
## 78                        <NA>   <NA>
## 79                        <NA>     No
## 80                        <NA>     No
## 81                        <NA>     No
## 82                        <NA>     No
## 83                        <NA>     No
## 84        Climate/Green Energy     No
## 85                        <NA>     No
## 86                        <NA>     No
## 87                        <NA>     No
## 88                        <NA>     No
## 89                        <NA>     No
## 90                        <NA>     No
## 91                        <NA>   <NA>
## 92                        <NA>    Yes
## 93                        <NA>    Yes
## 94                        <NA> No; OZ
## 95                        <NA>    Yes
## 96                        <NA>     No
## 97                        <NA>   <NA>
## 98                        <NA>     No
## 99                        <NA>     No
## 100                       <NA> No; OZ
## 101       Climate/Green Energy     No
## 102                       <NA>     No
## 103                       <NA>     No
## 104                       <NA>     No
## 105                       <NA>     No
## 106                       <NA>     No
## 107                       <NA>   <NA>
## 108       Climate/Green Energy     No
## 109       Climate/Green Energy    Yes
## 110                       <NA>     No
## 111                       <NA>    Yes
## 112                       <NA>    Yes
## 113                       <NA>    Yes
## 114                       <NA>    Yes
## 115                       <NA>     No
## 116                       <NA>    Yes
## 117                       <NA>     No
## 118                       <NA>     OZ
## 119                       <NA>   <NA>
## 120                       <NA>     No
## 121                       <NA>     No
## 122                       <NA>     No
## 123                       <NA>   <NA>
## 124                       <NA>     No
## 125                       <NA>     No
## 126                       <NA>   <NA>
## 127                       <NA>     No
## 128       Climate/Green Energy     No
## 129                       <NA>     No
## 130                       <NA>    Yes
## 131                       <NA>     No
## 132                       <NA>    Yes
## 133                       <NA>     No
## 134                       <NA>   <NA>
## 135                       <NA>    Yes
## 136                       <NA>     No
## 137                       <NA>     No
## 138                       <NA>     No
## 139                       <NA>     No
## 140                       <NA>     No
## 141                       <NA>     No
## 142                       <NA>    Yes
## 143                       <NA>    Yes
## 144                       <NA>     No
## 145                       <NA>     No
## 146                       <NA>    Yes
## 147                       <NA>   <NA>
## 148                       <NA>   <NA>
## 149                       <NA>    Yes
## 150                       <NA>    Yes
## 151                       <NA>     No
## 152                       <NA>    Yes
## 153                       <NA>     No
## 154                       <NA>    Yes
## 155                       <NA>    Yes
## 156                       <NA>    Yes
## 157                       <NA>     No
## 158                       <NA>   <NA>
## 159                       <NA>     No
## 160                       <NA>   <NA>
## 161                       <NA>    Yes
## 162                       <NA>    Yes
## 163                       <NA>    Yes
## 164                       <NA>     No
## 165                       <NA>    Yes
## 166                       <NA>    Yes
## 167                       <NA>     No
## 168                       <NA>   <NA>
## 169                       <NA>    Yes
## 170                       <NA>   <NA>
## 171                       <NA>    Yes
## 172                       <NA>    Yes
## 173                       <NA>    Yes
## 174                       <NA>     No
## 175                       <NA>   <NA>
## 176                       <NA>     No
## 177                       <NA>   <NA>
## 178                       <NA>     No
## 179                       <NA>   <NA>
## 180                       <NA>   <NA>
## 181                       <NA>   <NA>
## 182                       <NA>     No
## 183                       <NA>   <NA>
## 184                       <NA>   <NA>
## 185                       <NA>   <NA>
## 186                       <NA>   <NA>
## 187                       <NA>   <NA>
## 188                       <NA>     No
## 189                       <NA>   <NA>
## 190                       <NA>    Yes
## 191                       <NA>   <NA>
## 192                       <NA>    Yes
## 193                       <NA>   <NA>
## 194                       <NA>   <NA>
## 195                       <NA>   <NA>
## 196                       <NA>   <NA>
## 197                       <NA>   <NA>
## 198                       <NA>   <NA>
## 199                       <NA>   <NA>
## 200                       <NA>   <NA>
## 201                       <NA>    Yes
## 202                       <NA>   <NA>
## 203                       <NA>    Yes
## 204                       <NA>   <NA>
## 205                       <NA>     No
## 206                       <NA>    Yes
## 207                       <NA>   <NA>
## 208                       <NA>   <NA>
## 209                       <NA>   <NA>
## 210                       <NA>     No
## 211                       <NA>    Yes
## 212                       <NA>   <NA>
## 213                       <NA>     No
## 214                       <NA>    Yes
## 215                       <NA>    Yes
## 216                       <NA>    Yes
## 217                       <NA>   <NA>
## 218                       <NA>     No
## 219                       <NA>   <NA>
##                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Link
## 1                                                                                                                                                                                                                                                                                                                                                                                                                     https://newsismybusiness.com/bde-provides-3-8m-in-financing-to-biosimilar-ocyonbio-for-expansion/
## 2                                                                                                                                                                                                                                                                                                                                                                                       https://viconsortium.com/vi-business/virgin-islands-eda-facilitates-over--900k-in-loans-for-st--croix-and-st--thomas-businesses
## 3                                                                                                                                                                                                                                                                                                                                                                                       https://viconsortium.com/vi-business/virgin-islands-eda-facilitates-over--900k-in-loans-for-st--croix-and-st--thomas-businesses
## 4                                                                                                                                                                                                                                                                                                                                                                       https://esd.ny.gov/esd-media-center/press-releases/esd-announces-first-series-investments-from-ny-ssbci-pre-seed-and-seed-matching-fund-program
## 5                                                                                                                                                                                                                                                                                                                                                                                                                                 https://www.mass-ventures.com/massventures-closes-three-deals-with-deep-tech-startups
## 6                                                                                                                                                                                                                                                                                                                                                                                                                                        https://nerej.com/acella-construction-corp-breaks-ground-on-17-700-s-f-project
## 7                                                                                                                                                                                                                                                                                                                                                                                                                                 https://www.mass-ventures.com/massventures-closes-three-deals-with-deep-tech-startups
## 8                                                                                                                                                                                                                                                                                                                                                                                                                                 https://www.mass-ventures.com/massventures-closes-three-deals-with-deep-tech-startups
## 9                                                                                                                                                                                                                                                                                                                                                                                                           https://www.prnewswire.com/news-releases/maine-venture-fund-announces-investment-in-timberhp-301844030.html
## 10                                                                                                                                                                                                                                                                                                                                                                                                                                                                 https://home.treasury.gov/news/press-releases/jy2096
## 11                                                                                                                                                                                                                                                                                                                                                                                                      https://tech.einnews.com/pr_news/663695142/viphomelink-announces-completion-of-successful-capital-raising-round
## 12                                                                                                                                                                                                                                                                                                                                                                      https://esd.ny.gov/esd-media-center/press-releases/esd-announces-first-series-investments-from-ny-ssbci-pre-seed-and-seed-matching-fund-program
## 13                                                                                                                                                                                                                                                                                                                                                                      https://esd.ny.gov/esd-media-center/press-releases/esd-announces-first-series-investments-from-ny-ssbci-pre-seed-and-seed-matching-fund-program
## 14                                                                                                                                                                                                                                                                                                                                                                      https://esd.ny.gov/esd-media-center/press-releases/esd-announces-first-series-investments-from-ny-ssbci-pre-seed-and-seed-matching-fund-program
## 15                                                                                                                                                                                                                                                                                                                                                                      https://esd.ny.gov/esd-media-center/press-releases/esd-announces-first-series-investments-from-ny-ssbci-pre-seed-and-seed-matching-fund-program
## 16                                                                                                                                                                                                                                                                                                                               https://esd.ny.gov/esd-media-center/press-releases/esd-announces-more-than-1-3-million-assistance-chester-agricultural-center-historic-new-york-state-small-business-credit-initiative
## 17                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 18                                                                                                                                                                                                                                                                                                                                             https://www.linkedin.com/posts/bridgeway-capital_we-are-proud-to-have-closed-a-loan-with-st-activity-7045121357197537280-pYvX?utm_source=share&utm_medium=member_desktop
## 19                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.cpbj.com/local-businesses-gain-credc-financing/
## 20                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.cpbj.com/local-businesses-gain-credc-financing/
## 21                                                                                                                                                                                                                                                                                                                                                                                                                                                            https://home.treasury.gov/system/files/136/CDFI-SSBCI.pdf
## 22                                                                                                                                                                                                                                                                                                                                                                                                               https://www.readingeagle.com/2023/07/29/berks-company-receives-investment-from-ben-franklin-northeast/
## 23                                                                                                                                                                                                                                                                                                                                                                                                                    https://nep.benfranklin.org/ben-franklin-northeast-to-invest-1-1-million-in-the-regional-economy/
## 24                                                                                                                                                                                                                                                                                                                                                                                                                                                         https://lvb.com/ben-franklin-announces-latest-investments-2/
## 25                                                                                                                                                                                                                                                                                                                                                                                                                        https://nep.benfranklin.org/ben-franklin-northeast-to-invest-925000-in-11-regional-companies/
## 26                                                                                                                                                                                                                                                                                                                                                                                                                    https://nep.benfranklin.org/ben-franklin-northeast-to-invest-1-1-million-in-the-regional-economy/
## 27                                                                                                                                                                                                                                                                                                                                                                                                                        https://nep.benfranklin.org/ben-franklin-northeast-to-invest-925000-in-11-regional-companies/
## 28                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 29                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 30                                                                                                                                                                                                                                                                                                                                                                                                           https://www.readingeagle.com/2023/06/29/berks-woman-and-minority-owned-business-receives-50000-in-funding/
## 31                                                                                                                                                                                                                                                                                                                                                                        https://www.einnews.com/pr_news/637117678/vipc-s-virginia-venture-partners-invests-in-electra-to-provide-efficient-and-sustainable-air-travel
## 32                                                                                                                                                                                                                                                                                                                                                      https://www.einnews.com/pr_news/663890559/vipc-s-virginia-venture-partners-invests-in-truealgae-for-high-efficiency-environment-friendly-crop-nutrition-support
## 33                                                                                                                                                                                                                                                                                                                                                     https://tech.einnews.com/pr_news/657888590/vipc-s-virginia-venture-partners-invests-in-blue-vigil-for-autonomous-aerial-light-for-construction-and-public-safety
## 34                                                                                                                                                                                                                                                                                                                                                       https://www.einnews.com/pr_news/674649788/vipc-s-virginia-venture-partners-invests-in-applied-impact-robotics-for-transformative-robotic-inspection-technology
## 35                                                                                                                                                                                                                                                                                                                                                                                                                                       https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-nasaclip
## 36                                                                                                                                                                                                                                                                                                                                                                                                  https://www.prnewswire.com/news-releases/tedco-invests-first-of-marylands-ssbci-funds-in-medcura-inc-301620516.html
## 37                                                                                                                                                                                                                                                                                                                                                                                                                               https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-aged-diagnostics
## 38                                                                                                                                                                                                                                                                                                                                                                                                                                       https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-flexnode
## 39                                                                                                                                                                                                                                                                                                                                                                                                                  https://www.tedcomd.com/news-events/press-releases/2023/tedco-announces-ssbci-investment-n5-sensors
## 40                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.tedcomd.com/news-events/press-releases/2023/tedco-announces-ssbci-investment-givhero
## 41                                                                                                                                                                                                                                                                                                                                                                                                     https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-ssbci-funding-hememics-biotechnologies-inc
## 42                                                                                                                                                                                                                                                                                                                                                                                                                                                                 https://twitter.com/MDBiz/status/1636397297855770625
## 43                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.citybiz.co/article/433611/tedco-invests-ssbci-funds-in-longeviti-neuro-solutions/
## 44                                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.citybiz.co/article/441651/tedco-invests-ssbci-funding-into-kalocyte/
## 45                                                                                                                                                                                                                                                                                                                                                                                              https://www.prnewswire.com/news-releases/tedco-invests-1-million-of-ssbci-funds-into-cerebro-capital-inc-301879777.html
## 46                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://biobuzz.io/tedco-invests-ssbci-funds-in-junebrain/
## 47                                                                                                                                                                                                                                                                                                                                                                                                               https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-ssbci-funds-equity-brain-trust-0
## 48                                                                                                                                                                                                                                                                                                                                                                                                              https://www.tedcomd.com/news-events/press-releases/2023/tedco-announces-investment-novel-microdevices-0
## 49                                                                                                                                                                                                                                                                                                                                                                                                                                       https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-cydeploy
## 50                                                                                                                                                                                                                                                                                                                                                                                                                   https://www.tedcomd.com/news-events/press-releases/2023/tedco-announces-ssbci-investment-nanocrine
## 51                                                                                                                                                                                                                                                                                                                                                                                                                              https://www.tedcomd.com/news-events/press-releases/2023/tedco-invests-elite-gaming-live
## 52                                                                                                                                                                                                                                                                                                                                   https://news.maryland.gov/dhcd/2022/10/31/hogan-administration-announces-5-million-committed-to-biopharmaceutical-company-through-state-small-business-credit-initiative%EF%BF%BC/
## 53                                                                                                                                                                                                                                                                                                                                                      https://tech.einnews.com/pr_news/635177357/vipc-s-virginia-venture-partners-invests-in-kinometrix-to-provide-healthcare-workers-with-real-time-risk-assessments
## 54                                                                                                                                                                                                                                                                                                                       https://www.localsyr.com/business/press-releases/ein-presswire/630484957/vipcs-virginia-venture-partners-invests-in-sunny-day-fund-solutions-to-provide-a-workplace-emergency-savings-program/
## 55                                                                                                                                                                                                                                                                                                                                                                          https://www.einnews.com/pr_news/645502216/vipc-s-virginia-venture-partners-invests-in-8myles-to-expand-clean-frozen-foods-into-retail-space
## 56                                                                                                                                                                                                                                                                                                                                                             https://tech.einnews.com/pr_news/674347653/vipc-s-virginia-venture-partners-invests-in-4stay-to-help-connect-people-with-housing-near-their-destinations
## 57                                                                                                                                                                                                                                                                                                                                                        https://www.einnews.com/pr_news/681551321/vipc-s-virginia-venture-partners-invests-in-electrotempo-for-ev-charging-network-planning-and-intelligence-solution
## 58                                                                                                                                                                                                                                                                                                                                                     https://www.einnews.com/pr_news/669388288/vipc-s-virginia-venture-partners-invests-in-sedaro-to-scale-saas-platform-for-digital-twins-and-cloud-based-simulation
## 59                                                                                                                                                                                                                                                                                                                                                                 https://www.einnews.com/pr_news/645499426/vipc-s-virginia-venture-partners-invests-in-predict-health-to-help-humanize-healthcare-for-senior-citizens
## 60                                                                                                                                                                                                                                                                                                                                                                                              https://fintech.global/2023/05/30/wellthi-reels-in-significant-investment-to-reshape-social-finance-and-mobile-banking/
## 61                                                                                                                                                                                                                                                                                                                                                                         https://tech.einnews.com/pr_news/626132730/vipc-s-virginia-venture-partners-invests-in-atwork-systems-to-support-onelynk-sales-and-marketing
## 62                                                                                                                                                                                                                                                                                                                                                            https://www.einnews.com/pr_news/643363824/vipc-s-virginia-venture-partners-invests-in-opscanvas-to-support-a-transformation-in-cloud-software-deployments
## 63                                                                                                                                                                                                                                                                                                                                                                          https://kalkinemedia.com/uk/news/environment/vipcs-virginia-venture-partners-invests-in-nobull-burger-to-propel-market-growth-and-expansion
## 64                                                                                                                                                                                                                                                                                                                                            https://fox40.com/business/press-releases/ein-presswire/637141238/vipcs-virginia-venture-partners-invests-in-novela-to-simplify-the-wedding-planning-process-for-couples/
## 65                                                                                                                                                                                                                                                                                                                                                         https://www.einnews.com/pr_news/649922439/vipc-s-virginia-venture-partners-invests-in-luminoah-to-provide-the-first-ever-portable-data-driven-feeding-system
## 66                                                                                                                                                                                                                                                                                                                                                                https://www.einnews.com/pr_news/664086956/vipc-s-virginia-venture-partners-invests-in-owl-peak-technologies-for-early-stage-cancer-detection-solution
## 67                                                                                                                                                                                                                                                                                                                                                                           https://kalkinemedia.com/news/world-news/vipcs-virginia-venture-partners-invests-in-thinkgenetic-to-more-effectively-identify-rare-disease
## 68                                                                                                                                                                                                                                                                                                                                                https://www.einpresswire.com/article/643224041/vipc-s-virginia-venture-partners-invests-in-liquet-medical-to-support-the-transformation-of-vascular-disease-treatment
## 69                                                                                                                                                                                                                                                                                                                                                     https://www.einnews.com/pr_news/661397405/vipc-s-virginia-venture-partners-invests-in-joltz-to-support-bitcoin-as-loyalty-rewards-and-customer-acquisition-perks
## 70                                                                                                                                                                                                                                                                                                                                                  https://www.einpresswire.com/article/630472133/vipc-s-virginia-venture-partners-invests-in-brainbox-solutions-for-accurate-diagnosis-of-mild-traumatic-brain-injury
## 71                                                                                                                                                                                                                                                                                                                                                               https://www.einnews.com/pr_news/671703879/vipc-s-virginia-venture-partners-invests-in-medphlow-for-groundbreaking-essential-medicine-delivery-platform
## 72                                                                                                                                                                                                                                                                                                                                 https://www.kron4.com/business/press-releases/ein-presswire/635214327/vipcs-virginia-venture-partners-invests-in-babylon-micro-farms-to-make-sustainable-food-production-accessible/
## 73                                                                                                                                                                                                                                                                                                                                                                 https://www.einnews.com/pr_news/665889080/vipc-s-virginia-venture-partners-invests-in-warehowz-to-scale-innovative-on-demand-warehousing-marketplace
## 74                                                                                                                                                                                                                                                                                                                                                                                                                                                            https://home.treasury.gov/system/files/136/CDFI-SSBCI.pdf
## 75                                                                                                                                                                                                                                                                                                                                                                     https://www.cdfa.net/cdfa/cdfaweb.nsf/0/D1B2B172C7226D8288258A58004CD6EC/$file/WVJIT%20-%20Blankenship%20Real%20Estate%20Properties%2C%20LLC.pdf
## 76  https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cdfa.net%2Fcdfa%2Fcdfaweb.nsf%2F0%2FDF74F21BCFE58F8A88258A2700540A0C%2F%24file%2FWVJIT%2520Endolumik%2520Announcement.pdf&data=05%7C01%7Ccsd77%40drexel.edu%7C5f7505c29ff444debe5c08dbb39e2d0c%7C3664e6fa47bd45a696708c4f080f8ca6%7C0%7C1%7C638301264197674357%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=SaOmJOm26OxxMF4UaPgNoP4C%2BmJlVr5NZ15sQa%2FQsrk%3D&reserved=0
## 77                                                                                                                                                                                                                                                                                                   https://floridajobs.org/news-center/DEO-Press/2023/10/10/floridacommerce-reaches-$101-million-in-approved-loans-and-investments-to-florida-small-businesses-through-the-state-small-business-credit-initiative-2.0
## 78                                                                                                                                                                                                                                                                                                                                                                                                                                                                 https://home.treasury.gov/news/press-releases/jy2095
## 79                                                                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.iowaeda.com/iowa-news/ssbci-may2023/
## 80                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 81                                                                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.iowaeda.com/iowa-news/ssbci-may2023/
## 82                                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://www.iowaeda.com/iowa-news/ieda-march2023/
## 83                                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://www.iowaeda.com/iowa-news/ieda-march2023/
## 84                                                                                                                                                                                                                                                                                                                                                                                                                                                                       https://www.iowaeda.com/iowa-news/ssbci-feb23/
## 85                                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://www.iowaeda.com/iowa-news/ieda-march2023/
## 86                                                                                                                                                                                                                                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/iedaboard-sept2023/
## 87                                                                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.iowaeda.com/iowa-news/ssbci-may2023/
## 88                                                                                                                                                                                                                                                                                                                                                                                                                                                                 https://www.iowaeda.com/iowa-news/iedaboard-nov2023/
## 89                                                                                                                                                                                                                                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/iedaboard-sept2023/
## 90                                                                                                                                                                                                                                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/ieda-board-jan2023/
## 91                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/ssbci-feb23/; https://www.messengernews.net/news/local-news/2023/02/algona-startup-receives-ieda-innovation-fund-loan/ and https://www.messengernews.net/news/local-news/2023/02/algona-startup-receives-ieda-innovation-fund-loan/
## 92                                                                                                                                                                                                                                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/ieda-board-jan2023/
## 93                                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://www.iowaeda.com/iowa-news/ieda-march2023/
## 94                                                                                                                                                                                                                                                                                                                                             https://www.iowaeda.com/iowa-news/ssbci-feb23/ \r\nhttps://www.campussafetymagazine.com/press-release/intellisee-iowa-economic-development-authority-innovation-funding/
## 95                                                                                                                                                                                                                                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/iedaboard-july2023/
## 96                                                                                                                                                                                                                                                                                                                                                                                                                         https://corridorbusiness.com/ieda-approves-assistance-for-three-innovation-startups-in-iowa/
## 97                                                                                                                                                                                                                                                                                                                                                                                                                                                                https://www.iowaeda.com/iowa-news/ieda-board-jan2023/
## 98                                                                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.iowaeda.com/iowa-news/ssbci-may2023/
## 99                                                                                                                                                                                                                                                                                                                                                                                                                                    https://www.southeastiowaunion.com/news/washington-ag-business-earns-state-money/
## 100                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579575
## 101                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579577
## 102                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579590
## 103                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579587
## 104                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579585
## 105                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579579
## 106                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579583
## 107                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579589
## 108                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579586
## 109                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579588
## 110                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579580
## 111                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579582
## 112                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579576
## 113                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579573
## 114                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579584
## 115                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579578
## 116                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579581
## 117                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579572
## 118                                                                                                                                                                                                                                                                                                                                                                                                                           https://news.yahoo.com/ameristar-gets-federal-loan-initiative-233600438.html?guccounter=1
## 119                                                                                                                                                                                                                                                                                                                                                                                                                                          https://mn.gov/governor/newsroom/press-releases/#/detail/appId/1/id/579574
## 120                                                                                                                                                                                                                                                                                                                                                                  https://www.fergusfallsjournal.com/news/perham-business-benefits-from-loan-participation-program/article_8bab9346-047d-11ee-a3fb-779ea1d64f20.html
## 121                                                                                                                                                                                                                                                                                                                                                                                                               https://www.keloland.com/news/capitol-news-bureau/sioux-falls-business-gets-a-3-million-federal-loan/
## 122                                                                                                                                                                                                                                                                                                                                                                                                                      https://www.kxnet.com/news/top-stories/north-dakota-angel-match-program-makes-new-investments/
## 123                                                                                                                                                                                                                                                                                                                                                                                                                                   https://businessfacilities.com/north-dakota-invests-in-three-technology-startups/
## 124                                                                                                                                                                                                                                                                                                                                                                                       https://www.commerce.nd.gov/news/new-north-dakota-angel-match-program-makes-first-investment-project-phoenix-technologies-inc
## 125                                                                                                                                                                                                                                                                                                                                                                                                                                   https://businessfacilities.com/north-dakota-invests-in-three-technology-startups/
## 126                                                                                                                                                                                                                                                                                                                                                                                           https://www.commerce.nd.gov/news/north-dakota-angel-match-program-makes-new-investments-tech-and-manufacturing-businesses
## 127                                                                                                                                                                                                                                                                                                                       https://bismarcktribune.com/news/state-and-regional/govt-and-politics/north-dakota-program-overseen-by-shark-tank-star-makes-1st-investment/article_8a5ea576-b85d-11ed-8b89-d3081ff2799c.html
## 128                                                                                                                                                                                                                                                                                                                                                                                           https://www.commerce.nd.gov/news/north-dakota-angel-match-program-makes-new-investments-tech-and-manufacturing-businesses
## 129                                                                                                                                                                                                                                                                                                                                                                                                                      https://www.kxnet.com/news/top-stories/north-dakota-angel-match-program-makes-new-investments/
## 130                                                                                                                                                                                                                                                                                                                                                                                           https://www.commerce.nd.gov/news/north-dakota-angel-match-program-makes-new-investments-tech-and-manufacturing-businesses
## 131                                                                                                                                                                                                                                                                                                                                                                 https://www.grandforksherald.com/business/grand-forks-company-thread-chosen-as-next-investment-for-shark-tank-star-kevin-oleary-managed-wonder-fund
## 132                                                                                                                                                                                                                                                                                                                                                                                                                                   https://businessfacilities.com/north-dakota-invests-in-three-technology-startups/
## 133                                                                                                                                                                                                                                                                                                                                                                                      https://www.commerce.nd.gov/news/north-dakota-angel-match-program-funds-healthcare-app-development-and-tech-solution-companies
## 134                                                                                                                                                                                                                                                                                                                                                                                    https://www.missouritechnology.com/2023/05/02/missouri-technology-corporation-awards-2-3-million-worth-of-idea-fund-investments/
## 135                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 136                                                                                                                                                                                                                                                                                                                                                                                    https://www.missouritechnology.com/2023/05/02/missouri-technology-corporation-awards-2-3-million-worth-of-idea-fund-investments/
## 137                                                                                                                                                                                                                                                                                                                                                                                    https://www.missouritechnology.com/2023/05/02/missouri-technology-corporation-awards-2-3-million-worth-of-idea-fund-investments/
## 138                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://content.govdelivery.com/accounts/MODED/bulletins/34a5d7b
## 139                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://content.govdelivery.com/accounts/MODED/bulletins/34a5d7b
## 140                                                                                                                                                                                                                                                                                                                                                                                    https://www.missouritechnology.com/2023/05/02/missouri-technology-corporation-awards-2-3-million-worth-of-idea-fund-investments/
## 141                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 142                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 143                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 144                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 145                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://content.govdelivery.com/accounts/MODED/bulletins/34a5d7b
## 146                                                                                                                                                                                                                                                                                                                                                                                                         https://ded.mo.gov/content/missouri-technology-corporation-awards-2-million-ssbci-funded-equity-investments
## 147                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://content.govdelivery.com/accounts/MODED/bulletins/34a5d7b
## 148                                                                                                                                                                                                                                                                                                                                                                                    https://www.missouritechnology.com/2023/05/02/missouri-technology-corporation-awards-2-3-million-worth-of-idea-fund-investments/
## 149                                                                                                                                                                                                                                                                                                                                                                                                              https://www.kansascommerce.gov/2022/11/governor-laura-kelly-announces-850000-for-kansas-entrepreneurs/
## 150                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 151                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 152                                                                                                                                                                                                                                                                                                                                                                                    https://www.missouritechnology.com/2023/05/02/missouri-technology-corporation-awards-2-3-million-worth-of-idea-fund-investments/
## 153                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 154                                                                                                                                                                                                                                                                                                                                                                                                                                             https://www.startlandnews.com/2023/08/mtc-equity-investments-july-2023/
## 155                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://content.govdelivery.com/accounts/MODED/bulletins/34a5d7b
## 156                                                                                                                                                                                                                                                                                                                                                                                                                                                    https://content.govdelivery.com/accounts/MODED/bulletins/34a5d7b
## 157                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 158                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 159                                                                                                                                                                                                                                                                                                                                                                                                https://www.networkkansas.com/2023/03/06/12-businesses-receive-funding-from-network-kansas-partners-during-february/
## 160                                                                                                                                                                                                                                                                                                                                                                                                https://www.networkkansas.com/2023/03/06/12-businesses-receive-funding-from-network-kansas-partners-during-february/
## 161                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 162                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 163                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 164                                                                                                                                                                                                                                                                                                                                                                                                              https://www.kansascommerce.gov/2022/11/governor-laura-kelly-announces-850000-for-kansas-entrepreneurs/
## 165                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 166                                                                                                                                                                                                                                                                                                                                                                                                                                                                       https://www.startlandnews.com/2022/12/growks/
## 167                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 168                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 169                                                                                                                                                                                                                                                                                                                                                                                                                                                 https://www.startlandnews.com/2023/04/cap-creations-grad-cap-remix/
## 170                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 171                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 172                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 173                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 174                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 175                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 176                                                                                                                                                                                                                                                                                                                                                                                                                                                                  https://www.startlandnews.com/2023/03/bryght-labs/
## 177                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 178                                                                                                                                                                                                                                                                                                                                                                                                https://www.networkkansas.com/2023/03/06/12-businesses-receive-funding-from-network-kansas-partners-during-february/
## 179                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 180                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 181                                                                                                                                                                                                                                                                                                                                                                                                https://www.networkkansas.com/2023/03/06/12-businesses-receive-funding-from-network-kansas-partners-during-february/
## 182                                                                                                                                                                                                                                                                                                                                                                                                                                                                     https://www.startlandnews.com/2023/03/govbuilt/
## 183                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 184                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 185                                                                                                                                                                                                                                                                                                                                                                                                https://www.networkkansas.com/2023/03/06/12-businesses-receive-funding-from-network-kansas-partners-during-february/
## 186                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 187                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 188                                                                                                                                                                                                                                                                                                                                                                                                              https://www.kansascommerce.gov/2022/11/governor-laura-kelly-announces-850000-for-kansas-entrepreneurs/
## 189                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 190                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 191                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 192                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 193                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 194                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 195                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 196                                                                                                                                                                                                                                                                                                                                                                                                 https://www.networkkansas.com/2022/11/08/13-businesses-receive-funding-from-network-kansas-partners-during-october/
## 197                                                                                                                                                                                                                                                                                                                                                                                                https://www.networkkansas.com/2023/03/06/12-businesses-receive-funding-from-network-kansas-partners-during-february/
## 198                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 199                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 200                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 201                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 202                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 203                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 204                                                                                                                                                                                                                                                                                                                                                                                                                                                          https://www.networkkansas.com/2023/04/12/march-2023-loans/
## 205                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 206                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 207                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 208                                                                                                                                                                                                                                                                                                                                                                                                     https://www.networkkansas.com/2023/07/04/18-businesses-receive-funding-from-network-kansas-partners-during-may/
## 209                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 210                                                                                                                                                                                                                                                                                                                                                                                                                                                        https://www.networkkansas.com/2023/05/16/funding-april-2023/
## 211                                                                                                                                                                                                                                                                                                                                                                                                    https://www.networkkansas.com/2023/07/05/25-businesses-receive-funding-from-network-kansas-partners-during-june/
## 212                                                                                                                                                                                                                                                                                                                                                                                                                                                           https://www.networkkansas.com/2023/08/20/july2023funding/
## 213                                                                                                                                                                                                                                                                                                                                                                                https://www.kansascityfed.org/community/community-connections/new-federal-funds-bring-significant-impact-for-small-business-lending/
## 214                                                                                                                                                                                                                                                                                                                                                                     https://esd.ny.gov/esd-media-center/press-releases/esd-announces-first-series-investments-from-ny-ssbci-pre-seed-and-seed-matching-fund-program
## 215                                                                                                                                                                                                                                                                                                                                                                                https://www.kansascityfed.org/community/community-connections/new-federal-funds-bring-significant-impact-for-small-business-lending/
## 216                                                                                                                                                                                                                                                                                                                                                                                          https://www.einnews.com/pr_news/648017736/wyoming-business-council-announces-first-wyoming-venture-capital-fund-investment
## 217                                                                                                                                                                                                                                                                                                                                                                     https://www.wyomingnewsnow.tv/2023/10/12/wyoming-business-council-announces-wyoming-venture-capital-fund-investment-frontline-wildfire-defense/
## 218                                                                                                                                                                                                                                                                                                                                                 https://www.2news.com/news/companies-in-reno-and-las-vegas-receive-investments-at-angelnv-shark-tank-style-finale/article_eff982b0-e928-11ed-a8c0-7b3fb8fff48d.html
## 219                                                                                                                                                                                                                                                                                                                                                                                                           https://vegasinc.lasvegassun.com/business/2023/nov/13/local-startup-fund-helps-turn-business-vision-into/
##                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Notes
## 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    PR Economic Development Bank (BDE)'s first partnership with a private financial entity (Jesus Obrero Credit Union)
## 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  <NA>
## 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  <NA>
## 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    no company website
## 5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Semiconductor supply chain - liquid cooling for computer chips; energy efficiency
## 6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  <NA>
## 7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Woman-led
## 8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Latino-led
## 9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Renewable product with "negative carbon footprint" - also mentioned at: https://www.bangordailynews.com/2024/02/01/bdn-maine/fame-financing-to-assist-madison-and-waldoboro-businesses/
## 10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 11                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 12                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman-founded
## 13                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 14                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman-founded
## 15                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Founder of color
## 16                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Woman-led
## 17                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 18                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Black-led
## 19                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 20                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 21                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Listed by Treasury as a CDFI loan fund success story
## 22                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 23                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 24                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Black co-founder
## 25                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 26                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman-founded
## 27                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Black-led
## 28                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Woman-owned
## 29                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman-founded
## 30                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Black woman-founded
## 31                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 32                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 33                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 34                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 35                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Black woman-founded
## 36                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 37                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 38                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 39                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Founder of color; natural disaster detection
## 40                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 41                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 42                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Woman-owned
## 43                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 44                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Women-led; Co-founder of color
## 45                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 46                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Black woman-owned; also in Treasury Oct report https://home.treasury.gov/system/files/136/State-Small-Business-Credit-Initiative-in-Action.pdf
## 47                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Black-led
## 48                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Woman-owned
## 49                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Black woman-owned
## 50                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 51                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Black-led
## 52                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 53                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman-founded
## 54                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 55                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Black-owned
## 56                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 57                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Woman owned
## 58                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 59                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Founder of color
## 60                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Black woman-founded
## 61                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Black-led
## 62                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 63                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman founded
## 64                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 65                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 66                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 67                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 68                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 69                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 70                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Woman-led
## 71                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 72                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 73                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 74                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Listed by Treasury as a CDFI loan fund success story
## 75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 76                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 77                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 78                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 79                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Serves rural areas and farms
## 80                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 81                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 82                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Response to noticable industry labor force shortage
## 83                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 84                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Renewable energy tech
## 85                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             https://getmetafuel.com/
## 86                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 87                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 88                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 89                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 90                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 91  Also mentioned in SSBCI Bulletin (Feb 2, 2024) - Kinetic Technologies’ core goals are “design, build, and automate.” The Algona, Iowa based advanced manufacturing firm supports manufacturers in scaling their production capacity – often filling a market gap by helping customers produce smaller batches of highly- engineered parts. The company filed a patent for their robotic welding table in 2022, but they needed working capital to grow their marketing, distribution, and sales capacity, as well as to refine the product to respond to customer feedback. Kinetic received a $175,000 SSBCI loan through the Iowa Economic Development Authority’s Innovation Continuum Demonstration Fund, a program that catalyzes new private equity investment in the information technology, advanced manufacturing, and bioscience sectors by providing SSBCI debt capital. These funds will be used by the company to invest in both the product and Kinetic’s growth goals.“Iowa is filled with innovative thinkers who are pushing the boundaries in their industries, and it’s important that we create an ecosystem where they can thrive,” said Debi Durham, director of the Iowa Economic Development and Iowa Finance Authority. “The SSBCI investment is a great addition to our Innovation Continuum to assist more entrepreneurs at all stages.”
## 92                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman-founded
## 93                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Woman-owned
## 94                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 95                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Woman-led
## 96                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 97                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 98                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 <NA>
## 99                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Surge in demand from IRA tax credits
## 100                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 101                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 102                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 103                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 104                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 105                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 106                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 107                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 108                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Working to decarbonize and secure global energy systems
## 109                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 110                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 111                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 112                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Woman co-founded; OZ
## 113                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 114                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 115                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 116                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 117                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 118                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 119                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 120                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 121                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 122                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 123                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 124                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 125                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 126                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 127                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Kevin O'Leary - Shark Tank lead investor; establishing corporate office in ND; will serve rural landowners - does not have a physical location yet in Fargo
## 128                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Sustainable energy storage project
## 129                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 130                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 131                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 132                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Founder of color
## 133                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 134                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 135                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Woman co-founded
## 136                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 137                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 138                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 139                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 140                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 141                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 142                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Woman-led
## 143                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Founders of color
## 144                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 145                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 146                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Woman-led; helps ag startups with genetic modification
## 147                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 148                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 149                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Woman-founded; Manages finanical agreements between suppliers and distributors
## 150                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Co-founder of color
## 151                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 152                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Woman-owned
## 153                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 154                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Black co-founder
## 155                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Woman-owned; Licensing agreement w/ Mayo Clinic; SSBCI part of $3.6M/ also found at https://www.startlandnews.com/2023/02/healium-funding-mayo-clinic/
## 156                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Woman-founded; MTC
## 157                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 158                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 159                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 160                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 161                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Woman-led
## 162                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Woman co-led
## 163                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 164                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 165                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 166                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Black woman-founded
## 167                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 168                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        not yet open
## 169                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Black woman-founded
## 170                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 171                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Founders of color
## 172                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Woman of color founded; 8(a) STARS III GWAC prime contractor (contract with $50B ceiling)
## 173                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Vetern-owned
## 174                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 175                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 176                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    KS based company
## 177                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             E-Community Partnership
## 178                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 179                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Vetern-founded
## 180                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        not yet open
## 181                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 182                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 183                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 184                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 185                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 186                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 187                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       no company website; no clear business license
## 188                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Builds and repairs housing facilities for foster youth
## 189                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 190                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Woman-owned
## 191                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 192                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 193                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 194                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       no company website; no clear business license
## 195                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 196                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 197                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 198                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 199                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 200                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 201                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Woman co-owned; GROWKS filled gap financing to fund the startup
## 202                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 203                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Woman-owned
## 204                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  no company website
## 205                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 206                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         *A lot of KS businesses are brand new or haven't opened yet
## 207                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 208                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 209                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 210                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 211                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Woman-owned
## 212                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 213                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Expanded cacity for NEF CDFI; nonprofit matched 1:1
## 214                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Woman of color co-founded
## 215                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Rural businss
## 216                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Woman-founded
## 217                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 218                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
## 219                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                <NA>
##                                                                                                                                                                                                                                                                   Company Description
## 1                                                                                                                                                                                                                                                                                <NA>
## 2                                                                                                                                                                                                                                                                                <NA>
## 3                                                                                                                                                                                                                                                                                   5
## 4                                                                                                                                                                                                                                                                                <NA>
## 5                                                                                                                                                                                                                                                                                <NA>
## 6                                                                                                                                                                                                                                                                                <NA>
## 7                                                                                                                                                                                                                                                                                <NA>
## 8                                                                                                                                                                                                                                                                                <NA>
## 9                                                                                                                                                                                                                                                                                <NA>
## 10                                                                                                                                                                                                                                                                               <NA>
## 11                                                                                   simplifies homeownership with an interactive mobile app and expert digital content, while enabling and empowering homeowners to make their homes safer, more valuable and more energy efficient.
## 12                                                                                                                                                                                                                                                                               <NA>
## 13                                                                                                                                                                                                                                                                               <NA>
## 14                                                                                                                                                                                                                                                                               <NA>
## 15                                                                                                                                                                                                                                                                               <NA>
## 16                                                                                                                                                                                                                                                                               <NA>
## 17                                                                                                                                                                                                                                                                               <NA>
## 18                                                                                                                                                                                                                                                                               <NA>
## 19                                                                                                                                                                                                                                                                               <NA>
## 20                                                                                                                                                                                                                                                                               <NA>
## 21                                                                                                                                                                                                                                                                               <NA>
## 22                                                                                                                                                                                                                                                                               <NA>
## 23                                                                                                                                                                                                                                                                               <NA>
## 24                                                                                                                                                                                                                                                                               <NA>
## 25                                                                                                                                                                                                                                                                               <NA>
## 26                                                                                                                                                                                                                                                                               <NA>
## 27                                                                                                                                                                                                                                                                               <NA>
## 28                                                                                                                                                                                                                                                                               <NA>
## 29                                                                                                                                                                                                                                                                               <NA>
## 30                                                                                                                                                                                                                                                                               <NA>
## 31                                                                                                                                                                                                                                                                               <NA>
## 32                                                                                                                                                                  Commercializes powerful, cost-effective microalgae-derived metabolites for regenerative agriculture applications.
## 33                                                                                                                                                                                                                                                                               <NA>
## 34                                                                                                                                       specializes in robotic-enabled solutions to conduct inspection of crude oil storage tanks without the need to take the tanks out of service.
## 35                                                                                                                                                                                                                                                                               <NA>
## 36                                                                                                                                                                                                                                                                               <NA>
## 37                                                                                                                                                                                                                                                                               <NA>
## 38                                                                                                                                                                                                                                                                               <NA>
## 39                                                                                                                                                                                                                                                                               <NA>
## 40                                                                                                                                                                                                                                                                               <NA>
## 41                                                                                                                                                                                                                                                                               <NA>
## 42                                                                                                                                                                                                                                                                               <NA>
## 43                                                                                                                                                                                                                                                                               <NA>
## 44                                                                                                                                                                                                                                                                               <NA>
## 45                                                                                                                                                                                                                                                                               <NA>
## 46                                                                                                                                                                                                                                                                               <NA>
## 47                                                                                                                                                                                                                                                                               <NA>
## 48                                                                                                                                                                                                                                                                               <NA>
## 49                                                                                                                                                                                                                                                                               <NA>
## 50                                                                                                                                                                                                                                                                               <NA>
## 51                                                                                                                                                                                                                                                                               <NA>
## 52                                                                                                                                                                                                                                                                               <NA>
## 53                                                                                                                                                                                                                                                                               <NA>
## 54                                                                                                                                                                                                                                                                               <NA>
## 55                                                                                                                                                                                                                                                                               <NA>
## 56                                                                                                                                                                                                                                                                               <NA>
## 57                                                                                                                                                                                                                                                                               <NA>
## 58                                                                                       Sedaro is developing a cloud-based engineering physics engine for digital twins, virtual replicas of physical assets that are constructed via collaborative system modeling and data fusion.
## 59                                                                                                                                                                                                                                                                               <NA>
## 60                                                                                                                                                                                                                                                                               <NA>
## 61                                                                                                                                                                                                                                                                               <NA>
## 62                                                                                                                                                                                                                                                                               <NA>
## 63                                                                                                                                                           Takes real, quality ingredients and turns them into great-tasting, meat-free burgers that don’t compromise on nutrition.
## 64                                                                                                                                                                                                                                                                               <NA>
## 65                                                                                                                                                                                                                                                                               <NA>
## 66                                                                                                                                                              Developing an integrated platform technology using thermal imaging to detect colorectal cancer before symptoms start.
## 67                                                                                                                                                                                                                                                                               <NA>
## 68                                                                                                                                                                                                                                                                               <NA>
## 69                                                       Enables businesses of any size to provide bitcoin and digital assets as rewards to their customers or enticement for new customers, making it easy to infuse bitcoin into traditional consumer loyalty and rewards programs.
## 70                                                                                                                                                                                                                                                                               <NA>
## 71                                                                                                                                                                                                                                                                               <NA>
## 72                                                                                                                                                                                                                                                                               <NA>
## 73                                                                                                                                                                                                                                                                               <NA>
## 74                                                                                                                                                                                                                                                                               <NA>
## 75                                                                                                                                                                                                                                                                               <NA>
## 76                                                                                                                                                                                                                                                                               <NA>
## 77                                                                                                                                                                                                                                                                               <NA>
## 78                                                                                                                                                                                                                                                                               <NA>
## 79                                                                                                                                                                                                                                                                               <NA>
## 80                                                                                                                                                                                                                                                                               <NA>
## 81                                                                                                                                                                                                                                                                               <NA>
## 82                                                                                                                                                                                                                                                                               <NA>
## 83                                                                                                                                                                                                                                                                               <NA>
## 84                                                                                                                                                                                                                                                                               <NA>
## 85                                                                                                                                                                                                                                                                               <NA>
## 86                                                                                                                                                                                                                                                                               <NA>
## 87                                                                                                                                                                                                                                                                               <NA>
## 88                                                                                                                                                                                                                                                                               <NA>
## 89                                                                                                                                                                                                                                                                               <NA>
## 90                                                                                                                                                                                                                                                                               <NA>
## 91                                                                                                                                                                                                                                                                               <NA>
## 92                                                                                                                                                                                                                                                                               <NA>
## 93                                                                                                                                                                                                                                                                               <NA>
## 94                                                                                                                                                                                                                                                                               <NA>
## 95                                                                                                                                                                                                                                                                               <NA>
## 96                                                                                                                                                                                                                                                                               <NA>
## 97                                                                                                                                                                                                                                                                               <NA>
## 98                                                                                                                                                                                                                                                                               <NA>
## 99                                                                                                                                                                                                                                                                               <NA>
## 100                                                                                                                                                                                                                                                                              <NA>
## 101                                                                                                                                                                                                                                                                              <NA>
## 102                                                                                                                                                                                                                                                                              <NA>
## 103                                                                                                                                                                                                                                                                              <NA>
## 104                                                                                                                                                                                                                                                                              <NA>
## 105                                                                                                                                                                                                                                                                              <NA>
## 106                                                                                                                                                                                                                                                                              <NA>
## 107                                                                                                                                                                                                                                                                              <NA>
## 108                                                                                                                                                                                                                                                                              <NA>
## 109                                                                                                                                                                                                                                                                              <NA>
## 110                                                                                                                                                                                                                                                                              <NA>
## 111                                                                                                                                                                                                                                                                              <NA>
## 112                                                                                                                                                                                                                                                                              <NA>
## 113                                                                                                                                                                                                                                                                              <NA>
## 114                                                                                                                                                                                                                                                                              <NA>
## 115                                                                                                                                                                                                                                                                              <NA>
## 116                                                                                                                                                                                                                                                                              <NA>
## 117                                                                                                                                                                                                                                                                              <NA>
## 118                                                                                                                                                                                                                                                                              <NA>
## 119                                                                                                                                                                                                                                                                              <NA>
## 120                                                                                                                                                                                                                                                                              <NA>
## 121                                                                                                                                                                                                                                                                              <NA>
## 122                                                                                                                                                                                                                                                                              <NA>
## 123                                                                                                                                                                                                                                                                              <NA>
## 124                                                                                                                                                                                                                                                                              <NA>
## 125                                                                                                                                                                                                                                                                              <NA>
## 126                                                                                                                                                                                                                                                                              <NA>
## 127                                                                                                                                                                                                                                                                              <NA>
## 128                                                                                                                                                                                                                                                                              <NA>
## 129                                                                                                                                                                                                                                                                              <NA>
## 130                                                                                                                                                                                                                                                                              <NA>
## 131                                                                                                                                                                                                                                                                              <NA>
## 132                                                                                                                                                                                                                                                                              <NA>
## 133                                                                                                                                                                                                                                                                              <NA>
## 134                                                                                                                                      Provides data and software as a service product to help advertising buyers & sellers track and optimize media spend and improve performance.
## 135                                                                                                                                         Using proprietary computational tools to build superior cell-based products for regenerative medicine therapies and biomedical research. 
## 136                                                                                                                        Engages in the provision, facilitation, and delivery of hearing healthcare products and services via a proprietary full-stack hearing healthcare platform.
## 137                                                                                                                                      Develops and commercializes dual-use medical technologies to radically improve health outcomes for service members, veterans, and civilians.
## 138                                                                                                                                         Reverses metabolic disorders through self-knowledge, biomarker validation, and permanent lifestyle modification within a provider market.
## 139                                                                                                                                   Develops new drugs for the treatment of airway diseases and related conditions caused by respiratory viral infections and environmental toxins.
## 140                                                                                          Commercializes early-stage products and technologies in virtual care and remote patient monitoring; the first product, SweetSpot, is a remote monitoring platform for diabetes patients.
## 141                                                                                                                                                               Addresses the unmet clinical and economic needs associated with the treatment of large volume deep vein thrombosis.
## 142                                                                                                                                                                                                                                  Creates novel proteins for biotech applications.
## 143                                                   A hybrid care delivery platform that combines telehealth with in-person care to deliver a fully-integrated primary care solution for self-funded employers, where every doctor is available at every location for every member.
## 144                          Market leading, SaaS platform helping companies improve employee loyalty resulting in higher retention and productivity – accomplished through the integration of reward, learning and communication technologies needed to improve behavioral outcomes.
## 145                                                                                 Engineers sunflower plants to produce a domestic source of natural rubber, a strategic raw material required in many of military, industrial, and consumer products, but with no domestic supply.
## 146                                                                                                     A services provider for the AgTech industry that enables plant sciences companies to more quickly and cost-effectively deliver innovative products to growers and consumers. 
## 147                                                                                                                                                           Makes software solutions for oncology clinics to improve workflow, reduce healthcare costs, and improve patient care.  
## 148                                                                                                                                                                                    Technology platform that enables groups to social sync (sing, pray, or cheer together) online.
## 149                                                                                                                                                                                                                                                                              <NA>
## 150 Enables physical and occupational therapy practices to deliver best-in-class outcomes for their patients through accessible solutions that strengthen the patient-provider connection while increasing reimbursement to create a more sustainable future for PT/OT professionals.
## 151                                                 Operates to transform how America cares for seniors by creating technology, network services, and coordinated care that enable better health and quality of life outcomes at lower costs for seniors and senior living operators.
## 152                                                                                                                          Provides nutritional guidance during the birthing years with personalized nutrient and food recommendations during fertility, pregnancy, and postpartum.
## 153                                                                                                                                                                                                                                                                              <NA>
## 154                                                                                                                              Developed patent-pending Artificial Intelligence (Sailebots) automating sales prospecting tasks to deliver unlimited leads and labor to sales teams.
## 155                                                                                                       Sells digital therapeutics for the self-management of anxiety and sleep powered that connects any consumer wearable to 3D assets in augmented, virtual, or mixed realities.
## 156                                                                                                                           Pioneering a new category of orthopedic and spine hardware with a focus on bridging between hardware and biologics to meet patient-specific challenges.
## 157                                                                                                                                                                                                                                                                              <NA>
## 158                                                                                                                                                                                                                                                                              <NA>
## 159                                                                                                                                                                                                                                                                              <NA>
## 160                                                                                                                                                                                                                                                                              <NA>
## 161                                                                                                                                                                                                                                                                              <NA>
## 162                                                                                                                                                                                                                                                                              <NA>
## 163                                                                                                                                                                                                                                                                              <NA>
## 164                                                                                                                                                                                                                             Advances novel therapies for treating cancer in pets.
## 165                                                                                                                                                                                                                                                                              <NA>
## 166                                                                                                           Provides a career empowerment platform that connects service industry professionals to job opportunities and helps employers build a more stable and engaged workforce.
## 167                                                                                                                                                                                                                                                                              <NA>
## 168                                                                                                                                                                                                                                                                              <NA>
## 169                                                                                                                                                                                                                                                                              <NA>
## 170                                                                                                                                                                                                                                                                              <NA>
## 171                                                                                                                                                                                                                                                                              <NA>
## 172                                                                                                                                                                                                                                                                              <NA>
## 173                                                                                                                                                                                                                                                                              <NA>
## 174                                                                                                                                                                                                                                                                              <NA>
## 175                                                                                                                                                                                                                                                                              <NA>
## 176                                                                                                                                                                                                             Makes consumer electronics and software apps for sports and hobbies. 
## 177                                                                                                                                                                                                                                                                              <NA>
## 178                                                                                                                                                                                                                                                                              <NA>
## 179                                                                                                                                                                                                                                                                              <NA>
## 180                                                                                                                                                                                                                                                                              <NA>
## 181                                                                                                                                                                                                                                                                              <NA>
## 182                                                                                                                                   Partners with small and medium-sized municipal governments across the country to provide customized permitting and licensing software solutions
## 183                                                                                                                                                                                                                                                                              <NA>
## 184                                                                                                                                                                                                                                                                              <NA>
## 185                                                                                                                                                                                                                                                                              <NA>
## 186                                                                                                                                                                                                                                                                              <NA>
## 187                                                                                                                                                                                                                                                                              <NA>
## 188                                                                                                                                                                                                                                                                              <NA>
## 189                                                                                                                                                                                                                                                                              <NA>
## 190                                                                                                                                                                                                                                                                              <NA>
## 191                                                                                                                                                                                                                                                                              <NA>
## 192                                                                                                                                                                                                                                                                              <NA>
## 193                                                                                                                                                                                                                                                                              <NA>
## 194                                                                                                                                                                                                                                                                              <NA>
## 195                                                                                                                                                                                                                                                                              <NA>
## 196                                                                                                                                                                                                                                                                              <NA>
## 197                                                                                                                                                                                                                                                                              <NA>
## 198                                                                                                                                                                                                                                                                              <NA>
## 199                                                                                                                                                                                                                                                                              <NA>
## 200                                                                                                                                                                                                                                                                              <NA>
## 201                                                                                                                                                                                                                                                                              <NA>
## 202                                                                                                                                                                                                                                                                              <NA>
## 203                                                                                                                                                                                                                                                                              <NA>
## 204                                                                                                                                                                                                                                                                              <NA>
## 205                                                                                                                                                                                                                                                                              <NA>
## 206                                                                                                                                                                                                                                                                              <NA>
## 207                                                                                                                                                                                                                                                                              <NA>
## 208                                                                                                                                                                                                                                                                              <NA>
## 209                                                                                                                                                                                                                                                                              <NA>
## 210                                                                                                                                                                                                                                                                              <NA>
## 211                                                                                                                                                                                                                                                                              <NA>
## 212                                                                                                                                                                                                                                                                              <NA>
## 213                                                                                                                                                                                                                                                                              <NA>
## 214                                                                                                                                                                                                                                                                              <NA>
## 215                                                                                                                                                                                                                                                                              <NA>
## 216                                                                                                                                                                                                                                                                              <NA>
## 217                                                                                                                                                           Developed a unique approach to wildfire protection, offering a first line of defense to protect property from wildfire.
## 218                                                                                                                                                                                                                                                                              <NA>
## 219                                                                                                                                                                                                                                                                              <NA>
##          LAT        LNG
## 1   18.45518  -67.11989
## 2   18.35045  -64.97389
## 3   17.74456  -64.68293
## 4   42.06237  -72.62575
## 5   42.53593  -71.49057
## 6   42.15688  -71.21619
## 7   42.25508  -71.12922
## 8   42.38141  -71.09671
## 9   44.82635  -69.79971
## 10  41.05935  -73.54438
## 11  40.78420  -74.50002
## 12  40.73183  -73.98918
## 13  40.75236  -73.97249
## 14  40.77592  -73.98261
## 15  40.79845  -73.97443
## 16  41.34419  -74.26218
## 17  40.56594  -80.14640
## 18  40.45319  -79.89950
## 19  40.31581  -76.88644
## 20  40.26783  -76.78737
## 21  40.01462  -76.24635
## 22  41.34504  -76.85726
## 23  40.58587  -75.36724
## 24  40.58587  -75.36724
## 25  40.58587  -75.36724
## 26  40.56471  -75.56876
## 27  39.95290  -75.17430
## 28  39.95173  -75.15865
## 29  39.97775  -75.14590
## 30  40.33861  -75.85816
## 31  38.74717  -77.48454
## 32  38.89650  -77.44513
## 33  38.98627  -77.45578
## 34  38.98627  -77.45578
## 35  39.13757  -76.86794
## 36  38.96426  -76.91354
## 37  39.00274  -76.93172
## 38  39.00499  -77.10149
## 39  39.09134  -77.18229
## 40  39.11282  -77.25050
## 41  39.16842  -77.17151
## 42  38.98161  -77.00116
## 43  39.49241  -76.67444
## 44  39.29483  -76.62223
## 45  39.29483  -76.62223
## 46  39.29483  -76.62223
## 47  39.30847  -76.63915
## 48  39.27486  -76.54283
## 49  39.28720  -76.59195
## 50  39.35488  -77.37590
## 51  38.31408  -75.53211
## 52  39.58541  -75.95896
## 53  38.85892  -77.26026
## 54  38.84932  -77.14147
## 55  38.94020  -77.16488
## 56  38.95095  -77.22954
## 57  38.85687  -77.05149
## 58  38.87372  -77.11732
## 59  38.89502  -77.07546
## 60  38.89502  -77.07546
## 61  38.89502  -77.07546
## 62  38.80685  -77.05637
## 63  38.08770  -78.55274
## 64  37.91028  -78.52212
## 65  37.91028  -78.52212
## 66  37.91028  -78.52212
## 67  38.09986  -78.88055
## 68  37.70223  -77.57400
## 69  37.65615  -77.53778
## 70  37.53977  -77.43553
## 71  37.49760  -77.46743
## 72  37.58664  -77.48912
## 73  37.47581  -77.58528
## 74  38.35072  -81.63036
## 75  37.82289  -81.26620
## 76  39.60263  -79.89540
## 77  30.51552  -84.34164
## 78  42.01008  -83.92785
## 79  42.03085  -93.58840
## 80  42.03085  -93.58840
## 81  42.04630  -93.69445
## 82  41.73027  -93.63498
## 83  41.73027  -93.63498
## 84  41.59317  -93.87471
## 85  41.55308  -93.74478
## 86  41.57008  -93.79842
## 87  41.58460  -93.62084
## 88  41.58268  -93.67667
## 89  41.62563  -93.79365
## 90  41.61324  -93.79787
## 91  43.07404  -94.21918
## 92  42.06566  -94.86966
## 93  42.04677  -91.68687
## 94  41.69958  -91.59595
## 95  41.69958  -91.59595
## 96  41.67287  -91.51216
## 97  42.07160  -91.66609
## 98  41.80588  -91.49239
## 99  41.29935  -91.71149
## 100 44.51192  -92.53913
## 101 44.95389  -93.16445
## 102 45.01220  -93.15119
## 103 45.10640  -93.49703
## 104 44.89566  -93.60765
## 105 44.91544  -93.48443
## 106 44.95640  -93.53899
## 107 44.98458  -93.26910
## 108 44.91182  -93.31964
## 109 44.91182  -93.31964
## 110 44.99946  -93.24168
## 111 44.97480  -93.25765
## 112 45.02132  -93.24285
## 113 45.06295  -93.38136
## 114 44.82313  -93.38611
## 115 44.87563  -93.37475
## 116 44.06982  -92.50658
## 117 43.55706  -91.78011
## 118 44.12812  -93.97899
## 119 44.50207  -95.45650
## 120 46.61877  -95.54828
## 121 43.60478  -96.70743
## 122 46.72426  -96.87276
## 123 46.86250  -96.92409
## 124 46.92709  -96.83470
## 125 46.92709  -96.83470
## 126 46.92709  -96.83470
## 127 46.85614  -96.82207
## 128 46.79323  -96.83968
## 129 47.86664  -97.14114
## 130 47.86664  -97.14114
## 131 47.92076  -97.07221
## 132 46.90412 -100.75030
## 133 48.21789 -103.76308
## 134 38.63518  -90.18700
## 135 38.63518  -90.18700
## 136 38.62971  -90.21686
## 137 38.62971  -90.21686
## 138 38.62971  -90.21686
## 139 38.64480  -90.25342
## 140 38.62579  -90.26700
## 141 38.62579  -90.26700
## 142 38.62579  -90.26700
## 143 38.65893  -90.28267
## 144 38.66507  -90.32531
## 145 38.67603  -90.37799
## 146 38.67603  -90.37799
## 147 38.61041  -90.29172
## 148 38.65828  -90.45820
## 149 39.10473  -94.59037
## 150 39.08490  -94.58647
## 151 39.08490  -94.58647
## 152 39.01407  -94.59565
## 153 38.95780  -94.59860
## 154 39.20997  -94.51466
## 155 38.88432  -92.39857
## 156 37.11972  -93.30972
## 157 39.53874  -95.13764
## 158 38.80427  -95.23267
## 159 38.80427  -95.23267
## 160 38.73067  -94.69555
## 161 39.02329  -95.20891
## 162 38.97810  -95.34413
## 163 38.97810  -95.34413
## 164 38.89376  -94.87998
## 165 38.89376  -94.87998
## 166 38.89376  -94.87998
## 167 38.83549  -94.77869
## 168 39.10896  -94.69254
## 169 38.92214  -94.70478
## 170 38.92214  -94.70478
## 171 38.92512  -94.63562
## 172 38.92512  -94.63562
## 173 38.96742  -94.71409
## 174 38.95770  -94.74427
## 175 39.01377  -94.74158
## 176 38.86368  -94.70845
## 177 38.93237  -96.30965
## 178 38.92419  -95.55964
## 179 38.97352  -96.80309
## 180 39.15630  -96.52126
## 181 39.15630  -96.52126
## 182 39.15630  -96.52126
## 183 39.15630  -96.52126
## 184 39.07961  -95.66323
## 185 38.97673  -95.84457
## 186 38.41421  -96.21830
## 187 39.82474  -97.06589
## 188 37.66312  -96.96528
## 189 37.68698  -97.33492
## 190 37.70718  -97.31775
## 191 37.77321  -97.21304
## 192 37.77321  -97.21304
## 193 37.77321  -97.21304
## 194 37.77321  -97.21304
## 195 38.83183  -97.65457
## 196 38.83183  -97.65457
## 197 38.83183  -97.65457
## 198 39.32934  -97.19339
## 199 39.37874  -98.74056
## 200 37.97749  -97.92645
## 201 38.12674  -97.92995
## 202 38.07623  -99.25438
## 203 38.35206  -98.79448
## 204 38.87688  -99.34954
## 205 38.87688  -99.34954
## 206 39.35908  -99.84449
## 207 39.79720 -101.83674
## 208 38.96919 -101.53192
## 209 37.72360 -100.05719
## 210 37.72360 -100.05719
## 211 38.47044 -101.38299
## 212 38.48041 -101.80598
## 213 40.85448  -96.66018
## 214 35.91628  -90.53953
## 215 38.97333 -106.38126
## 216 41.09236 -104.93627
## 217 41.09236 -104.93627
## 218 36.15138 -115.10865
## 219 36.06115 -115.26351
ssbci$Amount[is.na(ssbci$Amount)] <- 0
library(htmltools)
## Warning: package 'htmltools' was built under R version 4.3.2
library(dplyr)
library(leaflet)
## Warning: package 'leaflet' was built under R version 4.3.2
popup_style <- "
  .custom-popup {
    background-color: #F7F7F7;
    color: #333;
    font-family: Arial, sans-serif;
    font-size: 14px;
  }
"
layers_control_style <- "
  .leaflet-control-layers {
    font-family: Arial, sans-serif;
    font-size: 14px;
  }
  
  .leaflet-control-layers-list {
    background-color: #F7F7F7;
    border: 2px solid #333;
    border-radius: 5px;
    padding: 10px;
  }
"
#title
library(htmltools)
tag.map.title1 <- tags$style(HTML("
  .leaflet-control.map-title { 
    transform: translate(-50%,20%);
    position: fixed !important;
    left: 30%;
    text-align: center;
    padding-left: 10px; 
    padding-right: 10px; 
    background: rgba(0, 51, 102, 0.5);
    font-weight: bold;
    font-size: 13px;
    color: white; 
  }
"))


title1 <- tags$div(
  tag.map.title1, HTML("SSBCI loans and investments, 2023")
)
disclaimer_text <- "About this map: This map contains publicly announced State Small Business Credit Initiative (SSBCI) loans and investments tracked and broadly categorized by the Nowak Metro Finance Lab. Deals are sourced via jurisdiction websites, press releases, and news outlets. They are broadly classified as manufacturing, supplier (i.e., B2G/B2C), “Main Street” (i.e., local-serving firms), and high growth (e.g., technology) businesses."
additional_disclaimer_text <- "Disclaimer: This map is not a comprehensive or authoritative listing of all SSBCI loans and investments. Many jurisdictions and their partners may not release information about SSBCI loans and investments, and many publicly announced deals may be omitted. Comprehensive information will be released by the U.S. Treasury Department.
This map is intended for illustrative purposes only. It provides examples of firms that have received SSBCI loans and investments and is intended to highlight the range of firm types that are using program funds. The map should not be used to evaluate the performance of any participating jurisdiction or entity. What have we missed? Are you aware of publicly-announced SSBCI loans and investments that are not included on this map? Let us know: csd77@drexel.edu"

disclaimer <- tags$div(
  style = "position: fixed; bottom: 60px; right: 10px; background: rgba(255, 255, 255, 0.3); padding: 5px; font-size: 13px;",
  disclaimer_text,
  tags$br(),
  tags$span(style = "font-size: 11px;", additional_disclaimer_text)  # Set the font size for additional_disclaimer_text
)


ssbci$size <- 5.5

library(htmltools)
library(dplyr)
library(leaflet)
library(scales)
## Warning: package 'scales' was built under R version 4.3.2
library(leaflet.extras)
## Warning: package 'leaflet.extras' was built under R version 4.3.2
sector_palette <- colorFactor("Set1", ssbci$Sector)
program_palette<- colorFactor("PiYG", ssbci$`Program Type`)
#create link in pop up
create_link <- function(url, text) {
  sprintf('<a href="%s" target="_blank">%s</a>', url, text)
}


library(rgdal)
states_shapefile = readOGR(dsn="data/cb_2018_us_state_500k/.", verbose=FALSE)
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
## Warning: OGR support is provided by the sf and terra packages among others
states <- leaflet() %>%
  addProviderTiles(providers$CartoDB.Positron) %>%
  setView(-98.483330, 38.712046, zoom = 4) %>% 
  addPolygons(data = states_shapefile, weight = 1, col = '#333333', smoothFactor = 0.5, 
            highlightOptions = highlightOptions( 
          color='#E0FDFB', weight = 1.5, 
          sendToBack = TRUE), label = ~NAME) %>%

   addCircleMarkers(data = ssbci %>% filter(Sector == "Manufacturing"),
                   color =~sector_palette(Sector),
                   lat = ~LAT, lng = ~LNG,
                   radius = ~ size,  
                   fillOpacity = 0.5,  stroke = TRUE,popup=~paste("Sector: ",Sector,"<br/>", "Industry: ",
                  Industry,"<br/>", "Business Name: ", `Business Name`,"<br/>","Amount: ", dollar(Amount),"<br/>",                    create_link(Link, "Visit Website") ),weight = 1,group = "Manufacturing") %>%
  
     addCircleMarkers(data = ssbci %>% filter(Sector == "Supplier"),
                   color =~sector_palette(Sector),
                   lat = ~LAT, lng = ~LNG,
                   radius = ~ size,  
                   fillOpacity = 0.5,  stroke = TRUE,popup=~paste("Sector: ",Sector,"<br/>", "Industry: ",
                  Industry,"<br/>", "Business Name: ", `Business Name`,"<br/>","Amount: ", dollar(Amount),"<br/>",                    create_link(Link, "Visit Website") ),weight = 1,group = "Supplier") %>%
     addCircleMarkers(data = ssbci %>% filter(Sector == "High Growth"),
                   color =~sector_palette(Sector),
                   lat = ~LAT, lng = ~LNG,
                   radius = ~ size,  
                   fillOpacity = 0.5,  stroke = TRUE,popup=~paste("Sector: ",Sector,"<br/>", "Industry: ",
                  Industry,"<br/>", "Business Name: ", `Business Name`,"<br/>","Amount: ", dollar(Amount),"<br/>",                    create_link(Link, "Visit Website") ),weight = 1,group = "High Growth") %>%
     addCircleMarkers(data = ssbci %>% filter(Sector == "Main Street"),
                   color =~sector_palette(Sector),
                   lat = ~LAT, lng = ~LNG,
                   radius = ~ size,  
                   fillOpacity = 0.5,  stroke = TRUE,popup=~paste("Sector: ",Sector,"<br/>", "Industry: ",
                  Industry,"<br/>", "Business Name: ", `Business Name`,"<br/>","Amount: ", dollar(Amount),"<br/>",                    create_link(Link, "Visit Website") ),weight = 1,group = "Main Street") %>%
     addCircleMarkers(data = ssbci %>% filter(is.na(Sector)),
                   color =~sector_palette(Sector),
                   lat = ~LAT, lng = ~LNG,
                   radius = ~ size,  
                   fillOpacity = 0.5,  stroke = TRUE,popup=~paste("Sector: ",Sector,"<br/>", "Industry: ",
                  Industry,"<br/>", "Business Name: ", `Business Name`,"<br/>","Amount: ", dollar(Amount),"<br/>",                    create_link(Link, "Visit Website") ),weight = 1,group = "NA") %>%
  
  
    addLegend(position = "topright", 
            colors = c("lightgreen", "purple", "red", "lightblue", "lightgrey"),  # Set your desired colors
            labels = c("Manufacturing", "Supplier", "High Growth", "Main Street", "NA"),  # Set your desired labels
            title = "Sectors",
            opacity = 0.5,
            group = c("Manufacturing", "Supplier", "High Growth", "Main Street", "NA")) %>%

  addLayersControl(overlayGroups = c("Manufacturing", "Supplier", "High Growth", "Main Street", "NA"),options= layersControlOptions(collapsed = TRUE, position="bottomright")) %>% 
  addControl(title1, position = "topright", className="map-title") %>% 
  addControl(disclaimer, position = "bottomleft")  # Add the disclaimer text






# Display the map
states