Compilation desk
Building-compliance records, compiled so every row can be checked against the agency.
We pull compliance records from open government datasets, apply the agency's own eligibility rules, and hand over a dated workbook. Every row carries its record number and source dataset, because a record you cannot verify is not worth acting on.
Most recent packaged releaseQA 9/10 pass
- Compilation
- Queens LL152 Gas Compliance Feed NYC-GAS-LL152-QNS · release 2026-06
- Source pull
- 26 June 2026 the as-of date printed on every sheet
- Sources
- DOB Safety Violations; MapPLUTO 855j-jady, rows updated 2026-06-26 18:08 UTC · 64uk-42ks, 2026-05-28 19:50 UTC
- Qualified
- 27,185 buildings of 27,255 with an active record; 70 dropped as exempt classes
- Release checks
- 9 PASS · 1 N/A the N/A gate compares against a prior pull; this was the first
- Delivered as
- 8-tab workbook, 5 CSV mirrors, manifest SHA-256 recorded for each file
Reproduced from that release's build manifest. Counts move with the source data; a later pull will not match them.
§01 The deliverable
What actually arrives
One workbook per compilation, plus flat CSVs of each working tab. The tabs are fixed, so a second month looks like the first.
- A ranked working queue of 250 buildings, and the full active master behind it — 27,185 qualified buildings on the June 2026 Queens gas release.
- Tabs for what is new since the last pull and what has been resolved, so a cured record disappears visibly rather than silently.
- A data dictionary for all 26 columns, a blank outcome sheet to return, and the release-check report.
- A manifest recording every source dataset, its update timestamp and a SHA-256 per file.
§02 Source to delivery
Five stages, and the number each one produced
Real stage counts from the Queens gas build of 26 June 2026, as written into that release's manifest.
-
2
Retrieve
Open datasets pulled from the city's Socrata endpoints, each stamped with the time the agency last updated it.
-
99.6%
Match
Violation rows joined to the tax-lot record by BBL, attaching class, floors, units and community district.
-
27,185
Qualify
Published exemption rules applied by building class. 70 exempt-class buildings dropped; 103 flagged where class alone cannot settle it.
-
250
Rank and diff
Compared against everything seen before, labelled new, recurring or baseline, then ordered into a working queue.
-
10
Check and package
Release gates run last. A failed hard gate stops the build and no file is written.
Full rules, thresholds and exclusions are on the method page.
§03 Coverage
What exists, and what is deliberately not offered
Coverage is limited by what an agency publishes and by whether the source has been verified against a working loader. Sources that have not cleared that check are listed as not offered rather than quietly implied.
| Record type | Territory | Source | Status |
|---|---|---|---|
| Gas piping, Local Law 152 | Queens, NYC | 855j-jady + 64uk-42ks |
Packaged 2026-06 |
| Sprinkler and standpipe | Queens, NYC | 6bgk-3dad |
Built, re-checked daily |
| Backflow prevention summonses | New York City | jz4z-kudi |
Source verified, not yet packaged |
| Cross-connection control | Gainesville, Florida | Utility records request | Extract held, 2026-06-23 |
| FDNY violations | New York City | avgm-ztsb |
Not offered |
| Elevator compliance | New York City | e5aq-a4j2 |
Not offered |
| Boiler and facade filings | New York City | No verified source | Not offered |
Scroll the table sideways for the remaining columns.
§04 Limits
What a record in one of these files is not
Public compliance data is a starting point for qualification. It is not proof that a condition still exists, that anyone owes money, or that work is available.
- Agency status changes daily. A row is true as of the pull date on the sheet and nothing more. Re-verify at the source before you contact anyone.
- An open record does not mean the condition is unresolved, the owner is reachable, or the work is unassigned.
- Public data can be delayed, corrected, superseded or simply wrong. The city's record is the authority; this compilation is not.
- Where public data cannot settle a question, the row says so instead of guessing.
- BackflowLeads is not a government agency, is not affiliated with or endorsed by any agency, and has no non-public access. Nothing here is legal, engineering or compliance advice.
A worked example of that discipline
A 20-record internal audit of the Queens gas queue on 16 July 2026 checked every sampled row against the city's current data. All 20 were active prior-cycle notices of deficiency carrying no penalty, not confirmed current violations.
So that is what they are called here, and the queue was re-described to match.
Not a government document
§05 Contact
Ask what exists for your trade and area
Tell us the work you are licensed for and where you work. You will get a straight answer about which records exist and where the gaps are. If nothing useful is published for your area, that is the answer you will get.
Email is the only channel. There is no form on this site, no newsletter and no tracking.
What a first exchange covers
- Which record types are published where you work, and which are not.
- A sample file with the real column layout.
- The source datasets, and how to check a row yourself.
- What the data cannot tell you.