home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

17 rows where dcc = "[]", intersection = 0 and keywords contains "Phone"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: address, street1, speed_limit, hit_run, keywords, geocoded_address, latitude, longitude, datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000083
Date:
2019-01-20
Time:
09:55
Address:
503 WATERTOWN ST
Speed limit:
25
Violation cited:
no
Narrative:
On the above date/time I responded to 503 Watertown Street for report of a mva hit/run with property damage. Upon arrival I met with the owner of 503 Watertown Street Ms. Antonietta Tempesta she stated through he daughter in law Ms. Tiz Acuri at approx. 0830 hours she noticed fresh tire impressions on the roadway leading onto the sidewalk and into her fence that was damaged. She also stated the MA registration plate # 5DT664 was on the fence. I ran the the plate which came back to a 2003 Ford pickup color white to Kyle Butler of 84 Auburndale Ave Newton MA. Officer Boyle in unit 493 went to the residence and spoke with Kyle's uncle to call NPD. I advised Ms. Acuri of the process. Mr. Butler called NPD I spoke with him on the phone. He stated he was driving west on Watertown Street and due to the icy roadway his truck slid to the right onto the sidewalk and into what he thought was a snow bank. I gave all parties each others information and advised them. I gave the uncle Kyles reg plate.
Keywords:
Ice, Phone, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3578253
Longitude:
-71.2059094
Location:
503 Watertown St, Newton, MA 02460, USA
Case number:
1900000490
Date:
2019-05-07
Time:
07:00
Address:
15 NEEDHAM ST
Speed limit:
5
Violation cited:
no
Narrative:
On 05/10/19 I met with Luiz A. Lopes who stated his vehicle ( Mass Commercial Reg# T83695 White Toyota Tacoma P/ U) was struck while parked in the lot around 07:00. Lopes said he didn't call the Police right away because he wasn't sure his car was struck there. The truck sustained a cracked front bumper and the fog light was popped out. We went inside of National Lumber and spoke with a manager who said he would contact G.M. Greg Assarian and have him look at the security footage. On 05/14/19 at approximately 14:00 the Police Station received a call from Lopes who just got off the phone with Assarian who found some security footage of the incident. I then traveled over to National Lumber and met with Assarian. He showed me the video and it appears that a newer grey four door Chevrolet truck backed into Lopes truck around 06:58 of 05/07/19. The Massachusetts plate is unreadable but an older White heavy set male gets out of the truck and walks into the store. After parking the truck the male can be seen checking his own truck bumper for damage. The male is wearing a baseball hat and sun glasses and cannot be identified on the video. The male does however walk with a noticeable limp. Assarian will show his picture to his employees and contact me if the employees are able to identify the male driver. I called Lopes back and apprised him of my findings. ******************UPDATE**************************************** As of today 05/20/19 I have yet to hear back from anyone at National Lumber so I will end this investigation and label it a hit and run crash.
Keywords:
Crash, Phone, Pictures, Solar, Walk
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3168424
Longitude:
-71.2097042
Location:
15 Needham St, Newton, MA 02461, USA
Case number:
1900000493
Date:
2019-05-15
Time:
12:27
Address:
35 PULSIFER ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 5-15-19 AT APPROX. 1227HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 35 PULSIFER I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES HE WAS PARKED IN FRONT OF 35 PULSIFER AND WHEN HE RETURNED TO HIS CAR HE NOTICED A DENT ON THE LEFT FRONT FENDER. THERE WAS NOTE WITH A PHONE NUMBER ATTACHED TO HIS WINDSHIELD. WHEN HE CALLED THE NUMBER HE GOT NO RESPONSE. OWNER DOES NO KNOW WHO HIT HIS VEHICLE. OWNER WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. VEHICLE #1 HAS MINOR FRONT END BUMPER DAMAGE. OWNER TOOK PICTURES OF THE DAMAGE.
Keywords:
Crash, Phone, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3465437
Longitude:
-71.2053061
Location:
35 Pulsifer St, Newton, MA 02460, USA
Case number:
1900001141
Date:
2019-11-06
Time:
06:10
Address:
15 NEEDHAM ST
Speed limit:
30
Violation cited:
no
Narrative:
On 11/6/19 at approximately 0610 hrs I responded to 15 Needham St., the National Lumber for a MVA involving a pedestrian. Upon arrival I spoke to the pedestrian who was lying on the street who stated he landed on his back and couldn't feel if anything was hurting. I advised him to stay put until the medics responded. The pedestrian was wearing brown pants and a black jacket and stated he was listening to his head phones when he attempted to cross the street. Where he attempted to cross was down Needham St from the main intersection and there was no crosswalk. He attempted to cross from the National Lumber side crossing the S/SW travel lane first. I then talked to the operator of MV#1 who stated he turned right onto Needham St from Winchester St and didn't see anybody attempting to cross until the last second. At this time he stated he jammed on his brakes and saw pedestrian on the hood of his Pickup before he fell to the ground. There was minor damage to the hood of the vehicle on the passenger side. The pedestrian was evaluated by the Medics and transported to NWH for further evaluation. Pictures were taken on scene and turned over to the IT bureau.
Keywords:
Crosswalk, Ped, Phone, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3168424
Longitude:
-71.2097042
Location:
15 Needham St, Newton, MA 02461, USA
Case number:
1900001315
Date:
2019-12-19
Time:
14:43
Address:
73 WALNUT ST
Speed limit:
20
Violation cited:
no
Narrative:
On 12/19/2019 at 14:43 hours Newton Police dispatch received numerous phone calls about a white male whose face was covered in blood and was riding on an electric motorized scooter south bound on Walnut St near number 100. Walnut St is a public way in the city of Newton. Approximately two tenths of a mile south 100 Walnut St, Ofc Garcia stopped the male on the scooter. Ofc Garcia stated that the male on the scooter was evasive when answering his questions and claimed that he did not realize that his face was covered in blood. The male on the scooter was identified as Gregory David Brown. Brown was transported to Newton Wellesley Hospital for treatment. Prior to Brown being transported I was dispatched to the area of 100 Walnut St for a report of a male on an scooter who had crashed into a south bound vehicle in traffic on Walnut St and another vehicle that was parked in front of number 73. Upon my arrival I spoke with Penni Rochwerger and Nikita Espinal. Rochwerger stated that she was driving south bound on Walnut St across from 100 when she activated her vehicle's four way flasher and stopped her vehicle to let Espinal who was the front seat passenger out. Rochwerger stated that south bound traffic stopped behind her vehicle after she came to a stop adjacent to Espinal vehicle that was parked facing south in front of 73 Walnut St. Espinal stated that she checked over her right should to see if it was clear to open her door and it was . Espinal stated that as she opened her door to exit a male on scooter crashed into the door and fell to the ground. Both Rochwerger and Espinal stated that the male on the scooter did not provide his name or address and continued south bound on Walnut St with his face coved in blood. Rochwerger's vehicle sustained damage to the front passenger side door that would not closed all the way. Espinal vehicle also had damage to it, the rear driver's side lower quarter panel was struck. I responded to Newton Wellesley Hospital to speak with Brown. When I arrived and spoke with Brown he was evasive with his answers . When I asked Brown what had happened he gave conflicting answers and contradicted himself. Brown stated that he was riding his scooter on the roadway south bound on Walnut St be could not recall any other details. When I asked Brown if he was wearing a helmet as required by MGL 90/1E he stated he couldn't recall. Rochwerger, Espinal and Ofc Garcia all stated to me that they did not see Brown wearing a hamlet. There was an unconfirmed post by a person named Tricia Marucci to the Facebook group Newton Parents stating that at 14:45 hours on 12/19/2019 saw Brown hitting a defect in the roadway in the area of Crafts St by California St that caused him to loses control of his scooter and fall face first onto the pavement. In her post Marucci stated that Brown was cover in blood from facial lacerations, and that he refused medical aid and continued to ride his scooter south bound towards the entrance to Walnut St. I left a message for Marucci to contact me and as of the writing of this report she has yet to do so. While at the hospital I ran Brown's name and date of birth via the MA RMV data base in order to issue him a citation for not wearing a helmet. The query of Brown via the MA RMV data base reviled that Brown's MA driver's license statutes was suspended. On 07/11/2018 admitted to a finding of sufficient facts to one count of MGL 90/24 OUI liquor. Brown received a Continued With Out Finding for 18 months. In addition Brown pleaded guilty to an additional count of MGL 90/24V Child Endangerment While OUI. Brown received a 90 day sentence in the Middlesex House of Correction which was suspended for 18 months. Brown also received a one year loss of his driver's license. Brown is on active probation out of Newton District Court until 07/21/2020. Biased upon the statements made to me I issued Brown MA Criminal Application T 2012526 for violations of MGL 90/24(2) Leaving The Scene Of An Accident Property Damage , MGL 90/1E Operation Of A Motorized Scooter Without A Valid License and MGL 90/1E Operation Of A Motorized Scooter With Out A Helmet. As of 12/20/2019 Brown was discharged from Newton Wellesley Hospital.
Keywords:
Citation, Crash, Helmet, Hospital, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3567928
Longitude:
-71.2103282
Location:
73 Walnut St, Newton, MA 02460, USA
Case number:
2000000146
Date:
2020-02-13
Time:
07:37
Address:
897 CHESTNUT ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated he was travelling northbound on Chestnut St when MV#3 struck his vehicle travelling southbound on Chestnut St. MV#3 continued southbound on Chestnut St and struck MV#2. MV#3 continued southbound on Chestnut St and left the accident scene. MV#1 sustained no visible damage due to it being a large steel framed garbage truck. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated she travelling northbound on Chestnut St directly behind MV#1 when she observed MV#3 struck MV#1 then striking her vehicle.MV#2 sustained heavy damages to its driver's side mirror. There were no reported injuries to the operator of MV#2 or its passenger. MV#3 was described as a white colored small sized "Sprinter van" type vehicle with heavy driver's side damages. The operator of MV#3 was reported to be a young white male and was texting and driving. A radio broadcast was given out to surrounding cities and towns and a canvass of the surrounding area showed negative results for MV#3.
Keywords:
Crash, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3184464
Longitude:
-71.2263295
Location:
897 Chestnut St, Waban, MA 02468, USA
Case number:
2000000228
Date:
2020-03-11
Time:
19:07
Address:
517 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
MV#1 was parked on the side of the road at 517 Washington St at 10am. The owner returned to her car at approximately 7pm and found moderate damage to the driver side and front of the vehicle. It appears as though MV#2 was travelling westbound on Washington St and was too close and sideswiped MV#1. A note was left with a phone number (617 892 0027) but no driver information. The owner was not able to make contact. I also attempted to reach the number with negative results. Owner was able to drive her vehicle from the scene.
Keywords:
Moderate, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3554503
Longitude:
-71.1943066
Location:
517 Washington St, Newton, MA 02458, USA
Case number:
2100000101
Date:
2021-02-10
Time:
18:19
Address:
176 BOYLSTON ST
Speed limit:
5
Violation cited:
no
Narrative:
On 2/10/21 at approximately 1820 hours, I responded to Basset Furniture for report of a past hit and run. Owner of MV1 stated he came out to his vehicle and saw damage to the left rear bumper of his vehicle. There was damage to the rear end of his vehicle but was able to drive away from the scene. a number was left 617-543-8628 Traffic Bureau update (Officer Gaudet): On Tuesday, February 16, 2021, I called the phone number provided by the RP with a negative result. The voice mail for the phone number provided no identifiying information about the other party involved. A message was left to have this party contact me. Through a search, I discovered the phone number is registered to Mr. Mauricio Castri and the carrier is T-Mobile.
Keywords:
Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3199042
Longitude:
-71.1748892
Location:
176 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
2100000276
Date:
2021-04-20
Time:
11:46
Address:
978 BOYLSTON ST
Speed limit:
10
Violation cited:
no
Narrative:
On 04/20/21 at 11:46 hours, I (Traffic Unit 523) responded to the CVS parking lot located at 978 Boylston Street for a city motor vehicle hit & run accident. The city vehicle was struck when the operator was inside the store and the other unknown vehicle left the scene. The CVS parking lot is a thru-way for the public to access and park for the store. The weather at the time was partly cloudy and the road conditions were dry. On arrival, I met the driver of the city vehicle identified as William Bertrand (MA D/L# S24973075). The vehicle is a 2016 Ford Escape color black with MA registration # M2534A and is labeled as vehicle number 304. Mr. Bertrand stated he was parked in the lot and went inside the store. The Escape was parked in the seventh spot in from the parking stalls closet to the entrance of the store. He then came out and observed that the vehicle had been struck on it's rear driver's side quarter panel area. He says the other vehicle had left the scene and no note was left on his vehicle. I observed numerous scrape marks to that mentioned area and I took digital photos of the damage. I also observed two small specks of paint on the damaged area that were a bluish gray type of color from the suspect vehicle. It appears that due to the scrape marks that the unknown vehicle was pulling in to the parking space to the left of the city vehicle. As it was pulling in, it struck the city vehicle with it's front passenger quarter panel area. I spoke to Nick (CVS manager) on the phone and was inquiring about possible surveillance footage of the lot. He stated that he didn't believe the cameras cover that area of the lot but he would look for any possible footage and notify me if so.
Keywords:
Crash, Phone, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3181167
Longitude:
-71.211237
Location:
978 Boylston St, Newton, MA 02461, USA
Case number:
2100000362
Date:
2021-05-19
Time:
16:41
Address:
457 WALNUT ST
Speed limit:
5
Violation cited:
no
Narrative:
On Wednesday, May 19th 2021, at approximately 4:40pm, I, Officer Brooks, responded to 457 Walnut street, the Newton North High school, for a hit and run that occurred in the parking lot. I spoke with the operator of MV1(MA REG 672MT6), who stated his vehicle had been parked in the lot all day. When he came out he found a note on the car saying sorry that I backed into your car, and a phone number (617-899-4204). No other information was provided. MV1 had a plastic fascia piece broken off of the front bumper. Attempts to reach the other driver at the number provided were unsuccessful and a voicemail was left. The operator of MV1 was provided with the report number. There are cameras on the high school that face the parking lot and may have caught the accident, but I was not able to access them at this time. MV1 was parked in the 4th row of spots if you count them from the wall of the school out towards the street. Traffic Bureau update (Officer Gaudet): I was able to obtain a name associated with the phone number provided on the note of MV1. The phone number is registered to Mr. Dominic Matos (SA2100551). I attmepted to contact Mr. Matos with a negative result. I left a message for him to contact me to provide a statement.
Keywords:
Crash, Phone, School
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3449976
Longitude:
-71.2077738
Location:
457 Walnut St, Newtonville, MA 02460, USA
Case number:
2100000557
Date:
2021-07-27
Time:
14:49
Address:
513 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On 07/27/2021, while assigned to N494, I, Officer Conary, spoke with DEALE, Cathy (Operator of MV1) over the phone about a past hit and run. DEALE explained to me that she parked Westbound on Washington Street in front of 513 by the fire hydrant. Between 1200-1400 MV1 was hit on the driver side, and the mirror broke off. Operator of MV1 did not see any other vehicle standing by, she left the area and notified Newton Police. Operator of MV1 sent me pictures to confirm the damage. I went back to the area of where the accident was reported and confirmed glass and a pieces of a mirror on the side of the road.
Keywords:
Crash, Fire, Phone, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3552254
Longitude:
-71.1940066
Location:
513 Washington St, Newton, MA 02458, USA
Case number:
2100000732
Date:
2021-09-20
Time:
13:54
Address:
314 HAMMOND ST
Speed limit:
25
Violation cited:
no
Narrative:
On the above date and time while on Patrol in N496 I responded to 314 Hammond St (Boston College) to assist BCPD with damage to a wall. On arrivial I spoke to BCPD who stated they were alerted by an employee (Luckny Capre) that NP landscaping pulled onto the property to turn around and while pulling back onto Hammond St struck the stone wall ripping it apart. While speaking to BCPD thier dispatch was able to locate the landscaper by phone who stated they were in Newton Corner area and would come back. The landscaper returned and was identified as Luis Chingo-Calel and stated he knew he struck the wall but did not know what to do. I issued Chingo-Calel MA Uniforn Citation #T1447323 for 90/24 leaving the scene with property damage. See also incident report #21040232
Keywords:
Citation, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3312402
Longitude:
-71.1697398
Location:
Haley, 314 Hammond St, Chestnut Hill, MA 02467, USA
Case number:
2100000748
Date:
2021-09-23
Time:
09:35
Address:
15 SUMMER ST
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday 9/23/2021 at approx 0935hrs, while assigned to N-498, I responded to 15 Summer St in Newton for a past H&R. There, I spoke with witness Kelly Alegria, who stated she observed a vehicle sideswipe a legally parked car (MV1). She said that she did not see the license plate of the other car but it appeared to be a turquois Nissan sedan operated by an older white man. Alegria stated the Nissan was travelling WB on Summer St before hitting MV1. I later contacted the owner of MV1 over the phone and provided a accident report number.
Keywords:
Crash, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3156195
Longitude:
-71.22445
Location:
15 Summer St, Newton, MA 02464, USA
Case number:
2100000877
Date:
2021-10-28
Time:
18:18
Address:
1221 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
On October 28, 2021 at approximately 18:26 hours I, Officer Guarino, spoke with Craig Gimbrone over the phone, who reported that he was hit by a motor vehicle in the crosswalk at 1221 Centre St between 15:00 and 15:13 hours. Craig said that he was crossing the crosswalk at 1221 Centre St east to west and was struck by a black car traveling southbound in the far right lane of Centre St. Craig said that the vehicle struck him and caused him to fall over, Craig got up and continued to cross the street and enter CVS without speaking with the operator of the vehicle. Craig did not get a license plate, description of the vehicle or the operator. Craig could only recall that the vehicle was a black sedan. Craig was wearing blue jeans and a gray jacket at the time of the collision. Craig said that the crosswalk flashing lights were not activated prior to him crossing the roadway. Crag said that he did not need EMS but was starting to have pain in his right ankle and right shoulder. He emailed me photographs of his ankle which was forwarded to IT to be attached to this report. Craig was given the crash report number for his records.
Keywords:
Crash, Crosswalk, Ems, Phone, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3310364
Longitude:
-71.19491
Location:
1221 Centre St, Newton Centre, MA 02459, USA
Case number:
22000319
Date:
2022-04-19
Time:
13:24
Address:
2014 WASHINGTON ST
Speed limit:
0
Violation cited:
no
Narrative:
On 04/19/2022@1324 hrs. I responded to 2014 Washington St/Newton Wellesley Hospital (E.R.Entrance) for a report of a MVA. On scene I spoke with Alexi Martin MA OLN#S30269628 owner of MA Reg. 1AND24; 2021 Toyt/RAV4 color green (V1). Martin's parked vehicle was backed into by MA Reg. 8844NO; 2016 Toyt/COR color black (V2). Owner of V2 is Jane Lindenbaum MA OLN#S71524093. V2 operated by Lindenbaum backed into V1 which was parked and unoccupied. V1 was parked by NWH Valet Jerome Saint Luc (Valet Co. is VPNE). Saint Luc witnessed the collision and stopped Lindenbaum. He informed her that she hit a parked vehicle as she backed up. Saint Luc informed me that Lindenbaum stated she did not hit the car and proceeded on her way. On scene I also spoke with VPNE Manager Jean Emmanuel Pierre-Canal (857)472-8269. I advised him that Saint Luc was not involved in the MVA but he did witness the collision. I checked with NWH Public Safety and reviewed video surveillance footage which captured the collision. The video did confirm the collision and Saint Luc stopping and speaking with Lindenbaum. Further follow up on this incident to be conducted.as I have not made contact with Jane Lindenbaum. I have left a VM message on a phone number believed to be hers.
Keywords:
Hospital, Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
2014 Washington St, Newton, MA 02462, USA
Case number:
22000408
Date:
2022-05-16
Time:
08:48
Address:
181 LEXINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On Monday May 16, 2022 at 0848 hours vehicle 1 was stopped in front of #188 Lexington St waiting to pick up a child. While parked vehicle 1s drivers side mirror was hit by a passing vehicle traveling southbound towards Commonwealth Ave with out stopping. The operator of vehicle 1, Claire Rice was driving for JSC Transportation and had one child aboard, Amir Ayden-Cronin who was being transported to Newton Early Childhood on Jackson Rd. Neither Rice or Ayden-Cronin reported any injuries and signed patient refusals with Fallon medics. Sahar Zaheer (617-943-8356) is the mother of Amir and I spoke to her over the phone. Zaheer was notified of the situation and gave consent for medics to evaluate her son and for him to continue to school for the day. I contacted Susan Downs (781-272-8555) of JSC to attempt to see if the vans dash camera captured any of the incident but have not heard back at this time. Rice had already spoken to her dispatch who did not believe the camera would have been clear enough to pick up anything to assist in identifying the other operator. Officer Gaudet took pictures of the damage to the vans mirror.
Keywords:
Phone, Pictures, School
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3551907
Longitude:
-71.2433377
Location:
181 Lexington St, Auburndale, MA 02466, USA
Case number:
22000459
Date:
2022-05-27
Time:
17:46
Address:
340 RIVER ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 said she was parked in the parking lot of 340 River Street. Operator of MV1 said MV2 was parked next to her backed up and hit the building of 340 River Street. Operator of MV1 said after MV2 struck the building MV2 drove forward and struck the rear of MV1. Operator of MV1 said that the operator of MV2 exited the vehicle and said that there was no damage and that he did not have time for this. Operator of MV1 said MV2 sped out of the parking lot taking a right heading eastbound on River Street. Operator of MV1 said it was a dark color Toyota that's registration began with a 7. Operator of MV1 described the operator as a young white male with dark curly hair and was wearing a light colored sweatshirt. There was a small scratch on the rear bumper of MV1. According to Operator of MV1 there should be damage done to the right side of the front bumper as well as the rear bumper of MV2. There were no injuries and MV1 was able to drive away from the scene. I spoke to the employee of River Side Street Food Mart (340 River Street). The employee stated they have camera's that face the parking lot but he does not know how to use the cameras. The employee said his boss knows how to use the camera's but he was not working tonight. I provided the employee with the Newton Police's phone number and advised him to call if his boss can send us the video footage to see if we can see the license plate of MV2.
Keywords:
Phone
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3575474
Longitude:
-71.239428
Location:
340 River St, Newton, MA 02465, 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 287.525ms