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

Nebraska - Time Series For Statistical Variables

@datacommons.states.nebraska_geoid_31
  • 24.36 MB
  • 3777023 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
  • 24.67 MB
  • 3758302 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
  • 22.45 MB
  • 3514246 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
  • 32.94 MB
  • 4964149 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
  • 25.15 MB
  • 3918751 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
  • 36.51 MB
  • 5283113 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
  • 33.53 MB
  • 4991184 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.04 MB
  • 3007040 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.7 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.48 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.73 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
  • 20.65 MB
  • 2165406 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
  • 35.64 MB
  • 5259223 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
  • 28.32 MB
  • 4371104 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
  • 29.2 MB
  • 4492155 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.2 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
  • 59.39 KB
  • 6277 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
  • 62.56 KB
  • 6141 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
  • 56.41 KB
  • 5772 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
  • 35.82 MB
  • 5332165 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
  • 63.02 KB
  • 6360 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
  • 58.71 KB
  • 6184 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
  • 27.04 MB
  • 2925645 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
  • 16.74 MB
  • 2919406 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
  • 13.83 MB
  • 1434107 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.