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

Barcelona - Time Series For Statistical Variables

@datacommons.cities.barcelona_wikidataid_q1492
  • 63.8 kB
  • 8,656 rows
  • 12 columns
Loading... 
CREATE TABLE barcelona_wikidataid_q1492 (
  "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
);

Barcelona - Time Series For Statistical Variables

@datacommons.cities.barcelona_wikidataid_q391221
  • 37.98 kB
  • 4,435 rows
  • 12 columns
Loading... 
CREATE TABLE barcelona_wikidataid_q391221 (
  "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
);

Barcelona - Time Series For Statistical Variables

@datacommons.cities.barcelona_wikidataid_q771345
  • 58.51 kB
  • 9,230 rows
  • 12 columns
Loading... 
CREATE TABLE barcelona_wikidataid_q771345 (
  "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
);

Barceloneta Zona Urbana - Time Series For Statistical Variables

@datacommons.cities.barceloneta_zona_urbana_geoid_7205346
  • 1.58 MB
  • 191,074 rows
  • 12 columns
Loading... 
CREATE TABLE barceloneta_zona_urbana_geoid_7205346 (
  "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
);

Barcelos (city) - Time Series For Statistical Variables

@datacommons.cities.barcelos_city_wikidataid_q31910871
  • 55.12 kB
  • 7,110 rows
  • 12 columns
Loading... 
CREATE TABLE barcelos_city_wikidataid_q31910871 (
  "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
);

Barcelos - Time Series For Statistical Variables

@datacommons.cities.barcelos_wikidataid_q213242
  • 55 kB
  • 7,195 rows
  • 12 columns
Loading... 
CREATE TABLE barcelos_wikidataid_q213242 (
  "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
);

Barcin - Time Series For Statistical Variables

@datacommons.cities.barcin_wikidataid_q1007355
  • 57.91 kB
  • 7,685 rows
  • 12 columns
Loading... 
CREATE TABLE barcin_wikidataid_q1007355 (
  "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
);

Barclay - Time Series For Statistical Variables

@datacommons.cities.barclay_geoid_2404250
  • 2.84 MB
  • 342,319 rows
  • 12 columns
Loading... 
CREATE TABLE barclay_geoid_2404250 (
  "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
);

Barclay - Time Series For Statistical Variables

@datacommons.cities.barclay_geoid_3402880
  • 3.12 MB
  • 357,435 rows
  • 12 columns
Loading... 
CREATE TABLE barclay_geoid_3402880 (
  "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
);

Barclay-Kingston - Time Series For Statistical Variables

@datacommons.cities.barclay_kingston_geoid_3402905
  • 100.91 kB
  • 15,803 rows
  • 12 columns
Loading... 
CREATE TABLE barclay_kingston_geoid_3402905 (
  "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
);

Barclay Township - Time Series For Statistical Variables

@datacommons.cities.barclay_township_geoid_1990126
  • 93.66 kB
  • 14,918 rows
  • 12 columns
Loading... 
CREATE TABLE barclay_township_geoid_1990126 (
  "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
);

Barclay Township - Time Series For Statistical Variables

@datacommons.cities.barclay_township_geoid_2004175
  • 101.61 kB
  • 14,803 rows
  • 12 columns
Loading... 
CREATE TABLE barclay_township_geoid_2004175 (
  "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
);

Barclay Township - Time Series For Statistical Variables

@datacommons.cities.barclay_township_geoid_2703538
  • 85.17 kB
  • 13,520 rows
  • 12 columns
Loading... 
CREATE TABLE barclay_township_geoid_2703538 (
  "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
);

Barcs - Time Series For Statistical Variables

@datacommons.cities.barcs_wikidataid_q790370
  • 43.4 kB
  • 5,080 rows
  • 12 columns
Loading... 
CREATE TABLE barcs_wikidataid_q790370 (
  "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
);

Barczewo - Time Series For Statistical Variables

@datacommons.cities.barczewo_wikidataid_q807991
  • 51.15 kB
  • 6,699 rows
  • 12 columns
Loading... 
CREATE TABLE barczewo_wikidataid_q807991 (
  "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
);

Búðardalur - Time Series For Statistical Variables

@datacommons.cities.b_ardalur_wikidataid_q1020276
  • 51.07 kB
  • 6,670 rows
  • 12 columns
Loading... 
CREATE TABLE b_ardalur_wikidataid_q1020276 (
  "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
);

Bardaskan - Time Series For Statistical Variables

@datacommons.cities.bardaskan_wikidataid_q4576750
  • 29.26 kB
  • 3,175 rows
  • 12 columns
Loading... 
CREATE TABLE bardaskan_wikidataid_q4576750 (
  "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
);

Barda - Time Series For Statistical Variables

@datacommons.cities.barda_wikidataid_q842869
  • 37.11 kB
  • 4,111 rows
  • 12 columns
Loading... 
CREATE TABLE barda_wikidataid_q842869 (
  "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
);

Bard College - Time Series For Statistical Variables

@datacommons.cities.bard_college_geoid_3604388
  • 1.09 MB
  • 67,057 rows
  • 12 columns
Loading... 
CREATE TABLE bard_college_geoid_3604388 (
  "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
);

Bardeh Rasheh, Marivan - Time Series For Statistical Variables

@datacommons.cities.bardeh_rasheh_marivan_wikidataid_q6416695
  • 12.43 kB
  • 407 rows
  • 12 columns
Loading... 
CREATE TABLE bardeh_rasheh_marivan_wikidataid_q6416695 (
  "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
);

Bardejov - Time Series For Statistical Variables

@datacommons.cities.bardejov_wikidataid_q27007
  • 38.74 kB
  • 4,339 rows
  • 12 columns
Loading... 
CREATE TABLE bardejov_wikidataid_q27007 (
  "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
);

Bardestan - Time Series For Statistical Variables

@datacommons.cities.bardestan_wikidataid_q2632275
  • 20.09 kB
  • 1,564 rows
  • 12 columns
Loading... 
CREATE TABLE bardestan_wikidataid_q2632275 (
  "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
);

Bardhaman - Time Series For Statistical Variables

@datacommons.cities.bardhaman_wikidataid_q709267
  • 50.09 kB
  • 5,702 rows
  • 12 columns
Loading... 
CREATE TABLE bardhaman_wikidataid_q709267 (
  "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
);

Bardia - Time Series For Statistical Variables

@datacommons.cities.bardia_wikidataid_q141687
  • 49.42 kB
  • 6,516 rows
  • 12 columns
Loading... 
CREATE TABLE bardia_wikidataid_q141687 (
  "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
);

Bardmoor - Time Series For Statistical Variables

@datacommons.cities.bardmoor_geoid_1203480
  • 3.16 MB
  • 357,037 rows
  • 12 columns
Loading... 
CREATE TABLE bardmoor_geoid_1203480 (
  "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.