crash_reports
5 rows where "date" is on date 2019-04-25
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
                number:
            
            
            Date:
            2019-04-25
            
            Time:
            10:21
            
            Address:
            545 GROVE ST
            
            Speed
                limit:
            25
            
            Violation
                cited:
            no
            
            Narrative:
            Operator of vehicle 1 states she was was driving southbound on Grove St when a squirrell ran out infront of her. She swerved right to avoid the squirrell and hit a utility poll. Operator 1 was checked on by Cataldo medics and signed a patient refusal. The vehicle was towed by AAA and utilites were notified about possible damage to the poll.
            
            Keywords:
            []
            
            Dcc:
            Inattention
            
            Report
                url:
            
            
            Image
                url:
            
            
            Latitude:
            42.3306225
            
            Longitude:
            -71.258568
            
            
            Location:
            
        Case
                number:
            
            
            Date:
            2019-04-25
            
            Time:
            10:28
            
            Address:
            87 BRANDEIS RD
            
            Speed
                limit:
            30
            
            Violation
                cited:
            no
            
            Narrative:
            Patrice Lys was operating vehicle #2 on Brandies Rd. Lys states that vehicle #1 was about to back out of the driveway so he stopped. Lys state that the vehicle did not back out so he started to drive again, at that point vehicle #1 backed out of the driveway and struck his vehicle on the left rear. Azad Chitchian was operating vehicle #1. Azad states that she saw vehicle #2 stop to let her out of her driveway, she then went to back out of her driveway and vehicle #2 struck her. Aghavni Gevorgyan was witness. Aghavni confirms Azad's version of events. Aghavni and Azad are known to each other. Azad was transported to NWH. I took pictures, no traffic officers working.
            
            Keywords:
            Pictures
            
            Dcc:
            Inattention
            
            Report
                url:
            
            
            Image
                url:
            
            
            Latitude:
            42.3140858
            
            Longitude:
            -71.1911506
            
            
            Location:
            
        Case
                number:
            
            
            Date:
            2019-04-25
            
            Time:
            13:43
            
            Address:
            BEACON ST & CRESCENT AVE
            
            Speed
                limit:
            25
            
            Violation
                cited:
            no
            
            Narrative:
            I responded to the intersection of Crescent Ave.@Beacon st for a two car MVA at approx. 1343 hrs 04/25/2019. V1; MA reg 8738ES, 2010 toyt/Camry color gray operated by Kuller, Robert A. MA OLN S40421474. V1 operator was attempting to turn left onto Beacon St from Crescent Ave. There was on coming traffic on Beacon St. V1 operator who had been trying to make the turn was sticking out onto Beacon st. V1 operator put his vehicle in reverse and proceeded to back up for the oncoming traffic. V1 collided into V2 which was directly behind when he backed up. V2; MA Reg 6PA747, 2017 Jeep/Util. color white operated by Mesen, Alvarado MA OLN S31551122. V2 Operate's account of the collision was consistent with V1 operator without dispute. There was minor damage to both vehicles. Neither operator was injured as a result of the collision. No airbag deployment. Neither vehicle required towing service.
            
            Keywords:
            Airbag
            
            Dcc:
            Distracted
            
            Report
                url:
            
            
            Image
                url:
            
            
            Latitude:
            42.3303911
            
            Longitude:
            -71.1980873
            
            
            Location:
            
        Case
                number:
            
            
            Date:
            2019-04-25
            
            Time:
            14:51
            
            Address:
            1369 WASHINGTON ST
            
            Speed
                limit:
            5
            
            Violation
                cited:
            no
            
            Narrative:
            On 3/25/19 the owner of vehicle #1 reports that on 3/24/19 while his wife was at work at the Village Bank his vehicle was hit by an unknown vehicle causing damage to the front grill. His wife is attempting to get video of the accident from the Village Bank security cameras. She will contact NPD Traffic Bureau if they are able to get video of incident.
            
            Keywords:
            Crash
            
            Dcc:
            []
            
            Report
                url:
            
            
            Image
                url:
            
            
            Latitude:
            42.3488912
            
            Longitude:
            -71.2289819
            
            
            Location:
            
        Case
                number:
            
            
            Date:
            2019-04-25
            
            Time:
            17:53
            
            Address:
            194 ADAMS ST
            
            Speed
                limit:
            25
            
            Violation
                cited:
            no
            
            Narrative:
            On 04/25/2019, at 1753 hrs, I responded to 193 Adams St for a two car MVA. Upon arrival, I observed MV1 to have front passenger side damage and MV2 to have rear passenger side damage. The operator of MV1 stated she was attempting to take a left turn out of her driveway and had difficulty seeing due to parked cars. She then collided with MV2 who was traveling northbound on Adams St. The operator of MV2 stated she was traveling northbound on Adams St when MV1 pulled out of a driveway and they collided. No injuries were reported and both vehicles were driven from the scene.
            
            Keywords:
            []
            
            Dcc:
            Visibility obstructed
            
            Report
                url:
            
            
            Image
                url:
            
            
            Latitude:
            42.358515
            
            Longitude:
            -71.2000155
            
            
            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);




