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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20542100_wikidataid_q20542100
  • 55.06 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20542100_wikidataid_q20542100 (
  "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/Q20542121 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q20542220_wikidataid_q20542220
  • 47.62 kB
  • 5,064 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20542220_wikidataid_q20542220 (
  "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/Q20542254 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q20542382_wikidataid_q20542382
  • 46.64 kB
  • 5,456 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20542382_wikidataid_q20542382 (
  "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/Q20542388 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q20542416_wikidataid_q20542416
  • 52.24 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20542416_wikidataid_q20542416 (
  "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/Q20542523 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20542523_wikidataid_q20542523
  • 58.16 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20542523_wikidataid_q20542523 (
  "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.