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

@datacommons.cities.wikidataid_q12562474_wikidataid_q12562474
  • 96.73 kB
  • 14,383 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562474_wikidataid_q12562474 (
  "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/Q12562476 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562476_wikidataid_q12562476
  • 93.69 kB
  • 14,134 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562476_wikidataid_q12562476 (
  "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/Q12562532 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562532_wikidataid_q12562532
  • 93.08 kB
  • 14,678 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562532_wikidataid_q12562532 (
  "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/Q12562598 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562598_wikidataid_q12562598
  • 76.84 kB
  • 12,686 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562598_wikidataid_q12562598 (
  "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/Q12562988 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12562988_wikidataid_q12562988
  • 97.22 kB
  • 15,006 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12562988_wikidataid_q12562988 (
  "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/Q12563046 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12563046_wikidataid_q12563046
  • 91.3 kB
  • 13,706 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12563046_wikidataid_q12563046 (
  "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/Q12563727 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12563727_wikidataid_q12563727
  • 77.58 kB
  • 12,852 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12563727_wikidataid_q12563727 (
  "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/Q12563728 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12563728_wikidataid_q12563728
  • 85.11 kB
  • 13,233 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12563728_wikidataid_q12563728 (
  "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/Q12563729 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12563729_wikidataid_q12563729
  • 95.45 kB
  • 15,099 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12563729_wikidataid_q12563729 (
  "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/Q12564949 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564949_wikidataid_q12564949
  • 97.92 kB
  • 15,691 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564949_wikidataid_q12564949 (
  "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/Q12564950 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564950_wikidataid_q12564950
  • 97.64 kB
  • 15,033 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564950_wikidataid_q12564950 (
  "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/Q12564951 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564951_wikidataid_q12564951
  • 98.78 kB
  • 15,033 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564951_wikidataid_q12564951 (
  "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/Q12564952 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564952_wikidataid_q12564952
  • 98.76 kB
  • 15,566 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564952_wikidataid_q12564952 (
  "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/Q12564954 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564954_wikidataid_q12564954
  • 99.94 kB
  • 16,133 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564954_wikidataid_q12564954 (
  "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/Q12564955 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564955_wikidataid_q12564955
  • 98.3 kB
  • 14,976 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564955_wikidataid_q12564955 (
  "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/Q12564956 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564956_wikidataid_q12564956
  • 94.42 kB
  • 15,136 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564956_wikidataid_q12564956 (
  "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/Q12564957 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564957_wikidataid_q12564957
  • 94.98 kB
  • 15,135 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564957_wikidataid_q12564957 (
  "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/Q12564958 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564958_wikidataid_q12564958
  • 100.3 kB
  • 16,006 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564958_wikidataid_q12564958 (
  "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/Q12564959 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564959_wikidataid_q12564959
  • 104.3 kB
  • 15,923 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564959_wikidataid_q12564959 (
  "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/Q12564961 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564961_wikidataid_q12564961
  • 102.27 kB
  • 16,177 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564961_wikidataid_q12564961 (
  "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/Q12564963 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564963_wikidataid_q12564963
  • 100.79 kB
  • 15,884 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564963_wikidataid_q12564963 (
  "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/Q12564964 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12564964_wikidataid_q12564964
  • 101.44 kB
  • 16,177 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12564964_wikidataid_q12564964 (
  "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/Q12566128 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12566128_wikidataid_q12566128
  • 65.24 kB
  • 12,238 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12566128_wikidataid_q12566128 (
  "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/Q12566375 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12566375_wikidataid_q12566375
  • 92.13 kB
  • 14,867 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12566375_wikidataid_q12566375 (
  "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/Q12566452 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12566452_wikidataid_q12566452
  • 96.9 kB
  • 15,340 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12566452_wikidataid_q12566452 (
  "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.