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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20548524_wikidataid_q20548524
  • 21.34 kB
  • 2,214 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20548524_wikidataid_q20548524 (
  "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/Q20548526 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q20548583_wikidataid_q20548583
  • 57.83 kB
  • 6,968 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20548583_wikidataid_q20548583 (
  "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/Q20548597 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q20548657_wikidataid_q20548657
  • 58.79 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20548657_wikidataid_q20548657 (
  "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.