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
  • 52.74 kB
  • 5,488 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
  • 30.95 MB
  • 4,583,680 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
  • 60.08 kB
  • 6,218 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.99 MB
  • 2,792,882 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.41 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
  • 53.19 kB
  • 5,484 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
  • 53.44 kB
  • 5,387 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
  • 27.99 MB
  • 2,925,475 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
  • 21.58 MB
  • 2,157,490 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
  • 31.74 MB
  • 4,517,137 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
  • 28.29 MB
  • 4,174,533 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
  • 14.18 MB
  • 1,407,966 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
  • 21.86 MB
  • 2,163,366 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
  • 67.74 kB
  • 6,776 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.91 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.28 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
  • 21.83 MB
  • 2,164,719 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.63 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
  • 45.37 MB
  • 6,005,035 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
  • 63.81 kB
  • 6,246 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
  • 29.1 MB
  • 2,928,533 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
  • 21.65 MB
  • 2,165,206 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
  • 31.68 MB
  • 4,608,706 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
  • 28.86 MB
  • 4,243,514 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
  • 180.25 kB
  • 4,540 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.