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

Alsager - Time Series For Statistical Variables

@datacommons.cities.alsager_wikidataid_q2388660
  • 71.18 kB
  • 9,920 rows
  • 12 columns
Loading... 
CREATE TABLE alsager_wikidataid_q2388660 (
  "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-Salameh - Time Series For Statistical Variables

@datacommons.cities.al_salameh_wikidataid_q12188445
  • 50.56 kB
  • 6,379 rows
  • 12 columns
Loading... 
CREATE TABLE al_salameh_wikidataid_q12188445 (
  "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 Salman - Time Series For Statistical Variables

@datacommons.cities.al_salman_wikidataid_q4532645
  • 13.51 kB
  • 676 rows
  • 12 columns
Loading... 
CREATE TABLE al_salman_wikidataid_q4532645 (
  "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-Sanamayn - Time Series For Statistical Variables

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

Alsasua – Altsasu - Time Series For Statistical Variables

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

Alsdorf - Time Series For Statistical Variables

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

Alsdorf - Time Series For Statistical Variables

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

Alsea - Time Series For Statistical Variables

@datacommons.cities.alsea_geoid_4101800
  • 1.35 MB
  • 184,822 rows
  • 12 columns
Loading... 
CREATE TABLE alsea_geoid_4101800 (
  "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
);

Alsea - Time Series For Statistical Variables

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

Alsen - Time Series For Statistical Variables

@datacommons.cities.alsen_geoid_3801740
  • 2.65 MB
  • 332,779 rows
  • 12 columns
Loading... 
CREATE TABLE alsen_geoid_3801740 (
  "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
);

Alsey - Time Series For Statistical Variables

@datacommons.cities.alsey_geoid_1700997
  • 2.79 MB
  • 339,869 rows
  • 12 columns
Loading... 
CREATE TABLE alsey_geoid_1700997 (
  "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
);

Alsfeld - Time Series For Statistical Variables

@datacommons.cities.alsfeld_wikidataid_q488314
  • 72.51 kB
  • 9,028 rows
  • 12 columns
Loading... 
CREATE TABLE alsfeld_wikidataid_q488314 (
  "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-Shaafah - Time Series For Statistical Variables

@datacommons.cities.al_shaafah_wikidataid_q12189011
  • 34.74 kB
  • 4,416 rows
  • 12 columns
Loading... 
CREATE TABLE al_shaafah_wikidataid_q12189011 (
  "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-Shajara, Syria - Time Series For Statistical Variables

@datacommons.cities.al_shajara_syria_wikidataid_q12188806
  • 56.49 kB
  • 7,410 rows
  • 12 columns
Loading... 
CREATE TABLE al_shajara_syria_wikidataid_q12188806 (
  "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 Shamal - Time Series For Statistical Variables

@datacommons.cities.al_shamal_wikidataid_q22948561
  • 16.25 kB
  • 1,035 rows
  • 12 columns
Loading... 
CREATE TABLE al_shamal_wikidataid_q22948561 (
  "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-Shaykh Badr - Time Series For Statistical Variables

@datacommons.cities.al_shaykh_badr_wikidataid_q2132653
  • 43.71 kB
  • 5,764 rows
  • 12 columns
Loading... 
CREATE TABLE al_shaykh_badr_wikidataid_q2132653 (
  "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-Shirqat - Time Series For Statistical Variables

@datacommons.cities.al_shirqat_wikidataid_q4523051
  • 16.44 kB
  • 1,022 rows
  • 12 columns
Loading... 
CREATE TABLE al_shirqat_wikidataid_q4523051 (
  "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-Shuaiba - Time Series For Statistical Variables

@datacommons.cities.al_shuaiba_wikidataid_q4073403
  • 45.53 kB
  • 5,674 rows
  • 12 columns
Loading... 
CREATE TABLE al_shuaiba_wikidataid_q4073403 (
  "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-Shuna Al-Shamalyah - Time Series For Statistical Variables

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

Alsip - Time Series For Statistical Variables

@datacommons.cities.alsip_geoid_1701010
  • 3.39 MB
  • 362,103 rows
  • 12 columns
Loading... 
CREATE TABLE alsip_geoid_1701010 (
  "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
);

Alsleben - Time Series For Statistical Variables

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

Alslev - Time Series For Statistical Variables

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

Alstead - Time Series For Statistical Variables

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

Alston - Time Series For Statistical Variables

@datacommons.cities.alston_geoid_1301808
  • 2.75 MB
  • 337,993 rows
  • 12 columns
Loading... 
CREATE TABLE alston_geoid_1301808 (
  "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
);

Alstonville - Time Series For Statistical Variables

@datacommons.cities.alstonville_wikidataid_q964216
  • 56.93 kB
  • 7,220 rows
  • 12 columns
Loading... 
CREATE TABLE alstonville_wikidataid_q964216 (
  "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.