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

Windsor - Time Series For Statistical Variables

@datacommons.cities.windsor_geoid_4578190
  • 2.8 MB
  • 340,560 rows
  • 12 columns
Loading... 
CREATE TABLE windsor_geoid_4578190 (
  "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
);

Windsor - Time Series For Statistical Variables

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

Windsor - Time Series For Statistical Variables

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

Windsor - Time Series For Statistical Variables

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

Windsor - Time Series For Statistical Variables

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

Windsor Heights - Time Series For Statistical Variables

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

Windsor Heights - Time Series For Statistical Variables

@datacommons.cities.windsor_heights_geoid_5487892
  • 1.49 MB
  • 189,445 rows
  • 12 columns
Loading... 
CREATE TABLE windsor_heights_geoid_5487892 (
  "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
);

Windsor Locks - Time Series For Statistical Variables

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

Windsor Locks - Time Series For Statistical Variables

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

Windsor Locks - Time Series For Statistical Variables

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

Windsor Place - Time Series For Statistical Variables

@datacommons.cities.windsor_place_geoid_2980380
  • 2.9 MB
  • 346,136 rows
  • 12 columns
Loading... 
CREATE TABLE windsor_place_geoid_2980380 (
  "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
);

Windsorton - Time Series For Statistical Variables

@datacommons.cities.windsorton_wikidataid_q3642331
  • 33 kB
  • 3,529 rows
  • 12 columns
Loading... 
CREATE TABLE windsorton_wikidataid_q3642331 (
  "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
);

Windsor (town) - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

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

Windsor Township - Time Series For Statistical Variables

@datacommons.cities.windsor_township_wikidataid_q6032645
  • 70.82 kB
  • 12,395 rows
  • 12 columns
Loading... 
CREATE TABLE windsor_township_wikidataid_q6032645 (
  "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.