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

Akkeshi - Time Series For Statistical Variables

@datacommons.cities.akkeshi_wikidataid_q419720
  • 62.03 kB
  • 7,938 rows
  • 12 columns
Loading... 

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

Aklavik - Time Series For Statistical Variables

@datacommons.cities.aklavik_wikidataid_q420187
  • 54.8 kB
  • 8,084 rows
  • 12 columns
Loading... 

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

Akmenė - Time Series For Statistical Variables

@datacommons.cities.akmen_wikidataid_q1023044
  • 74.17 kB
  • 8,669 rows
  • 12 columns
Loading... 

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

Aknīste - Time Series For Statistical Variables

@datacommons.cities.akn_ste_wikidataid_q420333
  • 30.39 kB
  • 3,239 rows
  • 12 columns
Loading... 

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

Akok - Time Series For Statistical Variables

@datacommons.cities.akok_wikidataid_q2829115
  • 42.45 kB
  • 5,263 rows
  • 12 columns
Loading... 

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

Akola - Time Series For Statistical Variables

@datacommons.cities.akola_wikidataid_q213014
  • 61.15 kB
  • 7,345 rows
  • 12 columns
Loading... 

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

Akonolinga - Time Series For Statistical Variables

@datacommons.cities.akonolinga_wikidataid_q2829121
  • 9.42 kB
  • 1 row
  • 12 columns
Loading... 

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

Akora Khattak - Time Series For Statistical Variables

@datacommons.cities.akora_khattak_wikidataid_q2475251
  • 13.33 kB
  • 582 rows
  • 12 columns
Loading... 

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

Akranes - Time Series For Statistical Variables

@datacommons.cities.akranes_wikidataid_q107398
  • 71.59 kB
  • 9,841 rows
  • 12 columns
Loading... 

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

Akra Township - Time Series For Statistical Variables

@datacommons.cities.akra_township_geoid_3800900
  • 83.9 kB
  • 13,438 rows
  • 12 columns
Loading... 

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

Akridge - Time Series For Statistical Variables

@datacommons.cities.akridge_wikidataid_q4701636
  • 77.52 kB
  • 13,873 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_0100676
  • 2.8 MB
  • 340,413 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_0800925
  • 3.1 MB
  • 355,076 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_1800748
  • 3.03 MB
  • 351,325 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_1900775
  • 3.06 MB
  • 354,451 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_2600700
  • 2.89 MB
  • 345,221 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_3600441
  • 3.13 MB
  • 356,256 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_3901000
  • 4.15 MB
  • 390,013 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_geoid_4200540
  • 3.13 MB
  • 356,742 rows
  • 12 columns
Loading... 

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

Akron Junction - Time Series For Statistical Variables

@datacommons.cities.akron_junction_geoid_3600452
  • 99.34 kB
  • 15,934 rows
  • 12 columns
Loading... 

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

Akron Township - Time Series For Statistical Variables

@datacommons.cities.akron_township_geoid_1700477
  • 94.74 kB
  • 15,116 rows
  • 12 columns
Loading... 

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

Akron Township - Time Series For Statistical Variables

@datacommons.cities.akron_township_geoid_2600720
  • 94.84 kB
  • 14,121 rows
  • 12 columns
Loading... 

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

Akron Township - Time Series For Statistical Variables

@datacommons.cities.akron_township_geoid_2700532
  • 75.68 kB
  • 12,389 rows
  • 12 columns
Loading... 

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

Akron Township - Time Series For Statistical Variables

@datacommons.cities.akron_township_geoid_2700550
  • 81.48 kB
  • 13,174 rows
  • 12 columns
Loading... 

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

Akron - Time Series For Statistical Variables

@datacommons.cities.akron_wikidataid_q2290421
  • 98.59 kB
  • 14,545 rows
  • 12 columns
Loading... 

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