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

Albertskroon - Time Series For Statistical Variables

@datacommons.cities.albertskroon_wikidataid_q4712277
  • 58.64 kB
  • 7,076 rows
  • 12 columns
Loading...

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

Albertson - Time Series For Statistical Variables

@datacommons.cities.albertson_geoid_3601011
  • 3.13 MB
  • 358,463 rows
  • 12 columns
Loading...

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

Albertson Township - Time Series For Statistical Variables

@datacommons.cities.albertson_township_wikidataid_q6026937
  • 87.42 kB
  • 14,796 rows
  • 12 columns
Loading...

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

Albert Township - Time Series For Statistical Variables

@datacommons.cities.albert_township_geoid_2600940
  • 77.07 kB
  • 12,907 rows
  • 12 columns
Loading...

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

Albert Township - Time Series For Statistical Variables

@datacommons.cities.albert_township_geoid_3800980
  • 85.25 kB
  • 13,187 rows
  • 12 columns
Loading...

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

Albertville, Gauteng - Time Series For Statistical Variables

@datacommons.cities.albertville_gauteng_wikidataid_q4712299
  • 58.34 kB
  • 7,076 rows
  • 12 columns
Loading...

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

Albertville - Time Series For Statistical Variables

@datacommons.cities.albertville_geoid_0100988
  • 3.32 MB
  • 358,031 rows
  • 12 columns
Loading...

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

Albertville - Time Series For Statistical Variables

@datacommons.cities.albertville_geoid_2700730
  • 3.16 MB
  • 357,120 rows
  • 12 columns
Loading...

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

Albertville - Time Series For Statistical Variables

@datacommons.cities.albertville_wikidataid_q1998292
  • 9.38 kB
  • 1 row
  • 12 columns
Loading...

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

Albert - Time Series For Statistical Variables

@datacommons.cities.albert_wikidataid_q4709566
  • 42.26 kB
  • 4,901 rows
  • 12 columns
Loading...

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

Alberuela De La Liena - Time Series For Statistical Variables

@datacommons.cities.alberuela_de_la_liena_wikidataid_q8193672
  • 46.93 kB
  • 5,998 rows
  • 12 columns
Loading...

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

Alberuela De Tubo - Time Series For Statistical Variables

@datacommons.cities.alberuela_de_tubo_wikidataid_q24013444
  • 47.3 kB
  • 5,998 rows
  • 12 columns
Loading...

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

Albeta - Time Series For Statistical Variables

@datacommons.cities.albeta_wikidataid_q24016514
  • 57.78 kB
  • 7,490 rows
  • 12 columns
Loading...

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

Albia - Time Series For Statistical Variables

@datacommons.cities.albia_geoid_1900910
  • 3.15 MB
  • 356,094 rows
  • 12 columns
Loading...

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

Albiasu - Time Series For Statistical Variables

@datacommons.cities.albiasu_wikidataid_q2831877
  • 61.7 kB
  • 8,397 rows
  • 12 columns
Loading...

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

Albina - Time Series For Statistical Variables

@datacommons.cities.albina_wikidataid_q580016
  • 33.22 kB
  • 3,767 rows
  • 12 columns
Loading...

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

Albin - Time Series For Statistical Variables

@datacommons.cities.albin_geoid_5600825
  • 1.38 MB
  • 184,766 rows
  • 12 columns
Loading...

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

Albin Township - Time Series For Statistical Variables

@datacommons.cities.albin_township_geoid_2700748
  • 74.94 kB
  • 12,226 rows
  • 12 columns
Loading...

CREATE TABLE albin_township_geoid_2700748 (
  "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_0600716
  • 2.7 MB
  • 336,239 rows
  • 12 columns
Loading...

CREATE TABLE albion_geoid_0600716 (
  "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_1601000
  • 2.89 MB
  • 344,085 rows
  • 12 columns
Loading...

CREATE TABLE albion_geoid_1601000 (
  "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_1700568
  • 3.07 MB
  • 353,286 rows
  • 12 columns
Loading...

CREATE TABLE albion_geoid_1700568 (
  "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_1800820
  • 3.09 MB
  • 353,129 rows
  • 12 columns
Loading...

CREATE TABLE albion_geoid_1800820 (
  "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_1900955
  • 2.88 MB
  • 343,269 rows
  • 12 columns
Loading...

CREATE TABLE albion_geoid_1900955 (
  "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_2300590
  • 94.58 kB
  • 15,618 rows
  • 12 columns
Loading...

CREATE TABLE albion_geoid_2300590 (
  "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_2600980
  • 3.3 MB
  • 358,777 rows
  • 12 columns
Loading...

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