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

Bad Bentheim - Time Series For Statistical Variables

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

Bad Bergzabern - Time Series For Statistical Variables

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

Bad Berka - Time Series For Statistical Variables

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

Bad Berka - Time Series For Statistical Variables

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

Bad Berleburg - Time Series For Statistical Variables

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

Bad Berneck Im Fichtelgebirge - Time Series For Statistical Variables

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

Bad Bevensen - Time Series For Statistical Variables

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

Bad Bibra - Time Series For Statistical Variables

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

Bad Blankenburg - Time Series For Statistical Variables

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

Bad Bramstedt - Time Series For Statistical Variables

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

Bad Brückenau - Time Series For Statistical Variables

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

Bad Breisig - Time Series For Statistical Variables

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

Bad Buchau - Time Series For Statistical Variables

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

Bad Camberg - Time Series For Statistical Variables

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

Bad Colberg-Heldburg - Time Series For Statistical Variables

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

Bad Düben - Time Series For Statistical Variables

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

Baddeck - Time Series For Statistical Variables

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

Bad Doberan - Time Series For Statistical Variables

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

Bad Doberan - Time Series For Statistical Variables

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

Bad Driburg - Time Series For Statistical Variables

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

Bad Dürkheim - Time Series For Statistical Variables

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

Bad Dürrenberg - Time Series For Statistical Variables

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

Bad Dürrheim - Time Series For Statistical Variables

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

Bad Elster - Time Series For Statistical Variables

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

Bad Ems - Time Series For Statistical Variables

@datacommons.cities.bad_ems_wikidataid_q490670
  • 63.3 kB
  • 8,405 rows
  • 12 columns
Loading...
CREATE TABLE bad_ems_wikidataid_q490670 (
  "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.