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

@datacommons.cities.wikidataid_q22961958_wikidataid_q22961958
  • 20.5 kB
  • 1,920 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q22961958_wikidataid_q22961958 (
  "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/Q23000330 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23000330_wikidataid_q23000330
  • 51.43 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23000330_wikidataid_q23000330 (
  "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/Q2300758 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2300758_wikidataid_q2300758
  • 70.45 kB
  • 10,147 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2300758_wikidataid_q2300758 (
  "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/Q2306922 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2306922_wikidataid_q2306922
  • 72.51 kB
  • 9,547 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2306922_wikidataid_q2306922 (
  "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/Q2308666 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2308666_wikidataid_q2308666
  • 56.28 kB
  • 6,845 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2308666_wikidataid_q2308666 (
  "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/Q2308754 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2308754_wikidataid_q2308754
  • 82.32 kB
  • 11,673 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2308754_wikidataid_q2308754 (
  "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/Q2316604 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2316604_wikidataid_q2316604
  • 65.89 kB
  • 9,687 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2316604_wikidataid_q2316604 (
  "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/Q2318361 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2318361_wikidataid_q2318361
  • 49.99 kB
  • 6,225 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2318361_wikidataid_q2318361 (
  "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/Q2349613 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2349613_wikidataid_q2349613
  • 17.39 kB
  • 1,029 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2349613_wikidataid_q2349613 (
  "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/Q23502438 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23502438_wikidataid_q23502438
  • 74.27 kB
  • 9,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23502438_wikidataid_q23502438 (
  "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/Q2355534 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2355534_wikidataid_q2355534
  • 52.27 kB
  • 5,796 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2355534_wikidataid_q2355534 (
  "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/Q2358474 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2358474_wikidataid_q2358474
  • 72.25 kB
  • 10,414 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2358474_wikidataid_q2358474 (
  "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/Q23695798 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23695798_wikidataid_q23695798
  • 51.83 kB
  • 6,497 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23695798_wikidataid_q23695798 (
  "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/Q2382006 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2382006_wikidataid_q2382006
  • 49.24 kB
  • 5,835 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2382006_wikidataid_q2382006 (
  "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/Q2383773 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2388411_wikidataid_q2388411
  • 69.8 kB
  • 8,416 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2388411_wikidataid_q2388411 (
  "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/Q2389276 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2392730_wikidataid_q2392730
  • 70.21 kB
  • 8,380 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2392730_wikidataid_q2392730 (
  "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/Q23929256 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23929256_wikidataid_q23929256
  • 10.37 kB
  • 129 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23929256_wikidataid_q23929256 (
  "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/Q23986352 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23986352_wikidataid_q23986352
  • 56.85 kB
  • 7,915 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23986352_wikidataid_q23986352 (
  "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/Q23992092 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23992092_wikidataid_q23992092
  • 53.82 kB
  • 6,974 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23992092_wikidataid_q23992092 (
  "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/Q23992324 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23992324_wikidataid_q23992324
  • 64.11 kB
  • 8,678 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23992324_wikidataid_q23992324 (
  "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/Q23992365 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23992365_wikidataid_q23992365
  • 62.83 kB
  • 8,373 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23992365_wikidataid_q23992365 (
  "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/Q23992605 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q23992605_wikidataid_q23992605
  • 56.13 kB
  • 7,381 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q23992605_wikidataid_q23992605 (
  "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/Q2400232 - Time Series For Statistical Variables

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