crash_reports
21 rows where dcc_code = "[3]" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: date, time, address, street1, street2, speed_limit, hit_run, violation_cited, keywords, geocoded_address, latitude, longitude, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-02
Time:
19:49
Address:
CHERRY ST & WEBSTER ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 was traveling SOUTH on Cherry St through the intersection of Webster St. MV2 was traveling WEST on Webster St through the same intersection. MV2 collided with MV1 inside of the Cherry St/Webster St intersection causing heavy front end damage to MV2 and damage to the rear drivers side wheel and fender. MV1 operator, Leah Wilson, stated that she had a green light and proceeded through the intersection when she was hit by MV2. MV2 operator, Caroline Steiner, and her 12yo daughter (passenger/front seat) Lorelai Steiner, stated that they were proceeding through the green light and observed MV1 going at a high rate of speed through the intersection. No injuries reported. Both vehicles towed by Tody's. MV1 operator, Leah Wilson was issued in hand MA Uniform Citation T1440472 for 89/9 - Red Light/Fail. On scene, I observed debris surrounding the four-way intersection and MV1 laid to rest past the intersection and facing the wrong direction in traffic. The damage to both vehicles was severe and MV1 had air bag deployment. The reporting party was an NPD auxiliary officer who had responded prior to my arrival because he heard the crash from the backyard of the police station which is approximately 350-400ft. Based on my training and experience, I believed Leah Wilson to be traveling through the intersection while failing to yield to the traffic control device.
Keywords:
Citation, Crash, Severe, Speed
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.350159
Longitude:
-71.228704
Location:
Case
number:
Date:
2019-02-03
Time:
09:18
Address:
WASHINGTON ST & CENTRE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED HE WAS GOING N/B ON WASHINGTON ST WAS CROSSING THE INTERSECTION OF CENTRE AVE(GREEN LIGHT) VEHICLE#2 FAILED TO STOP FOR HIS RED LIGHT CAUSING THE CRASH. OPERATOR #2 STATED HE WAS GOING E/B ON CENTRE AVE HEADING TOWARDS THE MASS PIKE EAST WHEN HE DIDN'T REALIZE HIS LIGHT HAD TURNED RED WHEN HE WAS GOING THROUGH THE INTERSECTION OF WASHINGTON ST. HE THEN CRASHED INTO VEHICLE #1 IN THE INTERSECTION.
Keywords:
Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2019-02-25
Time:
11:30
Address:
CHESTNUT ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On 2/25/2019 at approx 1130hrs while assigned to 497 I responded to the intersection of Commonwealth Ave and Chestnut St for a two car crash. Upon arrival I met with the operator of Ma reg RDTAIL ,Steve MCCULLOUGH who stated he was traveling NB on Chestnut St through the green light when he was suddenly struck by the operator of Ma Reg 298CBV George DIARBAKERLY who was travelling EB on Commonwealth Ave. I spoke with DIABAKERLY who initially stated he thought he had the green light but perhaps it changed, than stated maybe he was too far back when he saw the green light. MCCULLOUGH gave me the names of two people who had stopped , Matt DOLITKA 617-719-7621 and Dr J LAUFFLER 617-968-6343. I was able to speak with DOLITKA who stated he was travelling NB on Chestnut ST one car back from MCCULLOUGH, they were traveling through the green light which was solid green, had not just changed, when he saw MCCULLOUGH get hit by DIARBAKERLY at a high rate of speed, DIARBAKERLY struck MCCULLOUGH than bounced off and went up onto the island. DIARBAKERLY issued Mass Uniform Citation T1441861 for violation MGL 89/9 Failure to Stop, Red Light. All parties signed patient refusals with Cataldo. both vehicles towed by Todys.
Keywords:
Citation, Crash, Speed
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.336717
Longitude:
-71.223643
Location:
Case
number:
Date:
2019-03-10
Time:
16:15
Address:
CENTRE ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
On March 10, 2019 at approximately 16:15 hours I responded to Commonwealth Ave and Centre St. for a motor vehicle crash. Operator of MV2 said that he was driving westbound on Commonwealth Ave through the green light and was hit by MV1. The operator of MV1 said that he was traveling northbound on Centre St. and did not see the red light until last minute because a truck was blocking the signals. Both passengers of MV2 complained of minor soreness and refused medical transport. The operator of MV1 was issued a civil motor vehicle citation (T1140496) for MGL90/7 failure to stop at red light.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
Location:
Case
number:
Date:
2019-04-11
Time:
18:30
Address:
LINWOOD AVE & WALNUT ST
Speed
limit:
20
Violation
cited:
yes
Narrative:
Opr of V1 stated he was behind a vehicle at the stop sign. He stopped, drove past the vehicle and drove through the intersection. At this time, he made contact with V2. Opr had minor injuries and signed a refusal. V1 suffered damage to the left side and Tody's towed the vehicle. Opr of V1 was given MA Uniform Citation T1444242 for Failure to Stop at a Stop Sign (M.G.L. Chapter 89/ Section 9) Opr of V2 stated he was traveling southbound when he realized V1 went through the stop sign. At this time, he could not stop and made contact with V1. Passenger in V2 stated they did not see the vehicle until they made contact. V2 had significant damage and Tody's towed the vehicle. V2 had no injuries. Witness Jolie, spoke to Officer Dragone and stated she was at the stop sign waiting for traffic. At this time, V1 drove around her, through the stop sign, and hit V2.
Keywords:
Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.357634
Longitude:
-71.21072
Location:
Case
number:
Date:
2019-04-12
Time:
22:26
Address:
WASHINGTON ST & CENTRE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Friday 4/12/2019 at approx 2226hrs, while assigned N-494, I responded to the intersection of Washington St and Centre St (public way)for a 2 vehicle MVA. Upon arrival all parties stated they were uninjured. Operator of MV1 stated that he was in the Left Turn Only lane onto Washington St. He immediately stopped when he noticed a car to his left collide with his trailer. Operator of MV2 states that he was also in the Left Turn Only lane onto Washington St. and that MV1 came over from Left Turn/Straight lane on his right. Given that both operators stated that their vehicles had not been moved from where the collision occurred it is evident that MV2 was in the Left Turn Only lane onto I-90 and attempted to change lanes. It should be noted that the crash diagram is accurate to what I observed on scene. Operator of MV2 was cited for marked lanes MGL c89s 4C citation #T1268551 No damage visible to MV1. MV2 had passenger side paint damage.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2019-04-17
Time:
09:39
Address:
ELLIS ST & RT 9 (BOYLSTON ST) OFF RAMP
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of veh #1 was driving due South on Ellis St. when veh #2 drove from his right without stopping for the stop sign. Veh#1 collided with veh#2 causing slight damage to veh #1 bumper. The operator of veh#2 stated he was driving off the Rt 9 (Boylston St.) East off ramp when he "spaced out and didn't fully stop" for the stop sign at the end of the ramp and veh #2 collided with veh#1. Moderate to heavy damage to veh#2 drivers side. Operator of veh#2 issued Mass. Citation #T1444223 in hand for Ch89/ Sec9 Stop Sign violation.
Keywords:
Citation, Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3193044
Longitude:
-71.2039856
Location:
Case
number:
Date:
2019-04-24
Time:
07:29
Address:
CHERRY ST & RIVER ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV1(ma reg 773KV5) was traveling WB on River Street through the intersection of Cherry St when her vehicle was struck by a motor vehicle traveling on Cherry St. The operator of MV1 stated she had a green light and MV2 went through a red light striking her driver's side door. The operator of MV2 (MA reg 5CG678) stated she was traveling NB on Cherry St approaching the intersection of River St when she struck MV1. Operator of MV2 admitted she ran the red light and stated she zoned out for a minute. Operator of MV2 stated she was unsure if she wanted to turn onto River or continue straight onto Cherry and she ended up driving through the red light. Operator of MV1 was complaining of possibly head injury so I called for an ambulance. ALS 28 arrived on scene to evaluate and ended up transporting Operator of MV1 to NWH. Operator of MV2 stated she was not injured and did not require medical evaluation. Both vehicles sustained heavy damage and required tow's. Tody's arrived on scene on towed both vehicles. After MV1 was struck the operator ended up crashing into the retaining wall of the West Parrish Burial Ground. There was significant damage to the fence and wall. I had dispatch call for a traffic car to respond to the accident to take pictures since the Burial Ground is City Property. Traffic Officer Gaudet responded and took pictures of the vehicles and damage to the wall. The operator of MV2 was cited for CH 89-9 Fail to stop for a red light. MA citation (T1441437) was mailed to operator of MV2
Keywords:
Citation, Crash, Ems, Pictures
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3522831
Longitude:
-71.2294841
Location:
Case
number:
Date:
2019-05-08
Time:
11:48
Address:
WASHINGTON ST & PROSPECT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated he was traveling eastbound on Washington st and as he approached the intersection of Prospect St could not recall if the light was red or green but still preceded forward and was struck by vehicle 2. Operator of vehicle 2 states he was sitting on Prospect St at the light on Washington St. When the light turned green he proceeded forward across Washington St when vehicle 1 came across his path and he struck it on the driver side. Vehicle 1 had side airbag deployment. Both vehicles were towed by Todys. Both operators were evaluated by the medics and signed patient refusals.
Keywords:
Airbag
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3456884
Longitude:
-71.2334977
Location:
Case
number:
Date:
2019-05-17
Time:
14:48
Address:
BEACON ST & CHESTNUTHILL RD
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator 1 states he was traveling Eastbound on Beacon St when vehicle 2 drove through the stop sign on Chestnut Hill Dr and into the intersection. Operator 1 did not have time to stop and struck vehicle 2. Operator 2 stated he was stopped on Chestnut Hill Dr. at the stop sign. Operator 2 thought he had enough time to cross Beacon St and proceeded forward. Operator 2 was struck by vehicle 1 in the intersection. Vehicle 1 and 2 sustained moderate damage and were towed. There were no injuries.
Keywords:
Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3339598
Longitude:
-71.1623085
Location:
Case
number:
Date:
2019-05-26
Time:
11:58
Address:
BOYLSTON ST & ELLIS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of M/V # 1 was operating straight ahead exiting the Boylston Street (EB) off ramp at Ellis Street. The operator states that she never saw the stop sign at the end of the off ramp and proceeded through the intersection when she was struck by M/V # 2 on her driver's side rear door. M/V # 1 sustained moderate damage to the door but the vehicle was still driveable. Operator was issued MA Uniform Citation # T1444908 for Ch. 89/S9 Stop Sign Violation. Below the stop sign there is also a sign that states that oncoming traffic does not stop. Operator of M/V # 2 was operating straight ahead through the above listed intersection attempting to go southbound on to Ellis Street when M/V # 1 suddenly came through the intersection. The operator could not avoid M/V # 1 striking it on the driver's side rear door. The vehicle sustained moderate damage to the right side of the front bumper area but it was still driveable. The operator had her dog, Coconut, in the rear of the vehicle at the time but the dog appeared to be fine. No injuries reported by either operators.
Keywords:
Citation, Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3167943
Longitude:
-71.2269407
Location:
Case
number:
Date:
2019-06-19
Time:
12:57
Address:
LINWOOD AVE & WALNUT ST
Speed
limit:
0
Violation
cited:
no
Narrative:
VEH 1 TRVELING NORTH ON WALNUT STREEET WHEN VEH 2 OPERATING EAST ON LINWOOD WENT THROUGH STOP SIGN AND STRUCK VEH.1 ALL PATIENT REFUSALS. PICK UP TRUCK TOWED BY PERFECTION OWNER REQUEST, SEDAN TOWED BY TODY'S.
Keywords:
[]
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.357634
Longitude:
-71.21072
Location:
Case
number:
Date:
2020-01-10
Time:
09:23
Address:
CARLSON AVE & DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Veh #1 stated he was traveling due East on Dedham St when veh #2 pulled out of the "left turn only" lane and struck his drivers side. This pushed him into the curb flattening his passenger side front tire. Slight/moderate damage to veh #1 drivers side. Veh #2 stated he was traveling East on Dedham St when he realized he was in the wrong lane .He then tried to pull into the right lane when he collided with veh # 1. Slight/ moderate damage to veh #2 passenger side . Operator of veh#2 was cited in hand Mass #T2013424 for Ch89/ Sec4a-Unsafe lane change. Both vehicles were driven from the scene.
Keywords:
Citation, Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.2989668
Longitude:
-71.1865087
Location:
Case
number:
Date:
2020-01-10
Time:
18:02
Address:
AUSTIN ST & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated while traveling Northbound on Walnut Street MV2 was traveling close to his vehicle. Operator of MV1 stated as he approached the crosswalk to let a pedestrian cross, MV2 was in the left turn only lane onto Austin Street. Operator of MV1 stated MV2 then passed him on the left, striking the driver side of his vehicle and continued on Walnut Street toward Washington Street. Operator of MV1 stated as MV2 passed he was able to get a License Number of that vehicle. After speaking with the Operator of MV1, I contacted the Operator of MV2. The Operator of MV2 stated while traveling Northbound on Walnut Street, MV1 was attempting to look for a parking spot by stopping at times and turning his turn signal on and off. Operator of MV2 stated as MV1 turned his turn signal on and stopped after multiple times of breaking, he went around MV1. Operator of MV2 stated he did not know he struck the other vehicle and that is why he continued on Walnut Street. MV1 had moderate damage to the driver side of the vehicle. MV2 had moderate scratches to the passenger side of his vehicle.
Keywords:
Crosswalk, Moderate, Ped
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3505802
Longitude:
-71.2069457
Location:
Case
number:
Date:
2020-03-30
Time:
13:59
Address:
CHESTNUT ST & FULLER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 stated she was driving northbound on Chestnut St approaching the intersection of Fuller St when she observed MV2 stopped at the stop sign facing eastbound on Fuller St. Operator 1 stated that MV2 pulled out into the intersection where she collided with MV2 causing major damage to the front end of her MV. The momentum of MV1 caused MV1 to proceed onto the property of 404 Chestnut St destorying the lawn and about 6 feet of bushes. Operator 1 sustained minor injuries to her left hand and was tended to by medics. Operator 2 stated he was driving eastbound on Fuller St and stopped at the stop sign at the intersection of Chestnut St. Operator 2 stated he looked and did not see any oncoming motor vehicles and proceeded to enter the intersection driving eastbound on Fuller St when MV2 collided with the front passenger side of his vehicle causing major damage. Operator 2 sustained no injuries. I spoke with the homeowner of 404 Chestnut and notified him of the damage to his property.
Keywords:
Bus
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.335547
Longitude:
-71.223753
Location:
Case
number:
Date:
2020-07-22
Time:
08:26
Address:
JACKSON RD & PEARL ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On July 22nd, 2020 at approximately 08:26 hours while working N491 I responded to the intersection of Jackson Rd @ Pearl St for a reported two car mv crash. On my arrival with NFD and Medics I observed one vehicle Maryland license plate 9DF562, 2016 Ford Escape in the middle of the intersection with heavy front end damage. The other vehicle Ma commercial V42208, 2014 white transit van resting into the chain link fence to the property of #99 Jackson Rd with heavy damage to the passenger side front quarter. I first spoke with the operator of the Van, identified as David Dwyer. The Van which David was operating is owned by Porcelain Patch & Glaze Corp. #140 Watertown St, Watertown Ma. David stated he wasn't sure what happened. He reported going N/B on Jackson Rd passing thru the intersection of Pearl St when the crash occurred. I asked him if he possibly might have not stopped at the traffic light(red)? He responded, "he wasn't sure". I then spoke with the other operator identified as Raul Davila. He reported that he was going W/B on Pearl St crossing the intersection of Jackson Rd when vehicle #2 struck his vehicle in the intersection. He further stated his light was definitely green. Both vehicles were towed from the scene by Todys. Both operators signed patient refusals. Mr Davila did complain of dizziness but refused to go with the Medics. Operator #2, David Dwyer was cited with Ma citation #T2014122 for failing to stop for a red light on Jackson Rd. The citation was later left at his work place at #140 Watertown St, Watertown Ma. with a fellow employee. David had gone back out on the road to a job. The property to which vehicle #2 caused damage to, I later gave the owner, Fernarla Thomasis the insurance information from that vehicle.
Keywords:
Citation, Crash, Fire
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.359451
Longitude:
-71.194781
Location:
Case
number:
Date:
2020-08-08
Time:
06:13
Address:
CHERRY ST & WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Saturday, August 8th 2020, at approximately 6:13am, I, Officer Brooks, responded to a 2 car MVA at the intersection of Cherry street and Webster street. Upon arrival I spoke with the operator of MV1(MA REG 1XKP51), who stated he was traveling southbound on Cherry streeet, and failed to stop for the red light at the intersection of Webster street. The front end of his vehicle struck MV2 (MA REG 443LP3) on the passenger side front end. MV1 had damage to the front end and was towed by Tody's. I spoke with the operator of MV2 who stated she was traveling westbound on Webster street and had the green light. As she proceeded through the intersection she was struck by MV1. MV2 had heavy damage to the front passenger side, and had airbag deployment. The operator complained of chest pain and was transported to Newton Wellesley hospital. Her vehicle was towed by Tody's. Tow inventory forms were filed.
Keywords:
Airbag, Hospital
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.350159
Longitude:
-71.228704
Location:
Case
number:
Date:
2020-08-09
Time:
23:57
Address:
HERRICK RD & BRAELAND AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On August 9, 2020 at approx. 2357 hours, I responded to the area of Herrick Rd and Braeland Ave for a report of a hit and run that had just occurred. Rp reported being struck by a black Subaru Outback. MV1 operator states he was travelling WB on Braeland Ave came to a stop at the stop sign and then proceeded to take a right hand turn onto Herrick Rd. As MV1 was mid turn, MV2 travelling NB on Herrick Rd disregarded stop sign and struck MV1. MV2 then continued down Herrick Rd and took a right turn onto Union St. No injuries were reported on scene. I observed damage to front left quarter panel of MV1. Multiple NPD units searched the area for the suspect vehicle with negative results. a BOLO for the suspect vehicle was sent to the state police.
Keywords:
[]
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3288168
Longitude:
-71.1933968
Location:
Case
number:
Date:
2020-08-20
Time:
07:31
Address:
HOMER ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she was in the right lane (right turn only) on Homer St E/B at the Walnut St intersection. #1 stated the MV beside her in the left lane started rolling forward. #1 stated as a result, she believed the light was green but stated she never saw the light (red) prior to proceeding. #1 stated at that time, she proceeded straight ahead through the intersection and struck Mv#2 that was travelling straight ahead on Walnut St N/B. Mv#2 operator stated he was travelling straight ahead on Walnut St N/B. #2 stated while approaching the Homer St intersection he had a solid green light and proceeded straight ahead. #2 stated #1 suddenly appeared from his left going through the red light and struck him in the intersection. No injuries reported. Both Mv's sustained heavy front end damage, including airbag deployment in #2. Both were towed by Tody's. #1 operator cited in hand for violation of Ch89/Sec 4A Marked Lanes Violation and Ch89/Sec9 F/C Red Light.
Keywords:
Airbag, Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.33615
Longitude:
-71.20708
Location:
Case
number:
Date:
2020-09-01
Time:
07:31
Address:
NEEDHAM ST & OAK ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Catherine Dion was operating vehicle #2, Ma. Reg 8LL196 stopped at the Oak St at Needham St light. Catherine states that the light turned green and she went to go thru the intersection. Catherine states that vehicle #1 ran the red light and she struck vehicle #1 on the right side. Shannon Duchaine-Savage was operating vehicle 1, Ma. Reg. 2TX516 N/B on Needham St. Shannon stated that she had no idea what happened. Both vehicles towed. Duchaine-Savage was transported to the BI by Cataldo and issued citation#T2015217, Ch 89 S.9 F/C Red Light
Keywords:
Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3074482
Longitude:
-71.2161931
Location:
Case
number:
Date:
2020-09-03
Time:
09:13
Address:
BEACON ST & HOBART RD
Speed
limit:
25
Violation
cited:
no
Narrative:
OPER OF MV#1 STATED THAT SHE WAS TRAVELLING SB ON HOBART RD (CROSSING BEACON ST ON A GREEN LIGHT), WHEN MV#2 RAN THE RED LIGHT (WEST ON BEACON ST) AND STRUCK HER VEHICLE. OPER OF MV#2, STATED THAT HE WAS TRAVELLING WEST ON BEACON ST, AND STRUCK MV#1 IN THE INTERSECTION. OPER OF MV#2 STATED THAT HE WAS UNSURE HOW THE ACCIDENT HAD OCCURRED. MV#1 SUSTAINED MODERATE DRIVER SIDE DOOR DAMAGE. MV#2 SUSTAINED HEAVY FRONT DAMAGE W/AIRBAG DEPLOYMENT (TOWED).
Keywords:
Crash, Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3321327
Longitude:
-71.1812114
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);