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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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