Medical Waste Generator Inspections

Inspections and inspection violations for Medical Waste Generators in Marin County. For each licensed Medical Waste Generator facility, data consists of the following: facility license number, inspection date, type of inspection, listing of violations found, number of pharmaceutical violations found, information about the facility, earliest license issue date and geographic information. Only small quantity waste generators are currently tracked in this data set. Data is updated daily.

For any facilities with an earliest license issue date of 11/18/2012, their actual earliest license issue date was before that date. This is due to a change in tracking systems.

If a facility has any of the following violation codes they are considered by Environmental Health Services to have had pharmaceutical disposal violations strictly for purposes of the pharmaceutical disposal violations count shown in this data set. There are of course many other serious violations.

118275.g

118275

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"marincounty/medical-waste-generator-inspections-8pw7-tfbf\".\"medical_waste_generator_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.