home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

14 rows where dcc_code = "[9, 19]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, hit_run, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000323
Date:
2019-03-28
Time:
09:46
Address:
DEDHAM STREET & BOUND BROOK ROAD
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday, March 28, 2019 while assigned to Traffic unit N525, I responded to the area of Dedham Street and Bound Brook Road, Newton for a report of a motor vehicle accident. Dedham Street and Bound Brook Road are both public ways maintained by the City of Newton. Anna Johnson (S14645384) stated her vehicle, a 2012 Honda CRV (MA: 4AG988), was parked unoccupied on Dedham Street (S) right before Bound Brook Road. Johnson stated she was made aware that her vehicle was hit by a passing vehicle. When she arrived at her vehicle, she observed damage to the driver side door mirror and the rear driver side door area. A note with a name and phone number was left on her vehicle by the operator of MV2. I spoke with Maria Diaz-Santos (S91121221) stated she was operating her 2018 Chrysler Pacifica (MA: 1MMB61) south on Dedham Street towards Bound Brook Road. Diaz-Santos stated as she was traveling past MV1, her rear passenger side door mirror area made contact with the driver side of the parked vehicle. Diaz-Santos stated she contacted Newton PD to make them aware of the accident and left her name and phone number on MV1 for it's owner to exchange information. Diaz-Santos stated there is very minor damage to her passenger side door mirror.
Keywords:
Crash, Phone
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.311434
Longitude:
-71.202243
Location:
Bound Brook Rd & Dedham St, Newton, MA 02461, USA
Case number:
1900000577
Date:
2019-06-05
Time:
00:12
Address:
163 LEXINGTON ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Wednesday, June 5th 2019, at approximately 12:12am, I, Officer Brooks, responded to 163 Lexington street for a report of a 2 car MVA. Upon my arrival I observed that MV1(MA REG 574PF5) had struck MV2(FL REG CWWE22) which was parked legally in front of 163 Lexington street. I spoke with the operator of MV1 who stated he was traveling southbound on Lexington street, and had reached over to his passenger side to grab a Burger King bag. When he reached for the bag he drifted to the right and struck MV2. MV1 had heavy damage to the passenger side and airbag deployment. The operator was checked out by Cataldo and signed a patient refusal. MV1 was towed by Tody's. The operator was issued a citation for an expired registration. I spoke with the owner of MV2 who was inside of 163 Lexington street at the time of the accident. His vehicle had been legally parked when struck. MV2 sustained major damage to the driver's side. MV2 was towed by Tody's. Both operators were provided the report number.
Keywords:
Airbag, Citation, Crash
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3552534
Longitude:
-71.2426722
Location:
163 Lexington St, Auburndale, MA 02466, USA
Case number:
1900000898
Date:
2019-08-30
Time:
17:39
Address:
230 NEEDHAM ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 stated he was travelling westbound on Needham St and was attempting to turn left into the Verizon store when MV2 who was behind him passed him subsequently side swiping him. MV1 further stated that the operator "made eye contact with me after the crash but kept going. MV1 took a photo of MV2's trailer (MA REG C98747). I left a VM with the owner of MV2 requesting a call back. MV1 sustained minor passenger side damage. It is unknown what damage was caused to MV2 and whether it would be to the truck or the trailer. Traffic Bureau update (Officer Gaudet): On September 4, 2019, I made contact with the owner of LPS Enterprises, Tony Lisa. Lisa confirmed MA TRN: C98747 is registered to his company. Lisa stated he will look into who was using the trailer on 8/30/19 and will contact me with their information. I spoke with the operator of MV2, John Subilosky (S89884850). Subilosky stated he was operating a 2011 GMC Sierra (MA CON: T58930) with MA TRL:C98747 attached to it on the afternoon of the accident. Subilosky stated he was not aware he was involved in an accident and stated he would have stopped had he known. Subilosky stated there was a bobcat in the trailer at the time of the crash. Subilosky stated there is no damage to the trailer. Due to the size and weight of the trailer attached to MV2, it is reasonable to believe if MV2 made minor contact with MV1, the operator of MV2 would not have been aware. Subilosky has been added to this report as the operator of MV2.
Keywords:
Crash, Pictures
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3099761
Longitude:
-71.2137295
Location:
230 Needham St, Newton, MA 02464, USA
Case number:
1900000926
Date:
2019-09-10
Time:
09:32
Address:
1411 BEACON ST
Speed limit:
30
Violation cited:
no
Narrative:
On Tuesday, September 10, 2019 while assigned to Traffic unit N525, I responded to the area of Beacon Street and Roslyn Road, Newton for a report of a motor vehicle/bicycle crash. The weather at the time of the crash was overcast. The road surface was dry. Beacon Street and Roslyn Road are both public ways maintained by the City of Newton. I spoke with the bicyclist involved in the crash, Steven Greenzang (S96615185). Greenzang stated he was traveling Westbound on Beacon Street in the shoulder lane on his black Specialized bicycle. Greenzang had a yellow reflective vest on and was wearing a helmet at this time. Greenzang stated a vehicle in the travel lane to his left drove by him and hit the mirror located on his left handlebar. I observed damage to the mirror. Greenzang report no injuries. I spoke with the operator of MV1, Sarah Bonfanti (S66811372). Bonfanti stated she was parked in front of 1411 Beacon Street waiting to pick up a co-worker that resides at that address. Bonfanti stated a bicycle traveling on the sidewalk to her right crashed into the passenger side door mirror of her 2008 Toyota Scion (MA: 681YH1). Bonfanti stated the bicyclist was acting "crazy" during her interaction with him and he was trying to take her picture. Bonfanti stated she got back into her vehicle and moved up the roadway to wait for police to arrive on scene. I canvassed the area where the accident occurred with Sgt. Dempsey. There was glass from the passenger side mirror of MV1 and Greenzang's bicycle in the main travel lane of the roadway and the shoulder lane where Greenzang stated he was traveling. We also observed a large tree and a telephone pole on the sidewalk next to the roadway where the accident is alleged to have occurred. After speaking with all parties involved, observing the location of the glass in the roadway from the crash, and the location of the tree and telephone pole on the sidewalk where he accident occurred; Greenzang would not have been able to operate his bicycle on the sidewalk and be close enough to the roadway to make contact with MV1. Prior to clearing the accident, I asked Bonfanti if she had any questions and if she wanted to report any injuries. Bonfanti stated she was hit by the bicyclist during her exchange with him and began grabbing her left leg. I asked Bonfanti why she did not inform the officers on scene that she was assaulted. Bonfanti stated she said something to our Dispatch when she called. I asked Bonfanti if her leg was injured. Bonfanti stated I was putting words in her mouth and that she was just scratching her leg. Bonfanti then stated she was hit in the right shoulder. I asked Bonfanti if she would like an ambulance to respond and evaluate her. Bonfanti declined and stated she was more concerned about her mirror. I advised Bonfanti if she wanted to pursue charges against Greenzang she could do so in Newton District Court. I listened to the 9-1-1 recording Bonfanti made in regards to this incident. Bonfanti stated a pedestrian busted out her window. Bonfanti then stated to our dispatcher that the bicyclist lost control of his bicycle and smashed into her car. During her exchange with the our dispatcher, I did not hear Bonfanti say she was physically assaulted by Greenzang.
Keywords:
Bike, Bus, Crash, Ems, Helmet, Ped, Pictures, Tree
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3302456
Longitude:
-71.2218279
Location:
1411 Beacon St, Waban, MA 02468, USA
Case number:
1900001228
Date:
2019-12-01
Time:
10:55
Address:
4 MARLBORO ST
Speed limit:
25
Violation cited:
no
Narrative:
Reporting party parked her father's MV (MV1) infront of 4 Marlboro St (public way) facing northbound near the Tremont St intersection at approximately 1930 hours on Saturday 11/30/19. Reporting party was not present during the incident. A witness observed MV2 operated by an unknown party slowly sideswipe MV1. Witness stated the MV2 operator did not exchange paper work and left the scene immediately. Witness took a photo of the incident and forwarded it to reporting party when they met this morning. MV1 sustained heavy damage to the left rear bump and rear left side. No known injuries, no towed required. Reporting party dropped MV1 off at Honda Dealership on Washington St, and we transported the reporting party from Honda Dealership to her new address. Reporting party forward me the photo of the incident, and it has been forwarded to the IT Bureau. MV2 belonged to a Landscaping company, and I was unable to reach a party at this time. Traffic Bureau Update (Officer Gaudet): On Tuesday, December 10, 2019, I attempted to make contact with the registered owner of MV2, Brian Vassar (S88865602) with a negative result. A Hit and Run inquiry was mailed to Vassar.
Keywords:
Pictures
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3520996
Longitude:
-71.1756486
Location:
4 Marlboro St, Newton, MA 02458, USA
Case number:
2000000616
Date:
2020-10-27
Time:
18:39
Address:
546 PARKER ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Tuesday, October 27th 2020 at 18:40 hours, Myself N-499 and Ofc Crowe N498 responded to 546 Parker St for a single vehicle accident into a city tree. Upon arrival, I identified Mass Reg # 3GDM90, 2015 LEXS RX350, Color Gray had crashed into a City Tree. The airbags had not been deployed. The operator was no longer in the vehicle upon my arrival. He was identified as registered owner Brian Mcneill. Mcneill admitted he had operated the vehicle. Mcneill stated he was driving North on Parker St toward RT 9 headed home to Wellesley. Mcneill stated he was on his phone texting and lost sight of the road. Mcneill's vehicle veered off the side of the road and side swiped a City of Newton Tree causing heavy right side damage and loss of the front right tire. Mcneill's wife came to the scene to pick him up and drive him home. The set of golf clubs in the trunk of the vehicle was documented in the MV Inventory Crash Form. Mcneill suffered no injuries and signed a patient refusal with the medics. Tody's towed the vehicle. Mcneill was given MA Uniform Citation # T2013042 for the amount of $ 210 for M.G.L Ch 89/S4A Marked Lanes Violation and M.G.L Ch. 90/S13B Texting While Driving Violation. Pictures were taken of the accident and submitted to Newton IT Bureau.
Keywords:
Airbag, Citation, Crash, Phone, Pictures, Tree
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3089195
Longitude:
-71.197509
Location:
546 Parker St, Newton, MA 02459, USA
Case number:
2100000320
Date:
2021-05-07
Time:
12:45
Address:
497 CENTRE ST
Speed limit:
25
Violation cited:
yes
Narrative:
On Friday, May 7, 2021, while assigned to Traffic unit N525, I responded to the area of Colby Road for a report of a crash involving a City of Newton owned vehicle. The weather at the time of the crash was clear and sunny. The road surface was dry. I spoke with Mr. Michael Sanford from the City of Newton Water Department. Mr. Sanford stated his City of Newton owned vehicle (2013 Ford F-250 (MA MVN: M88493) was parked unoccupied (S) in front of 497 Centre Street, Newton. Mr. Sanford stated his emergency lights were on while he was marking out a service. Mr. Sanford stated he then observed a white 2005 Ford Ecowagon (MA CON: L61558) travel past his vehicle South on Centre Street and make contact with his driver side door mirror. Mr. Sanford stated the vehicle continued down Centre Street and he followed it to Rochester Road where is came to a stop. I observed damage to the driver door mirror. I spoke with the operator of MV2, Ms. Jerrie Spencer (S12241050). Ms. Spencer stated she knew she made contact with MV1's driver door mirror, but was trying to make it to her appointment at the Faulkner Hospital and that is why she did not immediately pull over. I observed damage to the front passenger side door mirror. Ms. Spencer was provided with Massachusetts Uniform Citation 994181AA for Chapter 89, Section 4A (Marked Lanes Violation). Centre Street is a public way maintained by the City of Newton. Photos were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Citation, Crash, Hospital, Pictures, Solar
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3538928
Longitude:
-71.1867646
Location:
497 Centre St, Newton, MA 02458, USA
Case number:
2100000650
Date:
2021-08-31
Time:
12:39
Address:
2014 WASHINGTON ST
Speed limit:
5
Violation cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that he was traveling Northbound toward the exit of the main entrance of Newton Wellesley Hospital. The operator stated that there was a truck parked in the fire lane on the right side which caused him to slightly cross over the other side of the road. The operator then stated that the road was on a bend and realized that motor vehicle #2 was approaching on the opposite side of the road and was not stopping. The operator stated that he realized that motor vehicle #2 was not going to fit and stopped the vehicle. operator of Motor Vehicle #1 stated that Motor vehicle #2 drove into his vehicle causing minor damage. Operator of Motor Vehicle #2 stated she was driving Southbound on the main entrance road of Newton Wellesley towards the Emergency entrance and realized that the rear end of the 18 wheeler was in her lane and she was trying to veer to the right to avoid the truck however was unable to. Motor vehicle # 2 sustained minor damage to the front drivers side pillar and drivers side mirror.
Keywords:
Fire, Hospital
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, USA
Case number:
2100000819
Date:
2021-10-13
Time:
09:10
Address:
320 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator #1 stated he was travelling westbound on Washington St passing the Sheraton Four Points Hotel, 320 Washington St, when he was hit by another vehicle. Operator #1 stated the operator of a white sedan ( Operator #2) was attempting to change lanes behind him and hit the rear driver side of his vehicle. Operator #2 fled the area without stopping. Vehicle #1 had minor damage to the rear of his vehicle. He stated Vehicle #2 would have damage to the front of their vehicle but unsure what side. He stated Vehicle #2 was a white sedan with a black male driver and a person in the back seat, possibly a rideshare service. Operator #1 was able to drive his vehicle away from the scene.
Keywords:
[]
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
320 Washington St, Newton, MA 02458, USA
Case number:
2100000981
Date:
2021-11-23
Time:
16:53
Address:
BEACON ST & WASHINGTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
Upon arrival, vehicle 1 was on the median facing Northbound on Beacon St at the intersection of Beacon St and Washington St. There was damage to the front drivers side bumper. Vehicle 2 was facing Southbound on Beacon St at the intersection of Beacon St and Washington St. There was heavy damage to the front bumper of Vehicle 2 and it was leaking fluid. Operator 1 stated through a translation device on his cell phone," Look, I was coming slowly when I was going down the curve and the car lost the brake, I didn't have it." When queried through dispatch, it came back that operator 1 was unlicensed. Operator 2 stated she was traveling on Washington St and taking a left turn to head Southbound on Beacon St when vehicle 1 drove over the median and crashed into her head on. Both vehicles were towed by Tody's towing. It appeared that the brakes on vehicle 1 were functioning properly when Tody's towing moved the vehicle. Operator 1 and 2, both signed patient refusals with Fallon Medics. Operator 1 was handed Massachusetts Uniform Citation#T1445614 in hand for Unlicensed Operation (Incident report# 21049086).
Keywords:
Citation, Crash, Phone
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3300068
Longitude:
-71.2484874
Location:
Beacon St & Washington St, Newton, MA 02462, USA
Case number:
22000224
Date:
2022-03-16
Time:
10:23
Address:
258 CONCORD STREET
Speed limit:
25
Violation cited:
no
Narrative:
OPERATOR OF MV 1 STATED SHE WAS TRAVELING SOUTH ON CONCORD ST WHEN SHE CAME DISTRACTED BY HER HAIR AND STRUCK A LEGALLY PARKED MV ON THE DRIVERS SIDE REAR TIRE. HEAVY DAMAGE SUSTAINED AND NO INJURIES WERE REPORTED. TODY'S RESPONDED AND TOWED MV 1 TO THEIR LOT. MV 2 WAS UNOCCUPIED AND PARKED LEGALLY DURING THE INNCIDENT. HEAVY DAMAGE SUSTAINED AND TODYS TOWING TOWED MV 2 TO THEIR LOT AS WELL. THE OWNER WAS NOTIFIED OF THE ACCIDENT AND GIVEN THE ACCIDENT REPORT NUMBER.
Keywords:
Crash, Distracted
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3261223
Longitude:
-71.2575006
Location:
258 Concord St, Newton Lower Falls, MA 02462, USA
Case number:
22000283
Date:
2022-04-07
Time:
21:13
Address:
NAHANTON ST & WINCHESTER ST
Speed limit:
25
Violation cited:
yes
Narrative:
MV#1 was traveling west on Nahanton St. MV#2 was traveling east on Nahanton St, crossing over the intersection at Winchester St. MV#2 struck MV#1 in the west bound lane, rolled over sliding 30 to 40 feet down the road. MV#2 then flipped back over onto the tires, and came to rest on the side of the road. Operator of MV#1 stated that while she was traveling west on Nahanton St, she observed a motor vehicle coming at her. She stated that she attempted to swerve to the side of the street to avoid impact, but that the other vehicle struck her on the side, and rolled over on the roof. Operator of MV#2 stated that she was traveling east on Nahanton St, and that someone had struck her causing her not to be able to steer. She stated that her windshield crashed in, and that she was not able to control her car. She stated that she then came to rest on the side of the street. There was a witness that was in a vehicle, behind MV#2. That witness stated that MV#2 crossed over into the oncoming traffic lane, heading right towards MV#1. He stated that it appeared as if MV#2 did not realize that she was going into the wrong lane until the last second. The witness stated that he observed MV#2 attempt to make a last second correction to her vehicle before crashing into MV#1. Witness stated that MV#2 then rolled over onto its roof, before sliding a distance down the road, and then righting it self back up. Both vehicles were towed away by Todys. Operator and occupant of MV#1 signed a patient refusal. Operator of MV#2 was transported to Brigham and Womens hospital. Operator of MV#2 was mailed citation #T2014884 (see incident report #22012411). I am also charging Operator of MV#2 with Ch90 Sec24E (Operating to Endanger) and Ch89 Sec4A (marked lanes violation).
Keywords:
Citation, Crash, Hospital
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.2969738
Longitude:
-71.2009796
Location:
Nahanton St & Winchester St, Newton, MA 02459, USA
Case number:
22000385
Date:
2022-05-10
Time:
13:45
Address:
57 CHARLESBANK ROAD
Speed limit:
25
Violation cited:
no
Narrative:
OPERATOR OF MV 1 WAS TRAVELING WEST ON CHARLESBANK ROAD WHEN HIS DRIVERS SIDE MIRROR WAS STRUCK BY A BLACK TOW TRUCK TRAVELING IN THE OPPOSITE DIRECTION ON CHARLESBANK ROAD. OPERATOR OF MV 1 WAS IN THE PROPER LANE WHEN THE ACCIDENT OCCURRED. THE OPERATOR OF MV 1 WAS UNABLE TO GET A REGISTRATION PLATE OR FURTHER DESCRIPTION BECAUSE IT HAPPENED SO QUICKLY AND MV 2 DROVE OFF WITHOUT EXCHANGING INFORMATION. MODERATE DAMAGE SUSTAINED TO MV1 AND NO INJURIES WERE REPORTED.
Keywords:
Crash, Moderate
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3587686
Longitude:
-71.1786414
Location:
57 Charlesbank Rd, Newton, MA 02458, USA
Case number:
22000558
Date:
2022-06-23
Time:
12:06
Address:
LOWELL AVENUE & OTIS STREET
Speed limit:
25
Violation cited:
yes
Narrative:
On Thursday, June 23, 2022, while assigned to unit N492, I responded to the area of Homer Street and Lowell Avenue in Newton for a report of a Hit and Run Crash. The weather at the time of the crash was clear and sunny. The road surface was dry. Detective Sgt. Claflin was working a paid detail for Feeney Brothers at the intersection of Lowell Avenue and Otis Street. While monitoring the traffic in the area, Detective Sgt. Claflin heard what he believed to be a vehicle crash in his vicinity. Detective Sgt. Claflin looked across the intersection and observed a 2020 Honda Civic (MA: 7MR818) leaving the scene down Lowell Avenue (S) towards Commonwealth Avenue. This vehicle had damage to it's passenger side door area. Detective Sgt. Claflin also observed fresh damage to the rear driver side bumper area of a 2021 Dodge Ram (MA: 5CFR30) that was parked in front of 296 Lowell Avenue (S). Detective Sgt. Claflin then entered his personal vehicle and attempted to catch up to the Honda Civic that left the scene to check on their well-being. Detective Sgt. Claflin stated as the vehicle approached the intersection of Lowell Avenue (S) and Commonwealth Avenue, it proceeded through the intersection on to Homer Street with out stopping at the red light activated at this intersection. Detective Sgt. Claflin was finally able to stop the vehicle on Homer Street just after Commonwealth Avenue. I arrived on scene and spoke with the operator, Ms. Ludmila Gelman (S30392030). I asked Ms. Gelman about the events that took place prior to Detective Sgt. Claflin stopping her. Ms. Gelman stated she did not know what happened. I observed moderate damage to the front passenger side door area of her vehicle. The front passenger door mirror was damaged and folded in. The glass window from the front passenger door was shattered and missing. There was glass from the middle covering the entire front passenger seat/floor area inside the vehicle. I showed Ms. Gelman the glass inside her vehicle and the damage to her door and asked her if she knew what caused it. Ms. Gelman stated she did not know and that something must have hit her. I explained to Ms. Gelman the events that has just transpired as conveyed to me by Detective Sgt. Claflin. Ms. Gelman seemed to be confused and did not understand what happened. Ms. Gelman called her son Steven and asked me to speak with him. I explained to Steven the events leading up to me speaking with him. I explained to Steven I did not feel comfortable allowing Ms. Gelman to drive away from the scene. At Steven's request, I moved Ms. Gelman's car away from the intersection and parked it in front of 1103 Commonwealth Avenue for him to pick it up. Ms. Gelman reported no injuries and was transported to her residence by myself in unit N492. Ms. Gelman was given Massachusetts Uniform Citation 487210AB in hand for Chapter 90, Section 24 (Leaving The Scene Of Property Damage), Chapter 89, Section 9 (Fail To Yield, Red Light), and Newton City Ordinance Chapter 19, Section 75 (Fail To Use Care). Ms. Gelman was also advised I would be filing an Immediate Threat with the Registry of Motor Vehicles. A Request for Immediate Threat License Suspension/Revocation was completed and submitted tot he Registry of Motor Vehicles with supporting documentation via e-mail, DCUImmediateThreat@massmail.state.ma.us. I returned to the area of the crash and observed damage to the rear driver side bumper area of the involved Dodge Ram. The vehicle was unoccupied at the time of the crash. The registered owner, Mr. Zachary Maclaughlin, was advised. A copy of the issued Criminal Application was submitted to the Court Prosecutor with supporting documentation. Otis Street, Lowell Avenue, Commonwealth Avenue, and Homer Street are all public ways maintained by the City of Newton.
Keywords:
Citation, Crash, Moderate, Solar
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3473475
Longitude:
-71.2108849
Location:
Otis St & Lowell Ave, Newton, MA 02460, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 293.117ms