crash_reports
2 rows where "retrieved" is on date 2022-04-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-04
Time:
16:02
Address:
314 WASHINGTON ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV1 stated he was travelling straight ahead when his dog jumped in his lap causing him to swerve and rear end MV2 which was parked & unoccupied. Operator of MV1 was cited for Impeded Operation (Dog). Both vehicles were towed from the scene and no injuries were reported.
Keywords:
Citation
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.356791
Longitude:
-71.186449
Location:
Case
number:
Date:
2022-04-04
Time:
17:12
Address:
THORNTON ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 stated he was turning right from Thornton St onto Washington St and trying to get into the left lane when he made contact with MV2. MV2 stated she was travelling straight ahead on Washington St when MV1 struck her vehicle. Both vehicles were towed from the scene and the operator of MV2 was transported to Newton Wellesley Hospital for pain to her right arm.
Keywords:
Hospital
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3564751
Longitude:
-71.1883202
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);