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

Ada - Time Series For Statistical Variables

@datacommons.cities.ada_geoid_2700172
  • 3.07 MB
  • 356,846 rows
  • 12 columns
Loading... 

CREATE TABLE ada_geoid_2700172 (
  "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
);

Ada - Time Series For Statistical Variables

@datacommons.cities.ada_geoid_3900198
  • 3.12 MB
  • 355,154 rows
  • 12 columns
Loading... 

CREATE TABLE ada_geoid_3900198 (
  "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
);

Ada - Time Series For Statistical Variables

@datacommons.cities.ada_geoid_4000200
  • 3.36 MB
  • 360,145 rows
  • 12 columns
Loading... 

CREATE TABLE ada_geoid_4000200 (
  "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
);

Adair - Time Series For Statistical Variables

@datacommons.cities.adair_geoid_1700178
  • 2.72 MB
  • 335,158 rows
  • 12 columns
Loading... 

CREATE TABLE adair_geoid_1700178 (
  "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
);

Adair - Time Series For Statistical Variables

@datacommons.cities.adair_geoid_1900370
  • 3.03 MB
  • 352,839 rows
  • 12 columns
Loading... 

CREATE TABLE adair_geoid_1900370 (
  "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
);

Adair - Time Series For Statistical Variables

@datacommons.cities.adair_geoid_4000250
  • 2.99 MB
  • 348,548 rows
  • 12 columns
Loading... 

CREATE TABLE adair_geoid_4000250 (
  "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
);

Adairsville - Time Series For Statistical Variables

@datacommons.cities.adairsville_geoid_1300436
  • 3.11 MB
  • 351,920 rows
  • 12 columns
Loading... 

CREATE TABLE adairsville_geoid_1300436 (
  "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
);

Adair Township - Time Series For Statistical Variables

@datacommons.cities.adair_township_geoid_2900190
  • 75.26 kB
  • 12,697 rows
  • 12 columns
Loading... 

CREATE TABLE adair_township_geoid_2900190 (
  "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
);

Adair Village - Time Series For Statistical Variables

@datacommons.cities.adair_village_geoid_4100275
  • 1.55 MB
  • 193,896 rows
  • 12 columns
Loading... 

CREATE TABLE adair_village_geoid_4100275 (
  "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
);

Adairville - Time Series For Statistical Variables

@datacommons.cities.adairville_geoid_2100298
  • 2.91 MB
  • 343,281 rows
  • 12 columns
Loading... 

CREATE TABLE adairville_geoid_2100298 (
  "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
);

Adak - Time Series For Statistical Variables

@datacommons.cities.adak_geoid_0200065
  • 1.39 MB
  • 183,979 rows
  • 12 columns
Loading... 

CREATE TABLE adak_geoid_0200065 (
  "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
);

Adaklu Waya - Time Series For Statistical Variables

@datacommons.cities.adaklu_waya_wikidataid_q20991114
  • 30.76 kB
  • 3,457 rows
  • 12 columns
Loading... 

CREATE TABLE adaklu_waya_wikidataid_q20991114 (
  "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
);

Adamantina - Time Series For Statistical Variables

@datacommons.cities.adamantina_wikidataid_q1637498
  • 33.45 kB
  • 2,904 rows
  • 12 columns
Loading... 

CREATE TABLE adamantina_wikidataid_q1637498 (
  "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
);

Adaminaby - Time Series For Statistical Variables

@datacommons.cities.adaminaby_wikidataid_q351613
  • 56.11 kB
  • 7,271 rows
  • 12 columns
Loading... 

CREATE TABLE adaminaby_wikidataid_q351613 (
  "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
);

Adamov - Time Series For Statistical Variables

@datacommons.cities.adamov_wikidataid_q158242
  • 62.82 kB
  • 7,777 rows
  • 12 columns
Loading... 

CREATE TABLE adamov_wikidataid_q158242 (
  "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
);

Adampur, Haryana - Time Series For Statistical Variables

@datacommons.cities.adampur_haryana_wikidataid_q24951933
  • 63.31 kB
  • 7,677 rows
  • 12 columns
Loading... 

CREATE TABLE adampur_haryana_wikidataid_q24951933 (
  "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
);

Adams Basin - Time Series For Statistical Variables

@datacommons.cities.adams_basin_geoid_3600221
  • 98.23 kB
  • 15,485 rows
  • 12 columns
Loading... 

CREATE TABLE adams_basin_geoid_3600221 (
  "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
);

Adamsburg - Time Series For Statistical Variables

@datacommons.cities.adamsburg_geoid_4200332
  • 2.8 MB
  • 341,775 rows
  • 12 columns
Loading... 

CREATE TABLE adamsburg_geoid_4200332 (
  "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
);

Adams Center - Time Series For Statistical Variables

@datacommons.cities.adams_center_geoid_3600232
  • 3 MB
  • 350,608 rows
  • 12 columns
Loading... 

CREATE TABLE adams_center_geoid_3600232 (
  "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
);

Adams - Time Series For Statistical Variables

@datacommons.cities.adams_geoid_1700191
  • 933.65 kB
  • 63,371 rows
  • 12 columns
Loading... 

CREATE TABLE adams_geoid_1700191 (
  "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
);

Adams - Time Series For Statistical Variables

@datacommons.cities.adams_geoid_1800352
  • 792.34 kB
  • 37,086 rows
  • 12 columns
Loading... 

CREATE TABLE adams_geoid_1800352 (
  "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
);

Adams - Time Series For Statistical Variables

@datacommons.cities.adams_geoid_2500555
  • 97.08 kB
  • 16,032 rows
  • 12 columns
Loading... 

CREATE TABLE adams_geoid_2500555 (
  "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
);

Adams - Time Series For Statistical Variables

@datacommons.cities.adams_geoid_2500590
  • 3.12 MB
  • 356,113 rows
  • 12 columns
Loading... 

CREATE TABLE adams_geoid_2500590 (
  "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
);

Adams - Time Series For Statistical Variables

@datacommons.cities.adams_geoid_2700190
  • 3.01 MB
  • 353,658 rows
  • 12 columns
Loading... 

CREATE TABLE adams_geoid_2700190 (
  "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
);

Adams - Time Series For Statistical Variables

@datacommons.cities.adams_geoid_3100240
  • 2.98 MB
  • 352,013 rows
  • 12 columns
Loading... 

CREATE TABLE adams_geoid_3100240 (
  "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.