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

Yamada - Time Series For Statistical Variables

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

Yamagata - Time Series For Statistical Variables

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

Yamagata - Time Series For Statistical Variables

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

Yamaga - Time Series For Statistical Variables

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

Yamaguchi - Time Series For Statistical Variables

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

Yamakita - Time Series For Statistical Variables

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

Yamamoto - Time Series For Statistical Variables

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

Yamanashi - Time Series For Statistical Variables

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

Yamanobe - Time Series For Statistical Variables

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

Yamanouchi - Time Series For Statistical Variables

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

Yamatochō - Time Series For Statistical Variables

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

Yamatokoriyama - Time Series For Statistical Variables

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

Yamatotakada - Time Series For Statistical Variables

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

Yamato - Time Series For Statistical Variables

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

Yamato - Time Series For Statistical Variables

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

Yamatsuri - Time Series For Statistical Variables

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

Yamazakimachi - Time Series For Statistical Variables

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

Yamazaki - Time Series For Statistical Variables

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

Yamba - Time Series For Statistical Variables

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

Yambol - Time Series For Statistical Variables

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

Yambuk - Time Series For Statistical Variables

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

Yamchi - Time Series For Statistical Variables

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

Yame - Time Series For Statistical Variables

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

Yamhill - Time Series For Statistical Variables

@datacommons.cities.yamhill_geoid_4184250
  • 3.03 MB
  • 349,967 rows
  • 12 columns
Loading... 
CREATE TABLE yamhill_geoid_4184250 (
  "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
);

Yamoussoukro - Time Series For Statistical Variables

@datacommons.cities.yamoussoukro_wikidataid_q3768
  • 38.64 kB
  • 4,364 rows
  • 12 columns
Loading... 
CREATE TABLE yamoussoukro_wikidataid_q3768 (
  "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.