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

Aelia Capitolina - Time Series For Statistical Variables

@datacommons.cities.aelia_capitolina_wikidataid_q1250874
  • 64.98 kB
  • 8,656 rows
  • 12 columns
Loading... 

CREATE TABLE aelia_capitolina_wikidataid_q1250874 (
  "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
);

Aerdenhout - Time Series For Statistical Variables

@datacommons.cities.aerdenhout_wikidataid_q2347146
  • 76.57 kB
  • 10,720 rows
  • 12 columns
Loading... 

CREATE TABLE aerdenhout_wikidataid_q2347146 (
  "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
);

Aeroton - Time Series For Statistical Variables

@datacommons.cities.aeroton_wikidataid_q4688491
  • 58.08 kB
  • 7,059 rows
  • 12 columns
Loading... 

CREATE TABLE aeroton_wikidataid_q4688491 (
  "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
);

Aesch BL - Time Series For Statistical Variables

@datacommons.cities.aesch_bl_wikidataid_q68367
  • 76.99 kB
  • 10,870 rows
  • 12 columns
Loading... 

CREATE TABLE aesch_bl_wikidataid_q68367 (
  "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
);

Aetna Estates - Time Series For Statistical Variables

@datacommons.cities.aetna_estates_geoid_0800620
  • 2.91 MB
  • 344,301 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_estates_geoid_0800620 (
  "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
);

Aetna Estates - Time Series For Statistical Variables

@datacommons.cities.aetna_estates_wikidataid_q4688748
  • 103.41 kB
  • 15,392 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_estates_wikidataid_q4688748 (
  "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
);

Aetna Township - Time Series For Statistical Variables

@datacommons.cities.aetna_township_geoid_1700360
  • 94.04 kB
  • 15,122 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_township_geoid_1700360 (
  "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
);

Aetna Township - Time Series For Statistical Variables

@datacommons.cities.aetna_township_geoid_2000400
  • 77.4 kB
  • 13,470 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_township_geoid_2000400 (
  "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
);

Aetna Township - Time Series For Statistical Variables

@datacommons.cities.aetna_township_geoid_2600500
  • 76.56 kB
  • 12,859 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_township_geoid_2600500 (
  "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
);

Aetna Township - Time Series For Statistical Variables

@datacommons.cities.aetna_township_geoid_2600520
  • 93.44 kB
  • 15,067 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_township_geoid_2600520 (
  "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
);

Aetna Township - Time Series For Statistical Variables

@datacommons.cities.aetna_township_geoid_2700298
  • 80.49 kB
  • 12,703 rows
  • 12 columns
Loading... 

CREATE TABLE aetna_township_geoid_2700298 (
  "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
);

Afagnan - Time Series For Statistical Variables

@datacommons.cities.afagnan_wikidataid_q30744809
  • 42.38 kB
  • 5,140 rows
  • 12 columns
Loading... 

CREATE TABLE afagnan_wikidataid_q30744809 (
  "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
);

Afak - Time Series For Statistical Variables

@datacommons.cities.afak_wikidataid_q1029650
  • 31.38 kB
  • 3,809 rows
  • 12 columns
Loading... 

CREATE TABLE afak_wikidataid_q1029650 (
  "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
);

Afantou Municipality - Time Series For Statistical Variables

@datacommons.cities.afantou_municipality_wikidataid_q12874215
  • 43.78 kB
  • 5,446 rows
  • 12 columns
Loading... 

CREATE TABLE afantou_municipality_wikidataid_q12874215 (
  "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
);

Affoltern Am Albis - Time Series For Statistical Variables

@datacommons.cities.affoltern_am_albis_wikidataid_q68290
  • 80.13 kB
  • 11,047 rows
  • 12 columns
Loading... 

CREATE TABLE affoltern_am_albis_wikidataid_q68290 (
  "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
);

Affton - Time Series For Statistical Variables

@datacommons.cities.affton_geoid_2900280
  • 3.33 MB
  • 360,837 rows
  • 12 columns
Loading... 

CREATE TABLE affton_geoid_2900280 (
  "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
);

Afif - Time Series For Statistical Variables

@datacommons.cities.afif_wikidataid_q27139
  • 9.33 kB
  • 1 row
  • 12 columns
Loading... 

CREATE TABLE afif_wikidataid_q27139 (
  "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
);

Aflao - Time Series For Statistical Variables

@datacommons.cities.aflao_wikidataid_q383333
  • 49.78 kB
  • 6,552 rows
  • 12 columns
Loading... 

CREATE TABLE aflao_wikidataid_q383333 (
  "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
);

A Frieira (settlement) - Time Series For Statistical Variables

@datacommons.cities.a_frieira_settlement_wikidataid_q12380925
  • 56.24 kB
  • 6,506 rows
  • 12 columns
Loading... 

CREATE TABLE a_frieira_settlement_wikidataid_q12380925 (
  "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
);

Afrin - Time Series For Statistical Variables

@datacommons.cities.afrin_wikidataid_q302268
  • 49.66 kB
  • 6,380 rows
  • 12 columns
Loading... 

CREATE TABLE afrin_wikidataid_q302268 (
  "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
);

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_geoid_1900595
  • 3.03 MB
  • 351,903 rows
  • 12 columns
Loading... 

CREATE TABLE afton_geoid_1900595 (
  "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
);

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_geoid_2700316
  • 3.1 MB
  • 355,308 rows
  • 12 columns
Loading... 

CREATE TABLE afton_geoid_2700316 (
  "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
);

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_geoid_3600342
  • 3.05 MB
  • 354,499 rows
  • 12 columns
Loading... 

CREATE TABLE afton_geoid_3600342 (
  "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
);

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_geoid_4000600
  • 2.99 MB
  • 346,291 rows
  • 12 columns
Loading... 

CREATE TABLE afton_geoid_4000600 (
  "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
);

Afton - Time Series For Statistical Variables

@datacommons.cities.afton_geoid_5100484
  • 993.14 kB
  • 63,882 rows
  • 12 columns
Loading... 

CREATE TABLE afton_geoid_5100484 (
  "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.