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

@datacommons.cities.wikidataid_q6026615_wikidataid_q6026615
  • 94.95 kB
  • 15,351 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026615_wikidataid_q6026615 (
  "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/Q6026617 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026617_wikidataid_q6026617
  • 80.3 kB
  • 13,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026617_wikidataid_q6026617 (
  "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/Q6026620 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026620_wikidataid_q6026620
  • 88.12 kB
  • 14,513 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026620_wikidataid_q6026620 (
  "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/Q6026632 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026632_wikidataid_q6026632
  • 84.7 kB
  • 13,583 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026632_wikidataid_q6026632 (
  "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/Q6026635 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026635_wikidataid_q6026635
  • 88.52 kB
  • 14,855 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026635_wikidataid_q6026635 (
  "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/Q6026641 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026641_wikidataid_q6026641
  • 94.76 kB
  • 15,220 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026641_wikidataid_q6026641 (
  "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/Q6026644 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026644_wikidataid_q6026644
  • 92.17 kB
  • 15,079 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026644_wikidataid_q6026644 (
  "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/Q6026647 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026647_wikidataid_q6026647
  • 71.4 kB
  • 12,288 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026647_wikidataid_q6026647 (
  "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/Q6026650 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026650_wikidataid_q6026650
  • 82.4 kB
  • 13,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026650_wikidataid_q6026650 (
  "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/Q6026653 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026653_wikidataid_q6026653
  • 76.94 kB
  • 13,341 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026653_wikidataid_q6026653 (
  "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/Q6026657 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026657_wikidataid_q6026657
  • 91.18 kB
  • 14,711 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026657_wikidataid_q6026657 (
  "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/Q6026661 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026661_wikidataid_q6026661
  • 94.9 kB
  • 15,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026661_wikidataid_q6026661 (
  "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/Q6026669 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026669_wikidataid_q6026669
  • 85.72 kB
  • 14,314 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026669_wikidataid_q6026669 (
  "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/Q6026672 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026672_wikidataid_q6026672
  • 87.61 kB
  • 14,676 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026672_wikidataid_q6026672 (
  "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/Q6026677 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026677_wikidataid_q6026677
  • 94.07 kB
  • 15,218 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026677_wikidataid_q6026677 (
  "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/Q6026680 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026680_wikidataid_q6026680
  • 93.64 kB
  • 15,463 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026680_wikidataid_q6026680 (
  "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/Q6026683 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026683_wikidataid_q6026683
  • 94.63 kB
  • 15,091 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026683_wikidataid_q6026683 (
  "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/Q6026686 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026686_wikidataid_q6026686
  • 93.97 kB
  • 15,631 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026686_wikidataid_q6026686 (
  "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/Q6026691 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026691_wikidataid_q6026691
  • 94.56 kB
  • 15,633 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026691_wikidataid_q6026691 (
  "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/Q6026697 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026697_wikidataid_q6026697
  • 76.41 kB
  • 13,341 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026697_wikidataid_q6026697 (
  "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/Q6026700 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026700_wikidataid_q6026700
  • 79.57 kB
  • 13,461 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026700_wikidataid_q6026700 (
  "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/Q6026703 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026703_wikidataid_q6026703
  • 63.46 kB
  • 11,501 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026703_wikidataid_q6026703 (
  "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/Q6026711 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026711_wikidataid_q6026711
  • 94.76 kB
  • 15,091 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026711_wikidataid_q6026711 (
  "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/Q6026713 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026713_wikidataid_q6026713
  • 90.2 kB
  • 14,833 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026713_wikidataid_q6026713 (
  "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/Q6026715 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6026715_wikidataid_q6026715
  • 80.38 kB
  • 13,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6026715_wikidataid_q6026715 (
  "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.