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

Baker - Time Series For Statistical Variables

@datacommons.cities.baker_geoid_3204100
  • 2.58 MB
  • 326,160 rows
  • 12 columns
Loading... 
CREATE TABLE baker_geoid_3204100 (
  "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
);

Baker - Time Series For Statistical Variables

@datacommons.cities.baker_geoid_4003900
  • 949.83 kB
  • 62,997 rows
  • 12 columns
Loading... 
CREATE TABLE baker_geoid_4003900 (
  "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
);

Bakerhill - Time Series For Statistical Variables

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

Baker Lake - Time Series For Statistical Variables

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

Bakers Creek - Time Series For Statistical Variables

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

Bakersfield Country Club - Time Series For Statistical Variables

@datacommons.cities.bakersfield_country_club_geoid_0603546
  • 1.07 MB
  • 67,043 rows
  • 12 columns
Loading... 
CREATE TABLE bakersfield_country_club_geoid_0603546 (
  "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
);

Bakersfield - Time Series For Statistical Variables

@datacommons.cities.bakersfield_geoid_0603526
  • 4.46 MB
  • 408,680 rows
  • 12 columns
Loading... 
CREATE TABLE bakersfield_geoid_0603526 (
  "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
);

Bakersfield - Time Series For Statistical Variables

@datacommons.cities.bakersfield_geoid_2903052
  • 2.8 MB
  • 340,478 rows
  • 12 columns
Loading... 
CREATE TABLE bakersfield_geoid_2903052 (
  "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
);

Bakersfield - Time Series For Statistical Variables

@datacommons.cities.bakersfield_geoid_5002425
  • 1.04 MB
  • 66,384 rows
  • 12 columns
Loading... 
CREATE TABLE bakersfield_geoid_5002425 (
  "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
);

Bakersfield - Time Series For Statistical Variables

@datacommons.cities.bakersfield_geoid_5002500
  • 105.56 kB
  • 17,285 rows
  • 12 columns
Loading... 
CREATE TABLE bakersfield_geoid_5002500 (
  "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
);

Bakersfield - Time Series For Statistical Variables

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

Bakers Hill - Time Series For Statistical Variables

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

Bakerstown - Time Series For Statistical Variables

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

Bakerstown - Time Series For Statistical Variables

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

Bakersville - Time Series For Statistical Variables

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

Bakersville - Time Series For Statistical Variables

@datacommons.cities.bakersville_geoid_3703100
  • 2.93 MB
  • 342,933 rows
  • 12 columns
Loading... 
CREATE TABLE bakersville_geoid_3703100 (
  "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
);

Bakersville Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

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

Baker Township - Time Series For Statistical Variables

@datacommons.cities.baker_township_geoid_2903016
  • 88.68 kB
  • 13,769 rows
  • 12 columns
Loading... 
CREATE TABLE baker_township_geoid_2903016 (
  "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.