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

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

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

@datacommons.cities.wikidataid_q65073390_wikidataid_q65073390
  • 51.72 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q65073390_wikidataid_q65073390 (
  "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/Q65130168 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q6521053_wikidataid_q6521053
  • 47.83 kB
  • 6,132 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6521053_wikidataid_q6521053 (
  "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/Q65274817 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q65274817_wikidataid_q65274817
  • 61.46 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q65274817_wikidataid_q65274817 (
  "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/Q65296807 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q65296807_wikidataid_q65296807
  • 9.56 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q65296807_wikidataid_q65296807 (
  "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/Q65316504 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q65316504_wikidataid_q65316504
  • 43.29 kB
  • 5,225 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q65316504_wikidataid_q65316504 (
  "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/Q65426060 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q65426060_wikidataid_q65426060
  • 63.49 kB
  • 9,085 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q65426060_wikidataid_q65426060 (
  "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/Q65618226 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q65989379_wikidataid_q65989379
  • 51.73 kB
  • 5,943 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q65989379_wikidataid_q65989379 (
  "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/Q66055597 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q66055597_wikidataid_q66055597
  • 54.91 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q66055597_wikidataid_q66055597 (
  "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/Q66057705 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q66057705_wikidataid_q66057705
  • 10.08 kB
  • 56 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q66057705_wikidataid_q66057705 (
  "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/Q66100986 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q66100986_wikidataid_q66100986
  • 52.32 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q66100986_wikidataid_q66100986 (
  "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/Q66244146 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q66244146_wikidataid_q66244146
  • 30.16 kB
  • 3,303 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q66244146_wikidataid_q66244146 (
  "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/Q664663 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q664663_wikidataid_q664663
  • 63.14 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q664663_wikidataid_q664663 (
  "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/Q66493896 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q66493896_wikidataid_q66493896
  • 50.63 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q66493896_wikidataid_q66493896 (
  "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/Q66545000 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q66546030_wikidataid_q66546030
  • 54.07 kB
  • 7,007 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q66546030_wikidataid_q66546030 (
  "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.