From a 500-row sample across 40 columns.
street_nameboroughowner_state+6street_nameboroughfiling_date+5street_namebinblockHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| tr6_no | control_no | filing_type | cycle | bin | house_no | street_name | borough | block | lot | sequence_no | submitted_on |
|---|---|---|---|---|---|---|---|---|---|---|---|
| TR6-802744-8A-I1 | 802744 | Initial | 8 | 1019150 | 148 | EAST 39 STREET | Manhattan | 894 | 52 | 1 | 2018-04-09T00:00:00.000 |
| TR6-709724-7A-I1 | 709724 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
tr6_no | text | — | 0% | TR6-815008-8B-N1TR6-610070-NA-I1TR6-800351-8A-S1 |
control_no | text | — | 0% | 902354901485916004 |
filing_type | categorical | — | 0% | InitialAuto-GeneratedAmendedof 4 |
cycle | categorical | — | 0% | 986of 5 |
bin | text |
GET /api/datasets/xubg-57si GET /api/datasets/xubg-57si/quality GET /api/datasets/xubg-57si/related GET /api/columns?dataset=xubg-57si
lotbinstreet_nameboroughblock+3street_nameboroughblock+2blocklotbin| Initial |
| 7 |
| 3326542 |
| 300 |
| DUMONT AVENUE |
| Brooklyn |
| 3576 |
| 1 |
| 7 |
| 2012-12-03T00:00:00.000 |
| TR6-904431-9A-S1 | 904431 | Amended | 9 | 1036085 | 617 | MADISON AVENUE | Manhattan | 1294 | 46 | 1 | 2022-11-30T00:00:00.000 |
| TR6-601378-NA-I1 | 601378 | Initial | 6 | 1077829 | 204 | WEST 10 STREET | Manhattan | 619 | 7502 | 1 | 2006-09-13T00:00:00.000 |
| TR6-804384-8B-I1 | 804384 | Initial | 8 | 1035741 | 689 | FIFTH AVENUE | Manhattan | 1290 | 1 | 1 | 2018-01-20T00:00:00.000 |
| TR6-802057-8A-N1 | 802057 | Auto-Generated | 8 | 1015602 | 1101 | BROADWAY | Manhattan | 826 | 7501 | 1 | — |
| TR6-710640-7B-I1 | 710640 | Initial | 7 | 4430871 | 21-25 | 34 AVENUE | Queens | 557 | 3 | 1 | 2012-04-18T00:00:00.000 |
| TR6-917501-9A-N1 | 917501 | Auto-Generated | 9 | 1090530 | 147 | EAST 86 STREET | Manhattan | 1515 | 7505 | — | — |
| TR6-901026-9B-N1 | 901026 | Auto-Generated | 9 | 1008479 | 39 | GREAT JONES STREET | Manhattan | 530 | 26 | 1 | — |
| TR6-1010355-10A-I1 | 1010355 | Initial | 10 | 3344548 | 3677 | NOSTRAND AVENUE | Brooklyn | 7405 | 1001 | 7 | 2025-04-15T00:00:00.000 |
Showing 12 of 39 columns. All of them are listed below.
| — |
| 0% |
108478110000001081661 |
house_no | text | — | 0% | 15040 |
street_name | text | — | 0% | BROADWAYFIFTH AVENUEPARK AVENUE |
borough | categorical | — | 0% | ManhattanBrooklynBronxof 5 |
block | text | — | 0% | 2180163944 |
lot | text | — | 0% | 175017502 |
sequence_no | text | — | 6% | 123 |
submitted_on | datetime | — | 22% | 2007-02-21T00:00:00.0002007-02-20T00:00:00.0002012-02-21T00:00:00.000 |
current_status | categorical | — | 0% | SAFESWARMPUNSAFEof 4 |
qewi_name | text | — | 24% | PAUL MILLMANALAN S EPSTEINHOWARD L ZIMMERMAN |
qewi_bus_name | text | — | 25% | EPSTEIN ENGINEERING, P.CKOENIGSBERG ENGINEERING,…LAWLESS & MANGIONE, LLP |
qewi_bus_street_name | text | — | 22% | 480 NORTH BROADWAY159 WEST 25TH STREET11 WEST 30TH STREET |
qewi_city | text | — | 23% | NEW YORKYONKERSBROOKLYN |
qewi_state | categorical | — | 22% | NYNJCTof 19 |
qewi_zip | text | — | 59% | 100011001810016 |
qewi_nys_lic_no | text | — | 59% | PE - 088950PE - 067415RA - 014327 |
owner_name | text | — | 59% | LLOYD VALDEZLloyd ValdezGARY GUILLAUME |
owner_bus_name | text | — | 22% | NYCHAN.Y.C.H.A.NEW YORK CITY HOUSING AU… |
owner_bus_street_name | text | — | 21% | 90 CHURCH STREET24-02 49TH AVENUE770 LEXINGTON AVENUE |
owner_city | text | — | 22% | NEW YORKNYBROOKLYN |
owner_zip | text | — | 59% | 100161001711101 |
owner_state | text | — | 59% | NYNJNE |
filing_date | datetime | — | 23% | 2007-02-21T00:00:00.0002007-02-20T00:00:00.0002012-02-21T00:00:00.000 |
filing_status | categorical | — | 0% | SAFESWARMPNo Report Filedof 4 |
prior_cycle_filing_date | datetime | — | 33% | 2007-02-21T00:00:00.0002002-02-21T00:00:00.0002007-02-20T00:00:00.000 |
prior_status | categorical | — | 30% | SWARMPSAFEUNSAFEof 4 |
field_inspection_completed_date | datetime | — | 27% | 2006-11-01T01:00:00.0002012-02-15T00:00:00.0002023-02-15T00:00:00.000 |
qewi_signed_date | datetime | — | 29% | 2007-02-15T00:00:00.0002007-02-20T00:00:00.0002007-02-16T00:00:00.000 |
late_filing_amt | text | — | 1% | 03200044000 |
failure_to_file_amt | text | — | 1% | 010005000 |
failure_to_correct_amt | text | — | 1% | 010002000 |
comments | text | — | 73% | N.Y.C.H.ARESUBMISSIONALTERNATIVE PROGRAM |
exterior_wall_type_s_ | text | — | 24% | BRICK MASONRYOTHERMASONRY LOAD-BEARING WAL… |
exterior_wall_type_other_description | text | — | 74% | SOLID MASONRYSTONELIMESTONE |
exterior_wall_material_s_ | text | — | 24% | MASONRYOTHERMASONRY; OTHER |
exterior_wall_material_other_description | text | — | 96% | BRICKLIMESTONELimestone |