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

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

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

@datacommons.cities.wikidataid_q20550468_wikidataid_q20550468
  • 54.52 kB
  • 7,021 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20550468_wikidataid_q20550468 (
  "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/Q20550472 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20550472_wikidataid_q20550472
  • 54.69 kB
  • 7,021 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20550472_wikidataid_q20550472 (
  "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/Q20550621 - Time Series For Statistical Variables

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20588985_wikidataid_q20588985
  • 11.29 kB
  • 158 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20588985_wikidataid_q20588985 (
  "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/Q2060484 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2060484_wikidataid_q2060484
  • 75.67 kB
  • 10,685 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2060484_wikidataid_q2060484 (
  "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/Q20614654 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q20620068_wikidataid_q20620068
  • 48.97 kB
  • 5,157 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20620068_wikidataid_q20620068 (
  "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/Q20620795 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20620795_wikidataid_q20620795
  • 34.87 kB
  • 4,045 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20620795_wikidataid_q20620795 (
  "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/Q20621146 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20621146_wikidataid_q20621146
  • 57.85 kB
  • 7,325 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20621146_wikidataid_q20621146 (
  "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/Q2083620 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2083620_wikidataid_q2083620
  • 47.47 kB
  • 5,891 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2083620_wikidataid_q2083620 (
  "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/Q2084041 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2084041_wikidataid_q2084041
  • 64.59 kB
  • 8,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2084041_wikidataid_q2084041 (
  "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/Q2091300 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2091300_wikidataid_q2091300
  • 45.29 kB
  • 5,557 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2091300_wikidataid_q2091300 (
  "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/Q2096644 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2096644_wikidataid_q2096644
  • 70.2 kB
  • 10,138 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2096644_wikidataid_q2096644 (
  "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/Q2099044 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2099044_wikidataid_q2099044
  • 80.22 kB
  • 10,399 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2099044_wikidataid_q2099044 (
  "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/Q20992535 - Time Series For Statistical Variables

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