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

Williams - Time Series For Statistical Variables

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

Williams - Time Series For Statistical Variables

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

Williams Lake - Time Series For Statistical Variables

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

Williamson - Time Series For Statistical Variables

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

Williamson - Time Series For Statistical Variables

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

Williamson - Time Series For Statistical Variables

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

Williamson - Time Series For Statistical Variables

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

Williamson - Time Series For Statistical Variables

@datacommons.cities.williamson_geoid_3682029
  • 3.08 MB
  • 355,016 rows
  • 12 columns
Loading... 
CREATE TABLE williamson_geoid_3682029 (
  "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
);

Williamson - Time Series For Statistical Variables

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

Williamson - Time Series For Statistical Variables

@datacommons.cities.williamson_geoid_5487508
  • 3.09 MB
  • 350,774 rows
  • 12 columns
Loading... 
CREATE TABLE williamson_geoid_5487508 (
  "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
);

Williamsport - Time Series For Statistical Variables

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

Williamsport - Time Series For Statistical Variables

@datacommons.cities.williamsport_geoid_2485100
  • 3.08 MB
  • 355,379 rows
  • 12 columns
Loading... 
CREATE TABLE williamsport_geoid_2485100 (
  "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
);

Williamsport - Time Series For Statistical Variables

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

Williamsport - Time Series For Statistical Variables

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

Williamsport Township - Time Series For Statistical Variables

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

Williamsport Township - Time Series For Statistical Variables

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

Williamston - Time Series For Statistical Variables

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

Williamston - Time Series For Statistical Variables

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

Williamston - Time Series For Statistical Variables

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

Williamston - Time Series For Statistical Variables

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

Williamstown - Time Series For Statistical Variables

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

Williamstown - Time Series For Statistical Variables

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

Williamstown - Time Series For Statistical Variables

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

Williamstown - Time Series For Statistical Variables

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

Williamstown - Time Series For Statistical Variables

@datacommons.cities.williamstown_geoid_2980008
  • 885.53 kB
  • 60,827 rows
  • 12 columns
Loading... 
CREATE TABLE williamstown_geoid_2980008 (
  "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.