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

Willard - Time Series For Statistical Variables

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

Willard - Time Series For Statistical Variables

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

Willard - Time Series For Statistical Variables

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

Willards - Time Series For Statistical Variables

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

Willard - Time Series For Statistical Variables

@datacommons.cities.willard_wikidataid_q1644077
  • 101.76 kB
  • 16,024 rows
  • 12 columns
Loading...
CREATE TABLE willard_wikidataid_q1644077 (
  "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
);

Willaura - Time Series For Statistical Variables

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

Willaway - Time Series For Statistical Variables

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

Willbriggie - Time Series For Statistical Variables

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

Willcox - Time Series For Statistical Variables

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

Willebadessen - Time Series For Statistical Variables

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

Willemstad - Time Series For Statistical Variables

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

Willenabrina - Time Series For Statistical Variables

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

Willenhall - Time Series For Statistical Variables

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

Willernie - Time Series For Statistical Variables

@datacommons.cities.willernie_geoid_2770366
  • 1.47 MB
  • 188,819 rows
  • 12 columns
Loading...
CREATE TABLE willernie_geoid_2770366 (
  "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
);

Willet - Time Series For Statistical Variables

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

Willey - Time Series For Statistical Variables

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

Willey Township - Time Series For Statistical Variables

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

William C. Morris - Time Series For Statistical Variables

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

William Hamilton Township - Time Series For Statistical Variables

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

William Paterson University Of New Jersey - Time Series For Statistical Variables

@datacommons.cities.william_paterson_university_of_new_jersey_geoid_3481365
  • 1.07 MB
  • 67,200 rows
  • 12 columns
Loading...
CREATE TABLE william_paterson_university_of_new_jersey_geoid_3481365 (
  "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 Acres - Time Series For Statistical Variables

@datacommons.cities.williams_acres_geoid_3585230
  • 1 MB
  • 65,147 rows
  • 12 columns
Loading...
CREATE TABLE williams_acres_geoid_3585230 (
  "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 Bay - Time Series For Statistical Variables

@datacommons.cities.williams_bay_geoid_5587200
  • 3.08 MB
  • 353,023 rows
  • 12 columns
Loading...
CREATE TABLE williams_bay_geoid_5587200 (
  "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_0885155
  • 2.91 MB
  • 345,159 rows
  • 12 columns
Loading...
CREATE TABLE williamsburg_geoid_0885155 (
  "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_1277735
  • 3.15 MB
  • 351,595 rows
  • 12 columns
Loading...
CREATE TABLE williamsburg_geoid_1277735 (
  "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_1884356
  • 807.21 kB
  • 37,381 rows
  • 12 columns
Loading...
CREATE TABLE williamsburg_geoid_1884356 (
  "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.