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

Yaguachi - Time Series For Statistical Variables

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

Yaguarón - Time Series For Statistical Variables

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

Yaguará - Time Series For Statistical Variables

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

Yaguarú - Time Series For Statistical Variables

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

Yaguchi - Time Series For Statistical Variables

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

Yahaba - Time Series For Statistical Variables

@datacommons.cities.yahaba_wikidataid_q1205709
  • 63.32 kB
  • 8,112 rows
  • 12 columns
Loading... 
CREATE TABLE yahaba_wikidataid_q1205709 (
  "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
);

Yahatachō - Time Series For Statistical Variables

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

Yahmur - Time Series For Statistical Variables

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

Yahotyn - Time Series For Statistical Variables

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

Yah-ta-hey - Time Series For Statistical Variables

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

Yaita - Time Series For Statistical Variables

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

Yaizu - Time Series For Statistical Variables

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

Yakage - Time Series For Statistical Variables

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

Yakeshi - Time Series For Statistical Variables

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

Yakhroma - Time Series For Statistical Variables

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

Yakima - Time Series For Statistical Variables

@datacommons.cities.yakima_geoid_5380010
  • 4.06 MB
  • 390,531 rows
  • 12 columns
Loading... 
CREATE TABLE yakima_geoid_5380010 (
  "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
);

Yakınca - Time Series For Statistical Variables

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

Yakoruda - Time Series For Statistical Variables

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

Yakumo - Time Series For Statistical Variables

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

Yakushidai - Time Series For Statistical Variables

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

Yakushima - Time Series For Statistical Variables

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

Yakutat - Time Series For Statistical Variables

@datacommons.cities.yakutat_geoid_02282
  • 33 MB
  • 3,364,070 rows
  • 12 columns
Loading... 
CREATE TABLE yakutat_geoid_02282 (
  "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
);

Yakutat - Time Series For Statistical Variables

@datacommons.cities.yakutat_geoid_0286490
  • 1.59 MB
  • 199,667 rows
  • 12 columns
Loading... 
CREATE TABLE yakutat_geoid_0286490 (
  "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
);

Yakutsk - Time Series For Statistical Variables

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

Yakō - Time Series For Statistical Variables

@datacommons.cities.yak_wikidataid_q11431231
  • 68.89 kB
  • 9,728 rows
  • 12 columns
Loading... 
CREATE TABLE yak_wikidataid_q11431231 (
  "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.