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

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

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

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

@datacommons.cities.wikidataid_q3552462_wikidataid_q3552462
  • 61.43 kB
  • 8,324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3552462_wikidataid_q3552462 (
  "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/Q3552820 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q3561409_wikidataid_q3561409
  • 50.33 kB
  • 6,295 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3561409_wikidataid_q3561409 (
  "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/Q3561413 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3561413_wikidataid_q3561413
  • 48.85 kB
  • 5,801 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3561413_wikidataid_q3561413 (
  "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/Q35640709 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q35640709_wikidataid_q35640709
  • 51.52 kB
  • 5,934 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q35640709_wikidataid_q35640709 (
  "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/Q3566248 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3566248_wikidataid_q3566248
  • 32.72 kB
  • 3,752 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3566248_wikidataid_q3566248 (
  "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/Q3568012 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3568012_wikidataid_q3568012
  • 54.63 kB
  • 6,564 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3568012_wikidataid_q3568012 (
  "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/Q3572966 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3572966_wikidataid_q3572966
  • 35.08 kB
  • 3,910 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3572966_wikidataid_q3572966 (
  "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/Q3573284 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3573284_wikidataid_q3573284
  • 51.29 kB
  • 6,457 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3573284_wikidataid_q3573284 (
  "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/Q3573965 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3573965_wikidataid_q3573965
  • 34.75 kB
  • 3,752 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3573965_wikidataid_q3573965 (
  "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/Q3574882 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3574882_wikidataid_q3574882
  • 55.98 kB
  • 7,622 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3574882_wikidataid_q3574882 (
  "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/Q3575222 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3575532_wikidataid_q3575532
  • 52.94 kB
  • 6,717 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3575532_wikidataid_q3575532 (
  "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/Q3620580 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3620580_wikidataid_q3620580
  • 49.82 kB
  • 6,292 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3620580_wikidataid_q3620580 (
  "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/Q3703226 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3703226_wikidataid_q3703226
  • 45.85 kB
  • 4,718 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3703226_wikidataid_q3703226 (
  "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/Q37175546 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q37175546_wikidataid_q37175546
  • 78.85 kB
  • 11,228 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q37175546_wikidataid_q37175546 (
  "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/Q3719360 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3719360_wikidataid_q3719360
  • 30.03 kB
  • 2,850 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3719360_wikidataid_q3719360 (
  "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/Q3732722 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3732722_wikidataid_q3732722
  • 43.56 kB
  • 5,455 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3732722_wikidataid_q3732722 (
  "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/Q37781104 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q37819251_wikidataid_q37819251
  • 91.95 kB
  • 12,107 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q37819251_wikidataid_q37819251 (
  "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/Q3802075 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3802075_wikidataid_q3802075
  • 59.31 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3802075_wikidataid_q3802075 (
  "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.