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

Atmore - Time Series For Statistical Variables

@datacommons.cities.atmore_geoid_0103004
  • 3.19 MB
  • 353,156 rows
  • 12 columns
Loading...
CREATE TABLE atmore_geoid_0103004 (
  "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
);

Atoka - Time Series For Statistical Variables

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

Atoka - Time Series For Statistical Variables

@datacommons.cities.atoka_geoid_4003300
  • 3.15 MB
  • 353,553 rows
  • 12 columns
Loading...
CREATE TABLE atoka_geoid_4003300 (
  "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
);

Atoka - Time Series For Statistical Variables

@datacommons.cities.atoka_geoid_4702340
  • 3.22 MB
  • 356,747 rows
  • 12 columns
Loading...
CREATE TABLE atoka_geoid_4702340 (
  "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
);

Atomic City - Time Series For Statistical Variables

@datacommons.cities.atomic_city_geoid_1603970
  • 2.6 MB
  • 318,594 rows
  • 12 columns
Loading...
CREATE TABLE atomic_city_geoid_1603970 (
  "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
);

Atoyac - Time Series For Statistical Variables

@datacommons.cities.atoyac_undata_geo_c16800540
  • 9.2 kB
  • 1 row
  • 12 columns
Loading...
CREATE TABLE atoyac_undata_geo_c16800540 (
  "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
);

Atoyac - Time Series For Statistical Variables

@datacommons.cities.atoyac_undata_geo_c16801924
  • 9.2 kB
  • 1 row
  • 12 columns
Loading...
CREATE TABLE atoyac_undata_geo_c16801924 (
  "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
);

Atqasuk - Time Series For Statistical Variables

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

Atrato - Time Series For Statistical Variables

@datacommons.cities.atrato_undata_geo_c07500460
  • 9.22 kB
  • 1 row
  • 12 columns
Loading...
CREATE TABLE atrato_undata_geo_c07500460 (
  "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
);

Atru - Time Series For Statistical Variables

@datacommons.cities.atru_wikidataid_q24928005
  • 25.29 kB
  • 2,521 rows
  • 12 columns
Loading...
CREATE TABLE atru_wikidataid_q24928005 (
  "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
);

Atsion - Time Series For Statistical Variables

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

Atsugi - Time Series For Statistical Variables

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

Atsuma - Time Series For Statistical Variables

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

Attakulangara - Time Series For Statistical Variables

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

Attalla - Time Series For Statistical Variables

@datacommons.cities.attalla_geoid_0103028
  • 3.15 MB
  • 354,462 rows
  • 12 columns
Loading...
CREATE TABLE attalla_geoid_0103028 (
  "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
);

At Tannumah - Time Series For Statistical Variables

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

Attapeu - Time Series For Statistical Variables

@datacommons.cities.attapeu_wikidataid_q757905
  • 25.05 kB
  • 2,430 rows
  • 12 columns
Loading...
CREATE TABLE attapeu_wikidataid_q757905 (
  "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
);

Attapulgus - Time Series For Statistical Variables

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

Attapur - Time Series For Statistical Variables

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

Attari - Time Series For Statistical Variables

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

Attendorn - Time Series For Statistical Variables

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

Attica - Time Series For Statistical Variables

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

Attica - Time Series For Statistical Variables

@datacommons.cities.attica_geoid_2003100
  • 2.99 MB
  • 351,793 rows
  • 12 columns
Loading...
CREATE TABLE attica_geoid_2003100 (
  "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
);

Attica - Time Series For Statistical Variables

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

Attica - Time Series For Statistical Variables

@datacommons.cities.attica_geoid_3603001
  • 3.14 MB
  • 357,324 rows
  • 12 columns
Loading...
CREATE TABLE attica_geoid_3603001 (
  "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.