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

Andersonville - Time Series For Statistical Variables

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

Anderson West Township - Time Series For Statistical Variables

@datacommons.cities.anderson_west_township_geoid_2901237
  • 90.56 kB
  • 13,701 rows
  • 12 columns
Loading... 
CREATE TABLE anderson_west_township_geoid_2901237 (
  "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
);

Anderson - Time Series For Statistical Variables

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

Anderston - Time Series For Statistical Variables

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

Andes - Time Series For Statistical Variables

@datacommons.cities.andes_geoid_3602121
  • 2.81 MB
  • 339,832 rows
  • 12 columns
Loading... 
CREATE TABLE andes_geoid_3602121 (
  "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
);

Andes - Time Series For Statistical Variables

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

Andice - Time Series For Statistical Variables

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

Andijan - Time Series For Statistical Variables

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

Andimeshk - Time Series For Statistical Variables

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

Andisheh - Time Series For Statistical Variables

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

Andkhoy - Time Series For Statistical Variables

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

Andkær - Time Series For Statistical Variables

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

Andělská Hora - Time Series For Statistical Variables

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

Andong - Time Series For Statistical Variables

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

Andorra: All Cities Or Breakdown By Cities Not Available - Time Series For Statistical Variables

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

Andorra La Vella - Time Series For Statistical Variables

@datacommons.cities.andorra_la_vella_wikidataid_q1863
  • 18.79 kB
  • 1,249 rows
  • 12 columns
Loading... 
CREATE TABLE andorra_la_vella_wikidataid_q1863 (
  "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
);

Andorra - Time Series For Statistical Variables

@datacommons.cities.andorra_wikidataid_q24003627
  • 21.58 kB
  • 1,971 rows
  • 12 columns
Loading... 
CREATE TABLE andorra_wikidataid_q24003627 (
  "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
);

Andosilla - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

@datacommons.cities.andover_geoid_1701491
  • 2.89 MB
  • 344,025 rows
  • 12 columns
Loading... 
CREATE TABLE andover_geoid_1701491 (
  "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
);

Andover - Time Series For Statistical Variables

@datacommons.cities.andover_geoid_1902080
  • 2.77 MB
  • 340,676 rows
  • 12 columns
Loading... 
CREATE TABLE andover_geoid_1902080 (
  "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
);

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

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

Andover - Time Series For Statistical Variables

@datacommons.cities.andover_geoid_2501430
  • 3.19 MB
  • 359,021 rows
  • 12 columns
Loading... 
CREATE TABLE andover_geoid_2501430 (
  "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.