Academic Publications Metrics From ACM, IEEE, Etc
Uncovering Interconnectivity of Knowledge Disciplines
@kaggle.thedevastator_academic_publications_metrics_from_acm_ieee_and
Uncovering Interconnectivity of Knowledge Disciplines
@kaggle.thedevastator_academic_publications_metrics_from_acm_ieee_and
CREATE TABLE acm (
"title" VARCHAR,
"authors_name" VARCHAR,
"auths_institution" VARCHAR,
"auths_per_institution" VARCHAR,
"abstract" VARCHAR,
"location" VARCHAR,
"pub_date" VARCHAR,
"citation_nbres" BIGINT,
"download_nbres" BIGINT,
"dio" VARCHAR
);
CREATE TABLE acm_finale_data (
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"universities" VARCHAR,
"author_affiliations" VARCHAR,
"publication_year" BIGINT,
"citation" BIGINT,
"doi" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE clean_data_1 (
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"publication_year" VARCHAR,
"downloads" DOUBLE,
"citations" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE clean_data_2 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"publication_year" VARCHAR,
"downloads" DOUBLE,
"citations" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE clean_data_3 (
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" VARCHAR,
"downloads" DOUBLE,
"citations" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE clean_data_4 (
"unnamed_0_2" BIGINT,
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" BIGINT,
"citations" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE clean_data_5 (
"unnamed_0_2" BIGINT,
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" BIGINT,
"citations" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE final_data (
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" DOUBLE,
"abstract" VARCHAR,
"issn" VARCHAR,
"isbns" VARCHAR,
"doi" VARCHAR,
"article_citation_count" DOUBLE,
"patent_citation_count" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE final_data_2 (
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" DOUBLE,
"abstract" VARCHAR,
"issn" VARCHAR,
"isbns" VARCHAR,
"doi" VARCHAR,
"article_citation_count" DOUBLE,
"patent_citation_count" VARCHAR,
"publisher" VARCHAR
);
CREATE TABLE ieee (
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"publication_title" VARCHAR,
"date_added_to_xplore" VARCHAR,
"publication_year" BIGINT,
"volume" VARCHAR,
"issue" BIGINT,
"start_page" BIGINT,
"end_page" BIGINT,
"abstract" VARCHAR,
"issn" VARCHAR,
"isbns" VARCHAR,
"doi" VARCHAR,
"funding_information" VARCHAR,
"pdf_link" VARCHAR,
"author_keywords" VARCHAR,
"ieee_terms" VARCHAR,
"inspec_controlled_terms" VARCHAR,
"inspec_non_controlled_terms" VARCHAR,
"mesh_terms" VARCHAR,
"article_citation_count" DOUBLE,
"patent_citation_count" VARCHAR,
"reference_count" VARCHAR,
"license" VARCHAR,
"online_date" VARCHAR,
"issue_date" VARCHAR,
"meeting_date" VARCHAR,
"publisher" VARCHAR,
"document_identifier" VARCHAR
);
CREATE TABLE ieee_finale_data (
"unnamed_0_2" BIGINT,
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR,
"citation" DOUBLE
);
CREATE TABLE output_data (
"unnamed_0" BIGINT,
"titre" VARCHAR,
"date" VARCHAR,
"downloads" BIGINT,
"citations" BIGINT,
"authors" VARCHAR,
"article_link" VARCHAR
);
CREATE TABLE scdir_finale_data (
"unnamed_0_2" BIGINT,
"unnamed_0_1" BIGINT,
"unnamed_0" BIGINT,
"document_title" VARCHAR,
"authors" VARCHAR,
"author_affiliations" VARCHAR,
"universities" VARCHAR,
"publication_year" BIGINT,
"citations" DOUBLE,
"doi" VARCHAR,
"publisher" VARCHAR
);
Anyone who has the link will be able to view this.