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

Ampang Jaya - Time Series For Statistical Variables

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

Amparo, São Paulo - Time Series For Statistical Variables

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

Ampelakia - Time Series For Statistical Variables

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

Ampere North - Time Series For Statistical Variables

@datacommons.cities.ampere_north_geoid_3401184
  • 1.13 MB
  • 68,122 rows
  • 12 columns
Loading... 
CREATE TABLE ampere_north_geoid_3401184 (
  "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
);

Amphicleia - Time Series For Statistical Variables

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

Amphitheatre - Time Series For Statistical Variables

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

Amposta - Time Series For Statistical Variables

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

Ampthill - Time Series For Statistical Variables

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

Ampudia - Time Series For Statistical Variables

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

Amqui - Time Series For Statistical Variables

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

Amreli - Time Series For Statistical Variables

@datacommons.cities.amreli_wikidataid_q589163
  • 24.69 kB
  • 2,814 rows
  • 12 columns
Loading... 
CREATE TABLE amreli_wikidataid_q589163 (
  "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érica - Time Series For Statistical Variables

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

Américo Brasiliense - Time Series For Statistical Variables

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

Amriswil - Time Series For Statistical Variables

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

Amritsar - Time Series For Statistical Variables

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

Amruka - Time Series For Statistical Variables

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

Amstelveen - Time Series For Statistical Variables

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

Amsterdam-Churchill - Time Series For Statistical Variables

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

Amsterdam - Time Series For Statistical Variables

@datacommons.cities.amsterdam_geoid_2901090
  • 2.83 MB
  • 341,448 rows
  • 12 columns
Loading... 
CREATE TABLE amsterdam_geoid_2901090 (
  "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
);

Amsterdam - Time Series For Statistical Variables

@datacommons.cities.amsterdam_geoid_3001525
  • 2.82 MB
  • 341,683 rows
  • 12 columns
Loading... 
CREATE TABLE amsterdam_geoid_3001525 (
  "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
);

Amsterdam - Time Series For Statistical Variables

@datacommons.cities.amsterdam_geoid_3602066
  • 3.36 MB
  • 361,788 rows
  • 12 columns
Loading... 
CREATE TABLE amsterdam_geoid_3602066 (
  "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
);

Amsterdam - Time Series For Statistical Variables

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

Amsterdam - Time Series For Statistical Variables

@datacommons.cities.amsterdam_geoid_3901938
  • 2.86 MB
  • 342,534 rows
  • 12 columns
Loading... 
CREATE TABLE amsterdam_geoid_3901938 (
  "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
);

Amsterdam Township - Time Series For Statistical Variables

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

Amsterdam - Time Series For Statistical Variables

@datacommons.cities.amsterdam_wikidataid_q3152900
  • 39.39 kB
  • 4,535 rows
  • 12 columns
Loading... 
CREATE TABLE amsterdam_wikidataid_q3152900 (
  "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.