NIH Data - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:44Z

Ed at 17:34, 21 September 2020

2020-09-21T17:34:20Z

Ed at 17:20, 20 September 2020

2020-09-20T17:20:06Z

Ed at 17:12, 20 September 2020

2020-09-20T17:12:19Z

MichelleH at 15:09, 31 October 2017

2017-10-31T15:09:59Z

HiraF at 22:33, 21 June 2017

2017-06-21T22:33:29Z

HiraF: /* NIH Grant Location */

2017-06-21T22:32:58Z

NIH Grant Location

CatherineK at 18:35, 3 April 2017

2017-04-03T18:35:25Z

CatherineK at 18:34, 3 April 2017

2017-04-03T18:34:47Z

CatherineK at 18:33, 3 April 2017

2017-04-03T18:33:28Z

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=McNair Center
 |Has title=NIH Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=NIH Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=NIH Data
 |Has owner=Catherine Kirby,

@@ Line 1: / Line 1: @@
-{{McNair Projects
+{{Project
 |Has title=NIH Data
 |Has owner=Catherine Kirby,

@@ Line 2: / Line 2: @@
 |Has title=NIH Data
 |Has owner=Catherine Kirby,
-|Has project status=Active
+|Has project status=Subsume
 }}
 NIH grant data from RePORTER system goes from 1985-2015. The categories/columns are labeled: Application ID, Activity, Administering Institution Code, Application Type, American recover and Reinvestment act funding, award notice data, budget start, budget end, CFDA code, core project number, Education institution type, FOA number, full project number, funding institute code, funding mechanism, fiscal year, institution name, NIH spending category, organization city, organization country, organization department, organization district, organization FIPS, organization name, organization state, organization zipcode, PHR (potential to improve public health), Principal investigator ID, Principal investigator name, program officer name, program start, program end, project terms, project title, serial number, study section, study section name, subproject ID, suffix, support year, direct cost amount, indirect cost amount, total cost, total cost sub project.

@@ Line 13: / Line 13: @@
   E:\McNair\Projects\Federal Grant Data\NIH
-Most data appears to be loaded in database '"biotech"'.
+Most data appears to be loaded in database '''biotech'''.
 ==NIH gathering==

@@ Line 4: / Line 4: @@
 |Has project status=Active
 }}
-NIH grant data from RePORTER system goes from 1985-2015. The categories/columns are labeled: Application ID, Activity, Administering Insititution Code, Application Type, American recover and Reinvestment act funding, award notice data, budget start, budget end, CFDA code, core project number, Education instuition type, FOA number, full project number, funding institute code, fundign mechanism, fiscal year, insitition name, NIH spending category, orgnization city, organization country, organiation department, organization district, organization FIPS, organization name, organization state, organization zipcode, PHR (potential to improve public health), Principal investigator ID, Principal investigaotr name, program officer name, program start, program end, project terms, project title, serial number, study section, study setion name, subproject ID, suffix, support year, direct cost anmount, indirect cost amount, total cost, total cost sub project.
+NIH grant data from RePORTER system goes from 1985-2015. The categories/columns are labeled: Application ID, Activity, Administering Institution Code, Application Type, American recover and Reinvestment act funding, award notice data, budget start, budget end, CFDA code, core project number, Education institution type, FOA number, full project number, funding institute code, funding mechanism, fiscal year, institution name, NIH spending category, organization city, organization country, organization department, organization district, organization FIPS, organization name, organization state, organization zipcode, PHR (potential to improve public health), Principal investigator ID, Principal investigator name, program officer name, program start, program end, project terms, project title, serial number, study section, study section name, subproject ID, suffix, support year, direct cost amount, indirect cost amount, total cost, total cost sub project.
 Catherine focused on combining all years of zipcodes into one text file on the server and used this to then track zipcodes in a csv file.

← Older revision		Revision as of 18:33, 3 April 2017
Line 4:		Line 4:
	\|Has project status=Active		\|Has project status=Active
	}}		}}
		+
		+	NIH grant data from RePORTER system goes from 1985-2015. The categories/columns are labeled: Application ID, Activity, Administering Insititution Code, Application Type, American recover and Reinvestment act funding, award notice data, budget start, budget end, CFDA code, core project number, Education instuition type, FOA number, full project number, funding institute code, fundign mechanism, fiscal year, insitition name, NIH spending category, orgnization city, organization country, organiation department, organization district, organization FIPS, organization name, organization state, organization zipcode, PHR (potential to improve public health), Principal investigator ID, Principal investigaotr name, program officer name, program start, program end, project terms, project title, serial number, study section, study setion name, subproject ID, suffix, support year, direct cost anmount, indirect cost amount, total cost, total cost sub project
		+
		+	==NIH Grant Location==
		+
		+	Lists agency, estimated funding, opportunity title. opportunity number, and the date. Can be used to look up who was awarded the grants. I downloaded all grants offered by the NIH since 2005 (when the data was available)
		+	E:\McNair\Projects\Federal Grant Data\NIH
		+
		+	==NIH gathering==
		+
		+	NIH grants for a given year can be downloaded from [https://report.nih.gov/award/index.cfm https://report.nih.gov/award/index.cfm] as well as [https://exporter.nih.gov/ExPORTER_Catalog.aspx]
		+
		+	This does not specify what the grant was for, but it does list the amount and organization who received the grant. Additionally, the city and state of the organization are included. The number of awards received by each organization in a given year is listed as well. Excel Tables can be downloaded for each each year at this site. I downloaded the table for 2016 as a sample.