Police Officer Memorial Honor Roll: Beginning 1791

A listing of the police officers from around New York State who died while in the performance of their duties. The Office of Public Safety (OPS) of the NYS Division of Criminal Justice Services (DCJS) facilitates and provides support services for all activities surrounding the New York State Police Officers Memorial. A Remembrance Ceremony is held at the Memorial each year during the month of May.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/police-officer-memorial-honor-roll-beginning-1791-psym-z9ae\".\"police_officer_memorial_honor_roll_beginning_1791\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.