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

Amery - Time Series For Statistical Variables

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

Amesbury (CDP), Massachusetts - Time Series For Statistical Variables

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

Amesbury - Time Series For Statistical Variables

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

Amesbury Town - Time Series For Statistical Variables

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

Amesbury - Time Series For Statistical Variables

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

Ames - Time Series For Statistical Variables

@datacommons.cities.ames_geoid_1901855
  • 3.64 MB
  • 371,845 rows
  • 12 columns
Loading... 
CREATE TABLE ames_geoid_1901855 (
  "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
);

Ames - Time Series For Statistical Variables

@datacommons.cities.ames_geoid_2001725
  • 872.94 kB
  • 61,881 rows
  • 12 columns
Loading... 
CREATE TABLE ames_geoid_2001725 (
  "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
);

Ames - Time Series For Statistical Variables

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

Ames - Time Series For Statistical Variables

@datacommons.cities.ames_geoid_3601737
  • 2.83 MB
  • 340,477 rows
  • 12 columns
Loading... 
CREATE TABLE ames_geoid_3601737 (
  "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
);

Ames - Time Series For Statistical Variables

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

Ames - Time Series For Statistical Variables

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

Ames Lake - Time Series For Statistical Variables

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

Amesti - Time Series For Statistical Variables

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

Ames Township - Time Series For Statistical Variables

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

Amesville - Time Series For Statistical Variables

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

Ames - Time Series For Statistical Variables

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

Am Ettersberg - Time Series For Statistical Variables

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

Amfikleia - Time Series For Statistical Variables

@datacommons.cities.amfikleia_wikidataid_q1752471
  • 43.26 kB
  • 4,963 rows
  • 12 columns
Loading... 
CREATE TABLE amfikleia_wikidataid_q1752471 (
  "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
);

Amfilochia - Time Series For Statistical Variables

@datacommons.cities.amfilochia_wikidataid_q470461
  • 41.61 kB
  • 4,955 rows
  • 12 columns
Loading... 
CREATE TABLE amfilochia_wikidataid_q470461 (
  "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
);

Amfissa - Time Series For Statistical Variables

@datacommons.cities.amfissa_wikidataid_q470481
  • 41.54 kB
  • 4,963 rows
  • 12 columns
Loading... 
CREATE TABLE amfissa_wikidataid_q470481 (
  "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
);

Amherstburg - Time Series For Statistical Variables

@datacommons.cities.amherstburg_wikidataid_q385335
  • 120.18 kB
  • 16,450 rows
  • 12 columns
Loading... 
CREATE TABLE amherstburg_wikidataid_q385335 (
  "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
);

Amherst Center - Time Series For Statistical Variables

@datacommons.cities.amherst_center_geoid_2501360
  • 3.01 MB
  • 305,329 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_center_geoid_2501360 (
  "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
);

Amherstdale - Time Series For Statistical Variables

@datacommons.cities.amherstdale_geoid_5401660
  • 2.74 MB
  • 334,121 rows
  • 12 columns
Loading... 
CREATE TABLE amherstdale_geoid_5401660 (
  "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
);

Amherstdale-Robinette - Time Series For Statistical Variables

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

Amherst - Time Series For Statistical Variables

@datacommons.cities.amherst_geoid_0801915
  • 2.67 MB
  • 329,400 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_0801915 (
  "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.