337
edits
Changes
Jump to navigation
Jump to search
no edit summary
Jeemin_combined_files 2002-2012.csv
Jeemin_combined_files 2013-2015.csv
* psql table formula:
CREATE TABLE all_grants (
APPLICATION_ID integer,
ACTIVITY varchar(3),
ADMINISTERING_IC varchar(2),
APPLICATION_TYPE varchar(1),
ARRA_FUNDED varchar(1),
AWARD_NOTICE_DATE date,
BUDGET_START date,
BUDGET_END date,
CFDA_CODE varchar(3),
CORE_PROJECT_NUM varchar(11),
ED_INST_TYPE varchar(30),
FOA_NUMBER varchar(13),
FULL_PROJECT_NUM varchar(35),
FUNDING_ICs varchar(40),
FUNDING_MECHANISM varchar(23),
FY smallint,
IC_NAME varchar(77),
NIH_SPENDING_CATS varchar(295),
ORG_CITY varchar(20),
ORG_COUNTRY varchar(16),
ORG_DEPT varchar(30),
ORG_DISTRICT smallint,
ORG_DUNS integer,
ORG_FIPS varchar(2),
ORG_NAME varchar(60),
ORG_STATE varchar(2),
ORG_ZIPCODE integer,
PHR varchar(200),
PI_IDS varchar(30),
PI_NAMEs varchar(200),
PROGRAM_OFFICER_NAME varchar(36),
PROJECT_START date,
PROJECT_END date,
PROJECT_TERMS varchar(200),
PROJECT_TITLE varchar(244),
SERIAL_NUMBER smallint,
STUDY_SECTION varchar(4),
STUDY_SECTION_NAME varchar(100),
SUBPROJECT_ID smallint,
SUFFIX varchar(2),
SUPPORT_YEAR smallint,
DIRECT_COST_AMT integer,
INDIRECT_COST_AMT integer,
TOTAL_COST integer,
TOTAL_COST_SUB_PROJECT integer
);
\COPY all_grants FROM 'Jeemin_combined_files 1986-2001.csv' WITH DELIMITER AS E'\t' HEADER NULL AS ''CSV
[[Category:Work Log]]
