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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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