crash_reports
3 rows where "datetime" is on date 2019-03-26 and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-26
Time:
10:54
Address:
CHERRY ST & WEBSTER ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
ON 3-26-19 AT APPROX. 1054HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WEBSTER AND CHERRY ST. I S[POKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WEBSTER AND HAD THE GREEN LIGHT. WHEN HE WENT THROUGH THE INTERSECTION HE WAS HIT IN THE LEFT SIDE BY VEHICLE #2. VEHICLE #1 STATES AFTER BEING HIT HIS VEHICLE SPUN AND HIS RIGHT REAR SIDE HIT A EVERSOURCE UTILITY POLE ( 453/7 ). AFTER HITTING THE UTILITY POLE HIS VEHICLE CONTINUED TO MOVE ACROSS THE STREET TO 35 WEBSTER WHERE HE HIT A ROCK WALL CAUSING DAMAGE TO HIS LEFT FRONT. VEHICLE #2 STATES SHE WAS TRAVELING S-BOUND ON CHERRY ST. AS SHE APPROACHED WEBSTER ST. SHE STATES SHE WAS BLINDED BY SUN GLARE AND CONFUSED THE LIGHTS AT CHERRY AND WASHINGTON AS BEING THE CORRECT LIGHTS ( THEY WERE GREEN AT THE TIME ). WHEN SHE REALIZED THE LIGHT AT CHERRY AND WEBSTER WAS RED SHE WAS UNABLE TO AVOID HITTING VEHICLE #1. VEHICLE #1 HAD EXTENSIVE REAR AND LEFT FRONT END DAMAGE AND WAS TOWED BY TODYS. VEHICLE #2 HAD EXTENSIVE FRONT END DAMAGE AND WAS TOWED BY TODYS. OPERATOR OF VEHICLE #2 WAS MAILED CITATION ( T1442287 ) FOR CHAPTER 89/9 FAILURE TO YIELD. VEHICLE #1 WAS MAILED CITATION ( T1442286 ) FOR PASSENGER RESTRICTION VIOLATIONS UNDER JUNIOR OPERATOR LICENSE. ALL PARTIES , ( WITH THE EXCEPTION OF WRIGLEY LOWE ) REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. CHRISTOPHER CAMPBELL AND SERGIO ALVAREZ WERE TURNED OVER TO THEIR PARENTS. WRIGLEY LOWE WAS TRANSPORTED BY MEDIC2 TO NEWTON WELLESLEY HOSPITAL FOR MINOR CUTS. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. I TOOK APPROX. 7 PICTURES OF THE UTILITY POLE AND THE ROCK WALL. DISC TURNED OVER TO I.T. DIRECTOR SMITH. NEW DISC PLACED IN 492 CAMERA.
Keywords:
Citation, Crash, Glare, Hospital, Pictures, Severe, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.350159
Longitude:
-71.228704
Location:
Case
number:
Date:
2019-03-26
Time:
14:38
Address:
207 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 03/26/19 at 14:38 hours, I responded to 207 Nahanton Street for a two car motor vehicle accident with no injuries. Operator of M/V # 1 states she was traveling straight ahead westbound on Nahanton Street in stop and go heavy traffic. She states that she was not able to stop in time and struck M/V # 2 in the rear end. Her vehicle sustained damage to the front end bumper and grille area. Operator of M/V # 2 states he was stopped in traffic on Nahanton Street (W B) when he was rear ended by M/V # 1. His vehicle sustained rear end damage to the bumper, trunk area, and quarter panels.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2992485
Longitude:
-71.1984147
Location:
Case
number:
Date:
2019-03-26
Time:
09:50
Address:
1950 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 3-26-19 AT APPROX. 0950HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1540 WASHINGTON ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WASHINGTON. HE STATES VEHICLE #2 WAS DRIVEN BY AN ELDERLY FEMALE WHO SUDDENLY VEERED RIGHT AND CUT HIM OFF OF HIS LANE FORCING HIM TO GO UP ON THE CURB IN FRONT OF 1940WASHINGTON ST. DRIVER STATES HE HAS SCRAPES ALONG HIS FRONT RIGHT RIM AND TIRE FROM WHERE HIS VEHICLE WAS FORCED TO HIT THE CURB. DRIVER STATES VEHICLE #2 PULLED OVER IN THE WOODLAND T STOP LOT. VEHICLE #1 STOPPED BEHIND HER AND AS HE GOT OUT OF HIS VEHICLE, VEHICLE #2 LEFT THE AREA. VEHICLE #1 WAS ABLE TO TAKE A PICTURE OF VEHICLE #2 PLATE ( MA REG: 76439 ) AS THEY LEFT THE AREA. ATTEMPTS TO CONTACT VEHICLE #2 WERE UNSUCCESSFUL. WILL TRY AGAIN ON NEXT SHIFT. VEHICLE #1 ADVISED TO CONTACT HIS INSURANCE COMPANY. ON 4-3-19 AT APPROX 1400HRS. I WAS ABLE TO MAKE CONTACT WITH THE OPERATOR OF VEHICLE #2 ( MARJORIE TEMPLE ). OPERATOR EXPLAINED TO ME THAT SHE WAS TRYING TO GET IN THE RIGHT LANE FOR THE WOODLAND PARKING GARAGE AND DID NOT SEE VEHICLE #1 BECAUSE HE WAS IN HER BLIND SPOT. SHE STATED SHE PULLED OVER AND CHECKED HER VEHICLE AND SAW NO DAMAGE. OPERATOR STATES AS AN ELDERLY FEMALE WHEN A YOUNG MALE, 6'5" TALL GETS OUT OF HIS VEHICLE ANGRY I WASN'T GOING TO CONFRONT HIM. PARTY WAS ADVISED TO USE GREATER CAUTION WHILE DRIVING IN THE FUTURE. PARTY ALSO ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3336125
Longitude:
-71.2445594
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);