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

Acre - Time Series For Statistical Variables

@datacommons.states.acre_wikidataid_q40780
  • 51.51 KB
  • 5488 rows
  • 12 columns
Loading... 

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

Alabama - Time Series For Statistical Variables

@datacommons.states.alabama_geoid_01
  • 29.52 MB
  • 4583680 rows
  • 12 columns
Loading... 

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

Alagoas - Time Series For Statistical Variables

@datacommons.states.alagoas_wikidataid_q40885
  • 58.67 KB
  • 6218 rows
  • 12 columns
Loading... 

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

Alaska - Time Series For Statistical Variables

@datacommons.states.alaska_geoid_02
  • 18.11 MB
  • 2792882 rows
  • 12 columns
Loading... 

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

Al Qadarif - Time Series For Statistical Variables

@datacommons.states.al_qadarif_wikidataid_q309478
  • 10.16 KB
  • 129 rows
  • 12 columns
Loading... 

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

Amapá - Time Series For Statistical Variables

@datacommons.states.amap_wikidataid_q40130
  • 51.94 KB
  • 5484 rows
  • 12 columns
Loading... 

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

Amazonas - Time Series For Statistical Variables

@datacommons.states.amazonas_wikidataid_q40040
  • 52.18 KB
  • 5387 rows
  • 12 columns
Loading... 

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

Andaman And Nicobar Islands - Time Series For Statistical Variables

@datacommons.states.andaman_and_nicobar_islands_wikidataid_q40888
  • 26.69 MB
  • 2925475 rows
  • 12 columns
Loading... 

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

Andhra Pradesh - Time Series For Statistical Variables

@datacommons.states.andhra_pradesh_wikidataid_q1159
  • 20.58 MB
  • 2157490 rows
  • 12 columns
Loading... 

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

Arizona - Time Series For Statistical Variables

@datacommons.states.arizona_geoid_04
  • 30.27 MB
  • 4517137 rows
  • 12 columns
Loading... 

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

Arkansas - Time Series For Statistical Variables

@datacommons.states.arkansas_geoid_05
  • 26.98 MB
  • 4174533 rows
  • 12 columns
Loading... 

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

Arunachal Pradesh - Time Series For Statistical Variables

@datacommons.states.arunachal_pradesh_wikidataid_q1162
  • 13.52 MB
  • 1407966 rows
  • 12 columns
Loading... 

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

Assam - Time Series For Statistical Variables

@datacommons.states.assam_wikidataid_q1164
  • 20.85 MB
  • 2163366 rows
  • 12 columns
Loading... 

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

Bahia - Time Series For Statistical Variables

@datacommons.states.bahia_wikidataid_q40430
  • 66.16 KB
  • 6776 rows
  • 12 columns
Loading... 

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

Baker Island - Time Series For Statistical Variables

@datacommons.states.baker_island_geoid_81
  • 10.65 KB
  • 200 rows
  • 12 columns
Loading... 

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

Banaadir - Time Series For Statistical Variables

@datacommons.states.banaadir_wikidataid_q806070
  • 9.06 KB
  • 1 row
  • 12 columns
Loading... 

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

Bihar - Time Series For Statistical Variables

@datacommons.states.bihar_wikidataid_q1165
  • 20.82 MB
  • 2164719 rows
  • 12 columns
Loading... 

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

Blue Nile State - Time Series For Statistical Variables

@datacommons.states.blue_nile_state_wikidataid_q309489
  • 10.38 KB
  • 119 rows
  • 12 columns
Loading... 

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

California - Time Series For Statistical Variables

@datacommons.states.california_geoid_06
  • 43.27 MB
  • 6005035 rows
  • 12 columns
Loading... 

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

Ceará - Time Series For Statistical Variables

@datacommons.states.cear_wikidataid_q40123
  • 62.32 KB
  • 6246 rows
  • 12 columns
Loading... 

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

Chandigarh - Time Series For Statistical Variables

@datacommons.states.chandigarh_wikidataid_q43433
  • 27.75 MB
  • 2928533 rows
  • 12 columns
Loading... 

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

Chhattisgarh - Time Series For Statistical Variables

@datacommons.states.chhattisgarh_wikidataid_q1168
  • 20.65 MB
  • 2165206 rows
  • 12 columns
Loading... 

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

Colorado - Time Series For Statistical Variables

@datacommons.states.colorado_geoid_08
  • 30.22 MB
  • 4608706 rows
  • 12 columns
Loading... 

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

Connecticut - Time Series For Statistical Variables

@datacommons.states.connecticut_geoid_09
  • 27.53 MB
  • 4243514 rows
  • 12 columns
Loading... 

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

Dadra And Nagar Haveli - Time Series For Statistical Variables

@datacommons.states.dadra_and_nagar_haveli_wikidataid_q46107
  • 176.03 KB
  • 4540 rows
  • 12 columns
Loading... 

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