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

@datacommons.cities.wikidataid_q2158597_wikidataid_q2158597
  • 64.12 kB
  • 8,473 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2158597_wikidataid_q2158597 (
  "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/Q2159987 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2159987_wikidataid_q2159987
  • 67.71 kB
  • 8,995 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2159987_wikidataid_q2159987 (
  "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/Q21609144 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21609144_wikidataid_q21609144
  • 25.59 kB
  • 2,364 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21609144_wikidataid_q21609144 (
  "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/Q2163126 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2163126_wikidataid_q2163126
  • 67.74 kB
  • 9,079 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2163126_wikidataid_q2163126 (
  "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/Q21643598 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21643598_wikidataid_q21643598
  • 24.49 kB
  • 2,364 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21643598_wikidataid_q21643598 (
  "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/Q21643727 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21643727_wikidataid_q21643727
  • 24.47 kB
  • 2,364 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21643727_wikidataid_q21643727 (
  "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/Q21712896 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21712896_wikidataid_q21712896
  • 11.54 kB
  • 330 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21712896_wikidataid_q21712896 (
  "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/Q2172272 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2172272_wikidataid_q2172272
  • 82.71 kB
  • 11,727 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2172272_wikidataid_q2172272 (
  "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/Q21787833 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21787833_wikidataid_q21787833
  • 10.35 kB
  • 102 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21787833_wikidataid_q21787833 (
  "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/Q21787866 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21787866_wikidataid_q21787866
  • 40.53 kB
  • 4,912 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21787866_wikidataid_q21787866 (
  "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/Q21788741 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21788741_wikidataid_q21788741
  • 10.53 kB
  • 130 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21788741_wikidataid_q21788741 (
  "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/Q21790695 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21790695_wikidataid_q21790695
  • 53.6 kB
  • 6,733 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21790695_wikidataid_q21790695 (
  "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/Q21790698 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21790698_wikidataid_q21790698
  • 49.21 kB
  • 6,597 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21790698_wikidataid_q21790698 (
  "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/Q2183245 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2183245_wikidataid_q2183245
  • 49.55 kB
  • 6,226 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2183245_wikidataid_q2183245 (
  "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/Q2183787 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2183787_wikidataid_q2183787
  • 49.64 kB
  • 6,038 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2183787_wikidataid_q2183787 (
  "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/Q2189763 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2189812_wikidataid_q2189812
  • 63.92 kB
  • 8,349 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2189812_wikidataid_q2189812 (
  "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/Q2191234 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2191234_wikidataid_q2191234
  • 70.35 kB
  • 10,138 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2191234_wikidataid_q2191234 (
  "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/Q2194057 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2194057_wikidataid_q2194057
  • 49.98 kB
  • 5,743 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2194057_wikidataid_q2194057 (
  "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/Q2197393 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2197393_wikidataid_q2197393
  • 80.17 kB
  • 11,040 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2197393_wikidataid_q2197393 (
  "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/Q21993698 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q22002207_wikidataid_q22002207
  • 9.41 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q22002207_wikidataid_q22002207 (
  "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
);

Share link

Anyone who has the link will be able to view this.