The Search Keywords set to kidney and xls file downloaded at the URL https://www.sbir.gov/sbirsearch/award/all

## Loading required package: rJava
## Loading required package: xlsxjars
## 
## 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

Generate URLs of SBIR grant winners from email contacts

data<- read.xlsx("1480813733_export.xls", sheetIndex = 1, rowIndex = c(1:356), colIndex = c(1:45))
data$Award.Amount<- data$Award.Amount %>% as.character %>% as.numeric()
contact<-data %>% select(Contact.Email) %>% unlist() %>% unname()
domain<-str_extract_all(contact, "@[A-z]+\\.[A-z]+", simplify = T) 
domain.dash<-str_extract_all(contact, "@[A-z]+\\-[A-z]+\\.[A-z]+", simplify = T)
domains<-c(domain, domain.dash) %>% unique
domains<-gsub("@","",domains)
domains<-grep("com|net|us|org", domains,value=T)
domains<-domains[-grep("^aol\\.|^yahoo|^gmail|^msn|^hotmail|^mac\\.", domains)]
urls<-paste0("http://www.",domains)

URLs of grant winners

Excluded were second level domains of aol, gmail, hotmail, yahoo, mac and msn.

print(urls)
##   [1] "http://www.privotechnologies.com"      
##   [2] "http://www.sonomotion.com"             
##   [3] "http://www.sanochemicals.com"          
##   [4] "http://www.mdanderson.org"             
##   [5] "http://www.karyopharm.com"             
##   [6] "http://www.chkd.org"                   
##   [7] "http://www.kypha.net"                  
##   [8] "http://www.pulmokine.net"              
##   [9] "http://www.angion.com"                 
##  [10] "http://www.adeptrix.com"               
##  [11] "http://www.discoverybiomed.com"        
##  [12] "http://www.innoblative.com"            
##  [13] "http://www.kineta.us"                  
##  [14] "http://www.eunoiabiotech.com"          
##  [15] "http://www.tomegavax.com"              
##  [16] "http://www.vivonics.com"               
##  [17] "http://www.healthbehaviorsolutions.com"
##  [18] "http://www.northwindmed.com"           
##  [19] "http://www.therasourcellc.com"         
##  [20] "http://www.pacificdt.com"              
##  [21] "http://www.microsonics.com"            
##  [22] "http://www.urologydx.com"              
##  [23] "http://www.hillhurstbio.com"           
##  [24] "http://www.radikalrx.com"              
##  [25] "http://www.ginerinc.com"               
##  [26] "http://www.advancedcell.com"           
##  [27] "http://www.molecularexpress.com"       
##  [28] "http://www.lynntech.com"               
##  [29] "http://www.algomedix.com"              
##  [30] "http://www.extendbio.com"              
##  [31] "http://www.pano.com"                   
##  [32] "http://www.affinergy.com"              
##  [33] "http://www.innbio.com"                 
##  [34] "http://www.diapin.com"                 
##  [35] "http://www.magneticinsight.com"        
##  [36] "http://www.epigenbiosciences.com"      
##  [37] "http://www.symicbio.com"               
##  [38] "http://www.preventagehealthcare.com"   
##  [39] "http://www.thermimage.com"             
##  [40] "http://www.otcorp.com"                 
##  [41] "http://www.novelmed.com"               
##  [42] "http://www.roselliniscientific.com"    
##  [43] "http://www.omegaoptics.com"            
##  [44] "http://www.nanohmics.com"              
##  [45] "http://www.lunainc.com"                
##  [46] "http://www.orphagen.com"               
##  [47] "http://www.earthlink.net"              
##  [48] "http://www.celdaramedical.com"         
##  [49] "http://www.mchsi.com"                  
##  [50] "http://www.sarfez.com"                 
##  [51] "http://www.clinicalsensors.com"        
##  [52] "http://www.fastdiagnostics.com"        
##  [53] "http://www.spectradynellc.com"         
##  [54] "http://www.simplewater.com"            
##  [55] "http://www.embolx.com"                 
##  [56] "http://www.siliconkidney.com"          
##  [57] "http://www.exemplargenetics.com"       
##  [58] "http://www.recombinetics.com"          
##  [59] "http://www.msdrx.com"                  
##  [60] "http://www.probetex.com"               
##  [61] "http://www.immunext.com"               
##  [62] "http://www.citlink.net"                
##  [63] "http://www.electrozyme.com"            
##  [64] "http://www.captozyme.com"              
##  [65] "http://www.expressiontherapeutics.com" 
##  [66] "http://www.sentienbiotech.com"         
##  [67] "http://www.vaxiion.com"                
##  [68] "http://www.omneuron.com"               
##  [69] "http://www.icetinc.com"                
##  [70] "http://www.stategics.com"              
##  [71] "http://www.pnainnovations.com"         
##  [72] "http://www.irised.com"                 
##  [73] "http://www.vasculox.com"               
##  [74] "http://www.twinstarmedical.com"        
##  [75] "http://www.prodigy.net"                
##  [76] "http://www.crolaboratories.com"        
##  [77] "http://www.targeson.com"               
##  [78] "http://www.arrayomics.com"             
##  [79] "http://www.celltissuesystems.com"      
##  [80] "http://www.lasertissuewelding.com"     
##  [81] "http://www.medrospharma.com"           
##  [82] "http://www.omeros.com"                 
##  [83] "http://www.pharmain.com"               
##  [84] "http://www.phoenixsandt.com"           
##  [85] "http://www.rulesbasedmedicine.com"     
##  [86] "http://www.visotekinc.com"             
##  [87] "http://www.azanopharma.com"            
##  [88] "http://www.diabetomics.com"            
##  [89] "http://www.tuftsmedicalcenter.org"     
##  [90] "http://www.celsion.com"                
##  [91] "http://www.tartiscorp.com"             
##  [92] "http://www.aismail.wustl"              
##  [93] "http://www.infoscitex.com"             
##  [94] "http://www.akinainc.com"               
##  [95] "http://www.androbiosys.com"            
##  [96] "http://www.auritecpharma.com"          
##  [97] "http://www.bolderbio.com"              
##  [98] "http://www.culmini.com"                
##  [99] "http://www.glpharma.com"               
## [100] "http://www.ioshealth.com"              
## [101] "http://www.pluromed.com"               
## [102] "http://www.visonex.com"                
## [103] "http://www.rmdinc.com"                 
## [104] "http://www.biopharmsolutions.net"      
## [105] "http://www.cisthera.com"               
## [106] "http://www.connecttime.net"            
## [107] "http://www.dzymetech.com"              
## [108] "http://www.endoprotech.com"            
## [109] "http://www.incogen.com"                
## [110] "http://www.neuwave.com"                
## [111] "http://www.microbiotix.com"            
## [112] "http://www.molecularinsight.com"       
## [113] "http://www.nanoprobes.com"             
## [114] "http://www.profectusbiosciences.com"   
## [115] "http://www.proteotech.com"             
## [116] "http://www.spirecorp.com"              
## [117] "http://www.synthecon.com"              
## [118] "http://www.vistaphotonics.com"         
## [119] "http://www.zacharon.com"               
## [120] "http://www.minervabio.com"             
## [121] "http://www.filtsol.com"                
## [122] "http://www.alascience.com"             
## [123] "http://www.bioanalytical.com"          
## [124] "http://www.BioPAL.com"                 
## [125] "http://www.biotexmedical.com"          
## [126] "http://www.ciencia.com"                
## [127] "http://www.firstva.com"                
## [128] "http://www.lunainnovations.com"        
## [129] "http://www.molecularlogix.com"         
## [130] "http://www.oceanit.com"                
## [131] "http://www.progenra.com"               
## [132] "http://www.sapientdiscovery.com"       
## [133] "http://www.xos.com"                    
## [134] "http://www.amunix.com"                 
## [135] "http://www.swsciences.com"             
## [136] "http://www.isogenis.com"               
## [137] "http://www.micrablate.com"             
## [138] "http://www.usfamily.net"               
## [139] "http://www.creare.com"                 
## [140] "http://www.immunomedics.com"           
## [141] "http://www.madeleine-pharma.com"       
## [142] "http://www.visionquest-bio.com"        
## [143] "http://www.trim-edicine.com"           
## [144] "http://www.ame-corp.com"               
## [145] "http://www.mol-innov.com"              
## [146] "http://www.the-healthspan.com"

