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

Yalaha - Time Series For Statistical Variables

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

Yalata - Time Series For Statistical Variables

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

Yalavagi - Time Series For Statistical Variables

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

Yala - Time Series For Statistical Variables

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

Yalca - Time Series For Statistical Variables

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

Yale - Time Series For Statistical Variables

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

Yale - Time Series For Statistical Variables

@datacommons.cities.yale_geoid_1987285
  • 1.44 MB
  • 186,994 rows
  • 12 columns
Loading... 
CREATE TABLE yale_geoid_1987285 (
  "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
);

Yale - Time Series For Statistical Variables

@datacommons.cities.yale_geoid_2080650
  • 963.73 kB
  • 64,217 rows
  • 12 columns
Loading... 
CREATE TABLE yale_geoid_2080650 (
  "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
);

Yale - Time Series For Statistical Variables

@datacommons.cities.yale_geoid_2689000
  • 3.07 MB
  • 354,279 rows
  • 12 columns
Loading... 
CREATE TABLE yale_geoid_2689000 (
  "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
);

Yale - Time Series For Statistical Variables

@datacommons.cities.yale_geoid_4082500
  • 3.01 MB
  • 347,899 rows
  • 12 columns
Loading... 
CREATE TABLE yale_geoid_4082500 (
  "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
);

Yale - Time Series For Statistical Variables

@datacommons.cities.yale_geoid_4673020
  • 1.37 MB
  • 187,208 rows
  • 12 columns
Loading... 
CREATE TABLE yale_geoid_4673020 (
  "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
);

Yale Township, Valley County - Time Series For Statistical Variables

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

Yale - Time Series For Statistical Variables

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

Yalgogrin South - Time Series For Statistical Variables

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

Yalgoo - Time Series For Statistical Variables

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

Yallahs - Time Series For Statistical Variables

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

Yallakool - Time Series For Statistical Variables

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

Yallingup - Time Series For Statistical Variables

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

Yallourn - Time Series For Statistical Variables

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

Yallunda Flat - Time Series For Statistical Variables

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

Yalova - Time Series For Statistical Variables

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

Yalup Brook - Time Series For Statistical Variables

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

Yalutorovsk - Time Series For Statistical Variables

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

Yalwal - Time Series For Statistical Variables

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

Yamadamachi - Time Series For Statistical Variables

@datacommons.cities.yamadamachi_wikidataid_q11470536
  • 67.48 kB
  • 8,939 rows
  • 12 columns
Loading... 
CREATE TABLE yamadamachi_wikidataid_q11470536 (
  "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.