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

Kentucky - Time Series For Statistical Variables

@datacommons.states.kentucky_geoid_21
  • 29.29 MB
  • 4502586 rows
  • 12 columns
Loading... 

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

Kerala - Time Series For Statistical Variables

@datacommons.states.kerala_wikidataid_q1186
  • 20.1 MB
  • 2125650 rows
  • 12 columns
Loading... 

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

Khartoum - Time Series For Statistical Variables

@datacommons.states.khartoum_wikidataid_q310385
  • 10.22 KB
  • 99 rows
  • 12 columns
Loading... 

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

Lakshadweep - Time Series For Statistical Variables

@datacommons.states.lakshadweep_wikidataid_q26927
  • 26.62 MB
  • 2923657 rows
  • 12 columns
Loading... 

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

Louisiana - Time Series For Statistical Variables

@datacommons.states.louisiana_geoid_22
  • 30.01 MB
  • 4655504 rows
  • 12 columns
Loading... 

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

Madhya Pradesh - Time Series For Statistical Variables

@datacommons.states.madhya_pradesh_wikidataid_q1188
  • 20.73 MB
  • 2165205 rows
  • 12 columns
Loading... 

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

Maharashtra - Time Series For Statistical Variables

@datacommons.states.maharashtra_wikidataid_q1191
  • 20.74 MB
  • 2162730 rows
  • 12 columns
Loading... 

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

Maine - Time Series For Statistical Variables

@datacommons.states.maine_geoid_23
  • 22.4 MB
  • 3516182 rows
  • 12 columns
Loading... 

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

Manipur - Time Series For Statistical Variables

@datacommons.states.manipur_wikidataid_q1193
  • 20.85 MB
  • 2163168 rows
  • 12 columns
Loading... 

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

Maranhão - Time Series For Statistical Variables

@datacommons.states.maranh_o_wikidataid_q42362
  • 61.56 KB
  • 6512 rows
  • 12 columns
Loading... 

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

Maryland - Time Series For Statistical Variables

@datacommons.states.maryland_geoid_24
  • 29.36 MB
  • 4411384 rows
  • 12 columns
Loading... 

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

Massachusetts - Time Series For Statistical Variables

@datacommons.states.massachusetts_geoid_25
  • 31.23 MB
  • 4672378 rows
  • 12 columns
Loading... 

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

Mato Grosso Do Sul - Time Series For Statistical Variables

@datacommons.states.mato_grosso_do_sul_wikidataid_q43319
  • 57.02 KB
  • 5674 rows
  • 12 columns
Loading... 

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

Mato Grosso - Time Series For Statistical Variables

@datacommons.states.mato_grosso_wikidataid_q42824
  • 57.43 KB
  • 5659 rows
  • 12 columns
Loading... 

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

Meghalaya - Time Series For Statistical Variables

@datacommons.states.meghalaya_wikidataid_q1195
  • 20.88 MB
  • 2164236 rows
  • 12 columns
Loading... 

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

Michigan - Time Series For Statistical Variables

@datacommons.states.michigan_geoid_26
  • 34.07 MB
  • 5064071 rows
  • 12 columns
Loading... 

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

Midway Atoll - Time Series For Statistical Variables

@datacommons.states.midway_atoll_geoid_71
  • 9.28 KB
  • 6 rows
  • 12 columns
Loading... 

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

Minas Gerais - Time Series For Statistical Variables

@datacommons.states.minas_gerais_wikidataid_q39109
  • 65.7 KB
  • 6572 rows
  • 12 columns
Loading... 

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

Minnesota - Time Series For Statistical Variables

@datacommons.states.minnesota_geoid_27
  • 30.66 MB
  • 4625456 rows
  • 12 columns
Loading... 

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

Mississippi - Time Series For Statistical Variables

@datacommons.states.mississippi_geoid_28
  • 26.4 MB
  • 4082336 rows
  • 12 columns
Loading... 

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

Missouri - Time Series For Statistical Variables

@datacommons.states.missouri_geoid_29
  • 31.89 MB
  • 4860709 rows
  • 12 columns
Loading... 

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

Mizoram - Time Series For Statistical Variables

@datacommons.states.mizoram_wikidataid_q1502
  • 20.77 MB
  • 2163148 rows
  • 12 columns
Loading... 

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

Montana - Time Series For Statistical Variables

@datacommons.states.montana_geoid_30
  • 21.48 MB
  • 3447341 rows
  • 12 columns
Loading... 

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

Nagaland - Time Series For Statistical Variables

@datacommons.states.nagaland_wikidataid_q1599
  • 19.98 MB
  • 2126663 rows
  • 12 columns
Loading... 

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

Navassa Island - Time Series For Statistical Variables

@datacommons.states.navassa_island_geoid_76
  • 9.25 KB
  • 2 rows
  • 12 columns
Loading... 

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

Share link

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