## LIST NUMBER OF TABLES IN DATABASE
dbListTables(NRAFDB)
## [1] "CenterFunding" "Cost" "GoogleScholar"
## [4] "GovermentFunding" "NARFCategorizations" "Organizations"
## [7] "PUBMED" "Patents" "ProjectPersonInCharge"
## [10] "Projects" "Publications" "PublicationsLinks"
## [13] "SubProject" "sqlite_sequence"
CONCLUSION : QUERY FOR NEW COMERS FOR
THE CURRENT DATABASE SO THAT THEY CAN HAVE IDEA ON EXISTING DATABASE.
/*NUMBER OF PROJECTS IN THIS DATABASE*/
Select count(ProjectID) as NumOfProjects from Projects
| NumOfProjects |
|---|
| 100 |
/*FUNDING GIVEN FOR EACH PROJECT*/
Select APPLICATIONID, SPENDINGCATEGORY, OrganizationName, FUNDINGMECHANISM, TOTALCOSTIC, DIRECTCOSTIC, INDIRECTCOSTIC
FROM NARFCATEGORIZATIONS
INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.OrganizationID = NarfCategorizations.OrganizationID
INNER JOIN GovermentFunding ON GovermentFunding.FundingID = Organizations.FundingID
INNER JOIN Cost ON Cost.FundingID = GovermentFunding.FundingID
| ApplicationID | SpendingCategory | OrganizationName | FundingMechanism | TotalCostIC | DirectCostIC | IndirectCostIC |
|---|---|---|---|---|---|---|
| 9685926 | Bioengineering; Biotechnology; Cardiovascular; Heart Disease; Heart Disease - Coronary Heart Disease; Regenerative Medicine; Stem Cell Research; Stem Cell Research - Induced Pluripotent Stem Cell; Stem Cell Research - Induced Pluripotent Stem Cell - Human; Transplantation | UNIVERSITY OF SOUTHERN CALIFORNIA | Non-SBIR/STTR | $432,737.00 | $262,265.00 | $170,472.00 |
| 9686491 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Bioengineering; Biomedical Imaging; Brain Disorders; Dementia; Machine Learning and Artificial Intelligence; Networking and Information Technology R&D (NITRD); Neurodegenerative; Neurosciences; Prevention | MAYO CLINIC ROCHESTER | Non-SBIR/STTR | $419,836.00 | $270,000.00 | $149,836.00 |
| 9686346 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Brain Disorders; Dementia; Neurodegenerative; Neurosciences | STATE UNIVERSITY NEW YORK STONY BROOK | Non-SBIR/STTR | $465,779.00 | $296,065.00 | $169,714.00 |
| 9686261 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Brain Disorders; Dementia; Neurodegenerative; Neurosciences | METHODIST HOSPITAL RESEARCH INSTITUTE | Non-SBIR/STTR | $344,594.00 | $232,969.00 | $111,625.00 |
| 9686204 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease Related Dementias (ADRD); Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Brain Disorders; Dementia; Genetics; Lewy Body Dementia; Neurodegenerative; Neurosciences; Parkinson’s Disease; Stem Cell Research; Stem Cell Research - Induced Pluripotent Stem Cell; Stem Cell Research - Induced Pluripotent Stem Cell - Human | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | Non-SBIR/STTR | $742,927.00 | $933,700.00 | $343,839.00 |
| 9685862 | Biotechnology; Breast Cancer; Cancer; Genetics; Radiation Oncology; Women’s Health | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $585,477.00 | $589,048.00 | $162,352.00 |
| 9685843 | Aging; Clinical Research; Clinical Trials and Supportive Activities; Estrogen; Patient Safety; Women’s Health | UNIVERSITY OF DELAWARE | Non-SBIR/STTR | $645,425.00 | $516,405.00 | $129,020.00 |
| 9685264 | Aging; Bioengineering; Clinical Research; Clinical Trials and Supportive Activities; Health Disparities; Health Services; Minority Health; Networking and Information Technology R&D (NITRD) | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | Research Centers | $5,133,391.00 | $3,666,560.00 | $2,446,919.00 |
| 9685241 | Bioengineering; Biomedical Imaging; Cardiovascular; Clinical Research; Heart Disease; Heart Disease - Coronary Heart Disease; Kidney Disease; Women’s Health | NORTHWESTERN UNIVERSITY | Non-SBIR/STTR | $598,589.00 | $522,024.00 | $76,565.00 |
| 9684598 | Behavioral and Social Science; Clinical Research; Clinical Trials and Supportive Activities; Comparative Effectiveness Research; Drug Abuse (NIDA only); HIV/AIDS; Health Disparities; Infectious Diseases; Minority Health; Prevention; Sexually Transmitted Infections; Substance Abuse; Women’s Health | WAKE FOREST UNIVERSITY HEALTH SCIENCES | Non-SBIR/STTR | $450,548.00 | $303,130.00 | $147,418.00 |
| 9683870 | Basic Behavioral and Social Science; Behavioral and Social Science; Biomedical Imaging; Brain Disorders; Clinical Research; Drug Abuse (NIDA only); Health Disparities; Mental Health; Minority Health; Neurosciences; Pediatric; Prevention; Substance Abuse; Women’s Health | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | Non-SBIR/STTR | $193,334.00 | $125,000.00 | $68,334.00 |
| 9684057 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Biotechnology; Brain Disorders; Clinical Research; Dementia; Neurodegenerative; Neurosciences; Prevention | HARVARD MEDICAL SCHOOL | Non-SBIR/STTR | $3,463,224.00 | $3,065,681.00 | $397,543.00 |
| 9681497 | Autoimmune Disease; Genetics; Lung; Orphan Drug; Rare Diseases | HUDSON-ALPHA INSTITUTE FOR BIOTECHNOLOGY | Other | $6,999,491.00 | $5,627,051.00 | $1,372,440.00 |
| 9681492 | Cardiovascular; Clinical Research; Clinical Trials and Supportive Activities; Health Disparities; Minority Health; Physical Activity; Physical Rehabilitation; Prevention; Rehabilitation; Women’s Health | COLORADO SCHOOL OF MINES | Non-SBIR/STTR | $188,190.00 | $160,954.00 | $27,236.00 |
| 9681487 | Assistive Technology; Bioengineering; Biotechnology; Cardiovascular; Transplantation | UNIVERSITY OF WYOMING | Non-SBIR/STTR | $733,243.00 | $593,369.00 | $139,874.00 |
| 9682449 | Biotechnology; Cancer; Digestive Diseases; Genetics; Orphan Drug; Pancreatic Cancer; Rare Diseases | PURDUE UNIVERSITY | Non-SBIR/STTR | $187,994.00 | $125,000.00 | $62,994.00 |
| 9682434 | No NIH Category available | SYNFONICA, LLC | SBIR/STTR | $492,816.00 | ||
| 9682430 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Behavioral and Social Science; Brain Disorders; Clinical Research; Dementia; Health Services; Machine Learning and Artificial Intelligence; Neurodegenerative; Neurosciences; Prevention | BIOINCEPT, LLC | SBIR/STTR | $207,237.00 | ||
| 9680693 | Bioengineering; Cancer; Digestive Diseases; Liver Cancer; Liver Disease; Nanotechnology; Orphan Drug; Rare Diseases | NORTHWESTERN UNIVERSITY AT CHICAGO | Non-SBIR/STTR | $713,702.00 | $553,659.00 | $257,160.00 |
| 9678955 | Biodefense; Digestive Diseases; Emerging Infectious Diseases; Infectious Diseases | AEON IMAGING, LLC | SBIR/STTR | $490,002.00 | ||
| 9678336 | Bioengineering; Biotechnology; Cancer; Clinical Research; Clinical Trials and Supportive Activities; Digestive Diseases; Genetics; Orphan Drug; Pancreatic Cancer; Precision Medicine; Radiation Oncology; Rare Diseases | UNIVERSITY OF KENTUCKY | Other Research-Related | $557,910.00 | $438,764.00 | $119,146.00 |
| 9676986 | Biotechnology; Genetics; Regenerative Medicine; Stem Cell Research; Stem Cell Research - Nonembryonic - Non-Human | MEDICAL COLLEGE OF WISCONSIN | Non-SBIR/STTR | $341,706.00 | $221,887.00 | $119,819.00 |
| 9676967 | Biotechnology; Cardiovascular; Gene Therapy; Genetics; Heart Disease | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $405,000.00 | $250,000.00 | $155,000.00 |
| 9676963 | American Indian or Alaska Native; Clinical Research; Clinical Trials and Supportive Activities; Foodborne Illness; Health Disparities; Minority Health; Prevention; Rural Health | UNIV OF NORTH CAROLINA CHAPEL HILL | Non-SBIR/STTR | $657,518.00 | $523,656.00 | $133,862.00 |
| 9676333 | American Indian or Alaska Native; Behavioral and Social Science; Clinical Research; Clinical Trials and Supportive Activities; Health Disparities; Health Services; Minority Health; Nutrition; Prevention; Rural Health; Women’s Health | UNIVERSITY OF ROCHESTER | Non-SBIR/STTR | $679,709.00 | $442,807.00 | $236,902.00 |
| 9675317 | Biomedical Imaging; Infant Mortality; Lung; Neurosciences; Pediatric; Perinatal Period - Conditions Originating in Perinatal Period; Rare Diseases; Sleep Research; Sudden Infant Death Syndrome | UNIV OF NORTH CAROLINA CHAPEL HILL | Non-SBIR/STTR | $350,863.00 | $230,831.00 | $120,032.00 |
| 9670146 | Bioengineering; Biotechnology; Genetics; Human Genome; Precision Medicine; Prevention | TULANE UNIVERSITY OF LOUISIANA | Non-SBIR/STTR | $287,428.00 | $240,403.00 | $47,025.00 |
| 9670720 | Biodefense; Biotechnology; Emerging Infectious Diseases; Immunotherapy; Infectious Diseases | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $311,850.00 | $192,500.00 | $119,350.00 |
| 9671384 | Basic Behavioral and Social Science; Behavioral and Social Science; Brain Disorders; Child Abuse and Neglect Research; Drug Abuse (NIDA only); Genetics; Injury (total) Accidents/Adverse Effects; Injury - Childhood Injuries; Mental Health; Neurosciences; Pediatric; Substance Abuse; Violence Research | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | Non-SBIR/STTR | $396,250.00 | $250,000.00 | $146,250.00 |
| 9669105 | Acquired Cognitive Impairment; Autism; Basic Behavioral and Social Science; Behavioral and Social Science; Brain Disorders; Clinical Research; Clinical Trials and Supportive Activities; Intellectual and Developmental Disabilities (IDD); Mental Health; Neurosciences; Prevention; Rehabilitation | COLUMBIA UNIVERSITY HEALTH SCIENCES | Non-SBIR/STTR | $421,462.00 | $260,162.00 | $161,300.00 |
| 9668128 | Assistive Technology; Behavioral and Social Science; Bioengineering; Clinical Research; Rehabilitation | VAJRA INSTRUMENTS, INC. | SBIR/STTR | $999,597.00 | ||
| 9668083 | Biotechnology; Breast Cancer; Cancer; Cancer Genomics; Genetics; Human Genome; Prevention; Women’s Health | UNIVERSITY OF NEBRASKA MEDICAL CENTER | Non-SBIR/STTR | $81,864.00 | $53,681.00 | $28,183.00 |
| 9667414 | Behavioral and Social Science; Brain Disorders; Clinical Research; Drug Abuse (NIDA only); Neurosciences; Prevention; Substance Abuse; Tobacco; Tobacco Smoke and Health; Women’s Health | SLOAN-KETTERING INST CAN RESEARCH | Non-SBIR/STTR | $480,567.00 | $296,750.00 | $183,817.00 |
| 9666923 | Autoimmune Disease; Clinical Research; Kidney Disease; Rare Diseases | HARVARD SCHOOL OF PUBLIC HEALTH | Non-SBIR/STTR | $884,756.00 | $896,558.00 | $150,424.00 |
| 9665596 | Cardiovascular; Clinical Research; Clinical Trials and Supportive Activities; Hypertension; Neurosciences; Nutrition; Women’s Health | MASSACHUSETTS GENERAL HOSPITAL | Other Research-Related | $199,040.00 | $184,000.00 | $15,040.00 |
| 9664515 | Biotechnology; Cancer; Cervical Cancer; Genetics; Infectious Diseases; Sexually Transmitted Infections; Women’s Health | UNIVERSITY OF MICHIGAN AT ANN ARBOR | Non-SBIR/STTR | $678,076.00 | $875,307.00 | $402,474.00 |
| 9663980 | Biotechnology; Contraception/Reproduction; Infertility; Regenerative Medicine; Stem Cell Research; Stem Cell Research - Induced Pluripotent Stem Cell; Stem Cell Research - Induced Pluripotent Stem Cell - Human; Stem Cell Research - Induced Pluripotent Stem Cell - Non-Human; Stem Cell Research - Nonembryonic - Human; Transplantation | UNIV OF NORTH CAROLINA CHAPEL HILL | Non-SBIR/STTR | $1.00 | $756,505.00 | $320,841.00 |
| 9663286 | Basic Behavioral and Social Science; Behavioral and Social Science; Biomedical Imaging; Brain Disorders; Clinical Research; Drug Abuse (NIDA only); Neurosciences; Substance Abuse | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | Non-SBIR/STTR | $410,250.00 | $361,055.00 | $49,195.00 |
| 9663338 | Behavioral and Social Science; Cardiovascular; Clinical Research; Clinical Trials and Supportive Activities; Comparative Effectiveness Research; Diabetes; Health Disparities; Health Services; Minority Health; Nutrition; Obesity; Physical Activity; Prevention; Women’s Health | UNIVERSITY OF NEW MEXICO HEALTH SCIS CTR | Non-SBIR/STTR | $479,541.00 | $371,960.00 | $107,581.00 |
| 9663328 | Brain Disorders; Depression; Digestive Diseases; Genetics; Human Genome; Liver Disease; Major Depressive Disorder; Mental Health; Mental Illness; Precision Medicine | HENRY M. JACKSON FDN FOR THE ADV MIL/MED | Non-SBIR/STTR | $358,309.00 | $230,000.00 | $128,309.00 |
| 9663312 | Climate-Related Exposures and Conditions; Clinical Research; Health Effects of Indoor Air Pollution; Lung; Microbiome | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | Non-SBIR/STTR | $237,900.00 | $150,000.00 | $87,900.00 |
| 9695191 | Adolescent Sexual Activity; Behavioral and Social Science; Clinical Research; Clinical Trials and Supportive Activities; Cost Effectiveness Research; Drug Abuse (NIDA only); HIV/AIDS; Health Disparities; Health Services; Infectious Diseases; Minority Health; Pediatric; Pediatric Research Initiative; Prevention; Sexual and Gender Minorities (SGM/LGBT*); Substance Abuse | UNIVERSITY OF TEXAS SAN ANTONIO | Other Research-Related | $147,000.00 | $100,000.00 | $47,000.00 |
| 9695174 | Behavioral and Social Science; Cancer; Clinical Research; Clinical Trials and Supportive Activities; Complementary and Integrative Health; Mental Health; Mind and Body; Physical Activity; Prevention; Rehabilitation; Sleep Research | CHILDREN’S MERCY HOSP (KANSAS CITY, MO) | Non-SBIR/STTR | $665,791.00 | $536,726.00 | $129,065.00 |
| 9694747 | Biomedical Imaging; Clinical Research; Emerging Infectious Diseases; Health Disparities; Infectious Diseases; Minority Health; Neurosciences; Rare Diseases; Vector-Borne Diseases | MARYMOUNT UNIVERSITY | Non-SBIR/STTR | $40,169.00 | $26,977.00 | $13,192.00 |
| 9694737 | Clinical Research; Health Disparities; Health Services; Minority Health; Prevention | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | Non-SBIR/STTR | $604,408.00 | $409,828.00 | $194,580.00 |
| 9695046 | Bioengineering; Biotechnology; Injury (total) Accidents/Adverse Effects; Injury - Childhood Injuries; Pediatric; Prevention; Regenerative Medicine; Stem Cell Research; Stem Cell Research - Nonembryonic - Human | ARIZONA STATE UNIVERSITY-TEMPE CAMPUS | Non-SBIR/STTR | $586,687.00 | $853,161.00 | $393,298.00 |
| 9695271 | Autism; Behavioral and Social Science; Brain Disorders; Clinical Research; Intellectual and Developmental Disabilities (IDD); Mental Health; Neurosciences; Pediatric | UNIVERSITY OF OKLAHOMA HLTH SCIENCES CTR | Non-SBIR/STTR | $332,649.00 | $243,447.00 | $89,202.00 |
| 9694569 | No NIH Category available | CENTRE FOR ADDICTION AND MENTAL HEALTH | Non-SBIR/STTR | $149,604.00 | $138,522.00 | $11,082.00 |
| 9694201 | Behavioral and Social Science; Chronic Pain; Clinical Research; Clinical Trials and Supportive Activities; Diabetes; Neurodegenerative; Neurosciences; Obesity; Pain Research; Peripheral Neuropathy; Physical Activity; Prevention; Women’s Health | MASSACHUSETTS GENERAL HOSPITAL | Non-SBIR/STTR | $214,380.00 | $159,018.00 | $55,362.00 |
| 9693111 | Aging; Assistive Technology; Behavioral and Social Science; Bioengineering; Clinical Research; Clinical Trials and Supportive Activities; Complementary and Integrative Health; Neurosciences; Physical Activity; Physical Rehabilitation; Rehabilitation | UNIVERSITY OF ALABAMA AT BIRMINGHAM | Non-SBIR/STTR | $367,500.00 | $250,000.00 | $117,500.00 |
| 9693243 | Cancer; Genetics | UNIVERSITY OF PENNSYLVANIA | Non-SBIR/STTR | $430,558.00 | $282,980.00 | $147,578.00 |
| 9693239 | Climate-Related Exposures and Conditions; Diabetes; Genetics; Human Genome; Nutrition; Obesity; Prevention | UNIVERSITY OF EAST ANGLIA | Non-SBIR/STTR | $292,330.00 | $270,676.00 | $21,654.00 |
| 9692545 | Behavioral and Social Science; Brain Disorders; Chronic Pain; Clinical Research; Clinical Trials and Supportive Activities; Complementary and Integrative Health; Drug Abuse (NIDA only); Health Disparities; Mental Health; Mental Illness; Mind and Body; Minority Health; Opioid Misuse and Addiction; Opioids; Pain Research; Prescription Drug Abuse; Rehabilitation; Substance Abuse; Women’s Health | NEW YORK STATE PSYCHIATRIC INSTITUTE | Non-SBIR/STTR | $637,556.00 | $399,955.00 | $237,601.00 |
| 9692473 | Aging; Behavioral and Social Science; Cardiovascular; Clinical Research; Diabetes; Heart Disease; Nutrition; Prevention; Women’s Health | EMORY UNIVERSITY | Non-SBIR/STTR | $383,053.00 | $260,566.00 | $122,487.00 |
| 9692070 | Genetics | UNIVERSITY OF TEXAS, AUSTIN | Non-SBIR/STTR | $475,266.00 | $375,094.00 | $100,172.00 |
| 9691969 | Cardiovascular; Genetics; Heart Disease; Heart Disease - Coronary Heart Disease; Hematology; Human Genome; Hypertension | WAYNE STATE UNIVERSITY | Non-SBIR/STTR | $385,000.00 | $250,000.00 | $135,000.00 |
| 9691378 | Biomedical Imaging; Diabetes; Eye Disease and Disorders of Vision; Neurodegenerative; Neurosciences; Rare Diseases | UNIVERSITY OF LOUISVILLE | Non-SBIR/STTR | $192,500.00 | $125,000.00 | $67,500.00 |
| 9691451 | Basic Behavioral and Social Science; Behavioral and Social Science; Clinical Research; Health Disparities; Minority Health; Neurosciences | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | Non-SBIR/STTR | $537,166.00 | $346,473.00 | $190,693.00 |
| 9691150 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Behavioral and Social Science; Brain Disorders; Clinical Research; Clinical Trials and Supportive Activities; Complementary and Integrative Health; Dementia; Depression; Health Disparities; Health Services; Mental Health; Neurodegenerative; Neurosciences; Women’s Health | UNIVERSITY OF CALIFORNIA, SAN DIEGO | Non-SBIR/STTR | $624,292.00 | $436,059.00 | $188,233.00 |
| 9691083 | Alcoholism, Alcohol Use and Health; Basic Behavioral and Social Science; Behavioral and Social Science; Brain Disorders; Clinical Research; Clinical Trials and Supportive Activities; Health Disparities; Minority Health; Neurosciences; Precision Medicine; Substance Abuse; Women’s Health | UNIVERSITY OF DELAWARE | Non-SBIR/STTR | $237,339.00 | $155,526.00 | $81,813.00 |
| 9690832 | Clinical Research; Emergency Care; Health Services; Women’s Health | UNIVERSITY OF MICHIGAN AT ANN ARBOR | Non-SBIR/STTR | $682,257.00 | $461,761.00 | $220,496.00 |
| 9690827 | Cancer; Childhood Leukemia; Clinical Research; Clinical Trials and Supportive Activities; Genetics; Hematology; Pediatric; Pediatric Cancer; Rare Diseases; Stem Cell Research; Stem Cell Research - Nonembryonic - Human; Transplantation; Women’s Health | STATE UNIVERSITY NEW YORK STONY BROOK | Non-SBIR/STTR | $395,000.00 | $250,000.00 | $145,000.00 |
| 9690686 | Behavioral and Social Science; Brain Disorders; Cardiovascular; Clinical Research; Clinical Trials and Supportive Activities; Diabetes; Health Disparities; Mental Health; Mental Illness; Minority Health; Nutrition; Obesity; Prevention; Schizophrenia; Serious Mental Illness; Women’s Health | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $635,267.00 | $668,998.00 | $387,128.00 |
| 9690448 | Congenital Structural Anomalies; Dental/Oral and Craniofacial Disease; Pediatric; Stem Cell Research; Stem Cell Research - Nonembryonic - Non-Human | UNIV OF MASSACHUSETTS MED SCH WORCESTER | Non-SBIR/STTR | $721,436.00 | $430,708.00 | $290,728.00 |
| 9613793 | Cancer; Colo-Rectal Cancer; Digestive Diseases; Emerging Infectious Diseases; Genetics; Infectious Diseases; Nutrition; Prevention; Stem Cell Research; Stem Cell Research - Nonembryonic - Non-Human; Women’s Health | UNIVERSITY OF WASHINGTON | Other Research-Related | $161,884.00 | $149,900.00 | $11,984.00 |
| 9613790 | Bioengineering; Biomedical Imaging; Cancer; Clinical Research; Colo-Rectal Cancer; Digestive Diseases; Health Disparities; Minority Health; Pancreatic Cancer; Prevention; Rare Diseases | APDM, INC. | SBIR/STTR | $676,357.00 | ||
| 9610632 | Infectious Diseases | UNIVERSITY OF CALIFORNIA BERKELEY | Non-SBIR/STTR | $392,500.00 | $250,000.00 | $142,500.00 |
| 9608743 | Bioengineering; Cancer; Genetics; Nanotechnology | UNIVERSITY OF TEXAS MED BR GALVESTON | Non-SBIR/STTR | $3,532,750.00 | $2,248,680.00 | $1,284,070.00 |
| 9608036 | Cardiovascular; Heart Disease; Heart Disease - Coronary Heart Disease; Women’s Health | BRIGHAM AND WOMEN’S HOSPITAL | Non-SBIR/STTR | $653,228.00 | $592,483.00 | $60,745.00 |
| 9607605 | Genetics; Health Disparities; Human Genome; Minority Health | UNIVERSITY OF MINNESOTA | Non-SBIR/STTR | $313,573.00 | $221,887.00 | $91,686.00 |
| 9606509 | Anxiety Disorders; Basic Behavioral and Social Science; Behavioral and Social Science; Brain Disorders; Mental Health; Neurosciences; Post-Traumatic Stress Disorder (PTSD) | YALE UNIVERSITY | Non-SBIR/STTR | $183,750.00 | $125,000.00 | $58,750.00 |
| 9607110 | Bioengineering; Biotechnology; Clinical Research; Genetics; Human Genome; Women’s Health | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $2,318,900.00 | $3,530,479.00 | $787,589.00 |
| 9607110 | Bioengineering; Biotechnology; Clinical Research; Genetics; Human Genome; Women’s Health | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $364,500.00 | $225,000.00 | $139,500.00 |
| 9607082 | Neurosciences; Nutrition; Obesity | PENNSYLVANIA STATE UNIVERSITY-UNIV PARK | Non-SBIR/STTR | $353,700.00 | $225,000.00 | $128,700.00 |
| 9606367 | Bioengineering; Biomedical Imaging; Cancer; Dental/Oral and Craniofacial Disease; Health Disparities; Minority Health; Radiation Oncology; Rare Diseases | UNIVERSITY OF UTAH | Non-SBIR/STTR | $642,156.00 | $477,210.00 | $164,946.00 |
| 9605278 | Antimicrobial Resistance; Biodefense; Biotechnology; Emerging Infectious Diseases; Infectious Diseases; Neurosciences | UNIVERSITY OF CALIFORNIA LOS ANGELES | Non-SBIR/STTR | $429,000.00 | $275,000.00 | $154,000.00 |
| 9600071 | Dental/Oral and Craniofacial Disease; Diabetes | UNIVERSITY OF PUERTO RICO RIO PIEDRAS | Non-SBIR/STTR | $218,836.00 | $197,918.00 | $20,918.00 |
| 9601684 | Aging; Bioengineering; Congenital Structural Anomalies; Eye Disease and Disorders of Vision; Pediatric | NORTHWESTERN UNIVERSITY AT CHICAGO | Other Research-Related | $2,776,666.00 | $2,255,631.00 | $521,035.00 |
| 9745585 | Biotechnology; Clinical Research; Diabetes; Genetics; Nutrition; Obesity; Pediatric; Perinatal Period - Conditions Originating in Perinatal Period; Prevention; Women’s Health | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | Other Research-Related | $166,574.00 | $154,494.00 | $12,080.00 |
| 9745167 | Biotechnology; Clinical Research; Genetics; Health Services; Human Genome; Precision Medicine | UNIVERSITY OF ALABAMA AT BIRMINGHAM | Non-SBIR/STTR | $733,001.00 | $561,107.00 | $171,894.00 |
| 9744848 | Brain Disorders; Cerebrovascular; Clinical Research; Genetics; Neurodegenerative; Neurosciences; Orphan Drug; Pediatric; Prevention; Rare Diseases | UNIVERSITY OF KANSAS MEDICAL CENTER | Non-SBIR/STTR | $373,069.00 | $258,009.00 | $115,060.00 |
| 9744735 | Bioengineering; Biotechnology; Breast Cancer; Cancer; Health Disparities; Minority Health; Radiation Oncology; Women’s Health | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $459,386.00 | $283,572.00 | $175,814.00 |
| 9744550 | Aging; Behavioral and Social Science; Cardiovascular; Clinical Research; Clinical Trials and Supportive Activities; Heart Disease; Physical Activity; Prevention; Sleep Research | MASSACHUSETTS GENERAL HOSPITAL | Non-SBIR/STTR | $248,902.00 | $145,557.00 | $103,345.00 |
| 9744475 | Biotechnology; Clinical Research; Diabetes; Genetics; Health Disparities; Human Genome; Kidney Disease; Minority Health; Women’s Health | UNIVERSITY OF ALABAMA AT BIRMINGHAM | Non-SBIR/STTR | $352,112.00 | $246,822.00 | $105,290.00 |
| 9744254 | Brain Disorders; Clinical Research; Epilepsy; Neurodegenerative; Neurosciences; Pediatric; Rare Diseases | BROAD INSTITUTE, INC. | Research Centers | $2,108,141.00 | $1,895,344.00 | $212,797.00 |
| 9743883 | ALS; Brain Disorders; Genetics; Neurodegenerative; Neurosciences; Rare Diseases | BROAD INSTITUTE, INC. | Non-SBIR/STTR | $20,000,000.00 | $18,631,137.00 | $1,434,331.00 |
| 9743821 | Biotechnology; Genetics | TUFTS UNIVERSITY BOSTON | Non-SBIR/STTR | $360,112.00 | $218,250.00 | $141,862.00 |
| 9743775 | Chronic Liver Disease and Cirrhosis; Clinical Research; Clinical Trials and Supportive Activities; Digestive Diseases; Health Disparities; Hepatitis; Hepatitis - B; Immunotherapy; Infectious Diseases; Liver Disease; Minority Health; Women’s Health | UNIVERSITY OF WYOMING | Non-SBIR/STTR | $614,840.00 | $518,629.00 | $96,211.00 |
| 9743737 | Autoimmune Disease; Biotechnology; Cancer; Eye Disease and Disorders of Vision; Genetics; Immunization; Immunotherapy; Prevention; Vaccine Related | NUBAD, LLC | SBIR/STTR | $364,433.00 | ||
| 9743198 | Contraception/Reproduction; Emerging Infectious Diseases; Infectious Diseases; Infertility; Prevention; Women’s Health | YALE UNIVERSITY | Non-SBIR/STTR | $2,480,685.00 | $1,481,005.00 | $999,680.00 |
| 9743169 | Assistive Technology; Bioengineering; Biomedical Imaging; Brain Disorders; Clinical Research; Mental Health; Mental Illness; Neurosciences; Rehabilitation | YALE UNIVERSITY | Non-SBIR/STTR | $611,588.00 | $367,320.00 | $244,268.00 |
| 9742518 | Anxiety Disorders; Basic Behavioral and Social Science; Behavioral and Social Science; Brain Disorders; Mental Health; Neurosciences; Post-Traumatic Stress Disorder (PTSD) | JOHNS HOPKINS UNIVERSITY | Non-SBIR/STTR | $550,000.00 | $449,683.00 | $100,317.00 |
| 9742446 | Bioengineering; Biomedical Imaging; Brain Disorders; Cannabinoid Research; Clinical Research; Drug Abuse (NIDA only); Endocannabinoid System Research; Neurosciences; Prevention; Substance Abuse | NORTHWESTERN UNIVERSITY AT CHICAGO | Non-SBIR/STTR | $349,910.00 | $226,779.00 | $123,131.00 |
| 9742289 | Biotechnology; HIV/AIDS; Human Fetal Tissue; Immunization; Infectious Diseases; Prevention; Vaccine Related; Vaccine Related (AIDS) | UNIVERSITY OF CALGARY | Non-SBIR/STTR | $228,582.00 | $211,650.00 | $16,932.00 |
| 9741820 | ALS; Acquired Cognitive Impairment; Alzheimer’s Disease Related Dementias (ADRD); Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Brain Disorders; Dementia; Frontotemporal Dementia (FTD); Genetics; Health Disparities; Minority Health; Neurodegenerative; Neurosciences; Rare Diseases | EMORY UNIVERSITY | Non-SBIR/STTR | $387,900.00 | $250,000.00 | $137,900.00 |
| 9741795 | Bioengineering; Biomedical Imaging; Health Disparities; Lung; Machine Learning and Artificial Intelligence; Minority Health; Networking and Information Technology R&D (NITRD); Precision Medicine; Prevention; Women’s Health | UNANDUP, LLC | SBIR/STTR | $299,821.00 | ||
| 9741673 | Kidney Disease; Regenerative Medicine; Stem Cell Research; Stem Cell Research - Nonembryonic - Non-Human | UNIVERSITY OF COLORADO DENVER | Non-SBIR/STTR | $232,166.00 | $162,995.00 | $69,171.00 |
| 9671500 | Dietary Supplements; Neurosciences; Nutrition | HARVARD MEDICAL SCHOOL | Other Research-Related | $378,409.00 | $223,250.00 | $155,159.00 |
| 9672140 | Acquired Cognitive Impairment; Aging; Alzheimer’s Disease; Alzheimer’s Disease including Alzheimer’s Disease Related Dementias (AD/ADRD); Brain Disorders; Dementia; Neurodegenerative; Neurosciences; Sleep Research | AUGUSTA UNIVERSITY | Non-SBIR/STTR | $3,475,970.00 | $2,263,725.00 | $1,212,245.00 |
| 9670828 | Aging; Bioengineering; Biomedical Imaging; Clinical Research; Eye Disease and Disorders of Vision; Health Disparities; Health Services; Macular Degeneration; Neurodegenerative; Neurosciences | OREGON HEALTH & SCIENCE UNIVERSITY | Non-SBIR/STTR | $3,429,850.00 | $2,246,520.00 | $1,183,330.00 |
/*GET INFORMATION ABOUT PROJECT PERSON IN CHARGE*/
Select PROJECTNUMBER, PROJECTTITLE, PROJECTSTARTDATE, PROJECTENDDATE, PRIMARYPI, SECONDARYPI
FROM PROJECTS
INNER JOIN PROJECTPERSONINCHARGE ON PROJECTPERSONINCHARGE.ProjectID = PROJECTS.ProjectID
| ProjectNumber | ProjectTitle | ProjectStartDate | ProjectEndDate | PrimaryPI | SecondaryPI |
|---|---|---|---|---|---|
| 5R01HL131017-04 | Stem Cell Therapy for Myocardial Repair | 2016-07-01 | 2022-04-30 | ZHANG, JIANYI | OGLE, BRENDA M |
| 5R01AG041721-08 | Quantifying Brain Abnormality by Multimodality Neuroimage Analysis | 2012-08-01 | 2022-03-31 | LIU, MINGXIA | Not Applicable |
| 1RF1AG062166-01 | The Adipocyte PPARgama/Adiponectin Axis and Alzheimer’s Disease | 2019-02-15 | 2024-01-31 | LU, XIN-YUN | Not Applicable |
| 1RF1AG060718-01A1 | Calcineurin Mediates the Synergistic Toxicity of Tau and Aβ Oligomers | 2019-02-01 | 2024-01-31 | TAGLIALATELA, GIULIO | KAYED, RAKEZ |
| 1RF1NS110354-01 | Role of Glucosylsphingosine in Parkinson Disease and Dementia with Lewy Bodies | 2019-09-15 | 2023-08-31 | CHANDRA, SREEGANGA S | Not Applicable |
| 5R01CA187037-05 | Combined Biologic and Radiopharmaceutical Therapy of Breast Cancer | 2015-05-01 | 2022-04-30 | SGOUROS, GEORGE | Not Applicable |
| 5R01AG050588-04 | Transdermal Nitroglycerin Therapy for Menopausal Hot Flashes | 2016-04-15 | 2022-03-31 | HUANG, ALISON | Not Applicable |
| 5UL1TR001433-05 | MSHS Translational Science Hub | 2015-08-15 | 2022-03-31 | WRIGHT, ROSALIND J | Not Applicable |
| 5R01HL128592-05 | Novel MRI techniques for imaging cardiac fibrosis to improve clinical practice in patients with renal failure | 2015-06-01 | 2022-04-30 | VANDSBURGER, MORIEL | Not Applicable |
| 5R01DA039071-05 | Texting intervention to sustain HIV prevention in women in high-drug-use contexts | 2015-07-01 | 2022-04-30 | PATTERSON, THOMAS L. | Not Applicable |
| 5R01DA038154-05 | Cognitive Control in Children of SUD Parents: A Longitudinal Multimodal MRI Study | 2015-07-01 | 2022-04-30 | HOVEN, CHRISTINA W. | Not Applicable |
| 1RF1AG059392-01A1 | Establishing MicroRNA Biomarkers for Diagnosing Alzheimer’s Disease & Predicting Progression | 2019-02-15 | 2024-01-31 | SAUGSTAD, JULIE ANNE | Not Applicable |
| 5R01HL127338-04 | The Role of ZFP36 in Control of IPF | 2016-06-01 | 2022-04-30 | DING, QIANG | Not Applicable |
| 5R01HL126117-05 | TELmisartan plus EXercise to improve functioning in PAD: The TELEX Trial | 2015-08-17 | 2022-04-30 | MCDERMOTT, MARY MCGRAE | Not Applicable |
| 5R01HL129077-04 | Novel Simulation Technologies for BHV Long-Term Durability | 2016-05-19 | 2022-04-30 | SACKS, MICHAEL S | HUGHES, THOMAS J.; MANNING, KEEFE B |
| 5R01CA186338-05 | ZIP4 is a Novel Molecular Target in Human Pancreatic Cancer | 2015-05-01 | 2022-04-30 | LI, MIN | FERNANDEZ-ZAPICO, MARTIN ERNESTO |
| 5U01AI114378-05 | Experimental human infection with isogenic mutants of Neisseria gonorrhoeae | 2015-05-15 | 2022-04-30 | HOBBS, MARCIA METZGAR | Not Applicable |
| 5R03AG052416-02 | Dementia Screening Using Automated Speech Analysis: A Pilot Study | 2018-04-15 | 2022-03-31 | DIAZ-ASPER, CATHERINE | Not Applicable |
| 1R43CA236083-01 | Magnetomotive Embolization for Hepatocellular Carcinoma | 2019-03-01 | 2022-02-28 | CREIGHTON, FRANCIS MILTON | Not Applicable |
| 1R44AI138865-01A1 | Development of a novel therapy for mitigation of the irradiation-inducedgastrointestinal syndrome | 2019-05-01 | 2022-04-30 | DAINIAK, NICHOLAS | Not Applicable |
| 5R44CA199058-03 | A Prognostic Blood Test to Monitor Pancreatic Cancer Treatment by MiRNA Profiling | 2015-08-01 | 2022-04-30 | SARAF, RAVI | Not Applicable |
| 5R24OD021479-04 | Developing Regeneration Resources for a Model Amphibian | 2016-06-01 | 2022-03-31 | VOSS, STEPHEN RANDAL | THORSON, JON SCOTT |
| 5R01HL130376-04 | Final preclinical development of AAV gene therapy for atrial fibrillation | 2016-07-01 | 2022-04-30 | DONAHUE, J KEVIN | Not Applicable |
| 5R01ES025135-05 | Participatory Interventions to Reduce Arsenic in American Indian Communities | 2015-07-01 | 2022-03-31 | GEORGE, CHRISTINE MARIE | NAVAS-ACIEN, ANA |
| 5R01HL126666-05 | Growing Resilience in Wind River Indian Reservation: an RCT on gardens for health | 2015-08-01 | 2022-03-31 | PORTER, CHRISTINE MICHELLE | Not Applicable |
| 5R21HD095338-02 | Ontogeny of Brainstem Arousal Networks in Human Consciousness | 2018-04-01 | 2021-12-31 | ZOLLEI, LILLA | Not Applicable |
| 5U01HG009088-04 | Powering whole genome sequence-based genetic discovery for common human diseases | 2016-05-02 | 2022-03-31 | LIN, XIHONG | NEALE, BENJAMIN MICHAEL; SUNYAEV, SHAMIL |
| 5R01AI067946-14 | Directing Function at the Natural Killer Cell Secretory Immunological Synapse | 2005-12-01 | 2022-03-31 | ORANGE, JORDAN SCOTT | Not Applicable |
| 5R01DA039533-05 | Effects of early life stress on synaptic function and DA signaling in the VTA | 2015-05-01 | 2022-03-31 | NUGENT, FERESHTEH S | Not Applicable |
| 5R01MH106450-05 | Cognitive Enhancement Therapy for Adult Autism Spectrum Disorder | 2015-06-01 | 2022-03-31 | EACK, SHAUN M | Not Applicable |
| 5R44DC014173-03 | Expressive Speech Synthesis for Speech-Generating Devices | 2015-04-01 | 2022-02-28 | HERTZ, SUSAN R | Not Applicable |
| 5R01CA193343-05 | Genetic Mapping of Breast Cancer Risk in the Tumor Microenvironment | 2015-04-01 | 2022-03-31 | JOSHI, AMIT | Not Applicable |
| 5R01DA041438-04 | Effects of cigarette availability on neural and subjective sensitivity to rewards | 2016-04-01 | 2022-03-31 | WILSON, STEPHEN JEFFREY | Not Applicable |
| 5R01GM098539-08 | Analytical tools for the analysis of clustered O-glycans in clinical samples | 2011-09-15 | 2022-03-31 | RENFROW, MATTHEW B | Not Applicable |
| 5R01HL128388-04 | Adverse Neurogenic Actions of Dietary Salt | 2016-04-01 | 2022-03-31 | FARQUHAR, WILLIAM B | STOCKER, SEAN D |
| 5R01CA066980-25 | Biological Activity of HPV E7 in Human Epithelial Cells | 1996-04-19 | 2022-03-31 | MUNGER, KARL | Not Applicable |
| 5R01HD091068-03 | A System for Culturing Mammalian Spermatogonial Cells | 2017-04-01 | 2022-03-31 | DOBRINSKI, INA | Not Applicable |
| 5R21DA044749-02 | Imaging the monoaminergic midbrain and cognitive control in cocaine addiction | 2018-03-15 | 2022-02-28 | LI, CHIANG-SHAN RAY | Not Applicable |
| 5R01HL126099-04 | Adapting the Diabetes Prevention Program for a developing world context | 2016-03-15 | 2022-02-28 | CATLEY, DELWYN | Not Applicable |
| 5R01GM028157-38 | Inherited Variations In Drug Metabolizing Enzymes | 1996-07-01 | 2022-03-31 | WEINSHILBOUM, RICHARD M. | Not Applicable |
| 5R21ES029762-02 | Taking a Breath after the Disaster: Homes, Mold and Health in Puerto Rico after Hurricane Maria | 2018-04-01 | 2022-03-31 | CAVALLIN, HUMBERTO | Not Applicable |
| 5R01DA041032-05 | Optimizing HIV counseling testing and referral through an adaptive drug use intervention | 2015-09-15 | 2022-05-31 | STEPHENSON, ROB B. | BAUERMEISTER, JOSE ARTURO |
| 5R01CA181064-06 | Yoga Versus CBT-I for Insomnia in Cancer Survivors and Biobehavioral Mechanisms | 2014-07-25 | 2022-05-31 | MUSTIAN, KAREN M. | Not Applicable |
| 5R21NS104603-02 | Brain structure and function in adult ZIKV patients with neurological manifestations | 2018-06-01 | 2022-05-31 | SADAGHIANI, SEPIDEH | Not Applicable |
| 5R01NR015241-05 | Advancing CBPR Practice Through a Collective Reflection and Measurement Toolkit | 2015-09-23 | 2022-05-31 | WALLERSTEIN, NINA B | Not Applicable |
| 5R21AR071585-02 | Engineering a biopolymer hydrogel to inhibit osteogenesis: Implications for growth plate repair | 2018-05-10 | 2022-03-31 | KREBS, MELISSA | Not Applicable |
| 5R21MH114095-02 | Understanding Attentional Strengths and Weaknesses in Autism Spectrum Disorder | 2018-05-07 | 2022-03-31 | KEEHN, BRANDON | Not Applicable |
| 5U2CAG057441-03 | ARMADA: Advancing Reliable Measurement in Alzheimer’s Disease and cognitive Aging | 2017-09-30 | 2022-04-30 | GERSHON, RICHARD | WEINTRAUB, SANDRA |
| 5R01DK064814-13 | Acitivity for Diabetic Polyneuropathy: The ADAPT Study | 2004-04-15 | 2022-03-31 | SINGLETON, JOHN ROBINSON | SMITH, A. GORDON |
| 5R44AG056012-03 | Mobility Rehab: A Biofeedback System for Mobility Rehabilitation for Older Adults | 2016-09-30 | 2022-04-30 | EL-GOHARY, MAHMOUD | Not Applicable |
| 5R01GM111682-05 | PARylation in genotoxic stress-induced NF-kB activation | 2015-05-01 | 2022-04-30 | WAN, FENGYI | Not Applicable |
| 5U01ES026721-04 | Epigenomics of Air Pollution driven Inflammation, Obesity and Insulin Resistance | 2016-06-01 | 2022-04-30 | BISWAL, SHYAM | RAJAGOPALAN, SANJAY |
| 5R34DA041549-03 | Advancing STOP: Self-regulation/CBT Therapy for Opioid addiction and Pain | 2017-07-01 | 2022-04-30 | WACHHOLTZ, AMY B | Not Applicable |
| 5R01AG053325-04 | Non-esterified Fatty Acids and Cardiometabolic Disease in Older Adults | 2016-09-15 | 2022-04-30 | DJOUSSE, LUC | MUKAMAL, KENNETH JAY |
| 5R24OD021997-04 | Drosophila resources for modeling human diseases | 2016-06-01 | 2022-04-30 | PERRIMON, NORBERT | Not Applicable |
| 5R01HL122684-05 | Genetic Studies of The Impact of Hematologic Traits On Cardiovascular Disease | 2015-08-10 | 2022-04-30 | GANESH, SANTHI K | Not Applicable |
| 5R01EY026584-04 | Novel Imaging of rod oxidative stress in retinal disease and treatment in vivo | 2016-05-01 | 2022-04-30 | BERKOWITZ, BRUCE A. | Not Applicable |
| 5R01HD045713-16 | The Dynamics of Visual Attention and Word Learning | 2003-09-01 | 2022-04-30 | SAMUELSON, LARISSA K | Not Applicable |
| 5R01AT009444-03 | A randomized trial of dance on mood, balance and brain in Alzheimer’s Disease | 2017-05-01 | 2022-04-30 | HUGENSCHMIDT, CHRISTINA E | SORIANO, CHRISTINA T |
| 5R01AA013892-15 | Chronic Alcohol and Brain Stress Circuit Response | 2003-03-01 | 2022-04-30 | SINHA, RAJITA | Not Applicable |
| 5K23HL130648-04 | Optimizing ED to ICU triage decisions for critically ill patients in respiratory distress | 2016-05-05 | 2022-01-09 | MATHEWS, KUSUM SARA | Not Applicable |
| 5R01HL129472-05 | Selection of Allogeneic Hematopoietic Cell Donor Based on KIR and HLA Genotypes | 2015-05-15 | 2022-04-30 | HSU, KATHARINE C | Not Applicable |
| 5R01DK105526-04 | Novel pharmacotherapy strategies for obesity in schizophrenia | 2016-04-15 | 2022-03-31 | JARSKOG, LARS FREDRIK | Not Applicable |
| 5R01DE016402-14 | Mesenchymal Regulation of Osteogenesis | 2004-09-28 | 2022-05-31 | SCHNEIDER, RICHARD A | Not Applicable |
| 5R01CA185322-05 | Epigenetics and Infection-induced EMT of Colonic Crypts - Target for Chemoprevention | 2015-01-05 | 2021-12-31 | UMAR, SHAHID | Not Applicable |
| 5R01CA183101-05 | Biophotonics to Couple Pancreatic with Upper GI Screening via Ultrathin Endoscopy | 2015-01-01 | 2021-12-31 | BACKMAN, VADIM | ROGERS, JEREMY D.; ROY, HEMANT K. |
| 5R03AI130174-02 | Receptor-mediated steps in enterovirus infection involve allostery | 2017-12-08 | 2021-11-30 | CARSON, STEVEN D | Not Applicable |
| 5R21ES028911-02 | Mechanisms of carcinogenic effects of nickel nanoparticles | 2017-12-15 | 2021-11-30 | ZHANG, QUNWEI | Not Applicable |
| 5R01HL039752-31 | Elevated Calcium and Myocardial Ischemia injury | 1988-03-01 | 2021-11-30 | STEENBERGEN, CHARLES | Not Applicable |
| 5UM1HG008895-04 | Center for Common Disease Genetics | 2016-01-14 | 2021-11-30 | GABRIEL, STACEY | DALY, MARK JOSEPH |
| 5R01MH100318-05 | Amygdala-mediated enhancement of the hippocampal memory system | 2014-12-01 | 2021-11-30 | MANNS, JOSEPH R | Not Applicable |
| 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | 2011-12-05 | 2021-11-30 | VALLE, DAVID | Not Applicable |
| 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | 2011-12-05 | 2021-11-30 | VALLE, DAVID | Not Applicable |
| 5R01DK104867-04 | Dorsomedial Hypothalamic Signaling Pathways and Energy Balance | 2015-12-01 | 2021-11-30 | BI, SHENG | Not Applicable |
| 5R01CA183749-05 | Optimizing cancer photodynamic therapy using photoacoustic lifetime imaging | 2014-12-22 | 2021-11-30 | ASHKENAZI, SHAI | Not Applicable |
| 5R41DC016257-02 | Nucleobase aminosugars with reduced ototoxicity | 2017-12-01 | 2021-11-30 | ARYA, DEV PRIYA | Not Applicable |
| 5R01DE017732-11 | Diabetes-enhanced Experimental Periodontitis | 2006-07-01 | 2021-11-30 | GRAVES, DANA T | Not Applicable |
| 5R01EY026155-04 | Role of aquaporins in mammalian lens development,transparency and homeostasis | 2015-12-01 | 2021-11-30 | VARADARAJ, KULANDAIAPPAN | Not Applicable |
| 5K08DK103945-05 | Circulating MicroRNAs and Hyperglycemia | 2015-09-15 | 2022-07-31 | WANDER (JANUSZEWSKI), PANDORA "LUKE" | Not Applicable |
| 1OT2OD027070-01 | Population-Scale Clinical Genomics | 2019-09-21 | 2024-08-31 | LEVY, SHAWN E | Not Applicable |
| 5K08NS094683-05 | Effect of ABCD1 upon Brain Endothelium in X-linked Adrenoleukodystrophy | 2015-09-30 | 2022-06-30 | MUSOLINO, PATRICIA LEONOR | Not Applicable |
| 5SC2GM121250-03 | Photosensitization of albumin: a potential approach to modulate drug delivery into abnormal cells. | 2017-09-01 | 2022-07-31 | BRANCALEON, LORENZO | Not Applicable |
| 5R21AG056765-02 | Integrating Mobile and Wearable Technology to Promote Physical Activity and Sleep among Midlife Adults: The Be SMART for Heart Health Trial | 2018-07-15 | 2022-03-31 | DOMINICK, GREGORY MITCHELL | Not Applicable |
| 5R01DK101505-05 | Whole-exome Sequencing Study of Diabetic Nephropathy | 2015-08-21 | 2022-05-31 | KELLY, TANIKA NICOLE | Not Applicable |
| 1R21NS107884-01A1 | Cellular immunity in intractable pediatric epilepsy | 2019-03-15 | 2022-02-28 | OWENS, GEOFFREY C | MATHERN, GARY W. |
| 5R01NS088645-05 | Etiological Linkage of DNA Damage/Repair Deficiency in Neurodegenerative Diseases | 2015-07-01 | 2022-06-30 | HEGDE, MURALIDHAR L | Not Applicable |
| 5U54HL127366-06 | Broad Institute LINCS Center for Transcriptomics | 2014-09-10 | 2022-07-31 | SUBRAMANIAN, ARAVIND | Not Applicable |
| 5U01DK082944-12 | Hepatitis B Research Network (HBRN): Natural History and Treatment Studies | 2008-09-30 | 2022-05-31 | KHALILI, MANDANA | COOPER, STEWART ; TERRAULT, NORAH A. |
| 5R01CA191317-05 | Separating autoimmunity and anti-tumor immunity | 2015-08-01 | 2022-07-31 | LE POOLE, I CAROLINE | Not Applicable |
| 5R21ES028963-02 | Water disinfection by-products and female fertility | 2018-07-15 | 2022-05-31 | FLAWS, JODI A | PLEWA, MICHAEL JACOB |
| 5R00EB019482-05 | Neuroimaging of deep brain stimulation patients using safe MRI excitations | 2017-07-01 | 2022-06-30 | GUERIN, BASTIEN | Not Applicable |
| 5R01NS022061-35 | Modulation of neuronal acetylcholine receptors | 1985-07-01 | 2022-07-31 | PLOTKIN, JOSHUA L | Not Applicable |
| 5R21DA045296-02 | Understanding Cannabis Withdrawal: A PET Study of Endocannabinoid Metabolism | 2018-07-15 | 2022-06-30 | BOILEAU, ISABELLE | Not Applicable |
| 5R01AI124804-04 | Impact of Fc N-glycan structure on HIV-specific antibody functions | 2016-08-01 | 2022-07-31 | JARVIS, DONALD L. | Not Applicable |
| 5R01NS093362-05 | Defining the role of FUS phosphorylation in neurodegeneration | 2015-08-01 | 2022-06-30 | KUKAR, THOMAS L | Not Applicable |
| 5R01HL128785-04 | Computer-Aided Diagnosis of Pulmonary Embolism | 2016-07-01 | 2022-04-30 | LIANG, JIANMING | Not Applicable |
| 5R01DK064324-15 | Multiphoton imaging of the juxtaglomerular apparatus | 2003-04-01 | 2022-06-30 | PETI-PETERDI, JANOS | Not Applicable |
| 5R01NS096755-04 | From brain iron deficiency to therapeutic opportunities in mucolipidosis IV | 2016-04-01 | 2022-03-31 | KISELYOV, KIRILL | CONNOR, JAMES ROBERT; SLAUGENHAUPT, SUSAN A |
| 1RF1AG061774-01 | Slow-wave activity as a modifier of the progression of neurodegeneration in Alzheimer’s disease | 2019-04-15 | 2024-03-31 | GERASHCHENKO, DMITRY | BACSKAI, BRIAN J |
| 5R44EY024186-03 | Confocal and Autofluorescence Imaging of Macular Degeneration using a Low Cost Digital Imager | 2018-04-01 | 2022-03-31 | MULLER, MATTHEW S | Not Applicable |
/*TO CHECK WHICH YEAR THE FUNDING WAS DISBURSED*/
Select ProjectNumber, ProjectTitle, PrimaryPI, OrganizationName, ArraIndicator, CfdaCode, FundingICS, FundingMechanism, DirectCostIC, IndirectCostIC,TotalCostIC, Strftime("%Y", ProjectStartDate) As FundingDisbursed
From Projects
Inner join ProjectPersonIncharge on ProjectPersonincharge.ProjectID = Projects.ProjectID
Inner join Organizations on Organizations.OrganizationID = ProjectpersonIncharge.OrganizationID
Inner Join GovermentFunding on GovermentFunding.FundingID = Organizations.FundingID
Inner Join Cost on Cost.FundingID = GovermentFunding.FundingID
ORDER BY FUNDINGDISBURSED
| ProjectNumber | ProjectTitle | PrimaryPI | OrganizationName | ARRAIndicator | CFDACode | FundingICS | FundingMechanism | DirectCostIC | IndirectCostIC | TotalCostIC | FundingDisbursed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5R01NS022061-35 | Modulation of neuronal acetylcholine receptors | PLOTKIN, JOSHUA L | STATE UNIVERSITY NEW YORK STONY BROOK | N | 853 | NINDS | Non-SBIR/STTR | $296,065.00 | $169,714.00 | $465,779.00 | 1985 |
| 5R01HL039752-31 | Elevated Calcium and Myocardial Ischemia injury | STEENBERGEN, CHARLES | JOHNS HOPKINS UNIVERSITY | N | 837 | NHLBI | Non-SBIR/STTR | $250,000.00 | $155,000.00 | $405,000.00 | 1988 |
| 5R01CA066980-25 | Biological Activity of HPV E7 in Human Epithelial Cells | MUNGER, KARL | TUFTS UNIVERSITY BOSTON | N | 393 | NCI | Non-SBIR/STTR | $218,250.00 | $141,862.00 | $360,112.00 | 1996 |
| 5R01GM028157-38 | Inherited Variations In Drug Metabolizing Enzymes | WEINSHILBOUM, RICHARD M. | MAYO CLINIC ROCHESTER | N | 859 | NIGMS | Non-SBIR/STTR | $270,000.00 | $149,836.00 | $419,836.00 | 1996 |
| 5R01HD045713-16 | The Dynamics of Visual Attention and Word Learning | SAMUELSON, LARISSA K | UNIVERSITY OF EAST ANGLIA | N | 865 | NICHD | Non-SBIR/STTR | $270,676.00 | $21,654.00 | $292,330.00 | 2003 |
| 5R01AA013892-15 | Chronic Alcohol and Brain Stress Circuit Response | SINHA, RAJITA | YALE UNIVERSITY | N | 273 | NIAAA | Non-SBIR/STTR | $367,320.00 | $244,268.00 | $611,588.00 | 2003 |
| 5R01DK064324-15 | Multiphoton imaging of the juxtaglomerular apparatus | PETI-PETERDI, JANOS | UNIVERSITY OF SOUTHERN CALIFORNIA | N | 847 | NIDDK | Non-SBIR/STTR | $262,265.00 | $170,472.00 | $432,737.00 | 2003 |
| 5R01DK064814-13 | Acitivity for Diabetic Polyneuropathy: The ADAPT Study | SINGLETON, JOHN ROBINSON | UNIVERSITY OF UTAH | N | 847 | NIDDK | Non-SBIR/STTR | $477,210.00 | $164,946.00 | $642,156.00 | 2004 |
| 5R01DE016402-14 | Mesenchymal Regulation of Osteogenesis | SCHNEIDER, RICHARD A | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 121 | NIDCR | Non-SBIR/STTR | $250,000.00 | $146,250.00 | $396,250.00 | 2004 |
| 5R01AI067946-14 | Directing Function at the Natural Killer Cell Secretory Immunological Synapse | ORANGE, JORDAN SCOTT | COLUMBIA UNIVERSITY HEALTH SCIENCES | N | 855 | NIAID | Non-SBIR/STTR | $260,162.00 | $161,300.00 | $421,462.00 | 2005 |
| 5R01DE017732-11 | Diabetes-enhanced Experimental Periodontitis | GRAVES, DANA T | UNIVERSITY OF PENNSYLVANIA | N | 121 | NIDCR | Non-SBIR/STTR | $282,980.00 | $147,578.00 | $430,558.00 | 2006 |
| 5U01DK082944-12 | Hepatitis B Research Network (HBRN): Natural History and Treatment Studies | KHALILI, MANDANA | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 847 | NIDDK | Non-SBIR/STTR | $933,700.00 | $343,839.00 | $742,927.00 | 2008 |
| 5R01GM098539-08 | Analytical tools for the analysis of clustered O-glycans in clinical samples | RENFROW, MATTHEW B | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 859 | NIGMS | Non-SBIR/STTR | $246,822.00 | $105,290.00 | $352,112.00 | 2011 |
| 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | VALLE, DAVID | JOHNS HOPKINS UNIVERSITY | N | 172 | NHLBI | Non-SBIR/STTR | $449,683.00 | $100,317.00 | $550,000.00 | 2011 |
| 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | VALLE, DAVID | JOHNS HOPKINS UNIVERSITY | N | 172 | NHGRI | Non-SBIR/STTR | $3,530,479.00 | $787,589.00 | $2,318,900.00 | 2011 |
| 5R01AG041721-08 | Quantifying Brain Abnormality by Multimodality Neuroimage Analysis | LIU, MINGXIA | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 866 | NIA | Non-SBIR/STTR | $230,831.00 | $120,032.00 | $350,863.00 | 2012 |
| 5R01CA181064-06 | Yoga Versus CBT-I for Insomnia in Cancer Survivors and Biobehavioral Mechanisms | MUSTIAN, KAREN M. | UNIVERSITY OF ROCHESTER | N | 395 | NCI | Non-SBIR/STTR | $442,807.00 | $236,902.00 | $679,709.00 | 2014 |
| 5R01MH100318-05 | Amygdala-mediated enhancement of the hippocampal memory system | MANNS, JOSEPH R | EMORY UNIVERSITY | N | 242 | NIMH | Non-SBIR/STTR | $250,000.00 | $137,900.00 | $387,900.00 | 2014 |
| 5R01CA183749-05 | Optimizing cancer photodynamic therapy using photoacoustic lifetime imaging | ASHKENAZI, SHAI | UNIVERSITY OF MINNESOTA | N | 394 | NCI | Non-SBIR/STTR | $221,887.00 | $91,686.00 | $313,573.00 | 2014 |
| 5U54HL127366-06 | Broad Institute LINCS Center for Transcriptomics | SUBRAMANIAN, ARAVIND | BROAD INSTITUTE, INC. | N | 837 | OD | Research Centers | $1,895,344.00 | $212,797.00 | $2,108,141.00 | 2014 |
| 5R01CA187037-05 | Combined Biologic and Radiopharmaceutical Therapy of Breast Cancer | SGOUROS, GEORGE | JOHNS HOPKINS UNIVERSITY | N | 395 | NCI | Non-SBIR/STTR | $283,572.00 | $175,814.00 | $459,386.00 | 2015 |
| 5UL1TR001433-05 | MSHS Translational Science Hub | WRIGHT, ROSALIND J | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | N | 350 | NCATS | Research Centers | $3,666,560.00 | $2,446,919.00 | $5,133,391.00 | 2015 |
| 5R01HL128592-05 | Novel MRI techniques for imaging cardiac fibrosis to improve clinical practice in patients with renal failure | VANDSBURGER, MORIEL | UNIVERSITY OF CALIFORNIA BERKELEY | N | 837 | NHLBI | Non-SBIR/STTR | $250,000.00 | $142,500.00 | $392,500.00 | 2015 |
| 5R01DA039071-05 | Texting intervention to sustain HIV prevention in women in high-drug-use contexts | PATTERSON, THOMAS L. | UNIVERSITY OF CALIFORNIA, SAN DIEGO | N | 279 | NIDA | Non-SBIR/STTR | $436,059.00 | $188,233.00 | $624,292.00 | 2015 |
| 5R01DA038154-05 | Cognitive Control in Children of SUD Parents: A Longitudinal Multimodal MRI Study | HOVEN, CHRISTINA W. | NEW YORK STATE PSYCHIATRIC INSTITUTE | N | 279 | NIDA | Non-SBIR/STTR | $399,955.00 | $237,601.00 | $637,556.00 | 2015 |
| 5R01HL126117-05 | TELmisartan plus EXercise to improve functioning in PAD: The TELEX Trial | MCDERMOTT, MARY MCGRAE | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 837 | NHLBI | Non-SBIR/STTR | $553,659.00 | $257,160.00 | $713,702.00 | 2015 |
| 5R01CA186338-05 | ZIP4 is a Novel Molecular Target in Human Pancreatic Cancer | LI, MIN | UNIVERSITY OF OKLAHOMA HLTH SCIENCES CTR | N | 396 | NCI | Non-SBIR/STTR | $243,447.00 | $89,202.00 | $332,649.00 | 2015 |
| 5U01AI114378-05 | Experimental human infection with isogenic mutants of Neisseria gonorrhoeae | HOBBS, MARCIA METZGAR | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 855 | NIAID | Non-SBIR/STTR | $756,505.00 | $320,841.00 | $1.00 | 2015 |
| 5R44CA199058-03 | A Prognostic Blood Test to Monitor Pancreatic Cancer Treatment by MiRNA Profiling | SARAF, RAVI | VAJRA INSTRUMENTS, INC. | N | 394 | NCI | SBIR/STTR | $999,597.00 | 2015 | ||
| 5R01ES025135-05 | Participatory Interventions to Reduce Arsenic in American Indian Communities | GEORGE, CHRISTINE MARIE | JOHNS HOPKINS UNIVERSITY | N | 113 | NIEHS | Non-SBIR/STTR | $589,048.00 | $162,352.00 | $585,477.00 | 2015 |
| 5R01HL126666-05 | Growing Resilience in Wind River Indian Reservation: an RCT on gardens for health | PORTER, CHRISTINE MICHELLE | UNIVERSITY OF WYOMING | N | 837 | NHLBI | Non-SBIR/STTR | $518,629.00 | $96,211.00 | $614,840.00 | 2015 |
| 5R01DA039533-05 | Effects of early life stress on synaptic function and DA signaling in the VTA | NUGENT, FERESHTEH S | HENRY M. JACKSON FDN FOR THE ADV MIL/MED | N | 279 | NIDA | Non-SBIR/STTR | $230,000.00 | $128,309.00 | $358,309.00 | 2015 |
| 5R01MH106450-05 | Cognitive Enhancement Therapy for Adult Autism Spectrum Disorder | EACK, SHAUN M | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | N | 242 | NIMH | Non-SBIR/STTR | $409,828.00 | $194,580.00 | $604,408.00 | 2015 |
| 5R44DC014173-03 | Expressive Speech Synthesis for Speech-Generating Devices | HERTZ, SUSAN R | SYNFONICA, LLC | N | 173 | NIDCD | SBIR/STTR | $492,816.00 | 2015 | ||
| 5R01CA193343-05 | Genetic Mapping of Breast Cancer Risk in the Tumor Microenvironment | JOSHI, AMIT | MEDICAL COLLEGE OF WISCONSIN | N | 396 | NCI | Non-SBIR/STTR | $221,887.00 | $119,819.00 | $341,706.00 | 2015 |
| 5R01DA041032-05 | Optimizing HIV counseling testing and referral through an adaptive drug use intervention | STEPHENSON, ROB B. | UNIVERSITY OF MICHIGAN AT ANN ARBOR | N | 279 | NIDA | Non-SBIR/STTR | $461,761.00 | $220,496.00 | $682,257.00 | 2015 |
| 5R01NR015241-05 | Advancing CBPR Practice Through a Collective Reflection and Measurement Toolkit | WALLERSTEIN, NINA B | UNIVERSITY OF NEW MEXICO HEALTH SCIS CTR | N | 361 | NINR | Non-SBIR/STTR | $371,960.00 | $107,581.00 | $479,541.00 | 2015 |
| 5R01GM111682-05 | PARylation in genotoxic stress-induced NF-kB activation | WAN, FENGYI | JOHNS HOPKINS UNIVERSITY | N | 859 | NIGMS | Non-SBIR/STTR | $192,500.00 | $119,350.00 | $311,850.00 | 2015 |
| 5R01HL122684-05 | Genetic Studies of The Impact of Hematologic Traits On Cardiovascular Disease | GANESH, SANTHI K | UNIVERSITY OF MICHIGAN AT ANN ARBOR | N | 837 | NHLBI | Non-SBIR/STTR | $875,307.00 | $402,474.00 | $678,076.00 | 2015 |
| 5R01HL129472-05 | Selection of Allogeneic Hematopoietic Cell Donor Based on KIR and HLA Genotypes | HSU, KATHARINE C | SLOAN-KETTERING INST CAN RESEARCH | N | 839 | NHLBI | Non-SBIR/STTR | $296,750.00 | $183,817.00 | $480,567.00 | 2015 |
| 5R01CA185322-05 | Epigenetics and Infection-induced EMT of Colonic Crypts - Target for Chemoprevention | UMAR, SHAHID | UNIVERSITY OF KANSAS MEDICAL CENTER | N | 393 | NCI | Non-SBIR/STTR | $258,009.00 | $115,060.00 | $373,069.00 | 2015 |
| 5R01CA183101-05 | Biophotonics to Couple Pancreatic with Upper GI Screening via Ultrathin Endoscopy | BACKMAN, VADIM | NORTHWESTERN UNIVERSITY | N | 394 | NCI | Non-SBIR/STTR | $522,024.00 | $76,565.00 | $598,589.00 | 2015 |
| 5R01DK104867-04 | Dorsomedial Hypothalamic Signaling Pathways and Energy Balance | BI, SHENG | JOHNS HOPKINS UNIVERSITY | N | 847 | NIDDK | Non-SBIR/STTR | $225,000.00 | $139,500.00 | $364,500.00 | 2015 |
| 5R01EY026155-04 | Role of aquaporins in mammalian lens development,transparency and homeostasis | VARADARAJ, KULANDAIAPPAN | STATE UNIVERSITY NEW YORK STONY BROOK | N | 867 | NEI | Non-SBIR/STTR | $250,000.00 | $145,000.00 | $395,000.00 | 2015 |
| 5K08DK103945-05 | Circulating MicroRNAs and Hyperglycemia | WANDER (JANUSZEWSKI), PANDORA "LUKE" | UNIVERSITY OF WASHINGTON | N | 847 | NIDDK | Other Research-Related | $149,900.00 | $11,984.00 | $161,884.00 | 2015 |
| 5K08NS094683-05 | Effect of ABCD1 upon Brain Endothelium in X-linked Adrenoleukodystrophy | MUSOLINO, PATRICIA LEONOR | MASSACHUSETTS GENERAL HOSPITAL | N | 853 | NINDS | Other Research-Related | $184,000.00 | $15,040.00 | $199,040.00 | 2015 |
| 5R01DK101505-05 | Whole-exome Sequencing Study of Diabetic Nephropathy | KELLY, TANIKA NICOLE | TULANE UNIVERSITY OF LOUISIANA | N | 847 | NIDDK | Non-SBIR/STTR | $240,403.00 | $47,025.00 | $287,428.00 | 2015 |
| 5R01NS088645-05 | Etiological Linkage of DNA Damage/Repair Deficiency in Neurodegenerative Diseases | HEGDE, MURALIDHAR L | METHODIST HOSPITAL RESEARCH INSTITUTE | N | 853 | NINDS | Non-SBIR/STTR | $232,969.00 | $111,625.00 | $344,594.00 | 2015 |
| 5R01CA191317-05 | Separating autoimmunity and anti-tumor immunity | LE POOLE, I CAROLINE | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 395 | NCI | Non-SBIR/STTR | $226,779.00 | $123,131.00 | $349,910.00 | 2015 |
| 5R01NS093362-05 | Defining the role of FUS phosphorylation in neurodegeneration | KUKAR, THOMAS L | EMORY UNIVERSITY | N | 853 | NINDS | Non-SBIR/STTR | $260,566.00 | $122,487.00 | $383,053.00 | 2015 |
| 5R01HL131017-04 | Stem Cell Therapy for Myocardial Repair | ZHANG, JIANYI | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 837 | NHLBI | Non-SBIR/STTR | $561,107.00 | $171,894.00 | $733,001.00 | 2016 |
| 5R01AG050588-04 | Transdermal Nitroglycerin Therapy for Menopausal Hot Flashes | HUANG, ALISON | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 866 | NIA | Non-SBIR/STTR | $346,473.00 | $190,693.00 | $537,166.00 | 2016 |
| 5R01HL127338-04 | The Role of ZFP36 in Control of IPF | DING, QIANG | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 838 | NHLBI | Non-SBIR/STTR | $250,000.00 | $117,500.00 | $367,500.00 | 2016 |
| 5R01HL129077-04 | Novel Simulation Technologies for BHV Long-Term Durability | SACKS, MICHAEL S | UNIVERSITY OF TEXAS, AUSTIN | N | 837 | NHLBI | Non-SBIR/STTR | $375,094.00 | $100,172.00 | $475,266.00 | 2016 |
| 5R24OD021479-04 | Developing Regeneration Resources for a Model Amphibian | VOSS, STEPHEN RANDAL | UNIVERSITY OF KENTUCKY | N | 351 | OD | Other Research-Related | $438,764.00 | $119,146.00 | $557,910.00 | 2016 |
| 5R01HL130376-04 | Final preclinical development of AAV gene therapy for atrial fibrillation | DONAHUE, J KEVIN | UNIV OF MASSACHUSETTS MED SCH WORCESTER | N | 837 | NHLBI | Non-SBIR/STTR | $430,708.00 | $290,728.00 | $721,436.00 | 2016 |
| 5U01HG009088-04 | Powering whole genome sequence-based genetic discovery for common human diseases | LIN, XIHONG | HARVARD SCHOOL OF PUBLIC HEALTH | N | 172 | NHGRI | Non-SBIR/STTR | $896,558.00 | $150,424.00 | $884,756.00 | 2016 |
| 5R01DA041438-04 | Effects of cigarette availability on neural and subjective sensitivity to rewards | WILSON, STEPHEN JEFFREY | PENNSYLVANIA STATE UNIVERSITY-UNIV PARK | N | 279 | NIDA | Non-SBIR/STTR | $225,000.00 | $128,700.00 | $353,700.00 | 2016 |
| 5R01HL128388-04 | Adverse Neurogenic Actions of Dietary Salt | FARQUHAR, WILLIAM B | UNIVERSITY OF DELAWARE | N | 837 | NHLBI | Non-SBIR/STTR | $516,405.00 | $129,020.00 | $645,425.00 | 2016 |
| 5R01HL126099-04 | Adapting the Diabetes Prevention Program for a developing world context | CATLEY, DELWYN | CHILDREN’S MERCY HOSP (KANSAS CITY, MO) | N | 837 | NHLBI | Non-SBIR/STTR | $536,726.00 | $129,065.00 | $665,791.00 | 2016 |
| 5R44AG056012-03 | Mobility Rehab: A Biofeedback System for Mobility Rehabilitation for Older Adults | EL-GOHARY, MAHMOUD | APDM, INC. | N | 866 | NIA | SBIR/STTR | $676,357.00 | 2016 | ||
| 5U01ES026721-04 | Epigenomics of Air Pollution driven Inflammation, Obesity and Insulin Resistance | BISWAL, SHYAM | JOHNS HOPKINS UNIVERSITY | N | 113 | NIEHS | Non-SBIR/STTR | $668,998.00 | $387,128.00 | $635,267.00 | 2016 |
| 5R01AG053325-04 | Non-esterified Fatty Acids and Cardiometabolic Disease in Older Adults | DJOUSSE, LUC | BRIGHAM AND WOMEN’S HOSPITAL | N | 866 | NIA | Non-SBIR/STTR | $592,483.00 | $60,745.00 | $653,228.00 | 2016 |
| 5R24OD021997-04 | Drosophila resources for modeling human diseases | PERRIMON, NORBERT | HARVARD MEDICAL SCHOOL | N | 351 | OD | Other Research-Related | $223,250.00 | $155,159.00 | $378,409.00 | 2016 |
| 5R01EY026584-04 | Novel Imaging of rod oxidative stress in retinal disease and treatment in vivo | BERKOWITZ, BRUCE A. | WAYNE STATE UNIVERSITY | N | 867 | NEI | Non-SBIR/STTR | $250,000.00 | $135,000.00 | $385,000.00 | 2016 |
| 5K23HL130648-04 | Optimizing ED to ICU triage decisions for critically ill patients in respiratory distress | MATHEWS, KUSUM SARA | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | N | 838 | NHLBI | Other Research-Related | $154,494.00 | $12,080.00 | $166,574.00 | 2016 |
| 5R01DK105526-04 | Novel pharmacotherapy strategies for obesity in schizophrenia | JARSKOG, LARS FREDRIK | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 847 | NIDDK | Non-SBIR/STTR | $523,656.00 | $133,862.00 | $657,518.00 | 2016 |
| 5UM1HG008895-04 | Center for Common Disease Genetics | GABRIEL, STACEY | BROAD INSTITUTE, INC. | N | 172 | NHGRI | Non-SBIR/STTR | $18,631,137.00 | $1,434,331.00 | $20,000,000.00 | 2016 |
| 5R01AI124804-04 | Impact of Fc N-glycan structure on HIV-specific antibody functions | JARVIS, DONALD L. | UNIVERSITY OF WYOMING | N | 855 | NIAID | Non-SBIR/STTR | $593,369.00 | $139,874.00 | $733,243.00 | 2016 |
| 5R01HL128785-04 | Computer-Aided Diagnosis of Pulmonary Embolism | LIANG, JIANMING | ARIZONA STATE UNIVERSITY-TEMPE CAMPUS | N | 838 | NHLBI | Non-SBIR/STTR | $853,161.00 | $393,298.00 | $586,687.00 | 2016 |
| 5R01NS096755-04 | From brain iron deficiency to therapeutic opportunities in mucolipidosis IV | KISELYOV, KIRILL | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | N | 853 | NINDS | Non-SBIR/STTR | $361,055.00 | $49,195.00 | $410,250.00 | 2016 |
| 5R01HD091068-03 | A System for Culturing Mammalian Spermatogonial Cells | DOBRINSKI, INA | UNIVERSITY OF CALGARY | N | 865 | NICHD | Non-SBIR/STTR | $211,650.00 | $16,932.00 | $228,582.00 | 2017 |
| 5U2CAG057441-03 | ARMADA: Advancing Reliable Measurement in Alzheimer’s Disease and cognitive Aging | GERSHON, RICHARD | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 866 | NIA | Other Research-Related | $2,255,631.00 | $521,035.00 | $2,776,666.00 | 2017 |
| 5R34DA041549-03 | Advancing STOP: Self-regulation/CBT Therapy for Opioid addiction and Pain | WACHHOLTZ, AMY B | UNIVERSITY OF COLORADO DENVER | N | 279 | NIDA | Non-SBIR/STTR | $162,995.00 | $69,171.00 | $232,166.00 | 2017 |
| 5R01AT009444-03 | A randomized trial of dance on mood, balance and brain in Alzheimer’s Disease | HUGENSCHMIDT, CHRISTINA E | WAKE FOREST UNIVERSITY HEALTH SCIENCES | N | 213 | NCCIH | Non-SBIR/STTR | $303,130.00 | $147,418.00 | $450,548.00 | 2017 |
| 5R03AI130174-02 | Receptor-mediated steps in enterovirus infection involve allostery | CARSON, STEVEN D | UNIVERSITY OF NEBRASKA MEDICAL CENTER | N | 855 | NIAID | Non-SBIR/STTR | $53,681.00 | $28,183.00 | $81,864.00 | 2017 |
| 5R21ES028911-02 | Mechanisms of carcinogenic effects of nickel nanoparticles | ZHANG, QUNWEI | UNIVERSITY OF LOUISVILLE | N | 113 | NIEHS | Non-SBIR/STTR | $125,000.00 | $67,500.00 | $192,500.00 | 2017 |
| 5R41DC016257-02 | Nucleobase aminosugars with reduced ototoxicity | ARYA, DEV PRIYA | NUBAD, LLC | N | 173 | NIDCD | SBIR/STTR | $364,433.00 | 2017 | ||
| 5SC2GM121250-03 | Photosensitization of albumin: a potential approach to modulate drug delivery into abnormal cells. | BRANCALEON, LORENZO | UNIVERSITY OF TEXAS SAN ANTONIO | N | 859 | NIGMS | Other Research-Related | $100,000.00 | $47,000.00 | $147,000.00 | 2017 |
| 5R00EB019482-05 | Neuroimaging of deep brain stimulation patients using safe MRI excitations | GUERIN, BASTIEN | MASSACHUSETTS GENERAL HOSPITAL | N | 286 | NIBIB | Non-SBIR/STTR | $145,557.00 | $103,345.00 | $248,902.00 | 2017 |
| 5R03AG052416-02 | Dementia Screening Using Automated Speech Analysis: A Pilot Study | DIAZ-ASPER, CATHERINE | MARYMOUNT UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $26,977.00 | $13,192.00 | $40,169.00 | 2018 |
| 5R21HD095338-02 | Ontogeny of Brainstem Arousal Networks in Human Consciousness | ZOLLEI, LILLA | MASSACHUSETTS GENERAL HOSPITAL | N | 865 | NICHD | Non-SBIR/STTR | $159,018.00 | $55,362.00 | $214,380.00 | 2018 |
| 5R21DA044749-02 | Imaging the monoaminergic midbrain and cognitive control in cocaine addiction | LI, CHIANG-SHAN RAY | YALE UNIVERSITY | N | 279 | NIDA | Non-SBIR/STTR | $125,000.00 | $58,750.00 | $183,750.00 | 2018 |
| 5R21ES029762-02 | Taking a Breath after the Disaster: Homes, Mold and Health in Puerto Rico after Hurricane Maria | CAVALLIN, HUMBERTO | UNIVERSITY OF PUERTO RICO RIO PIEDRAS | N | 113 | NIEHS | Non-SBIR/STTR | $197,918.00 | $20,918.00 | $218,836.00 | 2018 |
| 5R21NS104603-02 | Brain structure and function in adult ZIKV patients with neurological manifestations | SADAGHIANI, SEPIDEH | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | N | 853 | NINDS | Non-SBIR/STTR | $125,000.00 | $68,334.00 | $193,334.00 | 2018 |
| 5R21AR071585-02 | Engineering a biopolymer hydrogel to inhibit osteogenesis: Implications for growth plate repair | KREBS, MELISSA | COLORADO SCHOOL OF MINES | N | 846 | NIAMS | Non-SBIR/STTR | $160,954.00 | $27,236.00 | $188,190.00 | 2018 |
| 5R21MH114095-02 | Understanding Attentional Strengths and Weaknesses in Autism Spectrum Disorder | KEEHN, BRANDON | PURDUE UNIVERSITY | N | 242 | NIMH | Non-SBIR/STTR | $125,000.00 | $62,994.00 | $187,994.00 | 2018 |
| 5R21AG056765-02 | Integrating Mobile and Wearable Technology to Promote Physical Activity and Sleep among Midlife Adults: The Be SMART for Heart Health Trial | DOMINICK, GREGORY MITCHELL | UNIVERSITY OF DELAWARE | N | 866 | NIA | Non-SBIR/STTR | $155,526.00 | $81,813.00 | $237,339.00 | 2018 |
| 5R21ES028963-02 | Water disinfection by-products and female fertility | FLAWS, JODI A | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | N | 113 | NIEHS | Non-SBIR/STTR | $150,000.00 | $87,900.00 | $237,900.00 | 2018 |
| 5R21DA045296-02 | Understanding Cannabis Withdrawal: A PET Study of Endocannabinoid Metabolism | BOILEAU, ISABELLE | CENTRE FOR ADDICTION AND MENTAL HEALTH | N | 279 | NIDA | Non-SBIR/STTR | $138,522.00 | $11,082.00 | $149,604.00 | 2018 |
| 5R44EY024186-03 | Confocal and Autofluorescence Imaging of Macular Degeneration using a Low Cost Digital Imager | MULLER, MATTHEW S | AEON IMAGING, LLC | N | 867 | NEI | SBIR/STTR | $490,002.00 | 2018 | ||
| 1RF1AG062166-01 | The Adipocyte PPARgama/Adiponectin Axis and Alzheimer’s Disease | LU, XIN-YUN | AUGUSTA UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $2,263,725.00 | $1,212,245.00 | $3,475,970.00 | 2019 |
| 1RF1AG060718-01A1 | Calcineurin Mediates the Synergistic Toxicity of Tau and Aβ Oligomers | TAGLIALATELA, GIULIO | UNIVERSITY OF TEXAS MED BR GALVESTON | N | 866 | NIA | Non-SBIR/STTR | $2,248,680.00 | $1,284,070.00 | $3,532,750.00 | 2019 |
| 1RF1NS110354-01 | Role of Glucosylsphingosine in Parkinson Disease and Dementia with Lewy Bodies | CHANDRA, SREEGANGA S | YALE UNIVERSITY | N | 853 | NIA | Non-SBIR/STTR | $1,481,005.00 | $999,680.00 | $2,480,685.00 | 2019 |
| 1RF1AG059392-01A1 | Establishing MicroRNA Biomarkers for Diagnosing Alzheimer’s Disease & Predicting Progression | SAUGSTAD, JULIE ANNE | OREGON HEALTH & SCIENCE UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $2,246,520.00 | $1,183,330.00 | $3,429,850.00 | 2019 |
| 1R43CA236083-01 | Magnetomotive Embolization for Hepatocellular Carcinoma | CREIGHTON, FRANCIS MILTON | UNANDUP, LLC | N | 395 | NCI | SBIR/STTR | $299,821.00 | 2019 | ||
| 1R44AI138865-01A1 | Development of a novel therapy for mitigation of the irradiation-inducedgastrointestinal syndrome | DAINIAK, NICHOLAS | BIOINCEPT, LLC | N | 855 | NIAID | SBIR/STTR | $207,237.00 | 2019 | ||
| 1OT2OD027070-01 | Population-Scale Clinical Genomics | LEVY, SHAWN E | HUDSON-ALPHA INSTITUTE FOR BIOTECHNOLOGY | N | 350 | NCATS | Other | $5,627,051.00 | $1,372,440.00 | $6,999,491.00 | 2019 |
| 1R21NS107884-01A1 | Cellular immunity in intractable pediatric epilepsy | OWENS, GEOFFREY C | UNIVERSITY OF CALIFORNIA LOS ANGELES | N | 853 | NINDS | Non-SBIR/STTR | $275,000.00 | $154,000.00 | $429,000.00 | 2019 |
| 1RF1AG061774-01 | Slow-wave activity as a modifier of the progression of neurodegeneration in Alzheimer’s disease | GERASHCHENKO, DMITRY | HARVARD MEDICAL SCHOOL | N | 866 | NIA | Non-SBIR/STTR | $3,065,681.00 | $397,543.00 | $3,463,224.00 | 2019 |
/*QUERY WITH USED CHECK WHICH YEAR THE FUNDING WAS DISBURSED QUARTERLY*/
WITH QUARTERLYFUNDING AS
(Select ProjectNumber, ProjectTitle, PrimaryPI, OrganizationName, ArraIndicator, CfdaCode, FundingICS, FundingMechanism, TotalCostIC AS TotalFundingDisbursed, Strftime("%m", ProjectStartDate) as Months, Strftime("%Y", ProjectStartDate) As FundingDisbursed
From Projects
Inner join ProjectPersonIncharge on ProjectPersonincharge.ProjectID = Projects.ProjectID
Inner join Organizations on Organizations.OrganizationID = ProjectpersonIncharge.OrganizationID
Inner Join GovermentFunding on GovermentFunding.FundingID = Organizations.FundingID
Inner Join Cost on Cost.FundingID = GovermentFunding.FundingID
Group by ProjectNumber
ORDER BY FUNDINGDISBURSED)
SELECT Months, Case when Months in ("01", "02", "03") THEN "Q1"
when Months in ("04","05","06") THEN "Q2"
when months in ("07", "08", "09") THEN "Q2"
Else "Q4"
END as QUARTERS,
FundingDIsbursed, ProjectNumber, ProjectTitle, PrimaryPI, OrganizationName, ArraIndicator, CfdaCode, FundingICS, FundingMechanism,TotalFundingDisbursed
From QuarterlyFunding
Group by ProjectNumber
Order by Quarters
| Months | QUARTERS | FundingDisbursed | ProjectNumber | ProjectTitle | PrimaryPI | OrganizationName | ArraIndicator | CfdaCode | FundingICS | FundingMechanism | TotalFundingDisbursed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 03 | Q1 | 2019 | 1R21NS107884-01A1 | Cellular immunity in intractable pediatric epilepsy | OWENS, GEOFFREY C | UNIVERSITY OF CALIFORNIA LOS ANGELES | N | 853 | NINDS | Non-SBIR/STTR | $429,000.00 |
| 03 | Q1 | 2019 | 1R43CA236083-01 | Magnetomotive Embolization for Hepatocellular Carcinoma | CREIGHTON, FRANCIS MILTON | UNANDUP, LLC | N | 395 | NCI | SBIR/STTR | $299,821.00 |
| 02 | Q1 | 2019 | 1RF1AG059392-01A1 | Establishing MicroRNA Biomarkers for Diagnosing Alzheimer’s Disease & Predicting Progression | SAUGSTAD, JULIE ANNE | OREGON HEALTH & SCIENCE UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $3,429,850.00 |
| 02 | Q1 | 2019 | 1RF1AG060718-01A1 | Calcineurin Mediates the Synergistic Toxicity of Tau and Aβ Oligomers | TAGLIALATELA, GIULIO | UNIVERSITY OF TEXAS MED BR GALVESTON | N | 866 | NIA | Non-SBIR/STTR | $3,532,750.00 |
| 02 | Q1 | 2019 | 1RF1AG062166-01 | The Adipocyte PPARgama/Adiponectin Axis and Alzheimer’s Disease | LU, XIN-YUN | AUGUSTA UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $3,475,970.00 |
| 03 | Q1 | 2003 | 5R01AA013892-15 | Chronic Alcohol and Brain Stress Circuit Response | SINHA, RAJITA | YALE UNIVERSITY | N | 273 | NIAAA | Non-SBIR/STTR | $611,588.00 |
| 01 | Q1 | 2015 | 5R01CA183101-05 | Biophotonics to Couple Pancreatic with Upper GI Screening via Ultrathin Endoscopy | BACKMAN, VADIM | NORTHWESTERN UNIVERSITY | N | 394 | NCI | Non-SBIR/STTR | $598,589.00 |
| 01 | Q1 | 2015 | 5R01CA185322-05 | Epigenetics and Infection-induced EMT of Colonic Crypts - Target for Chemoprevention | UMAR, SHAHID | UNIVERSITY OF KANSAS MEDICAL CENTER | N | 393 | NCI | Non-SBIR/STTR | $373,069.00 |
| 03 | Q1 | 1988 | 5R01HL039752-31 | Elevated Calcium and Myocardial Ischemia injury | STEENBERGEN, CHARLES | JOHNS HOPKINS UNIVERSITY | N | 837 | NHLBI | Non-SBIR/STTR | $405,000.00 |
| 03 | Q1 | 2016 | 5R01HL126099-04 | Adapting the Diabetes Prevention Program for a developing world context | CATLEY, DELWYN | CHILDREN’S MERCY HOSP (KANSAS CITY, MO) | N | 837 | NHLBI | Non-SBIR/STTR | $665,791.00 |
| 03 | Q1 | 2018 | 5R21DA044749-02 | Imaging the monoaminergic midbrain and cognitive control in cocaine addiction | LI, CHIANG-SHAN RAY | YALE UNIVERSITY | N | 279 | NIDA | Non-SBIR/STTR | $183,750.00 |
| 01 | Q1 | 2016 | 5UM1HG008895-04 | Center for Common Disease Genetics | GABRIEL, STACEY | BROAD INSTITUTE, INC. | N | 172 | NHGRI | Non-SBIR/STTR | $20,000,000.00 |
| 09 | Q2 | 2019 | 1OT2OD027070-01 | Population-Scale Clinical Genomics | LEVY, SHAWN E | HUDSON-ALPHA INSTITUTE FOR BIOTECHNOLOGY | N | 350 | NCATS | Other | $6,999,491.00 |
| 05 | Q2 | 2019 | 1R44AI138865-01A1 | Development of a novel therapy for mitigation of the irradiation-inducedgastrointestinal syndrome | DAINIAK, NICHOLAS | BIOINCEPT, LLC | N | 855 | NIAID | SBIR/STTR | $207,237.00 |
| 04 | Q2 | 2019 | 1RF1AG061774-01 | Slow-wave activity as a modifier of the progression of neurodegeneration in Alzheimer’s disease | GERASHCHENKO, DMITRY | HARVARD MEDICAL SCHOOL | N | 866 | NIA | Non-SBIR/STTR | $3,463,224.00 |
| 09 | Q2 | 2019 | 1RF1NS110354-01 | Role of Glucosylsphingosine in Parkinson Disease and Dementia with Lewy Bodies | CHANDRA, SREEGANGA S | YALE UNIVERSITY | N | 853 | NIA | Non-SBIR/STTR | $2,480,685.00 |
| 09 | Q2 | 2015 | 5K08DK103945-05 | Circulating MicroRNAs and Hyperglycemia | WANDER (JANUSZEWSKI), PANDORA "LUKE" | UNIVERSITY OF WASHINGTON | N | 847 | NIDDK | Other Research-Related | $161,884.00 |
| 09 | Q2 | 2015 | 5K08NS094683-05 | Effect of ABCD1 upon Brain Endothelium in X-linked Adrenoleukodystrophy | MUSOLINO, PATRICIA LEONOR | MASSACHUSETTS GENERAL HOSPITAL | N | 853 | NINDS | Other Research-Related | $199,040.00 |
| 05 | Q2 | 2016 | 5K23HL130648-04 | Optimizing ED to ICU triage decisions for critically ill patients in respiratory distress | MATHEWS, KUSUM SARA | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | N | 838 | NHLBI | Other Research-Related | $166,574.00 |
| 07 | Q2 | 2017 | 5R00EB019482-05 | Neuroimaging of deep brain stimulation patients using safe MRI excitations | GUERIN, BASTIEN | MASSACHUSETTS GENERAL HOSPITAL | N | 286 | NIBIB | Non-SBIR/STTR | $248,902.00 |
| 08 | Q2 | 2012 | 5R01AG041721-08 | Quantifying Brain Abnormality by Multimodality Neuroimage Analysis | LIU, MINGXIA | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 866 | NIA | Non-SBIR/STTR | $350,863.00 |
| 04 | Q2 | 2016 | 5R01AG050588-04 | Transdermal Nitroglycerin Therapy for Menopausal Hot Flashes | HUANG, ALISON | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 866 | NIA | Non-SBIR/STTR | $537,166.00 |
| 09 | Q2 | 2016 | 5R01AG053325-04 | Non-esterified Fatty Acids and Cardiometabolic Disease in Older Adults | DJOUSSE, LUC | BRIGHAM AND WOMEN’S HOSPITAL | N | 866 | NIA | Non-SBIR/STTR | $653,228.00 |
| 08 | Q2 | 2016 | 5R01AI124804-04 | Impact of Fc N-glycan structure on HIV-specific antibody functions | JARVIS, DONALD L. | UNIVERSITY OF WYOMING | N | 855 | NIAID | Non-SBIR/STTR | $733,243.00 |
| 05 | Q2 | 2017 | 5R01AT009444-03 | A randomized trial of dance on mood, balance and brain in Alzheimer’s Disease | HUGENSCHMIDT, CHRISTINA E | WAKE FOREST UNIVERSITY HEALTH SCIENCES | N | 213 | NCCIH | Non-SBIR/STTR | $450,548.00 |
| 04 | Q2 | 1996 | 5R01CA066980-25 | Biological Activity of HPV E7 in Human Epithelial Cells | MUNGER, KARL | TUFTS UNIVERSITY BOSTON | N | 393 | NCI | Non-SBIR/STTR | $360,112.00 |
| 07 | Q2 | 2014 | 5R01CA181064-06 | Yoga Versus CBT-I for Insomnia in Cancer Survivors and Biobehavioral Mechanisms | MUSTIAN, KAREN M. | UNIVERSITY OF ROCHESTER | N | 395 | NCI | Non-SBIR/STTR | $679,709.00 |
| 05 | Q2 | 2015 | 5R01CA186338-05 | ZIP4 is a Novel Molecular Target in Human Pancreatic Cancer | LI, MIN | UNIVERSITY OF OKLAHOMA HLTH SCIENCES CTR | N | 396 | NCI | Non-SBIR/STTR | $332,649.00 |
| 05 | Q2 | 2015 | 5R01CA187037-05 | Combined Biologic and Radiopharmaceutical Therapy of Breast Cancer | SGOUROS, GEORGE | JOHNS HOPKINS UNIVERSITY | N | 395 | NCI | Non-SBIR/STTR | $459,386.00 |
| 08 | Q2 | 2015 | 5R01CA191317-05 | Separating autoimmunity and anti-tumor immunity | LE POOLE, I CAROLINE | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 395 | NCI | Non-SBIR/STTR | $349,910.00 |
| 04 | Q2 | 2015 | 5R01CA193343-05 | Genetic Mapping of Breast Cancer Risk in the Tumor Microenvironment | JOSHI, AMIT | MEDICAL COLLEGE OF WISCONSIN | N | 396 | NCI | Non-SBIR/STTR | $341,706.00 |
| 07 | Q2 | 2015 | 5R01DA038154-05 | Cognitive Control in Children of SUD Parents: A Longitudinal Multimodal MRI Study | HOVEN, CHRISTINA W. | NEW YORK STATE PSYCHIATRIC INSTITUTE | N | 279 | NIDA | Non-SBIR/STTR | $637,556.00 |
| 07 | Q2 | 2015 | 5R01DA039071-05 | Texting intervention to sustain HIV prevention in women in high-drug-use contexts | PATTERSON, THOMAS L. | UNIVERSITY OF CALIFORNIA, SAN DIEGO | N | 279 | NIDA | Non-SBIR/STTR | $624,292.00 |
| 05 | Q2 | 2015 | 5R01DA039533-05 | Effects of early life stress on synaptic function and DA signaling in the VTA | NUGENT, FERESHTEH S | HENRY M. JACKSON FDN FOR THE ADV MIL/MED | N | 279 | NIDA | Non-SBIR/STTR | $358,309.00 |
| 09 | Q2 | 2015 | 5R01DA041032-05 | Optimizing HIV counseling testing and referral through an adaptive drug use intervention | STEPHENSON, ROB B. | UNIVERSITY OF MICHIGAN AT ANN ARBOR | N | 279 | NIDA | Non-SBIR/STTR | $682,257.00 |
| 04 | Q2 | 2016 | 5R01DA041438-04 | Effects of cigarette availability on neural and subjective sensitivity to rewards | WILSON, STEPHEN JEFFREY | PENNSYLVANIA STATE UNIVERSITY-UNIV PARK | N | 279 | NIDA | Non-SBIR/STTR | $353,700.00 |
| 09 | Q2 | 2004 | 5R01DE016402-14 | Mesenchymal Regulation of Osteogenesis | SCHNEIDER, RICHARD A | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 121 | NIDCR | Non-SBIR/STTR | $396,250.00 |
| 07 | Q2 | 2006 | 5R01DE017732-11 | Diabetes-enhanced Experimental Periodontitis | GRAVES, DANA T | UNIVERSITY OF PENNSYLVANIA | N | 121 | NIDCR | Non-SBIR/STTR | $430,558.00 |
| 04 | Q2 | 2003 | 5R01DK064324-15 | Multiphoton imaging of the juxtaglomerular apparatus | PETI-PETERDI, JANOS | UNIVERSITY OF SOUTHERN CALIFORNIA | N | 847 | NIDDK | Non-SBIR/STTR | $432,737.00 |
| 04 | Q2 | 2004 | 5R01DK064814-13 | Acitivity for Diabetic Polyneuropathy: The ADAPT Study | SINGLETON, JOHN ROBINSON | UNIVERSITY OF UTAH | N | 847 | NIDDK | Non-SBIR/STTR | $642,156.00 |
| 08 | Q2 | 2015 | 5R01DK101505-05 | Whole-exome Sequencing Study of Diabetic Nephropathy | KELLY, TANIKA NICOLE | TULANE UNIVERSITY OF LOUISIANA | N | 847 | NIDDK | Non-SBIR/STTR | $287,428.00 |
| 04 | Q2 | 2016 | 5R01DK105526-04 | Novel pharmacotherapy strategies for obesity in schizophrenia | JARSKOG, LARS FREDRIK | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 847 | NIDDK | Non-SBIR/STTR | $657,518.00 |
| 07 | Q2 | 2015 | 5R01ES025135-05 | Participatory Interventions to Reduce Arsenic in American Indian Communities | GEORGE, CHRISTINE MARIE | JOHNS HOPKINS UNIVERSITY | N | 113 | NIEHS | Non-SBIR/STTR | $585,477.00 |
| 05 | Q2 | 2016 | 5R01EY026584-04 | Novel Imaging of rod oxidative stress in retinal disease and treatment in vivo | BERKOWITZ, BRUCE A. | WAYNE STATE UNIVERSITY | N | 867 | NEI | Non-SBIR/STTR | $385,000.00 |
| 07 | Q2 | 1996 | 5R01GM028157-38 | Inherited Variations In Drug Metabolizing Enzymes | WEINSHILBOUM, RICHARD M. | MAYO CLINIC ROCHESTER | N | 859 | NIGMS | Non-SBIR/STTR | $419,836.00 |
| 09 | Q2 | 2011 | 5R01GM098539-08 | Analytical tools for the analysis of clustered O-glycans in clinical samples | RENFROW, MATTHEW B | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 859 | NIGMS | Non-SBIR/STTR | $352,112.00 |
| 05 | Q2 | 2015 | 5R01GM111682-05 | PARylation in genotoxic stress-induced NF-kB activation | WAN, FENGYI | JOHNS HOPKINS UNIVERSITY | N | 859 | NIGMS | Non-SBIR/STTR | $311,850.00 |
| 09 | Q2 | 2003 | 5R01HD045713-16 | The Dynamics of Visual Attention and Word Learning | SAMUELSON, LARISSA K | UNIVERSITY OF EAST ANGLIA | N | 865 | NICHD | Non-SBIR/STTR | $292,330.00 |
| 04 | Q2 | 2017 | 5R01HD091068-03 | A System for Culturing Mammalian Spermatogonial Cells | DOBRINSKI, INA | UNIVERSITY OF CALGARY | N | 865 | NICHD | Non-SBIR/STTR | $228,582.00 |
| 08 | Q2 | 2015 | 5R01HL122684-05 | Genetic Studies of The Impact of Hematologic Traits On Cardiovascular Disease | GANESH, SANTHI K | UNIVERSITY OF MICHIGAN AT ANN ARBOR | N | 837 | NHLBI | Non-SBIR/STTR | $678,076.00 |
| 08 | Q2 | 2015 | 5R01HL126117-05 | TELmisartan plus EXercise to improve functioning in PAD: The TELEX Trial | MCDERMOTT, MARY MCGRAE | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 837 | NHLBI | Non-SBIR/STTR | $713,702.00 |
| 08 | Q2 | 2015 | 5R01HL126666-05 | Growing Resilience in Wind River Indian Reservation: an RCT on gardens for health | PORTER, CHRISTINE MICHELLE | UNIVERSITY OF WYOMING | N | 837 | NHLBI | Non-SBIR/STTR | $614,840.00 |
| 06 | Q2 | 2016 | 5R01HL127338-04 | The Role of ZFP36 in Control of IPF | DING, QIANG | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 838 | NHLBI | Non-SBIR/STTR | $367,500.00 |
| 04 | Q2 | 2016 | 5R01HL128388-04 | Adverse Neurogenic Actions of Dietary Salt | FARQUHAR, WILLIAM B | UNIVERSITY OF DELAWARE | N | 837 | NHLBI | Non-SBIR/STTR | $645,425.00 |
| 06 | Q2 | 2015 | 5R01HL128592-05 | Novel MRI techniques for imaging cardiac fibrosis to improve clinical practice in patients with renal failure | VANDSBURGER, MORIEL | UNIVERSITY OF CALIFORNIA BERKELEY | N | 837 | NHLBI | Non-SBIR/STTR | $392,500.00 |
| 07 | Q2 | 2016 | 5R01HL128785-04 | Computer-Aided Diagnosis of Pulmonary Embolism | LIANG, JIANMING | ARIZONA STATE UNIVERSITY-TEMPE CAMPUS | N | 838 | NHLBI | Non-SBIR/STTR | $586,687.00 |
| 05 | Q2 | 2016 | 5R01HL129077-04 | Novel Simulation Technologies for BHV Long-Term Durability | SACKS, MICHAEL S | UNIVERSITY OF TEXAS, AUSTIN | N | 837 | NHLBI | Non-SBIR/STTR | $475,266.00 |
| 05 | Q2 | 2015 | 5R01HL129472-05 | Selection of Allogeneic Hematopoietic Cell Donor Based on KIR and HLA Genotypes | HSU, KATHARINE C | SLOAN-KETTERING INST CAN RESEARCH | N | 839 | NHLBI | Non-SBIR/STTR | $480,567.00 |
| 07 | Q2 | 2016 | 5R01HL130376-04 | Final preclinical development of AAV gene therapy for atrial fibrillation | DONAHUE, J KEVIN | UNIV OF MASSACHUSETTS MED SCH WORCESTER | N | 837 | NHLBI | Non-SBIR/STTR | $721,436.00 |
| 07 | Q2 | 2016 | 5R01HL131017-04 | Stem Cell Therapy for Myocardial Repair | ZHANG, JIANYI | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 837 | NHLBI | Non-SBIR/STTR | $733,001.00 |
| 06 | Q2 | 2015 | 5R01MH106450-05 | Cognitive Enhancement Therapy for Adult Autism Spectrum Disorder | EACK, SHAUN M | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | N | 242 | NIMH | Non-SBIR/STTR | $604,408.00 |
| 09 | Q2 | 2015 | 5R01NR015241-05 | Advancing CBPR Practice Through a Collective Reflection and Measurement Toolkit | WALLERSTEIN, NINA B | UNIVERSITY OF NEW MEXICO HEALTH SCIS CTR | N | 361 | NINR | Non-SBIR/STTR | $479,541.00 |
| 07 | Q2 | 1985 | 5R01NS022061-35 | Modulation of neuronal acetylcholine receptors | PLOTKIN, JOSHUA L | STATE UNIVERSITY NEW YORK STONY BROOK | N | 853 | NINDS | Non-SBIR/STTR | $465,779.00 |
| 07 | Q2 | 2015 | 5R01NS088645-05 | Etiological Linkage of DNA Damage/Repair Deficiency in Neurodegenerative Diseases | HEGDE, MURALIDHAR L | METHODIST HOSPITAL RESEARCH INSTITUTE | N | 853 | NINDS | Non-SBIR/STTR | $344,594.00 |
| 08 | Q2 | 2015 | 5R01NS093362-05 | Defining the role of FUS phosphorylation in neurodegeneration | KUKAR, THOMAS L | EMORY UNIVERSITY | N | 853 | NINDS | Non-SBIR/STTR | $383,053.00 |
| 04 | Q2 | 2016 | 5R01NS096755-04 | From brain iron deficiency to therapeutic opportunities in mucolipidosis IV | KISELYOV, KIRILL | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | N | 853 | NINDS | Non-SBIR/STTR | $410,250.00 |
| 04 | Q2 | 2018 | 5R03AG052416-02 | Dementia Screening Using Automated Speech Analysis: A Pilot Study | DIAZ-ASPER, CATHERINE | MARYMOUNT UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $40,169.00 |
| 07 | Q2 | 2018 | 5R21AG056765-02 | Integrating Mobile and Wearable Technology to Promote Physical Activity and Sleep among Midlife Adults: The Be SMART for Heart Health Trial | DOMINICK, GREGORY MITCHELL | UNIVERSITY OF DELAWARE | N | 866 | NIA | Non-SBIR/STTR | $237,339.00 |
| 05 | Q2 | 2018 | 5R21AR071585-02 | Engineering a biopolymer hydrogel to inhibit osteogenesis: Implications for growth plate repair | KREBS, MELISSA | COLORADO SCHOOL OF MINES | N | 846 | NIAMS | Non-SBIR/STTR | $188,190.00 |
| 07 | Q2 | 2018 | 5R21DA045296-02 | Understanding Cannabis Withdrawal: A PET Study of Endocannabinoid Metabolism | BOILEAU, ISABELLE | CENTRE FOR ADDICTION AND MENTAL HEALTH | N | 279 | NIDA | Non-SBIR/STTR | $149,604.00 |
| 07 | Q2 | 2018 | 5R21ES028963-02 | Water disinfection by-products and female fertility | FLAWS, JODI A | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | N | 113 | NIEHS | Non-SBIR/STTR | $237,900.00 |
| 04 | Q2 | 2018 | 5R21ES029762-02 | Taking a Breath after the Disaster: Homes, Mold and Health in Puerto Rico after Hurricane Maria | CAVALLIN, HUMBERTO | UNIVERSITY OF PUERTO RICO RIO PIEDRAS | N | 113 | NIEHS | Non-SBIR/STTR | $218,836.00 |
| 04 | Q2 | 2018 | 5R21HD095338-02 | Ontogeny of Brainstem Arousal Networks in Human Consciousness | ZOLLEI, LILLA | MASSACHUSETTS GENERAL HOSPITAL | N | 865 | NICHD | Non-SBIR/STTR | $214,380.00 |
| 05 | Q2 | 2018 | 5R21MH114095-02 | Understanding Attentional Strengths and Weaknesses in Autism Spectrum Disorder | KEEHN, BRANDON | PURDUE UNIVERSITY | N | 242 | NIMH | Non-SBIR/STTR | $187,994.00 |
| 06 | Q2 | 2018 | 5R21NS104603-02 | Brain structure and function in adult ZIKV patients with neurological manifestations | SADAGHIANI, SEPIDEH | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | N | 853 | NINDS | Non-SBIR/STTR | $193,334.00 |
| 06 | Q2 | 2016 | 5R24OD021479-04 | Developing Regeneration Resources for a Model Amphibian | VOSS, STEPHEN RANDAL | UNIVERSITY OF KENTUCKY | N | 351 | OD | Other Research-Related | $557,910.00 |
| 06 | Q2 | 2016 | 5R24OD021997-04 | Drosophila resources for modeling human diseases | PERRIMON, NORBERT | HARVARD MEDICAL SCHOOL | N | 351 | OD | Other Research-Related | $378,409.00 |
| 07 | Q2 | 2017 | 5R34DA041549-03 | Advancing STOP: Self-regulation/CBT Therapy for Opioid addiction and Pain | WACHHOLTZ, AMY B | UNIVERSITY OF COLORADO DENVER | N | 279 | NIDA | Non-SBIR/STTR | $232,166.00 |
| 09 | Q2 | 2016 | 5R44AG056012-03 | Mobility Rehab: A Biofeedback System for Mobility Rehabilitation for Older Adults | EL-GOHARY, MAHMOUD | APDM, INC. | N | 866 | NIA | SBIR/STTR | $676,357.00 |
| 08 | Q2 | 2015 | 5R44CA199058-03 | A Prognostic Blood Test to Monitor Pancreatic Cancer Treatment by MiRNA Profiling | SARAF, RAVI | VAJRA INSTRUMENTS, INC. | N | 394 | NCI | SBIR/STTR | $999,597.00 |
| 04 | Q2 | 2015 | 5R44DC014173-03 | Expressive Speech Synthesis for Speech-Generating Devices | HERTZ, SUSAN R | SYNFONICA, LLC | N | 173 | NIDCD | SBIR/STTR | $492,816.00 |
| 04 | Q2 | 2018 | 5R44EY024186-03 | Confocal and Autofluorescence Imaging of Macular Degeneration using a Low Cost Digital Imager | MULLER, MATTHEW S | AEON IMAGING, LLC | N | 867 | NEI | SBIR/STTR | $490,002.00 |
| 09 | Q2 | 2017 | 5SC2GM121250-03 | Photosensitization of albumin: a potential approach to modulate drug delivery into abnormal cells. | BRANCALEON, LORENZO | UNIVERSITY OF TEXAS SAN ANTONIO | N | 859 | NIGMS | Other Research-Related | $147,000.00 |
| 05 | Q2 | 2015 | 5U01AI114378-05 | Experimental human infection with isogenic mutants of Neisseria gonorrhoeae | HOBBS, MARCIA METZGAR | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 855 | NIAID | Non-SBIR/STTR | $1.00 |
| 09 | Q2 | 2008 | 5U01DK082944-12 | Hepatitis B Research Network (HBRN): Natural History and Treatment Studies | KHALILI, MANDANA | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 847 | NIDDK | Non-SBIR/STTR | $742,927.00 |
| 06 | Q2 | 2016 | 5U01ES026721-04 | Epigenomics of Air Pollution driven Inflammation, Obesity and Insulin Resistance | BISWAL, SHYAM | JOHNS HOPKINS UNIVERSITY | N | 113 | NIEHS | Non-SBIR/STTR | $635,267.00 |
| 05 | Q2 | 2016 | 5U01HG009088-04 | Powering whole genome sequence-based genetic discovery for common human diseases | LIN, XIHONG | HARVARD SCHOOL OF PUBLIC HEALTH | N | 172 | NHGRI | Non-SBIR/STTR | $884,756.00 |
| 09 | Q2 | 2017 | 5U2CAG057441-03 | ARMADA: Advancing Reliable Measurement in Alzheimer’s Disease and cognitive Aging | GERSHON, RICHARD | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 866 | NIA | Other Research-Related | $2,776,666.00 |
| 09 | Q2 | 2014 | 5U54HL127366-06 | Broad Institute LINCS Center for Transcriptomics | SUBRAMANIAN, ARAVIND | BROAD INSTITUTE, INC. | N | 837 | OD | Research Centers | $2,108,141.00 |
| 08 | Q2 | 2015 | 5UL1TR001433-05 | MSHS Translational Science Hub | WRIGHT, ROSALIND J | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | N | 350 | NCATS | Research Centers | $5,133,391.00 |
| 12 | Q4 | 2005 | 5R01AI067946-14 | Directing Function at the Natural Killer Cell Secretory Immunological Synapse | ORANGE, JORDAN SCOTT | COLUMBIA UNIVERSITY HEALTH SCIENCES | N | 855 | NIAID | Non-SBIR/STTR | $421,462.00 |
| 12 | Q4 | 2014 | 5R01CA183749-05 | Optimizing cancer photodynamic therapy using photoacoustic lifetime imaging | ASHKENAZI, SHAI | UNIVERSITY OF MINNESOTA | N | 394 | NCI | Non-SBIR/STTR | $313,573.00 |
| 12 | Q4 | 2015 | 5R01DK104867-04 | Dorsomedial Hypothalamic Signaling Pathways and Energy Balance | BI, SHENG | JOHNS HOPKINS UNIVERSITY | N | 847 | NIDDK | Non-SBIR/STTR | $364,500.00 |
| 12 | Q4 | 2015 | 5R01EY026155-04 | Role of aquaporins in mammalian lens development,transparency and homeostasis | VARADARAJ, KULANDAIAPPAN | STATE UNIVERSITY NEW YORK STONY BROOK | N | 867 | NEI | Non-SBIR/STTR | $395,000.00 |
| 12 | Q4 | 2014 | 5R01MH100318-05 | Amygdala-mediated enhancement of the hippocampal memory system | MANNS, JOSEPH R | EMORY UNIVERSITY | N | 242 | NIMH | Non-SBIR/STTR | $387,900.00 |
| 12 | Q4 | 2017 | 5R03AI130174-02 | Receptor-mediated steps in enterovirus infection involve allostery | CARSON, STEVEN D | UNIVERSITY OF NEBRASKA MEDICAL CENTER | N | 855 | NIAID | Non-SBIR/STTR | $81,864.00 |
| 12 | Q4 | 2017 | 5R21ES028911-02 | Mechanisms of carcinogenic effects of nickel nanoparticles | ZHANG, QUNWEI | UNIVERSITY OF LOUISVILLE | N | 113 | NIEHS | Non-SBIR/STTR | $192,500.00 |
| 12 | Q4 | 2017 | 5R41DC016257-02 | Nucleobase aminosugars with reduced ototoxicity | ARYA, DEV PRIYA | NUBAD, LLC | N | 173 | NIDCD | SBIR/STTR | $364,433.00 |
| 12 | Q4 | 2011 | 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | VALLE, DAVID | JOHNS HOPKINS UNIVERSITY | N | 172 | NHLBI | Non-SBIR/STTR | $550,000.00 |
/*QUERY TO RANK PROJECT INCHARGE ACCORDING TO THEIR FUNDING RECIEVED IN EVERY YEAR*/
CREATE VIEW IF NOT EXISTS PROJECTINCHARGERANK
AS
Select ProjectNumber, ProjectTitle, RANK() OVER (ORDER BY PrimaryPI DESC) AS INCHARGERANK , OrganizationName, ArraIndicator, CfdaCode, FundingICS, FundingMechanism, DirectCostIC, IndirectCostIC,TotalCostIC, Strftime("%Y", ProjectStartDate) As FundingDisbursed
From Projects
Inner join ProjectPersonIncharge on ProjectPersonincharge.ProjectID = Projects.ProjectID
Inner join Organizations on Organizations.OrganizationID = ProjectpersonIncharge.OrganizationID
Inner Join GovermentFunding on GovermentFunding.FundingID = Organizations.FundingID
Inner Join Cost on Cost.FundingID = GovermentFunding.FundingID
## LIST NUMBER OF TABLES IN DATABASE
dbListTables(NRAFDB)
## [1] "CenterFunding" "Cost" "GoogleScholar"
## [4] "GovermentFunding" "NARFCategorizations" "Organizations"
## [7] "PROJECTINCHARGERANK" "PUBMED" "Patents"
## [10] "ProjectPersonInCharge" "Projects" "Publications"
## [13] "PublicationsLinks" "SubProject" "sqlite_sequence"
/*CONFIRMATION */
SELECT * FROM PROJECTINCHARGERANK
| ProjectNumber | ProjectTitle | INCHARGERANK | OrganizationName | ARRAIndicator | CFDACode | FundingICS | FundingMechanism | DirectCostIC | IndirectCostIC | TotalCostIC | FundingDisbursed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5R21HD095338-02 | Ontogeny of Brainstem Arousal Networks in Human Consciousness | 1 | MASSACHUSETTS GENERAL HOSPITAL | N | 865 | NICHD | Non-SBIR/STTR | $159,018.00 | $55,362.00 | $214,380.00 | 2018 |
| 5R21ES028911-02 | Mechanisms of carcinogenic effects of nickel nanoparticles | 2 | UNIVERSITY OF LOUISVILLE | N | 113 | NIEHS | Non-SBIR/STTR | $125,000.00 | $67,500.00 | $192,500.00 | 2017 |
| 5R01HL131017-04 | Stem Cell Therapy for Myocardial Repair | 3 | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 837 | NHLBI | Non-SBIR/STTR | $561,107.00 | $171,894.00 | $733,001.00 | 2016 |
| 5UL1TR001433-05 | MSHS Translational Science Hub | 4 | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | N | 350 | NCATS | Research Centers | $3,666,560.00 | $2,446,919.00 | $5,133,391.00 | 2015 |
| 5R01DA041438-04 | Effects of cigarette availability on neural and subjective sensitivity to rewards | 5 | PENNSYLVANIA STATE UNIVERSITY-UNIV PARK | N | 279 | NIDA | Non-SBIR/STTR | $225,000.00 | $128,700.00 | $353,700.00 | 2016 |
| 5R01GM028157-38 | Inherited Variations In Drug Metabolizing Enzymes | 6 | MAYO CLINIC ROCHESTER | N | 859 | NIGMS | Non-SBIR/STTR | $270,000.00 | $149,836.00 | $419,836.00 | 1996 |
| 5K08DK103945-05 | Circulating MicroRNAs and Hyperglycemia | 7 | UNIVERSITY OF WASHINGTON | N | 847 | NIDDK | Other Research-Related | $149,900.00 | $11,984.00 | $161,884.00 | 2015 |
| 5R01GM111682-05 | PARylation in genotoxic stress-induced NF-kB activation | 8 | JOHNS HOPKINS UNIVERSITY | N | 859 | NIGMS | Non-SBIR/STTR | $192,500.00 | $119,350.00 | $311,850.00 | 2015 |
| 5R01NR015241-05 | Advancing CBPR Practice Through a Collective Reflection and Measurement Toolkit | 9 | UNIVERSITY OF NEW MEXICO HEALTH SCIS CTR | N | 361 | NINR | Non-SBIR/STTR | $371,960.00 | $107,581.00 | $479,541.00 | 2015 |
| 5R34DA041549-03 | Advancing STOP: Self-regulation/CBT Therapy for Opioid addiction and Pain | 10 | UNIVERSITY OF COLORADO DENVER | N | 279 | NIDA | Non-SBIR/STTR | $162,995.00 | $69,171.00 | $232,166.00 | 2017 |
| 5R24OD021479-04 | Developing Regeneration Resources for a Model Amphibian | 11 | UNIVERSITY OF KENTUCKY | N | 351 | OD | Other Research-Related | $438,764.00 | $119,146.00 | $557,910.00 | 2016 |
| 5R01EY026155-04 | Role of aquaporins in mammalian lens development,transparency and homeostasis | 12 | STATE UNIVERSITY NEW YORK STONY BROOK | N | 867 | NEI | Non-SBIR/STTR | $250,000.00 | $145,000.00 | $395,000.00 | 2015 |
| 5R01HL128592-05 | Novel MRI techniques for imaging cardiac fibrosis to improve clinical practice in patients with renal failure | 13 | UNIVERSITY OF CALIFORNIA BERKELEY | N | 837 | NHLBI | Non-SBIR/STTR | $250,000.00 | $142,500.00 | $392,500.00 | 2015 |
| 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | 14 | JOHNS HOPKINS UNIVERSITY | N | 172 | NHLBI | Non-SBIR/STTR | $449,683.00 | $100,317.00 | $550,000.00 | 2011 |
| 5UM1HG006542-08 | Baylor Johns Hopkins Center for Mendelian Genetics | 14 | JOHNS HOPKINS UNIVERSITY | N | 172 | NHGRI | Non-SBIR/STTR | $3,530,479.00 | $787,589.00 | $2,318,900.00 | 2011 |
| 5R01CA185322-05 | Epigenetics and Infection-induced EMT of Colonic Crypts - Target for Chemoprevention | 16 | UNIVERSITY OF KANSAS MEDICAL CENTER | N | 393 | NCI | Non-SBIR/STTR | $258,009.00 | $115,060.00 | $373,069.00 | 2015 |
| 1RF1AG060718-01A1 | Calcineurin Mediates the Synergistic Toxicity of Tau and Aβ Oligomers | 17 | UNIVERSITY OF TEXAS MED BR GALVESTON | N | 866 | NIA | Non-SBIR/STTR | $2,248,680.00 | $1,284,070.00 | $3,532,750.00 | 2019 |
| 5U54HL127366-06 | Broad Institute LINCS Center for Transcriptomics | 18 | BROAD INSTITUTE, INC. | N | 837 | OD | Research Centers | $1,895,344.00 | $212,797.00 | $2,108,141.00 | 2014 |
| 5R01DA041032-05 | Optimizing HIV counseling testing and referral through an adaptive drug use intervention | 19 | UNIVERSITY OF MICHIGAN AT ANN ARBOR | N | 279 | NIDA | Non-SBIR/STTR | $461,761.00 | $220,496.00 | $682,257.00 | 2015 |
| 5R01HL039752-31 | Elevated Calcium and Myocardial Ischemia injury | 20 | JOHNS HOPKINS UNIVERSITY | N | 837 | NHLBI | Non-SBIR/STTR | $250,000.00 | $155,000.00 | $405,000.00 | 1988 |
| 5R01AA013892-15 | Chronic Alcohol and Brain Stress Circuit Response | 21 | YALE UNIVERSITY | N | 273 | NIAAA | Non-SBIR/STTR | $367,320.00 | $244,268.00 | $611,588.00 | 2003 |
| 5R01DK064814-13 | Acitivity for Diabetic Polyneuropathy: The ADAPT Study | 22 | UNIVERSITY OF UTAH | N | 847 | NIDDK | Non-SBIR/STTR | $477,210.00 | $164,946.00 | $642,156.00 | 2004 |
| 5R01CA187037-05 | Combined Biologic and Radiopharmaceutical Therapy of Breast Cancer | 23 | JOHNS HOPKINS UNIVERSITY | N | 395 | NCI | Non-SBIR/STTR | $283,572.00 | $175,814.00 | $459,386.00 | 2015 |
| 5R01DE016402-14 | Mesenchymal Regulation of Osteogenesis | 24 | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 121 | NIDCR | Non-SBIR/STTR | $250,000.00 | $146,250.00 | $396,250.00 | 2004 |
| 1RF1AG059392-01A1 | Establishing MicroRNA Biomarkers for Diagnosing Alzheimer’s Disease & Predicting Progression | 25 | OREGON HEALTH & SCIENCE UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $2,246,520.00 | $1,183,330.00 | $3,429,850.00 | 2019 |
| 5R44CA199058-03 | A Prognostic Blood Test to Monitor Pancreatic Cancer Treatment by MiRNA Profiling | 26 | VAJRA INSTRUMENTS, INC. | N | 394 | NCI | SBIR/STTR | $999,597.00 | 2015 | ||
| 5R01HD045713-16 | The Dynamics of Visual Attention and Word Learning | 27 | UNIVERSITY OF EAST ANGLIA | N | 865 | NICHD | Non-SBIR/STTR | $270,676.00 | $21,654.00 | $292,330.00 | 2003 |
| 5R21NS104603-02 | Brain structure and function in adult ZIKV patients with neurological manifestations | 28 | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | N | 853 | NINDS | Non-SBIR/STTR | $125,000.00 | $68,334.00 | $193,334.00 | 2018 |
| 5R01HL129077-04 | Novel Simulation Technologies for BHV Long-Term Durability | 29 | UNIVERSITY OF TEXAS, AUSTIN | N | 837 | NHLBI | Non-SBIR/STTR | $375,094.00 | $100,172.00 | $475,266.00 | 2016 |
| 5R01GM098539-08 | Analytical tools for the analysis of clustered O-glycans in clinical samples | 30 | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 859 | NIGMS | Non-SBIR/STTR | $246,822.00 | $105,290.00 | $352,112.00 | 2011 |
| 5R01HL126666-05 | Growing Resilience in Wind River Indian Reservation: an RCT on gardens for health | 31 | UNIVERSITY OF WYOMING | N | 837 | NHLBI | Non-SBIR/STTR | $518,629.00 | $96,211.00 | $614,840.00 | 2015 |
| 5R01NS022061-35 | Modulation of neuronal acetylcholine receptors | 32 | STATE UNIVERSITY NEW YORK STONY BROOK | N | 853 | NINDS | Non-SBIR/STTR | $296,065.00 | $169,714.00 | $465,779.00 | 1985 |
| 5R01DK064324-15 | Multiphoton imaging of the juxtaglomerular apparatus | 33 | UNIVERSITY OF SOUTHERN CALIFORNIA | N | 847 | NIDDK | Non-SBIR/STTR | $262,265.00 | $170,472.00 | $432,737.00 | 2003 |
| 5R24OD021997-04 | Drosophila resources for modeling human diseases | 34 | HARVARD MEDICAL SCHOOL | N | 351 | OD | Other Research-Related | $223,250.00 | $155,159.00 | $378,409.00 | 2016 |
| 5R01DA039071-05 | Texting intervention to sustain HIV prevention in women in high-drug-use contexts | 35 | UNIVERSITY OF CALIFORNIA, SAN DIEGO | N | 279 | NIDA | Non-SBIR/STTR | $436,059.00 | $188,233.00 | $624,292.00 | 2015 |
| 1R21NS107884-01A1 | Cellular immunity in intractable pediatric epilepsy | 36 | UNIVERSITY OF CALIFORNIA LOS ANGELES | N | 853 | NINDS | Non-SBIR/STTR | $275,000.00 | $154,000.00 | $429,000.00 | 2019 |
| 5R01AI067946-14 | Directing Function at the Natural Killer Cell Secretory Immunological Synapse | 37 | COLUMBIA UNIVERSITY HEALTH SCIENCES | N | 855 | NIAID | Non-SBIR/STTR | $260,162.00 | $161,300.00 | $421,462.00 | 2005 |
| 5R01DA039533-05 | Effects of early life stress on synaptic function and DA signaling in the VTA | 38 | HENRY M. JACKSON FDN FOR THE ADV MIL/MED | N | 279 | NIDA | Non-SBIR/STTR | $230,000.00 | $128,309.00 | $358,309.00 | 2015 |
| 5R01CA181064-06 | Yoga Versus CBT-I for Insomnia in Cancer Survivors and Biobehavioral Mechanisms | 39 | UNIVERSITY OF ROCHESTER | N | 395 | NCI | Non-SBIR/STTR | $442,807.00 | $236,902.00 | $679,709.00 | 2014 |
| 5K08NS094683-05 | Effect of ABCD1 upon Brain Endothelium in X-linked Adrenoleukodystrophy | 40 | MASSACHUSETTS GENERAL HOSPITAL | N | 853 | NINDS | Other Research-Related | $184,000.00 | $15,040.00 | $199,040.00 | 2015 |
| 5R01CA066980-25 | Biological Activity of HPV E7 in Human Epithelial Cells | 41 | TUFTS UNIVERSITY BOSTON | N | 393 | NCI | Non-SBIR/STTR | $218,250.00 | $141,862.00 | $360,112.00 | 1996 |
| 5R44EY024186-03 | Confocal and Autofluorescence Imaging of Macular Degeneration using a Low Cost Digital Imager | 42 | AEON IMAGING, LLC | N | 867 | NEI | SBIR/STTR | $490,002.00 | 2018 | ||
| 5R01HL126117-05 | TELmisartan plus EXercise to improve functioning in PAD: The TELEX Trial | 43 | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 837 | NHLBI | Non-SBIR/STTR | $553,659.00 | $257,160.00 | $713,702.00 | 2015 |
| 5K23HL130648-04 | Optimizing ED to ICU triage decisions for critically ill patients in respiratory distress | 44 | ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | N | 838 | NHLBI | Other Research-Related | $154,494.00 | $12,080.00 | $166,574.00 | 2016 |
| 5R01MH100318-05 | Amygdala-mediated enhancement of the hippocampal memory system | 45 | EMORY UNIVERSITY | N | 242 | NIMH | Non-SBIR/STTR | $250,000.00 | $137,900.00 | $387,900.00 | 2014 |
| 1RF1AG062166-01 | The Adipocyte PPARgama/Adiponectin Axis and Alzheimer’s Disease | 46 | AUGUSTA UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $2,263,725.00 | $1,212,245.00 | $3,475,970.00 | 2019 |
| 5R01AG041721-08 | Quantifying Brain Abnormality by Multimodality Neuroimage Analysis | 47 | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 866 | NIA | Non-SBIR/STTR | $230,831.00 | $120,032.00 | $350,863.00 | 2012 |
| 5U01HG009088-04 | Powering whole genome sequence-based genetic discovery for common human diseases | 48 | HARVARD SCHOOL OF PUBLIC HEALTH | N | 172 | NHGRI | Non-SBIR/STTR | $896,558.00 | $150,424.00 | $884,756.00 | 2016 |
| 5R01HL128785-04 | Computer-Aided Diagnosis of Pulmonary Embolism | 49 | ARIZONA STATE UNIVERSITY-TEMPE CAMPUS | N | 838 | NHLBI | Non-SBIR/STTR | $853,161.00 | $393,298.00 | $586,687.00 | 2016 |
| 5R01CA186338-05 | ZIP4 is a Novel Molecular Target in Human Pancreatic Cancer | 50 | UNIVERSITY OF OKLAHOMA HLTH SCIENCES CTR | N | 396 | NCI | Non-SBIR/STTR | $243,447.00 | $89,202.00 | $332,649.00 | 2015 |
| 5R21DA044749-02 | Imaging the monoaminergic midbrain and cognitive control in cocaine addiction | 51 | YALE UNIVERSITY | N | 279 | NIDA | Non-SBIR/STTR | $125,000.00 | $58,750.00 | $183,750.00 | 2018 |
| 1OT2OD027070-01 | Population-Scale Clinical Genomics | 52 | HUDSON-ALPHA INSTITUTE FOR BIOTECHNOLOGY | N | 350 | NCATS | Other | $5,627,051.00 | $1,372,440.00 | $6,999,491.00 | 2019 |
| 5R01CA191317-05 | Separating autoimmunity and anti-tumor immunity | 53 | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 395 | NCI | Non-SBIR/STTR | $226,779.00 | $123,131.00 | $349,910.00 | 2015 |
| 5R01NS093362-05 | Defining the role of FUS phosphorylation in neurodegeneration | 54 | EMORY UNIVERSITY | N | 853 | NINDS | Non-SBIR/STTR | $260,566.00 | $122,487.00 | $383,053.00 | 2015 |
| 5R21AR071585-02 | Engineering a biopolymer hydrogel to inhibit osteogenesis: Implications for growth plate repair | 55 | COLORADO SCHOOL OF MINES | N | 846 | NIAMS | Non-SBIR/STTR | $160,954.00 | $27,236.00 | $188,190.00 | 2018 |
| 5R01NS096755-04 | From brain iron deficiency to therapeutic opportunities in mucolipidosis IV | 56 | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | N | 853 | NINDS | Non-SBIR/STTR | $361,055.00 | $49,195.00 | $410,250.00 | 2016 |
| 5U01DK082944-12 | Hepatitis B Research Network (HBRN): Natural History and Treatment Studies | 57 | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 847 | NIDDK | Non-SBIR/STTR | $933,700.00 | $343,839.00 | $742,927.00 | 2008 |
| 5R01DK101505-05 | Whole-exome Sequencing Study of Diabetic Nephropathy | 58 | TULANE UNIVERSITY OF LOUISIANA | N | 847 | NIDDK | Non-SBIR/STTR | $240,403.00 | $47,025.00 | $287,428.00 | 2015 |
| 5R21MH114095-02 | Understanding Attentional Strengths and Weaknesses in Autism Spectrum Disorder | 59 | PURDUE UNIVERSITY | N | 242 | NIMH | Non-SBIR/STTR | $125,000.00 | $62,994.00 | $187,994.00 | 2018 |
| 5R01CA193343-05 | Genetic Mapping of Breast Cancer Risk in the Tumor Microenvironment | 60 | MEDICAL COLLEGE OF WISCONSIN | N | 396 | NCI | Non-SBIR/STTR | $221,887.00 | $119,819.00 | $341,706.00 | 2015 |
| 5R01AI124804-04 | Impact of Fc N-glycan structure on HIV-specific antibody functions | 61 | UNIVERSITY OF WYOMING | N | 855 | NIAID | Non-SBIR/STTR | $593,369.00 | $139,874.00 | $733,243.00 | 2016 |
| 5R01DK105526-04 | Novel pharmacotherapy strategies for obesity in schizophrenia | 62 | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 847 | NIDDK | Non-SBIR/STTR | $523,656.00 | $133,862.00 | $657,518.00 | 2016 |
| 5R01AT009444-03 | A randomized trial of dance on mood, balance and brain in Alzheimer’s Disease | 63 | WAKE FOREST UNIVERSITY HEALTH SCIENCES | N | 213 | NCCIH | Non-SBIR/STTR | $303,130.00 | $147,418.00 | $450,548.00 | 2017 |
| 5R01AG050588-04 | Transdermal Nitroglycerin Therapy for Menopausal Hot Flashes | 64 | UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | N | 866 | NIA | Non-SBIR/STTR | $346,473.00 | $190,693.00 | $537,166.00 | 2016 |
| 5R01HL129472-05 | Selection of Allogeneic Hematopoietic Cell Donor Based on KIR and HLA Genotypes | 65 | SLOAN-KETTERING INST CAN RESEARCH | N | 839 | NHLBI | Non-SBIR/STTR | $296,750.00 | $183,817.00 | $480,567.00 | 2015 |
| 5R01DA038154-05 | Cognitive Control in Children of SUD Parents: A Longitudinal Multimodal MRI Study | 66 | NEW YORK STATE PSYCHIATRIC INSTITUTE | N | 279 | NIDA | Non-SBIR/STTR | $399,955.00 | $237,601.00 | $637,556.00 | 2015 |
| 5U01AI114378-05 | Experimental human infection with isogenic mutants of Neisseria gonorrhoeae | 67 | UNIV OF NORTH CAROLINA CHAPEL HILL | N | 855 | NIAID | Non-SBIR/STTR | $756,505.00 | $320,841.00 | $1.00 | 2015 |
| 5R44DC014173-03 | Expressive Speech Synthesis for Speech-Generating Devices | 68 | SYNFONICA, LLC | N | 173 | NIDCD | SBIR/STTR | $492,816.00 | 2015 | ||
| 5R01NS088645-05 | Etiological Linkage of DNA Damage/Repair Deficiency in Neurodegenerative Diseases | 69 | METHODIST HOSPITAL RESEARCH INSTITUTE | N | 853 | NINDS | Non-SBIR/STTR | $232,969.00 | $111,625.00 | $344,594.00 | 2015 |
| 5R00EB019482-05 | Neuroimaging of deep brain stimulation patients using safe MRI excitations | 70 | MASSACHUSETTS GENERAL HOSPITAL | N | 286 | NIBIB | Non-SBIR/STTR | $145,557.00 | $103,345.00 | $248,902.00 | 2017 |
| 5R01DE017732-11 | Diabetes-enhanced Experimental Periodontitis | 71 | UNIVERSITY OF PENNSYLVANIA | N | 121 | NIDCR | Non-SBIR/STTR | $282,980.00 | $147,578.00 | $430,558.00 | 2006 |
| 5U2CAG057441-03 | ARMADA: Advancing Reliable Measurement in Alzheimer’s Disease and cognitive Aging | 72 | NORTHWESTERN UNIVERSITY AT CHICAGO | N | 866 | NIA | Other Research-Related | $2,255,631.00 | $521,035.00 | $2,776,666.00 | 2017 |
| 1RF1AG061774-01 | Slow-wave activity as a modifier of the progression of neurodegeneration in Alzheimer’s disease | 73 | HARVARD MEDICAL SCHOOL | N | 866 | NIA | Non-SBIR/STTR | $3,065,681.00 | $397,543.00 | $3,463,224.00 | 2019 |
| 5R01ES025135-05 | Participatory Interventions to Reduce Arsenic in American Indian Communities | 74 | JOHNS HOPKINS UNIVERSITY | N | 113 | NIEHS | Non-SBIR/STTR | $589,048.00 | $162,352.00 | $585,477.00 | 2015 |
| 5R01HL122684-05 | Genetic Studies of The Impact of Hematologic Traits On Cardiovascular Disease | 75 | UNIVERSITY OF MICHIGAN AT ANN ARBOR | N | 837 | NHLBI | Non-SBIR/STTR | $875,307.00 | $402,474.00 | $678,076.00 | 2015 |
| 5UM1HG008895-04 | Center for Common Disease Genetics | 76 | BROAD INSTITUTE, INC. | N | 172 | NHGRI | Non-SBIR/STTR | $18,631,137.00 | $1,434,331.00 | $20,000,000.00 | 2016 |
| 5R21ES028963-02 | Water disinfection by-products and female fertility | 77 | UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | N | 113 | NIEHS | Non-SBIR/STTR | $150,000.00 | $87,900.00 | $237,900.00 | 2018 |
| 5R01HL128388-04 | Adverse Neurogenic Actions of Dietary Salt | 78 | UNIVERSITY OF DELAWARE | N | 837 | NHLBI | Non-SBIR/STTR | $516,405.00 | $129,020.00 | $645,425.00 | 2016 |
| 5R44AG056012-03 | Mobility Rehab: A Biofeedback System for Mobility Rehabilitation for Older Adults | 79 | APDM, INC. | N | 866 | NIA | SBIR/STTR | $676,357.00 | 2016 | ||
| 5R01MH106450-05 | Cognitive Enhancement Therapy for Adult Autism Spectrum Disorder | 80 | UNIVERSITY OF PITTSBURGH AT PITTSBURGH | N | 242 | NIMH | Non-SBIR/STTR | $409,828.00 | $194,580.00 | $604,408.00 | 2015 |
| 5R01HL130376-04 | Final preclinical development of AAV gene therapy for atrial fibrillation | 81 | UNIV OF MASSACHUSETTS MED SCH WORCESTER | N | 837 | NHLBI | Non-SBIR/STTR | $430,708.00 | $290,728.00 | $721,436.00 | 2016 |
| 5R21AG056765-02 | Integrating Mobile and Wearable Technology to Promote Physical Activity and Sleep among Midlife Adults: The Be SMART for Heart Health Trial | 82 | UNIVERSITY OF DELAWARE | N | 866 | NIA | Non-SBIR/STTR | $155,526.00 | $81,813.00 | $237,339.00 | 2018 |
| 5R01HD091068-03 | A System for Culturing Mammalian Spermatogonial Cells | 83 | UNIVERSITY OF CALGARY | N | 865 | NICHD | Non-SBIR/STTR | $211,650.00 | $16,932.00 | $228,582.00 | 2017 |
| 5R01AG053325-04 | Non-esterified Fatty Acids and Cardiometabolic Disease in Older Adults | 84 | BRIGHAM AND WOMEN’S HOSPITAL | N | 866 | NIA | Non-SBIR/STTR | $592,483.00 | $60,745.00 | $653,228.00 | 2016 |
| 5R01HL127338-04 | The Role of ZFP36 in Control of IPF | 85 | UNIVERSITY OF ALABAMA AT BIRMINGHAM | N | 838 | NHLBI | Non-SBIR/STTR | $250,000.00 | $117,500.00 | $367,500.00 | 2016 |
| 5R03AG052416-02 | Dementia Screening Using Automated Speech Analysis: A Pilot Study | 86 | MARYMOUNT UNIVERSITY | N | 866 | NIA | Non-SBIR/STTR | $26,977.00 | $13,192.00 | $40,169.00 | 2018 |
| 1R44AI138865-01A1 | Development of a novel therapy for mitigation of the irradiation-inducedgastrointestinal syndrome | 87 | BIOINCEPT, LLC | N | 855 | NIAID | SBIR/STTR | $207,237.00 | 2019 | ||
| 1R43CA236083-01 | Magnetomotive Embolization for Hepatocellular Carcinoma | 88 | UNANDUP, LLC | N | 395 | NCI | SBIR/STTR | $299,821.00 | 2019 | ||
| 1RF1NS110354-01 | Role of Glucosylsphingosine in Parkinson Disease and Dementia with Lewy Bodies | 89 | YALE UNIVERSITY | N | 853 | NIA | Non-SBIR/STTR | $1,481,005.00 | $999,680.00 | $2,480,685.00 | 2019 |
| 5R21ES029762-02 | Taking a Breath after the Disaster: Homes, Mold and Health in Puerto Rico after Hurricane Maria | 90 | UNIVERSITY OF PUERTO RICO RIO PIEDRAS | N | 113 | NIEHS | Non-SBIR/STTR | $197,918.00 | $20,918.00 | $218,836.00 | 2018 |
| 5R01HL126099-04 | Adapting the Diabetes Prevention Program for a developing world context | 91 | CHILDREN’S MERCY HOSP (KANSAS CITY, MO) | N | 837 | NHLBI | Non-SBIR/STTR | $536,726.00 | $129,065.00 | $665,791.00 | 2016 |
| 5R03AI130174-02 | Receptor-mediated steps in enterovirus infection involve allostery | 92 | UNIVERSITY OF NEBRASKA MEDICAL CENTER | N | 855 | NIAID | Non-SBIR/STTR | $53,681.00 | $28,183.00 | $81,864.00 | 2017 |
| 5SC2GM121250-03 | Photosensitization of albumin: a potential approach to modulate drug delivery into abnormal cells. | 93 | UNIVERSITY OF TEXAS SAN ANTONIO | N | 859 | NIGMS | Other Research-Related | $100,000.00 | $47,000.00 | $147,000.00 | 2017 |
| 5R21DA045296-02 | Understanding Cannabis Withdrawal: A PET Study of Endocannabinoid Metabolism | 94 | CENTRE FOR ADDICTION AND MENTAL HEALTH | N | 279 | NIDA | Non-SBIR/STTR | $138,522.00 | $11,082.00 | $149,604.00 | 2018 |
| 5U01ES026721-04 | Epigenomics of Air Pollution driven Inflammation, Obesity and Insulin Resistance | 95 | JOHNS HOPKINS UNIVERSITY | N | 113 | NIEHS | Non-SBIR/STTR | $668,998.00 | $387,128.00 | $635,267.00 | 2016 |
| 5R01DK104867-04 | Dorsomedial Hypothalamic Signaling Pathways and Energy Balance | 96 | JOHNS HOPKINS UNIVERSITY | N | 847 | NIDDK | Non-SBIR/STTR | $225,000.00 | $139,500.00 | $364,500.00 | 2015 |
| 5R01EY026584-04 | Novel Imaging of rod oxidative stress in retinal disease and treatment in vivo | 97 | WAYNE STATE UNIVERSITY | N | 867 | NEI | Non-SBIR/STTR | $250,000.00 | $135,000.00 | $385,000.00 | 2016 |
| 5R01CA183101-05 | Biophotonics to Couple Pancreatic with Upper GI Screening via Ultrathin Endoscopy | 98 | NORTHWESTERN UNIVERSITY | N | 394 | NCI | Non-SBIR/STTR | $522,024.00 | $76,565.00 | $598,589.00 | 2015 |
| 5R01CA183749-05 | Optimizing cancer photodynamic therapy using photoacoustic lifetime imaging | 99 | UNIVERSITY OF MINNESOTA | N | 394 | NCI | Non-SBIR/STTR | $221,887.00 | $91,686.00 | $313,573.00 | 2014 |
| 5R41DC016257-02 | Nucleobase aminosugars with reduced ototoxicity | 100 | NUBAD, LLC | N | 173 | NIDCD | SBIR/STTR | $364,433.00 | 2017 |
/*DELETE THE VIEW CREATED*/
DROP VIEW IF EXISTS PROJECTINCHARGERANK
## LIST NUMBER OF TABLES IN DATABASE
dbListTables(NRAFDB)
## [1] "CenterFunding" "Cost" "GoogleScholar"
## [4] "GovermentFunding" "NARFCategorizations" "Organizations"
## [7] "PUBMED" "Patents" "ProjectPersonInCharge"
## [10] "Projects" "Publications" "PublicationsLinks"
## [13] "SubProject" "sqlite_sequence"
CONCLUSION :NEW ENTITY WAS DELETED
SUCCESSFULLY
/*QUERY TO GET TOTAL FUNDING DISBURSED FOR STANFORD UNIVERSITY ACCORDING TO THIER ORGANIZATIONS INVOLVED IN RESEARCH ACTIVITY*/
SELECT PUBLICATIONS.COREPROJECTNUMBER, PATENTOWNER, ORGANIZATIONNAME,PATENTNUMBER, TOTALCOSTIC, ACTIVITY, JOURNALTITLE, COUNTRY, ISSN, JOURNALISSUE, FISCALYEAR, PUBLICATIONYEAR, ORGANIZATIONTYPE, CFDACODE, FUNDINGICS
FROM PUBLICATIONS
INNER JOIN PATENTS ON PATENTS.CoreNARFProjectNumber = PUBLICATIONS.CoreProjectNumber
INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.OrganizationID = PUBLICATIONS.OrganizationID
INNER JOIN GOVERMENTFUNDING ON GOVERMENTFUNDING.FundingID = ORGANIZATIONS.FundingID
INNER JOIN COST ON COST.FundingID = GOVERMENTFUNDING.FundingID
WHERE PATENTOWNER = "STANFORD UNIVERSITY"
| CoreProjectNumber | PatentOwner | OrganizationName | PatentNumber | TotalCostIC | Activity | JournalTitle | Country | ISSN | JournalIssue | FiscalYear | PublicationYear | OrganizationType | CFDACode | FundingICS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R01GM130840 | STANFORD UNIVERSITY | UNIVERSITY OF ALABAMA AT BIRMINGHAM | 7081444 | $733,001.00 | R01 | J Cell Sci | England | 1477-9137 | 5 | 2019 | 2022 | SCHOOLS OF MEDICINE | 837 | NHLBI |
| R01HL113084 | STANFORD UNIVERSITY | NEW YORK STATE PSYCHIATRIC INSTITUTE | 7985726 | $637,556.00 | R01 | J Mol Cell Cardiol | England | 1095-8584 | 2019 | 2021 | Independent Hospitals | 279 | NIDA | |
| R01EY023397 | STANFORD UNIVERSITY | OREGON HEALTH & SCIENCE UNIVERSITY | 8592363 | $3,429,850.00 | RF1 | Sci Rep | England | 2045-2322 | 1 | 2019 | 2021 | SCHOOLS OF MEDICINE | 866 | NIA |
| K23HL140081 | STANFORD UNIVERSITY | UNIVERSITY OF ALABAMA AT BIRMINGHAM | 10285976 | $352,112.00 | R01 | Neurology | United States | 1526-632X | 7 | 2019 | 2021 | SCHOOLS OF MEDICINE | 859 | NIGMS |
| R01EB026574 | STANFORD UNIVERSITY | UNIVERSITY OF DELAWARE | 10285976 | $645,425.00 | R01 | IEEE Trans Ultrason Ferroelectr Freq Control | United States | 1525-8955 | 5 | 2019 | 2021 | SCH ALLIED HEALTH PROFESSIONS | 837 | NHLBI |
| ZIAAA000130 | STANFORD UNIVERSITY | UNIVERSITY OF ROCHESTER | 10570150 | $679,709.00 | R01 | Addict Biol | United States | 1369-1600 | 1 | 2019 | 2021 | SCHOOL OF MEDICINE & DENTISTRY | 395 | NCI |
| P30DK089502 | STANFORD UNIVERSITY | WAYNE STATE UNIVERSITY | 8574583 | $385,000.00 | R01 | Curr Opin Immunol | England | 1879-0372 | 2019 | 2021 | SCHOOLS OF MEDICINE | 867 | NEI | |
| P41GM103422 | STANFORD UNIVERSITY | UNIVERSITY OF EAST ANGLIA | 7588772 | $292,330.00 | R01 | iScience | United States | 2589-0042 | 6 | 2019 | 2021 | Unavailable | 865 | NICHD |
| R01GM059796 | STANFORD UNIVERSITY | WAKE FOREST UNIVERSITY HEALTH SCIENCES | 10406244 | $450,548.00 | R01 | J Phys Chem B | United States | 1520-5207 | 22 | 2019 | 2021 | SCHOOLS OF MEDICINE | 213 | NCCIH |
| R01MH118217 | STANFORD UNIVERSITY | UNIVERSITY OF WYOMING | 9273313 | $733,243.00 | R01 | Curr Dev Disord Rep | Switzerland | 2196-2987 | 2 | 2019 | 2021 | EARTH SCIENCES/RESOURCES | 855 | NIAID |
/*QUERY TO GET RANK OF ORGANIZATION ACCORDING TO THIER FUNDING RECIEVED*/
SELECT ORGANIZATIONNAME , RANK() OVER (ORDER BY ORGANIZATIONNAME) AS ORGANIZATIONRANK , OrganizationCity, FUNDINGICS, TOTALCOSTIC AS FUNDINGRECIEVED
FROM ORGANIZATIONS
INNER JOIN GOVERMENTFUNDING ON GOVERMENTFUNDING.FundingID = ORGANIZATIONS.FundingID
INNER JOIN COST ON COST.FundingID = GOVERMENTFUNDING.FundingID
GROUP BY ORGANIZATIONNAME
| OrganizationName | ORGANIZATIONRANK | OrganizationCity | FundingICS | FUNDINGRECIEVED |
|---|---|---|---|---|
| AEON IMAGING, LLC | 1 | BLOOMINGTON | NEI | $490,002.00 |
| APDM, INC. | 2 | PORTLAND | NIA | $676,357.00 |
| ARIZONA STATE UNIVERSITY-TEMPE CAMPUS | 3 | TEMPE | NHLBI | $586,687.00 |
| AUGUSTA UNIVERSITY | 4 | AUGUSTA | NIA | $3,475,970.00 |
| BIOINCEPT, LLC | 5 | New York | NIAID | $207,237.00 |
| BRIGHAM AND WOMEN’S HOSPITAL | 6 | BOSTON | NIA | $653,228.00 |
| BROAD INSTITUTE, INC. | 7 | CAMBRIDGE | NHGRI | $20,000,000.00 |
| CENTRE FOR ADDICTION AND MENTAL HEALTH | 8 | TORONTO | NIDA | $149,604.00 |
| CHILDREN’S MERCY HOSP (KANSAS CITY, MO) | 9 | KANSAS CITY | NHLBI | $665,791.00 |
| COLORADO SCHOOL OF MINES | 10 | GOLDEN | NIAMS | $188,190.00 |
| COLUMBIA UNIVERSITY HEALTH SCIENCES | 11 | NEW YORK | NIAID | $421,462.00 |
| EMORY UNIVERSITY | 12 | ATLANTA | NIMH | $387,900.00 |
| HARVARD MEDICAL SCHOOL | 13 | BOSTON | OD | $378,409.00 |
| HARVARD SCHOOL OF PUBLIC HEALTH | 14 | BOSTON | NHGRI | $884,756.00 |
| HENRY M. JACKSON FDN FOR THE ADV MIL/MED | 15 | BETHESDA | NIDA | $358,309.00 |
| HUDSON-ALPHA INSTITUTE FOR BIOTECHNOLOGY | 16 | HUNTSVILLE | NCATS | $6,999,491.00 |
| ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI | 17 | NEW YORK | NCATS | $5,133,391.00 |
| JOHNS HOPKINS UNIVERSITY | 18 | BALTIMORE | NCI | $459,386.00 |
| MARYMOUNT UNIVERSITY | 19 | ARLINGTON | NIA | $40,169.00 |
| MASSACHUSETTS GENERAL HOSPITAL | 20 | BOSTON | NICHD | $214,380.00 |
| MAYO CLINIC ROCHESTER | 21 | ROCHESTER | NIGMS | $419,836.00 |
| MEDICAL COLLEGE OF WISCONSIN | 22 | MILWAUKEE | NCI | $341,706.00 |
| METHODIST HOSPITAL RESEARCH INSTITUTE | 23 | HOUSTON | NINDS | $344,594.00 |
| NEW YORK STATE PSYCHIATRIC INSTITUTE | 24 | NEW YORK | NIDA | $637,556.00 |
| NORTHWESTERN UNIVERSITY | 25 | Chicago | NCI | $598,589.00 |
| NORTHWESTERN UNIVERSITY AT CHICAGO | 26 | CHICAGO | NHLBI | $713,702.00 |
| NUBAD, LLC | 27 | GREENVILLE | NIDCD | $364,433.00 |
| OREGON HEALTH & SCIENCE UNIVERSITY | 28 | PORTLAND | NIA | $3,429,850.00 |
| PENNSYLVANIA STATE UNIVERSITY-UNIV PARK | 29 | UNIVERSITY PARK | NIDA | $353,700.00 |
| PURDUE UNIVERSITY | 30 | WEST LAFAYETTE | NIMH | $187,994.00 |
| SLOAN-KETTERING INST CAN RESEARCH | 31 | NEW YORK | NHLBI | $480,567.00 |
| STATE UNIVERSITY NEW YORK STONY BROOK | 32 | STONY BROOK | NEI | $395,000.00 |
| SYNFONICA, LLC | 33 | ITHACA | NIDCD | $492,816.00 |
| TUFTS UNIVERSITY BOSTON | 34 | BOSTON | NCI | $360,112.00 |
| TULANE UNIVERSITY OF LOUISIANA | 35 | NEW ORLEANS | NIDDK | $287,428.00 |
| UNANDUP, LLC | 36 | SAINT LOUIS | NCI | $299,821.00 |
| UNIV OF MASSACHUSETTS MED SCH WORCESTER | 37 | WORCESTER | NHLBI | $721,436.00 |
| UNIV OF NORTH CAROLINA CHAPEL HILL | 38 | CHAPEL HILL | NIA | $350,863.00 |
| UNIVERSITY OF ALABAMA AT BIRMINGHAM | 39 | BIRMINGHAM | NHLBI | $733,001.00 |
| UNIVERSITY OF CALGARY | 40 | CALGARY | NICHD | $228,582.00 |
| UNIVERSITY OF CALIFORNIA BERKELEY | 41 | BERKELEY | NHLBI | $392,500.00 |
| UNIVERSITY OF CALIFORNIA LOS ANGELES | 42 | LOS ANGELES | NINDS | $429,000.00 |
| UNIVERSITY OF CALIFORNIA, SAN DIEGO | 43 | LA JOLLA | NIDA | $624,292.00 |
| UNIVERSITY OF CALIFORNIA, SAN FRANCISCO | 44 | SAN FRANCISCO | NIA | $537,166.00 |
| UNIVERSITY OF COLORADO DENVER | 45 | Aurora | NIDA | $232,166.00 |
| UNIVERSITY OF DELAWARE | 46 | NEWARK | NHLBI | $645,425.00 |
| UNIVERSITY OF EAST ANGLIA | 47 | NORFOLK | NICHD | $292,330.00 |
| UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN | 48 | CHAMPAIGN | NINDS | $193,334.00 |
| UNIVERSITY OF KANSAS MEDICAL CENTER | 49 | KANSAS CITY | NCI | $373,069.00 |
| UNIVERSITY OF KENTUCKY | 50 | LEXINGTON | OD | $557,910.00 |
| UNIVERSITY OF LOUISVILLE | 51 | LOUISVILLE | NIEHS | $192,500.00 |
| UNIVERSITY OF MICHIGAN AT ANN ARBOR | 52 | ANN ARBOR | NIDA | $682,257.00 |
| UNIVERSITY OF MINNESOTA | 53 | MINNEAPOLIS | NCI | $313,573.00 |
| UNIVERSITY OF NEBRASKA MEDICAL CENTER | 54 | OMAHA | NIAID | $81,864.00 |
| UNIVERSITY OF NEW MEXICO HEALTH SCIS CTR | 55 | ALBUQUERQUE | NINR | $479,541.00 |
| UNIVERSITY OF OKLAHOMA HLTH SCIENCES CTR | 56 | OKLAHOMA CITY | NCI | $332,649.00 |
| UNIVERSITY OF PENNSYLVANIA | 57 | PHILADELPHIA | NIDCR | $430,558.00 |
| UNIVERSITY OF PITTSBURGH AT PITTSBURGH | 58 | PITTSBURGH | NIMH | $604,408.00 |
| UNIVERSITY OF PUERTO RICO RIO PIEDRAS | 59 | SAN JUAN | NIEHS | $218,836.00 |
| UNIVERSITY OF ROCHESTER | 60 | ROCHESTER | NCI | $679,709.00 |
| UNIVERSITY OF SOUTHERN CALIFORNIA | 61 | Los Angeles | NIDDK | $432,737.00 |
| UNIVERSITY OF TEXAS MED BR GALVESTON | 62 | GALVESTON | NIA | $3,532,750.00 |
| UNIVERSITY OF TEXAS SAN ANTONIO | 63 | SAN ANTONIO | NIGMS | $147,000.00 |
| UNIVERSITY OF TEXAS, AUSTIN | 64 | AUSTIN | NHLBI | $475,266.00 |
| UNIVERSITY OF UTAH | 65 | SALT LAKE CITY | NIDDK | $642,156.00 |
| UNIVERSITY OF WASHINGTON | 66 | SEATTLE | NIDDK | $161,884.00 |
| UNIVERSITY OF WYOMING | 67 | LARAMIE | NHLBI | $614,840.00 |
| VAJRA INSTRUMENTS, INC. | 68 | LINCOLN | NCI | $999,597.00 |
| WAKE FOREST UNIVERSITY HEALTH SCIENCES | 69 | WINSTON-SALEM | NCCIH | $450,548.00 |
| WAYNE STATE UNIVERSITY | 70 | DETROIT | NEI | $385,000.00 |
| YALE UNIVERSITY | 71 | NEW HAVEN | NIA | $2,480,685.00 |
/*TO GET ALL THE PROJECTS IN SPECIFIC DATES*/
SELECT PROJECTNUMBER, PROJECTTITLE, PROJECTSTARTDATE, PROJECTENDDATE
FROM PROJECTS
WHERE PROJECTSTARTDATE BETWEEN '2015-09-30' AND '2021-11-30'
| ProjectNumber | ProjectTitle | ProjectStartDate | ProjectEndDate |
|---|---|---|---|
| 5R01HL131017-04 | Stem Cell Therapy for Myocardial Repair | 2016-07-01 | 2022-04-30 |
| 1RF1AG062166-01 | The Adipocyte PPARgama/Adiponectin Axis and Alzheimer’s Disease | 2019-02-15 | 2024-01-31 |
| 1RF1AG060718-01A1 | Calcineurin Mediates the Synergistic Toxicity of Tau and Aβ Oligomers | 2019-02-01 | 2024-01-31 |
| 1RF1NS110354-01 | Role of Glucosylsphingosine in Parkinson Disease and Dementia with Lewy Bodies | 2019-09-15 | 2023-08-31 |
| 5R01AG050588-04 | Transdermal Nitroglycerin Therapy for Menopausal Hot Flashes | 2016-04-15 | 2022-03-31 |
| 1RF1AG059392-01A1 | Establishing MicroRNA Biomarkers for Diagnosing Alzheimer’s Disease & Predicting Progression | 2019-02-15 | 2024-01-31 |
| 5R01HL127338-04 | The Role of ZFP36 in Control of IPF | 2016-06-01 | 2022-04-30 |
| 5R01HL129077-04 | Novel Simulation Technologies for BHV Long-Term Durability | 2016-05-19 | 2022-04-30 |
| 5R03AG052416-02 | Dementia Screening Using Automated Speech Analysis: A Pilot Study | 2018-04-15 | 2022-03-31 |
| 1R43CA236083-01 | Magnetomotive Embolization for Hepatocellular Carcinoma | 2019-03-01 | 2022-02-28 |
| 1R44AI138865-01A1 | Development of a novel therapy for mitigation of the irradiation-inducedgastrointestinal syndrome | 2019-05-01 | 2022-04-30 |
| 5R24OD021479-04 | Developing Regeneration Resources for a Model Amphibian | 2016-06-01 | 2022-03-31 |
| 5R01HL130376-04 | Final preclinical development of AAV gene therapy for atrial fibrillation | 2016-07-01 | 2022-04-30 |
| 5R21HD095338-02 | Ontogeny of Brainstem Arousal Networks in Human Consciousness | 2018-04-01 | 2021-12-31 |
| 5U01HG009088-04 | Powering whole genome sequence-based genetic discovery for common human diseases | 2016-05-02 | 2022-03-31 |
| 5R01DA041438-04 | Effects of cigarette availability on neural and subjective sensitivity to rewards | 2016-04-01 | 2022-03-31 |
| 5R01HL128388-04 | Adverse Neurogenic Actions of Dietary Salt | 2016-04-01 | 2022-03-31 |
| 5R01HD091068-03 | A System for Culturing Mammalian Spermatogonial Cells | 2017-04-01 | 2022-03-31 |
| 5R21DA044749-02 | Imaging the monoaminergic midbrain and cognitive control in cocaine addiction | 2018-03-15 | 2022-02-28 |
| 5R01HL126099-04 | Adapting the Diabetes Prevention Program for a developing world context | 2016-03-15 | 2022-02-28 |
| 5R21ES029762-02 | Taking a Breath after the Disaster: Homes, Mold and Health in Puerto Rico after Hurricane Maria | 2018-04-01 | 2022-03-31 |
| 5R21NS104603-02 | Brain structure and function in adult ZIKV patients with neurological manifestations | 2018-06-01 | 2022-05-31 |
| 5R21AR071585-02 | Engineering a biopolymer hydrogel to inhibit osteogenesis: Implications for growth plate repair | 2018-05-10 | 2022-03-31 |
| 5R21MH114095-02 | Understanding Attentional Strengths and Weaknesses in Autism Spectrum Disorder | 2018-05-07 | 2022-03-31 |
| 5U2CAG057441-03 | ARMADA: Advancing Reliable Measurement in Alzheimer’s Disease and cognitive Aging | 2017-09-30 | 2022-04-30 |
| 5R44AG056012-03 | Mobility Rehab: A Biofeedback System for Mobility Rehabilitation for Older Adults | 2016-09-30 | 2022-04-30 |
| 5U01ES026721-04 | Epigenomics of Air Pollution driven Inflammation, Obesity and Insulin Resistance | 2016-06-01 | 2022-04-30 |
| 5R34DA041549-03 | Advancing STOP: Self-regulation/CBT Therapy for Opioid addiction and Pain | 2017-07-01 | 2022-04-30 |
| 5R01AG053325-04 | Non-esterified Fatty Acids and Cardiometabolic Disease in Older Adults | 2016-09-15 | 2022-04-30 |
| 5R24OD021997-04 | Drosophila resources for modeling human diseases | 2016-06-01 | 2022-04-30 |
| 5R01EY026584-04 | Novel Imaging of rod oxidative stress in retinal disease and treatment in vivo | 2016-05-01 | 2022-04-30 |
| 5R01AT009444-03 | A randomized trial of dance on mood, balance and brain in Alzheimer’s Disease | 2017-05-01 | 2022-04-30 |
| 5K23HL130648-04 | Optimizing ED to ICU triage decisions for critically ill patients in respiratory distress | 2016-05-05 | 2022-01-09 |
| 5R01DK105526-04 | Novel pharmacotherapy strategies for obesity in schizophrenia | 2016-04-15 | 2022-03-31 |
| 5R03AI130174-02 | Receptor-mediated steps in enterovirus infection involve allostery | 2017-12-08 | 2021-11-30 |
| 5R21ES028911-02 | Mechanisms of carcinogenic effects of nickel nanoparticles | 2017-12-15 | 2021-11-30 |
| 5UM1HG008895-04 | Center for Common Disease Genetics | 2016-01-14 | 2021-11-30 |
| 5R01DK104867-04 | Dorsomedial Hypothalamic Signaling Pathways and Energy Balance | 2015-12-01 | 2021-11-30 |
| 5R41DC016257-02 | Nucleobase aminosugars with reduced ototoxicity | 2017-12-01 | 2021-11-30 |
| 5R01EY026155-04 | Role of aquaporins in mammalian lens development,transparency and homeostasis | 2015-12-01 | 2021-11-30 |
| 1OT2OD027070-01 | Population-Scale Clinical Genomics | 2019-09-21 | 2024-08-31 |
| 5K08NS094683-05 | Effect of ABCD1 upon Brain Endothelium in X-linked Adrenoleukodystrophy | 2015-09-30 | 2022-06-30 |
| 5SC2GM121250-03 | Photosensitization of albumin: a potential approach to modulate drug delivery into abnormal cells. | 2017-09-01 | 2022-07-31 |
| 5R21AG056765-02 | Integrating Mobile and Wearable Technology to Promote Physical Activity and Sleep among Midlife Adults: The Be SMART for Heart Health Trial | 2018-07-15 | 2022-03-31 |
| 1R21NS107884-01A1 | Cellular immunity in intractable pediatric epilepsy | 2019-03-15 | 2022-02-28 |
| 5R21ES028963-02 | Water disinfection by-products and female fertility | 2018-07-15 | 2022-05-31 |
| 5R00EB019482-05 | Neuroimaging of deep brain stimulation patients using safe MRI excitations | 2017-07-01 | 2022-06-30 |
| 5R21DA045296-02 | Understanding Cannabis Withdrawal: A PET Study of Endocannabinoid Metabolism | 2018-07-15 | 2022-06-30 |
| 5R01AI124804-04 | Impact of Fc N-glycan structure on HIV-specific antibody functions | 2016-08-01 | 2022-07-31 |
| 5R01HL128785-04 | Computer-Aided Diagnosis of Pulmonary Embolism | 2016-07-01 | 2022-04-30 |
| 5R01NS096755-04 | From brain iron deficiency to therapeutic opportunities in mucolipidosis IV | 2016-04-01 | 2022-03-31 |
| 1RF1AG061774-01 | Slow-wave activity as a modifier of the progression of neurodegeneration in Alzheimer’s disease | 2019-04-15 | 2024-03-31 |
| 5R44EY024186-03 | Confocal and Autofluorescence Imaging of Macular Degeneration using a Low Cost Digital Imager | 2018-04-01 | 2022-03-31 |
/*TO COUNT NUMBER OF PATENTS OF SPECIFIC ORGANIZATION*/
SELECT PATENTOWNER AS Organization, COUNT(PATENTNUMBER) AS NumOfPatents
FROM PUBLICATIONS
INNER JOIN PATENTS ON PATENTS.CoreNARFProjectNumber= PUBLICATIONS.CoreProjectNumber
GROUP BY PATENTOWNER
| Organization | NumOfPatents |
|---|---|
| 6 | |
| ALBERT EINSTEIN COLLEGE OF MEDICINE | 6 |
| BECKMAN RESEARCH INSTITUTE/CITY OF HOPE | 1 |
| BRIGHAM AND WOMEN’S HOSPITAL | 3 |
| BRIGHAM YOUNG UNIVERSITY | 1 |
| CALIFORNIA INSTITUTE OF TECHNOLOGY | 1 |
| DANA-FARBER CANCER INST | 3 |
| DREXEL UNIVERSITY | 2 |
| HARVARD UNIVERSITY | 1 |
| JOHNS HOPKINS UNIVERSITY | 6 |
| KANSAS STATE UNIVERSITY | 1 |
| LSU HEALTH SCIENCES CENTER | 1 |
| MASSACHUSETTS GENERAL HOSPITAL | 5 |
| MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 3 |
| MAYO CLINIC ROCHESTER | 4 |
| NEW YORK UNIVERSITY | 2 |
| ROCKEFELLER UNIVERSITY | 3 |
| SANFORD BURNHAM PREBYS MEDICAL DISCOVERY INSTITUTE | 3 |
| SCRIPPS RESEARCH INSTITUTE | 1 |
| SLOAN-KETTERING INST CAN RESEARCH | 3 |
| ST. JUDE CHILDREN’S RESEARCH HOSPITAL | 4 |
| STANFORD UNIVERSITY | 10 |
| UNIVERSITY OF CALIFORNIA BERKELEY | 1 |
| UNIVERSITY OF CALIFORNIA, SAN DIEGO | 3 |
| UNIVERSITY OF GEORGIA | 1 |
| UNIVERSITY OF KANSAS MEDICAL CENTER | 2 |
| UNIVERSITY OF MICHIGAN | 3 |
| UNIVERSITY OF MINNESOTA | 1 |
| UNIVERSITY OF NOTRE DAME | 2 |
| UNIVERSITY OF PENNSYLVANIA | 6 |
| UNIVERSITY OF WISCONSIN-MADISON | 2 |
| UT SOUTHWESTERN MEDICAL CENTER | 1 |
| VANDERBILT UNIVERSITY | 4 |
| WASHINGTON UNIVERSITY | 4 |
/*TO COUNT NUMBER OF PATENTS OF SPECIFIC ORGANIZATION*/
SELECT PATENTOWNER AS Organization, COUNT(PATENTNUMBER), COUNT(*) OVER (PARTITION BY PATENTNUMBER) AS NumOfPatents
FROM PUBLICATIONS
INNER JOIN PATENTS ON PATENTS.CoreNARFProjectNumber= PUBLICATIONS.CoreProjectNumber
GROUP BY PATENTOWNER
| Organization | COUNT(PATENTNUMBER) | NumOfPatents |
|---|---|---|
| SLOAN-KETTERING INST CAN RESEARCH | 3 | 1 |
| UNIVERSITY OF KANSAS MEDICAL CENTER | 2 | 1 |
| DANA-FARBER CANCER INST | 3 | 1 |
| SANFORD BURNHAM PREBYS MEDICAL DISCOVERY INSTITUTE | 3 | 1 |
| ST. JUDE CHILDREN’S RESEARCH HOSPITAL | 4 | 1 |
| LSU HEALTH SCIENCES CENTER | 1 | 1 |
| UNIVERSITY OF MICHIGAN | 3 | 1 |
| UNIVERSITY OF GEORGIA | 1 | 1 |
| MAYO CLINIC ROCHESTER | 4 | 1 |
| STANFORD UNIVERSITY | 10 | 1 |
| UNIVERSITY OF CALIFORNIA BERKELEY | 1 | 1 |
| ALBERT EINSTEIN COLLEGE OF MEDICINE | 6 | 1 |
| BECKMAN RESEARCH INSTITUTE/CITY OF HOPE | 1 | 1 |
| NEW YORK UNIVERSITY | 2 | 1 |
| DREXEL UNIVERSITY | 2 | 1 |
| UNIVERSITY OF CALIFORNIA, SAN DIEGO | 3 | 1 |
| KANSAS STATE UNIVERSITY | 1 | 1 |
| BRIGHAM AND WOMEN’S HOSPITAL | 3 | 1 |
| SCRIPPS RESEARCH INSTITUTE | 1 | 1 |
| VANDERBILT UNIVERSITY | 4 | 1 |
| UNIVERSITY OF WISCONSIN-MADISON | 2 | 1 |
| ROCKEFELLER UNIVERSITY | 3 | 1 |
| MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 3 | 1 |
| UNIVERSITY OF NOTRE DAME | 2 | 1 |
| 6 | 1 | |
| UT SOUTHWESTERN MEDICAL CENTER | 1 | 1 |
| HARVARD UNIVERSITY | 1 | 1 |
| CALIFORNIA INSTITUTE OF TECHNOLOGY | 1 | 1 |
| UNIVERSITY OF PENNSYLVANIA | 6 | 1 |
| BRIGHAM YOUNG UNIVERSITY | 1 | 1 |
| WASHINGTON UNIVERSITY | 4 | 1 |
| JOHNS HOPKINS UNIVERSITY | 6 | 1 |
| UNIVERSITY OF MINNESOTA | 1 | 1 |
| MASSACHUSETTS GENERAL HOSPITAL | 5 | 1 |
/*USING UNION TO GET DISBURSED FUNDINGS OF DIFFERENT YEAR*/
SELECT STRFTIME("%Y", PROJECTSTARTDATE) AS YEAR, DIRECTCOSTIC, INDIRECTCOSTIC, TOTALCOSTIC
FROM CENTERFUNDING
INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.OrganizationID = CENTERFUNDING.OrganizationID
INNER JOIN GOVERMENTFUNDING ON GOVERMENTFUNDING.FundingID = ORGANIZATIONS.FundingID
INNER JOIN COST ON COST.FundingID = GOVERMENTFUNDING.FundingID
INNER JOIN PROJECTPERSONINCHARGE ON PROJECTPERSONINCHARGE.OrganizationID = ORGANIZATIONS.OrganizationID
INNER JOIN PROJECTS ON PROJECTS.ProjectID = PROJECTPERSONINCHARGE.ProjectID
WHERE YEAR = "2015"
UNION
SELECT STRFTIME("%Y", PROJECTSTARTDATE) AS YEAR, DIRECTCOSTIC, INDIRECTCOSTIC, TOTALCOSTIC
FROM CENTERFUNDING
INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.OrganizationID = CENTERFUNDING.OrganizationID
INNER JOIN GOVERMENTFUNDING ON GOVERMENTFUNDING.FundingID = ORGANIZATIONS.FundingID
INNER JOIN COST ON COST.FundingID = GOVERMENTFUNDING.FundingID
INNER JOIN PROJECTPERSONINCHARGE ON PROJECTPERSONINCHARGE.OrganizationID = ORGANIZATIONS.OrganizationID
INNER JOIN PROJECTS ON PROJECTS.ProjectID = PROJECTPERSONINCHARGE.ProjectID
WHERE YEAR = "2016"
| YEAR | DirectCostIC | IndirectCostIC | TotalCostIC |
|---|---|---|---|
| 2015 | $492,816.00 | ||
| 2015 | $999,597.00 | ||
| 2015 | $149,900.00 | $11,984.00 | $161,884.00 |
| 2015 | $184,000.00 | $15,040.00 | $199,040.00 |
| 2015 | $192,500.00 | $119,350.00 | $311,850.00 |
| 2015 | $221,887.00 | $119,819.00 | $341,706.00 |
| 2015 | $225,000.00 | $139,500.00 | $364,500.00 |
| 2015 | $226,779.00 | $123,131.00 | $349,910.00 |
| 2015 | $230,000.00 | $128,309.00 | $358,309.00 |
| 2015 | $232,969.00 | $111,625.00 | $344,594.00 |
| 2015 | $240,403.00 | $47,025.00 | $287,428.00 |
| 2015 | $243,447.00 | $89,202.00 | $332,649.00 |
| 2015 | $250,000.00 | $142,500.00 | $392,500.00 |
| 2015 | $250,000.00 | $145,000.00 | $395,000.00 |
| 2015 | $258,009.00 | $115,060.00 | $373,069.00 |
| 2015 | $260,566.00 | $122,487.00 | $383,053.00 |
| 2015 | $283,572.00 | $175,814.00 | $459,386.00 |
| 2015 | $296,750.00 | $183,817.00 | $480,567.00 |
| 2015 | $3,666,560.00 | $2,446,919.00 | $5,133,391.00 |
| 2015 | $371,960.00 | $107,581.00 | $479,541.00 |
| 2015 | $399,955.00 | $237,601.00 | $637,556.00 |
| 2015 | $409,828.00 | $194,580.00 | $604,408.00 |
| 2015 | $436,059.00 | $188,233.00 | $624,292.00 |
| 2015 | $461,761.00 | $220,496.00 | $682,257.00 |
| 2015 | $518,629.00 | $96,211.00 | $614,840.00 |
| 2015 | $522,024.00 | $76,565.00 | $598,589.00 |
| 2015 | $553,659.00 | $257,160.00 | $713,702.00 |
| 2015 | $589,048.00 | $162,352.00 | $585,477.00 |
| 2015 | $756,505.00 | $320,841.00 | $1.00 |
| 2015 | $875,307.00 | $402,474.00 | $678,076.00 |
| 2016 | $676,357.00 | ||
| 2016 | $154,494.00 | $12,080.00 | $166,574.00 |
| 2016 | $18,631,137.00 | $1,434,331.00 | $20,000,000.00 |
| 2016 | $223,250.00 | $155,159.00 | $378,409.00 |
| 2016 | $225,000.00 | $128,700.00 | $353,700.00 |
| 2016 | $250,000.00 | $117,500.00 | $367,500.00 |
| 2016 | $250,000.00 | $135,000.00 | $385,000.00 |
| 2016 | $346,473.00 | $190,693.00 | $537,166.00 |
| 2016 | $361,055.00 | $49,195.00 | $410,250.00 |
| 2016 | $375,094.00 | $100,172.00 | $475,266.00 |
| 2016 | $430,708.00 | $290,728.00 | $721,436.00 |
| 2016 | $438,764.00 | $119,146.00 | $557,910.00 |
| 2016 | $516,405.00 | $129,020.00 | $645,425.00 |
| 2016 | $523,656.00 | $133,862.00 | $657,518.00 |
| 2016 | $536,726.00 | $129,065.00 | $665,791.00 |
| 2016 | $561,107.00 | $171,894.00 | $733,001.00 |
| 2016 | $592,483.00 | $60,745.00 | $653,228.00 |
| 2016 | $593,369.00 | $139,874.00 | $733,243.00 |
| 2016 | $668,998.00 | $387,128.00 | $635,267.00 |
| 2016 | $853,161.00 | $393,298.00 | $586,687.00 |
| 2016 | $896,558.00 | $150,424.00 | $884,756.00 |
/*TO GET ARTICLE LINK OF PUBMED EVERY PROJECT NUMBER*/
SELECT PUBPROJECTNUMBER, FULLTEXTLINK, PMCID, PMID, PUBMEDABSTRACT, RELATED, CITED, CFDACODE, FUNDINGMECHANISM, ORGANIZATIONNAME, JOURNALTITLE
FROM PUBLICATIONSLINKS
INNER JOIN PUBMED ON PUBMED.LinkID = PUBLICATIONSLINKS.LinkID
INNER JOIN GOVERMENTFUNDING ON GOVERMENTFUNDING.FundingProjNumber = PUBLICATIONSLINKS.PUBProjectNumber
INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.FundingID = GOVERMENTFUNDING.FundingID
INNER JOIN PUBLICATIONS ON PUBLICATIONS.OrganizationID = ORGANIZATIONS.OrganizationID
LIMIT 50
/*FUNDINGS RELEASED IN THAT PARTICULAR YEAR*/
SELECT STRFTIME("%Y", PROJECTSTARTDATE) AS YEAR, TOTALCOSTIC
FROM PROJECTS
INNER JOIN PROJECTPERSONINCHARGE ON PROJECTPERSONINCHARGE.ProjectID = PROJECTS.ProjectID
INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.OrganizationID = PROJECTPERSONINCHARGE.OrganizationID
INNER JOIN GOVERMENTFUNDING ON GOVERMENTFUNDING.FundingID = ORGANIZATIONS.FundingID
INNER JOIN COST ON COST.FundingID = GOVERMENTFUNDING.FundingID
GROUP BY YEAR
| YEAR | TotalCostIC |
|---|---|
| 1985 | $465,779.00 |
| 1988 | $405,000.00 |
| 1996 | $360,112.00 |
| 2003 | $292,330.00 |
| 2004 | $642,156.00 |
| 2005 | $421,462.00 |
| 2006 | $430,558.00 |
| 2008 | $742,927.00 |
| 2011 | $352,112.00 |
| 2012 | $350,863.00 |
| 2014 | $679,709.00 |
| 2015 | $459,386.00 |
| 2016 | $733,001.00 |
| 2017 | $228,582.00 |
| 2018 | $40,169.00 |
| 2019 | $3,475,970.00 |