crash_reports
3 rows where "datetime" is on date 2019-03-12, intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-12
Time:
08:43
Address:
279 CHESTNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 03/12/2019, I responded to the area of 279 Chestnut St for two car motor vehicle accident. On arrival, I spoke with the operator of MV1 (MA Reg: 824WA6) who stated that he was driving northbound on Chestnut St when he was rear ended by MV2. I spoke with the operator of MV2 (MA Reg: 4DN621) who stated that she was travelling northbound on Chestnut St behind MV1. MV2 stated that they were in stop and go traffic and misjudged the distance and rear ended MV1. MV1 sustained moderate damage to its rear end. MV2 sustained moderate damage to the front end and had airbags deployed. All parties were evaluated by medics and signed patient refusals. MV2 was towed from the scene by Tody's Towing.
Keywords:
Airbag, Crash, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3400512
Longitude:
-71.2238931
Location:
Case
number:
Date:
2019-03-12
Time:
09:59
Address:
182 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS STOPPED N/B ON WASHINGTON ST FOR THE TRAFFIC LIGHT AT THE INTERSECTION OF CENTRE AVE/ MASS PIKE E/B ENTRANCE WHEN SHE WAS REAR ENDED BY VEHICLE #2. OPERATOR #2 STATED SHE WAS TRAVELLING N/B ON WASHINGTON ST WHEN SHE BEGAN TO SLOW DOWN DUE TO THE TRAFFIC AHEAD OF HER WAS STOPPED DUE TO A RED LIGHT. SHE THEN REPORTS THAT AS SHE WAS ABOUT TO HIT HER BRAKE TO COME TO A FULL STOP, SHE WAS STRUCK ON HER DRIVERS SIDE REAR WHICH CAUSED HER TO BE PUSHED FORWARD ALL THE WHILE ATTEMPTING TO JAM ON HER BRAKES TO AVOID CRASHING INTO THE VEHICLE IN FRONT OF HER. VEHICLE #2 STILL WAS FORCED INTO THE REAR OF VEHICLE #1 BY VEHICLE #3. OPERATOR #3 STATED HE WAS GOING N/B ON WASHINGTON ST WHEN HE ATTEMPTED TO GO AROUND VEHICLE #2 ON THE LEFT THINKING THERE WAS ENOUGH CLEARANCE FOR TWO LANES OF TRAFFIC. AT THE TIME PRIOR TO CRASH THERE WAS A SINGLE LANE OF TRAFFIC AHEAD. OPERATOR #3 FURTHER STATED AS HE BEGAN TO GO TO THE LEFT OF VEHICLE #2 HE THOUGHT SHE BEGAN TO GO TO THE LEFT ALSO CAUSING HIM TO HIT HER VEHICLE. I AGAIN SPOKE WITH OPERATOR#2 ABOUT WHAT OPERATOR TO VEHICLE #3 STATED AND SHE STATED THAT SHE NEVER WENT TO HER LEFT PRIOR TO THE CRASH.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3563285
Longitude:
-71.1816752
Location:
Case
number:
Date:
2019-03-12
Time:
14:36
Address:
30 TOWER RD
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated he parked his vehicle in the parking lot of 30 Tower Rd and went inside the store to shop. He returned to his vehicle and discovered that the front and rear passenger side doors had been damaged. The owner of MV#1 stated he went back into the store in hopes to view surveillance videos of the accident but came up with negative results.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3102612
Longitude:
-71.2156323
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);