crash_reports

Table actions

1 row where "datetime" is on date 2022-05-22, dcc contains "Visibility obstructed" and intersection = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

Case number:
22000437
Date:
2022-05-22
Time:
18:48
Address:
WASHINGTON ST & CRAFT ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 5-22-22 AT APPROX. 1848HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 25 CRAFTS ST. I SPOKE TO THE DRIVER OF VEHICLE #1. DRIVER STATES SHE WAS HEADED N-BOUND ON CRAFTS WHEN VEHICLE #2 ENTERED THE TRAFFIC LANE AND HIT HER LEFT SIDE CAUSING DAMAGE. VEHICLE #2 STATES SHE WAS EXITING WHOLE FOODS FROM THE CRAFTS ST. EXIT GOING LEFT ON CRAFTS. SHE STATED WHILE EXITING SHE HIT VEHICLE #1 WHO HAD CUT IN FRONT OF HER. BOTH PARTIES HAD THEIR VISIBILITY OBSTRUCTED BECAUSE NEITHER VEHICLE SAW EACH OTHER UNTIL THEY CRASHED. . VEHICLE #1 HAD LEFT SIDE DAMAGE AND WAS STILL OPERATIONAL. VEHICLE #2 HAD FRONT END DAMAGE AND WAS TOWED BY AAA. BOTH PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE AGENCIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.353961
Longitude:
-71.198957
Location:
Crafts St & Washington St, Newton, MA 02458, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);