Country Activity Tracker: Artificial Intelligence (Center For Security And Emerging Technology, 2023)
@owid.cset
@owid.cset
CREATE TABLE owid_cset_1 (
"country" VARCHAR,
"year" INTEGER,
"field" VARCHAR,
"disclosed_investment" BIGINT,
"investment_estimated" BIGINT,
"disclosed_investment_summary" BIGINT,
"estimated_investment_summary" BIGINT,
"num_patent_applications" UINTEGER,
"num_patent_granted" INTEGER,
"num_patent_applications_summary" UINTEGER,
"num_patent_granted_summary" UINTEGER,
"num_articles" UINTEGER,
"num_citations" UINTEGER,
"num_articles_summary" UINTEGER,
"num_citations_summary" UINTEGER,
"num_patent_applications_per_mil" FLOAT,
"num_patent_granted_per_mil" FLOAT,
"num_articles_per_mil" FLOAT,
"proportion_patents_granted" FLOAT,
"citations_per_article" FLOAT
);
CREATE TABLE owid_cset_2 (
"country" VARCHAR,
"year" INTEGER,
"field" VARCHAR,
"disclosed_investment" BIGINT,
"investment_estimated" BIGINT,
"disclosed_investment_summary" BIGINT,
"estimated_investment_summary" BIGINT,
"num_patent_applications" UINTEGER,
"num_patent_granted" INTEGER,
"num_patent_applications_summary" UINTEGER,
"num_patent_granted_summary" UINTEGER,
"num_articles" UINTEGER,
"num_citations" UINTEGER,
"num_articles_summary" UINTEGER,
"num_citations_summary" UINTEGER,
"num_patent_applications_per_mil" FLOAT,
"num_patent_granted_per_mil" FLOAT,
"num_articles_per_mil" FLOAT,
"citations_per_article" FLOAT
);
CREATE TABLE owid_cset_3 (
"country" VARCHAR,
"year" INTEGER,
"field" VARCHAR,
"disclosed_investment" BIGINT,
"estimated_investment" BIGINT,
"num_patent_applications" UINTEGER,
"num_patent_granted" INTEGER,
"num_articles" UINTEGER,
"num_citations" UINTEGER,
"num_patent_applications_per_mil" FLOAT,
"num_patent_granted_per_mil" FLOAT,
"num_articles_per_mil" FLOAT
);
Anyone who has the link will be able to view this.