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

Albacete - Time Series For Statistical Variables

@datacommons.cities.albacete_wikidataid_q15095
  • 58.73 kB
  • 8,033 rows
  • 12 columns
Loading... 

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

Alba - Time Series For Statistical Variables

@datacommons.cities.alba_geoid_2600900
  • 2.8 MB
  • 339,870 rows
  • 12 columns
Loading... 

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

Alba - Time Series For Statistical Variables

@datacommons.cities.alba_geoid_2900496
  • 2.89 MB
  • 344,167 rows
  • 12 columns
Loading... 

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

Alba - Time Series For Statistical Variables

@datacommons.cities.alba_geoid_4200572
  • 2.74 MB
  • 339,350 rows
  • 12 columns
Loading... 

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

Alba - Time Series For Statistical Variables

@datacommons.cities.alba_geoid_4801636
  • 2.85 MB
  • 341,106 rows
  • 12 columns
Loading... 

CREATE TABLE alba_geoid_4801636 (
  "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 Bahah - Time Series For Statistical Variables

@datacommons.cities.al_bahah_wikidataid_q27176
  • 30.84 kB
  • 3,485 rows
  • 12 columns
Loading... 

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

Alba Iulia - Time Series For Statistical Variables

@datacommons.cities.alba_iulia_wikidataid_q174665
  • 38.14 kB
  • 4,305 rows
  • 12 columns
Loading... 

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

Albalate De Cinca - Time Series For Statistical Variables

@datacommons.cities.albalate_de_cinca_wikidataid_q24013449
  • 53.67 kB
  • 6,974 rows
  • 12 columns
Loading... 

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

Albalá De La Vega - Time Series For Statistical Variables

@datacommons.cities.albal_de_la_vega_wikidataid_q5662483
  • 10.9 kB
  • 144 rows
  • 12 columns
Loading... 

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

Alban - Time Series For Statistical Variables

@datacommons.cities.alban_geoid_5500725
  • 92.25 kB
  • 14,499 rows
  • 12 columns
Loading... 

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

Albanopolis - Time Series For Statistical Variables

@datacommons.cities.albanopolis_wikidataid_q2401418
  • 44.36 kB
  • 5,453 rows
  • 12 columns
Loading... 

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

Albano Township - Time Series For Statistical Variables

@datacommons.cities.albano_township_geoid_2000800
  • 72.85 kB
  • 12,492 rows
  • 12 columns
Loading... 

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

Alban Township - Time Series For Statistical Variables

@datacommons.cities.alban_township_geoid_4600580
  • 73.89 kB
  • 12,243 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_0600674
  • 3.36 MB
  • 363,427 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_1301052
  • 3.55 MB
  • 365,980 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_1700516
  • 2.93 MB
  • 347,020 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_1800802
  • 3.06 MB
  • 352,161 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_2100694
  • 3.04 MB
  • 351,583 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_2200835
  • 2.92 MB
  • 344,980 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_2700622
  • 3.1 MB
  • 355,428 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_2900514
  • 3.04 MB
  • 351,603 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_3300420
  • 92.88 kB
  • 15,062 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_3601000
  • 3.9 MB
  • 382,846 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_3901042
  • 2.95 MB
  • 344,428 rows
  • 12 columns
Loading... 

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

Albany - Time Series For Statistical Variables

@datacommons.cities.albany_geoid_4000950
  • 2.68 MB
  • 334,302 rows
  • 12 columns
Loading... 

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