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

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

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

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

@datacommons.cities.wikidataid_q20992584_wikidataid_q20992584
  • 52.66 kB
  • 6,730 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20992584_wikidataid_q20992584 (
  "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/Q20992585 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q20992616_wikidataid_q20992616
  • 50.59 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20992616_wikidataid_q20992616 (
  "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/Q20992622 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q21013878_wikidataid_q21013878
  • 55.16 kB
  • 7,661 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21013878_wikidataid_q21013878 (
  "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/Q2103712 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q21075306_wikidataid_q21075306
  • 25.05 kB
  • 2,520 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21075306_wikidataid_q21075306 (
  "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/Q21084378 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q21084378_wikidataid_q21084378
  • 37.97 kB
  • 4,077 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q21084378_wikidataid_q21084378 (
  "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/Q2112089 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2112089_wikidataid_q2112089
  • 63.53 kB
  • 8,382 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2112089_wikidataid_q2112089 (
  "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/Q2122605 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2122605_wikidataid_q2122605
  • 47.98 kB
  • 5,902 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2122605_wikidataid_q2122605 (
  "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/Q2131577 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2143006_wikidataid_q2143006
  • 45.15 kB
  • 5,297 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2143006_wikidataid_q2143006 (
  "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/Q2143588 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2143588_wikidataid_q2143588
  • 48.02 kB
  • 5,937 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2143588_wikidataid_q2143588 (
  "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/Q2146779 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2146779_wikidataid_q2146779
  • 63.74 kB
  • 8,340 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2146779_wikidataid_q2146779 (
  "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/Q2148503 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q2155042_wikidataid_q2155042
  • 53.56 kB
  • 6,037 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2155042_wikidataid_q2155042 (
  "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/Q2155523 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2155523_wikidataid_q2155523
  • 71.94 kB
  • 10,386 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2155523_wikidataid_q2155523 (
  "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.