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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20546704_wikidataid_q20546704
  • 21.32 kB
  • 2,214 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546704_wikidataid_q20546704 (
  "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/Q20546729 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q20546935_wikidataid_q20546935
  • 53.67 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20546935_wikidataid_q20546935 (
  "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.