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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12400084_wikidataid_q12400084
  • 52.73 kB
  • 6,503 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12400084_wikidataid_q12400084 (
  "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/Q12400108 - Time Series For Statistical Variables

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

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

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

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

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

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

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

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

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

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

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

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

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

@datacommons.cities.wikidataid_q12400323_wikidataid_q12400323
  • 42.13 kB
  • 5,092 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q12400323_wikidataid_q12400323 (
  "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.