Baselight

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

Aksakovo - Time Series For Statistical Variables

@datacommons.cities.aksakovo_wikidataid_q405433
  • 53.73 kB
  • 6,864 rows
  • 12 columns
Loading...

CREATE TABLE aksakovo_wikidataid_q405433 (
  "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
);

Aksaray - Time Series For Statistical Variables

@datacommons.cities.aksaray_wikidataid_q182025
  • 22.09 kB
  • 1,536 rows
  • 12 columns
Loading...

CREATE TABLE aksaray_wikidataid_q182025 (
  "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
);

Aksay - Time Series For Statistical Variables

@datacommons.cities.aksay_wikidataid_q103176
  • 64.8 kB
  • 8,196 rows
  • 12 columns
Loading...

CREATE TABLE aksay_wikidataid_q103176 (
  "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
);

Aksu - Time Series For Statistical Variables

@datacommons.cities.aksu_wikidataid_q421648
  • 13.81 kB
  • 565 rows
  • 12 columns
Loading...

CREATE TABLE aksu_wikidataid_q421648 (
  "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
);

Aksu - Time Series For Statistical Variables

@datacommons.cities.aksu_wikidataid_q622780
  • 61.77 kB
  • 8,615 rows
  • 12 columns
Loading...

CREATE TABLE aksu_wikidataid_q622780 (
  "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
);

Aktau - Time Series For Statistical Variables

@datacommons.cities.aktau_wikidataid_q198989
  • 39.48 kB
  • 4,610 rows
  • 12 columns
Loading...

CREATE TABLE aktau_wikidataid_q198989 (
  "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
);

Aktepe - Time Series For Statistical Variables

@datacommons.cities.aktepe_wikidataid_q4701880
  • 42.09 kB
  • 4,832 rows
  • 12 columns
Loading...

CREATE TABLE aktepe_wikidataid_q4701880 (
  "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
);

Aktobe - Time Series For Statistical Variables

@datacommons.cities.aktobe_wikidataid_q477232
  • 82.36 kB
  • 10,819 rows
  • 12 columns
Loading...

CREATE TABLE aktobe_wikidataid_q477232 (
  "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
);

Aktogay, East Kazakhstan Province - Time Series For Statistical Variables

@datacommons.cities.aktogay_east_kazakhstan_province_wikidataid_q2753561
  • 24.27 kB
  • 2,228 rows
  • 12 columns
Loading...

CREATE TABLE aktogay_east_kazakhstan_province_wikidataid_q2753561 (
  "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
);

Akune - Time Series For Statistical Variables

@datacommons.cities.akune_wikidataid_q15732
  • 50.06 kB
  • 6,217 rows
  • 12 columns
Loading...

CREATE TABLE akune_wikidataid_q15732 (
  "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
);

Akure - Time Series For Statistical Variables

@datacommons.cities.akure_wikidataid_q423831
  • 16.92 kB
  • 1,277 rows
  • 12 columns
Loading...

CREATE TABLE akure_wikidataid_q423831 (
  "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
);

Akureyri - Time Series For Statistical Variables

@datacommons.cities.akureyri_wikidataid_q29042
  • 53.38 kB
  • 7,183 rows
  • 12 columns
Loading...

CREATE TABLE akureyri_wikidataid_q29042 (
  "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
);

Akutan - Time Series For Statistical Variables

@datacommons.cities.akutan_geoid_0201090
  • 1.37 MB
  • 178,614 rows
  • 12 columns
Loading...

CREATE TABLE akutan_geoid_0201090 (
  "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
);

Akutsu - Time Series For Statistical Variables

@datacommons.cities.akutsu_wikidataid_q11512426
  • 69.11 kB
  • 9,728 rows
  • 12 columns
Loading...

CREATE TABLE akutsu_wikidataid_q11512426 (
  "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
);

Akwesasne - Time Series For Statistical Variables

@datacommons.cities.akwesasne_geoid_3600457
  • 1.13 MB
  • 67,881 rows
  • 12 columns
Loading...

CREATE TABLE akwesasne_geoid_3600457 (
  "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
);

Akwete - Time Series For Statistical Variables

@datacommons.cities.akwete_wikidataid_q15043591
  • 25.22 kB
  • 2,215 rows
  • 12 columns
Loading...

CREATE TABLE akwete_wikidataid_q15043591 (
  "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
);

Akweteyman - Time Series For Statistical Variables

@datacommons.cities.akweteyman_wikidataid_q20644848
  • 39.72 kB
  • 4,878 rows
  • 12 columns
Loading...

CREATE TABLE akweteyman_wikidataid_q20644848 (
  "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
);

Akō - Time Series For Statistical Variables

@datacommons.cities.ak_wikidataid_q424813
  • 56.65 kB
  • 7,066 rows
  • 12 columns
Loading...

CREATE TABLE ak_wikidataid_q424813 (
  "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
);

Akyaka - Time Series For Statistical Variables

@datacommons.cities.akyaka_wikidataid_q424411
  • 46.49 kB
  • 5,633 rows
  • 12 columns
Loading...

CREATE TABLE akyaka_wikidataid_q424411 (
  "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
);

Akyaka - Time Series For Statistical Variables

@datacommons.cities.akyaka_wikidataid_q424414
  • 75.9 kB
  • 10,090 rows
  • 12 columns
Loading...

CREATE TABLE akyaka_wikidataid_q424414 (
  "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 Aaroui - Time Series For Statistical Variables

@datacommons.cities.al_aaroui_wikidataid_q613913
  • 48.62 kB
  • 6,052 rows
  • 12 columns
Loading...

CREATE TABLE al_aaroui_wikidataid_q613913 (
  "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
);

Alabama Port - Time Series For Statistical Variables

@datacommons.cities.alabama_port_geoid_0100772
  • 85.76 kB
  • 14,537 rows
  • 12 columns
Loading...

CREATE TABLE alabama_port_geoid_0100772 (
  "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
);

Alabama Township - Time Series For Statistical Variables

@datacommons.cities.alabama_township_wikidataid_q9035953
  • 60.9 kB
  • 11,592 rows
  • 12 columns
Loading...

CREATE TABLE alabama_township_wikidataid_q9035953 (
  "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
);

Alabama - Time Series For Statistical Variables

@datacommons.cities.alabama_wikidataid_q3709658
  • 110.07 kB
  • 15,937 rows
  • 12 columns
Loading...

CREATE TABLE alabama_wikidataid_q3709658 (
  "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
);

Alabam Township - Time Series For Statistical Variables

@datacommons.cities.alabam_township_wikidataid_q5693832
  • 90.25 kB
  • 14,558 rows
  • 12 columns
Loading...

CREATE TABLE alabam_township_wikidataid_q5693832 (
  "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.