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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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