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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12397461_wikidataid_q12397461
  • 61.41 kB
  • 7,935 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12397461_wikidataid_q12397461 (
  "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/Q12397526 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12397526_wikidataid_q12397526
  • 51.98 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12397526_wikidataid_q12397526 (
  "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/Q12397527 - Time Series For Statistical Variables

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

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

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

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

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

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