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

Aga - Time Series For Statistical Variables

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

Aga - Time Series For Statistical Variables

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

Agboville - Time Series For Statistical Variables

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

Agchia - Time Series For Statistical Variables

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

Agdam - Time Series For Statistical Variables

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

Agdash - Time Series For Statistical Variables

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

Agder Township - Time Series For Statistical Variables

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

Agematsu - Time Series For Statistical Variables

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

Agency - Time Series For Statistical Variables

@datacommons.cities.agency_geoid_1900640
  • 2.91 MB
  • 345,561 rows
  • 12 columns
Loading... 
CREATE TABLE agency_geoid_1900640 (
  "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
);

Agency - Time Series For Statistical Variables

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

Agency Township - Time Series For Statistical Variables

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

Agency Township - Time Series For Statistical Variables

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

Agency Township - Time Series For Statistical Variables

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

Agency Township - Time Series For Statistical Variables

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

Agency Township - Time Series For Statistical Variables

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

Agency Village - Time Series For Statistical Variables

@datacommons.cities.agency_village_geoid_4600520
  • 2.87 MB
  • 342,426 rows
  • 12 columns
Loading... 
CREATE TABLE agency_village_geoid_4600520 (
  "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
);

Agency - Time Series For Statistical Variables

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

Agenda - Time Series For Statistical Variables

@datacommons.cities.agenda_geoid_2000475
  • 1.36 MB
  • 184,813 rows
  • 12 columns
Loading... 
CREATE TABLE agenda_geoid_2000475 (
  "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
);

Agenda - Time Series For Statistical Variables

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

Ageo - Time Series For Statistical Variables

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

Agerskov - Time Series For Statistical Variables

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

Ages - Time Series For Statistical Variables

@datacommons.cities.ages_geoid_2100514
  • 2.61 MB
  • 295,957 rows
  • 12 columns
Loading... 
CREATE TABLE ages_geoid_2100514 (
  "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
);

Aggeneys - Time Series For Statistical Variables

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

Agger - Time Series For Statistical Variables

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

Aghajari - Time Series For Statistical Variables

@datacommons.cities.aghajari_wikidataid_q889045
  • 28.33 kB
  • 3,018 rows
  • 12 columns
Loading... 
CREATE TABLE aghajari_wikidataid_q889045 (
  "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.