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

@datacommons.cities.wikidataid_q12388066_wikidataid_q12388066
  • 57.42 kB
  • 7,124 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388066_wikidataid_q12388066 (
  "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/Q12388125 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q12388141_wikidataid_q12388141
  • 51.65 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388141_wikidataid_q12388141 (
  "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/Q12388144 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q12388228_wikidataid_q12388228
  • 54.93 kB
  • 7,021 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388228_wikidataid_q12388228 (
  "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/Q12388232 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12388314_wikidataid_q12388314
  • 43.51 kB
  • 5,224 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12388314_wikidataid_q12388314 (
  "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/Q12388337 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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