Baselight

Counties

County-Level Data for Regional Insights

@datacommons.counties

Loading...
Loading...

About this Dataset

Counties

This dataset comprises worldwide county-level statistical variables, covering a wide range of metrics such as demographics, economic activity, health, and education.

Tables

Piscataquis County - Time Series For Statistical Variables

@datacommons.counties.piscataquis_county_geoid_23021
  • 36.05 MB
  • 3806549 rows
  • 12 columns
Loading...

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

Pitkin County - Time Series For Statistical Variables

@datacommons.counties.pitkin_county_geoid_08097
  • 37.53 MB
  • 4088479 rows
  • 12 columns
Loading...

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

Pitt County - Time Series For Statistical Variables

@datacommons.counties.pitt_county_geoid_37147
  • 41.34 MB
  • 4617022 rows
  • 12 columns
Loading...

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

Pittsburg County - Time Series For Statistical Variables

@datacommons.counties.pittsburg_county_geoid_40121
  • 38.12 MB
  • 4123579 rows
  • 12 columns
Loading...

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

Pittsylvania County - Time Series For Statistical Variables

@datacommons.counties.pittsylvania_county_geoid_51143
  • 37.65 MB
  • 4019423 rows
  • 12 columns
Loading...

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

Piute County - Time Series For Statistical Variables

@datacommons.counties.piute_county_geoid_49031
  • 33.94 MB
  • 3584901 rows
  • 12 columns
Loading...

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

Placer County - Time Series For Statistical Variables

@datacommons.counties.placer_county_geoid_06061
  • 45.36 MB
  • 5175045 rows
  • 12 columns
Loading...

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

Plaquemines Parish - Time Series For Statistical Variables

@datacommons.counties.plaquemines_parish_geoid_22075
  • 37.26 MB
  • 3976404 rows
  • 12 columns
Loading...

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

Platte County - Time Series For Statistical Variables

@datacommons.counties.platte_county_geoid_29165
  • 40.11 MB
  • 4388407 rows
  • 12 columns
Loading...

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

Platte County - Time Series For Statistical Variables

@datacommons.counties.platte_county_geoid_31141
  • 37.92 MB
  • 4112607 rows
  • 12 columns
Loading...

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

Platte County - Time Series For Statistical Variables

@datacommons.counties.platte_county_geoid_56031
  • 35.54 MB
  • 3772794 rows
  • 12 columns
Loading...

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

Pleasants County - Time Series For Statistical Variables

@datacommons.counties.pleasants_county_geoid_54073
  • 34.98 MB
  • 3665845 rows
  • 12 columns
Loading...

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

Plumas County - Time Series For Statistical Variables

@datacommons.counties.plumas_county_geoid_06063
  • 36.84 MB
  • 3933461 rows
  • 12 columns
Loading...

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

Põlva County - Time Series For Statistical Variables

@datacommons.counties.p_lva_county_wikidataid_q191813
  • 10.8 KB
  • 215 rows
  • 12 columns
Loading...

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

Plymouth County - Time Series For Statistical Variables

@datacommons.counties.plymouth_county_geoid_19149
  • 37.01 MB
  • 3963825 rows
  • 12 columns
Loading...

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

Plymouth County - Time Series For Statistical Variables

@datacommons.counties.plymouth_county_geoid_25023
  • 46.65 MB
  • 5479666 rows
  • 12 columns
Loading...

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

Pocahontas County - Time Series For Statistical Variables

@datacommons.counties.pocahontas_county_geoid_19151
  • 35.4 MB
  • 3732340 rows
  • 12 columns
Loading...

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

Pocahontas County - Time Series For Statistical Variables

@datacommons.counties.pocahontas_county_geoid_54075
  • 35.32 MB
  • 3741960 rows
  • 12 columns
Loading...

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

Požega-Slavonia County - Time Series For Statistical Variables

@datacommons.counties.po_ega_slavonia_county_wikidataid_q58111
  • 10.06 KB
  • 44 rows
  • 12 columns
Loading...

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

Pohnpei State - Time Series For Statistical Variables

@datacommons.counties.pohnpei_state_geoid_64040
  • 57.69 KB
  • 10192 rows
  • 12 columns
Loading...

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

Poinsett County - Time Series For Statistical Variables

@datacommons.counties.poinsett_county_geoid_05111
  • 36.41 MB
  • 3850820 rows
  • 12 columns
Loading...

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

Pointe Coupee Parish - Time Series For Statistical Variables

@datacommons.counties.pointe_coupee_parish_geoid_22077
  • 36.06 MB
  • 3818109 rows
  • 12 columns
Loading...

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

Polk County - Time Series For Statistical Variables

@datacommons.counties.polk_county_geoid_05113
  • 36.38 MB
  • 3856057 rows
  • 12 columns
Loading...

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

Polk County - Time Series For Statistical Variables

@datacommons.counties.polk_county_geoid_12105
  • 46.66 MB
  • 5459289 rows
  • 12 columns
Loading...

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

Polk County - Time Series For Statistical Variables

@datacommons.counties.polk_county_geoid_13233
  • 36.92 MB
  • 3896475 rows
  • 12 columns
Loading...

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