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

Amelia - Time Series For Statistical Variables

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

Amelia - Time Series For Statistical Variables

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

Amelia - Time Series For Statistical Variables

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

Ameneiro - Time Series For Statistical Variables

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

Amenia - Time Series For Statistical Variables

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

Amenia - Time Series For Statistical Variables

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

Amenia - Time Series For Statistical Variables

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

Amenia Township - Time Series For Statistical Variables

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

Americana - Time Series For Statistical Variables

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

American Canyon - Time Series For Statistical Variables

@datacommons.cities.american_canyon_geoid_0601640
  • 3.41 MB
  • 363,598 rows
  • 12 columns
Loading... 
CREATE TABLE american_canyon_geoid_0601640 (
  "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
);

American Falls - Time Series For Statistical Variables

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

American Fork - Time Series For Statistical Variables

@datacommons.cities.american_fork_geoid_4901310
  • 3.42 MB
  • 363,934 rows
  • 12 columns
Loading... 
CREATE TABLE american_fork_geoid_4901310 (
  "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
);

American River - Time Series For Statistical Variables

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

American Township - Time Series For Statistical Variables

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

America Township - Time Series For Statistical Variables

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

America Township - Time Series For Statistical Variables

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

Americus - Time Series For Statistical Variables

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

Americus - Time Series For Statistical Variables

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

Americus - Time Series For Statistical Variables

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

Americus Township - Time Series For Statistical Variables

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

Americus Township - Time Series For Statistical Variables

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

Amersfoort - Time Series For Statistical Variables

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

Amersfoort - Time Series For Statistical Variables

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

Amersham - Time Series For Statistical Variables

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

Amery - Time Series For Statistical Variables

@datacommons.cities.amery_geoid_5501725
  • 3.07 MB
  • 351,627 rows
  • 12 columns
Loading... 
CREATE TABLE amery_geoid_5501725 (
  "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.