About this Dataset

Outdoor Pools Session Information

The NYC Parks outdoor pool season typically runs from late June to the Sunday after Labor Day. During the season, Parks' staff record data via a mobile app survey at the end of each pool session. The survey includes questions on attendance, staffing, meals, issues, weather conditions, and closures for that specific session.

NYC Parks operates two sessions at each pool every day of the pool season. First Session is from 11:00am - 3:00pm. Second Session is from 4:00pm - 7:00pm, with the requirement for Olympic / Intermediate pools to stay open for Extended Second Session from 7:00pm - 8:00pm when the City Heat Emergency Plan is activated.

For each pool season, every pool will have at least two survey submissions per day - one submission for the first session, and one submission for the second session. A pool will have a third submission if it stays open for an extended second session.

Data Dictionary: https://docs.google.com/spreadsheets/d/15lHSZF76W1cZnjwlWRSn7tzLh6EqVZVeZ2vwDFqXHMM/edit?usp=sharing

For reference, pool geography from Open Data can be found here: https://data.cityofnewyork.us/City-Government/Pools/3vjv-6tf5
Organization: City of New York
Last updated: 2025-01-17T22:23:27.932330
Tags: extreme-temperature, pools, recreation, summer, swimming, swimming-pool, weather

Tables

Table 1

@usgov.city_of_new_york_outdoor_pools_session_information.table_1

310.71 kB
22,308 rows
35 columns

CREATE TABLE table_1 (
  "observationdate" TIMESTAMP,
  "borough" VARCHAR,
  "pool" VARCHAR,
  "poolid" VARCHAR,
  "sessiontype" VARCHAR,
  "opentoday" BOOLEAN,
  "closedreason" VARCHAR,
  "opentime" VARCHAR,
  "lateopen" VARCHAR,
  "lateopenreason" VARCHAR,
  "poolopenpercent" DOUBLE,
  "attendance" DOUBLE,
  "supervisorcount" DOUBLE,
  "lifeguardcount" DOUBLE,
  "pepcount" DOUBLE,
  "nypdcount" DOUBLE,
  "meetingtime" VARCHAR,
  "incident" VARCHAR,
  "incidentcount" DOUBLE,
  "incidentreport" VARCHAR,
  "problem" VARCHAR,
  "problemcount" DOUBLE,
  "arrest" VARCHAR,
  "arrestcount" DOUBLE,
  "chlorinetype" VARCHAR,
  "liquidchlorine" DOUBLE,
  "tabletchlorine" DOUBLE,
  "overnightswimmers" VARCHAR,
  "overnightswimmerscheck" VARCHAR,
  "overnightswimmernum" DOUBLE,
  "pressyes" VARCHAR,
  "breakfasts" DOUBLE,
  "lunches" DOUBLE,
  "temperature" VARCHAR,
  "weatherconditions" VARCHAR
);