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
);

Daman And Diu - Time Series For Statistical Variables

@datacommons.states.daman_and_diu_wikidataid_q66710
  • 164.19 kB
  • 3,849 rows
  • 12 columns
Loading... 
CREATE TABLE daman_and_diu_wikidataid_q66710 (
  "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
);

Delaware - Time Series For Statistical Variables

@datacommons.states.delaware_geoid_10
  • 20.29 MB
  • 2,969,218 rows
  • 12 columns
Loading... 
CREATE TABLE delaware_geoid_10 (
  "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
);

Delhi - Time Series For Statistical Variables

@datacommons.states.delhi_wikidataid_q1353
  • 21.01 MB
  • 2,126,582 rows
  • 12 columns
Loading... 
CREATE TABLE delhi_wikidataid_q1353 (
  "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
);

District Of Columbia - Time Series For Statistical Variables

@datacommons.states.district_of_columbia_geoid_11
  • 16.75 MB
  • 2,328,164 rows
  • 12 columns
Loading... 
CREATE TABLE district_of_columbia_geoid_11 (
  "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
);

Espírito Santo - Time Series For Statistical Variables

@datacommons.states.esp_rito_santo_wikidataid_q43233
  • 52.88 kB
  • 5,272 rows
  • 12 columns
Loading... 
CREATE TABLE esp_rito_santo_wikidataid_q43233 (
  "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
);

Federal District - Time Series For Statistical Variables

@datacommons.states.federal_district_wikidataid_q119158
  • 49.73 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE federal_district_wikidataid_q119158 (
  "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
);

Florida - Time Series For Statistical Variables

@datacommons.states.florida_geoid_12
  • 38.97 MB
  • 5,388,470 rows
  • 12 columns
Loading... 
CREATE TABLE florida_geoid_12 (
  "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
);

Georgia - Time Series For Statistical Variables

@datacommons.states.georgia_geoid_13
  • 34.81 MB
  • 4,930,430 rows
  • 12 columns
Loading... 
CREATE TABLE georgia_geoid_13 (
  "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
);

Gezira - Time Series For Statistical Variables

@datacommons.states.gezira_wikidataid_q309469
  • 10.65 kB
  • 104 rows
  • 12 columns
Loading... 
CREATE TABLE gezira_wikidataid_q309469 (
  "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
);

Goa - Time Series For Statistical Variables

@datacommons.states.goa_wikidataid_q1171
  • 21.61 MB
  • 2,157,704 rows
  • 12 columns
Loading... 
CREATE TABLE goa_wikidataid_q1171 (
  "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
);

Goiás - Time Series For Statistical Variables

@datacommons.states.goi_s_wikidataid_q41587
  • 59.81 kB
  • 5,764 rows
  • 12 columns
Loading... 
CREATE TABLE goi_s_wikidataid_q41587 (
  "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
);

Gujarat - Time Series For Statistical Variables

@datacommons.states.gujarat_wikidataid_q1061
  • 21.59 MB
  • 2,162,608 rows
  • 12 columns
Loading... 
CREATE TABLE gujarat_wikidataid_q1061 (
  "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
);

Haryana - Time Series For Statistical Variables

@datacommons.states.haryana_wikidataid_q1174
  • 14.45 MB
  • 1,434,053 rows
  • 12 columns
Loading... 
CREATE TABLE haryana_wikidataid_q1174 (
  "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
);

Hawaii - Time Series For Statistical Variables

@datacommons.states.hawaii_geoid_15
  • 21.91 MB
  • 3,237,424 rows
  • 12 columns
Loading... 
CREATE TABLE hawaii_geoid_15 (
  "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
);

Himachal Pradesh - Time Series For Statistical Variables

@datacommons.states.himachal_pradesh_wikidataid_q1177
  • 21.69 MB
  • 2,163,364 rows
  • 12 columns
Loading... 
CREATE TABLE himachal_pradesh_wikidataid_q1177 (
  "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
);

Howland Island - Time Series For Statistical Variables

@datacommons.states.howland_island_geoid_84
  • 10.27 kB
  • 64 rows
  • 12 columns
Loading... 
CREATE TABLE howland_island_geoid_84 (
  "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
);

Idaho - Time Series For Statistical Variables

@datacommons.states.idaho_geoid_16
  • 25 MB
  • 3,778,329 rows
  • 12 columns
Loading... 
CREATE TABLE idaho_geoid_16 (
  "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
);

Illinois - Time Series For Statistical Variables

@datacommons.states.illinois_geoid_17
  • 37.07 MB
  • 5,218,956 rows
  • 12 columns
Loading... 
CREATE TABLE illinois_geoid_17 (
  "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
);

Indiana - Time Series For Statistical Variables

@datacommons.states.indiana_geoid_18
  • 32.6 MB
  • 4,706,009 rows
  • 12 columns
Loading... 
CREATE TABLE indiana_geoid_18 (
  "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
);

Iowa - Time Series For Statistical Variables

@datacommons.states.iowa_geoid_19
  • 28.17 MB
  • 4,151,785 rows
  • 12 columns
Loading... 
CREATE TABLE iowa_geoid_19 (
  "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
);

Jammu And Kashmir - Time Series For Statistical Variables

@datacommons.states.jammu_and_kashmir_wikidataid_q66278313
  • 21.85 MB
  • 2,164,281 rows
  • 12 columns
Loading... 
CREATE TABLE jammu_and_kashmir_wikidataid_q66278313 (
  "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
);

Jharkhand - Time Series For Statistical Variables

@datacommons.states.jharkhand_wikidataid_q1184
  • 21.72 MB
  • 2,165,040 rows
  • 12 columns
Loading... 
CREATE TABLE jharkhand_wikidataid_q1184 (
  "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
);

Kansas - Time Series For Statistical Variables

@datacommons.states.kansas_geoid_20
  • 27.85 MB
  • 4,097,643 rows
  • 12 columns
Loading... 
CREATE TABLE kansas_geoid_20 (
  "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
);

Karnataka - Time Series For Statistical Variables

@datacommons.states.karnataka_wikidataid_q1185
  • 21.54 MB
  • 2,164,602 rows
  • 12 columns
Loading... 
CREATE TABLE karnataka_wikidataid_q1185 (
  "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
);

Kassala - Time Series For Statistical Variables

@datacommons.states.kassala_wikidataid_q954963
  • 10.16 kB
  • 53 rows
  • 12 columns
Loading... 
CREATE TABLE kassala_wikidataid_q954963 (
  "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.