Patents And Publications From Federal Grants And
Detailed Contract-Level Data for Empirical Research in Innovation and Science
@kaggle.thedevastator_patents_and_publications_from_federal_grants_and
Detailed Contract-Level Data for Empirical Research in Innovation and Science
@kaggle.thedevastator_patents_and_publications_from_federal_grants_and
CREATE TABLE n_01_patent_contract (
"patent_contract_id" BIGINT,
"piid" VARCHAR,
"patent" BIGINT,
"contract" BIGINT,
"grant" BIGINT
);
CREATE TABLE n_02_procurement_information (
"piid" VARCHAR,
"maj_agency_cat" VARCHAR,
"contractingofficeagencyid" VARCHAR,
"contractingofficeid" VARCHAR,
"dunsnumber" BIGINT,
"typeofcontractpricing" VARCHAR,
"performancebased" VARCHAR,
"typeofsetaside" VARCHAR,
"productorservicecode" VARCHAR,
"psc_cat" VARCHAR,
"description" VARCHAR,
"extentcompeted" VARCHAR,
"numberofoffersreceived" BIGINT,
"reasonnotcompeted" VARCHAR,
"first_signed_date" TIMESTAMP,
"completion_date" VARCHAR,
"last_modification_date" VARCHAR,
"pop_state" VARCHAR,
"pop_city" VARCHAR,
"pop_zipcode" VARCHAR,
"pop_cd" VARCHAR,
"sbir" BIGINT,
"sttr" BIGINT,
"recovery" BIGINT
);
CREATE TABLE n_03_procurement_year (
"piid" VARCHAR,
"fiscal_year" BIGINT,
"total_amount" DOUBLE,
"nr_of_transactions" BIGINT
);
CREATE TABLE n_04_vendor_information (
"dunsnumber" BIGINT,
"vendor_name" VARCHAR,
"vendor_altername" VARCHAR,
"parent_duns" VARCHAR,
"parent_name" VARCHAR,
"state" VARCHAR,
"city" VARCHAR,
"street" VARCHAR,
"zip_code" VARCHAR,
"phone" VARCHAR,
"organizational_type" VARCHAR,
"receive_grants" BIGINT
);
CREATE TABLE n_05_grant_information (
"piid_maj_agency_cat_agency_code_duns_no_cfda_program_n_d2473cb5" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR
);
CREATE TABLE n_06_grant_year (
"piid" VARCHAR,
"fiscal_year" BIGINT,
"total_amount" DOUBLE,
"non_federal" DOUBLE,
"nr_of_transactions" BIGINT
);
CREATE TABLE n_07_grantee_information (
"dunsnumber" BIGINT,
"recipient_name" VARCHAR,
"recipient_state_code" VARCHAR,
"recipient_county_name" VARCHAR,
"recipient_city_name" VARCHAR,
"receip_addr1" VARCHAR,
"recipient_zip" VARCHAR,
"recip_cat_type" VARCHAR,
"receive_contract" BIGINT
);
CREATE TABLE n_08_patent_information (
"patent" BIGINT,
"filing_date" TIMESTAMP,
"grant_date" TIMESTAMP,
"priority" BIGINT,
"ipc_codes" VARCHAR,
"tot_ipc4" BIGINT,
"claims" BIGINT,
"independent_claims" BIGINT,
"words_tot" BIGINT,
"words_indep" BIGINT,
"family_size" BIGINT,
"geo_family_size" BIGINT,
"bwd_citation" BIGINT,
"npl" BIGINT,
"fwd_cit_3" BIGINT,
"fwd_cit_5" BIGINT,
"generality" DOUBLE,
"originality" DOUBLE
);
CREATE TABLE n_09_paper_information (
"piid" VARCHAR,
"wos_id" VARCHAR,
"year" BIGINT
);
Anyone who has the link will be able to view this.