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

Alviano - Time Series For Statistical Variables

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

Alvie - Time Series For Statistical Variables

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

Alvin - Time Series For Statistical Variables

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

Alvin - Time Series For Statistical Variables

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

Alvin - Time Series For Statistical Variables

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

Alvinlândia - Time Series For Statistical Variables

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

Alviso - Time Series For Statistical Variables

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

Alvite - Time Series For Statistical Variables

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

Alvito - Time Series For Statistical Variables

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

Alvito - Time Series For Statistical Variables

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

Alvo - Time Series For Statistical Variables

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

Alvord - Time Series For Statistical Variables

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

Alvord - Time Series For Statistical Variables

@datacommons.cities.alvord_geoid_4802284
  • 2.93 MB
  • 345,770 rows
  • 12 columns
Loading... 
CREATE TABLE alvord_geoid_4802284 (
  "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
);

Alvordton - Time Series For Statistical Variables

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

Alvor - Time Series For Statistical Variables

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

Alvwood Township - Time Series For Statistical Variables

@datacommons.cities.alvwood_township_geoid_2701288
  • 72.84 kB
  • 12,075 rows
  • 12 columns
Loading... 
CREATE TABLE alvwood_township_geoid_2701288 (
  "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 Wajajah - Time Series For Statistical Variables

@datacommons.cities.al_wajajah_wikidataid_q4704938
  • 26.17 kB
  • 2,643 rows
  • 12 columns
Loading... 
CREATE TABLE al_wajajah_wikidataid_q4704938 (
  "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 Wajh - Time Series For Statistical Variables

@datacommons.cities.al_wajh_wikidataid_q27251
  • 35.16 kB
  • 4,845 rows
  • 12 columns
Loading... 
CREATE TABLE al_wajh_wikidataid_q27251 (
  "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 Wakrah - Time Series For Statistical Variables

@datacommons.cities.al_wakrah_wikidataid_q310893
  • 40.15 kB
  • 4,904 rows
  • 12 columns
Loading... 
CREATE TABLE al_wakrah_wikidataid_q310893 (
  "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 Waleed - Time Series For Statistical Variables

@datacommons.cities.al_waleed_wikidataid_q4704943
  • 24.38 kB
  • 2,656 rows
  • 12 columns
Loading... 
CREATE TABLE al_waleed_wikidataid_q4704943 (
  "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-Wasta - Time Series For Statistical Variables

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

Alwernia - Time Series For Statistical Variables

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

Alyangula - Time Series For Statistical Variables

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

Alytus - Time Series For Statistical Variables

@datacommons.cities.alytus_wikidataid_q450625
  • 40.2 kB
  • 4,773 rows
  • 12 columns
Loading... 
CREATE TABLE alytus_wikidataid_q450625 (
  "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-Zabadani - Time Series For Statistical Variables

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