crash_reports
2 rows where "datetime" is on date 2019-12-06, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date)
Case
number:
Date:
2019-12-06
Time:
14:16
Address:
1309 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 (MA. reg. STJ711) states he was parked outside of 1309 Washington Street when his drivers side mirror was side swiped by MV2 (MA. reg. A878.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.349591
Longitude:
-71.2271417
Location:
Case
number:
Date:
2019-12-06
Time:
17:36
Address:
332 LANGLEY RD
Speed
limit:
30
Violation
cited:
no
Narrative:
On Friday 12/6/2019 at approximately 1736 hours while assigned to marked unit n499 I was dispatched to the area of 332 Langley Rd. for a report of a 3 car MVA with minor injuries. Upon arrival I spoke with the operator of MV#1 GARCIA, Sarah, who states that her vehicle was rear ended while she was stopped attempting to make a left into a driveway at Langley Rd. She was rear ended by a vehicle (MV#2) operated by TANZER, Harvey. I spoke with TANZER who states that his vehicle was rear ended by MV#3 as he stopped behind GARCIA's vehicle causing him to strike the rear of GARCIA's vehicle ( MV#1). Operator of MV#3 was identified as MELTON, Andrea. When I asked MELTON what happened, she stated that she diidnt know. MELTON stated she was driving on Langley Rd. and the vehicles were just there stopped.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.322468
Longitude:
-71.1848161
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);