crash_reports
2 rows where date = "2022-04-26" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-26
Time:
12:34
Address:
HIGHLAND ST & TEMPLE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 4-26-22 AT APPROX. 1234HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF TEMPLE AND HIGHLAND ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING S-BOUND ON HIGHLAND ST. SHE STATES VEHICLE #2 ENTERED THE TRAFFIC LANE FROM TEMPLE ST. AND CUT HER OFF. SHE STARTED SHE STARTED BEEPING HER HORN REPEATEDLY AT WHICH POINT VEHICLE #2 STOPPED HIS VEHICLE ABRUPTLY AND SHE WAS UNABLE TO AVOID HITTING HIM. DRIVER STATES VEHICLE #2 STOPPED DELIBERATELY KNOWING SHE WOULD BE UNABLE TO AVOID HITTING HIM. DRIVER OF VEHICLE #2 STATES HE ENTERED HIGHLAND ST. FROM TEMPLE AND WAS TRAVELING S-BOUND. HE STATES VEHICLE #1 WAS BEEPING HER HORN REPEATEDLY. HE STATES HE STOPPED TO SEE IF THERE WERE A PROBLEM AT WHICH TIME VEHICLE #1 HIT HIS VEHICLE. VEHICLE #1 HAD MINOR FRONT END DAMAGE. VEHICLE #2 HAD MINOR REAR END DAMAGE. BOTH PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3457188
Longitude:
-71.2256908
Location:
Case
number:
Date:
2022-04-26
Time:
17:01
Address:
345 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 stated he was attempting to pull into traffic when he made contact with MV2 causing minor damage. MV2 stated he was travelling straight when MV1 pulled out and hit him causing minor damage. No injuries reported & no tows required.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3568934
Longitude:
-71.1877425
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);