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

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

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

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

@datacommons.cities.wikidataid_q3304026_wikidataid_q3304026
  • 15.13 kB
  • 927 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3304026_wikidataid_q3304026 (
  "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/Q3306261 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3307756_wikidataid_q3307756
  • 50.7 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3307756_wikidataid_q3307756 (
  "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/Q3315862 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q3326597_wikidataid_q3326597
  • 48 kB
  • 5,914 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3326597_wikidataid_q3326597 (
  "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/Q3328835 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3328835_wikidataid_q3328835
  • 62.1 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3328835_wikidataid_q3328835 (
  "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/Q3331656 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3336040_wikidataid_q3336040
  • 66.31 kB
  • 8,418 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3336040_wikidataid_q3336040 (
  "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/Q3337496 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3340738_wikidataid_q3340738
  • 65.26 kB
  • 8,398 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3340738_wikidataid_q3340738 (
  "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/Q3347796 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3347800_wikidataid_q3347800
  • 55.75 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3347800_wikidataid_q3347800 (
  "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/Q3349151 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3349151_wikidataid_q3349151
  • 62.07 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3349151_wikidataid_q3349151 (
  "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/Q3349926 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3349926_wikidataid_q3349926
  • 62.39 kB
  • 8,418 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3349926_wikidataid_q3349926 (
  "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/Q3356601 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3356606_wikidataid_q3356606
  • 52.83 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3356606_wikidataid_q3356606 (
  "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/Q3356887 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3356891_wikidataid_q3356891
  • 54.69 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3356891_wikidataid_q3356891 (
  "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/Q3358063 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3358063_wikidataid_q3358063
  • 43.11 kB
  • 5,359 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3358063_wikidataid_q3358063 (
  "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/Q3363063 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3363063_wikidataid_q3363063
  • 52.36 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3363063_wikidataid_q3363063 (
  "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.