crash_reports
4 rows where "datetime" is on date 2019-07-08, intersection = 0 and "retrieved" is on date 2020-10-07
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-07-08
Time:
08:35
Address:
310 WAVERLEY AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED MV#3 SLAMMED ON THE BRAKES CAUSING HER TO DO THE SAME. AS RESULT MV#2 STRUCK THE REAR OF MV#1. THE OPERATOR OF MV#2 STATED THE SAME STORY. MV#3 DID NOT STAY ON SCENE AND NO INFORMATION WAS AVAILABLE.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3451643
Longitude:
-71.1812879
Location:
Case
number:
Date:
2019-07-08
Time:
11:49
Address:
210 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 7-8-19 AT APPROX. 1149HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT THE NEWTON POLICE STATION FRONT DESK I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES ON 7-6-19 BETWEEN 1500-1600HRS. WHILE SHE WAS PARKED IN THE PARKING STALL AT 210 NEEDHAM ST. ( HOME GOODS ) SOMEONE HIT THE LEFT REAR QTR. PANEL OF HER VEHICLE CAUSING DAMAGE TO THE FENDER AS WELL AS THE LEFT BRAKE LIGHT. OWNER STATED SHE DELAYED REPORTING THE INCIDENT BECAUSE HER VEHICLE WAS STILL OPERATIONAL. OWNER REPORTED NO INJURIES. WAS ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3107468
Longitude:
-71.2134511
Location:
Case
number:
Date:
2019-07-08
Time:
12:46
Address:
182 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of vehicle #1 was travelling Southbound on Walnut St. Operator stated that she went to scratch a mosquito bite on her leg which caused her to veer to the right and collide with parked vehicle #2.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3539004
Longitude:
-71.2079515
Location:
Case
number:
Date:
2019-07-08
Time:
18:28
Address:
2014 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPMV#1 Was traveling Eastbound on Washington St when they were struck by the OPMV#2 exiting the NWH at 2014 Washington St. OPMV#1 Stated he was traveling straight on Washington St heading home and noticed a vehicle pulling out into his lane then stop. He slowed down to let them go but the vehicle didn't move so he proceeded to travel straight and the vehicle pulled out in front of him colliding with his vehicle. OPMV#2 Was traveling Northbound on the NWH exit/entrance roadway attempting to make a left turn onto Washington St traveling Eastbound when he was struck by the OPMV#1. OPMV#2 Stated he thought he could make a left turn until he was suddenly struck by the OPMV#1. Both vehicles were towed by Tody's Towing. EMS evaluated all parties with no injuries.
Keywords:
Ems
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);