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

@datacommons.cities.wikidataid_q12401377_wikidataid_q12401377
  • 52.97 kB
  • 6,503 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401377_wikidataid_q12401377 (
  "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/Q12401381 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12401630_wikidataid_q12401630
  • 50.64 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401630_wikidataid_q12401630 (
  "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/Q12401657 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12401658_wikidataid_q12401658
  • 51.65 kB
  • 5,997 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401658_wikidataid_q12401658 (
  "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/Q12401663 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12401663_wikidataid_q12401663
  • 48.53 kB
  • 5,997 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401663_wikidataid_q12401663 (
  "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/Q12401670 - Time Series For Statistical Variables

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

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

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

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

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

@datacommons.cities.wikidataid_q12401692_wikidataid_q12401692
  • 56.78 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12401692_wikidataid_q12401692 (
  "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.