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

Abaza - Time Series For Statistical Variables

@datacommons.cities.abaza_wikidataid_q102469
  • 68.26 kB
  • 8,892 rows
  • 12 columns
Loading... 

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

Ab Bar - Time Series For Statistical Variables

@datacommons.cities.ab_bar_wikidataid_q861916
  • 9.38 kB
  • 1 row
  • 12 columns
Loading... 

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

Abbasabad - Time Series For Statistical Variables

@datacommons.cities.abbasabad_wikidataid_q2633198
  • 37.92 kB
  • 4,165 rows
  • 12 columns
Loading... 

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

Abbeville - Time Series For Statistical Variables

@datacommons.cities.abbeville_geoid_0100124
  • 3.13 MB
  • 354,441 rows
  • 12 columns
Loading... 

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

Abbeville - Time Series For Statistical Variables

@datacommons.cities.abbeville_geoid_1300184
  • 2.95 MB
  • 347,368 rows
  • 12 columns
Loading... 

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

Abbeville - Time Series For Statistical Variables

@datacommons.cities.abbeville_geoid_2200100
  • 3.24 MB
  • 358,862 rows
  • 12 columns
Loading... 

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

Abbeville - Time Series For Statistical Variables

@datacommons.cities.abbeville_geoid_2800100
  • 2.87 MB
  • 342,126 rows
  • 12 columns
Loading... 

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

Abbeville - Time Series For Statistical Variables

@datacommons.cities.abbeville_geoid_4500100
  • 3.17 MB
  • 354,266 rows
  • 12 columns
Loading... 

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

Abbeyleix - Time Series For Statistical Variables

@datacommons.cities.abbeyleix_wikidataid_q1650406
  • 53.56 kB
  • 6,712 rows
  • 12 columns
Loading... 

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

Abbot - Time Series For Statistical Variables

@datacommons.cities.abbot_geoid_2300100
  • 81.68 kB
  • 14,052 rows
  • 12 columns
Loading... 

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

Abbotsdale - Time Series For Statistical Variables

@datacommons.cities.abbotsdale_wikidataid_q306688
  • 62.87 kB
  • 7,609 rows
  • 12 columns
Loading... 

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

Abbotsford - Time Series For Statistical Variables

@datacommons.cities.abbotsford_geoid_5500100
  • 3.06 MB
  • 352,455 rows
  • 12 columns
Loading... 

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

Abbotsford, Johannesburg - Time Series For Statistical Variables

@datacommons.cities.abbotsford_johannesburg_wikidataid_q4664288
  • 60.63 kB
  • 7,075 rows
  • 12 columns
Loading... 

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

Abbotsford (Matsqui),BC - Time Series For Statistical Variables

@datacommons.cities.abbotsford_matsqui_bc_undata_geo_c05800001
  • 9.38 kB
  • 3 rows
  • 12 columns
Loading... 

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

Abbotsford - Time Series For Statistical Variables

@datacommons.cities.abbotsford_wikidataid_q271730
  • 111.43 kB
  • 15,124 rows
  • 12 columns
Loading... 

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

Abbotspoort - Time Series For Statistical Variables

@datacommons.cities.abbotspoort_wikidataid_q15177853
  • 39.71 kB
  • 5,186 rows
  • 12 columns
Loading... 

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

Abbottabad - Time Series For Statistical Variables

@datacommons.cities.abbottabad_wikidataid_q170315
  • 33.19 kB
  • 3,464 rows
  • 12 columns
Loading... 

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

Abbott - Time Series For Statistical Variables

@datacommons.cities.abbott_geoid_4800100
  • 2.93 MB
  • 346,697 rows
  • 12 columns
Loading... 

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

Abbotts Creek Township - Time Series For Statistical Variables

@datacommons.cities.abbotts_creek_township_wikidataid_q4664406
  • 93.13 kB
  • 15,306 rows
  • 12 columns
Loading... 

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

Abbotts Creek Township - Time Series For Statistical Variables

@datacommons.cities.abbotts_creek_township_wikidataid_q6026913
  • 101.52 kB
  • 15,304 rows
  • 12 columns
Loading... 

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

Abbottstown - Time Series For Statistical Variables

@datacommons.cities.abbottstown_geoid_4200116
  • 3 MB
  • 352,698 rows
  • 12 columns
Loading... 

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

Abbott Township - Time Series For Statistical Variables

@datacommons.cities.abbott_township_wikidataid_q1089348
  • 66.81 kB
  • 11,723 rows
  • 12 columns
Loading... 

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

Abbs Valley - Time Series For Statistical Variables

@datacommons.cities.abbs_valley_geoid_5100110
  • 958.93 kB
  • 63,544 rows
  • 12 columns
Loading... 

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

Abbyville - Time Series For Statistical Variables

@datacommons.cities.abbyville_geoid_2000100
  • 2.75 MB
  • 339,515 rows
  • 12 columns
Loading... 

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

Abéché - Time Series For Statistical Variables

@datacommons.cities.ab_ch_wikidataid_q242587
  • 36.38 kB
  • 4,846 rows
  • 12 columns
Loading... 

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