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

WikidataId/Q2928657 - Time Series For Statistical Variables

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

WikidataId/Q2938062 - Time Series For Statistical Variables

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

WikidataId/Q2940803 - Time Series For Statistical Variables

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

WikidataId/Q29417899 - Time Series For Statistical Variables

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

WikidataId/Q29430296 - Time Series For Statistical Variables

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

WikidataId/Q2986799 - Time Series For Statistical Variables

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

WikidataId/Q2998129 - Time Series For Statistical Variables

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

WikidataId/Q3008539 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3008539_wikidataid_q3008539
  • 78.86 kB
  • 9,929 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3008539_wikidataid_q3008539 (
  "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
);

WikidataId/Q3011615 - Time Series For Statistical Variables

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

WikidataId/Q3027729 - Time Series For Statistical Variables

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

WikidataId/Q30302641 - Time Series For Statistical Variables

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

WikidataId/Q3049179 - Time Series For Statistical Variables

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

WikidataId/Q3049249 - Time Series For Statistical Variables

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

WikidataId/Q3049559 - Time Series For Statistical Variables

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

WikidataId/Q3050998 - Time Series For Statistical Variables

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

WikidataId/Q3051781 - Time Series For Statistical Variables

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

WikidataId/Q3057492 - Time Series For Statistical Variables

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

WikidataId/Q3059375 - Time Series For Statistical Variables

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

WikidataId/Q3059408 - Time Series For Statistical Variables

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

WikidataId/Q3059419 - Time Series For Statistical Variables

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

WikidataId/Q3060344 - Time Series For Statistical Variables

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

WikidataId/Q3066862 - Time Series For Statistical Variables

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

WikidataId/Q3072832 - Time Series For Statistical Variables

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

WikidataId/Q30752877 - Time Series For Statistical Variables

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

WikidataId/Q308143 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q308143_wikidataid_q308143
  • 73.8 kB
  • 10,405 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q308143_wikidataid_q308143 (
  "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.