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

Acre - Time Series For Statistical Variables

@datacommons.cities.acre_wikidataid_q126084
  • 57.5 kB
  • 7,419 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_geoid_0600212
  • 3.22 MB
  • 358,478 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_geoid_1800262
  • 101.01 kB
  • 15,718 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_geoid_2300275
  • 94.91 kB
  • 14,989 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_geoid_2500380
  • 112.35 kB
  • 17,815 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_geoid_3000400
  • 934.61 kB
  • 63,820 rows
  • 12 columns
Loading... 

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

Actons Corners, Ontario - Time Series For Statistical Variables

@datacommons.cities.actons_corners_ontario_wikidataid_q344450
  • 93.03 kB
  • 14,539 rows
  • 12 columns
Loading... 

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

Acton Township - Time Series For Statistical Variables

@datacommons.cities.acton_township_geoid_2700154
  • 78.07 kB
  • 12,944 rows
  • 12 columns
Loading... 

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

Acton Township - Time Series For Statistical Variables

@datacommons.cities.acton_township_geoid_3800260
  • 75.18 kB
  • 12,296 rows
  • 12 columns
Loading... 

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

Acton Vale - Time Series For Statistical Variables

@datacommons.cities.acton_vale_wikidataid_q141960
  • 76.59 kB
  • 12,076 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_wikidataid_q344432
  • 92.05 kB
  • 14,398 rows
  • 12 columns
Loading... 

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

Acton - Time Series For Statistical Variables

@datacommons.cities.acton_wikidataid_q83609
  • 64.06 kB
  • 8,606 rows
  • 12 columns
Loading... 

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

Actopan - Time Series For Statistical Variables

@datacommons.cities.actopan_undata_geo_c16801910
  • 9.21 kB
  • 1 row
  • 12 columns
Loading... 

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

Acuña - Time Series For Statistical Variables

@datacommons.cities.acu_a_undata_geo_c16800233
  • 9.22 kB
  • 2 rows
  • 12 columns
Loading... 

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

Acula - Time Series For Statistical Variables

@datacommons.cities.acula_undata_geo_c16801911
  • 9.2 kB
  • 1 row
  • 12 columns
Loading... 

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

Aculco - Time Series For Statistical Variables

@datacommons.cities.aculco_undata_geo_c16800656
  • 9.2 kB
  • 1 row
  • 12 columns
Loading... 

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

Acultzingo - Time Series For Statistical Variables

@datacommons.cities.acultzingo_undata_geo_c16801912
  • 9.23 kB
  • 1 row
  • 12 columns
Loading... 

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

Acultzingo - Time Series For Statistical Variables

@datacommons.cities.acultzingo_wikidataid_q20220404
  • 55.51 kB
  • 7,420 rows
  • 12 columns
Loading... 

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

Acumuer - Time Series For Statistical Variables

@datacommons.cities.acumuer_wikidataid_q3571764
  • 12.63 kB
  • 403 rows
  • 12 columns
Loading... 

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

Acushnet Center - Time Series For Statistical Variables

@datacommons.cities.acushnet_center_geoid_2500530
  • 3 MB
  • 347,216 rows
  • 12 columns
Loading... 

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

Acushnet - Time Series For Statistical Variables

@datacommons.cities.acushnet_geoid_2500520
  • 109.22 kB
  • 17,318 rows
  • 12 columns
Loading... 

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

Acworth - Time Series For Statistical Variables

@datacommons.cities.acworth_geoid_1300408
  • 3.35 MB
  • 359,524 rows
  • 12 columns
Loading... 

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

Acworth - Time Series For Statistical Variables

@datacommons.cities.acworth_geoid_3300260
  • 95.37 kB
  • 15,912 rows
  • 12 columns
Loading... 

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

Ada, Alabama - Time Series For Statistical Variables

@datacommons.cities.ada_alabama_geoid_0100388
  • 100.01 kB
  • 15,526 rows
  • 12 columns
Loading... 

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

Ada - Time Series For Statistical Variables

@datacommons.cities.ada_geoid_2000225
  • 2.69 MB
  • 334,749 rows
  • 12 columns
Loading... 

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