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

Alma - Time Series For Statistical Variables

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

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_0500970
  • 3.16 MB
  • 356,180 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_0500970 (
  "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
);

Alma - Time Series For Statistical Variables

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

Alma - Time Series For Statistical Variables

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

Alma - Time Series For Statistical Variables

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

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_2001350
  • 3.03 MB
  • 354,064 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_2001350 (
  "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
);

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_2601540
  • 3.24 MB
  • 357,574 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_2601540 (
  "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
);

Alma - Time Series For Statistical Variables

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

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_3100975
  • 3.02 MB
  • 352,598 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_3100975 (
  "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
);

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_3502560
  • 817.26 kB
  • 58,724 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_3502560 (
  "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
);

Alma - Time Series For Statistical Variables

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

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_4802044
  • 2.88 MB
  • 343,800 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_4802044 (
  "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
);

Alma - Time Series For Statistical Variables

@datacommons.cities.alma_geoid_5501225
  • 2.99 MB
  • 352,693 rows
  • 12 columns
Loading... 
CREATE TABLE alma_geoid_5501225 (
  "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
);

Alma - Time Series For Statistical Variables

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

Al Mahwit - Time Series For Statistical Variables

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

Al Majma'ah - Time Series For Statistical Variables

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

Al-Malikiyah - Time Series For Statistical Variables

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

Alma, Limpopo - Time Series For Statistical Variables

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

Almancil - Time Series For Statistical Variables

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

Almanor - Time Series For Statistical Variables

@datacommons.cities.almanor_geoid_0601094
  • 2.48 MB
  • 318,260 rows
  • 12 columns
Loading... 
CREATE TABLE almanor_geoid_0601094 (
  "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
);

Al-Manshāh - Time Series For Statistical Variables

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

Al Mansura District - Time Series For Statistical Variables

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

Almaraz - Time Series For Statistical Variables

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

Al-Mashariqah - Time Series For Statistical Variables

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

Alma (town), Buffalo County, Wisconsin - Time Series For Statistical Variables

@datacommons.cities.alma_town_buffalo_county_wisconsin_wikidataid_q4733520
  • 77.48 kB
  • 12,500 rows
  • 12 columns
Loading... 
CREATE TABLE alma_town_buffalo_county_wisconsin_wikidataid_q4733520 (
  "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.