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

Arpelar - Time Series For Statistical Variables

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

Arpelar - Time Series For Statistical Variables

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

Arp - Time Series For Statistical Variables

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

Arpin - Time Series For Statistical Variables

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

Arpin - Time Series For Statistical Variables

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

Arraba - Time Series For Statistical Variables

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

Arrah - Time Series For Statistical Variables

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

Arraiolos - Time Series For Statistical Variables

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

Arraiolos - Time Series For Statistical Variables

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

Arraitz-Orkin - Time Series For Statistical Variables

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

Arraiza - Time Series For Statistical Variables

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

Ar Ramtha - Time Series For Statistical Variables

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

Arran–Elderslie - Time Series For Statistical Variables

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

Arranhó - Time Series For Statistical Variables

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

Arraso - Time Series For Statistical Variables

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

Ar Rawdah - Time Series For Statistical Variables

@datacommons.cities.ar_rawdah_wikidataid_q12187948
  • 17.66 kB
  • 1,474 rows
  • 12 columns
Loading... 
CREATE TABLE ar_rawdah_wikidataid_q12187948 (
  "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
);

Arrecife - Time Series For Statistical Variables

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

Arre - Time Series For Statistical Variables

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

Arrey - Time Series For Statistical Variables

@datacommons.cities.arrey_geoid_3504870
  • 2.66 MB
  • 329,967 rows
  • 12 columns
Loading... 
CREATE TABLE arrey_geoid_3504870 (
  "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
);

Arriba - Time Series For Statistical Variables

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

Arrifana - Time Series For Statistical Variables

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

Arrifana - Time Series For Statistical Variables

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

Arrington - Time Series For Statistical Variables

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

Arrington Township - Time Series For Statistical Variables

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

Arrington - Time Series For Statistical Variables

@datacommons.cities.arrington_wikidataid_q4795997
  • 99.04 kB
  • 15,135 rows
  • 12 columns
Loading... 
CREATE TABLE arrington_wikidataid_q4795997 (
  "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.