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

Amsterdam - Time Series For Statistical Variables

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

Amstetten - Time Series For Statistical Variables

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

Amtala, Murshidabad - Time Series For Statistical Variables

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

Am Timan - Time Series For Statistical Variables

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

Amt Stavenhagen - Time Series For Statistical Variables

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

Amudalavalasa - Time Series For Statistical Variables

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

Amundsville Township - Time Series For Statistical Variables

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

Amursk - Time Series For Statistical Variables

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

Amvrosiivka - Time Series For Statistical Variables

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

Amwell Township - Time Series For Statistical Variables

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

Amwell Township - Time Series For Statistical Variables

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

Amyntaio - Time Series For Statistical Variables

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

Anabad - Time Series For Statistical Variables

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

Anacoco - Time Series For Statistical Variables

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

Anaconda - Time Series For Statistical Variables

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

Anacortes - Time Series For Statistical Variables

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

Anacua - Time Series For Statistical Variables

@datacommons.cities.anacua_geoid_4803126
  • 1.14 MB
  • 163,378 rows
  • 12 columns
Loading... 
CREATE TABLE anacua_geoid_4803126 (
  "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
);

Anadarko - Time Series For Statistical Variables

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

Anadia - Time Series For Statistical Variables

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

Anadia - Time Series For Statistical Variables

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

Anadyr - Time Series For Statistical Variables

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

Anagawacho - Time Series For Statistical Variables

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

Anaheim - Time Series For Statistical Variables

@datacommons.cities.anaheim_geoid_0602000
  • 4.49 MB
  • 408,605 rows
  • 12 columns
Loading... 
CREATE TABLE anaheim_geoid_0602000 (
  "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
);

Anahim Lake - Time Series For Statistical Variables

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

Anahola - Time Series For Statistical Variables

@datacommons.cities.anahola_geoid_1502200
  • 1.57 MB
  • 192,445 rows
  • 12 columns
Loading... 
CREATE TABLE anahola_geoid_1502200 (
  "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.