From a 500-row sample across 21 columns.
| tracking_number | boiler_id | report_type | boiler_make | pressure_type | inspection_date | defects_exist | lff_45_days | lff_180_days | filing_fee | total_amount_paid | report_status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017-10000007621Y0001-15530 | 10000007621Y0001 | Initial | SMITH | Low Pressure | 05/10/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
| 2017-10000823916N0001-6255 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
tracking_number | text | The tracking number for the boiler compliance filing. | 0% | 2016-10000003263Y0002-71…2016-10000005880Y0001-39…2016-10000007847Y0001-26… |
boiler_id | text | The identification number for the Boiler. It's a combination of the Borough code, the DOB device number, the multiple dwelling flag, and the serial number. | 0% | 10000000BNRY000110000000BNRN000120000072016Y0001 |
report_type | categorical | The type of compliance filing. Expected values: • Initial = the initial boiler compliance filing for this device in this inspection cycle • Subsequent = a subsequent filing is submitted to correct defects on a previous filing. | 0% | InitialSubsequentBNRof 4 |
applicantfirst_name |
GET /api/datasets/52dp-yji6 GET /api/datasets/52dp-yji6/quality GET /api/datasets/52dp-yji6/related GET /api/columns?dataset=52dp-yji6
| 10000823916N0001 |
| Initial |
| WEILMCLAIN |
| Low Pressure |
| 06/21/2017 00:00:00 |
| Yes |
| 0 |
| 0 |
| 30 |
| 0 |
| Accepted |
| 2017-10000826544Y0001-31963 | 10000826544Y0001 | Subsequent | FEDERAL | Low Pressure | 02/07/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
| 2017-10000900625Y0001-39648 | 10000900625Y0001 | Initial | SLANTFIN | Low Pressure | 02/26/2017 00:00:00 | Yes | 0 | 0 | 30 | 0 | Accepted |
| 2017-10000913169Y0001-15491 | 10000913169Y0001 | Initial | ROCKMILLS | Low Pressure | 06/22/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
| 2017-10000919714Y0001-6499 | 10000919714Y0001 | Initial | WEILMCLAIN | Low Pressure | 05/24/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
| 2017-20000046160N0001-25637 | 20000046160N0001 | Initial | LAARS | Low Pressure | 06/08/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
| 2017-20000061740Y0001-7220 | 20000061740Y0001 | Initial | — | Low Pressure | 02/14/2017 00:00:00 | Yes | 0 | 0 | 30 | 0 | Accepted |
| 2017-20000064720N0001-35199 | 20000064720N0001 | Initial | — | Low Pressure | 04/04/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
| 2017-20000065107N0001-21260 | 20000065107N0001 | Initial | DUNKIRK | Low Pressure | 07/06/2017 00:00:00 | No | 0 | 0 | 30 | 0 | Accepted |
Showing 12 of 14 columns. All of them are listed below.
| text |
| First name of the person who filed the application |
| 1% |
JOHNMICHAELVINCENT |
applicant_last_name | text | Last name of the person who filed the application. | 1% | CAPUTOTHOMASRUSSELL |
applicant_license_type | categorical | The license type that the applicant used to file the application. Expected values: • BB = Insurance Agency Inspector Certified by NYS • E = High Pressure Boiler Operator • O = Oil Burner Installer • P = Master Plumber | 1% | BBOPof 5 |
applicant_license_number | text | The applicant's license number on file with the Department. | 1% | 546853565578 |
owner_first_name | text | The first name of the building owner. | 1% | ROBERTLENINMICHAEL |
owner_last_name | text | The last name of the building owner. | 1% | IPQBURKESWANSON |
boiler_make | text | The manufacturer of the boiler. | 4% | WEIL MCLAINFEDERALBURNHAM |
boiler_model | text | The model of the boiler. | 37% | UNKNOWNOTHEREG-75 |
pressure_type | categorical | The type of boiler: either low or high pressure. | 0% | Low PressureHigh Pressureof 2 |
inspection_type | categorical | Low pressure boilers only require an external inspection. High pressure boilers require both an external and an internal inspection. Expected values: • Internal = inspection by DOB staff • External = inspection performed by an inspector hired by the building owner. | 1% | ExternalInternalof 2 |
inspection_date | date | Date that the boiler was inspected. Date in ISO 8601 format | 0% | 12/31/2018 00:00:0012/29/2017 00:00:0012/31/2019 00:00:00 |
defects_exist | categorical | This indicates if any defects were found during the inspection. Expected values: • true = Defects were found • false = Defects were not found | 0% | NoYesof 2 |
lff_45_days | categorical | Inspection reports submitted to DOB after the forty-five (45) days of the annual inspection date but within twelve (12) months from the inspection date will be considered “late filings” and will be subject to the appropriate civil penalties. | 0% | 050100of 13 |
lff_180_days | categorical | Inspection reports submitted as Unsatisfactory (with defects) must be corrected within one hundred eighty days (180) from the initial date of inspection else the owner will be subject to the appropriate civil penalties. | 0% | 050100of 13 |
filing_fee | categorical | — | 0% | 30015of 3 |
total_amount_paid | text | The total amount paid for the boiler compliance filing. | 0% | 30080 |
report_status | categorical | Work Flow Status for the life cycle of the filing. Expected Values: Pre-Filing, QA Review, Rejected, Accepted | 0% | AcceptedAccepted Civil Penalti…Pre-Filingof 18 |
bin_number | integer | — | 0% | 307121940921203347532 |