Baselight

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

Alleghenyville - Time Series For Statistical Variables

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

Alleghenyville - Time Series For Statistical Variables

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

Alleman - Time Series For Statistical Variables

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

Allemansdrift - Time Series For Statistical Variables

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

Allendale Charter Township - Time Series For Statistical Variables

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

Allendale East - Time Series For Statistical Variables

@datacommons.cities.allendale_east_wikidataid_q4731996
  • 72.17 kB
  • 9,879 rows
  • 12 columns
Loading...
CREATE TABLE allendale_east_wikidataid_q4731996 (
  "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
);

Allendale - Time Series For Statistical Variables

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

Allendale - Time Series For Statistical Variables

@datacommons.cities.allendale_geoid_1700815
  • 2.9 MB
  • 344,597 rows
  • 12 columns
Loading...
CREATE TABLE allendale_geoid_1700815 (
  "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
);

Allendale - Time Series For Statistical Variables

@datacommons.cities.allendale_geoid_2601340
  • 3.25 MB
  • 360,033 rows
  • 12 columns
Loading...
CREATE TABLE allendale_geoid_2601340 (
  "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
);

Allendale - Time Series For Statistical Variables

@datacommons.cities.allendale_geoid_2900712
  • 2.71 MB
  • 335,375 rows
  • 12 columns
Loading...
CREATE TABLE allendale_geoid_2900712 (
  "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
);

Allendale - Time Series For Statistical Variables

@datacommons.cities.allendale_geoid_3400700
  • 3.24 MB
  • 358,225 rows
  • 12 columns
Loading...
CREATE TABLE allendale_geoid_3400700 (
  "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
);

Allendale - Time Series For Statistical Variables

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

Allendale Township - Time Series For Statistical Variables

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

Allendale Township - Time Series For Statistical Variables

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

Allendale - Time Series For Statistical Variables

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

Allendorf (Lumda) - Time Series For Statistical Variables

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

Allendorf - Time Series For Statistical Variables

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

Allen - Time Series For Statistical Variables

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

Allen - Time Series For Statistical Variables

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

Allen - Time Series For Statistical Variables

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

Allen - Time Series For Statistical Variables

@datacommons.cities.allen_geoid_2601300
  • 1.44 MB
  • 188,655 rows
  • 12 columns
Loading...
CREATE TABLE allen_geoid_2601300 (
  "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
);

Allen - Time Series For Statistical Variables

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

Allen - Time Series For Statistical Variables

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

Allen - Time Series For Statistical Variables

@datacommons.cities.allen_geoid_4001400
  • 3 MB
  • 350,608 rows
  • 12 columns
Loading...
CREATE TABLE allen_geoid_4001400 (
  "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
);

Allen - Time Series For Statistical Variables

@datacommons.cities.allen_geoid_4600900
  • 2.72 MB
  • 333,006 rows
  • 12 columns
Loading...
CREATE TABLE allen_geoid_4600900 (
  "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.