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

Avajiq - Time Series For Statistical Variables

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

Avaj - Time Series For Statistical Variables

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

Avalon - Time Series For Statistical Variables

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

Avalon - Time Series For Statistical Variables

@datacommons.cities.avalon_geoid_1202660
  • 2.78 MB
  • 337,161 rows
  • 12 columns
Loading... 
CREATE TABLE avalon_geoid_1202660 (
  "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
);

Avalon - Time Series For Statistical Variables

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

Avalon - Time Series For Statistical Variables

@datacommons.cities.avalon_geoid_2902692
  • 971.22 kB
  • 62,792 rows
  • 12 columns
Loading... 
CREATE TABLE avalon_geoid_2902692 (
  "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
);

Avalon - Time Series For Statistical Variables

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

Avalon - Time Series For Statistical Variables

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

Avanca - Time Series For Statistical Variables

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

Avangard - Time Series For Statistical Variables

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

Avanhandava - Time Series For Statistical Variables

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

Avant - Time Series For Statistical Variables

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

Avard - Time Series For Statistical Variables

@datacommons.cities.avard_geoid_4003550
  • 899.97 kB
  • 60,639 rows
  • 12 columns
Loading... 
CREATE TABLE avard_geoid_4003550 (
  "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
);

Avaré, São Paulo - Time Series For Statistical Variables

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

Avarua - Time Series For Statistical Variables

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

Avaí - Time Series For Statistical Variables

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

Avazak - Time Series For Statistical Variables

@datacommons.cities.avazak_wikidataid_q4827886
  • 82.95 kB
  • 11,247 rows
  • 12 columns
Loading... 
CREATE TABLE avazak_wikidataid_q4827886 (
  "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
);

Avdiivka - Time Series For Statistical Variables

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

Avdira - Time Series For Statistical Variables

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

Aveh - Time Series For Statistical Variables

@datacommons.cities.aveh_wikidataid_q2791851
  • 10.46 kB
  • 52 rows
  • 12 columns
Loading... 
CREATE TABLE aveh_wikidataid_q2791851 (
  "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
);

Aveiras De Cima - Time Series For Statistical Variables

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

Aveiro (city) - Time Series For Statistical Variables

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

Aveiro - Time Series For Statistical Variables

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

Avelar - Time Series For Statistical Variables

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

Aveley - Time Series For Statistical Variables

@datacommons.cities.aveley_wikidataid_q2449718
  • 79.17 kB
  • 10,952 rows
  • 12 columns
Loading... 
CREATE TABLE aveley_wikidataid_q2449718 (
  "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.