crash_reports
3 rows where dcc = "["Unknown"]" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-27
Time:
19:51
Address:
1149 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was parked, unoccupied, facing eastbound in the area of 1155 Washington St. The operator stated he observed a "light" colored Tesla (unknown registration) which was parked in front of MV#1, back into the vehicle before continuing eastbound onto Washington St. A very small scratch was observed below the passenger side headlight. Incident documented for insurance purposes.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3495382
Longitude:
-71.2205749
Location:
Case
number:
Date:
2021-11-02
Time:
16:31
Address:
39 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was parked in front of 39 Commonwealth ave. Operator stated it was parked at approximately 1330hrs with no damage. Operator of MV1 stated that at approximately 1631 hours they noticed damage to the front driver side wheel well fender. MV1 operator stated that a vehicle was parked in front of his vehicle with extensive damage. I witnessed red paint transfer, but not blue paint transfer on the gray vehicle parked in front of MV1.
Keywords:
Severe
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3399286
Longitude:
-71.1683847
Location:
Case
number:
Date:
2021-11-09
Time:
16:49
Address:
50 EDDY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 11/9/21 Alexandra Hogan came to NPD Headquarters to report a past mva that occurred at 0730hrs today. Hogan states she was driving southbound on Eddy St in MA reg WS1543 (vehicle #1), when she observed MA reg CI396B (vehicle #2) driving down the middle of the road northbound. Hogan was unable to swerve out of the way and contact was made. She reports extensive damage to the front left side of her vehicle. Operator #2 left her information with Hogan and allegedly stated that the sun was in her eyes. She was apologetic. Attempts to call operator #2 were met with negative results. Hogan reports no injuries but needed documentation for her insurance company.
Keywords:
Severe, Solar
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3513132
Longitude:
-71.2160988
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);