Journal Ranking Dataset

CREATE TABLE journal_ranking_data (
  "rank" BIGINT,
  "title" VARCHAR,
  "oa" BOOLEAN,
  "country" VARCHAR,
  "sjr_index" DOUBLE,
  "citescore" DOUBLE,
  "h_index" BIGINT,
  "best_quartile" VARCHAR,
  "best_categories" VARCHAR,
  "best_subject_area" VARCHAR,
  "best_subject_rank" BIGINT,
  "total_docs" BIGINT,
  "total_docs_3y" BIGINT,
  "total_refs" BIGINT,
  "total_cites_3y" BIGINT,
  "citable_docs_3y" BIGINT,
  "cites_doc_2y" DOUBLE,
  "refs_doc" DOUBLE,
  "publisher" VARCHAR,
  "core_collection" VARCHAR,
  "coverage" VARCHAR,
  "active" VARCHAR,
  "in_press" VARCHAR,
  "iso_language_code" VARCHAR,
  "asjc_codes" VARCHAR,
  "life_sciences" BIGINT,
  "social_sciences" BIGINT,
  "physical_sciences" BIGINT,
  "health_sciences" BIGINT,
  "n_1000_general" BIGINT,
  "n_1100_agricultural_and_biological_sciences" BIGINT,
  "n_1200_arts_and_humanities" BIGINT,
  "n_1300_biochemistry_genetics_and_molecular_biology" BIGINT,
  "n_1400_business_management_and_accounting" BIGINT,
  "n_1500_chemical_engineering" BIGINT,
  "n_1600_chemistry" BIGINT,
  "n_1700_computer_science" BIGINT,
  "n_1800_decision_sciences" BIGINT,
  "n_1900_earth_and_planetary_sciences" BIGINT,
  "n_2000_economics_econometrics_and_finance" BIGINT,
  "n_2100_energy" BIGINT,
  "n_2200_engineering" BIGINT,
  "n_2300_environmental_science" BIGINT,
  "n_2400_immunology_and_microbiology" BIGINT,
  "n_2500_materials_science" BIGINT,
  "n_2600_mathematics" BIGINT,
  "n_2700_medicine" BIGINT,
  "n_2800_neuroscience" BIGINT,
  "n_2900_nursing" BIGINT,
  "n_3000_pharmacology_toxicology_and_pharmaceutics" BIGINT,
  "n_3100_physics_and_astronomy" BIGINT,
  "n_3200_psychology" BIGINT,
  "n_3300_social_sciences" BIGINT,
  "n_3400_veterinary" BIGINT,
  "n_3500_dentistry" BIGINT,
  "n_3600_health_professions" BIGINT
);