Winner company, awarded year and total amount at the year

Excluded were TLDs of org and edu, and SLDs of aol, yahoo, gmail,msn,hotmail and mac

sum_tab<-data%>%select(Company, Award.Year, Award.Amount)%>% group_by(Company, Award.Year) %>% 
  summarise(Total.Grant=sum(Award.Amount)) %>% arrange(desc(Total.Grant))
x<-data.frame(sum_tab); x[order(x$Company), ]
##                                      Company Award.Year Total.Grant
## 8                    20/20 GENESYSTEMS, INC.       2010     2949597
## 186     3-C INSTITUTE FOR SOCIAL DEVELOPMENT       2016      210222
## 147              ADENOSINE THERAPEUTICS, LLC       2005      288277
## 236              ADENOSINE THERAPEUTICS, LLC       <NA>      147326
## 92                      ADEPTRIX CORPORATION       2016      720069
## 267   ADVANCED DIGITAL IMAGING RESEARCH, LLC       2005      100000
## 217 ADVANCED MEDICAL ELECTRONICS CORPORATION       2015      161416
## 299                  ADVANCED MICROLABS, LLC       2006       99710
## 268          ADVANCED RENAL THERAPIES, INC..       2005      100000
## 144                           AFFINERGY, LLC       2015      293816
## 252             AGENTA BIOTECHNOLOGIES, INC.       2006      121980
## 269                              AKINA, INC.       2009      100000
## 206         ALA SCIENTIFIC INSTRUMENTS, INC.       2007      181825
## 141                          ALGOMEDIX, INC.       2015      296818
## 301                             ALKYMOS, INC       2008       99646
## 265                             AMUNIX, INC.       2007      100263
## 243                        ANDROBIOSYS, INC.       2009      139945
## 1               ANGION BIOMEDICA CORPORATION       2009     6180276
## 2               ANGION BIOMEDICA CORPORATION       2006     3909240
## 22              ANGION BIOMEDICA CORPORATION       2012     1780804
## 39              ANGION BIOMEDICA CORPORATION       2011     1335726
## 70              ANGION BIOMEDICA CORPORATION       2010      950836
## 100             ANGION BIOMEDICA CORPORATION       2016      610943
## 115             ANGION BIOMEDICA CORPORATION       2007      470491
## 156             ANGION BIOMEDICA CORPORATION       2004      239795
## 47           ANNIAS IMMUNOTHERAPEUTICS, INC.       2015     1227385
## 95                            APTALOGIC, INC       2015      683545
## 270                 ARETE THERAPEUTICS, INC.       <NA>      100000
## 37                          ARRAYOMICS, INC.       2010     1395810
## 292                         ARRAYOMICS, INC.       2008       99999
## 293                         ARRAYOMICS, INC.       2009       99999
## 41             AURITEC PHARMACEUTICALS, INC.       2009     1330820
## 237              AZANO PHARMACEUTICALS, INC.       2010      146716
## 314                        Barlow Scientific       1987       50000
## 136                       BESSOR PHARMA, LLC       2016      300000
## 98        BIOANALYTICAL SYSTEMS, INC. (BASI)       2007      643229
## 325                   Bioassay Systems Corp.       1983       45608
## 315                            Biomat Corpon       1992       50000
## 316              Biomedical Development Corp       1992       50000
## 69                               BIOPAL, INC       2012      963000
## 75                               BIOPAL, INC       2010      845941
## 271                 BIOPHARM SOLUTIONS, INC.       2008      100000
## 309 BIOPHYSICS ASSAY LAB, INC. (BIOPAL, INC)       2007       77521
## 266                     BIOPSY SCIENCES, LLC       2006      100045
## 272                BIOREP TECHNOLOGIES, INC.       2009      100000
## 126                             BIOTEX, INC.       2007      373938
## 46                BOLDER BIOTECHNOLOGY, INC.       2009     1240490
## 111               BOLDER BIOTECHNOLOGY, INC.       2004      500000
## 3                             BREONICS, INC.       2014     3522234
## 122                           BREONICS, INC.       2009      400000
## 97                     CANCER GENETICS, INC.       2010      645168
## 306                    CANCER GENETICS, INC.       2008       93253
## 57                            CAPTOZYME, LLC       2014     1008124
## 153                           CAPTOZYME, LLC       2010      250772
## 219           CATHAROS MEDICAL SYSTEMS, INC.       2009      152729
## 30                      CELDARA MEDICAL, LLC       2015     1478801
## 58             CELL AND TISSUE SYSTEMS, INC.       2005     1005430
## 90             CELL AND TISSUE SYSTEMS, INC.       2007      745872
## 201            CELL AND TISSUE SYSTEMS, INC.       2010      189552
## 215            CELL AND TISSUE SYSTEMS, INC.       2006      161977
## 205                      CELSION CORPORATION       2010      182906
## 211                  CHEN LABORATORIES, INC.       2002      169571
## 311               Chi's Research Corporation       2005       69060
## 230         CHILDREN'S SPECIALTY GROUP, PLLC       2016      149930
## 155              CHIMERIC TECHNOLOGIES, INC.       2006      240800
## 109                            CIENCIA, INC.       2007      504097
## 209                           CISTHERA, INC.       2008      177880
## 43                    CLINICAL SENSORS, INC.       2015     1296237
## 297       CLINICIAN SUPPORT TECHNOLOGY, INC.       2002       99824
## 165               COGNIZANCE BIOMARKERS, LLC       2015      225000
## 273           COMPACT MEMBRANE SYSTEMS, INC.       1999      100000
## 264             COSTELLO PHARMACEUTICAL, LLC       2008      100682
## 106                              Creare Inc.       2004      591264
## 49                              CREARE, INC.       2010     1200580
## 242                             CREARE, INC.       2008      140318
## 295                   CRO LABORATORIES, INC.       2011       99978
## 77                             CULMINI, INC.       2009      837226
## 238                            CULMINI, INC.       2007      146051
## 231                         DIABETOMICS, LLC       2010      149822
## 312                         DiagXotics, Inc.       1998       65000
## 65                  DIAPIN THERAPEUTICS, LLC       2015      990902
## 25                     DISCOVERYBIOMED, INC.       2015     1613420
## 52                     DISCOVERYBIOMED, INC.       2014     1135118
## 120                    DISCOVERYBIOMED, INC.       2013      436560
## 127                    DISCOVERYBIOMED, INC.       2016      366185
## 54                      DISCOVERYBIOMED, LLC       2009     1068326
## 189                     DISCOVERYBIOMED, LLC       <NA>      200000
## 274                     DISCOVERYBIOMED, LLC       2008      100000
## 85                              DUOPHOS, LLC       2014      751950
## 86                           DZYMETECH, INC.       2008      750000
## 294                          DZYMETECH, INC.       <NA>       99986
## 101                         ELECTROZYME, LLC       2014      600000
## 173                              Embolx Inc.       2014      224940
## 302       EMPIRICAL TECHNOLOGIES CORPORATION       2007       99634
## 198                    EMV TECHNOLOGIES, LLC       <NA>      194032
## 203               ENABLE MEDICAL CORPORATION       2005      185856
## 68                         ENDOPROTECH, INC.       2008      963666
## 321                          Enig Assocs Inc       1990       49947
## 80                              ENSION, INC.       2005      825271
## 32                  EPIGEN BIOSCIENCES, INC.       2014     1453632
## 161                 EPIGEN BIOSCIENCES, INC.       2015      228661
## 310                         Epigenesis, Inc.       1994       75000
## 138                     EUNOIA BIO TECH, LLC       2016      299940
## 157                   EXEMPLAR GENETICS, LLC       2014      238920
## 23                             EXOCELL, INC.       2006     1770940
## 296                            EXOCELL, INC.       1998       99839
## 29                   EXPRESSION THERAPEUTICS       2014     1483531
## 135                 EXTEND BIOSCIENCES, INC.       2015      306738
## 73                FILTRATION SOLUTIONS, INC.       2008      879826
## 275                            GCAT SCIENCES       2005      100000
## 9                    GENERATION BIOTECH, LLC       2004     2777170
## 307                          GENOGNOMON, LLC       <NA>       91142
## 317                             Genzyme Corp       1986       50000
## 313                           Genzyme Corpon       1983       61898
## 318                                Giner Inc       1987       50000
## 12                               GINER, INC.       2015     2179171
## 26                               GINER, INC.       2010     1610840
## 87                       GlucoSentient, Inc.       2013      750000
## 10         GREAT LAKES PHARMACEUTICALS, INC.       2009     2618970
## 276        GREAT LAKES PHARMACEUTICALS, INC.       2008      100000
## 319                    Guild Associates Inc.       1984       50000
## 261           GUILFORD PHARMACEUTICALS, INC.       2005      106742
## 166          HEALTH BEHAVIOR SOLUTIONS, INC.       2016      225000
## 139              HEALTHSPAN DIAGNOSTICS, LLC       2015      299648
## 254              HEALTHSPAN DIAGNOSTICS, LLC       2014      121635
## 277                HEALTHSPAN SOLUTIONS, LLC       2009      100000
## 74        HILLHURST BIOPHARMACEUTICALS, INC.       2016      862618
## 213                   IGAN BIOSCIENCES, INC.       2010      166180
## 20                            IMMUNEXT, INC.       2014     1949257
## 199                       IMMUNOMEDICS, INC.       <NA>      192688
## 7                              INCOGEN, INC.       2008     2959990
## 78                        INDIANA UNIVERSITY       2010      836167
## 300                   Infoscitex Corporation       2010       99666
## 140                   INFOSCITEX CORPORATION       <NA>      297113
## 255                           INNATE BIOTECH       2007      121062
## 222                   INNAVASC MEDICAL, INC.       2016      150000
## 167                      Innoblative Designs       2016      225000
## 72             INNOVATIVE BIOTHERAPIES, INC.       2015      912516
## 154            INNOVATIVE BIOTHERAPIES, INC.       2007      249999
## 246            INNOVATIVE BIOTHERAPIES, INC.       2008      137388
## 241   INNOVATIVE CHEMICAL/ENVIRONMENTAL TECH       2013      141561
## 278                            INPHOTON, LLC       2007      100000
## 279                        INSIGHT MAGNETICS       2010      100000
## 178      INTEGRATED ONCOLOGY SOLUTIONS, INC.       2009      222572
## 204                         IRIS MEDIA, INC.       2013      184355
## 5                             ISOGENIS, INC.       2006     2996220
## 128                 JOHNS HOPKINS UNIVERSITY       2010      365333
## 142             JORTAN PHARMACEUTICALS, INC.       2015      295597
## 168            KARYOPHARM THERAPEUTICS, INC.       2016      225000
## 67                       KIBOW BIOTECH, INC.       2003      976056
## 280                      KIBOW BIOTECH, INC.       2002      100000
## 171                             KINETA, INC.       2016      224977
## 181                              KYPHA, INC.       2016      218241
## 149                      L2 DIAGNOSTICS, LLC       2007      277711
## 51                LASER TISSUE WELDING, INC.       2010     1145700
## 112               LASER TISSUE WELDING, INC.       2016      500000
## 216               LASER TISSUE WELDING, INC.       2006      161789
## 76                     LITHOLINK CORPORATION       2006      838517
## 89                     LITHOLINK CORPORATION       2002      749803
## 190                    LITHOLINK CORPORATION       2005      200000
## 281                    LITHOLINK CORPORATION       2001      100000
## 282                    LITHOLINK CORPORATION       2004      100000
## 244                 LPATH THERAPEUTICS, INC.       2009      139523
## 196                       LUMEN THERAPEUTICS       <NA>      195859
## 66             Luna Innovations Incorporated       2015      986106
## 223            Luna Innovations Incorporated       2014      150000
## 192                   LUNA INNOVATIONS, INC.       2007      199970
## 110                           LYNNTECH, INC.       2007      501783
## 224                           LYNNTECH, INC.       2015      150000
## 239                           LYNNTECH, INC.       2005      145724
## 15           MADELEINE PHARMACEUTICALS, INC.       2016     1996767
## 177                   MAGNETIC INSIGHT, INC.       2015      223825
## 105           MASSACHUSETTS GENERAL HOSPITAL       2010      592083
## 200                                MC3, INC.       2009      189719
## 220                             MEDROS, INC.       2010      152114
## 250                             MEDROS, INC.       2009      136313
## 253       METABOLIC SOLUTIONS DEVELOPMENT CO       2014      121956
## 16                           MICRABLATE, LLC       2008     1995600
## 134                          MICRABLATE, LLC       2006      312802
## 11                          MICROBIOTIX, INC       2008     2200520
## 225                 MICROSONIC SYSTEMS, INC.       2015      150000
## 227                 MICROSONIC SYSTEMS, INC.       2016      149999
## 207      MINERVA BIOTECHNOLOGIES CORPORATION       2008      181320
## 71                         MIRIMEDICAL, LLC.       2009      916596
## 44                         MIRUS CORPORATION       2004     1260320
## 160                         MITOHEALTH, INC.       2014      232938
## 132                  MOLECULAR EXPRESS, INC.       2015      329911
## 221                  MOLECULAR EXPRESS, INC.       2013      150501
## 259              MOLECULAR INNOVATIONS, INC.       2010      112349
## 187  MOLECULAR INSIGHT PHARMACEUTICALS, INC.       2008      204351
## 249                    MOLECULAR LOGIX, INC.       2007      136332
## 245             MULTICELL TECHNOLOGIES, INC.       2005      137724
## 113                 Nano3D Biosciences, Inc.       2011      500000
## 60                            Nanohmics, Inc       2015      999999
## 228                           Nanohmics, Inc       2014      149955
## 193                         NANOPROBES, INC.       2008      199930
## 158               NEPHROPATHOLOGY ASSOCIATES       2004      237810
## 88                Nephros Therapeutics, Inc.       1996      750000
## 283               Nephros Therapeutics, Inc.       1995      100000
## 125              NEUROX PHARMACEUTICALS, LLC       2007      382084
## 208                  NORTHWIND MEDICAL, INC.       2016      179155
## 4                             NOVATARG, INC.       2015     3223377
## 33               NOVELMED THERAPEUTICS, INC.       2014     1451573
## 50               NOVELMED THERAPEUTICS, INC.       2015     1159286
## 137              NOVELMED THERAPEUTICS, INC.       2010      300000
## 159              NOVELMED THERAPEUTICS, INC.       2009      233538
## 116             NOVOPHAGE THERAPEUTICS, INC.       2015      450000
## 164                 OCATA THERAPEUTICS, INC.       2015      225639
## 284                            OCEANIT, INC.       2007      100000
## 169                       Omega Optics, Inc.       2015      225000
## 195                       OMEROS CORPORATION       2010      198383
## 99                            OMNEURON, INC.       2013      639646
## 235                    ONE CELL SYSTEMS, INC       2007      148009
## 63      OPERATIONAL TECHNOLOGIES CORPORATION       2015      999469
## 133                 ORPHAGEN PHARMACEUTICALS       2015      325051
## 176            PACIFIC DIABETES TECHNOLOGIES       2016      224150
## 118                  PANORAMA RESEARCH, INC.       2015      448420
## 175                  PANORAMA RESEARCH, INC.       2014      224243
## 194                  PANORAMA RESEARCH, INC.       2010      199800
## 234             Pharmaco-Kinesis Corporation       2014      148573
## 14                   PHARMACOPHOTONICS, INC.       2015     1999106
## 61                    PHARMACOPHOTONICS, LLC       2009      999981
## 263                   PHARMACOPHOTONICS, LLC       2008      103740
## 102                     PHARMAIN CORPORATION       2009      600000
## 218                     PHARMAIN CORPORATION       2010      160363
## 124     PHOENIX SCIENCE AND TECHNOLOGY, INC.       2007      385857
## 304     PHOENIX SCIENCE AND TECHNOLOGY, INC.       2006       98735
## 305     PHOENIX SCIENCE AND TECHNOLOGY, INC.       2010       98166
## 212           PHYLONIX PHARMACEUTICALS, INC.       2006      168689
## 229              Physical Optics Corporation       2014      149948
## 163                  Physical Sciences, Inc.       1987      226000
## 324                  Physical Sciences, Inc.       1986       48000
## 62                       PLUREON CORPORATION       <NA>      999977
## 36                            PLUROMED, INC.       2009     1433838
## 298                           PLUROMED, INC.       2007       99820
## 108                    PNA INNOVATIONS, INC.       2013      540554
## 55                PREVENTAGE HEALTHCARE, LLC       2015     1061369
## 13                   PRIVO TECHNOLOGIES, LLC       2016     2017564
## 93                            PROBETEX, INC.       2009      716872
## 94                            PROBETEX, INC.       2006      688614
## 232                           PROBETEX, INC.       2014      149212
## 233                           PROBETEX, INC.       2007      148785
## 285                           PROBETEX, INC.       2004      100000
## 145              PROFECTUS BIOSCIENCES, INC.       2008      293564
## 184              PROFECTUS BIOSCIENCES, INC.       2007      215170
## 96                            PROGENRA, INC.       2007      650617
## 42                          PROTEOTECH, INC.       2008     1330460
## 152                         PROTEOTECH, INC.       2004      264984
## 131                          PULMOKINE, INC.       2016      337324
## 35                       QUALITYMETRIC, INC.       2006     1435150
## 286                      QUALITYMETRIC, INC.       2002      100000
## 251       RADIATION MONITORING DEVICES, INC.       2008      135000
## 45                RADIKAL THERAPEUTICS, INC.       2016     1248631
## 129                      RECOMBINETICS, INC.       2014      352419
## 119                           REGENEREX, LLC       <NA>      447862
## 320           Research & Diagnostic Antibodi       1986       50000
## 48                    ROCHAL INDUSTRIES, LLP       2014     1202986
## 180                ROSELLINI SCIENTIFIC, LLC       2015      218377
## 262               RULES-BASED MEDICINE, INC.       2009      104265
## 287               RULES-BASED MEDICINE, INC.       2010      100000
## 170                            Sanguina, LLC       2015      225000
## 143                      SANO CHEMICALS, INC       2016      295381
## 260                   SAPIENT DISCOVERY, LLC       2007      106981
## 17              SARFEZ PHARMACEUTICALS, INC.       2015     1987476
## 59                      SCARAB GENOMICS, LLC       2006     1000000
## 56               SCARLESS LABORATORIES, INC.       2015     1020109
## 123              SCARLESS LABORATORIES, INC.       2014      396771
## 151                         SCHNELLGEN, INC.       2010      269288
## 322           Seattle Silicon Technology, In       1985       49760
## 6              SENTIEN BIOTECHNOLOGIES, INC.       2014     2985949
## 107            SENTIEN BIOTECHNOLOGIES, INC.       2010      565011
## 19                                   SEQUELA       2015     1954329
## 24                                   SEQUELA       2012     1675105
## 104                                  SEQUELA       2010      592427
## 121                                  SEQUELA       2005      403642
## 226                       Silicon Kidney LLC       2014      150000
## 117                      SILICON KIDNEY, LLC       2014      449519
## 288                              SimpleWater       2014      100000
## 256                           SOCRATECH, LLC       2008      120636
## 18                          SONOMOTION, INC.       2016     1956776
## 303                 SOUTHWEST SCIENCES, INC.       2007       99000
## 27                          SPECTRADYNE, LLC       2015     1512193
## 289                      SPECTRASONICS, INC.       2007      100000
## 64                         SPIRE CORPORATION       2008      992385
## 162                          STATEGICS, INC.       2013      227624
## 257                    STEMCOR SYSTEMS, INC.       2008      115516
## 183                             STEMMED, LTD       2016      215557
## 174                     Symic Biomedical Inc       2014      224561
## 31                    SYMIC BIOMEDICAL, INC.       2015     1466956
## 114             SYNERGENE THERAPEUTICS, INC.       <NA>      478857
## 91                           SYNTHECON, INC.       2008      737846
## 290                    Tandem Scanning Corp.       1998      100000
## 38                             TARGESON, LLC       2011     1338742
## 214                            TARGESON, LLC       2009      166046
## 258                             TARTIS, INC.       2010      112885
## 28           THERAGNOSTIC TECHNOLOGIES, INC.       2015     1488964
## 83                          THERASOURCE, LLC       2016      762935
## 34                          THERMIMAGE, INC.       2015     1444877
## 172                          TOMEGAVAX, INC.       2016      224959
## 79                        TRIM-EDICINE, INC.       2016      833693
## 21                        TWIN STAR TDS, LLC       2013     1904313
## 148            University Medical Associates       1988      283000
## 323            University Medical Associates       1986       49000
## 84                    UNIVERSITY OF KENTUCKY       2010      760562
## 146                UROLOGY DIAGNOSTICS, INC.       2016      291776
## 53                            VASCULOX, INC.       2013     1131763
## 150                           VASCULOX, INC.       2011      276232
## 188                           VASCULOX, INC.       2009      203191
## 240               VAXIION THERAPEUTICS, INC.       2013      144103
## 179                            VIDASYM, INC.       2011      219123
## 182                            VIDASYM, INC.       2012      217354
## 248                   VIROTECH INTERNATIONAL       2006      137150
## 82               VISIONQUEST BIOMEDICAL, LLC       2016      794688
## 185              VISIONQUEST BIOMEDICAL, LLC       2015      211067
## 40                              VISONEX, LLC       2009     1332670
## 130                             VISONEX, LLC       2008      337402
## 210                            VISOTEK, INC.       2010      175785
## 291                    VISTA PHOTONICS, INC.       2008      100000
## 326                               Vitor Inc.       1983       20000
## 247                           VIVONICS, INC.       2016      137170
## 81                    WAKE FOREST UNIVERSITY       2010      813754
## 197                    WASHINGTON UNIVERSITY       2010      194509
## 308                           Wellport, Inc.       1995       90000
## 103              X-RAY OPTICAL SYSTEMS, INC.       2007      592744
## 191              X-RAY OPTICAL SYSTEMS, INC.       <NA>      199977
## 202           ZACHARON PHARMACEUTICALS, INC.       2008      188112

Plot amounts awarded to R&D proposals by year

USD in log unit vs year

ggplot(data,aes(Award.Year, log10(Award.Amount), color=Agency)) +geom_point()