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

@datacommons.cities.wikidataid_q82001853_wikidataid_q82001853
  • 76.24 kB
  • 10,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q82001853_wikidataid_q82001853 (
  "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/Q8202647 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8202647_wikidataid_q8202647
  • 34.71 kB
  • 3,872 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8202647_wikidataid_q8202647 (
  "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/Q8203147 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q8204489_wikidataid_q8204489
  • 54.49 kB
  • 6,879 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8204489_wikidataid_q8204489 (
  "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/Q8204696 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q8204947_wikidataid_q8204947
  • 50.56 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8204947_wikidataid_q8204947 (
  "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/Q8205214 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8205214_wikidataid_q8205214
  • 56.55 kB
  • 7,236 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8205214_wikidataid_q8205214 (
  "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/Q8210844 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q8210898_wikidataid_q8210898
  • 50.22 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8210898_wikidataid_q8210898 (
  "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/Q8238647 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q8246314_wikidataid_q8246314
  • 16.07 kB
  • 931 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8246314_wikidataid_q8246314 (
  "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/Q8246325 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8246325_wikidataid_q8246325
  • 16.07 kB
  • 931 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8246325_wikidataid_q8246325 (
  "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/Q8246604 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q8247322_wikidataid_q8247322
  • 62.34 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8247322_wikidataid_q8247322 (
  "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/Q8254535 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q8342940_wikidataid_q8342940
  • 16.26 kB
  • 931 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8342940_wikidataid_q8342940 (
  "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/Q8343229 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q8343229_wikidataid_q8343229
  • 41.61 kB
  • 4,721 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q8343229_wikidataid_q8343229 (
  "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.