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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20550049_wikidataid_q20550049
  • 53.79 kB
  • 7,002 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20550049_wikidataid_q20550049 (
  "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/Q20550122 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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