From a 500-row sample across 7 columns.
check_numbercase_numberbblbbl| check_number | check_date | bbl | case_number | period_begin | period_end | refund_amount |
|---|---|---|---|---|---|---|
| 7042305 | 2018-11-01T00:00:00.000 | 3-8769-1002 | 17337514 | 2018-07-01T00:00:00.000 | 2018-09-30T00:00:00.000 | 466.21 |
| 7042306 | 2018-11-01T00:00:00.000 | 4-9794-19 | 17374184 | 2019-01-01T00:00:00.000 | 2019-06-30T00:00:00.000 | 344.34 |
| 7042306 | 2018-11-01T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
check_number | text | CHECK NUMBER | 0% | 704982970482467042874 |
check_date | datetime | Date Check was Issued | 0% | 2018-12-06T00:00:00.0002019-01-10T00:00:00.0002018-11-01T00:00:00.000of 14 |
bbl | text | Borough Block Lot | 0% | 5-2450-17323-1893-12223-1893-1223 |
case_number | text | CASE NUMBER | 0% | 170073601724458117244580 |
GET /api/datasets/j7in-ctnu GET /api/datasets/j7in-ctnu/quality GET /api/datasets/j7in-ctnu/related GET /api/columns?dataset=j7in-ctnu
| 4-9794-19 |
| 17374184 |
| 2018-07-01T00:00:00.000 |
| 2018-12-31T00:00:00.000 |
| 344.34 |
| 7042307 | 2018-11-01T00:00:00.000 | 5-4621-27 | 17230805 | 2018-04-01T00:00:00.000 | 2018-06-30T00:00:00.000 | 162.13 |
| 7042308 | 2018-11-01T00:00:00.000 | 3-8665-495 | 17377553 | 2019-01-01T00:00:00.000 | 2019-03-31T00:00:00.000 | 71.24 |
| 7042308 | 2018-11-01T00:00:00.000 | 3-8665-495 | 17377553 | 2019-04-01T00:00:00.000 | 2019-06-30T00:00:00.000 | 71.24 |
| 7042308 | 2018-11-01T00:00:00.000 | 3-8665-495 | 17377553 | 2018-07-01T00:00:00.000 | 2018-09-30T00:00:00.000 | 71.24 |
| 7042308 | 2018-11-01T00:00:00.000 | 3-8665-495 | 17377553 | 2018-10-01T00:00:00.000 | 2018-12-31T00:00:00.000 | 71.24 |
| 7042309 | 2018-11-01T00:00:00.000 | 1-1171-62 | 17377431 | 2018-07-01T00:00:00.000 | 2018-12-31T00:00:00.000 | 59766.22 |
| 7042310 | 2018-11-01T00:00:00.000 | 2-2842-29 | 17349389 | 2018-07-01T00:00:00.000 | 2018-12-31T00:00:00.000 | 922.26 |
period_begin | datetime | Period begin date | 0% | 2018-07-01T00:00:00.0002018-01-01T00:00:00.0002017-07-01T00:00:00.000 |
period_end | datetime | Period end date | 0% | 2018-07-01T00:00:00.0002018-01-01T00:00:00.0002017-07-01T00:00:00.000 |
refund_amount | float | REFUND AMOUNT | 0% | 3.6863.3661.66 |