From a 500-row sample across 10 columns.
boroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| fiscal_year_fy_ | claim | borough | occurrence_date | filed_date | claim_type | disposition_date | disposition_amount | agency | claim_action |
|---|---|---|---|---|---|---|---|---|---|
| 2023 | 2018PI015819 | BRONX | 2018-03-01T00:00:00.000 | 2018-05-24T09:56:03.000 | Police Action | 2022-07-25T00:00:00.000 | 50000.00 | Police Department | SETTLED |
| 2023 | 2018PI003147 | BRONX | 2017-11-06T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
fiscal_year_fy_ | categorical | Indicates the fiscal year in which a claim was filed or settled. | 0% | 201620172018of 8 |
claim | text | This column sets forth the notice of claim identification number assigned to the notice of claim when it is filed with the Comptroller's Office | 0% | 2018PI0306492012PI0099392016PI001510 |
borough | text | This column sets forth the borough in which the claim arose | 7% | BRONXBROOKLYN (KINGS)MANHATTAN (NEW YORK) |
occurrence_date | datetime | This column sets forth the date on which the event giving rise to the claim took place | 3% |
GET /api/datasets/ex6k-ym48 GET /api/datasets/ex6k-ym48/quality GET /api/datasets/ex6k-ym48/related GET /api/columns?dataset=ex6k-ym48
boroughborough| 2018-01-31T11:49:07.000 |
| Police Action |
| 2022-11-23T00:00:00.000 |
| 22500.00 |
| Police Department |
| SETTLED |
| 2023 | 2018PI021882 | BRONX | 2018-01-13T00:00:00.000 | 2018-07-24T16:08:49.000 | Police Action | 2022-07-25T00:00:00.000 | 28000.00 | Police Department | SETTLED |
| 2023 | 2018PI019587 | BRONX | 2017-02-24T00:00:00.000 | 2018-07-02T16:20:23.000 | Police Action | 2023-04-04T00:00:00.000 | 12500.00 | Police Department | SETTLED |
| 2023 | 2018PI013601 | BRONX | 2018-01-23T00:00:00.000 | 2018-05-04T17:11:45.000 | Police Action | 2022-07-25T00:00:00.000 | 45000.00 | Police Department | SETTLED |
| 2023 | 2018PI015816 | BRONX | 2018-03-01T00:00:00.000 | 2018-05-24T09:54:44.000 | Police Action | 2022-07-25T00:00:00.000 | 20000.00 | Police Department | SETTLED |
| 2023 | 2018PI024873 | BRONX | 2018-06-07T00:00:00.000 | 2018-08-24T15:46:27.000 | Police Action | 2023-04-03T00:00:00.000 | 12500.00 | Police Department | SETTLED |
| 2023 | 2018PI026720 | BRONX | 2018-06-20T00:00:00.000 | 2018-09-14T13:02:10.000 | Police Action | 2023-04-12T00:00:00.000 | 20000.00 | Police Department | SETTLED |
| 2023 | 2018PI022039 | BRONX | 2018-04-28T00:00:00.000 | 2018-07-26T13:41:38.000 | Police Action | 2023-04-12T00:00:00.000 | 15000.00 | Police Department | SETTLED |
| 2023 | 2018PI005183 | BRONX | 2017-02-23T00:00:00.000 | 2017-07-06T00:00:00.000 | Police Action | 2022-10-24T00:00:00.000 | 75000.00 | Police Department | SETTLED |
2021-09-01T00:00:00.0002021-09-02T00:00:00.0002016-01-24T00:00:00.000 |
filed_date | datetime | This column sets forth the date on which the claim was filed with the Comptroller's Office | 0% | 2019-01-28T00:00:00.0002019-04-12T00:00:00.0002021-09-16T00:00:00.000 |
claim_type | text | This column sets forth the general category into which the claims falls; PI stands for personal injury; PD stands for property damage | 0% | Motor VehiclePolice ActionCorrection Facility |
disposition_date | datetime | This column sets for the date on which the claim was resolved | 70% | 2015-11-30T00:00:00.0002016-06-01T00:00:00.0002019-01-28T00:00:00.000 |
disposition_amount | integer | This column sets for the the amount for which the claim was resolved or settled | 70% | 15000.005000.007500.00 |
agency | text | This column sets for the agency alleged by the claimant to be responsible for the event(s) giving rise to the claim | 1% | Police DepartmentDepartment of CorrectionDepartment of Transporta… |
claim_action | categorical | Indicates whether a claim was filed or settled. | 0% | FILEDSETTLEDof 2 |