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

Yarm - Time Series For Statistical Variables

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

Yarnell - Time Series For Statistical Variables

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

Yarnell - Time Series For Statistical Variables

@datacommons.cities.yarnell_geoid_4286936
  • 954.94 kB
  • 63,200 rows
  • 12 columns
Loading... 
CREATE TABLE yarnell_geoid_4286936 (
  "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
);

Yaroslavl - Time Series For Statistical Variables

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

Yarovoye - Time Series For Statistical Variables

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

Yarra Glen - Time Series For Statistical Variables

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

Yarragon - Time Series For Statistical Variables

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

Yarra Junction - Time Series For Statistical Variables

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

Yarraman - Time Series For Statistical Variables

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

Yarram - Time Series For Statistical Variables

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

Yarrawonga - Time Series For Statistical Variables

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

Yarroweyah - Time Series For Statistical Variables

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

Yarrow Point - Time Series For Statistical Variables

@datacommons.cities.yarrow_point_geoid_5380150
  • 2.96 MB
  • 348,035 rows
  • 12 columns
Loading... 
CREATE TABLE yarrow_point_geoid_5380150 (
  "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
);

Yarrowsburg - Time Series For Statistical Variables

@datacommons.cities.yarrowsburg_geoid_2487150
  • 2.66 MB
  • 329,575 rows
  • 12 columns
Loading... 
CREATE TABLE yarrowsburg_geoid_2487150 (
  "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
);

Yarrowyck - Time Series For Statistical Variables

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

Yartsevo - Time Series For Statistical Variables

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

Yashio - Time Series For Statistical Variables

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

Yashio - Time Series For Statistical Variables

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

Yasnogorsk - Time Series For Statistical Variables

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

Yasny - Time Series For Statistical Variables

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

Yasothon - Time Series For Statistical Variables

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

Yass - Time Series For Statistical Variables

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

Yasuda - Time Series For Statistical Variables

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

Yasugi - Time Series For Statistical Variables

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

Yasuj - Time Series For Statistical Variables

@datacommons.cities.yasuj_wikidataid_q383129
  • 33.51 kB
  • 3,342 rows
  • 12 columns
Loading... 
CREATE TABLE yasuj_wikidataid_q383129 (
  "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.