crash_reports
4 rows where date = "2019-06-10"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-10
Time:
07:22
Address:
1126 CENTRE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
VEHICLE #1 WAS TRAVELING STRAIGHT AHEAD ON CENTRE ST, HEADING NORTHBOUND. VEHICLE #2 WAS ALSO ON CENTRE ST, HEADING NORTHBOUND. AS BOTH VEHICLES PASSED BY WILLOW ST, VEHICLE #2, WHO WAS IN THE RIGHT LANE, TRIED TO PASS VEHICLE #1 ON THE RIGHT, WHEN VEHICLE #2 TRIED TO GET IN FRONT OF VEHICLE #1 IT STRUCK THAT VEHICLE, WHICH WAS A COMMERCIAL TRUCK. OPERATOR OF VEHICLE #1 STATED THAT HE NEVER SAW VEHICLE #2. NO INJURIES REPORTED. OFF DUTY NEWTON POLICE OFFICER LAU WITNESSED THE ACCIDENT, WHO WAS STOPPED ON WILLOW ST @ CENTRE ST AND NOTICED VEHICLE #2 TRY TO PASS VEHICLE #1 ON THE RIGHT. VEHICLE #2 OPERATOR WILL BE ISSUED CITATION #T0645460 BY MAIL FOR IMPROPER PASSING AND MARKED LANES VIOLATION.
Keywords:
Citation, Crash
Dcc:
Signs/Signals, Lane departure
Report
url:
Image
url:
Latitude:
42.3337491
Longitude:
-71.1932117
Location:
Case
number:
Date:
2019-06-10
Time:
11:57
Address:
210 BOYLSTON ST LOT
Speed
limit:
10
Violation
cited:
no
Narrative:
OPER OF MV#1 STATED THAT WHILE PARKED (#210 BOYLSTON ST LOT), MV#2 REVERSED INTO HER VEHICLE CAUSING MODERATE REAR DAMAGE. OPER OF MV#2 STATED THAT HE WAS BACKING HIS TRUCK UP, AND DID NOT SEE MV#1 PARKED. MV#2 (REAR) COLLIDED WITH THE REAR OF MV#1. MV#2 SUSTAINED MINOR REAR PAINT TRANSFER.
Keywords:
Moderate
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3187649
Longitude:
-71.1759039
Location:
Case
number:
Date:
2019-06-10
Time:
12:00
Address:
CENTRE ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Elaine Forsythe was operating vehicle #2. Elaine took the exit 17 off ramp and attempted to merge onto the Centre Ave rotary. Elaine states that at this time vehicle #1 struck the back of her vehicle. Brian Radzwill was operating vehicle #1. Brain states that while trying to merge onto the rotary he bumped into vehicle #2. Both vehicles had very minor damage. Forsythe was transported to NWH. Her vehicle was parked at the Richardson St lot, meter #4711. Parking control notified for consideration.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2019-06-10
Time:
17:17
Address:
131 TOLMAN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 parked his vehicle outside his residence from 1100-1600hrs today. When he returned home at 1630, he came outside and noticed someone had struck his rear drivers side bumper. The vehicle had moderate damage and did not require a tow. The vehicle was unoccupied at the time of the accident and no note or other party information was left. Operator of MV1 requested the accident to be documented for insurance purposes.
Keywords:
Crash, Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3592737
Longitude:
-71.2355375
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);