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

@datacommons.cities.wikidataid_q20546102_wikidataid_q20546102
  • 43.17 kB
  • 5,224 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546102_wikidataid_q20546102 (
  "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/Q20546103 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20546115_wikidataid_q20546115
  • 46.1 kB
  • 5,964 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546115_wikidataid_q20546115 (
  "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/Q20546129 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20546241_wikidataid_q20546241
  • 58.57 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546241_wikidataid_q20546241 (
  "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/Q20546271 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q20546302_wikidataid_q20546302
  • 60.69 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546302_wikidataid_q20546302 (
  "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/Q20546306 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20546434_wikidataid_q20546434
  • 21.45 kB
  • 2,214 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546434_wikidataid_q20546434 (
  "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/Q20546479 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20546479_wikidataid_q20546479
  • 53.85 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546479_wikidataid_q20546479 (
  "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.