Fields and sample — the full column layout

§01 One real row

A row from the June 2026 Queens release

These are the values that build produced, not an illustration. The fields that identify a specific building and its owner of record are withheld from this public page. They are present in the delivered file, and they are what make the row checkable.

NOW_QUEUE_TOP_250 · row 1 of 250as of 2026-06-26

Rank: 1 rank_reason: DUE 2026 cycle · 30 fl · 498 units · open since 2025-10
lead_id: Withheld here stable per-building identifier used to return outcomes
lead_status: Baseline first pull for this territory
address: Withheld here house number, street and postal code in the delivered file
borough: Queens
floors: 30
units: 498
bldg_class: D4 elevator apartment, co-operative
owner: Withheld here owner of record, from the public tax-lot dataset
community_district: 6
ll152_cycle: C
cycle_due_year: 2026
open_violations: 1
oldest_open: 2025-10-31
newest_open: 2025-10-31
violation_numbers: Withheld here the real record number; the row's receipt
bin / bbl: Withheld here building and tax-lot identifiers for portal lookup

Nineteen columns appear on the queue tab. The master tab carries all twenty-six, adding the record type, remark sample, eligibility basis, exemption flag, first-seen date, outcome status and suppression reason.

Why the withholding

Those fields point at one building and the people who own it. They belong in a file sent to a licensed contractor who has agreed to the conditions of use, not on a page that anyone can index. Everything else about the row is shown exactly as it was built.

§02 Master columns

All twenty-six

Source is named per column. Anything derived here says so, so an agency value and a provider judgement are never confused for each other.

lead_idprovider: Stable per-building identifier. Use it to return outcomes.
Rankprovider rule: Priority order: cycle year due, then size by floors and units, then how long the record has been open.
lead_statusprovider diff: New since the last pull, recurring from a prior pull, or baseline on a first pull.
rank_reasonprovider rule: The reason for the rank, written out.
boroughDOB 855j-jady: Borough.
addressDOB 855j-jady: House number, street and postal code.
floorsPLUTO numfloors: Number of floors.
bldg_classPLUTO bldgclass: Department of Finance building class. Drives eligibility.
unitsPLUTO unitstotal: Total units.
ownerPLUTO ownername: Owner of record, from public data. We do not contact owners.
open_violationsDOB 855j-jady: Count of distinct open records on the building.
violation_typeDOB 855j-jady: The agency's record type code.
first_seenprovider diff: Pull date on which the building first appeared active in this territory.
oldest_openDOB 855j-jady: Issue date of the oldest open record.
newest_openDOB 855j-jady: Issue date of the newest open record.
remark_sampleDOB 855j-jady: Sample remark text from the record, truncated.
eligibility_basisprovider rule: Why the building qualified, or which condition could not be resolved.
exemption_flagprovider rule: Set where class alone cannot resolve an exemption.
community_districtPLUTO cd: Community district number, which drives the four-year cycle.
ll152_cycleprovider rule: Sub-cycle group A to D for that district.
cycle_due_yearprovider rule: Year the building's inspection cycle falls due.
binDOB 855j-jady: Building identification number.
bblDOB 855j-jady: Borough, block and lot.
violation_numbersDOB 855j-jady: The real record number or numbers. Verify each at the agency before acting.
outcome_statusreturned by buyer: Latest status ingested from a returned outcome sheet.
suppression_reasonprovider + outcomes: Why a row is held back from the queue: cured, no gas, has vendor, won, bad record, do not contact.

§03 Outcome sheet

The columns you fill in

The return sheet is short on purpose. Fill in what you did, send it back, and the next build acts on it.

lead_id, bin, addresspre-filled: Already populated so a returned row can be matched without guesswork.
buyer_statusyou: Free text, if the flags do not fit.
status_date, worked_byyou: When it was worked and by whom.
contact_attempted, site_visit_set, quoted, won, lostyou: Funnel flags. These are the only real measure of whether the list is any good.
already_cured, already_has_vendor, not_applicable_no_gas, bad_record, do_not_contactyou: Disposition flags. Each one takes the row out of future queues, with the reason recorded.
buyer_notesyou: Anything the fields above miss.

No outcome data has been returned to date, so nothing on this site claims a conversion rate, a win rate or a job value. Those numbers will exist when buyers report them, and not before.

§04 Formats

How it is packaged

Workbook tabs — Queens LL152 gas compilation, release 2026-06
Tab	Holds	Rows
`README_SOURCE_TERMS`	Source datasets and their update timestamps, the as-of date, what the file is and is not, and the conditions of use.	—
`NOW_QUEUE_TOP_250`	The ranked working list. Ordered by cycle year due, then building size, then how long the record has been open.	250
`NEW_THIS_MONTH`	Buildings that became newly delinquent since the previous pull, from the diff registry.	0
`FULL_ACTIVE_MASTER`	Every qualified building with an active record in the territory, not only the queue.	27,185
`CURED_SINCE_PRIOR_DROP`	Rows that were active in the last pull and are not active now, so a resolved record is visible rather than silently gone.	0
`OUTCOME_LOG`	A blank return sheet. Send it back and worked, won or dead rows drop out of the next queue.	—
`DATA_DICTIONARY`	Every column, the tab it appears on, what it means and which dataset it came from.	26 fields
`RUN_QA_SUMMARY`	The release checks for that build, with the measured value and the threshold beside each one.	10 gates

Scroll the table sideways for the remaining columns.

Row counts are from the 2026-06 release manifest, pulled 2026-06-26. NEW_THIS_MONTH and CURED_SINCE_PRIOR_DROP are empty because that build was the first pull for the territory and had nothing to diff against.

CSV mirrors of each working tab, for anything that would rather read flat files.
A manifest recording source datasets, their update timestamps, row counts, the check report and a SHA-256 for every file.
The whole release as a single archive.

A separate 50-row sample workbook is what gets sent on request, with the same column layout as the full file.
No macros, no add-ins, no login, no portal.
Nothing phones home. The file is a file.

Request a sample file