crash_reports
4 rows where "date" is on date 2019-01-14, intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-14
Time:
08:02
Address:
437 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
M/V #1 WAS TAKING A RIGHT TURN ONTO CENTRE ST WHEN IT STRUCK A TRAFFIC SIGNAL LIGHT ON THE SIDEWALK. THE LIGHT WAS KNOCKED OVER AND DAMAGED. TRAFFIC RESPONDED AND TOOK PHOTOS.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3554145
Longitude:
-71.1864033
Location:
Case
number:
Date:
2019-01-14
Time:
15:13
Address:
99 JACKSON RD
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-14-19 AT APPROX. 15123HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 99 JACKSON RD. SPOKE TO THE OWNER OF VEHICLE #1. DRIVER STATES SHE WAS PARKED IN FRONT OF 99 JACKSON RD. GETTING HER DAUGHTER FROM LINCOLN ELIOT SCHOOL. SHE STATES WHEN SHE RETURNED TO HER CA SHE WAS INFORMED BY A PASSERBY ( WHO REFUSED INVOLVEMENT ) THAT A VEHICLE SIDESWIPED HER VEHICLE CAUSING LEFT FRONT BUMPER SCRAPES. SHE GAVE THE OWNER OF VEHICLE #1. I RAN THE PLATE AND IT CAME BACK TO A BLACK JEEP OWNED BY ( ANAPAULA GUERES ). ATTEMPTS TO CONTACT VEHICLE #2 WAS UNSUCCESSFUL. VEHICLE #1 STATES SHE HAD NO INJURIES. ADVISED TO CONTACT HER INSURANCE COMPANY. ON 1-24-19 AT APPROX. 0930HRS. WHILE WORKING N492 I WAS INFORMED BY CIVILIAN EMPLOYEE ( STACY ANNESE ) THAT THE OWNER OF VEHICLE #1 ( AYENG FONG ) HAD COME TO THE STATION TO INFORM ME THAT THE ORIGINAL LATE NUMBER SHE HAD GIVEN ME WAS WRONG. SHE STATE THE PLATE NUMBER OF THE VEHICLE THAT ALLEGEDLY HIT HER CAR WAS ( MA REG: 9TK518 ). A REGISTRY CHECK CAME BACK TO A 2019 BLACK JEEP CHEROKEE OWNED BY CHRISTINE MITCHELL OF 169 ADAMS ST. I WAS UNABLE TO MAKE CONTACT WITH MS MITCHELL AND WILL ATTEMPT O DO SO ON NEXT SHIFT. Traffic Bureau update (Officer Gaudet): I attempted to contact the owner of MV2, Anapaula Guedes (S28004541) with a negative result. A Hit and Run inquiry was mailed to the Guedes.
Keywords:
Crash, School
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3596746
Longitude:
-71.19491
Location:
Case
number:
Date:
2019-01-14
Time:
16:44
Address:
77 NEWELL RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of MV1 was parked across the street from 77 Newell rd from the hours of 345pm to 450pm. When she had come out of the residence to her vehicle, she noticed red paint and several dents to the front fender of her vehicle. There was minor damage and was able to drive. The vehicle was unoccupied and there are no cameras in the surrounding houses.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.351057
Longitude:
-71.243825
Location:
Case
number:
Date:
2019-01-14
Time:
14:06
Address:
2150 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/14/2019 at approx 1406Hrs while assigned to 497 I responded to the area of 2150 Washington St for a report of a 2 car collision. Upon arrival I met with the operators of Ma Reg 5NG581 Jeff LONDON and Ma Reg RT35K2 Lori GANS. LONDON was signing a refusal with Cataldo Ambulance and stated he had already exchanged all his information with the other operator. I spoke with GANS who stated LONDON stopped suddenly for a turkey that walked into the roadway, GANS was able to brake but lightly tapped LONDON.
Keywords:
Ems, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3291503
Longitude:
-71.2501096
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);