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

Bearsden - Time Series For Statistical Variables

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

Bearsville - Time Series For Statistical Variables

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

Bear Valley - Time Series For Statistical Variables

@datacommons.cities.bear_valley_geoid_0604716
  • 2.7 MB
  • 333,799 rows
  • 12 columns
Loading... 
CREATE TABLE bear_valley_geoid_0604716 (
  "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
);

Bear Valley - Time Series For Statistical Variables

@datacommons.cities.bear_valley_geoid_0604730
  • 2.7 MB
  • 335,328 rows
  • 12 columns
Loading... 
CREATE TABLE bear_valley_geoid_0604730 (
  "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
);

Bear Valley Springs - Time Series For Statistical Variables

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

Bearville Township - Time Series For Statistical Variables

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

Beasley - Time Series For Statistical Variables

@datacommons.cities.beasley_geoid_4806272
  • 2.9 MB
  • 344,029 rows
  • 12 columns
Loading... 
CREATE TABLE beasley_geoid_4806272 (
  "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
);

Beason - Time Series For Statistical Variables

@datacommons.cities.beason_geoid_1704403
  • 2.74 MB
  • 336,835 rows
  • 12 columns
Loading... 
CREATE TABLE beason_geoid_1704403 (
  "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
);

Beatrice - Time Series For Statistical Variables

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

Beatrice - Time Series For Statistical Variables

@datacommons.cities.beatrice_geoid_3103390
  • 3.31 MB
  • 357,183 rows
  • 12 columns
Loading... 
CREATE TABLE beatrice_geoid_3103390 (
  "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
);

Beattie - Time Series For Statistical Variables

@datacommons.cities.beattie_geoid_2004900
  • 2.84 MB
  • 341,365 rows
  • 12 columns
Loading... 
CREATE TABLE beattie_geoid_2004900 (
  "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
);

Beatty - Time Series For Statistical Variables

@datacommons.cities.beatty_geoid_3205100
  • 2.79 MB
  • 336,515 rows
  • 12 columns
Loading... 
CREATE TABLE beatty_geoid_3205100 (
  "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
);

Beatty - Time Series For Statistical Variables

@datacommons.cities.beatty_geoid_4105150
  • 2.49 MB
  • 300,462 rows
  • 12 columns
Loading... 
CREATE TABLE beatty_geoid_4105150 (
  "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
);

Beattystown - Time Series For Statistical Variables

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

Beatty Township - Time Series For Statistical Variables

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

Beattyville - Time Series For Statistical Variables

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

Beauceville - Time Series For Statistical Variables

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

Beaucoup Township - Time Series For Statistical Variables

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

Beaudesert - Time Series For Statistical Variables

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

Beauford Township - Time Series For Statistical Variables

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

Beaufort - Time Series For Statistical Variables

@datacommons.cities.beaufort_geoid_3704260
  • 3.2 MB
  • 356,535 rows
  • 12 columns
Loading... 
CREATE TABLE beaufort_geoid_3704260 (
  "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
);

Beaufort - Time Series For Statistical Variables

@datacommons.cities.beaufort_geoid_4504690
  • 3.33 MB
  • 360,006 rows
  • 12 columns
Loading... 
CREATE TABLE beaufort_geoid_4504690 (
  "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
);

Beaufort Township - Time Series For Statistical Variables

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

Beaufort West - Time Series For Statistical Variables

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

Beaufort - Time Series For Statistical Variables

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

Share link

Anyone who has the link will be able to view this.