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

Winthrop - Time Series For Statistical Variables

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

Winthrop - Time Series For Statistical Variables

@datacommons.cities.winthrop_geoid_5379380
  • 2.96 MB
  • 349,640 rows
  • 12 columns
Loading...
CREATE TABLE winthrop_geoid_5379380 (
  "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
);

Winthrop Harbor - Time Series For Statistical Variables

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

Winthrop Town - Time Series For Statistical Variables

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

Winthrop - Time Series For Statistical Variables

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

Winthrop - Time Series For Statistical Variables

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

Winthrop - Time Series For Statistical Variables

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

Winthrop - Time Series For Statistical Variables

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

Winton - Time Series For Statistical Variables

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

Winton - Time Series For Statistical Variables

@datacommons.cities.winton_geoid_2771140
  • 1.32 MB
  • 182,156 rows
  • 12 columns
Loading...
CREATE TABLE winton_geoid_2771140 (
  "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
);

Winton - Time Series For Statistical Variables

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

Winton - Time Series For Statistical Variables

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

Winton - Time Series For Statistical Variables

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

Winton - Time Series For Statistical Variables

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

Wiota - Time Series For Statistical Variables

@datacommons.cities.wiota_geoid_1986610
  • 1.35 MB
  • 184,331 rows
  • 12 columns
Loading...
CREATE TABLE wiota_geoid_1986610 (
  "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
);

Wiota - Time Series For Statistical Variables

@datacommons.cities.wiota_geoid_5588025
  • 2.6 MB
  • 286,427 rows
  • 12 columns
Loading...
CREATE TABLE wiota_geoid_5588025 (
  "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
);

Wiota - Time Series For Statistical Variables

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

Wipperfürth - Time Series For Statistical Variables

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

Wirges - Time Series For Statistical Variables

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

Wirksworth - Time Series For Statistical Variables

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

Wirrabara - Time Series For Statistical Variables

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

Wirrulla - Time Series For Statistical Variables

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

Wirt - Time Series For Statistical Variables

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

Wirt Township - Time Series For Statistical Variables

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

Wisacky - Time Series For Statistical Variables

@datacommons.cities.wisacky_geoid_4578640
  • 965.05 kB
  • 64,296 rows
  • 12 columns
Loading...
CREATE TABLE wisacky_geoid_4578640 (
  "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.