cityofnewyork-us/nypd-shooting-incident-data-year-to-date-5ucz-vwe8
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 5 days ago
Indexed 32 minutes ago

NYPD Shooting Incident Data (Year To Date)

List of every shooting incident that occurred in NYC during the current calendar year.

This is a breakdown of every shooting incident that occurred in NYC during the current calendar year. This data is manually extracted every quarter and reviewed by the Office of Management Analysis and Planning before being posted on the NYPD website.

Each record represents a shooting incident in NYC and includes information about the event, the location and time of occurrence. In addition, information related to suspect and victim demographics is also included. This data can be used by the public to explore the nature of police enforcement activity. Please refer to the attached data footnotes for additional information about this dataset.

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/nypd-shooting-incident-data-year-to-date-5ucz-vwe8\".\"nypd_shooting_incident_data_year_to_date\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • nypd_shooting_incident_data_year_to_date
     
     
     
     
     
Upstream Metadata