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

Alford - Time Series For Statistical Variables

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

Alfred - Time Series For Statistical Variables

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

Alfred - Time Series For Statistical Variables

@datacommons.cities.alfred_geoid_2300730
  • 107.34 kB
  • 17,560 rows
  • 12 columns
Loading... 
CREATE TABLE alfred_geoid_2300730 (
  "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
);

Alfred - Time Series For Statistical Variables

@datacommons.cities.alfred_geoid_3601198
  • 3.09 MB
  • 353,754 rows
  • 12 columns
Loading... 
CREATE TABLE alfred_geoid_3601198 (
  "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
);

Alfred - Time Series For Statistical Variables

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

Alfred - Time Series For Statistical Variables

@datacommons.cities.alfred_geoid_4801816
  • 2.63 MB
  • 327,664 rows
  • 12 columns
Loading... 
CREATE TABLE alfred_geoid_4801816 (
  "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
);

Alfredo Marcondes - Time Series For Statistical Variables

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

Alfred-South La Paloma - Time Series For Statistical Variables

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

Alfredtown - Time Series For Statistical Variables

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

Alfreton - Time Series For Statistical Variables

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

Alfsborg Township - Time Series For Statistical Variables

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

Al-Fu'ah - Time Series For Statistical Variables

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

Al-Fukhari - Time Series For Statistical Variables

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

Algameca - Time Series For Statistical Variables

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

Algansee Township - Time Series For Statistical Variables

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

Algapur - Time Series For Statistical Variables

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

Alger - Time Series For Statistical Variables

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

Alger - Time Series For Statistical Variables

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

Algernon Township, Custer County, Nebraska - Time Series For Statistical Variables

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

Alger Township - Time Series For Statistical Variables

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

Algestrup - Time Series For Statistical Variables

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

Al Gharraf - Time Series For Statistical Variables

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

Al Ghuwariyah - Time Series For Statistical Variables

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

Algiers - Time Series For Statistical Variables

@datacommons.cities.algiers_geoid_5001035
  • 1 MB
  • 63,754 rows
  • 12 columns
Loading... 
CREATE TABLE algiers_geoid_5001035 (
  "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
);

Algiers - Time Series For Statistical Variables

@datacommons.cities.algiers_wikidataid_q3561
  • 69.74 kB
  • 9,602 rows
  • 12 columns
Loading... 
CREATE TABLE algiers_wikidataid_q3561 (
  "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.