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

Daman And Diu - Time Series For Statistical Variables

@datacommons.states.daman_and_diu_wikidataid_q66710
  • 160.34 KB
  • 3849 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
  • 19.35 MB
  • 2969218 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
  • 20.04 MB
  • 2126582 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
  • 15.97 MB
  • 2328164 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
  • 51.64 KB
  • 5272 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
  • 48.56 KB
  • 5092 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
  • 37.16 MB
  • 5388470 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
  • 33.19 MB
  • 4930430 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.4 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
  • 20.6 MB
  • 2157704 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
  • 58.41 KB
  • 5764 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
  • 20.59 MB
  • 2162608 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
  • 13.78 MB
  • 1434053 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
  • 20.9 MB
  • 3237424 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
  • 20.68 MB
  • 2163364 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.03 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
  • 23.85 MB
  • 3778329 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
  • 35.35 MB
  • 5218956 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
  • 31.09 MB
  • 4706009 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
  • 26.86 MB
  • 4151785 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
  • 20.83 MB
  • 2164281 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
  • 20.72 MB
  • 2165040 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
  • 26.56 MB
  • 4097643 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
  • 20.54 MB
  • 2164602 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
  • 9.92 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.