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

@datacommons.cities.wikidataid_q6037540_wikidataid_q6037540
  • 32.11 kB
  • 3,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6037540_wikidataid_q6037540 (
  "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/Q6052275 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6052275_wikidataid_q6052275
  • 61.05 kB
  • 8,294 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6052275_wikidataid_q6052275 (
  "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/Q6063840 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6063840_wikidataid_q6063840
  • 14.36 kB
  • 829 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6063840_wikidataid_q6063840 (
  "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/Q6065789 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6065789_wikidataid_q6065789
  • 33.81 kB
  • 3,506 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6065789_wikidataid_q6065789 (
  "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/Q6083230 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q60848484_wikidataid_q60848484
  • 41.52 kB
  • 5,268 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q60848484_wikidataid_q60848484 (
  "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/Q6085623 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6085623_wikidataid_q6085623
  • 50.87 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6085623_wikidataid_q6085623 (
  "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/Q6085801 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6085801_wikidataid_q6085801
  • 57.19 kB
  • 7,492 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6085801_wikidataid_q6085801 (
  "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/Q61054003 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q6107915_wikidataid_q6107915
  • 28.72 kB
  • 3,751 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6107915_wikidataid_q6107915 (
  "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/Q6117110 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6117110_wikidataid_q6117110
  • 51.71 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6117110_wikidataid_q6117110 (
  "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/Q6118248 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6118248_wikidataid_q6118248
  • 51.05 kB
  • 6,722 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6118248_wikidataid_q6118248 (
  "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/Q6118343 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q6119148_wikidataid_q6119148
  • 59.94 kB
  • 7,493 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6119148_wikidataid_q6119148 (
  "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/Q6119690 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6119690_wikidataid_q6119690
  • 61.52 kB
  • 8,311 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6119690_wikidataid_q6119690 (
  "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/Q6120221 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6120221_wikidataid_q6120221
  • 58.55 kB
  • 7,790 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6120221_wikidataid_q6120221 (
  "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/Q6125058 - Time Series For Statistical Variables

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

@datacommons.cities.wikidataid_q61268825_wikidataid_q61268825
  • 34.28 kB
  • 4,591 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61268825_wikidataid_q61268825 (
  "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/Q6127874 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6127874_wikidataid_q6127874
  • 41.36 kB
  • 4,806 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6127874_wikidataid_q6127874 (
  "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/Q6131541 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q6131541_wikidataid_q6131541
  • 48.96 kB
  • 6,675 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q6131541_wikidataid_q6131541 (
  "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/Q61379093 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q61379093_wikidataid_q61379093
  • 54.8 kB
  • 6,968 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379093_wikidataid_q61379093 (
  "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/Q61379194 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q61379194_wikidataid_q61379194
  • 43.49 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379194_wikidataid_q61379194 (
  "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/Q61379200 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q61379200_wikidataid_q61379200
  • 43.43 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379200_wikidataid_q61379200 (
  "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/Q61379201 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q61379201_wikidataid_q61379201
  • 43.53 kB
  • 5,156 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q61379201_wikidataid_q61379201 (
  "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/Q61379203 - Time Series For Statistical Variables

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