About this Dataset

NYC Pool Inspections

A permit is required to install, operate or construct any indoor or outdoor bathing establishment with a pool in New York City. This permit may also include saunas, steam rooms, or spray grounds that are at the same location as the pool(s). This permit applies to bathing establishments owned or operated by city agencies, commercial interests or private entities including, but not limited to, public or private schools, corporations, hotels, motels, camps, apartment houses, condominiums, country clubs, gymnasia and health establishments. This dataset contains results of indoor and outdoor pool inspections.

Due to the COVID-19 public health emergency, there were periods of time in 2020 when facilities were subject to mandatory closure orders or chose not to open, and inspections were subsequently paused or modified.
Organization: City of New York
Last updated: 2021-11-07T06:39:02.866834
Tags: indoor-pool, outdoor-pool, pool

Tables

Table 1

@usgov.city_of_new_york_dohmh_pool_inspections.table_1

202.25 KB
4669 rows
23 columns


CREATE TABLE table_1 (
  "permit_type" VARCHAR,
  "accela" BIGINT,
  "facility_name" VARCHAR,
  "address_no" VARCHAR,
  "address_st" VARCHAR,
  "bo" VARCHAR,
  "zip" BIGINT,
  "inspection_date" TIMESTAMP,
  "inspection_type" VARCHAR,
  "n__of_all_violations" BIGINT,
  "n__of_phh_violations" DOUBLE,
  "n__of_critical_violations" DOUBLE,
  "n__of_general_violations" DOUBLE,
  "docket" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "boro_block_lot" DOUBLE,
  "bin" DOUBLE,
  "nta" VARCHAR,
  "nta_code" VARCHAR
);