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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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