Baselight

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
  • 30.72 MB
  • 4,502,586 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
  • 21.08 MB
  • 2,125,650 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.47 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
  • 27.91 MB
  • 2,923,657 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
  • 31.47 MB
  • 4,655,504 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
  • 21.74 MB
  • 2,165,205 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
  • 21.75 MB
  • 2,162,730 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
  • 23.49 MB
  • 3,516,182 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
  • 21.86 MB
  • 2,163,168 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
  • 63.03 kB
  • 6,512 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
  • 30.79 MB
  • 4,411,384 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
  • 32.75 MB
  • 4,672,378 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
  • 58.39 kB
  • 5,674 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
  • 58.81 kB
  • 5,659 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
  • 21.89 MB
  • 2,164,236 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
  • 35.73 MB
  • 5,064,071 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.5 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
  • 67.28 kB
  • 6,572 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
  • 32.15 MB
  • 4,625,456 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
  • 27.68 MB
  • 4,082,336 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
  • 33.44 MB
  • 4,860,709 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
  • 21.78 MB
  • 2,163,148 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
  • 22.53 MB
  • 3,447,341 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
  • 20.95 MB
  • 2,126,663 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.47 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
);

Nebraska - Time Series For Statistical Variables

@datacommons.states.nebraska_geoid_31
  • 25.55 MB
  • 3,777,023 rows
  • 12 columns
Loading...
CREATE TABLE nebraska_geoid_31 (
  "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
);

Nevada - Time Series For Statistical Variables

@datacommons.states.nevada_geoid_32
  • 25.87 MB
  • 3,758,302 rows
  • 12 columns
Loading...
CREATE TABLE nevada_geoid_32 (
  "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
);

New Hampshire - Time Series For Statistical Variables

@datacommons.states.new_hampshire_geoid_33
  • 23.54 MB
  • 3,514,246 rows
  • 12 columns
Loading...
CREATE TABLE new_hampshire_geoid_33 (
  "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
);

New Jersey - Time Series For Statistical Variables

@datacommons.states.new_jersey_geoid_34
  • 34.54 MB
  • 4,964,149 rows
  • 12 columns
Loading...
CREATE TABLE new_jersey_geoid_34 (
  "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
);

New Mexico - Time Series For Statistical Variables

@datacommons.states.new_mexico_geoid_35
  • 26.37 MB
  • 3,918,751 rows
  • 12 columns
Loading...
CREATE TABLE new_mexico_geoid_35 (
  "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
);

New York - Time Series For Statistical Variables

@datacommons.states.new_york_geoid_36
  • 38.28 MB
  • 5,283,113 rows
  • 12 columns
Loading...
CREATE TABLE new_york_geoid_36 (
  "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
);

North Carolina - Time Series For Statistical Variables

@datacommons.states.north_carolina_geoid_37
  • 35.16 MB
  • 4,991,184 rows
  • 12 columns
Loading...
CREATE TABLE north_carolina_geoid_37 (
  "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
);

North Dakota - Time Series For Statistical Variables

@datacommons.states.north_dakota_geoid_38
  • 19.97 MB
  • 3,007,040 rows
  • 12 columns
Loading...
CREATE TABLE north_dakota_geoid_38 (
  "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
);

North Darfur - Time Series For Statistical Variables

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

Northern State - Time Series For Statistical Variables

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

North Kordofan - Time Series For Statistical Variables

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

Odisha - Time Series For Statistical Variables

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

Ohio - Time Series For Statistical Variables

@datacommons.states.ohio_geoid_39
  • 37.37 MB
  • 5,259,223 rows
  • 12 columns
Loading...
CREATE TABLE ohio_geoid_39 (
  "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
);

Oklahoma - Time Series For Statistical Variables

@datacommons.states.oklahoma_geoid_40
  • 29.7 MB
  • 4,371,104 rows
  • 12 columns
Loading...
CREATE TABLE oklahoma_geoid_40 (
  "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
);

Oregon - Time Series For Statistical Variables

@datacommons.states.oregon_geoid_41
  • 30.62 MB
  • 4,492,155 rows
  • 12 columns
Loading...
CREATE TABLE oregon_geoid_41 (
  "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
);

Palmyra Atoll - Time Series For Statistical Variables

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

Paraíba - Time Series For Statistical Variables

@datacommons.states.para_ba_wikidataid_q38088
  • 60.81 kB
  • 6,277 rows
  • 12 columns
Loading...
CREATE TABLE para_ba_wikidataid_q38088 (
  "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
);

Paraná - Time Series For Statistical Variables

@datacommons.states.paran_wikidataid_q15499
  • 64.06 kB
  • 6,141 rows
  • 12 columns
Loading...
CREATE TABLE paran_wikidataid_q15499 (
  "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
);

Pará - Time Series For Statistical Variables

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

Pennsylvania - Time Series For Statistical Variables

@datacommons.states.pennsylvania_geoid_42
  • 37.55 MB
  • 5,332,165 rows
  • 12 columns
Loading...
CREATE TABLE pennsylvania_geoid_42 (
  "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
);

Pernambuco - Time Series For Statistical Variables

@datacommons.states.pernambuco_wikidataid_q40942
  • 64.53 kB
  • 6,360 rows
  • 12 columns
Loading...
CREATE TABLE pernambuco_wikidataid_q40942 (
  "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
);

Piauí - Time Series For Statistical Variables

@datacommons.states.piau_wikidataid_q42722
  • 60.12 kB
  • 6,184 rows
  • 12 columns
Loading...
CREATE TABLE piau_wikidataid_q42722 (
  "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
);

Puducherry - Time Series For Statistical Variables

@datacommons.states.puducherry_wikidataid_q66743
  • 28.35 MB
  • 2,925,645 rows
  • 12 columns
Loading...
CREATE TABLE puducherry_wikidataid_q66743 (
  "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
);

Puerto Rico - Time Series For Statistical Variables

@datacommons.states.puerto_rico_geoid_72
  • 17.56 MB
  • 2,919,406 rows
  • 12 columns
Loading...
CREATE TABLE puerto_rico_geoid_72 (
  "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
);

Punjab - Time Series For Statistical Variables

@datacommons.states.punjab_wikidataid_q22424
  • 14.5 MB
  • 1,434,107 rows
  • 12 columns
Loading...
CREATE TABLE punjab_wikidataid_q22424 (
  "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.