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

@datacommons.cities.wikidataid_q12560957_wikidataid_q12560957
  • 105.51 kB
  • 14,940 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12560957_wikidataid_q12560957 (
  "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/Q12561266 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12561266_wikidataid_q12561266
  • 78.19 kB
  • 13,130 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12561266_wikidataid_q12561266 (
  "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/Q12562341 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562341_wikidataid_q12562341
  • 111.09 kB
  • 15,757 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562341_wikidataid_q12562341 (
  "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/Q12562436 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562436_wikidataid_q12562436
  • 94.07 kB
  • 14,831 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562436_wikidataid_q12562436 (
  "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/Q12562437 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562437_wikidataid_q12562437
  • 95.79 kB
  • 14,905 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562437_wikidataid_q12562437 (
  "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/Q12562440 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562440_wikidataid_q12562440
  • 94.64 kB
  • 14,831 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562440_wikidataid_q12562440 (
  "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/Q12562441 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562441_wikidataid_q12562441
  • 98.11 kB
  • 15,836 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562441_wikidataid_q12562441 (
  "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/Q12562442 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562442_wikidataid_q12562442
  • 97.53 kB
  • 14,683 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562442_wikidataid_q12562442 (
  "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/Q12562446 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562446_wikidataid_q12562446
  • 72.92 kB
  • 12,844 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562446_wikidataid_q12562446 (
  "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/Q12562448 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562448_wikidataid_q12562448
  • 90.71 kB
  • 14,383 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562448_wikidataid_q12562448 (
  "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/Q12562450 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562450_wikidataid_q12562450
  • 89.19 kB
  • 14,070 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562450_wikidataid_q12562450 (
  "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/Q12562451 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562451_wikidataid_q12562451
  • 87.72 kB
  • 14,426 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562451_wikidataid_q12562451 (
  "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/Q12562453 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562453_wikidataid_q12562453
  • 95.45 kB
  • 15,119 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562453_wikidataid_q12562453 (
  "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/Q12562455 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562455_wikidataid_q12562455
  • 94.16 kB
  • 14,749 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562455_wikidataid_q12562455 (
  "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/Q12562456 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562456_wikidataid_q12562456
  • 89.06 kB
  • 13,993 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562456_wikidataid_q12562456 (
  "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/Q12562458 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562458_wikidataid_q12562458
  • 91.47 kB
  • 14,257 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562458_wikidataid_q12562458 (
  "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/Q12562462 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562462_wikidataid_q12562462
  • 96.48 kB
  • 15,452 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562462_wikidataid_q12562462 (
  "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/Q12562463 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562463_wikidataid_q12562463
  • 87.9 kB
  • 14,068 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562463_wikidataid_q12562463 (
  "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/Q12562464 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562464_wikidataid_q12562464
  • 97.15 kB
  • 15,694 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562464_wikidataid_q12562464 (
  "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/Q12562465 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562465_wikidataid_q12562465
  • 95.64 kB
  • 15,333 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562465_wikidataid_q12562465 (
  "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/Q12562466 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12562467_wikidataid_q12562467
  • 96.68 kB
  • 15,099 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562467_wikidataid_q12562467 (
  "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/Q12562469 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562469_wikidataid_q12562469
  • 94.73 kB
  • 14,690 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562469_wikidataid_q12562469 (
  "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/Q12562470 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562470_wikidataid_q12562470
  • 91.92 kB
  • 14,295 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562470_wikidataid_q12562470 (
  "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/Q12562473 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562473_wikidataid_q12562473
  • 78.6 kB
  • 12,498 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562473_wikidataid_q12562473 (
  "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.