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

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

@datacommons.cities.wikidataid_q33772084_wikidataid_q33772084
  • 43.95 kB
  • 5,377 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q33772084_wikidataid_q33772084 (
  "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/Q3395553 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3395951_wikidataid_q3395951
  • 47.77 kB
  • 5,802 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3395951_wikidataid_q3395951 (
  "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/Q3399351 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3399351_wikidataid_q3399351
  • 54.63 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3399351_wikidataid_q3399351 (
  "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/Q3399366 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3399366_wikidataid_q3399366
  • 54.97 kB
  • 7,081 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3399366_wikidataid_q3399366 (
  "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/Q3399449 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3399449_wikidataid_q3399449
  • 17.28 kB
  • 1,028 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3399449_wikidataid_q3399449 (
  "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/Q34001254 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q34001254_wikidataid_q34001254
  • 45.31 kB
  • 5,276 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q34001254_wikidataid_q34001254 (
  "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/Q3401560 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q3413799_wikidataid_q3413799
  • 44.76 kB
  • 5,282 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3413799_wikidataid_q3413799 (
  "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/Q3416432 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3416432_wikidataid_q3416432
  • 69.52 kB
  • 10,157 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3416432_wikidataid_q3416432 (
  "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/Q3419592 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3419592_wikidataid_q3419592
  • 69.6 kB
  • 10,009 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3419592_wikidataid_q3419592 (
  "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/Q3442852 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3442852_wikidataid_q3442852
  • 43.4 kB
  • 5,924 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3442852_wikidataid_q3442852 (
  "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/Q3461597 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q346649_wikidataid_q346649
  • 60.28 kB
  • 8,352 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q346649_wikidataid_q346649 (
  "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/Q3472184 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3472184_wikidataid_q3472184
  • 48.91 kB
  • 6,712 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3472184_wikidataid_q3472184 (
  "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/Q3473501 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3485061_wikidataid_q3485061
  • 40.39 kB
  • 4,953 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3485061_wikidataid_q3485061 (
  "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/Q3501451 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q3502361_wikidataid_q3502361
  • 62.21 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3502361_wikidataid_q3502361 (
  "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/Q3532754 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q3543607_wikidataid_q3543607
  • 48.41 kB
  • 5,969 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3543607_wikidataid_q3543607 (
  "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/Q3547712 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3547712_wikidataid_q3547712
  • 64.04 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3547712_wikidataid_q3547712 (
  "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.