crash_reports
2 rows where "datetime" is on date 2019-02-09 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-09
Time:
15:23
Address:
175 TEMPLE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was parked SB in front of 175 Temple St. from approximately 1000 hrs to 1430 hrs, and she came out to a note left on her vehicle. The note stated "I saw someone back into your car, I got their plate, MA Reg TC58LC, Black Suburban". and there was minor damage to the drivers side doors. MA Reg TC58LC came back to a HUTTER, Carol of 67 Randlett Pk, Newton. I responded to that address and attempted to raise HUTTER with no answer at the door. I then called the phone number listed from a past incident with the Newton Police and HUTTER answered the phone. She stated she was at the Temple attempting to parallel park when she thought she may have hit another vehicle. She stated she got out to look at the vehicle and didn't see any damage, so she took a photo of the license plate and would try to report it once she got home. MA Reg TC58LC had several scratches on the bumper of the vehicle.
Keywords:
Phone, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3423605
Longitude:
-71.2327106
Location:
Case
number:
Date:
2019-02-09
Time:
15:59
Address:
54 ASH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/9/19 I responded to 54 Ash St and met with Ms. Zardar Hovhannisyan in regards to a past hit & run to her vehicle. Hovhannisyan parked MA reg 1EC474 on Ash St (a northbound public one way street) just prior to Commonwealth Ave around 0800 hrs this morning. When she returned around 1000 hrs, she noticed moderate damage to the front left area of the vehicle. There was minor debris on the ground consistent with the damage I viewed. It should be noted that there are parking stalls parallel to where the vehicle was parked, with several residents of Norumbega Gardens coming and going quite frequently. It is not believed that there are cameras facing the specific area where the collision occurred. Hovhannisyan was advised to contact her insurance company.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3468969
Longitude:
-71.251064
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);