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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12402185_wikidataid_q12402185
  • 57.22 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402185_wikidataid_q12402185 (
  "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/Q12402204 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12402206_wikidataid_q12402206
  • 58.35 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402206_wikidataid_q12402206 (
  "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/Q12402207 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q12402232_wikidataid_q12402232
  • 17.66 kB
  • 1,479 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12402232_wikidataid_q12402232 (
  "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/Q12402244 - Time Series For Statistical Variables

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

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