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

Arcadia - Time Series For Statistical Variables

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

Arcadia - Time Series For Statistical Variables

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

Arcanum - Time Series For Statistical Variables

@datacommons.cities.arcanum_geoid_3902330
  • 3.09 MB
  • 356,369 rows
  • 12 columns
Loading... 
CREATE TABLE arcanum_geoid_3902330 (
  "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
);

Arcata - Time Series For Statistical Variables

@datacommons.cities.arcata_geoid_0602476
  • 3.4 MB
  • 361,808 rows
  • 12 columns
Loading... 
CREATE TABLE arcata_geoid_0602476 (
  "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
);

Arcetri - Time Series For Statistical Variables

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

Archangelos - Time Series For Statistical Variables

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

Archbald - Time Series For Statistical Variables

@datacommons.cities.archbald_geoid_4202832
  • 3.18 MB
  • 355,647 rows
  • 12 columns
Loading... 
CREATE TABLE archbald_geoid_4202832 (
  "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
);

Archbold - Time Series For Statistical Variables

@datacommons.cities.archbold_geoid_3902344
  • 3.19 MB
  • 354,350 rows
  • 12 columns
Loading... 
CREATE TABLE archbold_geoid_3902344 (
  "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
);

Archdale - Time Series For Statistical Variables

@datacommons.cities.archdale_geoid_3701720
  • 3.31 MB
  • 360,467 rows
  • 12 columns
Loading... 
CREATE TABLE archdale_geoid_3701720 (
  "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
);

Archer City - Time Series For Statistical Variables

@datacommons.cities.archer_city_geoid_4803696
  • 3.03 MB
  • 352,849 rows
  • 12 columns
Loading... 
CREATE TABLE archer_city_geoid_4803696 (
  "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
);

Archer - Time Series For Statistical Variables

@datacommons.cities.archer_geoid_1201775
  • 2.94 MB
  • 344,846 rows
  • 12 columns
Loading... 
CREATE TABLE archer_geoid_1201775 (
  "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
);

Archer - Time Series For Statistical Variables

@datacommons.cities.archer_geoid_1902530
  • 1.38 MB
  • 186,724 rows
  • 12 columns
Loading... 
CREATE TABLE archer_geoid_1902530 (
  "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
);

Archer - Time Series For Statistical Variables

@datacommons.cities.archer_geoid_3101920
  • 2.69 MB
  • 334,785 rows
  • 12 columns
Loading... 
CREATE TABLE archer_geoid_3101920 (
  "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
);

Archer Lodge - Time Series For Statistical Variables

@datacommons.cities.archer_lodge_geoid_3701760
  • 3 MB
  • 347,154 rows
  • 12 columns
Loading... 
CREATE TABLE archer_lodge_geoid_3701760 (
  "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
);

Archer Lodge - Time Series For Statistical Variables

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

Archer Township - Time Series For Statistical Variables

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

Archey Valley Township - Time Series For Statistical Variables

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

Archidona, Ecuador - Time Series For Statistical Variables

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

Archie - Time Series For Statistical Variables

@datacommons.cities.archie_geoid_2901702
  • 3.03 MB
  • 350,826 rows
  • 12 columns
Loading... 
CREATE TABLE archie_geoid_2901702 (
  "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
);

Archies Creek - Time Series For Statistical Variables

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

Archville - Time Series For Statistical Variables

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

Arco - Time Series For Statistical Variables

@datacommons.cities.arco_geoid_1603160
  • 3 MB
  • 351,275 rows
  • 12 columns
Loading... 
CREATE TABLE arco_geoid_1603160 (
  "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
);

Arco - Time Series For Statistical Variables

@datacommons.cities.arco_geoid_2701972
  • 2.74 MB
  • 338,184 rows
  • 12 columns
Loading... 
CREATE TABLE arco_geoid_2701972 (
  "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
);

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_geoid_1701881
  • 3.15 MB
  • 355,622 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_geoid_1701881 (
  "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
);

Arcola - Time Series For Statistical Variables

@datacommons.cities.arcola_geoid_1801990
  • 813.18 kB
  • 38,693 rows
  • 12 columns
Loading... 
CREATE TABLE arcola_geoid_1801990 (
  "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.