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

Battonya - Time Series For Statistical Variables

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

Batu Arang - Time Series For Statistical Variables

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

Batuco - Time Series For Statistical Variables

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

Batu Kawan - Time Series For Statistical Variables

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

Batumi - Time Series For Statistical Variables

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

Batu Pahat - Time Series For Statistical Variables

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

Batu - Time Series For Statistical Variables

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

Batu - Time Series For Statistical Variables

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

Bat Yam - Time Series For Statistical Variables

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

Baubau - Time Series For Statistical Variables

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

Baucau - Time Series For Statistical Variables

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

Bauchi - Time Series For Statistical Variables

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

Baudette - Time Series For Statistical Variables

@datacommons.cities.baudette_geoid_2704024
  • 2.99 MB
  • 350,702 rows
  • 12 columns
Loading... 
CREATE TABLE baudette_geoid_2704024 (
  "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
);

Baudette Township - Time Series For Statistical Variables

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

Baughman Township - Time Series For Statistical Variables

@datacommons.cities.baughman_township_geoid_3904276
  • 94.85 kB
  • 15,045 rows
  • 12 columns
Loading... 
CREATE TABLE baughman_township_geoid_3904276 (
  "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
);

Baugo Township - Time Series For Statistical Variables

@datacommons.cities.baugo_township_geoid_1803754
  • 97.01 kB
  • 15,392 rows
  • 12 columns
Loading... 
CREATE TABLE baugo_township_geoid_1803754 (
  "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
);

Bauhinia - Time Series For Statistical Variables

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

Baumholder - Time Series For Statistical Variables

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

Baumstown - Time Series For Statistical Variables

@datacommons.cities.baumstown_geoid_4204488
  • 2.77 MB
  • 338,475 rows
  • 12 columns
Loading... 
CREATE TABLE baumstown_geoid_4204488 (
  "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
);

Baunach - Time Series For Statistical Variables

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

Baunatal - Time Series For Statistical Variables

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

Baures - Time Series For Statistical Variables

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

Baure - Time Series For Statistical Variables

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

Bauru - Time Series For Statistical Variables

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

Bausell And Ellis - Time Series For Statistical Variables

@datacommons.cities.bausell_and_ellis_wikidataid_q979052
  • 71.99 kB
  • 13,028 rows
  • 12 columns
Loading... 
CREATE TABLE bausell_and_ellis_wikidataid_q979052 (
  "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.