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 Pyrmont - Time Series For Statistical Variables

@datacommons.cities.bad_pyrmont_wikidataid_q556352
  • 62.76 kB
  • 8,199 rows
  • 12 columns
Loading...
CREATE TABLE bad_pyrmont_wikidataid_q556352 (
  "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 Radkersburg - Time Series For Statistical Variables

@datacommons.cities.bad_radkersburg_wikidataid_q698465
  • 53.14 kB
  • 6,518 rows
  • 12 columns
Loading...
CREATE TABLE bad_radkersburg_wikidataid_q698465 (
  "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 Rappenau - Time Series For Statistical Variables

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

Badreh - Time Series For Statistical Variables

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

Bad Reichenhall - Time Series For Statistical Variables

@datacommons.cities.bad_reichenhall_wikidataid_q487971
  • 82.51 kB
  • 11,403 rows
  • 12 columns
Loading...
CREATE TABLE bad_reichenhall_wikidataid_q487971 (
  "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 Rodach - Time Series For Statistical Variables

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

Badrud - Time Series For Statistical Variables

@datacommons.cities.badrud_wikidataid_q80818
  • 34.02 kB
  • 3,982 rows
  • 12 columns
Loading...
CREATE TABLE badrud_wikidataid_q80818 (
  "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 Sachsa - Time Series For Statistical Variables

@datacommons.cities.bad_sachsa_wikidataid_q541860
  • 73.12 kB
  • 10,314 rows
  • 12 columns
Loading...
CREATE TABLE bad_sachsa_wikidataid_q541860 (
  "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 Salzdetfurth - Time Series For Statistical Variables

@datacommons.cities.bad_salzdetfurth_wikidataid_q633004
  • 66.64 kB
  • 9,443 rows
  • 12 columns
Loading...
CREATE TABLE bad_salzdetfurth_wikidataid_q633004 (
  "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 Salzuflen - Time Series For Statistical Variables

@datacommons.cities.bad_salzuflen_wikidataid_q4108
  • 64.19 kB
  • 8,323 rows
  • 12 columns
Loading...
CREATE TABLE bad_salzuflen_wikidataid_q4108 (
  "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 Salzungen - Time Series For Statistical Variables

@datacommons.cities.bad_salzungen_wikidataid_q502662
  • 62.7 kB
  • 8,249 rows
  • 12 columns
Loading...
CREATE TABLE bad_salzungen_wikidataid_q502662 (
  "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 Saulgau - Time Series For Statistical Variables

@datacommons.cities.bad_saulgau_wikidataid_q83190
  • 76.18 kB
  • 10,064 rows
  • 12 columns
Loading...
CREATE TABLE bad_saulgau_wikidataid_q83190 (
  "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 Schandau - Time Series For Statistical Variables

@datacommons.cities.bad_schandau_wikidataid_q6406
  • 86.88 kB
  • 11,228 rows
  • 12 columns
Loading...
CREATE TABLE bad_schandau_wikidataid_q6406 (
  "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 Schmiedeberg - Time Series For Statistical Variables

@datacommons.cities.bad_schmiedeberg_wikidataid_q522557
  • 79.25 kB
  • 10,779 rows
  • 12 columns
Loading...
CREATE TABLE bad_schmiedeberg_wikidataid_q522557 (
  "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 Schussenried - Time Series For Statistical Variables

@datacommons.cities.bad_schussenried_wikidataid_q522513
  • 79.68 kB
  • 10,506 rows
  • 12 columns
Loading...
CREATE TABLE bad_schussenried_wikidataid_q522513 (
  "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 Schwalbach - Time Series For Statistical Variables

@datacommons.cities.bad_schwalbach_wikidataid_q522541
  • 81.73 kB
  • 11,082 rows
  • 12 columns
Loading...
CREATE TABLE bad_schwalbach_wikidataid_q522541 (
  "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 Schwartau - Time Series For Statistical Variables

@datacommons.cities.bad_schwartau_wikidataid_q516432
  • 67.58 kB
  • 9,597 rows
  • 12 columns
Loading...
CREATE TABLE bad_schwartau_wikidataid_q516432 (
  "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 Säckingen - Time Series For Statistical Variables

@datacommons.cities.bad_s_ckingen_wikidataid_q522362
  • 83.75 kB
  • 11,895 rows
  • 12 columns
Loading...
CREATE TABLE bad_s_ckingen_wikidataid_q522362 (
  "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 Segeberg - Time Series For Statistical Variables

@datacommons.cities.bad_segeberg_wikidataid_q496050
  • 81.95 kB
  • 11,445 rows
  • 12 columns
Loading...
CREATE TABLE bad_segeberg_wikidataid_q496050 (
  "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 Sülze - Time Series For Statistical Variables

@datacommons.cities.bad_s_lze_wikidataid_q507967
  • 78.82 kB
  • 10,840 rows
  • 12 columns
Loading...
CREATE TABLE bad_s_lze_wikidataid_q507967 (
  "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 Sobernheim - Time Series For Statistical Variables

@datacommons.cities.bad_sobernheim_wikidataid_q520075
  • 81.12 kB
  • 11,558 rows
  • 12 columns
Loading...
CREATE TABLE bad_sobernheim_wikidataid_q520075 (
  "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 Soden-Salmünster - Time Series For Statistical Variables

@datacommons.cities.bad_soden_salm_nster_wikidataid_q558600
  • 63.3 kB
  • 8,324 rows
  • 12 columns
Loading...
CREATE TABLE bad_soden_salm_nster_wikidataid_q558600 (
  "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 Soden - Time Series For Statistical Variables

@datacommons.cities.bad_soden_wikidataid_q39785
  • 82.85 kB
  • 11,300 rows
  • 12 columns
Loading...
CREATE TABLE bad_soden_wikidataid_q39785 (
  "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 Sooden-Allendorf - Time Series For Statistical Variables

@datacommons.cities.bad_sooden_allendorf_wikidataid_q564821
  • 78.86 kB
  • 9,270 rows
  • 12 columns
Loading...
CREATE TABLE bad_sooden_allendorf_wikidataid_q564821 (
  "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 Staffelstein - Time Series For Statistical Variables

@datacommons.cities.bad_staffelstein_wikidataid_q504634
  • 68.51 kB
  • 9,659 rows
  • 12 columns
Loading...
CREATE TABLE bad_staffelstein_wikidataid_q504634 (
  "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.