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

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

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

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

@datacommons.cities.wikidataid_q20547036_wikidataid_q20547036
  • 53.78 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547036_wikidataid_q20547036 (
  "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/Q20547042 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547042_wikidataid_q20547042
  • 58.65 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547042_wikidataid_q20547042 (
  "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/Q20547069 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547069_wikidataid_q20547069
  • 67.64 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547069_wikidataid_q20547069 (
  "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/Q20547079 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547079_wikidataid_q20547079
  • 59.89 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547079_wikidataid_q20547079 (
  "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/Q20547104 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547104_wikidataid_q20547104
  • 59.27 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547104_wikidataid_q20547104 (
  "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/Q20547174 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20547179_wikidataid_q20547179
  • 64.08 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547179_wikidataid_q20547179 (
  "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/Q20547200 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547200_wikidataid_q20547200
  • 52.23 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547200_wikidataid_q20547200 (
  "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/Q20547210 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20547214_wikidataid_q20547214
  • 59.24 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547214_wikidataid_q20547214 (
  "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/Q20547224 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547224_wikidataid_q20547224
  • 52.49 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547224_wikidataid_q20547224 (
  "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/Q20547233 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547233_wikidataid_q20547233
  • 59.37 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547233_wikidataid_q20547233 (
  "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/Q20547234 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20547234_wikidataid_q20547234
  • 54.61 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547234_wikidataid_q20547234 (
  "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/Q20547283 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20547307_wikidataid_q20547307
  • 66.63 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547307_wikidataid_q20547307 (
  "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/Q20547330 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q20547338_wikidataid_q20547338
  • 58.9 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20547338_wikidataid_q20547338 (
  "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/Q20547355 - Time Series For Statistical Variables

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

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

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

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