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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q22002236_wikidataid_q22002236
  • 38.21 kB
  • 4,324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q22002236_wikidataid_q22002236 (
  "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/Q22002481 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q22002481_wikidataid_q22002481
  • 9.89 kB
  • 37 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q22002481_wikidataid_q22002481 (
  "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/Q2202279 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2202279_wikidataid_q2202279
  • 49.02 kB
  • 6,079 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2202279_wikidataid_q2202279 (
  "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/Q2203010 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2203010_wikidataid_q2203010
  • 54.64 kB
  • 7,281 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2203010_wikidataid_q2203010 (
  "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/Q22035307 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q22035307_wikidataid_q22035307
  • 29.1 kB
  • 2,795 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q22035307_wikidataid_q22035307 (
  "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/Q2213716 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2213716_wikidataid_q2213716
  • 66.04 kB
  • 9,684 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2213716_wikidataid_q2213716 (
  "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/Q2215484 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2215484_wikidataid_q2215484
  • 49.53 kB
  • 6,228 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2215484_wikidataid_q2215484 (
  "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/Q2219906 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2219906_wikidataid_q2219906
  • 48.94 kB
  • 6,069 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2219906_wikidataid_q2219906 (
  "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/Q2227101 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2227101_wikidataid_q2227101
  • 53.41 kB
  • 6,725 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2227101_wikidataid_q2227101 (
  "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/Q2239555 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2239555_wikidataid_q2239555
  • 70.65 kB
  • 8,454 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2239555_wikidataid_q2239555 (
  "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/Q2242887 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2242887_wikidataid_q2242887
  • 69.98 kB
  • 8,361 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2242887_wikidataid_q2242887 (
  "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/Q2243862 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2243862_wikidataid_q2243862
  • 47.41 kB
  • 5,894 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2243862_wikidataid_q2243862 (
  "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/Q2265943 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2265943_wikidataid_q2265943
  • 75.3 kB
  • 10,682 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2265943_wikidataid_q2265943 (
  "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/Q2278198 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2278198_wikidataid_q2278198
  • 72.19 kB
  • 10,377 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2278198_wikidataid_q2278198 (
  "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/Q2279169 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2279169_wikidataid_q2279169
  • 75.14 kB
  • 9,007 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2279169_wikidataid_q2279169 (
  "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/Q22893617 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q22928906_wikidataid_q22928906
  • 47 kB
  • 6,113 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q22928906_wikidataid_q22928906 (
  "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/Q2294648 - Time Series For Statistical Variables

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