crash_reports
23 rows where "retrieved" is on date 2020-10-07 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: date, intersection, hit_run, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-29
Time:
13:29
Address:
51 JEFFERSON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Mv#1 was attempting to maneuver between an illegally parked moving truck (Rare Moving & Trucking 617-825-7273) and a legally parked car (Mv#2) on Jefferson St E/B in front of #51A. #1 operator stated moving truck workers were trying to help direct him through. During this time, #1 passenger side struck #2 driver's side mirror. Newton Parking Control issued a violation to the moving truck. Mv#2 owner was unable to be reached. Note left on #2 windshield.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3588253
Longitude:
-71.183771
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-09
Time:
14:06
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 7/9/2019 at approx 1406Hrs while assigned to 497 I responded to level 4A of the Newton Wellesley parking garage at 2014 Washington St for a report of a minor collision. Upon arrival I spoke with the operator of RI Reg FV705, Malorie CURLEY who stated she had parked her new work vehicle in the parking stall was exiting her vehicle to see if she was within the lines when the operator of Ma Reg 69EL83 Laurence HENDY pulled into the spot next to her, opened his door striking her truck, CURLEY stated as she was rounding the car HENDY proceeded to grab his door and slam it into her car several more times. CURLEY stated she confronted HENDY who refused to exchange information with her for the damage to her car and fled. CURLEY took pictures which she will provide in her own crash report. The front bumper of CURLEYS car had several spots where the white paint was peeled back , HENDYS vehicle had the matching white paint on the edge of his drivers side door. Although the damage was minor CURLEY requested a report for documentation as it was her work vehicle. i attempted to contact HENDY but no phone number is listed.
Keywords:
Crash, Phone, Pictures
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Case
number:
Date:
2019-07-13
Time:
17:19
Address:
210 NAHANTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Saturday 7/13/19 at approximately 1719 hours I was dispatched to the parking lot of 210 Nahanton Street for a report of a past hit and run. Upon arrival I spoke to the operator, Rachel Namutebi, who states that she parked her car at 3pm on 7/10/19 and when she came out on 7/11/19 at 11am she noticed that the passengers side door had been struck by another vehicle causing damage to her car. She states she spoke with building security and they stated that the video surveillance does not video that part of the parking lot.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2969814
Longitude:
-71.1958963
Location:
Case
number:
Date:
2019-07-28
Time:
12:40
Address:
244 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated his vehicle was parked on Charlemont St directly in front of "Splash" at 244 Needham St when MV#2 reversed out of her parking spot and struck his vehicle. MV#1 sustained minor damages to its left side rear bumper area. There were no reported injuries to the owner of MV#1. The operator of MV#2 stated she was reversing out of her parking spot and struck MV#1. MV#2 sustained minor damages to its rear bumper. There were no reported injuries to the operator of MV#2.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3095777
Longitude:
-71.2137829
Location:
Case
number:
Date:
2019-08-13
Time:
16:34
Address:
224 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Owner of MV1 stated while she was inside the Starbucks at 224 Needham St her motor vehicle was struck in the front driver side bumper. Owner of MV1 stated she parked her vehicle to the right of the Starbucks, facing Southbound. Owner of MV1 stated there was moderate damage to the right front bumper and fender. Owner of MV1 was not able to provide a description of the vehicle.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3102024
Longitude:
-71.21363
Location:
Case
number:
Date:
2019-08-14
Time:
12:53
Address:
220 BOYLSTON ST LOT
Speed
limit:
10
Violation
cited:
no
Narrative:
OPER OF MV#1 STATED THAT SHE WAS TRAVELLING SB IN THE PARKING OF LOT OF #220 BOYLSTON ST, WHEN MV#2 PROCEEDED THROUGH A STOP SIGN (LOT SIGN), AND STRUCK HER VEHICLE. OPER OF MV#2 STATED THAT SHE WAS STOPPED AT A STOP SIGN IN THE PARKING LOT, AND THAT SHE DID NOT SEE MV#1 APPROACHING. MV#1 THEN STRUCK THE SIDE OF MV#2 AS SHE PULLED OUT. MV#1 SUSTAINED MINOR FRONT DAMAGE AND WAS TOWED BY AAA. MV#2 SUSTAINED MODERATED DRIVER SIDE DAMAGE TO THE DOORS AND WAS TOWED BY TODYS. THERE WERE NO INJURIES DUE TO THIS ACCIDENT.
Keywords:
Crash, Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3197333
Longitude:
-71.1761359
Location:
Case
number:
Date:
2019-08-17
Time:
11:22
Address:
32 LANGLEY RD REAR LOT
Speed
limit:
10
Violation
cited:
no
Narrative:
OWNER OF MV1, STATED THAT HER VEHICLE WAS PARKED IN THE REAR LOT OF#32 LANGLEY RD, AND WHILE IT WAS UNATTENDED, AN UNKNOWN VEHICLE STRUCK THE REAR BUMPER/LIGHT (DRIVER SIDE). MV1 SUSTAINED MINOR DAMAGE TO THE LIGHT AND BUMPER/FENDER AREA.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3309896
Longitude:
-71.1930999
Location:
Case
number:
Date:
2019-08-30
Time:
11:08
Address:
142 PARK ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Friday, August 30, 2019, while assigned to Traffic unit N525, I responded to Burr Park (142 Park Street, Newton) for a motor vehicle crash involving a City of Newton Fire truck. The operator of Newton Fire Ladder 3 (MA: MF453453), Michael Pohlman, stated while trying to exit Burr Park from the Waverly Street exit, the middle driver side tire area of Ladder 3 made contact with a fixed cement pole. The pole is located at the entrance/exit and has a chain attached to it used to restrict access to the area. I observed minor damage to the driver side middle tire area and no damage to the pole. No injuries were reported by the occupants of Ladder 3. Photos were taken and submitted to the IT Bureau. Ladder 3 stated they were at the Burr Park permorming an inspection.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.352293
Longitude:
-71.1810558
Location:
Case
number:
Date:
2019-08-30
Time:
15:01
Address:
191 WATERTOWN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Owner of Motor Vehicle #1 stated that he was exiting the gym at Planet Fitness and he noticed that someone was leaving a piece of paper on his front windshield. He was approached by the man who told him that he witnessed a Gray Dodge Ram bearing MA Reg 9JGD90 strike his Jeep Grand Cherokee that was parked and unoccupied causing moderate rear drivers side damage. MA Reg 9JGD90 came back to a 2018 Dodge Ram 1500 Gray in Color and registered to a Kenneth Doucette out of 41 Thaxter Street, Newton MA. I was able to locate several telephone numbers from our in house system however those numbers were no longer in service. I made several attempts to make contact with Mr. Doucette at his residents and had negative results. N491 Officer D. Healy also made an attempt to make contact with Kenneth Doucette later on in the evening and had negative results. I left a voicemail message to the witness and have yet to receive a return call for questioning. This will be further investigated on my next tour of Duty. **UPDATE Wednesday 09/04/19** At approximately 10:00 a.m. I went to 41 Thaxter Street to once again attempt to make contact with Kenneth Doucette and had negative results. I left another voicemail for the witness Claudio Silva and had negative results. I then spoke to Traffic Officer M. Gaudet to inform him about this incident and he stated that he will follow up with this investigation. Traffic Bureau update (Officer Gaudet): On September 4, 2019, I attempted to make contact with the witness to the crash, Claudio Silva, with a negative result. I made contact with the registered owner of MV2, Kenneth Doucette (S80920300). Doucette stated he was operating MA: 9JGD90 at the time of the accident. Doucette stated he pulled into a parking spot next to MV1 and stated he didn't think he "hit it hard". Doucette stated a short time later he left the area and when he got back to work he observed damage to his own vehicle. Doucette stated he had damage to the front passenger bumper area. Doucette stated he returned to the crash scene to see if the other vehicle had damage but it was gone. Doucette was advised and provided Massachusetts Uniform Citation T2016422 in hand for Chapter 90, Section 24 (Leaving the Scene of Property Damage, MV).
Keywords:
Citation, Crash, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3640863
Longitude:
-71.1938638
Location:
Case
number:
Date:
2019-09-08
Time:
15:49
Address:
199 BOYLSTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of vehicle 1 went into the mall, came back to their parked car, and noticed paint on the rear driver's side. They found a note on their car from a witness stating she saw vehicle 2 side swipe their car and leave the area. The witness stated that vehicle 2 was backing out of their space, and side swiped vehicle 1. Vehicle 2 should have damage on the front passenger side. The damage was very minor. I attempted to contact the owner with negtive results.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
Case
number:
Date:
2019-09-14
Time:
12:11
Address:
BOYLSTON ST & RAMSDELL ST
Speed
limit:
10
Violation
cited:
no
Narrative:
M.V. #1 was merging onto Rt. East when they were bumped from behind by veh #2. There was a newborn in veh #1 so as a precaution, the baby and its mother was transported by Medics to Newton-Wellesley Hospital to get checked out. Passenger #1 complained of headache after Medics left but didn't want me to call for a transport. She stated she would take some Tylenol and see how she felt later on. Very minor damage to veh #1. The operator of veh#2 stated she was merging onto Rt. 9 East when she didn't realize veh #1 in front of her didn't proceed and that's when she struck the rear of the car. Operator handed Mass Citation #T1445110 for N.C.O. -Failure to Use Care in Starting. Very minor damage to veh #2.
Keywords:
Citation, Hospital
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3189344
Longitude:
-71.2116253
Location:
Case
number:
Date:
2019-09-23
Time:
11:28
Address:
233 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of veh #1 initially stated she was about to back out her parking spot but was stopped when veh #2 backed into her vehicle. Operator of veh #1 later stated she backed out "only slightly" before stopping and that's when veh #2 backed into her car. Slight damage to rear passenger side of veh #1. The operator of veh #2 (U.S.P.S. delivery truck) stated he was backing up and as he did, veh #1 also backed up and thats when they collided. No visible damage to veh #2. There were no witnesses or security cameras in the area.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.309961
Longitude:
-71.2150396
Location:
Case
number:
Date:
2019-09-24
Time:
21:24
Address:
175 BOYLSTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The Operator of vehicle 1 stated she was traveling north in the parking lot of Bloomingdale's when she came to a stop, looked to her left, and saw a car that she thought was stopping, then looked to her right and saw no cars coming, she then proceeded to drive forward when she struck vehicle 2. The passenger stated the same. The Operator of Vehicle 2 stated he was traveling East in the parking lot when he was struck on his passenger side doors by vehicle 1.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3216347
Longitude:
-71.1749764
Location:
Case
number:
Date:
2019-10-04
Time:
16:04
Address:
525 WALTHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator of MV#1 stated his car was parked in a metered spot in the parking lot behind West Newton Post Office, 525 Waltham St. Operator of MV#2 stated she was pulling into the parking lot and turning into a spot next to MV#1. She sideswiped MV#1. Minor damage to both vehicles. Both vehicles were able to be driven from the scene.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3497196
Longitude:
-71.2265848
Location:
Case
number:
Date:
2019-10-05
Time:
14:30
Address:
241 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 10/5/19 at 1430 I responded to the parking lot of the Marshalls Dept store for a past hit and run MVA. Upon arrival I spoke with the owner/operator of MV#1 who stated she parked her vehicle, went into the store and when she came outside her front driver side bumper was hit. There was moderate damage to the vehicle but she was able to drive it home. There were no injuries. I checked the department stores for surveillance, which neither the CVS or Marshalls had any exterior cameras facing the parking lot. There were no witnesses on scene and the owner of MV#1 did not see who hit her.
Keywords:
Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3097858
Longitude:
-71.2156787
Location:
Case
number:
Date:
2019-10-22
Time:
12:10
Address:
647 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 10-22-19 AT APPROX. 1210HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 647 WASHINGTON ST. ( WHOLE FOODS PARKING LOT ) I MET THE OWNER OF VEHICLE #1. OWNER STATES SOMETIME BETWEEN 1130-1210HRS. WHILE SHE WAS SHOPPING AT WHOLE FOODS SOMEONE HIT THE RIGHT REAR OF HER VEHICLE CAUSING SCRAPES ALONG THE RIGHT REAR QTR. PANEL. OWNER STATES SHE SAW A WHITE DELIVERY VAN PARKED ACROSS FROM HER STALL IN THE LOT BUT DID NOT ACTUALLY SEE HER VEHICLE GET HIT. OWNER REPORTS NO INJURIES. WAS ADVISED TO CONTACT HER INSURANCE COMPANY.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2019-10-25
Time:
14:43
Address:
1321 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV1 (MA: 249AB2) stated he was operating his vehicle Westbound through the parking lot behind 1321 Washington Street, Newton. The operator stated he was attempting to pull over to the right side of the roadway to allow a vehicle traveling Eastbound through the parking lot by him. In doing so, MV1's passenger side door area made contact with the front crash guard of Newton Police cruiser N506 ( MA MVN: MP506B). I observed minor damage to the passenger side door area of MV1 and minor damage to the front crash guard of MV2. No injuries reported. Photos were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
Case
number:
Date:
2019-11-12
Time:
12:26
Address:
2040 COMMONWEALTH AVE
Speed
limit:
10
Violation
cited:
yes
Narrative:
On 11/12/2019 at 12:26 hours, I responded to the Star Market parking lot located at 2040 Commonwealth Avenue for a motor vehicle pedestrian accident. The parking lot is a public/thru way that motorists use to access the Star Market along with other businesses. The weather at the time was cloudy and rainy and the parking lot was saturated. Prior to my arrival, the pedestrian involved left the scene and did not want to speak to the officer nor wanted medical attention. Ofc. Claflin then cancelled Cataldo Ambulance. The pedestrian, Mary Alexander, left her information with a store employee prior to leaving. I spoke to the operator of MV # 1 (Joshua Randel MD Lic.# R534440603244) who stated that he was travelling through the third row of the Star Market parking lot at an appropriate speed. He was then attempting to make a left turn near the entrance/exit of the store. He says that there was a large white van parked in the end handicapped spot towards the left of him. He says the van was sticking out in the spot limiting his visibility. As he was half way through his left turn and coming around the corner, he was not able to see a pedestrian pushing a shopping carriage. He then struck the carriage that was being pushed by Mary Alexander. He further says that the cart jolted Ms. Alexander and she fell down to the ground. At the time, Alexander was walking through the lot near the store entrance heading back towards the parked cars. She was not in the crosswalk at the time which was approximately ten feet down from her location. After, I attempted to go to Ms. Alexander's residence to follow up. I spoke to her friend who was bringing up Alexander's groceries and she stated that she decided to go to Newton Wellesley Hospital for treatment. I then spoke to Ms. Alexander in the lobby of the hospital. She stated that she was exiting the store through the lot with her shopping carriage. She believes she was approximately eight feet away from the door when all of a sudden she only saw red coming at her. She believes MV # 1 was speeding at the time. I asked her if she was struck by the vehicle or was the shopping carriage only struck. She replied that she did not know and only remembers falling to the ground after. She sustained a large bruise to the inside palm area of her right hand and her left knee was swollen. Digital photos of the scene were taken and pictures of Ms. Alexander's injuries were taken at the hospital. As far as possible video surveillance, I was told that the Loss Prevention Department has to access the video. On 11/13/19 at approximately 14:20 hours, I went in to the Star Market and spoke to the manager, Nidal Rajeh, inquiring about possible video surveillance. He said there is coverage in the parking lot and he was able to show me the video. A copy of the video would have to be done by Loss Prevention which I requested. I observed at the 12:12pm mark in the video, MV # 1 was parked five spots up from the third row of the lot that he was exiting. I also observed a white transport van parked in the end handicapped spot mentioned by the operator but it was parked correctly and not limiting visibility. Next, MV # 1 backs out of the spot and drives forward going at a reasonable speed. The pedestrian (Alexander) has already exited the store with her carriage and is walking at an angle toward the same third row of parked cars. As the pedestrian is walking towards the direction of MV # 1, it appears that the pedestrian should be visible to him. MV # 1 then starts to take the left turn around the corner without slowing or stopping and strikes the carriage head on. Due to the impact, Alexander then loses grasp of the carriage and it goes past her twisting her body around. She then hits and rolls up on the hood of the vehicle on her left side. MV # 1 then suddenly stops and immediately gets out and provides assistance to the pedestrian. Due to the video surveillance, Mr. Randel will be issued/mailed MA Uniform Citation # T2012347 for Ch. 90/14/A Failure to slow for a pedestrian.
Keywords:
Bus, Citation, Crash, Crosswalk, Ems, Hospital, Ped, Pictures, Rain, Speed, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
Case
number:
Date:
2019-11-15
Time:
16:03
Address:
260 NEEDHAM ST
Speed
limit:
10
Violation
cited:
yes
Narrative:
OPMV#1 Was parked in the parking lot of Marshals located at 260 Needham St when she was attempting to exit her vehicle. When the OPMV#1 opened her car door, the door was struck by the OPMV#2. OPMV#1 Stated she was exiting her car and another vehicle wiped into the spot next to her. OPMV#2 Was attempting to pull into a parking spot in the Marshals parking lot located at 260 Needham St when she struck the left drivers side door of the OPMV#1. OPMV#2 Stated the person parked in the spot didn't even check to see if it was clear to open her car door before she pulled into her spot. OPMV#2 Was issued MA UNIFORM CITATION#T1442156 M.G.L. C.90 S.10 Unlicensed Operation. See INCIDENT REPORT#19049296.
Keywords:
Citation
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3088013
Longitude:
-71.2144481
Location:
Case
number:
Date:
2019-11-24
Time:
17:30
Address:
225 BOYLSTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Sunday 11/24/19 at approximately 1730 hours while working in marked unit n499 I was dispatched to the parking lot on the rt9 side of 225 Boylston Street (Bloomingdales) for a report of a minor motor vehicle crash. Upon arrival I spoke with the operator of motor vehicle 2, GIRARD Kathleen, who states that she was driving from the 2nd aisle of parking spots into the main travel lane to attempt to exit the mall. When she attempted to turn left she didnt see motor vehicle 1 already in the lane of traffic striking the side of the vehicle. After speaking with GIRARD I spoke with the operator of motor vehicle 1, SONG Guang min. SONG did not speak english, but he corroborated what GIRARD had stated by using a translation app on his cell phone. GIRARD had damage to the front of her vehicle and SONG had damage to the drivers side of his vehicle. Both vehicles were still operable and were driven from the scene. Neither party was injured
Keywords:
Crash, Phone, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3213504
Longitude:
-71.177129
Location:
Case
number:
Date:
2019-12-20
Time:
08:39
Address:
146 WALNUT ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Owner of vehicle reports that unk vehicle struck her vehicle while it was parked in her assigned parking space at #146 Walnut st, The hit and run occurred stb 19:30 hours and 21:30 hours last nite, 12/19/2019.
Keywords:
[]
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3547212
Longitude:
-71.2084309
Location:
Case
number:
Date:
2019-12-27
Time:
15:19
Address:
2345 COMMONWEALTH AVE
Speed
limit:
10
Violation
cited:
no
Narrative:
Witness said between 0930 to 1430 hours this date she was out of the hotel running errands. Witness stated her husband's MV (MV1) was parked unoccupied within the lines of 2345 Commonwealth Ave (Marriott Hotel) between those hours. Witness stated when she came back at 1430 hours she observed new damage done to MV1. Witness said during that time period an unknown MV sideswiped MV1 and left the scene without giving information. Witness believes the unknown MV must have scratched their car while attempting to back up from their space. Witness said the minor damage (scratch to the rear passenger side) was not there before today. Witness does not know who may have caused the damage. No injuries reported, no tow required, and no security camera recordings. Witness was advised for the registered owner to contact their insurance.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.346364
Longitude:
-71.2584662
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);