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

Apúlia - Time Series For Statistical Variables

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

Aplin - Time Series For Statistical Variables

@datacommons.cities.aplin_geoid_0501630
  • 942.38 kB
  • 62,236 rows
  • 12 columns
Loading... 
CREATE TABLE aplin_geoid_0501630 (
  "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
);

Aplington - Time Series For Statistical Variables

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

Aplin Township - Time Series For Statistical Variables

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

Apoera - Time Series For Statistical Variables

@datacommons.cities.apoera_wikidataid_q1318695
  • 9.42 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE apoera_wikidataid_q1318695 (
  "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
);

Apolacon Township - Time Series For Statistical Variables

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

Apolda - Time Series For Statistical Variables

@datacommons.cities.apolda_wikidataid_q490689
  • 74.6 kB
  • 10,266 rows
  • 12 columns
Loading... 
CREATE TABLE apolda_wikidataid_q490689 (
  "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
);

Apollo Bay - Time Series For Statistical Variables

@datacommons.cities.apollo_bay_wikidataid_q619097
  • 63.8 kB
  • 9,112 rows
  • 12 columns
Loading... 
CREATE TABLE apollo_bay_wikidataid_q619097 (
  "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
);

Apollo Beach - Time Series For Statistical Variables

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

Apollo - Time Series For Statistical Variables

@datacommons.cities.apollo_geoid_4202720
  • 3.07 MB
  • 353,720 rows
  • 12 columns
Loading... 
CREATE TABLE apollo_geoid_4202720 (
  "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
);

Apolo, La Paz - Time Series For Statistical Variables

@datacommons.cities.apolo_la_paz_wikidataid_q2307341
  • 27.44 kB
  • 2,809 rows
  • 12 columns
Loading... 
CREATE TABLE apolo_la_paz_wikidataid_q2307341 (
  "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
);

Apopka - Time Series For Statistical Variables

@datacommons.cities.apopka_geoid_1201700
  • 3.59 MB
  • 369,597 rows
  • 12 columns
Loading... 
CREATE TABLE apopka_geoid_1201700 (
  "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
);

Aporo - Time Series For Statistical Variables

@datacommons.cities.aporo_undata_geo_c16800784
  • 9.2 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE aporo_undata_geo_c16800784 (
  "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
);

Aporo - Time Series For Statistical Variables

@datacommons.cities.aporo_wikidataid_q3892968
  • 39.81 kB
  • 5,529 rows
  • 12 columns
Loading... 
CREATE TABLE aporo_wikidataid_q3892968 (
  "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
);

Apostolove - Time Series For Statistical Variables

@datacommons.cities.apostolove_wikidataid_q475572
  • 57.52 kB
  • 6,952 rows
  • 12 columns
Loading... 
CREATE TABLE apostolove_wikidataid_q475572 (
  "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
);

Appalachia - Time Series For Statistical Variables

@datacommons.cities.appalachia_geoid_5102040
  • 2.96 MB
  • 343,854 rows
  • 12 columns
Loading... 
CREATE TABLE appalachia_geoid_5102040 (
  "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
);

Appanoose Township - Time Series For Statistical Variables

@datacommons.cities.appanoose_township_geoid_1701621
  • 92.96 kB
  • 14,870 rows
  • 12 columns
Loading... 
CREATE TABLE appanoose_township_geoid_1701621 (
  "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
);

Appanoose Township - Time Series For Statistical Variables

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

Appeltern - Time Series For Statistical Variables

@datacommons.cities.appeltern_wikidataid_q2634040
  • 78.55 kB
  • 11,024 rows
  • 12 columns
Loading... 
CREATE TABLE appeltern_wikidataid_q2634040 (
  "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
);

Appenzell - Time Series For Statistical Variables

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

Appingedam - Time Series For Statistical Variables

@datacommons.cities.appingedam_wikidataid_q33422054
  • 79.05 kB
  • 11,043 rows
  • 12 columns
Loading... 
CREATE TABLE appingedam_wikidataid_q33422054 (
  "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
);

Appin - Time Series For Statistical Variables

@datacommons.cities.appin_wikidataid_q1404409
  • 34.81 kB
  • 4,594 rows
  • 12 columns
Loading... 
CREATE TABLE appin_wikidataid_q1404409 (
  "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
);

Appin - Time Series For Statistical Variables

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

Appleby - Time Series For Statistical Variables

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

Appleby-in-Westmorland - Time Series For Statistical Variables

@datacommons.cities.appleby_in_westmorland_wikidataid_q621540
  • 70.97 kB
  • 9,356 rows
  • 12 columns
Loading... 
CREATE TABLE appleby_in_westmorland_wikidataid_q621540 (
  "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.