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

@datacommons.cities.wikidataid_q1961686_wikidataid_q1961686
  • 50.28 kB
  • 5,967 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1961686_wikidataid_q1961686 (
  "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/Q1963933 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1963933_wikidataid_q1963933
  • 19.03 kB
  • 1,666 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1963933_wikidataid_q1963933 (
  "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/Q19715112 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q19715112_wikidataid_q19715112
  • 70.35 kB
  • 9,579 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q19715112_wikidataid_q19715112 (
  "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/Q1972412 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1972412_wikidataid_q1972412
  • 38.35 kB
  • 4,513 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1972412_wikidataid_q1972412 (
  "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/Q1974951 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1974951_wikidataid_q1974951
  • 47.45 kB
  • 5,828 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1974951_wikidataid_q1974951 (
  "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/Q1982933 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1982933_wikidataid_q1982933
  • 69.63 kB
  • 10,169 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1982933_wikidataid_q1982933 (
  "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/Q1987821 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1987821_wikidataid_q1987821
  • 75.3 kB
  • 10,682 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1987821_wikidataid_q1987821 (
  "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/Q1988409 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1988409_wikidataid_q1988409
  • 47.31 kB
  • 5,804 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1988409_wikidataid_q1988409 (
  "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/Q1988694 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1988694_wikidataid_q1988694
  • 65.12 kB
  • 8,379 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1988694_wikidataid_q1988694 (
  "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/Q1992722 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q1992722_wikidataid_q1992722
  • 71.94 kB
  • 10,147 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q1992722_wikidataid_q1992722 (
  "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/Q20018120 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20018120_wikidataid_q20018120
  • 59.41 kB
  • 8,226 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20018120_wikidataid_q20018120 (
  "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/Q20052844 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20052844_wikidataid_q20052844
  • 60.05 kB
  • 8,110 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20052844_wikidataid_q20052844 (
  "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/Q20058339 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20058339_wikidataid_q20058339
  • 81.14 kB
  • 11,526 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20058339_wikidataid_q20058339 (
  "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/Q2007409 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2007409_wikidataid_q2007409
  • 48.38 kB
  • 5,967 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2007409_wikidataid_q2007409 (
  "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/Q20108317 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20108317_wikidataid_q20108317
  • 34.67 kB
  • 4,656 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20108317_wikidataid_q20108317 (
  "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/Q20207490 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20207490_wikidataid_q20207490
  • 57.07 kB
  • 8,094 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20207490_wikidataid_q20207490 (
  "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/Q2040808 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q2040808_wikidataid_q2040808
  • 84.19 kB
  • 11,728 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2040808_wikidataid_q2040808 (
  "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/Q20413554 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q2045668_wikidataid_q2045668
  • 82.37 kB
  • 11,673 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q2045668_wikidataid_q2045668 (
  "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/Q20483985 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20483985_wikidataid_q20483985
  • 97.46 kB
  • 15,452 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20483985_wikidataid_q20483985 (
  "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/Q20483988 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20483988_wikidataid_q20483988
  • 91.9 kB
  • 14,666 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20483988_wikidataid_q20483988 (
  "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/Q20484024 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484024_wikidataid_q20484024
  • 68.23 kB
  • 11,898 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484024_wikidataid_q20484024 (
  "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/Q20484032 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q20484032_wikidataid_q20484032
  • 74.63 kB
  • 12,471 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q20484032_wikidataid_q20484032 (
  "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/Q20484171 - Time Series For Statistical Variables

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