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

@datacommons.cities.wikidataid_q5406025_wikidataid_q5406025
  • 94.91 kB
  • 15,086 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5406025_wikidataid_q5406025 (
  "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/Q5408619 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5408619_wikidataid_q5408619
  • 93.15 kB
  • 15,632 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5408619_wikidataid_q5408619 (
  "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/Q544536 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q54809384_wikidataid_q54809384
  • 9.56 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q54809384_wikidataid_q54809384 (
  "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/Q5489414 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5489414_wikidataid_q5489414
  • 93.05 kB
  • 15,634 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5489414_wikidataid_q5489414 (
  "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/Q550123 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q55228938_wikidataid_q55228938
  • 9.56 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q55228938_wikidataid_q55228938 (
  "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/Q55400422 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q55400422_wikidataid_q55400422
  • 58.02 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q55400422_wikidataid_q55400422 (
  "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/Q55400553 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q55400553_wikidataid_q55400553
  • 47.05 kB
  • 5,702 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q55400553_wikidataid_q55400553 (
  "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/Q5552259 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5552259_wikidataid_q5552259
  • 88.62 kB
  • 14,252 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5552259_wikidataid_q5552259 (
  "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/Q5557357 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5557357_wikidataid_q5557357
  • 49.54 kB
  • 6,496 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5557357_wikidataid_q5557357 (
  "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/Q55590000 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q55590000_wikidataid_q55590000
  • 9.58 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q55590000_wikidataid_q55590000 (
  "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/Q55652375 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q55712705_wikidataid_q55712705
  • 9.53 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q55712705_wikidataid_q55712705 (
  "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/Q55714171 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q55714171_wikidataid_q55714171
  • 9.61 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q55714171_wikidataid_q55714171 (
  "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/Q5573700 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5573700_wikidataid_q5573700
  • 52.8 kB
  • 6,941 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5573700_wikidataid_q5573700 (
  "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/Q5599705 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5599705_wikidataid_q5599705
  • 24.87 kB
  • 3,704 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5599705_wikidataid_q5599705 (
  "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/Q5604330 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5604330_wikidataid_q5604330
  • 29.05 kB
  • 3,098 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5604330_wikidataid_q5604330 (
  "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/Q56293133 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56293133_wikidataid_q56293133
  • 49.27 kB
  • 6,273 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56293133_wikidataid_q56293133 (
  "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/Q56294086 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56294086_wikidataid_q56294086
  • 33.15 kB
  • 3,715 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56294086_wikidataid_q56294086 (
  "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/Q56301283 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56301283_wikidataid_q56301283
  • 51.38 kB
  • 6,552 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56301283_wikidataid_q56301283 (
  "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/Q56301285 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56301285_wikidataid_q56301285
  • 51.19 kB
  • 6,552 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56301285_wikidataid_q56301285 (
  "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/Q56353307 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56353307_wikidataid_q56353307
  • 9.53 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56353307_wikidataid_q56353307 (
  "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/Q5637390 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q5637390_wikidataid_q5637390
  • 19.35 kB
  • 1,362 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q5637390_wikidataid_q5637390 (
  "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/Q56401684 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q56401684_wikidataid_q56401684
  • 42.34 kB
  • 4,773 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q56401684_wikidataid_q56401684 (
  "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.