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

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

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

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

@datacommons.cities.wikidataid_q12401129_wikidataid_q12401129
  • 51.15 kB
  • 6,223 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401129_wikidataid_q12401129 (
  "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/Q12401134 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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