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

Avon - Time Series For Statistical Variables

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

Avon - Time Series For Statistical Variables

@datacommons.cities.avon_geoid_3702780
  • 2.76 MB
  • 336,031 rows
  • 12 columns
Loading... 
CREATE TABLE avon_geoid_3702780 (
  "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
);

Avon - Time Series For Statistical Variables

@datacommons.cities.avon_geoid_3903352
  • 3.32 MB
  • 360,420 rows
  • 12 columns
Loading... 
CREATE TABLE avon_geoid_3903352 (
  "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
);

Avon - Time Series For Statistical Variables

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

Avon - Time Series For Statistical Variables

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

Avon - Time Series For Statistical Variables

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

Avon - Time Series For Statistical Variables

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

Avonia - Time Series For Statistical Variables

@datacommons.cities.avonia_geoid_4203676
  • 2.9 MB
  • 343,877 rows
  • 12 columns
Loading... 
CREATE TABLE avonia_geoid_4203676 (
  "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
);

Avonia - Time Series For Statistical Variables

@datacommons.cities.avonia_wikidataid_q1132239
  • 93.64 kB
  • 14,807 rows
  • 12 columns
Loading... 
CREATE TABLE avonia_wikidataid_q1132239 (
  "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
);

Avon Lake - Time Series For Statistical Variables

@datacommons.cities.avon_lake_geoid_3903464
  • 3.33 MB
  • 359,959 rows
  • 12 columns
Loading... 
CREATE TABLE avon_lake_geoid_3903464 (
  "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
);

Avonmore - Time Series For Statistical Variables

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

Avon Park - Time Series For Statistical Variables

@datacommons.cities.avon_park_geoid_1202750
  • 3.2 MB
  • 355,324 rows
  • 12 columns
Loading... 
CREATE TABLE avon_park_geoid_1202750 (
  "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
);

Avonsleigh - Time Series For Statistical Variables

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

Avon Township - Time Series For Statistical Variables

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

Avon Township - Time Series For Statistical Variables

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

Avon Township - Time Series For Statistical Variables

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

Avon Township - Time Series For Statistical Variables

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

Avon Township - Time Series For Statistical Variables

@datacommons.cities.avon_township_geoid_3803940
  • 96.78 kB
  • 14,873 rows
  • 12 columns
Loading... 
CREATE TABLE avon_township_geoid_3803940 (
  "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
);

Avontuur - Time Series For Statistical Variables

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

Avon - Time Series For Statistical Variables

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

Avon - Time Series For Statistical Variables

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

Avra Valley - Time Series For Statistical Variables

@datacommons.cities.avra_valley_geoid_0404880
  • 3.03 MB
  • 348,531 rows
  • 12 columns
Loading... 
CREATE TABLE avra_valley_geoid_0404880 (
  "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
);

Avrig - Time Series For Statistical Variables

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

Avô - Time Series For Statistical Variables

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

Awaji - Time Series For Statistical Variables

@datacommons.cities.awaji_wikidataid_q373107
  • 59.97 kB
  • 7,399 rows
  • 12 columns
Loading... 
CREATE TABLE awaji_wikidataid_q373107 (
  "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.