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

@datacommons.cities.wikidataid_q671507_wikidataid_q671507
  • 47.63 kB
  • 5,781 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q671507_wikidataid_q671507 (
  "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/Q67365564 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q67365564_wikidataid_q67365564
  • 9.78 kB
  • 12 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q67365564_wikidataid_q67365564 (
  "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/Q68126661 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q684375_wikidataid_q684375
  • 79.95 kB
  • 10,386 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q684375_wikidataid_q684375 (
  "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/Q68560046 - Time Series For Statistical Variables

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

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

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

@datacommons.cities.wikidataid_q691662_wikidataid_q691662
  • 72.31 kB
  • 9,679 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q691662_wikidataid_q691662 (
  "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/Q72011804 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q72011804_wikidataid_q72011804
  • 55.49 kB
  • 7,318 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q72011804_wikidataid_q72011804 (
  "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/Q733131 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q733131_wikidataid_q733131
  • 63.81 kB
  • 8,361 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q733131_wikidataid_q733131 (
  "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/Q73893491 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q73893491_wikidataid_q73893491
  • 45.07 kB
  • 5,299 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q73893491_wikidataid_q73893491 (
  "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/Q73903684 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q73903684_wikidataid_q73903684
  • 46.48 kB
  • 5,965 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q73903684_wikidataid_q73903684 (
  "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/Q73904092 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q73904092_wikidataid_q73904092
  • 46.12 kB
  • 5,965 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q73904092_wikidataid_q73904092 (
  "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/Q740694 - Time Series For Statistical Variables

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

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

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

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

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

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

@datacommons.cities.wikidataid_q7637937_wikidataid_q7637937
  • 50.41 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q7637937_wikidataid_q7637937 (
  "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/Q7643708 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q772425_wikidataid_q772425
  • 74.26 kB
  • 10,502 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q772425_wikidataid_q772425 (
  "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/Q77726863 - Time Series For Statistical Variables

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