Coverage
What is covered, where, and on what evidence
Coverage is set by two things: whether an agency publishes the record at all, and whether its dataset has been read by working code rather than only noted as promising. Sources that have not cleared the second test are listed on this page as not offered.
Key Status terms
| Status | Meaning |
|---|---|
| Packaged | A dated release has been built end to end, passed its release checks and written a manifest with checksums. |
| Built | The pipeline runs and produces a working list, but it has not been packaged into the standard workbook release. |
| Source verified | The dataset has been read by working code and its record-selection rules written and tested, with no release built yet. |
| Not offered | A plausible dataset exists but no verified loader reads it here. It is named so it is clear it is excluded, not implied. |
Scroll the table sideways for the remaining columns.
§01 Gas piping
Local Law 152 gas piping — Queens, New York City
New York City requires periodic gas-piping inspection of covered buildings on a four-year cycle organised by community district. This compilation identifies buildings in Queens that carry an active record in the city's safety-violation dataset and are not in an exempt building class.
Sources
- DOB Safety Violations — dataset
855j-jady, the record itself. - MapPLUTO — dataset
64uk-42ks, for building class, floors, units, owner of record and community district.
Both are New York City open data, retrieved from the city's public API.
Eligibility rules applied
- The city's published exempt building classes are dropped. Class B0 is not on that list and is therefore kept.
- Class M3 is exempt only at two dwelling units or fewer, so it is dropped only when the public unit count confirms it.
- Class M4 is exempt only below 21 occupants, which public data does not carry. Those rows are kept and flagged rather than guessed at.
- The four-year cycle is mapped by community district. Queens districts 4, 6, 8, 9 and 16 sit in the sub-cycle due in 2026.
Volume, stated plainly
This is not a stream. Over the 21 days to 17 July 2026 the Queens active set produced no net-new qualifying buildings and fell by 41 against a base of about 27,200, measured twice: once by direct query against the city's API and once by re-running the pipeline. Gas compliance moves in an annual step around cycle deadlines, not month to month, and anyone buying it should expect that shape.
§02 Fire protection
Sprinkler and standpipe — Queens, New York City
Drawn from the city's hearing and violation ledger for buildings cited on sprinkler and standpipe matters, with the building context attached the same way as the gas compilation.
Source
- DOB ECB / OATH violations — dataset
6bgk-3dad.
Why each record is read by hand
Matching on the words "sprinkler" or "standpipe" alone pulls in drainage standpipes, electrical standpipes and occupancy citations that have nothing to do with fire protection work. Relevance is decided record by record and recorded, rather than left to a pattern match.
Re-checking
A Queens working list has been re-checked against the source every day since 2 July 2026. At the run recorded on 29 July 2026 it held 39 adjudicated records, of which 37 were still active and 2 had been marked resolved and dropped out. Status drift is the normal case, which is why the re-check exists.
Counts are from that run's state file and will have moved since.
Volume, stated plainly
Qualified fire-protection flow is thin. A review on 17 July 2026 put citywide qualified new records at roughly fifteen a month after about three quarters of keyword matches were rejected on reading. Queens alone is a fraction of that. It suits a contractor who wants a small, checked list, not one who wants volume.
§03 Backflow
Backflow prevention and cross-connection control
New York City — summonses Source verified
City hearing records carry charge codes for backflow-preventer obligations. The codes alone are not trusted here, because historical codes get reused: a row is only classified as backflow when the charge description also names the backflow preventer and either the installation and initial test, or a failed annual test report.
- Source: OATH hearings case status, dataset
jz4z-kudi, verified 17 July 2026. - A summons with a penalty due is material to review. It is not proof that field work remains available.
- No packaged release has been built for this record type yet.
Gainesville, Florida — utility program Extract held
Obtained from the municipal utility's cross-connection control program under Florida's public-records law. The utility's own system decides what counts as overdue — twelve months from the last passing test for commercial devices, twenty-four for residential — so the overdue determination is the agency's, not ours.
- Extract dated 23 June 2026, 4,847 device rows.
- Fields: device serial, device type, model, location name, full address, set test month, last test date, overdue flag.
- No account-holder names or contact details were requested or captured.
§04 Not offered
Datasets that look useful and are still excluded
These are named because leaving them out silently would let a reader assume broader coverage than exists.
| Record type | Candidate source | Why it is excluded |
|---|---|---|
| FDNY violations | avgm-ztsb |
Appears in working notes only. No verified loader reads it, so nothing is offered from it. |
| Elevator safety compliance | e5aq-a4j2 |
Same position: explored, never wired into verified code. |
| Boiler inspections | None identified | No verified device, inspection or filing source has been established. |
| Facade filings | None identified | No verified filing or status source has been established. |
Scroll the table sideways for the remaining columns.
If one of these becomes verifiable it will move up this page with the date it changed.
§05 Elsewhere
Asking about an area that is not listed
Whether a territory can be covered comes down to what its agency publishes and who is expected to do the testing. Some jurisdictions publish device inventories with no due dates or compliance status, which cannot support this kind of file. In others the utility tests its own assemblies, so there is no private work to find. Both have been checked and set aside before.
Send the trade you are licensed for and the area you work. The answer will be specific, including when the answer is that nothing usable is published.
Two ways a territory fails
No compliance state. The agency publishes what devices exist but not when they were tested or whether they passed. An inventory is not a work list.
No private market. The utility owns and tests the assemblies itself, so there is nothing for an outside contractor to be hired for.