Baselight
Sign In

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

Ballwin - Time Series For Statistical Variables

@datacommons.cities.ballwin_geoid_2903160
  • 3.38 MB
  • 363,520 rows
  • 12 columns
Loading... 
CREATE TABLE ballwin_geoid_2903160 (
  "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
);

Ballycastle - Time Series For Statistical Variables

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

Ballyconnell - Time Series For Statistical Variables

@datacommons.cities.ballyconnell_wikidataid_q252031
  • 50.27 kB
  • 6,321 rows
  • 12 columns
Loading... 
CREATE TABLE ballyconnell_wikidataid_q252031 (
  "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
);

Bally - Time Series For Statistical Variables

@datacommons.cities.bally_geoid_4203984
  • 3.06 MB
  • 354,596 rows
  • 12 columns
Loading... 
CREATE TABLE bally_geoid_4203984 (
  "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
);

Ballymena - Time Series For Statistical Variables

@datacommons.cities.ballymena_wikidataid_q805451
  • 54.76 kB
  • 6,604 rows
  • 12 columns
Loading... 
CREATE TABLE ballymena_wikidataid_q805451 (
  "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
);

Ballymoney - Time Series For Statistical Variables

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

Ballyragget - Time Series For Statistical Variables

@datacommons.cities.ballyragget_wikidataid_q2119844
  • 51.33 kB
  • 6,471 rows
  • 12 columns
Loading... 
CREATE TABLE ballyragget_wikidataid_q2119844 (
  "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
);

Ballyshannon - Time Series For Statistical Variables

@datacommons.cities.ballyshannon_wikidataid_q805462
  • 52.53 kB
  • 6,543 rows
  • 12 columns
Loading... 
CREATE TABLE ballyshannon_wikidataid_q805462 (
  "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
);

Bally - Time Series For Statistical Variables

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

Bally - Time Series For Statistical Variables

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

Balmazújváros - Time Series For Statistical Variables

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

Balm - Time Series For Statistical Variables

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

Balmoral - Time Series For Statistical Variables

@datacommons.cities.balmoral_wikidataid_q4852375
  • 54.16 kB
  • 6,652 rows
  • 12 columns
Loading... 
CREATE TABLE balmoral_wikidataid_q4852375 (
  "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
);

Balmorhea - Time Series For Statistical Variables

@datacommons.cities.balmorhea_geoid_4805468
  • 2.86 MB
  • 340,864 rows
  • 12 columns
Loading... 
CREATE TABLE balmorhea_geoid_4805468 (
  "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
);

Balmville - Time Series For Statistical Variables

@datacommons.cities.balmville_geoid_3604286
  • 3.1 MB
  • 356,699 rows
  • 12 columns
Loading... 
CREATE TABLE balmville_geoid_3604286 (
  "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
);

Balnarring Beach - Time Series For Statistical Variables

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

Balnarring - Time Series For Statistical Variables

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

Balninkai - Time Series For Statistical Variables

@datacommons.cities.balninkai_wikidataid_q2126478
  • 51.3 kB
  • 6,017 rows
  • 12 columns
Loading... 
CREATE TABLE balninkai_wikidataid_q2126478 (
  "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
);

Baloži - Time Series For Statistical Variables

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

Balranald - Time Series For Statistical Variables

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

Balsam Lake - Time Series For Statistical Variables

@datacommons.cities.balsam_lake_geoid_5504475
  • 3.01 MB
  • 352,274 rows
  • 12 columns
Loading... 
CREATE TABLE balsam_lake_geoid_5504475 (
  "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
);

Balsam Lake (town) - Time Series For Statistical Variables

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

Balsam Township - Time Series For Statistical Variables

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

Balsam Township - Time Series For Statistical Variables

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

Baltabay - Time Series For Statistical Variables

@datacommons.cities.baltabay_wikidataid_q4505892
  • 40.5 kB
  • 4,709 rows
  • 12 columns
Loading... 
CREATE TABLE baltabay_wikidataid_q4505892 (
  "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.