Created
July 31, 2014 02:07
-
-
Save fogonthedowns/0e0c1d539db9a7d4367e to your computer and use it in GitHub Desktop.
NIH Grants
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
format: | |
db.nia.find({"BUDGET_START":{$nin : ['', undefined]}}).forEach( function(obj) {if (typeof(obj.BUDGET_START)!='object') {var datePt = obj.BUDGET_START.split('/');var dateEn = datePt[2] + '-' + datePt[0] + '-' + datePt[1];obj.BUDGET_START = new ISODate(dateEn);db.nia.save(obj);}}); | |
then search: | |
db.nia.find({"BUDGET_START": {$gte: ISODate("2010-01-01T00:00:00.000Z"),$lt: ISODate("2010-12-30T00:00:00.000Z")}}).count() | |
ensure index: | |
db.nia.ensureIndex( { "TOTAL_COST": 1 } ) | |
Sort and limit: | |
db.nia.find({"BUDGET_START": {$gte: ISODate("2010-01-01T00:00:00.000Z"),$lt: ISODate("2010-12-30T00:00:00.000Z")}}).sort( { "TOTAL_COST": -1 }).limit(10) | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3ca"), "APPLICATION_ID" : 8173673, "ACTIVITY" : "UL1", "ADMINISTERING_IC" : "RR", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-06-05T00:00:00Z"), "BUDGET_START" : ISODate("2010-05-01T00:00:00Z"), "BUDGET_END" : "04/30/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "UL1RR025755", "ED_INST_TYPE" : "SCHOOLS OF MEDICINE", "FOA_NUMBER" : "RFA-RM-07-007", "FULL_PROJECT_NUM" : "7UL1RR025755-03", "FUNDING_ICs" : "NCRR:2974875\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "NATIONAL CENTER FOR RESEARCH RESOURCES", "NIH_SPENDING_CATS" : "Clinical Research;Clinical Research", "ORG_CITY" : "COLUMBUS", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "NONE", "ORG_DISTRICT" : 3, "ORG_DUNS" : NumberLong(832127323), "ORG_FIPS" : "US", "ORG_NAME" : "Ohio State University", "ORG_STATE" : "OH", "ORG_ZIPCODE" : 43210, "PHR" : "", "PI_IDS" : "6085315;", "PI_NAMEs" : "JACKSON, REBECCA D;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "05/01/2010", "PROJECT_END" : "04/30/2011", "PROJECT_TERMS" : "Clinical;Ohio;Translational Research;Universities", "PROJECT_TITLE" : "THE OHIO STATE UNIVERSITY CENTER FOR CLINICAL AND TRANSLATIONAL SCIENCE (UL1)", "SERIAL_NUMBER" : 25755, "STUDY_SECTION" : "ZRR1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 5507, "SUFFIX" : "", "SUPPORT_YEAR" : 3, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 2974875 } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c9"), "APPLICATION_ID" : 8173672, "ACTIVITY" : "UL1", "ADMINISTERING_IC" : "RR", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-06-05T00:00:00Z"), "BUDGET_START" : ISODate("2010-05-01T00:00:00Z"), "BUDGET_END" : "04/30/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "UL1RR025755", "ED_INST_TYPE" : "SCHOOLS OF MEDICINE", "FOA_NUMBER" : "RFA-RM-07-007", "FULL_PROJECT_NUM" : "7UL1RR025755-03", "FUNDING_ICs" : "NCRR:56130\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "NATIONAL CENTER FOR RESEARCH RESOURCES", "NIH_SPENDING_CATS" : "Clinical Research;Clinical Research;HIV/AIDS", "ORG_CITY" : "COLUMBUS", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "NONE", "ORG_DISTRICT" : 3, "ORG_DUNS" : NumberLong(832127323), "ORG_FIPS" : "US", "ORG_NAME" : "Ohio State University", "ORG_STATE" : "OH", "ORG_ZIPCODE" : 43210, "PHR" : "", "PI_IDS" : "6085315;", "PI_NAMEs" : "JACKSON, REBECCA D;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "05/01/2010", "PROJECT_END" : "04/30/2011", "PROJECT_TERMS" : "Research;Research Infrastructure", "PROJECT_TITLE" : "CTSA INFRASTRUCTURE FOR AIDS RESEARCH", "SERIAL_NUMBER" : 25755, "STUDY_SECTION" : "ZRR1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 5506, "SUFFIX" : "", "SUPPORT_YEAR" : 3, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 56130 } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c8"), "APPLICATION_ID" : 8173671, "ACTIVITY" : "UL1", "ADMINISTERING_IC" : "RR", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-06-05T00:00:00Z"), "BUDGET_START" : ISODate("2010-05-01T00:00:00Z"), "BUDGET_END" : "04/30/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "UL1RR025755", "ED_INST_TYPE" : "SCHOOLS OF MEDICINE", "FOA_NUMBER" : "RFA-RM-07-007", "FULL_PROJECT_NUM" : "7UL1RR025755-03", "FUNDING_ICs" : "NCRR:56129\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "NATIONAL CENTER FOR RESEARCH RESOURCES", "NIH_SPENDING_CATS" : "Clinical Research;Clinical Research;HIV/AIDS", "ORG_CITY" : "COLUMBUS", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "NONE", "ORG_DISTRICT" : 3, "ORG_DUNS" : NumberLong(832127323), "ORG_FIPS" : "US", "ORG_NAME" : "Ohio State University", "ORG_STATE" : "OH", "ORG_ZIPCODE" : 43210, "PHR" : "", "PI_IDS" : "6085315;", "PI_NAMEs" : "JACKSON, REBECCA D;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "05/01/2010", "PROJECT_END" : "04/30/2011", "PROJECT_TERMS" : "Research;Research Infrastructure", "PROJECT_TITLE" : "CTSA INFRASTRUCTURE FOR AIDS RESEARCH", "SERIAL_NUMBER" : 25755, "STUDY_SECTION" : "ZRR1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 5505, "SUFFIX" : "", "SUPPORT_YEAR" : 3, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 56129 } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c7"), "APPLICATION_ID" : 8173670, "ACTIVITY" : "UL1", "ADMINISTERING_IC" : "RR", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-06-05T00:00:00Z"), "BUDGET_START" : ISODate("2010-05-01T00:00:00Z"), "BUDGET_END" : "04/30/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "UL1RR025755", "ED_INST_TYPE" : "SCHOOLS OF MEDICINE", "FOA_NUMBER" : "RFA-RM-07-007", "FULL_PROJECT_NUM" : "7UL1RR025755-03", "FUNDING_ICs" : "NCRR:1122595\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "NATIONAL CENTER FOR RESEARCH RESOURCES", "NIH_SPENDING_CATS" : "Pediatric;Pediatric;Clinical Research;Clinical Research", "ORG_CITY" : "COLUMBUS", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "NONE", "ORG_DISTRICT" : 3, "ORG_DUNS" : NumberLong(832127323), "ORG_FIPS" : "US", "ORG_NAME" : "Ohio State University", "ORG_STATE" : "OH", "ORG_ZIPCODE" : 43210, "PHR" : "", "PI_IDS" : "6085315;", "PI_NAMEs" : "JACKSON, REBECCA D;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "05/01/2010", "PROJECT_END" : "04/30/2011", "PROJECT_TERMS" : "Pediatric Research;Research Infrastructure", "PROJECT_TITLE" : "CTSA INFRASTRUCTURE FOR PEDIATRIC RESEARCH", "SERIAL_NUMBER" : 25755, "STUDY_SECTION" : "ZRR1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 5504, "SUFFIX" : "", "SUPPORT_YEAR" : 3, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 1122595 } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c6"), "APPLICATION_ID" : 8173669, "ACTIVITY" : "UL1", "ADMINISTERING_IC" : "RR", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-06-05T00:00:00Z"), "BUDGET_START" : ISODate("2010-05-01T00:00:00Z"), "BUDGET_END" : "04/30/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "UL1RR025755", "ED_INST_TYPE" : "SCHOOLS OF MEDICINE", "FOA_NUMBER" : "RFA-RM-07-007", "FULL_PROJECT_NUM" : "7UL1RR025755-03", "FUNDING_ICs" : "NCRR:1403243\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "NATIONAL CENTER FOR RESEARCH RESOURCES", "NIH_SPENDING_CATS" : "Clinical Trials;Clinical Research;Clinical Trials;Clinical Research", "ORG_CITY" : "COLUMBUS", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "NONE", "ORG_DISTRICT" : 3, "ORG_DUNS" : NumberLong(832127323), "ORG_FIPS" : "US", "ORG_NAME" : "Ohio State University", "ORG_STATE" : "OH", "ORG_ZIPCODE" : 43210, "PHR" : "", "PI_IDS" : "6085315;", "PI_NAMEs" : "JACKSON, REBECCA D;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "05/01/2010", "PROJECT_END" : "04/30/2011", "PROJECT_TERMS" : "Clinical Trials;Research Infrastructure", "PROJECT_TITLE" : "CTSA INFRASTRUCTURE FOR CLINICAL TRIALS", "SERIAL_NUMBER" : 25755, "STUDY_SECTION" : "ZRR1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 5503, "SUFFIX" : "", "SUPPORT_YEAR" : 3, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 1403243 } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c3"), "APPLICATION_ID" : 8263271, "ACTIVITY" : "U79", "ADMINISTERING_IC" : "SM", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2011-05-11T00:00:00Z"), "BUDGET_START" : ISODate("2010-09-30T00:00:00Z"), "BUDGET_END" : "09/29/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "U79SM060444", "ED_INST_TYPE" : "", "FOA_NUMBER" : "RFA-SM-07-010", "FULL_PROJECT_NUM" : "7U79SM060444-04", "FUNDING_ICs" : "", "FUNDING_MECHANISM" : "Unknown", "FY" : 2010, "IC_NAME" : "Center for Mental Health Services", "NIH_SPENDING_CATS" : "", "ORG_CITY" : "NEW YORK", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "", "ORG_DISTRICT" : 12, "ORG_DUNS" : NumberLong(121911077), "ORG_FIPS" : "US", "ORG_NAME" : "NEW YORK UNIVERSITY SCHOOL OF MEDICINE", "ORG_STATE" : "NY", "ORG_ZIPCODE" : 10016, "PHR" : "", "PI_IDS" : "10930351;", "PI_NAMEs" : "SAXE, GLENN;", "PROGRAM_OFFICER_NAME" : "GORDON, MALCOLM ", "PROJECT_START" : "09/30/2010", "PROJECT_END" : "09/29/2011", "PROJECT_TERMS" : "", "PROJECT_TITLE" : "Children's Hospital Center for Refugee Trauma", "SERIAL_NUMBER" : 60444, "STUDY_SECTION" : "ZOA1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : "", "SUFFIX" : "", "SUPPORT_YEAR" : 4, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : "" } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c1"), "APPLICATION_ID" : 8134735, "ACTIVITY" : "U79", "ADMINISTERING_IC" : "SM", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-09-08T00:00:00Z"), "BUDGET_START" : ISODate("2010-09-30T00:00:00Z"), "BUDGET_END" : "09/29/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "U79SM060362", "ED_INST_TYPE" : "SCHOOLS OF MEDICINE", "FOA_NUMBER" : "RFA-SM-07-010", "FULL_PROJECT_NUM" : "7U79SM060362-04", "FUNDING_ICs" : "", "FUNDING_MECHANISM" : "Unknown", "FY" : 2010, "IC_NAME" : "Center for Mental Health Services", "NIH_SPENDING_CATS" : "", "ORG_CITY" : "NEW YORK", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "PSYCHIATRY", "ORG_DISTRICT" : 12, "ORG_DUNS" : NumberLong(121911077), "ORG_FIPS" : "US", "ORG_NAME" : "NEW YORK UNIVERSITY SCHOOL OF MEDICINE", "ORG_STATE" : "NY", "ORG_ZIPCODE" : 10016, "PHR" : "", "PI_IDS" : "2084721;", "PI_NAMEs" : "CHEMTOB, CLAUDE M;", "PROGRAM_OFFICER_NAME" : "GORDON, MALCOLM ", "PROJECT_START" : "09/30/2010", "PROJECT_END" : "09/29/2011", "PROJECT_TERMS" : "", "PROJECT_TITLE" : "Child Trauma Institute Treatment &Service Adaptation Center", "SERIAL_NUMBER" : 60362, "STUDY_SECTION" : "ZOA1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : "", "SUFFIX" : "", "SUPPORT_YEAR" : 4, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : "" } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3c0"), "APPLICATION_ID" : 8116171, "ACTIVITY" : "U79", "ADMINISTERING_IC" : "SM", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : ISODate("2010-07-26T00:00:00Z"), "BUDGET_START" : ISODate("2010-09-30T00:00:00Z"), "BUDGET_END" : "09/29/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "U79SM060359", "ED_INST_TYPE" : "", "FOA_NUMBER" : "RFA-SM-07-011", "FULL_PROJECT_NUM" : "7U79SM060359-04", "FUNDING_ICs" : "", "FUNDING_MECHANISM" : "Unknown", "FY" : 2010, "IC_NAME" : "Center for Mental Health Services", "NIH_SPENDING_CATS" : "", "ORG_CITY" : "AURORA", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "", "ORG_DISTRICT" : 6, "ORG_DUNS" : NumberLong(41096314), "ORG_FIPS" : "US", "ORG_NAME" : "UNIVERSITY OF COLORADO DENVER", "ORG_STATE" : "CO", "ORG_ZIPCODE" : NumberLong(800452571), "PHR" : "", "PI_IDS" : "10597344;", "PI_NAMEs" : "SHIPMAN, KIMBERLY;", "PROGRAM_OFFICER_NAME" : "BURROWS-MCELWAIN, CICELY ", "PROJECT_START" : "09/30/2010", "PROJECT_END" : "09/29/2011", "PROJECT_TERMS" : "", "PROJECT_TITLE" : "Denver-Kempe Trauma Collaboration", "SERIAL_NUMBER" : 60359, "STUDY_SECTION" : "ZOA1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : "", "SUFFIX" : "", "SUPPORT_YEAR" : 4, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : "" } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3be"), "APPLICATION_ID" : 8132701, "ACTIVITY" : "U54", "ADMINISTERING_IC" : "HD", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : "", "BUDGET_START" : ISODate("2010-08-16T00:00:00Z"), "BUDGET_END" : "03/31/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "U54HD040093", "ED_INST_TYPE" : "", "FOA_NUMBER" : "RFA-HD-06-005", "FULL_PROJECT_NUM" : "7U54HD040093-09", "FUNDING_ICs" : "NICHD:277688\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "EUNICE KENNEDY SHRIVER NATIONAL INSTITUTE OF CHILD HEALTH &HUMAN DEVELOPMENT", "NIH_SPENDING_CATS" : "", "ORG_CITY" : "EAST LANSING", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "", "ORG_DISTRICT" : 8, "ORG_DUNS" : NumberLong(193247145), "ORG_FIPS" : "US", "ORG_NAME" : "MICHIGAN STATE UNIVERSITY", "ORG_STATE" : "MI", "ORG_ZIPCODE" : NumberLong(488242612), "PHR" : "", "PI_IDS" : "6703604;", "PI_NAMEs" : "FAZLEABAS, ASGERALLY T.;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "08/16/2010", "PROJECT_END" : "03/31/2012", "PROJECT_TERMS" : "", "PROJECT_TITLE" : "Administrative Core", "SERIAL_NUMBER" : 40093, "STUDY_SECTION" : "ZHD1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 8555, "SUFFIX" : "", "SUPPORT_YEAR" : 9, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 277688 } | |
{ "_id" : ObjectId("53d99be8b3ed3f611f32c3bd"), "APPLICATION_ID" : 8132698, "ACTIVITY" : "U54", "ADMINISTERING_IC" : "HD", "APPLICATION_TYPE" : 7, "ARRA_FUNDED" : "N", "AWARD_NOTICE_DATE" : "", "BUDGET_START" : ISODate("2010-08-16T00:00:00Z"), "BUDGET_END" : "03/31/2011", "CFDA_CODE" : "", "CORE_PROJECT_NUM" : "U54HD040093", "ED_INST_TYPE" : "", "FOA_NUMBER" : "RFA-HD-06-005", "FULL_PROJECT_NUM" : "7U54HD040093-09", "FUNDING_ICs" : "NICHD:224562\\", "FUNDING_MECHANISM" : "Research Centers", "FY" : 2010, "IC_NAME" : "EUNICE KENNEDY SHRIVER NATIONAL INSTITUTE OF CHILD HEALTH &HUMAN DEVELOPMENT", "NIH_SPENDING_CATS" : "", "ORG_CITY" : "EAST LANSING", "ORG_COUNTRY" : "UNITED STATES", "ORG_DEPT" : "", "ORG_DISTRICT" : 8, "ORG_DUNS" : NumberLong(193247145), "ORG_FIPS" : "US", "ORG_NAME" : "MICHIGAN STATE UNIVERSITY", "ORG_STATE" : "MI", "ORG_ZIPCODE" : NumberLong(488242612), "PHR" : "", "PI_IDS" : "1865269;", "PI_NAMEs" : "LEACH, RICHARD E;", "PROGRAM_OFFICER_NAME" : "", "PROJECT_START" : "08/16/2010", "PROJECT_END" : "03/31/2012", "PROJECT_TERMS" : "Apoptosis;DTR gene;EGF gene;Epidermal Growth Factor Receptor;ErbB4 gene;Family;First Pregnancy Trimester;Human;Hypoxia;implantation;Metalloproteases;Phospholipase;Receptor Protein-Tyrosine Kinases;Role;Signal Pathway;Signal Transduction;Trans-Activation (Genetics);trophoblast", "PROJECT_TITLE" : "EGF Family Signaling in Human Implantation", "SERIAL_NUMBER" : 40093, "STUDY_SECTION" : "ZHD1", "STUDY_SECTION_NAME" : "Special Emphasis Panel", "SUBPROJECT_ID" : 8553, "SUFFIX" : "", "SUPPORT_YEAR" : 9, "TOTAL_COST" : "", "TOTAL_COST_SUB_PROJECT" : 224562 } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment