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

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

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

@datacommons.cities.wikidataid_q385445_wikidataid_q385445
  • 50.69 kB
  • 6,337 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q385445_wikidataid_q385445 (
  "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/Q3873472 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3873472_wikidataid_q3873472
  • 37.78 kB
  • 4,330 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3873472_wikidataid_q3873472 (
  "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/Q390897 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q390897_wikidataid_q390897
  • 19.37 kB
  • 1,502 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q390897_wikidataid_q390897 (
  "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/Q3946917 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q3946917_wikidataid_q3946917
  • 48.3 kB
  • 5,998 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q3946917_wikidataid_q3946917 (
  "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/Q3968190 - Time Series For Statistical Variables

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

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

@datacommons.cities.wikidataid_q39759573_wikidataid_q39759573
  • 48.06 kB
  • 6,096 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q39759573_wikidataid_q39759573 (
  "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/Q4083805 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4083805_wikidataid_q4083805
  • 57.2 kB
  • 7,292 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4083805_wikidataid_q4083805 (
  "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/Q4116151 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4116151_wikidataid_q4116151
  • 9.81 kB
  • 50 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4116151_wikidataid_q4116151 (
  "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/Q4159224 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4159224_wikidataid_q4159224
  • 43.48 kB
  • 5,311 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4159224_wikidataid_q4159224 (
  "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/Q4159666 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4159666_wikidataid_q4159666
  • 42.86 kB
  • 5,311 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4159666_wikidataid_q4159666 (
  "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/Q4162074 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4162074_wikidataid_q4162074
  • 11.05 kB
  • 201 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4162074_wikidataid_q4162074 (
  "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/Q4249235 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4249235_wikidataid_q4249235
  • 65.98 kB
  • 8,375 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4249235_wikidataid_q4249235 (
  "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/Q4288213 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4288213_wikidataid_q4288213
  • 49.2 kB
  • 6,089 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4288213_wikidataid_q4288213 (
  "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/Q4293500 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4293500_wikidataid_q4293500
  • 45.95 kB
  • 5,646 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4293500_wikidataid_q4293500 (
  "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/Q4299789 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4299789_wikidataid_q4299789
  • 64.76 kB
  • 8,630 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4299789_wikidataid_q4299789 (
  "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/Q4323399 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4323399_wikidataid_q4323399
  • 87.96 kB
  • 11,546 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4323399_wikidataid_q4323399 (
  "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/Q4348748 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4348748_wikidataid_q4348748
  • 58.6 kB
  • 7,990 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4348748_wikidataid_q4348748 (
  "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/Q4355217 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4355217_wikidataid_q4355217
  • 66.34 kB
  • 9,681 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4355217_wikidataid_q4355217 (
  "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/Q4405727 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4405727_wikidataid_q4405727
  • 22.91 kB
  • 2,223 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4405727_wikidataid_q4405727 (
  "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/Q4407227 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4407227_wikidataid_q4407227
  • 55.12 kB
  • 7,432 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4407227_wikidataid_q4407227 (
  "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/Q4419433 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4419433_wikidataid_q4419433
  • 37.4 kB
  • 5,255 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4419433_wikidataid_q4419433 (
  "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/Q4426421 - Time Series For Statistical Variables

@datacommons.cities.wikidataid_q4426421_wikidataid_q4426421
  • 69.8 kB
  • 10,199 rows
  • 12 columns
Loading... 
CREATE TABLE wikidataid_q4426421_wikidataid_q4426421 (
  "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.