crash_reports
19 rows where dcc = "["Failed to yield"]", intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, keywords, dcc_code, longitude, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-18
Time:
12:01
Address:
2014 WASHINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV#1 stated that she was waiting to exit NWH at the east exit/entrance. When her light turned green she proceeded to enter Washington St and her MV was struck by MV#2, who was traveling south on Washington St. The operator of MV#2 stated that she was traveling south on Washington St approaching NWH and had a green light to proceed thru the intersection at the east exit/entrance. An independent witness stated that she was in a MV directly behind MV#1 at the east exit when she observed their traffic light turn green and both her and MV#1 proceeded into the intersection. The witness then observed MV#2 traveling south on Washington St enter the intersection crashing into MV#1 while their light was still green. Operator #2 cited for a red light violation.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Case
number:
Date:
2019-02-27
Time:
08:52
Address:
843 BEACON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Wednesday, February 27, 2019 while assigned to Traffic unit N525, I responded to the area of 843 Beacon Street, Newton for a report of a 2 car motor vehicle accident. Beacon Street is a public way maintained by the City of Newton. I spoke with the operator of MV1, Omer Chaudhry (NY: 122909834). Chaudhry stated he as operating his 2015 blue Mazda 3 (NY Reg: GVJ1096) Eastbound on Beacon Street towards Centre Street. Chaudhry stated he observed MV2 exiting a parking spot on his right. As MV2 attempted to merge into traffic it's front driver side crashed into the passenger side of his vehicle. I observed damage along the passenger side of Chaudhry's vehicle from the rear passenger tire to the front passenger bumper area. Chaudhry reported no injuries at this time. I spoke with the operator of MV2, Elizabeth Libert (S75526057). Libert stated she was attempting to pulled out of a marked parking spot (E) on Beacon Street when the front driver side of her 2017 gray Mercedes E400 (MA: 1YT269) crashed into the passenger side of MV1. I observed damage to the front driver side tire area of MV2. Libert reported no injuries at this time. Libert's vehicle was removed from the roadway by Tody's towing. Libert was cited with Massachusetts Uniform Citation T1269154 for Newton City Ordinance Chapter 19, Section 75 (Failure to Use Care).
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3302668
Longitude:
-71.1955617
Location:
Case
number:
Date:
2019-04-18
Time:
10:08
Address:
2058 COMMONWEALTH AVE
Speed
limit:
5
Violation
cited:
yes
Narrative:
The owner of MV#1 states that he returned to his unoccupied MV to find a note from a witness stating they observed another MV strike his MV while they were attempting to park in the parking spot to the left of MV#1. Witness identified MV#2 as Ma Reg 1705XY, a Honda CRV. Witness states he observed an older W/M operating Ma. Reg. 1705XY (MV#2) attempt to park in a parking spot while striking MV#1 and then quickly exit the spot. Witness feels confident operator of MV#2 knew he struck MV#1. I then spoke with operator/owner of MV#2 who admitted he was operating MV#2 during minor crash, but didn't think it was significant so he left the area. Operator #2 cited for leaving the scene of a MV crash.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3471049
Longitude:
-71.2463773
Location:
Case
number:
Date:
2019-05-29
Time:
14:43
Address:
255 WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Wednesday, May 29, 2019 while assigned to Traffic unit N525, I responded to the area of Centre Street and Washington Street, Newton for a report of a motor vehicle crash involving a school bus. The weather at the time of the crash was overcast and the road surface was dry. Centre Street and Washington Street are both public ways maintained by the City of Newton. The operator of MV1, Norma Cedeno (S60008138), stated she was operating a 2016 Dodge Caravan (MA SPN: 104893) around the Washington Street/Centre Street rotary. Cedeno stated as she was traveling in the left turn lane on Centre Street, she attempted to travel straight (N) through the intersection at Washington Street towards 255 Washington Street. Cedeno stated the front passenger side of her vehicle crashed into the driver side of MV2. MV2 was attempted to continue left around the rotary and was located on the passenger side of her vehicle. Cedeno reported no injuries. I observed minor damage to the front passenger side tire area of MV1. Cendeno's passenger, Cristina Velez (S04276767), reported not injuries. The operator of MV2, Mary Sanker (S62890912), stated she was operating her 2016 BMW 328XI around the Washington Street/Centre Street rotary. Sanker stated as she was continuing through the rotary in her lane, the vehicle traveling in the lane to her left (MV2) entered her travel lane in an attempt to travel straight towards 255 Washington Street and crashed into the driver side of her vehicle. I observed moderate damage to the front and rear driver side doors of MV1. Sanker reported no injuries. The operator of MV1 was cited for Newton City Ordinance Chapter 19, Section 75 (Failure to Use Care)
Keywords:
Bus, Citation, Crash, Moderate, School
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3578474
Longitude:
-71.1840263
Location:
Case
number:
Date:
2019-06-25
Time:
10:10
Address:
199 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated that she was inside the mall parking lot and took a right down one of the rows when vehicle #2 pulled out of a parking spot and struck her on her passenger side. Operator of vehicle #2 stated that she was taking a left out of her parking spot and didn't see vehicle #1 when she struck the car. Minimal damage to both vehicles. The operator of vehicle #2 was cited in hand #T1271245 for failure to use care in turning.
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
Case
number:
Date:
2019-07-18
Time:
08:05
Address:
275 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was in the left hand turn lane on Grove St (north) in front of #275 Grove St. When her arrow to turn left turned green she proceeded to turn when her MV was struck by MV#2. The operator of MV#2 stated that she was traveling south on Grove St in front of #275 when she noticed she had a red light at the last minute and attempted to stop, but entered the intersection and struck MV#1. A witness walking in front of #275 Grove St stated she observed MV#2 go through her red light and strike MV#1 as she was turning into parking area. Operator #2 cited for failure to comply w/red light.
Keywords:
Citation, Walk
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3388685
Longitude:
-71.2527116
Location:
Case
number:
Date:
2019-07-27
Time:
12:42
Address:
1241 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of veh#1 stated he was driving North on Centre St when veh #2 pulled out of her parking spot and struck his vehicle. Minimal damage to veh #1 front bumper. Operator of veh #2 stated she was pulling out of her parking spot due North on Centre St when veh #1 came out of no where and she collided with him. Front bumper removed from veh #2. Operator of veh #2 cited #T1271258 in hand for N.C.O. 19/75 - Failure to use care in starting, stopping and turning. Both operators stated their speed was slow at the time of impact. Centre St is a public way in the City of Newton as it is serviced and maintained by this city.
Keywords:
Citation, Crash, Speed
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3307248
Longitude:
-71.1948758
Location:
Case
number:
Date:
2019-08-27
Time:
10:58
Address:
60 HIGHLAND ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV#1 stated that she was traveling north on Highland St when MV#2 exited the parking area at #60 Highland St and struck her MV. The operator of MV#2 stated she was attempting to exit the parking area of #60 Highland St and didn't see MV#1 when she crashed into her MV. Operator of MV#2 stated, "it's my fault." Operator #2 cited for failure to use care. No injuries, no tows.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3473066
Longitude:
-71.2259351
Location:
Case
number:
Date:
2019-09-22
Time:
11:53
Address:
1247 CENTER STREET
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV#1 was entering Center Street from a parking stall when he was struck by MV#2. -OpMV#1 stated he was entering Center Street from a parking stall when he was struck by MV#2. He stated he observed a far distance buffer between him and MV #2. MV#1 was occupied by two passengers. -OpMV#2 stated she was traveling north on Center Street. She stated she observed a MV#1 entering the roadway. She stated MV#1 pulled out suddenly in front of MV #2. She collided with MV#1. - I observe the damage to both vehicles. I observed the heavy damage and deep gouge to the driver(cid:31)s side door of MV#1. The gouge had cut open the outer panel of the door revealing the mechanical components inside the door. OpMV#1 stated he could not open the door, but the vehicle was drivable. I next conducted an inspection of the exterior damage of MV#2. I observed that the plastic bumper was separated from the frame and several cracks and breaks on the bumper. I further observed damage to the wheel well panel. OpMV#2 stated the vehicle was drivable. -There were no injuries reported at the scene and all parties declined medical assistance. Neither vehicle was towed from the scene. OpMV#1 was cited (T2015553) for Failure to Use Care Entering the Roadway.
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3303452
Longitude:
-71.1947576
Location:
Case
number:
Date:
2019-12-19
Time:
15:51
Address:
WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV #1 was traveling southbound on Walnut St. in the area of Lake Ave. MV #2 was parked along the curb on the shoulder of Walnut St. by Lake Ave. MV#2 attempted to pull out into the southbound travel lane of Walnut St. failed to yield to oncoming traffic and struck MV#1 on its passenger side. MV#1 suffered minor damage to its passenger side and no occupants were injured. MV#2 suffered minor damage to its driver's side front end and driver side wheel well. MV#2 was towed by Tody's at the owners request. The operator of MV#2 was cited with MGL 89-8 Fail to yield to oncoming traffic (citation #T2080186). A towed MV report was filled out and filed.
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3366399
Longitude:
-71.207016
Location:
Case
number:
Date:
2020-08-22
Time:
11:40
Address:
5 ELLIOT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of veh #1 stated he was driving due North on Elliot St when veh #2 turned in front of him suddenly and without a directional. Moderate damage to veh #1 but he pulled into CVS parking lot and stated he had his own tow on the way. The operator of veh #2 stated he was driving South on Elliot St when he attempted to take a left into Negoshian's Gas Station and veh #1 drove down the street too fast and they collided. Moderate damage to veh #2 as it was towed from the scene by David from Tody's Towing. The operator of veh #2 was cited in hand for Ch 89/ Sec 8 Failure to Yield to right of way.
Keywords:
Citation, Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3185661
Longitude:
-71.2125461
Location:
Case
number:
Date:
2020-12-01
Time:
11:42
Address:
200 BOYLSTON ST
Speed
limit:
15
Violation
cited:
yes
Narrative:
On Tuesday, December 01, 2020, while assigned to Traffic unit N525, I responded to the rear parking lot of 200 Boylston Street, Newton for a report of a motor vehicle crash. I spoke with the reporting party and operator of MV1, Sungmi Lee (S54407875). Ms. Lee stated she was operating her 2017 Hyundai Santa Fe (MA: 6KR971) Eastbound through the second floor of the Wegmans parking garage, a public right of way. The area she was traveling through is designated for one was travel with a vehicle ramp to her right that allows access for vehicle to go up or come down from the third floor. Ms. Lee stated MV2 (2018 Jeep Compass, CT: AR52330), traveled down the ramp from the third floor and did not stop at the stop sign at the entrance to the second floor. Ms. Lee stated the front end of MV2 crashed into the passenger side of her vehicle. I observed damage to the passenger side area of MV1. Ms. Lee stated her neck was sore from the crash but declined having EMS respond to evaluate her. Ms. Lee stated both vehicles pulled over to exchange information after the crash. Ms. Lee stated the operator of the other vehicle, Avery Adams, stated to her she was at fault for the crash. Ms. Lee stated she noticed the license Ms. Adams showed her was expired. Ms. Adams left the area after they exchanged information and Ms. Lee contacted Newton PD about Ms. Adams' license status. I queried Ms. Adams' license and registration status through Newton PD Dispatch who informed me both were suspended. I spoke with Ms. Adams via telephone. Ms. Adams stated she was traveling down the ramp to the second floor of the parking garage and came to stop at the stop sign. Ms. Adams stated she began making her turn onto the second floor when MV1 sped up to go around her. Ms. Adams stated the front driver side of her vehicle crashed into the rear passenger side of MV2. Ms. Adams was advised of her license and registration status and was mailed Massachusetts Uniform Citation T0115918 for Chapter 90, Section 23 (Operate MV with a Suspended License) and Chapter 90, Section 23 (Operate MV with a Suspended Registration).
Keywords:
Citation, Crash, Ems, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
Case
number:
Date:
2021-06-22
Time:
15:06
Address:
130 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Veh #1 was traveling due West on Needham St. when veh #2 pulled out of #141 Needham St attempting to take a left and collided with veh #1. Veh #2 traveled into #130 Needham St window, Loyal Companion. Both air bags went off on veh #2 and both drivers were checked out by Medics and both signed patent refusals. Operator of veh #2 had a rash on her forearm from the airbag. Both vehicles were towed by Todys (David). Building Inspector Paul Nelson from the City of Newton came down on scene and stated that the damage to the building (#130 Needham St.) didn't effect the structural integrity. The operator of veh#2 admitted to hitting the gas instead of the brake. Operator of veh #2 cited in hand Mass. #T2080855 N.C.O.-Failure to use care in starting. I went inside Loyal Companion and spoke with Manager Micheal Wade. Wade stated no pets were hurt during the accident and he had already notified the buildindgs mainternece company to repsonde and board up the windows.
Keywords:
Airbag, Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3130364
Longitude:
-71.2118267
Location:
Case
number:
Date:
2021-06-28
Time:
21:16
Address:
2040 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
I responded to 2040 Commonwealth Ave for a report of two car MVA. I arrived on location and the two involved MV's pulled into the parking lot of the Star Market. V1; MA Reg 66LS55, 2016 Volvo/Stwag color gray, operated by Hamar, Benjamin MA OLNS70134803. V1 traveling southbound on Commonwealth Ave collided with V2. V2; MA Reg 294F30, 2020 Jeep/util color white, operated by Xerras, Madeline MA OLN SA0790468. V2 was attempting to exit the parking lot of the Star Market, turning left from the exit. V2 was inattentive and failed to yield to oncoming traffic. V2 sustained front end damage. V1 sustained front/right end damge to the passenger side of the vehicle. Neither vehicle had airbag deployment. Neither of the operators sustained injury as a result of the collision. V2 operator was issued MA Uniform citation T2081075; 89/9 Fail to Yield.
Keywords:
Airbag, Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
Case
number:
Date:
2021-10-23
Time:
11:35
Address:
1390 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 states that he was traveling south on Washington St directly behind MV#2 in the middle lane approaching the Mass Pike off ramp. According to operator #1, MV#2 veered to the left at the island and then without warning turned to the right crashing into MV#1. Very minor damage to drivers side tire on MV#1. The operator of MV#2 states he was traveling south on Washington St in the middle travel lane and at the island used his directional to turn into the right hand lane when crash occurred with MV#1. Damage to front quarter on passengers side and MV was towed by Todys at owners request. The operator of MV#2 provided MA Reg. 7ZP982 as a witness. MV did not match description and owner stated to me when contacted that he did not witness a crash in Newton today. No injuries and no citations issued.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3483707
Longitude:
-71.2296589
Location:
Case
number:
Date:
2021-11-22
Time:
09:07
Address:
32 BRAE BURN RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV#1 was parked and unoccupied in front of #32 Brae Burn Rd, when according to a witness, MV#2 side swiped MV#1 and left the area. MV#1 sustained damage to rear passengers side. Witness, who was in the home at #22 Brae Burn Rd, describes MV#2 as JSC Transportation van that picked up a student at #22 Brae Burn Rd. Request Traffic Bureau follow up with JSC Transportation. Traffic Bureau update (Officer Gaudet): On November 23, 2021, I contacted JSC Transportation to follow up with them and get information for the operator of the van that was involved in the crash. JSC Transportation identified the operator of the vehicle as Ms. Brittany Flannery(S78277983) and provided me with her contact information. I also asked for information on the student that was on the vehicle at the time of the crash, Davine Archibald. JSC Transportation stated they did not realize this was the student on the van at the time of the crash. They immediately contact Davine's mother, Beula Effion to make her aware of the crash. I also contacted Ms. Effion to make her aware of the crash. Ms. Effion stated she received a call from JSC Transportation and that she is ok with everything. Ms. Effion stated she does not believe Davine was injured. Ms. Effion was advised. I spoke with Ms. Flannery about the crash. Ms. Flannery stated she was operating the JSC Transportation van (2019 Ford Transit, MA SPN: SP10940) involved in the crash. Ms. Flannery stated she was on her way to a pick up and was coming down Brae Burn Road. Ms. Flannery stated there were a couple of work vans parked on either side of the driveway where her pick up was. Ms. Flannery stated she pulled off the street and tried to park in between the two work vehicles on either side of the driveway. Ms. Flannery stated as she attempted to do this, the back passenger side of her van clipped the back passenger side of the van parked to her right. Ms. Flannery stated she asked the 1 passenger on the van, Davine Archibald, if she was ok. Ms. Flannery stated Davine stated she was. Ms. Flannery stated she exited the vehicle and checked the damage. Ms. Flannery reported the damage to the van as a scrape and scratch on the rear passenger side. Ms. Flannery stated she continued with her pick up at 22 Brae Burn Road and told the resident there she was going to contact the company that owns the van later. Ms. Flannery then left the area. Ms. Flannery stated she dropped the students off at the Newton Early Education Center on Jackson Road. I asked Ms. Flannery why she did not contact the Newton Police Department to report the crash and help her exchange information with the parked vehicle she hit. Ms. Flannery stated she did not know she had to because the vehicle was unoccupied. Ms. Flannery was advised that she needs to report being involved in a collision, especially when transporting children for JSC Transportation. Ms. Flannery will be cited with Massachusetts Uniform Citation 203510AB for Newton City Ordinance Chapter 19, Section 75 (Fail To Use Care). Brae Burn Road is a public way maintained by the City of Newton.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3432495
Longitude:
-71.2398341
Location:
Case
number:
Date:
2022-03-19
Time:
15:53
Address:
835 WASHINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 stated that they were traveling straight Westbound on Washington St when MV 2 attempted to either make a U turn or enter the traffic lane. MV 1 struck MV 2s front left end while MV 2 was attempting to make the turn. MV 1 sustained moderate damage to the center front and both front air bags were deployed. MV 1 was towed by Tody's due to it being disabled on a public way. MV 2 was attempting to make a U turn or enter the left lane of traffic when MV 1 struck his front left side. The operator of MV 2 stated he wasn't sure if he wanted to make a U turn or change lanes into the left lane. The operator of MV 2 further stated he did not see MV 1 travevling straight when he attempted to make the turn. The operator of MV 2 (Mr. Warren Freedenfeld) was cited for MGL chapter 89/8 (fail to yeild to oncoming traffic). MV 2 sustained major damage to the front left wheel rendering it disabled. MV 2 was towed by a private tow (AAA). There were no injuries to either driver and they both signed patient refusals with Fallon medics.
Keywords:
Citation, Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3516474
Longitude:
-71.2080575
Location:
Case
number:
Date:
2022-04-09
Time:
18:23
Address:
1211 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 states he was traveling northbound on Centre Street when MV2 pulled out of a parking spot without yielding to oncoming traffic and struck MV1. MV1 sustained damage to the right side front and rear passenger doors. No injuries. Operator of MV2 states he was parked at a parking spot facing northbound on Centre Street when he attempted to pull out of the parking spot to make a U-Turn heading southbound on Centre Street, which is prohibited, and struck MV1. MV2 sustained damage to the front left fender. No injuries. The operator of MV2 was issued in hand Massachusetts Uniform Citation #T2012869 for Ch. 89 Sec. 8 Failure to yield (oncoming traffic).
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3313666
Longitude:
-71.1950428
Location:
Case
number:
Date:
2022-06-12
Time:
13:33
Address:
832 DEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Sunday 6/12/22 at approximately 1333 hours while assigned to marked unit n498 I was dispatched to the area of 832 Dedham Street for a report of a 2 car motor vehicle crash with no injuries. Upon arrival I spoke with the operator, GERSHON Andrew, of motor vehicle #1 (6HS292). GERSHON states he was traveling Westbound on Dedham Street toward Brookline Street when he approached the driveway at 832 Dedham Street and motor vehicle #2 started to pull out in front of him. GERSHON states as he saw the vehicle pull out he swerved into oncoming traffic to avoid the collision, however motor vehicle #2 struck the passenger side of his vehicle. After the collision GERSHON attempted to pull back into his lane of travel, but lost control causing him to overcorrect and go off the road on the westbound side of the road in front of 824 Dedham Street causing some damage to the front landscaping of the yard. Secondly, I spoke with the operator, JIN Zhien, of motor vehicle #2 (EV87SA). JIN states she was attempting to pull out of the driveway of 832 Dedham Street and didn't see motor vehicle #1. JIN states she was distracted because there was a lot going on inside the car. She stated she was not on her cell phone. Finally I also spoke with a witness, CURTIS Ron, who was travelling in the opposite direction and witnessed the crash. Ron stated he saw motor vehicle #1 travelling straight in the opposite direction on Dedham Street. He saw the Tesla (MV#2) attempting to pull out of the driveway at 832 Dedham Street and drive into the side of MV#1. Ron stated he also observed MV#1 swerve into his lane of traffic trying to avoid the collision and then spinning out into the front of 824 Dedham Street. Taking the witness, operator, and passenger statements into account as well as my observations, I determined the operator, (JIN Zhien) of MV#2 (EV87SA) is at fault for the crash and she has been issued Massachusetts Uniform Citation T2012918 C89 S8 Failure to Yield Right of Way.
Keywords:
Citation, Crash, Distracted, Phone, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.2983252
Longitude:
-71.1847921
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);