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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12395114_wikidataid_q12395114
  • 50.66 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395114_wikidataid_q12395114 (
  "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/Q12395126 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q12395126_wikidataid_q12395126
  • 55.2 kB
  • 7,116 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12395126_wikidataid_q12395126 (
  "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/Q12395128 - Time Series For Statistical Variables

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

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

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

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

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

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

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