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

Aleysk - Time Series For Statistical Variables

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

Aley - Time Series For Statistical Variables

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

Alfajarín - Time Series For Statistical Variables

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

Alfambra - Time Series For Statistical Variables

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

Alfamén - Time Series For Statistical Variables

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

Alfarata - Time Series For Statistical Variables

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

Alfarata - Time Series For Statistical Variables

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

Alfarata - Time Series For Statistical Variables

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

Alfarelos - Time Series For Statistical Variables

@datacommons.cities.alfarelos_wikidataid_q2094565
  • 58.28 kB
  • 7,839 rows
  • 12 columns
Loading... 
CREATE TABLE alfarelos_wikidataid_q2094565 (
  "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-Faris - Time Series For Statistical Variables

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

Alfatar - Time Series For Statistical Variables

@datacommons.cities.alfatar_wikidataid_q407325
  • 66.56 kB
  • 9,009 rows
  • 12 columns
Loading... 
CREATE TABLE alfatar_wikidataid_q407325 (
  "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-Faw - Time Series For Statistical Variables

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

Alfeizerão - Time Series For Statistical Variables

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

Alfeld - Time Series For Statistical Variables

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

Alfena - Time Series For Statistical Variables

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

Alfândega Da Fé - Time Series For Statistical Variables

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

Alfândega Da Fé - Time Series For Statistical Variables

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

Alfántega - Time Series For Statistical Variables

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

Alford - Time Series For Statistical Variables

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

Alford - Time Series For Statistical Variables

@datacommons.cities.alford_geoid_1800946
  • 791.89 kB
  • 36,839 rows
  • 12 columns
Loading... 
CREATE TABLE alford_geoid_1800946 (
  "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
);

Alford - Time Series For Statistical Variables

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

Alfordsville - Time Series For Statistical Variables

@datacommons.cities.alfordsville_geoid_1800964
  • 1.32 MB
  • 182,051 rows
  • 12 columns
Loading... 
CREATE TABLE alfordsville_geoid_1800964 (
  "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
);

Alfordsville - Time Series For Statistical Variables

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

Alford - Time Series For Statistical Variables

@datacommons.cities.alford_wikidataid_q1876378
  • 76.78 kB
  • 10,757 rows
  • 12 columns
Loading... 
CREATE TABLE alford_wikidataid_q1876378 (
  "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
);

Alford - Time Series For Statistical Variables

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