Swapnesh Tiwari
Xin Li





Libraries Included



## 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 ENTRIES IN PROJECT TABLE.


  /*NUMBER OF PROJECTS IN THIS DATABASE*/
Select count(ProjectID) as NumOfProjects from Projects
1 records
NumOfProjects
100
CONCLUSION :TO GET NUMBER OF ENTRIES IN THIS CURRENT DATABASE.





TO GET FUNDING GIVEN TO EACH PROJECT


 /*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 
100 records
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
CONCLUSION :DISPLAYS FUNDING GIVEN FOR THE RESPECTIVE PROJECTS.





TO GET PROJECT PERSON IN CHARGE


 /*GET INFORMATION ABOUT PROJECT PERSON IN CHARGE*/
Select PROJECTNUMBER, PROJECTTITLE, PROJECTSTARTDATE, PROJECTENDDATE, PRIMARYPI, SECONDARYPI 

FROM PROJECTS

INNER JOIN PROJECTPERSONINCHARGE ON PROJECTPERSONINCHARGE.ProjectID = PROJECTS.ProjectID
100 records
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
CONCLUSION :WE GOT THE INFORMATION ABOUT THE EVERY PERSON IN CHARGE ACCORDING TO PROJECTS




TO CHECK WHICH YEAR THE FUNDING WAS DISBURSED


 /*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
100 records
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
CONCLUSION :IF THE NRAF DIRECTOR WANTS TO KNOW WHICH YEAR FUNDING WAS DISBURSED TO THE PARTICULAR ORGANIZATION.





TO CHECK WHICH YEAR THE FUNDING WAS DISBURSED QUARTERLY


 /*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
99 records
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
CONCLUSION :IF THE NRAF DIRECTOR WANTS TO KNOW THE QUARTERLY DISTRIBUTION OF FUNDING TO THE PARTICULAR ORGANIZATION.





QUERY TO RANK PROJECT INCHARGE ACCORDING TO THEIR FUNDING RECIEVED IN EVERY YEAR


 /*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
100 records
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
CONCLUSION :NEW ENTITY WAS CREATED SUCCESSFULLY NOW WE NEED TO DELETE THIS ENTITY FOR THAT WE WILL RUN THE BELOW QUERY.



 /*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.


 /*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"
10 records
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
CONCLUSION :WE CAN SEE THE DISBURSED AMOUNT FOR STANFORD UNIVERSITY BY YEAR






QUERY TO GET RANK OF ORGANIZATION ACCORDING TO THIER FUNDING RECIEVED.


 /*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
71 records
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
CONCLUSION :RANKED ORGANIZATION ACCORDING TO THEIR FUNDING RECIEVED.






TO GET ALL THE PROJECTS IN SPECIFIC DATES


 /*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'
53 records
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
CONCLUSION :RESULTS FROM THE SPECIFIC DATES ARE DISPLAYED






TO COUNT NUMBER OF PATENTS OF SPECIFIC ORGANIZATION


 /*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
34 records
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
CONCLUSION :THIS GIVES RESULTS FOR NUMBER OF PATENTS EACH ORAGNIZATION HAS, FOR EXAMPLE HARVARD UNIVERSITY HAS ONE PATENT INSERTED IN THIS DATABASE






TO COUNT NUMBER OF PATENTS OF SPECIFIC ORGANIZATION


 /*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
34 records
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
CONCLUSION :THIS GIVES RESULTS FOR NUMBER OF PATENTS EACH ORAGNIZATION HAS, FOR EXAMPLE HARVARD UNIVERSITY HAS ONE PATENT INSERTED IN THIS DATABASE





USING UNION TO GET DISBURSED FUNDINGS OF DIFFERENT YEAR


 /*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"
51 records
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
CONCLUSION :WE USED UNION TO GET THE FUNDING IN DIFFERENT YEAR





TO GET ARTICLE LINK OF EVERY PROJECT NUMBER IN PUBMED


 /*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
50 records
PUBProjectNumber FullTextLink PMCID PMID PUBMEDAbstract Related Cited CFDACode FundingMechanism OrganizationName JournalTitle
R01GM130840 S-acylation of Orai1 regulates store-operated Ca2+ entry. 8255033 34156466 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34156466'>Journal of cell science</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34156466&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8255033&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR UNIVERSITY OF ALABAMA AT BIRMINGHAM J Cell Sci
P30CA008748 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8351778'>A Master Autoantigen-ome Links Alternative Splicing, Female Predilection, and COVID-19 to Autoimmune Diseases.</a> 8351778 34373855 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34373855'>bioRxiv : the preprint server for biology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34373855&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8351778&action=cited'>Cited By, PMC</a> 866 Non-SBIR/STTR UNIV OF NORTH CAROLINA CHAPEL HILL bioRxiv
R01MH109520 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7887247'>Pairwise maximum entropy model explains the role of white matter structure in shaping emergent co-activation states.</a> 7887247 33594239 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33594239'>Communications biology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33594239&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7887247&action=cited'>Cited By, PMC</a> 866 Non-SBIR/STTR AUGUSTA UNIVERSITY Commun Biol
U01HG007530 Functional and structural analysis of cytokine-selective IL6ST defects that cause recessive hyper-IgE syndrome. 33771552 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33771552'>The Journal of allergy and clinical immunology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33771552&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> 866 Non-SBIR/STTR UNIVERSITY OF TEXAS MED BR GALVESTON J Allergy Clin Immunol
P30EY014801 The 100 most cited papers on retinal detachment: a bibliographic perspective. 8481341 33785506 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33785506'>The British journal of ophthalmology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33785506&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8481341&action=cited'>Cited By, PMC</a> 853 Non-SBIR/STTR YALE UNIVERSITY Br J Ophthalmol
D43TW007393 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8146470'>Antimicrobial Resistance Patterns and Dynamics of Extended-Spectrum β-Lactamase-Producing Uropathogenic Escherichia coli in Cusco, Peru.</a> 8146470 33922269 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33922269'>Antibiotics (Basel, Switzerland)</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33922269&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8146470&action=cited'>Cited By, PMC</a> 395 Non-SBIR/STTR JOHNS HOPKINS UNIVERSITY Antibiotics (Basel)
ZIAAI000249 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8019658'>COVID-19 Vaccination in Mastocytosis: Recommendations of the European Competence Network on Mastocytosis (ECNM) and American Initiative in Mast Cell Diseases (AIM).</a> 8019658 33831618 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33831618'>The journal of allergy and clinical immunology. In practice</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33831618&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8019658&action=cited'>Cited By, PMC</a> 866 Non-SBIR/STTR UNIVERSITY OF CALIFORNIA, SAN FRANCISCO J Allergy Clin Immunol Pract
P30EY026877 Neuro-Ophthalmic Emergencies. 8081067 33896536 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33896536'>Neurologic clinics</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33896536&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8081067&action=cited'>Cited By, PMC</a> 350 Research Centers ICAHN SCHOOL OF MEDICINE AT MOUNT SINAI Neurol Clin
R01NS097437 Is Levodopa Response a Valid Indicator of Parkinson’s Disease? 8046721 33253432 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33253432'>Movement disorders : official journal of the Movement Disorder Society</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33253432&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8046721&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR UNIVERSITY OF CALIFORNIA BERKELEY Mov Disord
R01AI104887 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8072330'>SARS-CoV-2 induces double-stranded RNA-mediated innate immune responses in respiratory epithelial-derived cells and cardiomyocytes.</a> 8072330 33811184 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33811184'>Proceedings of the National Academy of Sciences of the United States of America</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33811184&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8072330&action=cited'>Cited By, PMC</a> 279 Non-SBIR/STTR UNIVERSITY OF CALIFORNIA, SAN DIEGO Proc Natl Acad Sci U S A
R01HL113084 Remodeling of the m6A landscape in the heart reveals few conserved post-transcriptional events underlying cardiomyocyte hypertrophy. 7880874 33188779 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33188779'>Journal of molecular and cellular cardiology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33188779&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7880874&action=cited'>Cited By, PMC</a> 279 Non-SBIR/STTR NEW YORK STATE PSYCHIATRIC INSTITUTE J Mol Cell Cardiol
R01EY023397 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8102485'>Cytochrome P450-epoxygenated fatty acids inhibit Müller glial inflammation.</a> 8102485 33958662 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33958662'>Scientific reports</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33958662&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8102485&action=cited'>Cited By, PMC</a> 866 Non-SBIR/STTR OREGON HEALTH & SCIENCE UNIVERSITY Sci Rep
R24ES028524 Epigenetic Biomarkers of Prenatal Tobacco Smoke Exposure Are Associated with Gene Deletions in Childhood Acute Lymphoblastic Leukemia. 8338876 34020997 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34020997'>Cancer epidemiology, biomarkers & prevention : a publication of the American Association for Cancer Research, cosponsored by the American Society of Preventive Oncology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34020997&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8338876&action=cited'>Cited By, PMC</a> 838 Non-SBIR/STTR UNIVERSITY OF ALABAMA AT BIRMINGHAM Cancer Epidemiol Biomarkers Prev
R01HD041702 Maternal and cord plasma branched-chain amino acids and child risk of attention-deficit hyperactivity disorder: a prospective birth cohort study. 32960988 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/32960988'>Journal of child psychology and psychiatry, and allied disciplines</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=32960988&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> 837 Non-SBIR/STTR NORTHWESTERN UNIVERSITY AT CHICAGO J Child Psychol Psychiatry
T32EY023211 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7829161'>Artifacts and artifact removal in optical coherence tomographic angiography.</a> 7829161 33654681 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33654681'>Quantitative imaging in medicine and surgery</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33654681&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7829161&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR UNIVERSITY OF TEXAS, AUSTIN Quant Imaging Med Surg
R03AI144253 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8010169'>Revival of Leishmanization and Leishmanin.</a> 8010169 33816344 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33816344'>Frontiers in cellular and infection microbiology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33816344&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8010169&action=cited'>Cited By, PMC</a> 396 Non-SBIR/STTR UNIVERSITY OF OKLAHOMA HLTH SCIENCES CTR Front Cell Infect Microbiol
K23HL136899 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7985428'>Quantifying Variation in Treatment Utilization for Type 2 Diabetes Across Five Major University of California Health Systems.</a> 7985428 33531419 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33531419'>Diabetes care</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33531419&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7985428&action=cited'>Cited By, PMC</a> 855 Non-SBIR/STTR UNIV OF NORTH CAROLINA CHAPEL HILL Diabetes Care
R01GM124018 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8351544'>SET levels contribute to cohesion fatigue.</a> 8351544 33909454 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33909454'>Molecular biology of the cell</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33909454&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8351544&action=cited'>Cited By, PMC</a> 866 Non-SBIR/STTR MARYMOUNT UNIVERSITY Mol Biol Cell
R21AG066016 Central Cholinergic Synapse Formation in Optimized Primary Septal-Hippocampal Co-cultures. 7914286 32860154 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/32860154'>Cellular and molecular neurobiology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=32860154&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7914286&action=cited'>Cited By, PMC</a> 395 SBIR/STTR UNANDUP, LLC Cell Mol Neurobiol
K01AA024796 Craving management: Exploring factors that influence momentary craving-related risk of cannabis use among young adults. 33383565 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33383565'>Addictive behaviors</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33383565&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> 855 SBIR/STTR BIOINCEPT, LLC Addict Behav
UM1AI069432 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8453103'>Mortality Among Persons Entering HIV Care Compared With the General U.S. Population : An Observational Study.</a> 8453103 34224262 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34224262'>Annals of internal medicine</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34224262&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8453103&action=cited'>Cited By, PMC</a> 394 SBIR/STTR VAJRA INSTRUMENTS, INC. Ann Intern Med
R01GM100088 Dynein light chain-dependent dimerization of Egalitarian is essential for maintaining oocyte fate in Drosophila. 8374726 34181915 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34181915'>Developmental biology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34181915&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8374726&action=cited'>Cited By, PMC</a> 351 Other Research-Related UNIVERSITY OF KENTUCKY Dev Biol
K23HL151826 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8111143'>Comparative Performance of Five Commercially Available Serologic Assays To Detect Antibodies to SARS-CoV-2 and Identify Individuals with High Neutralizing Titers.</a> 8111143 33139419 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33139419'>Journal of clinical microbiology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33139419&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8111143&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR UNIV OF MASSACHUSETTS MED SCH WORCESTER J Clin Microbiol
P51OD010425 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8428855'>Scaled, high fidelity electrophysiological, morphological, and transcriptomic cell characterization.</a> 8428855 34387544 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34387544'>eLife</a>; <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34387544&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8428855&action=cited'>Cited By, PMC</a> 113 Non-SBIR/STTR JOHNS HOPKINS UNIVERSITY Elife
P30AG064201 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7675665'>Succeeding in Aging Research During the Pandemic: Strategies for Fellows and Junior Faculty.</a> 7675665 33047812 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33047812'>Journal of the American Geriatrics Society</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33047812&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7675665&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR UNIVERSITY OF WYOMING J Am Geriatr Soc
P2CHD086843 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7844226'>Epigenetic silencing directs expression heterogeneity of stably integrated multi-transcript unit genetic circuits.</a> 7844226 33510302 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33510302'>Scientific reports</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33510302&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7844226&action=cited'>Cited By, PMC</a> 865 Non-SBIR/STTR MASSACHUSETTS GENERAL HOSPITAL Sci Rep
T32CA060395 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7855036'>Chemotherapy-Induced Upregulation of Small Extracellular Vesicle-Associated PTX3 Accelerates Breast Cancer Metastasis.</a> 7855036 33115808 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33115808'>Cancer research</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33115808&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7855036&action=cited'>Cited By, PMC</a> 172 Non-SBIR/STTR HARVARD SCHOOL OF PUBLIC HEALTH Cancer Res
R01AI124753 Human microsporidian pathogen Encephalitozoon intestinalis impinges on enterocyte membrane trafficking and signaling. 7938802 33589497 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33589497'>Journal of cell science</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33589497&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7938802&action=cited'>Cited By, PMC</a> 855 Non-SBIR/STTR COLUMBIA UNIVERSITY HEALTH SCIENCES J Cell Sci
R01EB028778 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8171236'>A Comparison of Two Probes to Determine Rectum Optical Properties.</a> 8171236 34083859 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34083859'>Proceedings of SPIE–the International Society for Optical Engineering</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34083859&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8171236&action=cited'>Cited By, PMC</a> 279 Non-SBIR/STTR HENRY M. JACKSON FDN FOR THE ADV MIL/MED Proc SPIE Int Soc Opt Eng
R35GM133760 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7826891'>Immune Cell Production Is Targeted by Parasitoid Wasp Virulence in a Drosophila-Parasitoid Wasp Interaction.</a> 7826891 33429864 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33429864'>Pathogens (Basel, Switzerland)</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33429864&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7826891&action=cited'>Cited By, PMC</a> 242 Non-SBIR/STTR UNIVERSITY OF PITTSBURGH AT PITTSBURGH Pathogens
UM1AI068632 Pharmacokinetics and safety of early nevirapine-based antiretroviral therapy for neonates at high risk for perinatal HIV infection: a phase 1/2 proof of concept study. 7933083 33242457 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33242457'>The lancet. HIV</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33242457&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7933083&action=cited'>Cited By, PMC</a> 173 SBIR/STTR SYNFONICA, LLC Lancet HIV
P01CA111412 Following Transplantation for Acute Myelogenous Leukemia, Donor KIR Cen B02 Better Protects against Relapse than KIR Cen B01. 34117109 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34117109'>Journal of immunology (Baltimore, Md. : 1950)</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34117109&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> 396 Non-SBIR/STTR MEDICAL COLLEGE OF WISCONSIN J Immunol
R01AI137111 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8114807'>Sample processing and single cell RNA-sequencing of peripheral blood immune cells from COVID-19 patients.</a> 8114807 34002169 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34002169'>STAR protocols</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34002169&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8114807&action=cited'>Cited By, PMC</a> 279 Non-SBIR/STTR PENNSYLVANIA STATE UNIVERSITY-UNIV PARK STAR Protoc
K23HL140081 Sex and Race Differences in the Risk of Ischemic Stroke Associated With Fasting Blood Glucose in REGARDS. 8377876 34045272 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34045272'>Neurology</a>; <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34045272&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8377876&action=cited'>Cited By, PMC</a> 859 Non-SBIR/STTR UNIVERSITY OF ALABAMA AT BIRMINGHAM Neurology
R01EB026574 Frequency-Dependent Spatial Coherence in Conventional and Chirp Transmissions. 8162843 33417541 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33417541'>IEEE transactions on ultrasonics, ferroelectrics, and frequency control</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33417541&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8162843&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR UNIVERSITY OF DELAWARE IEEE Trans Ultrason Ferroelectr Freq Control
R01NS106915 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7870847'>Author Correction: Inhibitory neurotransmission drives endocannabinoid degradation to promote memory consolidation.</a> 7870847 33558484 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33558484'>Nature communications</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33558484&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7870847&action=cited'>Cited By, PMC</a> 393 Non-SBIR/STTR TUFTS UNIVERSITY BOSTON Nat Commun
P01CA163205 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8184061'>Cbl-b Is Upregulated and Plays a Negative Role in Activated Human NK Cells.</a> 8184061 33419766 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33419766'>Journal of immunology (Baltimore, Md. : 1950)</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33419766&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8184061&action=cited'>Cited By, PMC</a> 865 Non-SBIR/STTR UNIVERSITY OF CALGARY J Immunol
R01NS102669 MGMT promoter methylation is associated with patient age and 1p/19q status in IDH-mutant gliomas. 8099474 33830235 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33830235'>Neuro-oncology</a>; <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33830235&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8099474&action=cited'>Cited By, PMC</a> 279 Non-SBIR/STTR YALE UNIVERSITY Neuro Oncol
R01DC017114 Individual Variability in Recalibrating to Spectrally Shifted Speech: Implications for Cochlear Implants. 8387328 33795617 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33795617'>Ear and hearing</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33795617&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8387328&action=cited'>Cited By, PMC</a> 837 Non-SBIR/STTR CHILDREN’S MERCY HOSP (KANSAS CITY, MO) Ear Hear
U24NS120055 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7818876'>cAMP/PKA pathway and mitochondrial protection in oxidative stress-induced optic nerve head astrocytes.</a> 7818876 32788457 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/32788457'>Neural regeneration research</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=32788457&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7818876&action=cited'>Cited By, PMC</a> 859 Non-SBIR/STTR MAYO CLINIC ROCHESTER Neural Regen Res
F30CA254033 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8453133'>Chronic cerebral lipocalin 2 exposure elicits hippocampal neuronal dysfunction and cognitive impairment.</a> 8453133 34245812 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34245812'>Brain, behavior, and immunity</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34245812&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8453133&action=cited'>Cited By, PMC</a> 113 Non-SBIR/STTR UNIVERSITY OF PUERTO RICO RIO PIEDRAS Brain Behav Immun
R35HL135834 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8140387'>Airway basal stem cells generate distinct subpopulations of PNECs.</a> 8140387 33882306 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33882306'>Cell reports</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33882306&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8140387&action=cited'>Cited By, PMC</a> 279 Non-SBIR/STTR UNIVERSITY OF MICHIGAN AT ANN ARBOR Cell Rep
ZIAAA000130 Shared genetic risk between eating disorder- and substance-use-related phenotypes: Evidence from genome-wide association studies. 7429266 32064741 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/32064741'>Addiction biology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=32064741&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7429266&action=cited'>Cited By, PMC</a> 395 Non-SBIR/STTR UNIVERSITY OF ROCHESTER Addict Biol
R01HD034568 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7755743'>Mode of delivery, type of labor, and measures of adiposity from childhood to teenage: Project Viva.</a> 7755743 33199815 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33199815'>International journal of obesity (2005)</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33199815&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7755743&action=cited'>Cited By, PMC</a> 853 Non-SBIR/STTR UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN Int J Obes (Lond)
UM1AI126619 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8103677'>CD8 lymphocyte depletion enhances the latency reversal activity of the SMAC mimetic AZD5582 in ART-suppressed SIV-infected rhesus macaques.</a> 8103677 33568515 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33568515'>Journal of virology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33568515&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8103677&action=cited'>Cited By, PMC</a> 361 Non-SBIR/STTR UNIVERSITY OF NEW MEXICO HEALTH SCIS CTR J Virol
T32CA078207 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/7935355'>A modular approach toward producing nanotherapeutics targeting the innate immune system.</a> 7935355 33674313 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33674313'>Science advances</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33674313&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7935355&action=cited'>Cited By, PMC</a> 846 Non-SBIR/STTR COLORADO SCHOOL OF MINES Sci Adv
ZIAAG000948 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/8252519'>Genomewide Association Studies of LRRK2 Modifiers of Parkinson’s Disease.</a> 8252519 33938021 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33938021'>Annals of neurology</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33938021&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8252519&action=cited'>Cited By, PMC</a> 242 Non-SBIR/STTR PURDUE UNIVERSITY Ann Neurol
R01HL139793 EP3 (E-Prostanoid 3) Receptor Mediates Impaired Vasodilation in a Mouse Model of Salt-Sensitive Hypertension. 7946772 33641369 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/33641369'>Hypertension (Dallas, Tex. : 1979)</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=33641369&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7946772&action=cited'>Cited By, PMC</a> 866 Other Research-Related NORTHWESTERN UNIVERSITY AT CHICAGO Hypertension
K23NS105924 Investigating the ‘Weekend Effect’ on Outcomes of Patients Undergoing Endovascular Mechanical Thrombectomy for Ischemic Stroke. 8511062 34375859 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/34375859'>Journal of stroke and cerebrovascular diseases : the official journal of National Stroke Association</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=34375859&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=8511062&action=cited'>Cited By, PMC</a> 847 Non-SBIR/STTR UNIVERSITY OF UTAH J Stroke Cerebrovasc Dis
T32MH073124 Longitudinal Differences in Response to Name Among Infants Developing ASD and Risk for ADHD. 7375942 31974800 <a href=’https://www.ncbi.nlm.nih.gov/pubmed/31974800'>Journal of autism and developmental disorders</a> <a href=’https://www.ncbi.nlm.nih.gov/pubmed?Db=pubmed&DbFrom=pubmed&Cmd=Link&LinkName=pubmed_pubmed&IdsFromResult=31974800&ordinalpos=1&itool=EntrezSystem2.PEntrez.Pubmed.Pubmed_ResultsPanel.Pubmed_DiscoveryPanel.Pubmed_Discovery_RA&log$=relatedarticles&logdbfrom=pubmed'>Related, PubMed</a> <a href=’https://www.pubmedcentral.nih.gov/tocrender.fcgi?artid=7375942&action=cited'>Cited By, PMC</a> 866 SBIR/STTR APDM, INC. J Autism Dev Disord
CONCLUSION :TO GET ARTICLE LINK OF PUBMED EVERY PROJECT NUMBER





FUNDINGS RELEASED IN THAT PARTICULAR YEAR


 /*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
16 records
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
CONCLUSION :ABOVE YOU CAN SEE IN WHAT YEAR HOW MUCH FUNDING WAS RELEASED?