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

@datacommons.cities.wikidataid_q6031699_wikidataid_q6031699
  • 89.01 kB
  • 14,278 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031699_wikidataid_q6031699 (
  "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/Q6031731 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6031731_wikidataid_q6031731
  • 67.11 kB
  • 11,972 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031731_wikidataid_q6031731 (
  "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/Q6031767 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6031767_wikidataid_q6031767
  • 89.74 kB
  • 15,003 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6031767_wikidataid_q6031767 (
  "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/Q6032014 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032014_wikidataid_q6032014
  • 66.06 kB
  • 12,179 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032014_wikidataid_q6032014 (
  "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/Q6032053 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032053_wikidataid_q6032053
  • 97.35 kB
  • 14,883 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032053_wikidataid_q6032053 (
  "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/Q6032177 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032177_wikidataid_q6032177
  • 97.02 kB
  • 14,276 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032177_wikidataid_q6032177 (
  "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/Q6032180 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032180_wikidataid_q6032180
  • 89.44 kB
  • 14,444 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032180_wikidataid_q6032180 (
  "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/Q6032432 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032432_wikidataid_q6032432
  • 69.81 kB
  • 12,987 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032432_wikidataid_q6032432 (
  "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/Q6032472 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032472_wikidataid_q6032472
  • 74.6 kB
  • 12,425 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032472_wikidataid_q6032472 (
  "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/Q6032488 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032488_wikidataid_q6032488
  • 75.07 kB
  • 12,987 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032488_wikidataid_q6032488 (
  "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/Q6032542 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032542_wikidataid_q6032542
  • 70.09 kB
  • 12,372 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032542_wikidataid_q6032542 (
  "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/Q6032547 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032547_wikidataid_q6032547
  • 71.34 kB
  • 12,392 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032547_wikidataid_q6032547 (
  "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/Q6032568 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032568_wikidataid_q6032568
  • 69.71 kB
  • 12,984 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032568_wikidataid_q6032568 (
  "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/Q6032580 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032580_wikidataid_q6032580
  • 75.4 kB
  • 12,583 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032580_wikidataid_q6032580 (
  "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/Q6032609 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032609_wikidataid_q6032609
  • 70.22 kB
  • 12,539 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032609_wikidataid_q6032609 (
  "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/Q6032613 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032613_wikidataid_q6032613
  • 76.41 kB
  • 13,182 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032613_wikidataid_q6032613 (
  "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/Q6032639 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032639_wikidataid_q6032639
  • 88.77 kB
  • 14,274 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032639_wikidataid_q6032639 (
  "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/Q6032641 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032641_wikidataid_q6032641
  • 88.71 kB
  • 14,986 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032641_wikidataid_q6032641 (
  "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/Q6032656 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032656_wikidataid_q6032656
  • 76.89 kB
  • 13,281 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032656_wikidataid_q6032656 (
  "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/Q6032658 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032658_wikidataid_q6032658
  • 68.22 kB
  • 12,077 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032658_wikidataid_q6032658 (
  "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/Q6032664 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032664_wikidataid_q6032664
  • 79.96 kB
  • 13,857 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032664_wikidataid_q6032664 (
  "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/Q6032715 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032715_wikidataid_q6032715
  • 102.43 kB
  • 15,313 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032715_wikidataid_q6032715 (
  "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/Q6032717 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032717_wikidataid_q6032717
  • 89.52 kB
  • 14,448 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032717_wikidataid_q6032717 (
  "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/Q6032722 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032722_wikidataid_q6032722
  • 85.73 kB
  • 14,317 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032722_wikidataid_q6032722 (
  "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/Q6032736 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6032736_wikidataid_q6032736
  • 102.4 kB
  • 15,375 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6032736_wikidataid_q6032736 (
  "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.