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

Abington - Time Series For Statistical Variables

@datacommons.cities.abington_geoid_2500135
  • 3.22 MB
  • 358,773 rows
  • 12 columns
Loading...

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

Abington - Time Series For Statistical Variables

@datacommons.cities.abington_geoid_2500170
  • 111.06 kB
  • 17,820 rows
  • 12 columns
Loading...

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

Abington Township - Time Series For Statistical Variables

@datacommons.cities.abington_township_geoid_1700126
  • 97.37 kB
  • 15,339 rows
  • 12 columns
Loading...

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

Abington Township - Time Series For Statistical Variables

@datacommons.cities.abington_township_geoid_1800172
  • 80.12 kB
  • 13,106 rows
  • 12 columns
Loading...

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

Abington Township - Time Series For Statistical Variables

@datacommons.cities.abington_township_wikidataid_q2222550
  • 99.83 kB
  • 15,825 rows
  • 12 columns
Loading...

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

Abinsk - Time Series For Statistical Variables

@datacommons.cities.abinsk_wikidataid_q15762
  • 51.28 kB
  • 6,045 rows
  • 12 columns
Loading...

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

Abiquiu - Time Series For Statistical Variables

@datacommons.cities.abiquiu_geoid_3500310
  • 2.6 MB
  • 318,034 rows
  • 12 columns
Loading...

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

Abira - Time Series For Statistical Variables

@datacommons.cities.abira_wikidataid_q1354084
  • 59.76 kB
  • 7,783 rows
  • 12 columns
Loading...

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

Abish Ahmad - Time Series For Statistical Variables

@datacommons.cities.abish_ahmad_wikidataid_q4371167
  • 15.77 kB
  • 796 rows
  • 12 columns
Loading...

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

Abita Springs - Time Series For Statistical Variables

@datacommons.cities.abita_springs_geoid_2200240
  • 3.05 MB
  • 352,992 rows
  • 12 columns
Loading...

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

Abita Springs - Time Series For Statistical Variables

@datacommons.cities.abita_springs_wikidataid_q3193360
  • 67.58 kB
  • 12,752 rows
  • 12 columns
Loading...

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

Abizanda - Time Series For Statistical Variables

@datacommons.cities.abizanda_wikidataid_q24013453
  • 49.41 kB
  • 5,998 rows
  • 12 columns
Loading...

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

Abja-Paluoja - Time Series For Statistical Variables

@datacommons.cities.abja_paluoja_wikidataid_q321784
  • 59.1 kB
  • 7,356 rows
  • 12 columns
Loading...

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

Ablitas - Time Series For Statistical Variables

@datacommons.cities.ablitas_wikidataid_q322437
  • 26.55 kB
  • 2,909 rows
  • 12 columns
Loading...

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

Abney Crossroads - Time Series For Statistical Variables

@datacommons.cities.abney_crossroads_geoid_4500165
  • 924.62 kB
  • 61,111 rows
  • 12 columns
Loading...

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

Aboisso - Time Series For Statistical Variables

@datacommons.cities.aboisso_wikidataid_q521322
  • 49.56 kB
  • 6,225 rows
  • 12 columns
Loading...

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

Aboite Township - Time Series For Statistical Variables

@datacommons.cities.aboite_township_geoid_1800208
  • 97.32 kB
  • 15,453 rows
  • 12 columns
Loading...

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

Abole - Time Series For Statistical Variables

@datacommons.cities.abole_wikidataid_q2821689
  • 41.22 kB
  • 5,187 rows
  • 12 columns
Loading...

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

Abomey - Time Series For Statistical Variables

@datacommons.cities.abomey_wikidataid_q189685
  • 41.65 kB
  • 4,912 rows
  • 12 columns
Loading...

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

Abomsa - Time Series For Statistical Variables

@datacommons.cities.abomsa_wikidataid_q2821705
  • 37.65 kB
  • 4,611 rows
  • 12 columns
Loading...

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

Abong-Mbang - Time Series For Statistical Variables

@datacommons.cities.abong_mbang_wikidataid_q322917
  • 19.46 kB
  • 1,587 rows
  • 12 columns
Loading...

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

Abony - Time Series For Statistical Variables

@datacommons.cities.abony_wikidataid_q480421
  • 52.37 kB
  • 5,860 rows
  • 12 columns
Loading...

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

Abovyan - Time Series For Statistical Variables

@datacommons.cities.abovyan_wikidataid_q31493
  • 83.92 kB
  • 11,208 rows
  • 12 columns
Loading...

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

Ab Pakhsh - Time Series For Statistical Variables

@datacommons.cities.ab_pakhsh_wikidataid_q2634509
  • 12.58 kB
  • 496 rows
  • 12 columns
Loading...

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

Abū Qurqāş - Time Series For Statistical Variables

@datacommons.cities.ab_qurq_wikidataid_q28445605
  • 42 kB
  • 5,577 rows
  • 12 columns
Loading...

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