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

Bandarawela - Time Series For Statistical Variables

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

Bandar Charak - Time Series For Statistical Variables

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

Bandar Deylam - Time Series For Statistical Variables

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

Bandar Deyr - Time Series For Statistical Variables

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

Bandar-e Anzali - Time Series For Statistical Variables

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

Bandar-e Emam Khomeyni - Time Series For Statistical Variables

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

Bandar-e Gaz - Time Series For Statistical Variables

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

Bandar-e Mahshahr - Time Series For Statistical Variables

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

Bandar Ganaveh - Time Series For Statistical Variables

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

Bandar Kangan - Time Series For Statistical Variables

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

Bandar Khamir - Time Series For Statistical Variables

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

Bandar Lampung - Time Series For Statistical Variables

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

Bandar Lengeh - Time Series For Statistical Variables

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

Bandar Rig - Time Series For Statistical Variables

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

Bandar Seri Begawan - Time Series For Statistical Variables

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

Bandar Siraf - Time Series For Statistical Variables

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

Bandar Tasik Puteri - Time Series For Statistical Variables

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

Bandar Torkaman - Time Series For Statistical Variables

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

B And E - Time Series For Statistical Variables

@datacommons.cities.b_and_e_geoid_4805520
  • 2.72 MB
  • 334,156 rows
  • 12 columns
Loading... 
CREATE TABLE b_and_e_geoid_4805520 (
  "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
);

Bandelierkop - Time Series For Statistical Variables

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

Bandel - Time Series For Statistical Variables

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

Bandera - Time Series For Statistical Variables

@datacommons.cities.bandera_geoid_4805528
  • 2.98 MB
  • 351,190 rows
  • 12 columns
Loading... 
CREATE TABLE bandera_geoid_4805528 (
  "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
);

Banderilla - Time Series For Statistical Variables

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

Bandholm - Time Series For Statistical Variables

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

Bandipore - Time Series For Statistical Variables

@datacommons.cities.bandipore_wikidataid_q625761
  • 57.12 kB
  • 7,061 rows
  • 12 columns
Loading... 
CREATE TABLE bandipore_wikidataid_q625761 (
  "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.