cityofnewyork-us/civilian-complaint-review-board-complaints-against-2mby-ccnw
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 5 hours ago
Indexed 41 minutes ago

Civilian Complaint Review Board: Complaints Against Police Officers

The primary table for all public data on complaints, including dates, locations and the outcomes of closed complaints received since the year 2000.

The dataset is part of a database of all public police misconduct records the Civilian Complaint Review Board (CCRB) maintains on complaints against New York Police Department uniformed members of service received in CCRB's jurisdiction since the year 2000, when CCRB's database was first built. This data is published as four tables:

<a href="https://data.cityofnewyork.us/d/2fir-qns4/">Civilian Complaint Review Board: Police Officers</a>

<a href="https://data.cityofnewyork.us/d/2mby-ccnw/">Civilian Complaint Review Board: Complaints Against Police Officers</a>

<a href="https://data.cityofnewyork.us/d/6xgr-kwjq/">Civilian Complaint Review Board: Allegations Against Police Officers</a>

<a href="https://data.cityofnewyork.us/d/keep-pkmh/">Civilian Complaint Review Board: Penalties</a>

A single complaint can include multiple allegations, and those allegations may include multiple subject officers and multiple complainants.

Public records exclude complaints and allegations that were closed as Mediated, Mediation Attempted, Administrative Closure, Conciliated (for some complaints prior to the year 2000), or closed as Other Possible Misconduct Noted.

This database is inclusive of prior datasets held on Open Data (previously maintained as "Civilian Complaint Review Board (CCRB) - Complaints Received," "Civilian Complaint Review Board (CCRB) - Complaints Closed," and "Civilian Complaint Review Board (CCRB) - Allegations Closed") but includes information and records made public by the June 2020 repeal of New York Civil Rights law 50-a, which precipitated a full revision of what CCRB data could be considered public.

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 \"cityofnewyork-us/civilian-complaint-review-board-complaints-against-2mby-ccnw\".\"civilian_complaint_review_board_complaints_against\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • civilian_complaint_review_board_complaints_against
     
     
     
     
     
Upstream Metadata