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

Beeville - Time Series For Statistical Variables

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

Bega - Time Series For Statistical Variables

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

Beggs - Time Series For Statistical Variables

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

Begíjar - Time Series For Statistical Variables

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

Begusarai - Time Series For Statistical Variables

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

Behabad - Time Series For Statistical Variables

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

Behak Maken - Time Series For Statistical Variables

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

Behbahan - Time Series For Statistical Variables

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

Behchokǫ̀ - Time Series For Statistical Variables

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

Behiang Village - Time Series For Statistical Variables

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

Behiang - Time Series For Statistical Variables

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

Behrain - Time Series For Statistical Variables

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

Behshahr - Time Series For Statistical Variables

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

Bei'an - Time Series For Statistical Variables

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

Beica - Time Series For Statistical Variables

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

Beidou - Time Series For Statistical Variables

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

Beigang, Yunlin - Time Series For Statistical Variables

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

Beigan - Time Series For Statistical Variables

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

Beihai - Time Series For Statistical Variables

@datacommons.cities.beihai_wikidataid_q210365
  • 4.81 MB
  • 555,695 rows
  • 12 columns
Loading... 
CREATE TABLE beihai_wikidataid_q210365 (
  "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
);

Beijing - Time Series For Statistical Variables

@datacommons.cities.beijing_wikidataid_q956
  • 4.8 MB
  • 558,028 rows
  • 12 columns
Loading... 
CREATE TABLE beijing_wikidataid_q956 (
  "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
);

Beiliu - Time Series For Statistical Variables

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

Beilngries - Time Series For Statistical Variables

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

Beilstein - Time Series For Statistical Variables

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

Beilul - Time Series For Statistical Variables

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

Beinan - Time Series For Statistical Variables

@datacommons.cities.beinan_wikidataid_q712831
  • 47.06 kB
  • 5,855 rows
  • 12 columns
Loading... 
CREATE TABLE beinan_wikidataid_q712831 (
  "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.