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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12394381_wikidataid_q12394381
  • 52.51 kB
  • 6,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12394381_wikidataid_q12394381 (
  "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/Q12394406 - Time Series For Statistical Variables

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

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

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

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

@datacommons.cities.wikidataid_q12394457_wikidataid_q12394457
  • 57.55 kB
  • 7,545 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12394457_wikidataid_q12394457 (
  "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.