Baselight
Sign In

States

State-Level Statistical Variables

@datacommons.states

Loading...
Loading...

About this Dataset

States

This dataset provides statistical variables for worldwide states, offering insights into regional-level trends for analysis of demographics, economy, and public services.

Tables

Rajasthan - Time Series For Statistical Variables

@datacommons.states.rajasthan_wikidataid_q1437
  • 20.55 MB
  • 2164896 rows
  • 12 columns
Loading... 

CREATE TABLE rajasthan_wikidataid_q1437 (
  "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
);

Red Sea - Time Series For Statistical Variables

@datacommons.states.red_sea_wikidataid_q310120
  • 11.88 KB
  • 288 rows
  • 12 columns
Loading... 

CREATE TABLE red_sea_wikidataid_q310120 (
  "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
);

Rhode Island - Time Series For Statistical Variables

@datacommons.states.rhode_island_geoid_44
  • 18.66 MB
  • 2912869 rows
  • 12 columns
Loading... 

CREATE TABLE rhode_island_geoid_44 (
  "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
);

Rio De Janeiro - Time Series For Statistical Variables

@datacommons.states.rio_de_janeiro_wikidataid_q41428
  • 60.44 KB
  • 5573 rows
  • 12 columns
Loading... 

CREATE TABLE rio_de_janeiro_wikidataid_q41428 (
  "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
);

Rio Grande Do Norte - Time Series For Statistical Variables

@datacommons.states.rio_grande_do_norte_wikidataid_q43255
  • 51.66 KB
  • 5484 rows
  • 12 columns
Loading... 

CREATE TABLE rio_grande_do_norte_wikidataid_q43255 (
  "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
);

Rio Grande Do Sul - Time Series For Statistical Variables

@datacommons.states.rio_grande_do_sul_wikidataid_q40030
  • 64.2 KB
  • 6463 rows
  • 12 columns
Loading... 

CREATE TABLE rio_grande_do_sul_wikidataid_q40030 (
  "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
);

River Nile - Time Series For Statistical Variables

@datacommons.states.river_nile_wikidataid_q849297
  • 11.06 KB
  • 221 rows
  • 12 columns
Loading... 

CREATE TABLE river_nile_wikidataid_q849297 (
  "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
);

Rondônia - Time Series For Statistical Variables

@datacommons.states.rond_nia_wikidataid_q43235
  • 54.1 KB
  • 5761 rows
  • 12 columns
Loading... 

CREATE TABLE rond_nia_wikidataid_q43235 (
  "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
);

Roraima - Time Series For Statistical Variables

@datacommons.states.roraima_wikidataid_q42508
  • 52.1 KB
  • 5603 rows
  • 12 columns
Loading... 

CREATE TABLE roraima_wikidataid_q42508 (
  "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
);

Santa Catarina - Time Series For Statistical Variables

@datacommons.states.santa_catarina_wikidataid_q41115
  • 59.79 KB
  • 6043 rows
  • 12 columns
Loading... 

CREATE TABLE santa_catarina_wikidataid_q41115 (
  "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
);

Sennar - Time Series For Statistical Variables

@datacommons.states.sennar_wikidataid_q865534
  • 10.45 KB
  • 144 rows
  • 12 columns
Loading... 

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

Sergipe - Time Series For Statistical Variables

@datacommons.states.sergipe_wikidataid_q43783
  • 56.07 KB
  • 5860 rows
  • 12 columns
Loading... 

CREATE TABLE sergipe_wikidataid_q43783 (
  "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
);

Sikkim - Time Series For Statistical Variables

@datacommons.states.sikkim_wikidataid_q1505
  • 20.65 MB
  • 2157378 rows
  • 12 columns
Loading... 

CREATE TABLE sikkim_wikidataid_q1505 (
  "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
);

São Paulo - Time Series For Statistical Variables

@datacommons.states.s_o_paulo_wikidataid_q175
  • 64.73 KB
  • 5800 rows
  • 12 columns
Loading... 

CREATE TABLE s_o_paulo_wikidataid_q175 (
  "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
);

South Carolina - Time Series For Statistical Variables

@datacommons.states.south_carolina_geoid_45
  • 29.14 MB
  • 4573088 rows
  • 12 columns
Loading... 

CREATE TABLE south_carolina_geoid_45 (
  "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
);

South Dakota - Time Series For Statistical Variables

@datacommons.states.south_dakota_geoid_46
  • 19.29 MB
  • 3142147 rows
  • 12 columns
Loading... 

CREATE TABLE south_dakota_geoid_46 (
  "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
);

South Darfur - Time Series For Statistical Variables

@datacommons.states.south_darfur_wikidataid_q838778
  • 10.54 KB
  • 144 rows
  • 12 columns
Loading... 

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

South Kordofan - Time Series For Statistical Variables

@datacommons.states.south_kordofan_wikidataid_q465490
  • 10.84 KB
  • 154 rows
  • 12 columns
Loading... 

CREATE TABLE south_kordofan_wikidataid_q465490 (
  "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
);

Tamil Nadu - Time Series For Statistical Variables

@datacommons.states.tamil_nadu_wikidataid_q1445
  • 20.39 MB
  • 2157299 rows
  • 12 columns
Loading... 

CREATE TABLE tamil_nadu_wikidataid_q1445 (
  "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
);

Telangana - Time Series For Statistical Variables

@datacommons.states.telangana_wikidataid_q677037
  • 814.9 KB
  • 103258 rows
  • 12 columns
Loading... 

CREATE TABLE telangana_wikidataid_q677037 (
  "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
);

Tennessee - Time Series For Statistical Variables

@datacommons.states.tennessee_geoid_47
  • 31.6 MB
  • 4762483 rows
  • 12 columns
Loading... 

CREATE TABLE tennessee_geoid_47 (
  "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
);

Texas - Time Series For Statistical Variables

@datacommons.states.texas_geoid_48
  • 40.59 MB
  • 5791340 rows
  • 12 columns
Loading... 

CREATE TABLE texas_geoid_48 (
  "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
);

Tocantins - Time Series For Statistical Variables

@datacommons.states.tocantins_wikidataid_q43695
  • 56.59 KB
  • 5999 rows
  • 12 columns
Loading... 

CREATE TABLE tocantins_wikidataid_q43695 (
  "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
);

Tripura - Time Series For Statistical Variables

@datacommons.states.tripura_wikidataid_q1363
  • 20.68 MB
  • 2163197 rows
  • 12 columns
Loading... 

CREATE TABLE tripura_wikidataid_q1363 (
  "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
);

Utah - Time Series For Statistical Variables

@datacommons.states.utah_geoid_49
  • 27.08 MB
  • 4206322 rows
  • 12 columns
Loading... 

CREATE TABLE utah_geoid_49 (
  "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.