Baselight

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12397849_wikidataid_q12397849
  • 59.9 kB
  • 8,054 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12397849_wikidataid_q12397849 (
  "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/Q12397856 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12398012_wikidataid_q12398012
  • 53.89 kB
  • 7,002 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12398012_wikidataid_q12398012 (
  "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/Q12398020 - Time Series For Statistical Variables

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12398252_wikidataid_q12398252
  • 57.56 kB
  • 7,545 rows
  • 12 columns
Loading...
CREATE TABLE wikidataid_q12398252_wikidataid_q12398252 (
  "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.