Baselight

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg - Time Series For Statistical Variables

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

Williamsburg Township - Time Series For Statistical Variables

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

Williamsburg Township - Time Series For Statistical Variables

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

Williamsburg Township, Phelps County, Nebraska - Time Series For Statistical Variables

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

Williamsburg Township - Time Series For Statistical Variables

@datacommons.cities.williamsburg_township_wikidataid_q6032611
  • 93.39 kB
  • 15,194 rows
  • 12 columns
Loading...
CREATE TABLE williamsburg_township_wikidataid_q6032611 (
  "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 Canyon - Time Series For Statistical Variables

@datacommons.cities.williams_canyon_geoid_0685587
  • 956.56 kB
  • 64,303 rows
  • 12 columns
Loading...
CREATE TABLE williams_canyon_geoid_0685587 (
  "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 Creek - Time Series For Statistical Variables

@datacommons.cities.williams_creek_geoid_1884374
  • 2.88 MB
  • 345,702 rows
  • 12 columns
Loading...
CREATE TABLE williams_creek_geoid_1884374 (
  "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 Creek Township - Time Series For Statistical Variables

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

Williamsdale - Time Series For Statistical Variables

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

Williamsdale - Time Series For Statistical Variables

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

Williamsfield - Time Series For Statistical Variables

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

Williamsfield Township - Time Series For Statistical Variables

@datacommons.cities.williamsfield_township_geoid_3985372
  • 95.18 kB
  • 15,065 rows
  • 12 columns
Loading...
CREATE TABLE williamsfield_township_geoid_3985372 (
  "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_0483160
  • 3.18 MB
  • 357,460 rows
  • 12 columns
Loading...
CREATE TABLE williams_geoid_0483160 (
  "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_0685586
  • 3.16 MB
  • 356,388 rows
  • 12 columns
Loading...
CREATE TABLE williams_geoid_0685586 (
  "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_1884338
  • 2.74 MB
  • 334,804 rows
  • 12 columns
Loading...
CREATE TABLE williams_geoid_1884338 (
  "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_1985800
  • 2.89 MB
  • 343,813 rows
  • 12 columns
Loading...
CREATE TABLE williams_geoid_1985800 (
  "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_2770402
  • 2.78 MB
  • 339,117 rows
  • 12 columns
Loading...
CREATE TABLE williams_geoid_2770402 (
  "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.