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

Allgood - Time Series For Statistical Variables

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

Alliance - Time Series For Statistical Variables

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

Alliance - Time Series For Statistical Variables

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

Alliance - Time Series For Statistical Variables

@datacommons.cities.alliance_geoid_3901420
  • 3.38 MB
  • 362,100 rows
  • 12 columns
Loading... 
CREATE TABLE alliance_geoid_3901420 (
  "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
);

Alliance Township - Time Series For Statistical Variables

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

Alliance Township - Time Series For Statistical Variables

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

Alliance - Time Series For Statistical Variables

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

Alligator - Time Series For Statistical Variables

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

Alligator Township - Time Series For Statistical Variables

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

Allingåbro - Time Series For Statistical Variables

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

Allinge-Sandvig - Time Series For Statistical Variables

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

Allin Township - Time Series For Statistical Variables

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

Allison Gap - Time Series For Statistical Variables

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

Allison - Time Series For Statistical Variables

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

Allison - Time Series For Statistical Variables

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

Allison - Time Series For Statistical Variables

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

Allisonia - Time Series For Statistical Variables

@datacommons.cities.allisonia_geoid_5101256
  • 2.67 MB
  • 332,079 rows
  • 12 columns
Loading... 
CREATE TABLE allisonia_geoid_5101256 (
  "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
);

Allisonia - Time Series For Statistical Variables

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

Allison Park - Time Series For Statistical Variables

@datacommons.cities.allison_park_geoid_4202056
  • 3.24 MB
  • 359,457 rows
  • 12 columns
Loading... 
CREATE TABLE allison_park_geoid_4202056 (
  "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
);

Allison Park - Time Series For Statistical Variables

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

Allison Township - Time Series For Statistical Variables

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

Allison Township - Time Series For Statistical Variables

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

Allison Township - Time Series For Statistical Variables

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

Allison Township - Time Series For Statistical Variables

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

Allison Township - Time Series For Statistical Variables

@datacommons.cities.allison_township_geoid_4600980
  • 92.39 kB
  • 14,433 rows
  • 12 columns
Loading... 
CREATE TABLE allison_township_geoid_4600980 (
  "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.