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

@datacommons.cities.wikidataid_q86919327_wikidataid_q86919327
  • 47.42 kB
  • 5,703 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q86919327_wikidataid_q86919327 (
  "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/Q86987362 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q86987362_wikidataid_q86987362
  • 9.63 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q86987362_wikidataid_q86987362 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q86987372 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q86987372_wikidataid_q86987372
  • 9.63 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q86987372_wikidataid_q86987372 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q87057532 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87057532_wikidataid_q87057532
  • 46.36 kB
  • 5,978 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87057532_wikidataid_q87057532 (
  "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/Q87063496 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87063496_wikidataid_q87063496
  • 42.59 kB
  • 5,155 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87063496_wikidataid_q87063496 (
  "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/Q87118539 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87118539_wikidataid_q87118539
  • 56.65 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87118539_wikidataid_q87118539 (
  "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/Q87186173 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87186173_wikidataid_q87186173
  • 9.57 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87186173_wikidataid_q87186173 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q87186714 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87186714_wikidataid_q87186714
  • 9.57 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87186714_wikidataid_q87186714 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q87186715 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87186715_wikidataid_q87186715
  • 9.57 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87186715_wikidataid_q87186715 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q87186718 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87186718_wikidataid_q87186718
  • 28.52 kB
  • 3,750 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87186718_wikidataid_q87186718 (
  "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/Q87186722 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87186722_wikidataid_q87186722
  • 28.28 kB
  • 3,750 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87186722_wikidataid_q87186722 (
  "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/Q87186995 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87186995_wikidataid_q87186995
  • 9.57 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87186995_wikidataid_q87186995 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q87249223 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87249223_wikidataid_q87249223
  • 48.1 kB
  • 6,495 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87249223_wikidataid_q87249223 (
  "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/Q87249226 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87249226_wikidataid_q87249226
  • 48.31 kB
  • 6,495 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87249226_wikidataid_q87249226 (
  "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/Q87443977 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87443977_wikidataid_q87443977
  • 9.59 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87443977_wikidataid_q87443977 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q8771530 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8771530_wikidataid_q8771530
  • 61.19 kB
  • 7,371 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8771530_wikidataid_q8771530 (
  "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/Q87716510 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q8774261_wikidataid_q8774261
  • 50.9 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8774261_wikidataid_q8774261 (
  "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/Q8775081 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8775081_wikidataid_q8775081
  • 51.5 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8775081_wikidataid_q8775081 (
  "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/Q8775223 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8775223_wikidataid_q8775223
  • 50.5 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8775223_wikidataid_q8775223 (
  "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/Q8775463 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q8776896_wikidataid_q8776896
  • 62.11 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8776896_wikidataid_q8776896 (
  "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/Q8778483 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8778483_wikidataid_q8778483
  • 50.34 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8778483_wikidataid_q8778483 (
  "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/Q87823502 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87823502_wikidataid_q87823502
  • 56.64 kB
  • 7,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87823502_wikidataid_q87823502 (
  "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/Q87842497 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q87842497_wikidataid_q87842497
  • 77.15 kB
  • 10,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q87842497_wikidataid_q87842497 (
  "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.