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

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

@datacommons.cities.wikidataid_q9064300_wikidataid_q9064300
  • 54.3 kB
  • 6,895 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9064300_wikidataid_q9064300 (
  "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/Q9065598 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9065598_wikidataid_q9065598
  • 26.76 kB
  • 2,909 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9065598_wikidataid_q9065598 (
  "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/Q9072585 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9072585_wikidataid_q9072585
  • 52.93 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9072585_wikidataid_q9072585 (
  "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/Q9072882 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9072882_wikidataid_q9072882
  • 51.84 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9072882_wikidataid_q9072882 (
  "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/Q9073536 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9073536_wikidataid_q9073536
  • 9.54 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9073536_wikidataid_q9073536 (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" BIGINT,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

WikidataId/Q9073983 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9073983_wikidataid_q9073983
  • 58.16 kB
  • 7,990 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9073983_wikidataid_q9073983 (
  "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/Q9074012 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9074012_wikidataid_q9074012
  • 54.83 kB
  • 6,741 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9074012_wikidataid_q9074012 (
  "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/Q9078643 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9078643_wikidataid_q9078643
  • 51.84 kB
  • 6,472 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9078643_wikidataid_q9078643 (
  "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/Q9081512 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9081512_wikidataid_q9081512
  • 50.77 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9081512_wikidataid_q9081512 (
  "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/Q9088797 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9088797_wikidataid_q9088797
  • 62.48 kB
  • 8,324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9088797_wikidataid_q9088797 (
  "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/Q9091330 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9091330_wikidataid_q9091330
  • 61.25 kB
  • 8,324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9091330_wikidataid_q9091330 (
  "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/Q9091367 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9091367_wikidataid_q9091367
  • 56.19 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9091367_wikidataid_q9091367 (
  "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/Q9091930 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9091930_wikidataid_q9091930
  • 56.19 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9091930_wikidataid_q9091930 (
  "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/Q9091993 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9091993_wikidataid_q9091993
  • 56.51 kB
  • 7,368 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9091993_wikidataid_q9091993 (
  "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/Q9092053 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9092053_wikidataid_q9092053
  • 50.64 kB
  • 6,356 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9092053_wikidataid_q9092053 (
  "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/Q9092926 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9092926_wikidataid_q9092926
  • 41.8 kB
  • 4,718 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9092926_wikidataid_q9092926 (
  "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/Q9094097 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9094097_wikidataid_q9094097
  • 50.54 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9094097_wikidataid_q9094097 (
  "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/Q9097746 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q9097746_wikidataid_q9097746
  • 56.23 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q9097746_wikidataid_q9097746 (
  "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/Q919130 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q919130_wikidataid_q919130
  • 81.58 kB
  • 11,526 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q919130_wikidataid_q919130 (
  "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/Q920154 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q920154_wikidataid_q920154
  • 46.19 kB
  • 5,664 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q920154_wikidataid_q920154 (
  "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/Q926945 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q937054_wikidataid_q937054
  • 49.07 kB
  • 6,229 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q937054_wikidataid_q937054 (
  "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/Q973696 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q973696_wikidataid_q973696
  • 52.14 kB
  • 6,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q973696_wikidataid_q973696 (
  "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/Q980904 - Time Series For Statistical Variables

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