## 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
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)
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"
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
USD in log unit vs year
ggplot(data,aes(Award.Year, log10(Award.Amount), color=Agency)) +geom_point()