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

Ali Chuk - Time Series For Statistical Variables

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

Ali Chukson - Time Series For Statistical Variables

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

Alicia - Time Series For Statistical Variables

@datacommons.cities.alicia_geoid_0500700
  • 1.36 MB
  • 185,447 rows
  • 12 columns
Loading... 
CREATE TABLE alicia_geoid_0500700 (
  "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
);

Alief - Time Series For Statistical Variables

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

Aligarh - Time Series For Statistical Variables

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

Aligudarz - Time Series For Statistical Variables

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

Alijó - Time Series For Statistical Variables

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

Alijó - Time Series For Statistical Variables

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

Ali Molina - Time Series For Statistical Variables

@datacommons.cities.ali_molina_geoid_0401620
  • 2.59 MB
  • 326,517 rows
  • 12 columns
Loading... 
CREATE TABLE ali_molina_geoid_0401620 (
  "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
);

Aline - Time Series For Statistical Variables

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

Alins Del Monte - Time Series For Statistical Variables

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

Alipura - Time Series For Statistical Variables

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

Alipur Farash - Time Series For Statistical Variables

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

Aliquippa - Time Series For Statistical Variables

@datacommons.cities.aliquippa_geoid_4200820
  • 3.24 MB
  • 359,908 rows
  • 12 columns
Loading... 
CREATE TABLE aliquippa_geoid_4200820 (
  "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
);

Aliquippa - Time Series For Statistical Variables

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

Ali Sabieh - Time Series For Statistical Variables

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

Ali Shahr - Time Series For Statistical Variables

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

Alishan - Time Series For Statistical Variables

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

Aliso Viejo - Time Series For Statistical Variables

@datacommons.cities.aliso_viejo_geoid_0600947
  • 3.72 MB
  • 374,504 rows
  • 12 columns
Loading... 
CREATE TABLE aliso_viejo_geoid_0600947 (
  "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
);

Alistrati - Time Series For Statistical Variables

@datacommons.cities.alistrati_wikidataid_q2706465
  • 17.37 kB
  • 1,028 rows
  • 12 columns
Loading... 
CREATE TABLE alistrati_wikidataid_q2706465 (
  "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
);

Aliveri - Time Series For Statistical Variables

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

Aliwal North - Time Series For Statistical Variables

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

Alix - Time Series For Statistical Variables

@datacommons.cities.alix_geoid_0500730
  • 882.03 kB
  • 60,400 rows
  • 12 columns
Loading... 
CREATE TABLE alix_geoid_0500730 (
  "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
);

Alix Township - Time Series For Statistical Variables

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

Aliyu Amba - Time Series For Statistical Variables

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

Share link

Anyone who has the link will be able to view this.