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

Bazman - Time Series For Statistical Variables

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

Bazneh - Time Series For Statistical Variables

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

Bazoft - Time Series For Statistical Variables

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

B-baria, Bangladesh - Time Series For Statistical Variables

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

Băbeni - Time Series For Statistical Variables

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

Böblingen - Time Series For Statistical Variables

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

Bábolna - Time Series For Statistical Variables

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

Bécal - Time Series For Statistical Variables

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

Bécancour - Time Series For Statistical Variables

@datacommons.cities.b_cancour_wikidataid_q141542
  • 131.94 kB
  • 20,647 rows
  • 12 columns
Loading...
CREATE TABLE b_cancour_wikidataid_q141542 (
  "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
);

Béccar - Time Series For Statistical Variables

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

Bắc Giang - Time Series For Statistical Variables

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

Bückeburg - Time Series For Statistical Variables

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

Bắc Kạn - Time Series For Statistical Variables

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

Bạc Liêu - Time Series For Statistical Variables

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

Bắc Ninh - Time Series For Statistical Variables

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

Bácsalmás - Time Series For Statistical Variables

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

Bödefeld - Time Series For Statistical Variables

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

Büdelsdorf - Time Series For Statistical Variables

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

Büdingen - Time Series For Statistical Variables

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

Bádonfa - Time Series For Statistical Variables

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

Bédy-Goazon - Time Series For Statistical Variables

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

Będzin - Time Series For Statistical Variables

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

Beach City - Time Series For Statistical Variables

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

Beach City - Time Series For Statistical Variables

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

Beach - Time Series For Statistical Variables

@datacommons.cities.beach_geoid_3805420
  • 2.98 MB
  • 350,455 rows
  • 12 columns
Loading...
CREATE TABLE beach_geoid_3805420 (
  "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.