Baselight
Sign In

Cities

Urban Statistics and Key Metrics

@datacommons.cities

Loading...
Loading...

About this Dataset

Cities

This dataset includes key statistical variables for worldwide cities, providing data on population, infrastructure, economy, and urban development.

Tables

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_1782270
  • 3.02 MB
  • 351,637 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_1782270 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_1884752
  • 3.16 MB
  • 355,062 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_1884752 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_2079800
  • 2.9 MB
  • 345,432 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_2079800 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_2183676
  • 3.36 MB
  • 361,374 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_2183676 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_2580510
  • 110.77 kB
  • 17,778 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_2580510 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_2580545
  • 3.25 MB
  • 360,416 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_2580545 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_2980314
  • 3.04 MB
  • 350,267 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_2980314 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_3284600
  • 3.72 MB
  • 376,642 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_3284600 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_3385460
  • 3 MB
  • 347,730 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_3385460 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_3385540
  • 94.15 kB
  • 15,379 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_3385540 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_3985876
  • 2.9 MB
  • 342,003 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_3985876 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_4081575
  • 2.93 MB
  • 346,068 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_4081575 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_4781080
  • 3.27 MB
  • 355,804 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_4781080 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_5186720
  • 3.48 MB
  • 365,095 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_5186720 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_5587600
  • 81.94 kB
  • 13,210 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_5587600 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_5587625
  • 2.89 MB
  • 344,278 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_5587625 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_5587650
  • 87.21 kB
  • 13,761 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_5587650 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_geoid_5683910
  • 92.97 kB
  • 13,950 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_geoid_5683910 (
  "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
);

Winchester Township - Time Series For Statistical Variables

@datacommons.cities.winchester_township_geoid_2770762
  • 97.76 kB
  • 15,463 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_township_geoid_2770762 (
  "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
);

Winchester Township - Time Series For Statistical Variables

@datacommons.cities.winchester_township_geoid_3985890
  • 68.89 kB
  • 12,221 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_township_geoid_3985890 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_wikidataid_q172157
  • 58.14 kB
  • 7,651 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_wikidataid_q172157 (
  "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
);

Winchester - Time Series For Statistical Variables

@datacommons.cities.winchester_wikidataid_q38249818
  • 86.21 kB
  • 13,553 rows
  • 12 columns
Loading... 
CREATE TABLE winchester_wikidataid_q38249818 (
  "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
);

Windber - Time Series For Statistical Variables

@datacommons.cities.windber_geoid_4285632
  • 3.12 MB
  • 354,007 rows
  • 12 columns
Loading... 
CREATE TABLE windber_geoid_4285632 (
  "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
);

Windcrest - Time Series For Statistical Variables

@datacommons.cities.windcrest_geoid_4879672
  • 3.19 MB
  • 358,184 rows
  • 12 columns
Loading... 
CREATE TABLE windcrest_geoid_4879672 (
  "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
);

Windemere - Time Series For Statistical Variables

@datacommons.cities.windemere_geoid_4879676
  • 1.03 MB
  • 67,488 rows
  • 12 columns
Loading... 
CREATE TABLE windemere_geoid_4879676 (
  "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.