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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12389930_wikidataid_q12389930
  • 56.8 kB
  • 7,659 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12389930_wikidataid_q12389930 (
  "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/Q12389936 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q12389941_wikidataid_q12389941
  • 50.51 kB
  • 6,162 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12389941_wikidataid_q12389941 (
  "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/Q12389959 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12390124_wikidataid_q12390124
  • 54.19 kB
  • 7,012 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12390124_wikidataid_q12390124 (
  "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.