Crash Reporting - Non-Motorists Data

This dataset provides information on non-motorists (pedestrians and cyclists) involved in traffic collisions occurring on county and local roadways.The reports details of all traffic collisions occurring on county and local roadways within Montgomery County, as collected via the Automated Crash Reporting System (ACRS) of the Maryland State Police, and reported by the Montgomery County Police, Gaithersburg Police, Rockville Police, or the Maryland-National Capital Park Police. This dataset shows each collision data recorded and the non-motorists involved.

Please note that these collision reports are based on preliminary information supplied to the Police Department by the reporting parties. Therefore, the collision data available on this web page may reflect:

-Information not yet verified by further investigation

-Information that may include verified and unverified collision data

-Preliminary collision classifications may be changed at a later date based upon further investigation

-Information may include mechanical or human error

This dataset can be joined with the other 2 Crash Reporting datasets (see URLs below) by the State Report Number.

• Crash Reporting - Incidents Data at https://data.montgomerycountymd.gov/Public-Safety/Crash-Reporting-Incidents-Data/bhju-22kf

• Crash Reporting - Drivers Data at https://data.montgomerycountymd.gov/Public-Safety/Crash-Reporting-Drivers-Data/mmzv-x632

Update Frequency : Weekly

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 \"montgomerycountymd-gov/crash-reporting-nonmotorists-data-n7fk-dce5\".\"crash_reporting_nonmotorists_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.