Baselight

Countries

Global Country-Level Statistics

@datacommons.countries

Loading...
Loading...

About this Dataset

Countries

This dataset includes a comprehensive collection of statistical variables related to countries. It covers areas such as population, economy, health, education, and more.

Tables

Palau - Time Series For Statistical Variables

@datacommons.countries.palau_country_plw
  • 1.07 MB
  • 125140 rows
  • 12 columns
Loading...

CREATE TABLE palau_country_plw (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Palestinian Territories - Time Series For Statistical Variables

@datacommons.countries.palestinian_territories_country_pse
  • 1.55 MB
  • 164159 rows
  • 12 columns
Loading...

CREATE TABLE palestinian_territories_country_pse (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Panama - Time Series For Statistical Variables

@datacommons.countries.panama_country_pan
  • 1.89 MB
  • 201115 rows
  • 12 columns
Loading...

CREATE TABLE panama_country_pan (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Papua New Guinea - Time Series For Statistical Variables

@datacommons.countries.papua_new_guinea_country_png
  • 1.87 MB
  • 231149 rows
  • 12 columns
Loading...

CREATE TABLE papua_new_guinea_country_png (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Paraguay - Time Series For Statistical Variables

@datacommons.countries.paraguay_country_pry
  • 2.27 MB
  • 272110 rows
  • 12 columns
Loading...

CREATE TABLE paraguay_country_pry (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Peru - Time Series For Statistical Variables

@datacommons.countries.peru_country_per
  • 2.75 MB
  • 325473 rows
  • 12 columns
Loading...

CREATE TABLE peru_country_per (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Philippines - Time Series For Statistical Variables

@datacommons.countries.philippines_country_phl
  • 2.65 MB
  • 315222 rows
  • 12 columns
Loading...

CREATE TABLE philippines_country_phl (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Pitcairn Islands - Time Series For Statistical Variables

@datacommons.countries.pitcairn_islands_country_pcn
  • 96.2 KB
  • 17802 rows
  • 12 columns
Loading...

CREATE TABLE pitcairn_islands_country_pcn (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Poland - Time Series For Statistical Variables

@datacommons.countries.poland_country_pol
  • 2.7 MB
  • 246748 rows
  • 12 columns
Loading...

CREATE TABLE poland_country_pol (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Portugal - Time Series For Statistical Variables

@datacommons.countries.portugal_country_prt
  • 2.65 MB
  • 252943 rows
  • 12 columns
Loading...

CREATE TABLE portugal_country_prt (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Puerto Rico - Time Series For Statistical Variables

@datacommons.countries.puerto_rico_country_pri
  • 1.34 MB
  • 157258 rows
  • 12 columns
Loading...

CREATE TABLE puerto_rico_country_pri (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Qatar - Time Series For Statistical Variables

@datacommons.countries.qatar_country_qat
  • 1.66 MB
  • 185526 rows
  • 12 columns
Loading...

CREATE TABLE qatar_country_qat (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Romania - Time Series For Statistical Variables

@datacommons.countries.romania_country_rou
  • 2.6 MB
  • 239432 rows
  • 12 columns
Loading...

CREATE TABLE romania_country_rou (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Réunion - Time Series For Statistical Variables

@datacommons.countries.r_union_country_reu
  • 202.7 KB
  • 32352 rows
  • 12 columns
Loading...

CREATE TABLE r_union_country_reu (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Russia - Time Series For Statistical Variables

@datacommons.countries.russia_country_rus
  • 2.34 MB
  • 232705 rows
  • 12 columns
Loading...

CREATE TABLE russia_country_rus (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Rwanda - Time Series For Statistical Variables

@datacommons.countries.rwanda_country_rwa
  • 2.22 MB
  • 265663 rows
  • 12 columns
Loading...

CREATE TABLE rwanda_country_rwa (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Barthélemy - Time Series For Statistical Variables

@datacommons.countries.saint_barth_lemy_country_blm
  • 86.36 KB
  • 15241 rows
  • 12 columns
Loading...

CREATE TABLE saint_barth_lemy_country_blm (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Helena - Time Series For Statistical Variables

@datacommons.countries.saint_helena_country_shn
  • 199.04 KB
  • 36577 rows
  • 12 columns
Loading...

CREATE TABLE saint_helena_country_shn (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Kitts And Nevis - Time Series For Statistical Variables

@datacommons.countries.saint_kitts_and_nevis_country_kna
  • 599.95 KB
  • 72623 rows
  • 12 columns
Loading...

CREATE TABLE saint_kitts_and_nevis_country_kna (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Lucia - Time Series For Statistical Variables

@datacommons.countries.saint_lucia_country_lca
  • 961.26 KB
  • 119190 rows
  • 12 columns
Loading...

CREATE TABLE saint_lucia_country_lca (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Martin - Time Series For Statistical Variables

@datacommons.countries.saint_martin_country_maf
  • 134.83 KB
  • 21680 rows
  • 12 columns
Loading...

CREATE TABLE saint_martin_country_maf (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Pierre And Miquelon - Time Series For Statistical Variables

@datacommons.countries.saint_pierre_and_miquelon_country_spm
  • 894.09 KB
  • 118667 rows
  • 12 columns
Loading...

CREATE TABLE saint_pierre_and_miquelon_country_spm (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Saint Vincent And The Grenadines - Time Series For Statistical Variables

@datacommons.countries.saint_vincent_and_the_grenadines_country_vct
  • 936.54 KB
  • 125961 rows
  • 12 columns
Loading...

CREATE TABLE saint_vincent_and_the_grenadines_country_vct (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Samoa - Time Series For Statistical Variables

@datacommons.countries.samoa_country_wsm
  • 1.64 MB
  • 204062 rows
  • 12 columns
Loading...

CREATE TABLE samoa_country_wsm (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

San Marino - Time Series For Statistical Variables

@datacommons.countries.san_marino_country_smr
  • 374.49 KB
  • 41341 rows
  • 12 columns
Loading...

CREATE TABLE san_marino_country_smr (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Share link

Anyone who has the link will be able to view this.