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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12399860_wikidataid_q12399860
  • 59.68 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12399860_wikidataid_q12399860 (
  "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.