crash_reports
2 rows where "datetime" is on date 2019-02-12 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-12
Time:
14:02
Address:
CENTRE ST & NEWTONVILLE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED SHE WAS TRAVELING SOUTH ON CENTRE ST WHEN SHE STOPPED AT THE CROSSWALK AT INTERSECTION OF NEWTONVILLE AVE AND CENTRE ST FOR A PEDESTRIAN WALKING THEIR DOG. ONCE MV 1 CAME TO A COMPLETE STOP THEY WERE STRUCK IN THE REAR BY MV 2. MV 1 WAS UNABLE TO GET A LICENSE PLATE OR A DESCRIPTION DUE TO THE WEATHER (HEAVY SNOW) AND THE FACT THAT THEY JUST PULLED OVER TO THE SIDE AND ASSUMED MV 2 WOULD DO THE SAME. MV 2 NEVER PULLED OVER TO EXCHANGE INFORMATION AND CONTINUED GOING SOUTH ON CENTRE STREET. MV 1 SUSTAINED MODERATE REAR END DAMAGE AND NO INJURIES REPORTED. THERE WAS A PARTIAL PLATE GIVEN BY THE PEDESTRIAN CROSSING THE STREET OF 915.
Keywords:
Crosswalk, Moderate, Ped, Snow, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3515559
Longitude:
-71.1861175
Location:
Case
number:
Date:
2019-02-12
Time:
23:20
Address:
292 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that his vehicle was struck from behind by Vehicle #2. Operator #2 then stated, "there is no damage", and left the area. Operator #1 then took down the registration of Vehicle #2, and notified the police. I observed significant fresh damage to the rear bumper of Vehicle #1. Vehicle #2 is registered to a Ms. Jessica Gavell. I was later able to learn that the vehicle was being operated by her cousin, a Mr. Michael Gavell. Mr. Gavell was issued a citation for a violation of M.G.L. Ch.90/24-Leaving the Scene of Property Damage, and Ch.90/23-Operating MV after suspension due to OUI. (See Incident#19005785). None of the parties involved complained of injury, when asked.
Keywords:
Citation
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.358291
Longitude:
-71.184698
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);