crash_reports
2 rows where "datetime" is on date 2019-03-12, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
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);