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

Baharak - Time Series For Statistical Variables

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

Baharan Shahr - Time Series For Statistical Variables

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

Baharestan, Isfahan - Time Series For Statistical Variables

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

Bahar - Time Series For Statistical Variables

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

Bahía Solano - Time Series For Statistical Variables

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

Bahawalpur - Time Series For Statistical Variables

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

Bahir Dar - Time Series For Statistical Variables

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

Bahman - Time Series For Statistical Variables

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

Bahnemir - Time Series For Statistical Variables

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

Bahrain: All Cities Or Breakdown By Cities Not Available - Time Series For Statistical Variables

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

Bahreman - Time Series For Statistical Variables

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

Baia De Aramă - Time Series For Statistical Variables

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

Baia De Arieș - Time Series For Statistical Variables

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

Baia Mare - Time Series For Statistical Variables

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

Baia Sprie - Time Series For Statistical Variables

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

Baicheng - Time Series For Statistical Variables

@datacommons.cities.baicheng_wikidataid_q92381
  • 4.7 MB
  • 550,811 rows
  • 12 columns
Loading... 
CREATE TABLE baicheng_wikidataid_q92381 (
  "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
);

Baidland - Time Series For Statistical Variables

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

Baidland - Time Series For Statistical Variables

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

Baidoa - Time Series For Statistical Variables

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

Baidyabati - Time Series For Statistical Variables

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

Baie-Comeau - Time Series For Statistical Variables

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

Baie-D'Urfé - Time Series For Statistical Variables

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

Baiersdorf - Time Series For Statistical Variables

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

Baie-Saint-Paul - Time Series For Statistical Variables

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

Baigan - Time Series For Statistical Variables

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

Share link

Anyone who has the link will be able to view this.