crash_reports
2 rows where "datetime" is on date 2020-02-21, intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-21
Time:
12:17
Address:
241 RIVERVIEW AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 was parked half up on the sidewalk across from #241 Riverview Ave. He attempted to pull forward and onto the street and forgot there was a fire hydrant in front of him. the vehicle struck the hydrant knocking it from its base. Operator reported no injuries and the vehicle did not require a tow. Officer Gaudet took several digital images and the City was notified about the hydrant.
Keywords:
Fire
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3579194
Longitude:
-71.2427809
Location:
Case
number:
Date:
2020-02-21
Time:
16:03
Address:
456 NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday 02/19/2020, at approximately 1500 hrs, operator of MV1 stated she was traveling eastbound on Newtonville Ave, right before Walnut Street, a dark colored pick up truck was traveling behind her. Operator of MV1 stated she was driving below speed limit due to the approaching intersection at Walnut street when MV2 went into the eastbound traveling lane attempting to go around her. While attempting to go around MV1, MV2 side swiped MV1 causing the driver side mirror to break off causing moderate damage to the driver side of her vehicle. Operator of MV1 stated the pick up truck then stopped in front of her and the operator, an adult male began to yell at her then drive off. Operator of MV1 stated she got back in her car and did not get any information and did not have her cell phone to call the police. Operator of MV1 stated she was able to drive her vehicle home that day. No further description of the pick up truck was provided.
Keywords:
Moderate, Phone, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3507274
Longitude:
-71.2064618
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);