crash_reports
1 row where "date" is on date 2021-09-14 and geocoded_address = "Massachusetts Turnpike, Newton, MA, USA"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-14
Time:
09:02
Address:
CENTRE AVE & MASS PIKE OFF RAMP E/B
Speed
limit:
30
Violation
cited:
no
Narrative:
On September 14th, 2021 at approximately 09:02 hours while working N491 I responded to a report of a MV crash on Centre Ave near Centre St. On my arrival I located one of the involved vehicles a 2013 Grey Honda Civic, Ma plate 11JL66, operated by a Rita Kraner. She stated she was going over the Centre Ave bridge E/B when she yielded to the traffic coming of the Mass pike E/B. Her vehicle was then rear ended by vehicle #2. However that vehicle continued East without stopping. Ms Kraner was unable to get a description of vehicle #2 other that it was possibly a white van. Vehicle #2 left scene without stopping. Operator #1 sustained head and neck injury but signed a patient refusal for Fallon Ambulance. Her vehicle didn't need to be towed.
Keywords:
Crash, Ems
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3501037
Longitude:
-71.2142698
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);