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

Uttarakhand - Time Series For Statistical Variables

@datacommons.states.uttarakhand_wikidataid_q1499
  • 20.77 MB
  • 2164381 rows
  • 12 columns
Loading...

CREATE TABLE uttarakhand_wikidataid_q1499 (
  "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
);

Uttar Pradesh - Time Series For Statistical Variables

@datacommons.states.uttar_pradesh_wikidataid_q1498
  • 20.71 MB
  • 2163940 rows
  • 12 columns
Loading...

CREATE TABLE uttar_pradesh_wikidataid_q1498 (
  "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
);

Vermont - Time Series For Statistical Variables

@datacommons.states.vermont_geoid_50
  • 18.63 MB
  • 3018223 rows
  • 12 columns
Loading...

CREATE TABLE vermont_geoid_50 (
  "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
);

Virginia - Time Series For Statistical Variables

@datacommons.states.virginia_geoid_51
  • 32.86 MB
  • 4918694 rows
  • 12 columns
Loading...

CREATE TABLE virginia_geoid_51 (
  "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
);

Wake Island - Time Series For Statistical Variables

@datacommons.states.wake_island_geoid_79
  • 9.22 KB
  • 2 rows
  • 12 columns
Loading...

CREATE TABLE wake_island_geoid_79 (
  "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
);

Washington - Time Series For Statistical Variables

@datacommons.states.washington_geoid_53
  • 32.04 MB
  • 4840637 rows
  • 12 columns
Loading...

CREATE TABLE washington_geoid_53 (
  "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
);

West Bengal - Time Series For Statistical Variables

@datacommons.states.west_bengal_wikidataid_q1356
  • 20.83 MB
  • 2163078 rows
  • 12 columns
Loading...

CREATE TABLE west_bengal_wikidataid_q1356 (
  "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
);

West Darfur - Time Series For Statistical Variables

@datacommons.states.west_darfur_wikidataid_q846331
  • 9.54 KB
  • 18 rows
  • 12 columns
Loading...

CREATE TABLE west_darfur_wikidataid_q846331 (
  "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
);

West Virginia - Time Series For Statistical Variables

@datacommons.states.west_virginia_geoid_54
  • 22.93 MB
  • 3501438 rows
  • 12 columns
Loading...

CREATE TABLE west_virginia_geoid_54 (
  "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
);

White Nile - Time Series For Statistical Variables

@datacommons.states.white_nile_wikidataid_q311371
  • 10.29 KB
  • 97 rows
  • 12 columns
Loading...

CREATE TABLE white_nile_wikidataid_q311371 (
  "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
);

Wisconsin - Time Series For Statistical Variables

@datacommons.states.wisconsin_geoid_55
  • 31.08 MB
  • 4722002 rows
  • 12 columns
Loading...

CREATE TABLE wisconsin_geoid_55 (
  "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
);

Wyoming - Time Series For Statistical Variables

@datacommons.states.wyoming_geoid_56
  • 18.08 MB
  • 2840344 rows
  • 12 columns
Loading...

CREATE TABLE wyoming_geoid_56 (
  "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.