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

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_0485260
  • 2.83 MB
  • 340,798 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_0485260 (
  "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
);

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_2387985
  • 102.88 kB
  • 16,427 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_2387985 (
  "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
);

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_3082525
  • 997.21 kB
  • 65,446 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_3082525 (
  "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
);

York - Time Series For Statistical Variables

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

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_3684011
  • 1.04 MB
  • 66,226 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_3684011 (
  "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
);

York - Time Series For Statistical Variables

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

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_3887860
  • 2.65 MB
  • 332,241 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_3887860 (
  "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
);

York - Time Series For Statistical Variables

@datacommons.cities.york_geoid_4287048
  • 3.56 MB
  • 366,869 rows
  • 12 columns
Loading... 
CREATE TABLE york_geoid_4287048 (
  "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
);

York - Time Series For Statistical Variables

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

York - Time Series For Statistical Variables

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

York - Time Series For Statistical Variables

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

York - Time Series For Statistical Variables

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

York Hamlet - Time Series For Statistical Variables

@datacommons.cities.york_hamlet_geoid_3684035
  • 2.7 MB
  • 291,519 rows
  • 12 columns
Loading... 
CREATE TABLE york_hamlet_geoid_3684035 (
  "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
);

York Hamlet - Time Series For Statistical Variables

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

York Harbor - Time Series For Statistical Variables

@datacommons.cities.york_harbor_geoid_2388160
  • 3.05 MB
  • 352,564 rows
  • 12 columns
Loading... 
CREATE TABLE york_harbor_geoid_2388160 (
  "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
);

York Haven - Time Series For Statistical Variables

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

Yorklyn - Time Series For Statistical Variables

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

Yorklyn - Time Series For Statistical Variables

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

Yorkrakine - Time Series For Statistical Variables

@datacommons.cities.yorkrakine_wikidataid_q8055651
  • 56.63 kB
  • 8,019 rows
  • 12 columns
Loading... 
CREATE TABLE yorkrakine_wikidataid_q8055651 (
  "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
);

Yorkshire - Time Series For Statistical Variables

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

Yorkshire - Time Series For Statistical Variables

@datacommons.cities.yorkshire_geoid_3987164
  • 1.32 MB
  • 183,026 rows
  • 12 columns
Loading... 
CREATE TABLE yorkshire_geoid_3987164 (
  "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
);

Yorkshire - Time Series For Statistical Variables

@datacommons.cities.yorkshire_geoid_5188176
  • 3.23 MB
  • 357,012 rows
  • 12 columns
Loading... 
CREATE TABLE yorkshire_geoid_5188176 (
  "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
);

Yorkshire (town), New York - Time Series For Statistical Variables

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

York Springs - Time Series For Statistical Variables

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

Yorkton - Time Series For Statistical Variables

@datacommons.cities.yorkton_wikidataid_q1639696
  • 99.08 kB
  • 13,033 rows
  • 12 columns
Loading... 
CREATE TABLE yorkton_wikidataid_q1639696 (
  "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.