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

Bansko - Time Series For Statistical Variables

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

Banská Štiavnica - Time Series For Statistical Variables

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

Banstead - Time Series For Statistical Variables

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

Ban Suan - Time Series For Statistical Variables

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

Bantam - Time Series For Statistical Variables

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

Ban Thum - Time Series For Statistical Variables

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

Banting - Time Series For Statistical Variables

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

Bantry - Time Series For Statistical Variables

@datacommons.cities.bantry_geoid_3804740
  • 2.62 MB
  • 331,575 rows
  • 12 columns
Loading... 
CREATE TABLE bantry_geoid_3804740 (
  "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
);

Bantry Township - Time Series For Statistical Variables

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

Banureh - Time Series For Statistical Variables

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

Banwa - Time Series For Statistical Variables

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

Banya, Plovdiv Province - Time Series For Statistical Variables

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

Banyo, Cameroon - Time Series For Statistical Variables

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

Baoding - Time Series For Statistical Variables

@datacommons.cities.baoding_wikidataid_q58584
  • 4.77 MB
  • 556,551 rows
  • 12 columns
Loading... 
CREATE TABLE baoding_wikidataid_q58584 (
  "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
);

Baoji - Time Series For Statistical Variables

@datacommons.cities.baoji_wikidataid_q514796
  • 4.76 MB
  • 556,615 rows
  • 12 columns
Loading... 
CREATE TABLE baoji_wikidataid_q514796 (
  "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
);

Baños De Agua Santa - Time Series For Statistical Variables

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

Baoshan - Time Series For Statistical Variables

@datacommons.cities.baoshan_wikidataid_q496576
  • 4.76 MB
  • 555,437 rows
  • 12 columns
Loading... 
CREATE TABLE baoshan_wikidataid_q496576 (
  "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
);

Baoshan - Time Series For Statistical Variables

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

Baotou - Time Series For Statistical Variables

@datacommons.cities.baotou_wikidataid_q569907
  • 4.69 MB
  • 550,790 rows
  • 12 columns
Loading... 
CREATE TABLE baotou_wikidataid_q569907 (
  "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łażowa - Time Series For Statistical Variables

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

Baozhong - Time Series For Statistical Variables

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

Bapatla - Time Series For Statistical Variables

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

Bapsfontein - Time Series For Statistical Variables

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

Baqa-Jatt - Time Series For Statistical Variables

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

Baqershahr - Time Series For Statistical Variables

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