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

Almond Township - Time Series For Statistical Variables

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

Almond - Time Series For Statistical Variables

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

Almon - Time Series For Statistical Variables

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

Almonte - Time Series For Statistical Variables

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

Almonte - Time Series For Statistical Variables

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

Almont - Time Series For Statistical Variables

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

Almont - Time Series For Statistical Variables

@datacommons.cities.almont_geoid_3801700
  • 2.75 MB
  • 337,936 rows
  • 12 columns
Loading... 
CREATE TABLE almont_geoid_3801700 (
  "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
);

Almont Township - Time Series For Statistical Variables

@datacommons.cities.almont_township_geoid_2601680
  • 111.58 kB
  • 15,907 rows
  • 12 columns
Loading... 
CREATE TABLE almont_township_geoid_2601680 (
  "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-Muabbada - Time Series For Statistical Variables

@datacommons.cities.al_muabbada_wikidataid_q129789
  • 16.82 kB
  • 1,187 rows
  • 12 columns
Loading... 
CREATE TABLE al_muabbada_wikidataid_q129789 (
  "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 Mualla District - Time Series For Statistical Variables

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

Al-Mubarraz - Time Series For Statistical Variables

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

Almudáfar - Time Series For Statistical Variables

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

Almudévar - Time Series For Statistical Variables

@datacommons.cities.almud_var_wikidataid_q24003586
  • 37.94 kB
  • 3,872 rows
  • 12 columns
Loading... 
CREATE TABLE almud_var_wikidataid_q24003586 (
  "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-Mughraqa - Time Series For Statistical Variables

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

Almuniente - Time Series For Statistical Variables

@datacommons.cities.almuniente_wikidataid_q24013435
  • 34.57 kB
  • 3,872 rows
  • 12 columns
Loading... 
CREATE TABLE almuniente_wikidataid_q24013435 (
  "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
);

Almurta - Time Series For Statistical Variables

@datacommons.cities.almurta_wikidataid_q4734027
  • 57.12 kB
  • 7,241 rows
  • 12 columns
Loading... 
CREATE TABLE almurta_wikidataid_q4734027 (
  "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 Mushayrifah - Time Series For Statistical Variables

@datacommons.cities.al_mushayrifah_wikidataid_q18710423
  • 34.24 kB
  • 4,040 rows
  • 12 columns
Loading... 
CREATE TABLE al_mushayrifah_wikidataid_q18710423 (
  "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 Mushayrifah - Time Series For Statistical Variables

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

Almyra - Time Series For Statistical Variables

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

Almyros - Time Series For Statistical Variables

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

Alna - Time Series For Statistical Variables

@datacommons.cities.alna_geoid_2301010
  • 104.5 kB
  • 16,647 rows
  • 12 columns
Loading... 
CREATE TABLE alna_geoid_2301010 (
  "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
);

Alness - Time Series For Statistical Variables

@datacommons.cities.alness_wikidataid_q582452
  • 52.48 kB
  • 6,708 rows
  • 12 columns
Loading... 
CREATE TABLE alness_wikidataid_q582452 (
  "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íns - Time Series For Statistical Variables

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

Alnwick - Time Series For Statistical Variables

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

Alofi - Time Series For Statistical Variables

@datacommons.cities.alofi_wikidataid_q30966
  • 40.4 kB
  • 4,537 rows
  • 12 columns
Loading... 
CREATE TABLE alofi_wikidataid_q30966 (
  "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.