crash_reports
1 row where "datetime" is on date 2020-08-25 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-25
Time:
12:45
Address:
2014 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 8/25/2020 at approx 1245hrs while assigned to 497 I responded to NWH emergency ambulance entrance for a report of a past hit and run reported by Walpole Fire Dept personnel. Upon arrival I met with Firefighter Albert KING who stated he was travelling E/B on Washington St towards NWH with a patient and 2 other Firefighters on board when a black Toyota Prius being operated by a Asian female bumped into his front passenger side. FF KING stated he tried to communicate with the women to pull into the hospital and meet him at the ER but upon turning she continued straight on Washington St. KING stated he did not get a license plate number. Minor paint transfer to front passenger side as well as damage to front passenger wheel guard. Patient information not included for privacy, see Walpole Fire dept trip sheet if needed.
Keywords:
Ems, Fire, Hospital
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);