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

Yulin - Time Series For Statistical Variables

@datacommons.cities.yulin_wikidataid_q515712
  • 4.74 MB
  • 557,696 rows
  • 12 columns
Loading... 

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

Yulin - Time Series For Statistical Variables

@datacommons.cities.yulin_wikidataid_q571918
  • 4.76 MB
  • 552,927 rows
  • 12 columns
Loading... 

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

Yuli - Time Series For Statistical Variables

@datacommons.cities.yuli_wikidataid_q709009
  • 27.54 kB
  • 2,728 rows
  • 12 columns
Loading... 

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

Yuma - Time Series For Statistical Variables

@datacommons.cities.yuma_geoid_0485540
  • 4.02 MB
  • 388,423 rows
  • 12 columns
Loading... 

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

Yuma - Time Series For Statistical Variables

@datacommons.cities.yuma_geoid_0886750
  • 3.11 MB
  • 352,568 rows
  • 12 columns
Loading... 

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

Yuma - Time Series For Statistical Variables

@datacommons.cities.yuma_geoid_4782440
  • 941.39 kB
  • 61,911 rows
  • 12 columns
Loading... 

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

Yumali - Time Series For Statistical Variables

@datacommons.cities.yumali_wikidataid_q8061057
  • 49.36 kB
  • 6,366 rows
  • 12 columns
Loading... 

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

Yuma Proving Ground - Time Series For Statistical Variables

@datacommons.cities.yuma_proving_ground_geoid_0485680
  • 955.88 kB
  • 63,561 rows
  • 12 columns
Loading... 

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

Yumbel - Time Series For Statistical Variables

@datacommons.cities.yumbel_wikidataid_q23660242
  • 21.92 kB
  • 1,997 rows
  • 12 columns
Loading... 

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

Yumbo - Time Series For Statistical Variables

@datacommons.cities.yumbo_undata_geo_c07501096
  • 9.26 kB
  • 2 rows
  • 12 columns
Loading... 

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

Yumen City - Time Series For Statistical Variables

@datacommons.cities.yumen_city_wikidataid_q729562
  • 9.48 kB
  • 5 rows
  • 12 columns
Loading... 

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

Yuncheng - Time Series For Statistical Variables

@datacommons.cities.yuncheng_wikidataid_q73073
  • 4.75 MB
  • 557,160 rows
  • 12 columns
Loading... 

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

Yundool - Time Series For Statistical Variables

@datacommons.cities.yundool_wikidataid_q8061226
  • 62.7 kB
  • 7,344 rows
  • 12 columns
Loading... 

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

Yunesi - Time Series For Statistical Variables

@datacommons.cities.yunesi_wikidataid_q1770119
  • 29.1 kB
  • 3,173 rows
  • 12 columns
Loading... 

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

Yunfu - Time Series For Statistical Variables

@datacommons.cities.yunfu_wikidataid_q59233
  • 4.79 MB
  • 555,653 rows
  • 12 columns
Loading... 

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

Yungaburra - Time Series For Statistical Variables

@datacommons.cities.yungaburra_wikidataid_q1580463
  • 75.23 kB
  • 9,976 rows
  • 12 columns
Loading... 

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

Yungay - Time Series For Statistical Variables

@datacommons.cities.yungay_wikidataid_q20022220
  • 20.94 kB
  • 1,784 rows
  • 12 columns
Loading... 

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

Yungay - Time Series For Statistical Variables

@datacommons.cities.yungay_wikidataid_q919678
  • 24.03 kB
  • 2,443 rows
  • 12 columns
Loading... 

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

Yunguyo - Time Series For Statistical Variables

@datacommons.cities.yunguyo_wikidataid_q2306609
  • 9.31 kB
  • 1 row
  • 12 columns
Loading... 

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

Yuni - Time Series For Statistical Variables

@datacommons.cities.yuni_wikidataid_q1355570
  • 69 kB
  • 8,825 rows
  • 12 columns
Loading... 

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

Yunokomunarivsk - Time Series For Statistical Variables

@datacommons.cities.yunokomunarivsk_wikidataid_q570563
  • 64.52 kB
  • 8,166 rows
  • 12 columns
Loading... 

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

Yunomae - Time Series For Statistical Variables

@datacommons.cities.yunomae_wikidataid_q1184768
  • 55.63 kB
  • 6,878 rows
  • 12 columns
Loading... 

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

Yunyarinyi - Time Series For Statistical Variables

@datacommons.cities.yunyarinyi_wikidataid_q18079
  • 13.15 kB
  • 624 rows
  • 12 columns
Loading... 

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

Yura - Time Series For Statistical Variables

@datacommons.cities.yura_wikidataid_q1203250
  • 58.33 kB
  • 7,348 rows
  • 12 columns
Loading... 

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

Yurga - Time Series For Statistical Variables

@datacommons.cities.yurga_wikidataid_q198824
  • 55.91 kB
  • 7,278 rows
  • 12 columns
Loading... 

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