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

Alston - Time Series For Statistical Variables

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

Al-Suqaylabiyah - Time Series For Statistical Variables

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

Al-Susah - Time Series For Statistical Variables

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

Al-Suwayda - Time Series For Statistical Variables

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

Als - Time Series For Statistical Variables

@datacommons.cities.als_wikidataid_q2011008
  • 48.65 kB
  • 6,050 rows
  • 12 columns
Loading... 
CREATE TABLE als_wikidataid_q2011008 (
  "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
);

Alsózsolca - Time Series For Statistical Variables

@datacommons.cities.als_zsolca_wikidataid_q432888
  • 50.79 kB
  • 6,193 rows
  • 12 columns
Loading... 
CREATE TABLE als_zsolca_wikidataid_q432888 (
  "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
);

Altadena - Time Series For Statistical Variables

@datacommons.cities.altadena_geoid_0601290
  • 3.55 MB
  • 368,848 rows
  • 12 columns
Loading... 
CREATE TABLE altadena_geoid_0601290 (
  "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
);

Alta - Time Series For Statistical Variables

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

Alta - Time Series For Statistical Variables

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

Alta - Time Series For Statistical Variables

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

Alta - Time Series For Statistical Variables

@datacommons.cities.alta_geoid_5601985
  • 2.76 MB
  • 336,242 rows
  • 12 columns
Loading... 
CREATE TABLE alta_geoid_5601985 (
  "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
);

Alta Gracia - Time Series For Statistical Variables

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

Altair, São Paulo - Time Series For Statistical Variables

@datacommons.cities.altair_s_o_paulo_wikidataid_q305132
  • 30.66 kB
  • 2,526 rows
  • 12 columns
Loading... 
CREATE TABLE altair_s_o_paulo_wikidataid_q305132 (
  "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
);

Altai - Time Series For Statistical Variables

@datacommons.cities.altai_wikidataid_q2139924
  • 26.45 kB
  • 2,448 rows
  • 12 columns
Loading... 
CREATE TABLE altai_wikidataid_q2139924 (
  "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
);

Altai - Time Series For Statistical Variables

@datacommons.cities.altai_wikidataid_q433861
  • 50.2 kB
  • 6,865 rows
  • 12 columns
Loading... 
CREATE TABLE altai_wikidataid_q433861 (
  "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
);

Al-Tall - Time Series For Statistical Variables

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

Alta Loma - Time Series For Statistical Variables

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

Altamahaw - Time Series For Statistical Variables

@datacommons.cities.altamahaw_geoid_3701140
  • 2.78 MB
  • 339,686 rows
  • 12 columns
Loading... 
CREATE TABLE altamahaw_geoid_3701140 (
  "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
);

Altamahaw-Ossipee - Time Series For Statistical Variables

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

Altamonte Springs - Time Series For Statistical Variables

@datacommons.cities.altamonte_springs_geoid_1200950
  • 3.59 MB
  • 366,774 rows
  • 12 columns
Loading... 
CREATE TABLE altamonte_springs_geoid_1200950 (
  "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
);

Altamont - Time Series For Statistical Variables

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

Altamont - Time Series For Statistical Variables

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

Altamont - Time Series For Statistical Variables

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

Altamont - Time Series For Statistical Variables

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

Altamont - Time Series For Statistical Variables

@datacommons.cities.altamont_geoid_4101850
  • 3.32 MB
  • 359,778 rows
  • 12 columns
Loading... 
CREATE TABLE altamont_geoid_4101850 (
  "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.