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

Anathoth - Time Series For Statistical Variables

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

Anatoliko - Time Series For Statistical Variables

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

Anatoli - Time Series For Statistical Variables

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

Anatone - Time Series For Statistical Variables

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

Anavyssos - Time Series For Statistical Variables

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

Anawalt - Time Series For Statistical Variables

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

Anbarabad - Time Series For Statistical Variables

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

Anbaran - Time Series For Statistical Variables

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

Anbar Olum - Time Series For Statistical Variables

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

Ancaster - Time Series For Statistical Variables

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

Anchorage - Time Series For Statistical Variables

@datacommons.cities.anchorage_geoid_02020
  • 44.35 MB
  • 4,975,488 rows
  • 12 columns
Loading... 
CREATE TABLE anchorage_geoid_02020 (
  "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
);

Anchorage - Time Series For Statistical Variables

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

Anchorage Municipality - Time Series For Statistical Variables

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

Anchor Bay - Time Series For Statistical Variables

@datacommons.cities.anchor_bay_geoid_0602028
  • 2.75 MB
  • 335,472 rows
  • 12 columns
Loading... 
CREATE TABLE anchor_bay_geoid_0602028 (
  "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
);

Anchor - Time Series For Statistical Variables

@datacommons.cities.anchor_geoid_1701361
  • 1.39 MB
  • 187,634 rows
  • 12 columns
Loading... 
CREATE TABLE anchor_geoid_1701361 (
  "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
);

Anchor Point - Time Series For Statistical Variables

@datacommons.cities.anchor_point_geoid_0203110
  • 1.62 MB
  • 194,244 rows
  • 12 columns
Loading... 
CREATE TABLE anchor_point_geoid_0203110 (
  "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
);

Anchor Township - Time Series For Statistical Variables

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

Anchovy - Time Series For Statistical Variables

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

Anchuela Del Pedregal - Time Series For Statistical Variables

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

Ancient Corinth - Time Series For Statistical Variables

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

Ancient Oaks - Time Series For Statistical Variables

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

Ancient Oaks - Time Series For Statistical Variables

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

Ancient Ostra - Time Series For Statistical Variables

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

Ancín - Time Series For Statistical Variables

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

Ancona - Time Series For Statistical Variables

@datacommons.cities.ancona_wikidataid_q3415
  • 48.05 kB
  • 5,970 rows
  • 12 columns
Loading... 
CREATE TABLE ancona_wikidataid_q3415 (
  "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.