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

Altenburg - Time Series For Statistical Variables

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

Altenkirchen - Time Series For Statistical Variables

@datacommons.cities.altenkirchen_wikidataid_q488373
  • 74.97 kB
  • 9,048 rows
  • 12 columns
Loading...
CREATE TABLE altenkirchen_wikidataid_q488373 (
  "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
);

Altensteig - Time Series For Statistical Variables

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

Altentreptow - Time Series For Statistical Variables

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

Alter Do Chão - Time Series For Statistical Variables

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

Alter Do Chão - Time Series For Statistical Variables

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

Altha - Time Series For Statistical Variables

@datacommons.cities.altha_geoid_1201000
  • 2.84 MB
  • 340,586 rows
  • 12 columns
Loading...
CREATE TABLE altha_geoid_1201000 (
  "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-Thawrah - Time Series For Statistical Variables

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

Altheimer - Time Series For Statistical Variables

@datacommons.cities.altheimer_geoid_0501150
  • 2.88 MB
  • 342,969 rows
  • 12 columns
Loading...
CREATE TABLE altheimer_geoid_0501150 (
  "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
);

Altheim - Time Series For Statistical Variables

@datacommons.cities.altheim_wikidataid_q440718
  • 74.45 kB
  • 9,907 rows
  • 12 columns
Loading...
CREATE TABLE altheim_wikidataid_q440718 (
  "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
);

Althofen - Time Series For Statistical Variables

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

Altinópolis - Time Series For Statistical Variables

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

Altlandsberg - Time Series For Statistical Variables

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

Altmar - Time Series For Statistical Variables

@datacommons.cities.altmar_geoid_3601550
  • 2.88 MB
  • 344,476 rows
  • 12 columns
Loading...
CREATE TABLE altmar_geoid_3601550 (
  "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
);

Altınoluk - Time Series For Statistical Variables

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

Alto Alegre, São Paulo - Time Series For Statistical Variables

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

Alto Baudó - Time Series For Statistical Variables

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

Alto Bonito - Time Series For Statistical Variables

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

Alto Bonito Heights - Time Series For Statistical Variables

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

Alto - Time Series For Statistical Variables

@datacommons.cities.alto_geoid_0601416
  • 1.45 MB
  • 187,496 rows
  • 12 columns
Loading...
CREATE TABLE alto_geoid_0601416 (
  "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
);

Alto - Time Series For Statistical Variables

@datacommons.cities.alto_geoid_1301948
  • 3.02 MB
  • 350,128 rows
  • 12 columns
Loading...
CREATE TABLE alto_geoid_1301948 (
  "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
);

Alto - Time Series For Statistical Variables

@datacommons.cities.alto_geoid_4802188
  • 2.98 MB
  • 346,821 rows
  • 12 columns
Loading...
CREATE TABLE alto_geoid_4802188 (
  "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
);

Alto - Time Series For Statistical Variables

@datacommons.cities.alto_geoid_5501500
  • 1.06 MB
  • 65,648 rows
  • 12 columns
Loading...
CREATE TABLE alto_geoid_5501500 (
  "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
);

Alto - Time Series For Statistical Variables

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

Altomünster - Time Series For Statistical Variables

@datacommons.cities.altom_nster_wikidataid_q443815
  • 87.02 kB
  • 12,104 rows
  • 12 columns
Loading...
CREATE TABLE altom_nster_wikidataid_q443815 (
  "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.