crash_reports
1 row where date = "2021-06-21", "retrieved" is on date 2021-07-04 and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-21
Time:
13:11
Address:
238 GRANT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated he came to a stop on Grant Ave N/B at #238 for a vehicle that was backing out of that driveway. #1 stated at that time he was rear ended by Mv#2. #1 operator was outside on the sidewalk when I arrived on scene. #1 stated he had neck and back pain from being rear ended. #1 front seat passenger stated she had neck pain. #1 operator already exchanged #2 operator and vehicle info. #2 left scene prior to my arrival. Both #1 occupants were evaluated and transported by medics to NWH for further evaluation. #1 was towed by Tody's with moderate rear end damage. I responded to #2 operator address to get a statement. #2 was not home. Her statement was taken over the phone. #2 stated she was travelling on Beacon St E/B, turned N/B on Grant Ave then couldn't stop in time and rear ended #1. #2 was not injured and stated she had minor front end damage.
Keywords:
Moderate, Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3317879
Longitude:
-71.1879481
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);