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

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

@datacommons.cities.aberdeen_geoid_2800180
  • 3.16 MB
  • 355,179 rows
  • 12 columns
Loading... 
CREATE TABLE aberdeen_geoid_2800180 (
  "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
);

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

@datacommons.cities.aberdeen_geoid_4600100
  • 3.45 MB
  • 364,079 rows
  • 12 columns
Loading... 
CREATE TABLE aberdeen_geoid_4600100 (
  "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
);

Aberdeen - Time Series For Statistical Variables

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

Aberdeen Proving Ground - Time Series For Statistical Variables

@datacommons.cities.aberdeen_proving_ground_geoid_2400175
  • 3.1 MB
  • 355,264 rows
  • 12 columns
Loading... 
CREATE TABLE aberdeen_proving_ground_geoid_2400175 (
  "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
);

Aberdeen Proving Ground - Time Series For Statistical Variables

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

Aberdeen Township - Time Series For Statistical Variables

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

Aberdeen Township - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

@datacommons.cities.aberdeen_wikidataid_q319416
  • 34.53 kB
  • 3,526 rows
  • 12 columns
Loading... 
CREATE TABLE aberdeen_wikidataid_q319416 (
  "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
);

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

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

Aberdeen - Time Series For Statistical Variables

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

Aberdovey - Time Series For Statistical Variables

@datacommons.cities.aberdovey_wikidataid_q319536
  • 52.48 kB
  • 5,658 rows
  • 12 columns
Loading... 
CREATE TABLE aberdovey_wikidataid_q319536 (
  "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
);

Aberfeldy - Time Series For Statistical Variables

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

Aberfeldy - Time Series For Statistical Variables

@datacommons.cities.aberfeldy_wikidataid_q319566
  • 47.28 kB
  • 5,654 rows
  • 12 columns
Loading... 
CREATE TABLE aberfeldy_wikidataid_q319566 (
  "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
);

Abergavenny - Time Series For Statistical Variables

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

Abergowrie - Time Series For Statistical Variables

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

Abermain - Time Series For Statistical Variables

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

Abernant - Time Series For Statistical Variables

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

Abernathy - Time Series For Statistical Variables

@datacommons.cities.abernathy_geoid_4800160
  • 3.11 MB
  • 355,611 rows
  • 12 columns
Loading... 
CREATE TABLE abernathy_geoid_4800160 (
  "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
);

Abernethy - Time Series For Statistical Variables

@datacommons.cities.abernethy_wikidataid_q4667149
  • 70.27 kB
  • 8,848 rows
  • 12 columns
Loading... 
CREATE TABLE abernethy_wikidataid_q4667149 (
  "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.