From a 500-row sample across 111 columns.
blockblockbinblockbin| lotid | inspectionrequestid | lotno | privateind | areaid | lotstatusid | lotstatusdate | operid | overriteind | activityid | noofaddresses | old_lot_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 104327 | 9121 | 0026 | 682 | 39 | 702 | 2000-01-14T00:00:01.000 | 332 | 1 | 34722 | 0 | LOT25511 |
| 108504 | 9492 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
lotid | text | — | 0% | 283518001879996 |
inspectionrequestid | text | — | 0% | 5572456433145222 |
lotno | text | — | 0% | 000100350032 |
privateind | categorical | — | 0% | 682681of 2 |
areaid | categorical | — | 0% |
GET /api/datasets/r4c5-ndkx GET /api/datasets/r4c5-ndkx/quality GET /api/datasets/r4c5-ndkx/related GET /api/columns?dataset=r4c5-ndkx
notesblockblockbin| 0021 |
| 682 |
| 39 |
| 702 |
| 1999-12-24T00:00:01.000 |
| 332 |
| 1 |
| 20155 |
| 0 |
| LOT29591 |
| 65045 | 75818 | 0076 | 681 | 39 | 702 | 2008-04-04T00:00:01.000 | 332 | 1 | 11703 | 1 | LOT173157 |
| 196482 | 122191 | 0058 | 682 | 39 | 702 | 2013-12-27T00:00:00.000 | 675 | 0 | 46586 | — | — |
| 135852 | 20089 | 0014 | 682 | 39 | 702 | 2001-08-27T00:00:01.000 | 332 | 1 | 25725 | 0 | LOT57590 |
| 37092 | 58854 | 0001 | 682 | 40 | 702 | 2006-07-11T00:00:01.000 | 332 | 1 | 6687 | 0 | LOT145971 |
| 109775 | 11185 | 0029 | 682 | 39 | 702 | 2000-04-21T00:00:01.000 | 332 | 1 | 20490 | 0 | LOT30809 |
| 86925 | 91973 | 0013 | 682 | 39 | 702 | 2009-10-20T00:00:01.000 | 332 | 1 | 16198 | 0 | LOT194592 |
| 125105 | 14732 | 0225 | 681 | 40 | 702 | 2000-12-28T00:00:01.000 | 332 | 1 | 23447 | — | LOT46059 |
| 188996 | 115120 | 0043 | 681 | 39 | 702 | 2013-01-07T00:00:00.000 | 675 | 0 | 43887 | 1 | — |
Showing 12 of 98 columns. All of them are listed below.
3940of 2 |
lotstatusid | categorical | — | 0% | 702662750of 10 |
lotstatusdate | datetime | — | 0% | 1999-02-26T00:00:01.0002006-01-27T00:00:01.0002005-12-28T00:00:01.000 |
lotstatusreason | categorical | — | 99% | 919665705of 14 |
operid | text | — | 0% | 332770799 |
lotentrydate | datetime | — | 70% | 2011-03-11T09:57:18.0002012-12-27T15:43:49.0002014-09-29T09:51:39.000 |
billingdate | datetime | — | 61% | 2013-05-15T00:00:00.0002012-01-17T00:00:00.0002013-09-16T00:00:00.000 |
lotbllingtotal | coordinate | — | 61% | 0.00244.19178.96 |
overriteind | categorical | — | 0% | 10of 2 |
perimeter_ind | categorical | — | 69% | 01of 2 |
fivedayletterno | categorical | — | 81% | 102of 10 |
notes | text | — | 97% | HPDPROPERTY OF HPDDCAS |
psid | categorical | — | 70% | 0547553of 4 |
dupccu | text | — | 99% | 97 0657310-1130498 03206 |
activityid | text | — | 0% | 5689641055444 |
noofaddresses | categorical | — | 31% | 012of 11 |
refno | text | — | 100% | — |
lotnjinspectionrequestid | text | — | 100% | — |
lotdupinspectionrequestid | text | — | 100% | 1456393449346 |
lotissysflageddupoverridden | text | — | 70% | 0of 1 |
lotissysflagednjoverridden | text | — | 70% | 0of 1 |
lotprevstatusidbfrdupornj | text | — | 100% | — |
legalnotes | text | — | 100% | 14AOR-16; Post by 10-20-…Confirmed aor receipt wi…19AOR0052 Post By T… |
fieldnotes | text | — | 92% | PICTURES ATTACHED TO LOT…PICS IN LOT 1SEE LOT 18 |
supp_ind | categorical | — | 88% | NYof 2 |
old_lot_id | text | — | 30% | LOT13750LOT18792LOT18791 |
old_status_dd | categorical | — | 30% | MST117MST66MST119of 9 |
old_status_rea_dd | text | — | 100% | RR MM: 11, 2010DUPLICATE (S/A 97 06573)DUPLICATE (S/A 98 03206) |
lotconversion_notes | categorical | — | 30% | PB STATUS = COMPLETE;PB STATUS = ROUND ROBIN …PB STATUS = INELIGIBLE;of 16 |
ownerlotlcd | categorical | — | 100% | NMYof 3 |
logno | text | — | 100% | 14AOR001612AOR001421AOR0015 |
indexno | text | — | 100% | 201401455650934420212501752012 |
refferedtodohmhdate | text | — | 100% | — |
structure | categorical | — | 0% | 01of 2 |
activitydetailid | text | — | 0% | 703217034171959 |
titleid | categorical | — | 0% | 494746of 6 |
hours | coordinate | — | 0% | 6.505.504.50 |
operatorid_detail | text | — | 0% | 694693612 |
detailentrydate | datetime | — | 0% | 2010-11-04T11:17:14.0002012-01-10T11:24:19.0002014-10-24T11:51:37.000 |
dumpsiteid | text | — | 70% | 0of 1 |
vehicleno | text | — | 54% | AS-002DG-013DG-017 |
act_date | datetime | — | 0% | 2006-07-27T00:00:00.0001998-10-09T00:00:00.0001999-02-17T00:00:00.000 |
activityentrydate | datetime | — | 0% | 2006-01-05T11:44:59.0002006-01-31T11:27:07.0002017-11-22T08:43:47.000 |
abandonedcars | categorical | — | 30% | 0163of 8 |
activitystatusid | categorical | — | 0% | 750751749of 4 |
enddate | datetime | — | 0% | 1999-02-26T00:00:00.0002006-01-27T00:00:00.0002005-12-28T00:00:00.000 |
activitybllingtotal | coordinate | — | 84% | 1139.33970.40384.48 |
activitystatusdate | datetime | — | 0% | 2010-11-02T14:55:57.0002010-11-02T14:55:56.0002010-11-02T14:55:54.000 |
total_hrs | coordinate | — | 0% | 0.00of 1 |
total_tonnage | coordinate | — | 0% | 0.0001.0000.250 |
total_loads | coordinate | — | 0% | 0.001.002.00 |
s_tires | text | — | 0% | 024 |
l_tires | text | — | 0% | 0302 |
civilian_hrs | text | — | 0% | 0611 |
fel_tires | categorical | — | 0% | 0126of 4 |
uniform_hrs | text | — | 0% | 322620 |
old_main_lot_id | text | — | 30% | LOT140565LOT141830LOT22039 |
startdate | datetime | — | 0% | 1998-08-03T00:00:00.0002005-12-07T00:00:00.0001999-08-04T00:00:00.000 |
act_old_lot_id | text | — | 30% | LOT140565LOT141830LOT22039 |
lotcleaningtotal | coordinate | — | 61% | 0.001046.46891.30 |
salestax | coordinate | — | 61% | 0.0092.8779.10 |
isbillgenerated | categorical | — | 0% | 01of 2 |
prefix | categorical | — | 73% | 600611679of 17 |
house1 | text | — | 73% | 201244388 |
house2 | text | — | 99% | 109-49191105-60 |
streetaddress | text | — | 72% | FULTON STREETCHRISTOPHER AVENUEROCKAWAY AVENUE |
requestdate | date | — | 86% | 04/12/2007 09:31:0206/21/2014 00:00:0007/31/2012 00:00:00 |
lastname | text | — | 97% | ROSSANONYMOUSNAVARRO |
firstname | text | — | 85% | SUPV. LIGGIONALLYWELSH |
boroid | categorical | — | 0% | 798of 5 |
districtid | text | — | 0% | 30356 |
note | text | — | 89% | FENCED & LOCKEDOPENFenced + Locked. |
ccuyear | text | — | 0% | 989906 |
ccuno | text | — | 0% | 5142406052721709378 |
userid | text | — | 2% | 336665664 |
requestentrydate | datetime | — | 0% | 2005-12-02T19:05:01.0002006-01-12T20:30:15.0002017-08-18T12:13:12.000 |
refid | categorical | — | 70% | 0461of 2 |
requestsourceid | text | — | 0% | 504502463 |
scanno | text | — | 91% | 2014MLCY068382013MLGA190542012MLKN06233 |
isdeleted | text | — | 0% | 0of 1 |
assignedtoinspector | text | — | 0% | Nof 1 |
crossstreetone | text | — | 71% | SARATOGA AVENUEGLENMORE AVENUEBEND |
crossstreettwo | text | — | 71% | BENDHULL STREETLIBERTY AVENUE |
channel | categorical | — | 0% | 867929677of 7 |
program | categorical | — | 66% | 039530of 17 |
area | categorical | — | 15% | 39040of 3 |
crmno | text | — | 100% | 2019LC01001902018LC01003032019LC0100308 |
phone | text | — | 70% | __________002120 |
coordinatex | text | — | 71% | 010071011010154 |
coordinatey | text | — | 71% | 0186534184345 |
segmentid | text | — | 70% | 016759347121 |
bin | text | — | 71% | 030421123000000 |
block | text | — | 0% | 070510154903692 |
requeststatusid | categorical | — | 0% | 10489671043of 5 |
requeststatusreason | categorical | — | 100% | -110471040of 4 |
requeststatusdate | datetime | — | 0% | 2011-03-29T16:02:34.0002017-09-30T00:02:08.0002016-12-14T00:02:03.000 |
flp | categorical | — | 8% | 01of 2 |
inspectiondate | datetime | — | 0% | 1999-03-17T00:00:00.0001998-01-15T00:00:00.0002005-12-01T00:00:00.000 |
inspectorfindings | text | — | 70% | OPENFENCED & LOCKEDFL |
isduplicate | text | — | 100% | — |
used_prefix | categorical | — | 70% | 600611679of 12 |
used_house1 | text | — | 70% | 201244194 |
used_house2 | text | — | 98% | 109-49105-60304 |
used_streetaddress | text | — | 69% | FULTON STREETCHRISTOPHER AVENUEROCKAWAY AVENUE |
used_crossstreetone | text | — | 71% | SARATOGA AVENUEGLENMORE AVENUEBEND |
used_crossstreettwo | text | — | 71% | BENDHULL STREETLIBERTY AVENUE |
dupinspectionrequestid | categorical | — | 100% | 143041106657119902of 4 |
njinspectionrequestid | text | — | 100% | — |
issysflageddupoverridden | categorical | — | 76% | 01of 2 |
issysflagednjoverridden | categorical | — | 76% | 01of 2 |
zone | categorical | — | 6% | 416of 11 |
importfromscan | categorical | — | 0% | 01of 2 |
copyexistingaddress | categorical | — | 70% | 10of 2 |
old_inspect_id | categorical | — | 100% | INR31069INR31072INR31068of 3 |
block_loc | text | — | 64% | ADJ. 2012 FULTON STREET …ADJ. 44 CHRISTOPHER AVEN…ADJ. 388 CHRISTOPHER AVE… |
used_block_loc | text | — | 0% | ADJ. 2012 FULTON STREET …OPP 2930 W 30 STADJ. 44 CHRISTOPHER AVEN… |
loc_id | text | — | 30% | LOC60801LOC61457LOC9273 |
requestconversion_notes | categorical | — | 30% | PB STATUS = ASSIGNED TO …PB fsource= FG …of 2 |
originaloverride | categorical | — | 0% | 01of 2 |
usedoverride | categorical | — | 0% | 01of 2 |