From a 500-row sample across 57 columns.
personidoperatorlastnameunitid+2| propertyid | contractcode | addressline1 | addressline2 | concessioncity | concessionstate | concessionzipcode | latepercentage | endoffiscalyear | unitid | januaryminfee | februaryminfee |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7.0 | r1040004 | SOUTH SHORE RESTAURANT | SOUTH SHORE PARK | Staten Island | NY | 10065 | 2.0 | 6.0 | 400.0 | 10210.25 | 10210.28 |
| 7.0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
propertyid | integer | — | 0% | 271.01204.0223.0 |
contractcode | text | — | 0% | r0790005m1040040b0400004 |
addressline1 | text | — | 0% | CENTRAL PARKROCKAWAY BEACH SNACKBARSCONEY ISLAND BOARDWALK |
addressline2 | text | — | 18% | 5 AVE- CENTRAL PARKN W 4…ROCKAWAY BEACH PARKPRINCESS BAY |
GET /api/datasets/53m8-jdtg GET /api/datasets/53m8-jdtg/quality GET /api/datasets/53m8-jdtg/related GET /api/columns?dataset=53m8-jdtg
| r1040005 |
| SOUTH SHORE RESTAURANT |
| SOUTH SHORE PARK |
| Staten Island |
| NY |
| 10065 |
| 2.0 |
| 6.0 |
| 400.0 |
| 10210.25 |
| 10210.28 |
| 7.0 | r1040006 | SOUTH SHORE RESTAURANT | SOUTH SHORE PARK | Staten Island | NY | 10065 | 2.0 | 6.0 | 400.0 | 10210.25 | 10210.28 |
| 11.0 | b0070011 | BENSONHURST PARK | BENSONHURST FLOWER SALES | — | — | — | 2.0 | 6.0 | 34.0 | 0.0 | 0.0 |
| 11.0 | b0070014 | BENSONHURST PARK | BENSONHURST FLOWER SALES | — | — | — | 2.0 | 6.0 | 34.0 | 0.0 | 0.0 |
| 14.0 | b0090006 | BOROUGH HALL | BORO HALL SHOE SHINE | — | — | — | 2.0 | 6.0 | 28.0 | 0.0 | 0.0 |
| 7.0 | r1040006 | SOUTH SHORE RESTAURANT | SOUTH SHORE PARK | Staten Island | NY | 10065 | 2.0 | 6.0 | 400.0 | 10210.25 | 10210.28 |
| 17.0 | b0280011 | DYKER BEACH PARK | SHORE, 86 ST., 7 TO 14 AVE. | — | — | — | 2.0 | 6.0 | 14.0 | 3900.99 | 3900.0 |
| 17.0 | b0280015 | DYKER BEACH PARK | SHORE, 86 ST., 7 TO 14 AVE. | — | — | — | 2.0 | 6.0 | 14.0 | 3900.99 | 3900.0 |
| 17.0 | b0280020 | DYKER BEACH PARK | SHORE, 86 ST., 7 TO 14 AVE. | — | — | — | 2.0 | 6.0 | 14.0 | 3900.99 | 3900.0 |
Showing 12 of 56 columns. All of them are listed below.
addressline3| text |
| — |
| 100% |
INDOOR TENNIS FACILITYNORTH OF AVE UPELHAM BAY PARK |
concessioncity | text | — | 83% | NEW YORKQueensStaten Island |
concessionstate | categorical | — | 83% | NYNMof 2 |
concessionzipcode | text | — | 85% | 100651122010008 |
concessionextraaddressinfo | text | — | 100% | — |
latepercentage | categorical | — | 0% | 2.00.02000.0of 3 |
endoffiscalyear | categorical | — | 0% | 6.012.09.0of 3 |
unitid | integer | — | 0% | 795.0353.02439.0 |
januaryminfee | float | — | 3% | 0.042618.570.01 |
februaryminfee | float | — | 3% | 0.020636.011025.0 |
marchminfee | float | — | 3% | 0.025059.011020.0 |
aprilminfee | float | — | 3% | 0.023531.010915.0 |
mayminfee | float | — | 3% | 0.08848.010910.0 |
juneminfee | float | — | 3% | 0.08846.010807.0 |
julyminfee | float | — | 4% | 0.016383.010806.0 |
augustminfee | float | — | 4% | 0.016382.010700.0 |
septemberminfee | float | — | 4% | 0.015172.010699.0 |
octoberminfee | float | — | 4% | 0.015168.010594.0 |
novemberminfee | float | — | 4% | 0.014045.015838.5 |
decemberminfee | float | — | 4% | 0.013250.015837.5 |
concessiontypeid | text | — | 15% | Q163-SBR79-MM52-SB |
unittype | text | — | 0% | PushcartSnack BarMobile Truck |
personid | integer | — | 0% | 5016.06698.06564.0 |
operatorlastname | text | — | 0% | PRINCESS BAY BOATMEN'S A…PARKING SERVICES PLUS, I…COUNCIL ON THE ENVIRONME… |
operatorfirstname | text | — | 79% | MARIAJOHNDONATO |
operatorstatus | categorical | — | 0% | 1.00.02.0of 3 |
permitorlicensestartdate | datetime | — | 0% | 2011-01-01T00:00:00.0002004-01-15T00:00:00.0002026-02-27T00:00:00.000 |
permitorlicensefee | float | — | 0% | 0.011245.50.01 |
dueday | integer | — | 0% | 1.015.030.0 |
moveindate | datetime | — | 0% | 2011-01-01T00:00:00.0002004-01-15T00:00:00.0002025-12-31T00:00:00.000 |
permitorlicenseenddate | datetime | — | 0% | 2026-12-31T00:00:00.0002013-12-31T00:00:00.0002030-12-31T00:00:00.000 |
lategracedays | categorical | — | 1% | 10.01.06.0of 9 |
overagemonth | categorical | — | 0% | 1.00.010.0of 13 |
annualminimumfees1 | text | — | 49% | 0.00123,389.0075,000.00 |
annualminimumfees2 | text | — | 51% | 124,623.0079,500.000.00 |
annualminimumfees3 | text | — | 52% | 125,869.0084,270.000.00 |
annualminimumfees4 | text | — | 64% | 127,127.0091,012.001,485,691.00 |
annualminimumfees5 | text | — | 69% | 128,399.0098,293.001,530,000.00 |
percentduedate | text | — | 61% | N/A03/02/**01/30/** |
securitydepositreq | text | — | 1% | 0.00N/A37,267 |
permitnumber | text | — | 1% | Q163-SBR79-MM104-PL |
grossreceiptdate | text | — | 6% | **/30**/10**-10 |
origcontracexpdate | date | — | 13% | 2013-12-312014-12-312019-12-31 |
percentagefeereq | categorical | — | 3% | NoYesof 2 |
percentagefeedate | text | — | 38% | **/30N/A10/30/** |
letterofcreditinfo1 | text | — | 12% | 2941-RET. TO HANDS 12/04…39535209 |
letterofcreditinfo2 | text | — | 78% | 5098(9,000)4629-$23,095.21-JE335LOC#SM235620W |
addlocationinfo1 | text | — | 6% | VARIOUSLEMON CREEK PARKRANDALL'S ISLAND PARKING… |
addlocationinfo2 | text | — | 46% | HOLIDAY MARKETBEACH 149 STREETBTWN CPS & CPW |
capitalworkreq | text | — | 11% | NYN/A |
contractstatus | text | — | 53% | N/AEXPIREDEXP |
contractsigndate | datetime | — | 9% | 2011-01-01T00:00:00.0002004-01-15T00:00:00.0002025-12-31T00:00:00.000 |
contractenddate | datetime | — | 86% | 2024-01-14T00:00:00.0002023-06-30T00:00:00.0002021-08-13T00:00:00.000 |
geometrytype | categorical | — | 0% | POLYGONNO GEOMETRYPOINTof 3 |
shape | text | — | 25% | b'\xd7\x08\x00\x00\x01\x…b'\xd7\x08\x00\x00\x01\x…b'\xd7\x08\x00\x00\x01\x… |