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

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

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

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

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

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

@datacommons.cities.wikidataid_q61379233_wikidataid_q61379233
  • 44.44 kB
  • 5,157 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379233_wikidataid_q61379233 (
  "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/Q61379272 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q61379272_wikidataid_q61379272
  • 42.48 kB
  • 5,093 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379272_wikidataid_q61379272 (
  "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/Q61379337 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q61379337_wikidataid_q61379337
  • 42.63 kB
  • 5,093 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379337_wikidataid_q61379337 (
  "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/Q61379342 - Time Series For Statistical Variables

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q61379544_wikidataid_q61379544
  • 42.78 kB
  • 5,093 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379544_wikidataid_q61379544 (
  "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/Q61379602 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q6151337_wikidataid_q6151337
  • 9.58 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6151337_wikidataid_q6151337 (
  "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
);

Share link

Anyone who has the link will be able to view this.