crash_reports
1 row where dcc = "["Signs/Signals", "Inattention"]" and "retrieved" is on date 2021-03-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-08
Time:
16:51
Address:
ADAMS ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Monday, March 8th 2021, at approximately 4:51pm, I, Officer Brooks, responded to the intersection of Washington street and Adams street for an auto pedestrian accident. The vehicle involved was described as a 4 door blue sedan and had fled the scene northbound on Adams street. The injured party was not able to provide any further description of the vehicle or operator, and no witnesses were present. I spoke with Traivon King who was the party that had been struck by the vehicle. He stated he was walking eastbound on Washington street, and had the cross walk signal to cross over Adams street. The blue sedan was traveling westbound on Washington street and turned northbound on Adams street ignoring the crosswalk signal. King stated he was struck on the right side of his body and knocked to the ground. The operator of the car stopped briefly and stated the sun had been in his eyes before driving away. King complained of pain to his right arm, and was transported by Fallon ambulance services to NWH. It should be noted it was day light, the weather was clear, and King was wearing a green plaid jacket, a plaid hat, and blue jeans. Due to the fact the vehicle had fled the scene and the victim was aready being tended to by the medics photos were not taken.
Keywords:
Crash, Crosswalk, Ems, Ped, Pictures, Solar, Walk
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3548522
Longitude:
-71.1956673
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);