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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12400728_wikidataid_q12400728
  • 60.45 kB
  • 8,054 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12400728_wikidataid_q12400728 (
  "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/Q12400734 - Time Series For Statistical Variables

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12400950_wikidataid_q12400950
  • 53.94 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12400950_wikidataid_q12400950 (
  "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.