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

Bang Rachan - Time Series For Statistical Variables

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

Bang Rak Phatthana - Time Series For Statistical Variables

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

Bang Rin - Time Series For Statistical Variables

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

Bangs - Time Series For Statistical Variables

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

Bang Si Mueang - Time Series For Statistical Variables

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

Bangui - Time Series For Statistical Variables

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

Bangula - Time Series For Statistical Variables

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

Bangwe - Time Series For Statistical Variables

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

Banha - Time Series For Statistical Variables

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

Ban Houayxay - Time Series For Statistical Variables

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

Banibangou - Time Series For Statistical Variables

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

Bani Suheila - Time Series For Statistical Variables

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

Bani Walid - Time Series For Statistical Variables

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

Baniyas - Time Series For Statistical Variables

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

Banja Luka - Time Series For Statistical Variables

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

Banjarbaru - Time Series For Statistical Variables

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

Banjarmasin - Time Series For Statistical Variables

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

Banjar - Time Series For Statistical Variables

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

Banjul - Time Series For Statistical Variables

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

Bankhead, Alberta - Time Series For Statistical Variables

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

Ban Krot - Time Series For Statistical Variables

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

Banks - Time Series For Statistical Variables

@datacommons.cities.banks_geoid_0103940
  • 2.81 MB
  • 341,200 rows
  • 12 columns
Loading... 
CREATE TABLE banks_geoid_0103940 (
  "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
);

Banks - Time Series For Statistical Variables

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

Banks - Time Series For Statistical Variables

@datacommons.cities.banks_geoid_1604600
  • 2.53 MB
  • 322,328 rows
  • 12 columns
Loading... 
CREATE TABLE banks_geoid_1604600 (
  "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
);

Banks - Time Series For Statistical Variables

@datacommons.cities.banks_geoid_4103850
  • 3.06 MB
  • 356,662 rows
  • 12 columns
Loading... 
CREATE TABLE banks_geoid_4103850 (
  "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.