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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12393564_wikidataid_q12393564
  • 58.31 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12393564_wikidataid_q12393564 (
  "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/Q12393572 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q12393672_wikidataid_q12393672
  • 54.26 kB
  • 7,002 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12393672_wikidataid_q12393672 (
  "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/Q12393675 - Time Series For Statistical Variables

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12393873_wikidataid_q12393873
  • 59 kB
  • 7,903 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12393873_wikidataid_q12393873 (
  "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.