From a 500-row sample across 9 columns.
zipcodeboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| uniqueid | dateofbite | species | breed | gender | spayneuter | borough | zipcode | age |
|---|---|---|---|---|---|---|---|---|
| 1 | 2018-01-01T00:00:00.000 | DOG | UNKNOWN | U | false | Brooklyn | 11220 | — |
| 2 | 2018-01-04T00:00:00.000 | DOG | UNKNOWN | U | false | Brooklyn | — | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
uniqueid | text | Unique dog bite case identifier | 0% | 28351643838 |
dateofbite | datetime | Date bitten | 0% | 2025-10-31T00:00:00.0002025-05-16T00:00:00.0002025-05-11T00:00:00.000 |
species | text | Animal Type (Dog) | 0% | DOGof 1 |
breed | text | Breed type | 6% | UNKNOWNPit BullMIXED |
age | text |
GET /api/datasets/rsgh-akpg GET /api/datasets/rsgh-akpg/quality GET /api/datasets/rsgh-akpg/related GET /api/columns?dataset=rsgh-akpg
borough| 3 | 2018-01-06T00:00:00.000 | DOG | Pit Bull | U | false | Brooklyn | 11224 | — |
| 4 | 2018-01-08T00:00:00.000 | DOG | Mixed/Other | M | false | Brooklyn | 11231 | 4 |
| 5 | 2018-01-09T00:00:00.000 | DOG | Pit Bull | U | false | Brooklyn | 11224 | — |
| 6 | 2018-01-03T00:00:00.000 | DOG | BASENJI | M | false | Brooklyn | 11231 | 4Y |
| 7 | 2018-01-01T00:00:00.000 | DOG | UNKNOWN | U | false | Brooklyn | — | — |
| 8 | 2018-01-03T00:00:00.000 | DOG | Pit Bull | U | false | Brooklyn | 11233 | — |
| 9 | 2018-01-04T00:00:00.000 | DOG | American Pit Bull Mix / Pit Bull Mix | M | false | Brooklyn | 11235 | 5Y |
| 10 | 2018-01-10T00:00:00.000 | DOG | MIXED | F | false | Brooklyn | 11208 | 3Y |
| Dog's age at time of bite. Numbers with 'M' indicate months. |
| 54% |
231 |
gender | categorical | Sex of Dog. M=Male, F=Female, U=Unknown | 0% | UMFof 3 |
spayneuter | boolean | Surgical removal of dog's reproductive organs. True (reported to DOHMH as Spayed or Neutered), False (Unknown or Not Spayed or Neutered) | 0% | FalseTrueof 2 |
borough | categorical | Dog bite Borough. Other' indicates that the bite took place outside New York City | 0% | QueensManhattanBrooklynof 6 |
zipcode | text | Dog bite Zipcode. Blank ZipCode indicates that information was not available | 34% | 100291012811208 |