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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_3100555
  • 3.05 MB
  • 352,461 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_3601033
  • 3.19 MB
  • 357,064 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_4001050
  • 2.74 MB
  • 336,235 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_4200628
  • 3.07 MB
  • 355,855 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_5301010
  • 2.91 MB
  • 344,964 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_5500875
  • 95.13 kB
  • 15,107 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_5500900
  • 74.75 kB
  • 12,335 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_geoid_5500925
  • 93.9 kB
  • 15,043 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_1800838
  • 85.42 kB
  • 13,874 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_1990030
  • 93.52 kB
  • 14,913 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_1990033
  • 75.93 kB
  • 12,625 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_2000850
  • 92 kB
  • 14,664 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_2000875
  • 96.03 kB
  • 14,328 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_2000900
  • 92.36 kB
  • 14,723 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_2601000
  • 90.12 kB
  • 14,545 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_2700766
  • 97.35 kB
  • 15,103 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_geoid_3801060
  • 69.38 kB
  • 11,954 rows
  • 12 columns
Loading... 

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

Albion Township - Time Series For Statistical Variables

@datacommons.cities.albion_township_wikidataid_q11694023
  • 68.89 kB
  • 11,763 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_wikidataid_q4325183
  • 94.84 kB
  • 14,868 rows
  • 12 columns
Loading... 

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

Albion - Time Series For Statistical Variables

@datacommons.cities.albion_wikidataid_q4712477
  • 111.11 kB
  • 15,744 rows
  • 12 columns
Loading... 

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

@datacommons.cities.al_bireh_wikidataid_q311326
  • 65.57 kB
  • 8,758 rows
  • 12 columns
Loading... 

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

Alborn Township - Time Series For Statistical Variables

@datacommons.cities.alborn_township_geoid_2700820
  • 97.78 kB
  • 13,933 rows
  • 12 columns
Loading... 

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

Albright - Time Series For Statistical Variables

@datacommons.cities.albright_geoid_5400748
  • 1.43 MB
  • 187,843 rows
  • 12 columns
Loading... 

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

Albrightsville - Time Series For Statistical Variables

@datacommons.cities.albrightsville_geoid_4200652
  • 2.75 MB
  • 335,715 rows
  • 12 columns
Loading... 

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

Albright Township - Time Series For Statistical Variables

@datacommons.cities.albright_township_wikidataid_q6026941
  • 73.94 kB
  • 12,846 rows
  • 12 columns
Loading... 

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