About this Dataset

Pool Inspections

This dataset includes critical public swimming pool violations requiring immediate correction. Violations may lead to a temporary closure while the inspector is on site until such violation is corrected or summarily suspend a license if not corrected prior to the inspector completing the inspection and leaving the premise.
Update Frequency: Daily
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:19.268789
Tags: health, inspections, pool, safety, violations

Tables

Table 1

@usgov.montgomery_county_of_maryland_pool_inspections.table_1

212.57 kB
11,171 rows
21 columns

CREATE TABLE table_1 (
  "establishment_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "inspection_date" TIMESTAMP,
  "inspection_results" VARCHAR,
  "inspection_type" VARCHAR,
  "lifeguard_on_deck" VARCHAR,
  "main_drains_visible" VARCHAR,
  "recirculation_system_operating" VARCHAR,
  "water_level_adequate" VARCHAR,
  "disinfection_system_operating" VARCHAR,
  "bathhouse_operational" VARCHAR,
  "dhhs_permitted_entry" VARCHAR,
  "immediate_hazard_absent" VARCHAR,
  "cpr_certified_personnel" VARCHAR,
  "water_chemistry" VARCHAR,
  "organization" VARCHAR,
  "category" VARCHAR,
  "location_1" VARCHAR,
  "establishment" BIGINT  -- Establishment #
);