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

Alexandria - Time Series For Statistical Variables

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

Alexandria - Time Series For Statistical Variables

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

Alexandria - Time Series For Statistical Variables

@datacommons.cities.alexandria_geoid_5101000
  • 4.49 MB
  • 410,760 rows
  • 12 columns
Loading... 
CREATE TABLE alexandria_geoid_5101000 (
  "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
);

Alexandria, Mpumalanga - Time Series For Statistical Variables

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

Alexandria Township - Time Series For Statistical Variables

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

Alexandria Township - Time Series For Statistical Variables

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

Alexandria Township - Time Series For Statistical Variables

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

Alexandria Township - Time Series For Statistical Variables

@datacommons.cities.alexandria_township_geoid_3801300
  • 69.6 kB
  • 11,684 rows
  • 12 columns
Loading... 
CREATE TABLE alexandria_township_geoid_3801300 (
  "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
);

Alexandria - Time Series For Statistical Variables

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

Alexandria - Time Series For Statistical Variables

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

Alexandria - Time Series For Statistical Variables

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

Alexandria - Time Series For Statistical Variables

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

Alexandria - Time Series For Statistical Variables

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

Alexandroupoli - Time Series For Statistical Variables

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

Alexandrovsk-Sakhalinsky - Time Series For Statistical Variables

@datacommons.cities.alexandrovsk_sakhalinsky_wikidataid_q103406
  • 87.18 kB
  • 11,744 rows
  • 12 columns
Loading... 
CREATE TABLE alexandrovsk_sakhalinsky_wikidataid_q103406 (
  "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
);

Alexandrovsk - Time Series For Statistical Variables

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

Alexandrov - Time Series For Statistical Variables

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

Alexanter Township - Time Series For Statistical Variables

@datacommons.cities.alexanter_township_geoid_3801220
  • 69.26 kB
  • 11,496 rows
  • 12 columns
Loading... 
CREATE TABLE alexanter_township_geoid_3801220 (
  "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
);

Alexeyevka - Time Series For Statistical Variables

@datacommons.cities.alexeyevka_wikidataid_q103427
  • 9.43 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE alexeyevka_wikidataid_q103427 (
  "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
);

Alex - Time Series For Statistical Variables

@datacommons.cities.alex_geoid_4001250
  • 2.87 MB
  • 343,314 rows
  • 12 columns
Loading... 
CREATE TABLE alex_geoid_4001250 (
  "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
);

Alexis 133 - Time Series For Statistical Variables

@datacommons.cities.alexis_133_wikidataid_q14874792
  • 9.35 kB
  • 1 row
  • 12 columns
Loading... 
CREATE TABLE alexis_133_wikidataid_q14874792 (
  "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
);

Alexis - Time Series For Statistical Variables

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

Alexis - Time Series For Statistical Variables

@datacommons.cities.alexis_geoid_3700880
  • 1.04 MB
  • 66,327 rows
  • 12 columns
Loading... 
CREATE TABLE alexis_geoid_3700880 (
  "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
);

Alexis Township, Butler County, Nebraska - Time Series For Statistical Variables

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

Alex Township - Time Series For Statistical Variables

@datacommons.cities.alex_township_geoid_3801140
  • 98.25 kB
  • 15,273 rows
  • 12 columns
Loading... 
CREATE TABLE alex_township_geoid_3801140 (
  "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.