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/Q12391580 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391580_wikidataid_q12391580
  • 58.5 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391580_wikidataid_q12391580 (
  "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/Q12391587 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391587_wikidataid_q12391587
  • 53.88 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391587_wikidataid_q12391587 (
  "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/Q12391605 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391605_wikidataid_q12391605
  • 54.75 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391605_wikidataid_q12391605 (
  "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/Q12391624 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391624_wikidataid_q12391624
  • 66.7 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391624_wikidataid_q12391624 (
  "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/Q12391663 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391663_wikidataid_q12391663
  • 59.43 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391663_wikidataid_q12391663 (
  "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/Q12391674 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391674_wikidataid_q12391674
  • 57.77 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391674_wikidataid_q12391674 (
  "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/Q12391691 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391691_wikidataid_q12391691
  • 55.52 kB
  • 7,002 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391691_wikidataid_q12391691 (
  "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/Q12391733 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391733_wikidataid_q12391733
  • 57.01 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391733_wikidataid_q12391733 (
  "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/Q12391747 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391747_wikidataid_q12391747
  • 57.49 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391747_wikidataid_q12391747 (
  "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/Q12391756 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391756_wikidataid_q12391756
  • 52.97 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391756_wikidataid_q12391756 (
  "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/Q12391799 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391799_wikidataid_q12391799
  • 54.05 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391799_wikidataid_q12391799 (
  "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/Q12391801 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391801_wikidataid_q12391801
  • 59.08 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391801_wikidataid_q12391801 (
  "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/Q12391905 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12391905_wikidataid_q12391905
  • 54 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12391905_wikidataid_q12391905 (
  "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/Q12392049 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392049_wikidataid_q12392049
  • 42.68 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392049_wikidataid_q12392049 (
  "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/Q12392068 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392068_wikidataid_q12392068
  • 54.61 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392068_wikidataid_q12392068 (
  "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/Q12392073 - Time Series For Statistical Variables

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

WikidataId/Q12392086 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392086_wikidataid_q12392086
  • 43.59 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392086_wikidataid_q12392086 (
  "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/Q12392115 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392115_wikidataid_q12392115
  • 59.34 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392115_wikidataid_q12392115 (
  "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/Q12392123 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392123_wikidataid_q12392123
  • 53.85 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392123_wikidataid_q12392123 (
  "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/Q12392130 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392130_wikidataid_q12392130
  • 52.26 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392130_wikidataid_q12392130 (
  "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/Q12392131 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392131_wikidataid_q12392131
  • 60.7 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392131_wikidataid_q12392131 (
  "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/Q12392138 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392138_wikidataid_q12392138
  • 44.31 kB
  • 5,093 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392138_wikidataid_q12392138 (
  "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/Q12392159 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392159_wikidataid_q12392159
  • 53.74 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392159_wikidataid_q12392159 (
  "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/Q12392161 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392161_wikidataid_q12392161
  • 54.02 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392161_wikidataid_q12392161 (
  "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/Q12392169 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12392169_wikidataid_q12392169
  • 56.71 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12392169_wikidataid_q12392169 (
  "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.