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

Ambala - Time Series For Statistical Variables

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

Amba Mariam - Time Series For Statistical Variables

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

Ambam - Time Series For Statistical Variables

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

Ambanja - Time Series For Statistical Variables

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

Ambapani - Time Series For Statistical Variables

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

Ambarnath - Time Series For Statistical Variables

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

Ambato - Time Series For Statistical Variables

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

Ambattur - Time Series For Statistical Variables

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

Ambel - Time Series For Statistical Variables

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

Amber - Time Series For Statistical Variables

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

Amberg - Time Series For Statistical Variables

@datacommons.cities.amberg_geoid_5501650
  • 2.76 MB
  • 338,625 rows
  • 12 columns
Loading... 
CREATE TABLE amberg_geoid_5501650 (
  "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
);

Amberg - Time Series For Statistical Variables

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

Amberley - Time Series For Statistical Variables

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

Amberley - Time Series For Statistical Variables

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

Amber Township - Time Series For Statistical Variables

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

Ambia - Time Series For Statistical Variables

@datacommons.cities.ambia_geoid_1801342
  • 1.46 MB
  • 188,987 rows
  • 12 columns
Loading... 
CREATE TABLE ambia_geoid_1801342 (
  "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
);

Ambia - Time Series For Statistical Variables

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

Ambler - Time Series For Statistical Variables

@datacommons.cities.ambler_geoid_0201970
  • 1.41 MB
  • 181,809 rows
  • 12 columns
Loading... 
CREATE TABLE ambler_geoid_0201970 (
  "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
);

Ambler - Time Series For Statistical Variables

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

Ambleside - Time Series For Statistical Variables

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

Amble - Time Series For Statistical Variables

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

Ambodiharina - Time Series For Statistical Variables

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

Amboli - Time Series For Statistical Variables

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

Ambon - Time Series For Statistical Variables

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

Ambo - Time Series For Statistical Variables

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