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

Anpachi - Time Series For Statistical Variables

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

Anápolis - Time Series For Statistical Variables

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

Anqing - Time Series For Statistical Variables

@datacommons.cities.anqing_wikidataid_q360374
  • 4.8 MB
  • 557,435 rows
  • 12 columns
Loading... 
CREATE TABLE anqing_wikidataid_q360374 (
  "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
);

Anqiu - Time Series For Statistical Variables

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

Ansager - Time Series For Statistical Variables

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

Ansan - Time Series For Statistical Variables

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

Aínsa - Time Series For Statistical Variables

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

Ans, Denmark - Time Series For Statistical Variables

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

Anse La Raye - Time Series For Statistical Variables

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

Anselmo - Time Series For Statistical Variables

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

Ansel Township - Time Series For Statistical Variables

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

Anseong - Time Series For Statistical Variables

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

Anse-à-Pitres - Time Series For Statistical Variables

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

Ansfelden - Time Series For Statistical Variables

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

Anshan - Time Series For Statistical Variables

@datacommons.cities.anshan_wikidataid_q74957
  • 4.83 MB
  • 552,761 rows
  • 12 columns
Loading... 
CREATE TABLE anshan_wikidataid_q74957 (
  "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
);

Anshun - Time Series For Statistical Variables

@datacommons.cities.anshun_wikidataid_q486149
  • 4.73 MB
  • 552,403 rows
  • 12 columns
Loading... 
CREATE TABLE anshun_wikidataid_q486149 (
  "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
);

Ansião - Time Series For Statistical Variables

@datacommons.cities.ansi_o_undata_geo_c20700031
  • 9.28 kB
  • 3 rows
  • 12 columns
Loading... 
CREATE TABLE ansi_o_undata_geo_c20700031 (
  "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
);

Ansião - Time Series For Statistical Variables

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

Ansley - Time Series For Statistical Variables

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

Ansley Township, Custer County, Nebraska - Time Series For Statistical Variables

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

Anson - Time Series For Statistical Variables

@datacommons.cities.anson_geoid_2301360
  • 2.84 MB
  • 339,770 rows
  • 12 columns
Loading... 
CREATE TABLE anson_geoid_2301360 (
  "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
);

Anson - Time Series For Statistical Variables

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

Anson - Time Series For Statistical Variables

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

Ansonia - Time Series For Statistical Variables

@datacommons.cities.ansonia_geoid_0901150
  • 3.35 MB
  • 363,413 rows
  • 12 columns
Loading... 
CREATE TABLE ansonia_geoid_0901150 (
  "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
);

Ansonia - Time Series For Statistical Variables

@datacommons.cities.ansonia_geoid_3902120
  • 2.92 MB
  • 344,146 rows
  • 12 columns
Loading... 
CREATE TABLE ansonia_geoid_3902120 (
  "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.