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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12397092_wikidataid_q12397092
  • 60.54 kB
  • 7,925 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12397092_wikidataid_q12397092 (
  "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.