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

Amherst - Time Series For Statistical Variables

@datacommons.cities.amherst_geoid_2301185
  • 101.59 kB
  • 16,917 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_2301185 (
  "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_2501325
  • 100.98 kB
  • 15,752 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_2501325 (
  "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_3101290
  • 2.84 MB
  • 342,989 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_3101290 (
  "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_3301220
  • 2.93 MB
  • 347,425 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_3301220 (
  "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_3602000
  • 114.39 kB
  • 17,789 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_3602000 (
  "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_3901798
  • 3.31 MB
  • 359,835 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_3901798 (
  "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_4803084
  • 2.91 MB
  • 341,081 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_4803084 (
  "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_5101672
  • 3.1 MB
  • 356,031 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_5101672 (
  "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_5501750
  • 3.02 MB
  • 352,452 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_geoid_5501750 (
  "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 Junction - Time Series For Statistical Variables

@datacommons.cities.amherst_junction_geoid_5501800
  • 2.86 MB
  • 343,820 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_junction_geoid_5501800 (
  "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 Town - Time Series For Statistical Variables

@datacommons.cities.amherst_town_geoid_2501370
  • 1.27 MB
  • 73,136 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_town_geoid_2501370 (
  "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 Township - Time Series For Statistical Variables

@datacommons.cities.amherst_township_geoid_1990063
  • 76.68 kB
  • 12,631 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_township_geoid_1990063 (
  "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 Township - Time Series For Statistical Variables

@datacommons.cities.amherst_township_geoid_2701396
  • 74.7 kB
  • 12,406 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_township_geoid_2701396 (
  "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 Township - Time Series For Statistical Variables

@datacommons.cities.amherst_township_geoid_3901812
  • 95.34 kB
  • 15,140 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_township_geoid_3901812 (
  "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_wikidataid_q2323115
  • 101.02 kB
  • 15,809 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_wikidataid_q2323115 (
  "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_wikidataid_q470594
  • 87.26 kB
  • 13,573 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_wikidataid_q470594 (
  "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_wikidataid_q4746003
  • 59.37 kB
  • 7,370 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_wikidataid_q4746003 (
  "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_wikidataid_q4746017
  • 85.94 kB
  • 13,477 rows
  • 12 columns
Loading... 
CREATE TABLE amherst_wikidataid_q4746017 (
  "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
);

Amiais De Baixo - Time Series For Statistical Variables

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

Amidon - Time Series For Statistical Variables

@datacommons.cities.amidon_geoid_3802060
  • 2.62 MB
  • 330,901 rows
  • 12 columns
Loading... 
CREATE TABLE amidon_geoid_3802060 (
  "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
);

Amiens - Time Series For Statistical Variables

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

Amieva - Time Series For Statistical Variables

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

Aminshahr - Time Series For Statistical Variables

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

Amin Town - Time Series For Statistical Variables

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

Amioun - Time Series For Statistical Variables

@datacommons.cities.amioun_wikidataid_q25922
  • 41.44 kB
  • 5,003 rows
  • 12 columns
Loading... 
CREATE TABLE amioun_wikidataid_q25922 (
  "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.