crash_reports
1 row where "date" is on date 2019-02-12 and street1 = "NORTH 292 CENTRE ST"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-12
Time:
23:20
Address:
292 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that his vehicle was struck from behind by Vehicle #2. Operator #2 then stated, "there is no damage", and left the area. Operator #1 then took down the registration of Vehicle #2, and notified the police. I observed significant fresh damage to the rear bumper of Vehicle #1. Vehicle #2 is registered to a Ms. Jessica Gavell. I was later able to learn that the vehicle was being operated by her cousin, a Mr. Michael Gavell. Mr. Gavell was issued a citation for a violation of M.G.L. Ch.90/24-Leaving the Scene of Property Damage, and Ch.90/23-Operating MV after suspension due to OUI. (See Incident#19005785). None of the parties involved complained of injury, when asked.
Keywords:
Citation
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.358291
Longitude:
-71.184698
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);