From a 500-row sample across 8 columns.
bblcheck_numbercase_number| case_number | issue_date | check_number | bbl | effective_date | refund_year | refund_number | amount |
|---|---|---|---|---|---|---|---|
| 100001 | 2020-10-22T00:00:00.000 | 2103414 | 1-01553-0104 | 2020-07-01T00:00:00.000 | 2021 | 310665 | 1128.18 |
| 100002 | 2020-10-22T00:00:00.000 | 2103431 | 1-01561-0009 | 2020-07-01T00:00:00.000 | 2021 | 310666 | 704.72 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
case_number | text | CASE NUMBER | 0% | 3148552034315586165 |
issue_date | datetime | Date Check was Issued | 0% | 2019-10-03T00:00:00.0002019-10-17T00:00:00.0002020-06-25T00:00:00.000 |
check_number | text | CHECK NUMBER | 0% | ACH20119812003283 |
bbl | text | Borough Block Lot. Borough 1 = Manhattan; 2 = Bronx; 3 = Brooklyn ; 4 = Queens; 5 = Staten Island | 0% | 4-09806-00201-99999-00092-02381-1044 |
GET /api/datasets/w5ea-ydu3 GET /api/datasets/w5ea-ydu3/quality GET /api/datasets/w5ea-ydu3/related GET /api/columns?dataset=w5ea-ydu3
| 100003 |
| 2020-10-22T00:00:00.000 |
| 2103383 |
| 3-00154-0028 |
| 2020-07-01T00:00:00.000 |
| 2021 |
| 302354 |
| 22272.06 |
| 100004 | 2020-10-22T00:00:00.000 | 2103432 | 1-01561-0011 | 2020-07-01T00:00:00.000 | 2021 | 310667 | 1603.4 |
| 100005 | 2020-10-22T00:00:00.000 | 2103432 | 1-01561-0012 | 2020-07-01T00:00:00.000 | 2021 | 310668 | 1022.16 |
| 100006 | 2020-10-22T00:00:00.000 | 2103429 | 1-01562-0042 | 2020-07-01T00:00:00.000 | 2021 | 310669 | 858.76 |
| 100008 | 2020-10-22T00:00:00.000 | 2103407 | 3-00165-0022 | 2020-07-01T00:00:00.000 | 2021 | 302355 | 32279.04 |
| 100009 | 2020-10-22T00:00:00.000 | 2103430 | 1-01568-0043 | 2020-07-01T00:00:00.000 | 2021 | 310670 | 740.28 |
| 100011 | 2020-10-22T00:00:00.000 | 2103440 | 1-01580-0010 | 2019-07-01T00:00:00.000 | 2021 | 310671 | 1411.92 |
| 100011 | 2020-10-22T00:00:00.000 | 2103440 | 1-01580-0010 | 2020-07-01T00:00:00.000 | 2021 | 310672 | 1720.66 |
effective_date | datetime | Effective Date | 0% | 2019-07-01T00:00:00.0002020-07-01T00:00:00.0002022-07-01T00:00:00.000 |
refund_year | text | Refund Tax Year | 0% | 202020212023 |
refund_number | text | — | 0% | 381971710969251016 |
amount | float | Amount of the Refund | 0% | 14.940.010.02 |