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

@datacommons.cities.wikidataid_q3148622_wikidataid_q3148622
  • 62.53 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3148622_wikidataid_q3148622 (
  "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/Q3149803 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3149803_wikidataid_q3149803
  • 50.29 kB
  • 6,336 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3149803_wikidataid_q3149803 (
  "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/Q3154256 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3154256_wikidataid_q3154256
  • 52.72 kB
  • 6,717 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3154256_wikidataid_q3154256 (
  "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/Q3154258 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3154258_wikidataid_q3154258
  • 70.59 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3154258_wikidataid_q3154258 (
  "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/Q3154319 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3154319_wikidataid_q3154319
  • 26.8 kB
  • 2,935 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3154319_wikidataid_q3154319 (
  "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/Q3154353 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3154353_wikidataid_q3154353
  • 62.03 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3154353_wikidataid_q3154353 (
  "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/Q3156510 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3156510_wikidataid_q3156510
  • 61.39 kB
  • 8,324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3156510_wikidataid_q3156510 (
  "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/Q3160662 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3160662_wikidataid_q3160662
  • 41.77 kB
  • 4,837 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3160662_wikidataid_q3160662 (
  "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/Q31607710 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31607710_wikidataid_q31607710
  • 78.8 kB
  • 10,873 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31607710_wikidataid_q31607710 (
  "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/Q31891847 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q31891847_wikidataid_q31891847
  • 10.38 kB
  • 110 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q31891847_wikidataid_q31891847 (
  "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/Q3192944 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3192944_wikidataid_q3192944
  • 39.98 kB
  • 4,608 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3192944_wikidataid_q3192944 (
  "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/Q3194843 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q3196864_wikidataid_q3196864
  • 43.84 kB
  • 5,324 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3196864_wikidataid_q3196864 (
  "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/Q3199308 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3199308_wikidataid_q3199308
  • 16.83 kB
  • 1,189 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3199308_wikidataid_q3199308 (
  "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/Q3199354 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3199354_wikidataid_q3199354
  • 38.38 kB
  • 4,521 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3199354_wikidataid_q3199354 (
  "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/Q3218007 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3218007_wikidataid_q3218007
  • 55.08 kB
  • 7,236 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3218007_wikidataid_q3218007 (
  "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/Q3218439 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3218439_wikidataid_q3218439
  • 61.95 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3218439_wikidataid_q3218439 (
  "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/Q3228687 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3228687_wikidataid_q3228687
  • 51.45 kB
  • 6,497 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3228687_wikidataid_q3228687 (
  "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/Q3229045 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3229045_wikidataid_q3229045
  • 66.39 kB
  • 8,418 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3229045_wikidataid_q3229045 (
  "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/Q32323018 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q32323018_wikidataid_q32323018
  • 36.58 kB
  • 4,356 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q32323018_wikidataid_q32323018 (
  "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/Q3237700 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3237700_wikidataid_q3237700
  • 47.91 kB
  • 5,811 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3237700_wikidataid_q3237700 (
  "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/Q3257327 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3257327_wikidataid_q3257327
  • 62.5 kB
  • 8,397 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3257327_wikidataid_q3257327 (
  "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/Q3276080 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3276080_wikidataid_q3276080
  • 13.48 kB
  • 711 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3276080_wikidataid_q3276080 (
  "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/Q3276196 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3276196_wikidataid_q3276196
  • 61.76 kB
  • 8,388 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3276196_wikidataid_q3276196 (
  "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.