crash_reports
2 rows where dcc contains "Unknown" and "retrieved" is on date 2021-03-29
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-19
Time:
09:42
Address:
BRACKETT RD & PARK AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Veh #1 stated that she was traveling WB on Brackett Road, stopped at the stop sign. Veh #1 then tried to cross intersection of Park Ave where she was struck by Veh #2. She stated she didn't see veh #2 because her vision was obstructed by the bushes on the corner. She also believed that Veh #2 was speeding. Oper of Veh #2 stated she was driving SB on Park Ave when Veh # 1 pulled in front of her. Stated she didn't have time to stop. Also stated she was not speeding. Mailman on scene stated Veh #1 pulled out and didn't give Veh #2 time to stop,also stated veh # 2 may have been going a little fast. Did not leave info. Both cars towed by Todys. No injuries were reported.
Keywords:
Bus, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3430685
Longitude:
-71.1855112
Location:
Case
number:
Date:
2021-03-25
Time:
17:03
Address:
CENTRE ST & LANGLEY RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was parked at a meter parking spot facing northbound on Centre Street at Langley Road when MV2, a dark colored BMW (no model or plate), struck the left front tire with MV2's front right fender causing MV1's tire to go flat.. MV2 fled the scene without exchanging information. No injuries reported.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3312062
Longitude:
-71.1946329
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);