home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

22 rows where dcc = "[]", intersection = 0 and keywords contains "Snow"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, 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:
1900000073
Date:
2019-01-19
Time:
18:08
Address:
167 CHERRY ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 (MA Reg: 63EP17, a 2000 Acura 32TL; operator: Carlos Standford) was traveling NORTH on Cherry St when a vehicle swirved into his lane head-on. In order to avoid MV3 he swirved into the other lane and side-swiped MV2. MV2 (MA Reg: 9JX388, a 2019 Subaru Outback; operator: James Cant) was traveling SOUTH on Cherry St when he had come to a complete stop, put his left turn signal on to show him turning left into his driveway at 176 Cherry St. He was waiting to make his turn until MV1 had driven past so it was safe to do so. As he was at a complete stop, MV1 collided with his rear driver side bumper in an effort to avoid a head on collision with MV3. MV3 (MA Reg: 93YE85; a 1997 Toyota Camry; operator Matthew Kuniholm) was traveling SOUTH on Cherry St when he had seen MV2 at a complete stop with a turn signal. He didn't give himself enough time to stop, began to slide as he was braking and went over the marked lanes into oncoming traffic in an effort to not collide with MV2. MV3 operator, Matthew Kuniholm, was issued in hand MA Uniform Citation T1440470 for Marked Lane Violation 89/9a. All vehicles were still in driveable condition. MV1 had damage to the front driveside wheel fender and driver door. MV2 had slight damage to rear driver side bumper. MV3 did not have damage to his vehicle. Weather was icy and there was an active snow fall during the time of the accident, which was 1815hrs.
Keywords:
Citation, Crash, Ice, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3585592
Longitude:
-71.2273505
Location:
167 Cherry St, Newton, MA 02465, USA
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:
1900000087
Date:
2019-01-21
Time:
03:05
Address:
17 CHARLES RIVER TER
Speed limit:
25
Violation cited:
no
Narrative:
On 1/21/19 I was working N498 when I responded to 17 Charles River Ter for a report of a Cab that had struck a wall. Upon arrival I met with Pema Jigmey and Miriam Jost. Jost stated that Pema who was driving for Metro Cab (or Photo Cab) picked her up at the airport and brought her home. Once at her home 17 Charles River Ter, she asked him to back into the driveway due to the snow and ice conditions. While backing up in the driveway of 17 Charles River Ter the vehicle struck the residencet causing damage. Pema stated the same thing but believed Jost was half to blame due to the fact she asked him to be dropped in the driveway. I informed Pema that he drove the vehicle into the house and so was at fault. The house only appeared to suffer minor cosmetic damages but could not be accurately examined. Pema and Jost exchanged information in the hopes of settling the damages without insurance. Both parties were satisfied and provided a report number. Both parties stated they were uninjured and refused medical attention.
Keywords:
Ice, Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3040378
Longitude:
-71.2110958
Location:
17 Charles River Terrace, Newton, MA 02461, USA
Case number:
1900000175
Date:
2019-02-12
Time:
14:30
Address:
140 BRANDEIS RD
Speed limit:
30
Violation cited:
no
Narrative:
VEHICLE #1 WAS DRIVING DOWN BRANDEIS RD IN FRONT OF NEWTON SOUTH HIGH SCHOOL.IN A SNOW STORM. AS HE WAS TURNING THE CORNER IN FRONT OF THE TENNIS COURTS, HIS CAR SKIDDED ON THE UNTREATED AND UNPLOWED ROAD, INTO VEHICLE #2 WHO WAS HEADED IN THE OPPOSITE DIRECTION. NO INJURIES REPORTED. BOTH VEHICLES TOWED BY TODYS'S TOWING OF NEWTON.
Keywords:
School, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3135234
Longitude:
-71.1865424
Location:
140 Brandeis Rd, Newton, MA 02459, USA
Case number:
1900000177
Date:
2019-02-12
Time:
14:32
Address:
2345 COMMONWEALTH AVE
Speed limit:
35
Violation cited:
no
Narrative:
The operator of MV#1 stated that she had just made a U-Turn from the east bound side of Commonwealth Ave (#2345) to the west bound side when her MV started to slide in the fresh snow. MV then slid across Commonwealth Ave and hit the curb and then head on into a large tree. Operator arranged for their own tow.
Keywords:
Snow, Tree
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.346364
Longitude:
-71.2584662
Location:
2345 Commonwealth Avenue, Newton, MA 02466, USA
Case number:
1900000180
Date:
2019-02-12
Time:
21:32
Address:
85 CHARLESBANK RD
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 was travelling northbound on St James Street. As he approached the intersection of Charlesbank Rd, he began to brake to turn right. Due to the slippery snow and ice conditions, his brakes locked up and he skidded straight into the median in front of 85 Charlesbank Rd. The vehicle sustained major damage to the drivers side front axle, hood and under carriage. Operator of MV1 stated he was not injured and declined medical attention. He had called for a private tow. Tonys Towing responded to towed the vehicle.
Keywords:
Ice, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3588929
Longitude:
-71.1800115
Location:
85 Charlesbank Rd, Newton, MA 02458, USA
Case number:
1900000184
Date:
2019-02-12
Time:
14:45
Address:
659 CHESTNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
On 2/12/2018 at approx 1445hrs while assigned to 497 I responded to the area of 659 Chestnut St for a report of a two car crash . Upon arrival Ma Reg 9VA441 being operated by Steven HUTCHINSON and Ma Reg 98NL90 being operated by Vi DANG were pulled to the side of the road, there was a heavy snowfall and the road had accumulated a thick layer of snow and multiple crashes were occurring. NFD was on scene , DANG was crying and hysterical despite the minor nature of the crash and zero damage to either vehicle. HUTCHINSON stated they were creeping along NB on Chestnut St when DANG stopped, HUTCHINSON attempted to stop and his 4wd engaged and he slid slightly into the back of DANGS car, no marks or damage to either car. DANG elected to go to NWH with Cataldo . DANGs veh towed so as not to obstruct roadway.
Keywords:
Crash, Fire, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3272407
Longitude:
-71.2264688
Location:
659 Chestnut St, Waban, MA 02468, USA
Case number:
1900000189
Date:
2019-02-14
Time:
10:41
Address:
7 KENDALL ROAD
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV # 1 states that she took a right turn off of Parker Street on to Kendall Road when she lost control due to snow and ice on the right side of the road. The vehicle then veered off to the right over the curb and struck a United States Post Office Relay Mailbox knocking it completely over. The mailbox was located in front of 7 Kendall Road. No injuries reported by the operator and the vehicle sustained minor front end damage to the right side. I did observe an accumulation of snow and ice on the right side of Kendall Road that came out approximately one foot from the curb. Newton Center Post Office was notified regarding the mailbox. There was no mail in the box at the time.
Keywords:
Ice, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3168595
Longitude:
-71.1952349
Location:
7 Kendall Rd, Newton, MA 02459, USA
Case number:
1900000205
Date:
2019-02-21
Time:
09:53
Address:
IONIA ST
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday, February 21, 2019, while assigned to Traffic unit N526, I responded to the area of Ionia Street, Newton for a report of a motor vehicle accident involving a City of Newton owned vehicle. Ionia Street is a public way maintained by the City of Newton. The weather at the time of the accident was overcast. The road surface was icy and snow covered. The operator of MV1, Patrick Carresi (MA: S73958042), stated he was operating a City of Newton owned 2016 Ford F350 plow truck (MA MVN: M94756) turning left onto Ionia Street from Auburndale Av. Carresi stated as he took the turn, the rear passenger corner of the truck made contact with the drivers side front panel of MV2 which was parked on the side of the road facing southbound. I observed minor damage to the rear of MV1. MV2 received heavy front end damage with the entire front panel torn off. Carresi reported no injuries. Carresi works for the Utilities Department with the DPW. The operator of MV2, Donna Canavan (MA: S57637058), stated she was parked inside her 2005 Honda CRV (MA: 8ZEE40) facing southbound on Ionia Street. Canavan stated as the plow truck took the turn onto Ionia Street from Auburndale Av its rear corner of the truck struck the front panel of her parked vehicle ripping the panel off. I observed significant damage to the front panel area of MV2. Canavan reported no injuries and was able to drive her vehicle from the scene. Pictures were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Crash, Ice, Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.349507
Longitude:
-71.244875
Location:
Ionia St, Newton, MA 02466, USA
Case number:
1900000232
Date:
2019-03-04
Time:
08:32
Address:
25 CHESTNUT ST
Speed limit:
10
Violation cited:
no
Narrative:
MV1 was backing into a snow covered parking space at 25 Chestnut St. The lot had not been plowed yet. As he was backing, the rear of the truck fishtailed slightly and struck parked MV2(city MV). There was a scratch to the drivers side mirror of MV2. The rear drivers tail light and quarter panel were damaged on MV1. I took pictures as did oper MV1. I transferred my pictures to IT.
Keywords:
Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3488353
Longitude:
-71.2257494
Location:
25 Chestnut St, West Newton, MA 02465, USA
Case number:
1900001301
Date:
2019-12-17
Time:
14:47
Address:
717 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
On the above date and time I responded to 717 Centre St for a report of a crash involving two vehicles. The weather was snowy / rainy/ sleeting, and the roadway was a mixture of ice/ snow. Upon arrival on scene I spoke with the operator of V1 Ms. Howe, she stated she was traveling south on Centre St when V2 stopped abruptly. Ms. Howes stated she applied the brakes and her vehicle would nt stop due to the icy roadway and she had contact with V2. I then spoke with the operator of V2, Ms. Nunnally stated that a vehicle had abruptly pulled out of the driveway of 717 Centre St. She stated she applied her brakes immediately to avoid contact and pulled to the right. She stated when she stopped she felt rear impact from V2. Both parties had no injuries at this time. V2 was towed by Todys towing to 1354 Washington Street Newton. Ms. Howe removed valuables from the vehicle. At this time it appears the icy roadway was a contributing factor of the crash.
Keywords:
Crash, Ice, Rain, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.347321
Longitude:
-71.1892941
Location:
717 Centre St, Newton, MA 02458, USA
Case number:
2000000629
Date:
2020-11-01
Time:
17:35
Address:
15 ROGERS ST
Speed limit:
25
Violation cited:
no
Narrative:
On 10/30/2020 owners of vehicle one and vehicle two stated they parked their car on opposite side of their residence of 15 Rogers St. Both owners of the vehicle stated they went away for the weekend. On todays date 11/01/2020 both parties returned home to notice their vehicles to be damaged. Over the weekend there was snow that needed to be removed and due to my training experience and the bright yellow paint transfer and how high the damage was to both vehicles, it is believed to be a plow. Vehicle one had significant damage to the front passenger side wheel well and passenger door. Vehicle two had a long deep scratch from the passenger side front door to the rear door. Both vehicles showed bright yellow paint transfer onto the cars.
Keywords:
Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.349483
Longitude:
-71.1746739
Location:
15 Rogers St, Newton, MA 02458, USA
Case number:
2000000743
Date:
2020-12-16
Time:
23:47
Address:
80 CHARLESBANK RD
Speed limit:
30
Violation cited:
no
Narrative:
MV1 was travelling Eastbound on Charlesbank Rd when a vehicle approaching from the opposite direction had fish tailed around the bend of the road. MV1 turned their wheel to the right to avoid the on coming vehicle. Due to the slippery road surface from an on going snow storm MV1 slid into a concrete median divider causing damage to the driver side tire in front of 86 Charlesbank Rd. The vehicle was towed from the scene by Shlager Towing. The driver of the vehicle did not want to seek medical attention. There appeared to be no damage to the median. Due to the vehicle being owned by the City of Boston photographs of the vehicle and the scene were taken and sent to the IT Bureau to be attached to this crash report.
Keywords:
Crash, Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3585654
Longitude:
-71.1797224
Location:
80 Charlesbank Rd, Newton, MA 02458, USA
Case number:
2000000746
Date:
2020-12-17
Time:
12:34
Address:
56 RAMSDELL ST
Speed limit:
15
Violation cited:
no
Narrative:
On 12/17/20 I responded to #964 Boylston St- The B.P. Gas station for an accident that happened this morning at 02:35. The owner of the gas station Elias Ghazale showed me video that showed a white pick-up truck with a plow that pushed snow across Ramsdell St onto a customers car. When the truck pushed the first pass of snow, the security camera shows the entire vehicle move violently into the curb. It is unknown at this time if there is any damage to the customers vehicle. It is also unknown at this time who was operating the plow or the name of the company. Because of all the snow plowed up on the customers vehicle, the license plate and information on the vehicle is also unknown at this time. I traveled to Negoshians Towing and left a message asking the owner to call me at the station to follow up on this matter. On 12/18/20 I spoke with Elias Ghazale who gave me a Mass. Registration of 1WPG55 a 2009 Honda Odyssey grey van that is owned by a Sarkis E. Ghazale as the owner of the parked vehicle that was involved in this accident. I traveled to Ferguson Plumbing and spoke with the manager Eric Mackenzie who stated the landlord, Negoshians Towing deals with the snow removal for his property. I then traveled to Negoshians and spoke with the Owner Ted Negoshian. He stated his company is responsible for plowing the Ferguson lot. I showed him a security clip of the white truck plowing in the parked vehicle and Negoshian stated that he doesn't have any white trucks that plow for him only black ones. I then traveled to the City of Newton Highway Department and spoke with Superintendent Michael Arpino. I showed him the security video and he stated that the white truck in question was not a city owned or sub-contracted vehicle because the trucks would have a green flag on their mirrors or writing on the door. I also spoke with Newton Control Clerk Mark Parsons who viewed the City of newton GPS from the night of the storm and confirmed that no city vehicles or sub-contracted vehicles were on Ramsdell St between 2am and 3am. Unless new information on the identity of the white truck is learned, the vehicle in question (veh#2) will remain unknown. On 12/28/20 I spoke with Elias Ghazale's wife, Maria Vidalis wife who stated she was able to uncover the snowed in vehicle and found the following damage to Massachusetts Reg # 1WPG55: drivers door, front bumper, rear quarter panel scratches, drivers side fender and reports of leaking transmission fluid.. I then traveled to #964 Boylston St and viewed the vehicle myself and all confirmed the above damage except the transmission fluid.
Keywords:
Crash, Night, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3184836
Longitude:
-71.2108521
Location:
56 Ramsdell St, Newton, MA 02461, USA
Case number:
2100000003
Date:
2021-01-01
Time:
23:17
Address:
420 WALTHAM ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was driving southbound on Waltham St when he lost control of his vehicle due to the snow on the road. MV1 struck Verizon pole 43 outside of 420 Waltham St, no damage to the pole. The vehicle then bounced off the pole and back onto Waltham St. Vehicle sustained damage to the front bumper making it inoperable. Operator and passenger declined medical attention. MV1 was towed by Todys. Operator of MV1 took all valuables out of the car prior to his departure.
Keywords:
Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3526924
Longitude:
-71.2242876
Location:
420 Waltham St, West Newton, MA 02465, USA
Case number:
2100000054
Date:
2021-01-26
Time:
19:47
Address:
80 CHARLESBANK RD
Speed limit:
25
Violation cited:
no
Narrative:
On 1/26/2021, Newton Fire and Police were dispatched to Charlesbank Rd. and St. James St. for a single motor vehicle collision. Upon arrival, I observed Motor Vehicle #1 parked in the roadway with damage to its front end and under carriage. The operator stated; due to the snowy, wet, slippery conditions, her vehicle slid into the concrete median. The operator reported no injuries, however the vehicle was towed away from the scene by Tody's Towing Service.
Keywords:
Fire, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3585654
Longitude:
-71.1797224
Location:
80 Charlesbank Rd, Newton, MA 02458, USA
Case number:
2100000063
Date:
2021-01-28
Time:
12:23
Address:
34 HURLEY PL
Speed limit:
30
Violation cited:
no
Narrative:
VEHICLE OPERATOR WAS TRAVELING DOWN HURLEY PLACE, IT WAS SNOWING OUTSIDE AND THE ROAD WAS SLIPPERY. DRIVER STATES AS SHE WAS DRIVING DOWN THE HILL HER VEHICLE STARTED TO SKID AND SHE SKIDDED INTO UTILITY POLE # 20/4. THERE WERE NO INJURIES, THE VEHICLE WAS ABLE TO DRIVE AND THERE WAS NO DAMAGE TO THE UTILITY POLE.
Keywords:
Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3179704
Longitude:
-71.1896919
Location:
34 Hurley Pl, Newton, MA 02459, USA
Case number:
2100000070
Date:
2021-01-26
Time:
17:30
Address:
60 WEBSTER ST
Speed limit:
25
Violation cited:
no
Narrative:
On January 26, 2021 at approximately 1730 hours the weather condition at the time was snowy and the road conditions were slippery. Reporting party is the resident of 66 Webster St, and the property between 56 to 66 Webster St is maintained by the condo association. MV1 was operating on Webster St (a public way). MV1 struck two fences in front of 60 Webster St, causing an unknown amount of damage. The reporting party stated MV1 operator exited the vehicle and exchanged information. The reporting party wanted to notify Newton Police for insurance reasons.
Keywords:
Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3498973
Longitude:
-71.2289777
Location:
60 Webster St, Newton, MA 02465, USA
Case number:
2100000119
Date:
2021-02-15
Time:
20:14
Address:
41 ALGONQUIN RD
Speed limit:
25
Violation cited:
no
Narrative:
On 02/25/2021, while assigned to N494, I, Officer Conary responded to 41 Algonquin Road for a motor vehicle that struck a parked motor vehicle. The weather was cold outside and the ground in the area had iced over. I spoke with Operator of MV1 who stated he was driving Northbound on Algonquin Road when he lost control of his vehicle due to the ice on the road, and hit MV2 and then hit a snow bank. I asked he wanted medical attention and he declined. There was damage to MV2 left rear bumper and tire. MV1 had damage to the front bumper. MV2 remained parked on scene, and MV1 was able to be driven. Owner of MV2 and Operator of MV1 exchanged necessary paperwork. City was notified of the ice and also debris in the road.
Keywords:
Ice, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3406637
Longitude:
-71.1699163
Location:
41 Algonquin Rd, Chestnut Hill, MA 02467, USA
Case number:
2100000134
Date:
2021-02-19
Time:
17:42
Address:
35 LEXINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Oper v1 stated while traveling south on Lexington Street on a down hill slope her vehicle started to slide sideways due to black ice, and vehicle was uncontrollable and slide into Eversource pole # 254/ 5. Eversource was notified. Oper of v1 was evaluated by medics and signed patient refusal. Todys towing arrived on scene and towed vehicle to their tow lot. Weather was snowing roadway was snow/ice.
Keywords:
Ice, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3587904
Longitude:
-71.2396948
Location:
35 Lexington St, Newton, MA 02465, USA
Case number:
22000083
Date:
2022-01-29
Time:
02:32
Address:
55 BOYLSTON ST
Speed limit:
45
Violation cited:
no
Narrative:
On Saturday, January 29, 2022 at approximately 0232hrs, MV1 was traveling Westbound on Boylston St. when the vehicle slid and crashed into the left side guard rail in front of 55 Boylston St. Operator of MV1 stated that when she tapped on her brakes her vehicle lost traction and slid into the guard rail. I asked the operator if she was okay and would like to be evaluated by paramedics. Operator stated she was "okay" and refused medical attention. The vehicle at this time was located in the parking lot of 55 Boylston St., by the shake shack. The vehicle sustained heavy front end damage and was allowed to stay in the parking lot while waiting for the operators private tow (AAA). The guard rail that was struck did not sustain any damage from the crash. The operator was informed a report would be generated in regards to the incident. It should be noted that the incident occurred during a snow storm.
Keywords:
Crash, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3227831
Longitude:
-71.1687096
Location:
55 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
22000145
Date:
2022-02-13
Time:
18:32
Address:
49 BALDPATE HILL RD
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 stated they were coming down their very steep driveway at 40 Baldpate Hill Rd. when their vehicle slid across the street, and into the front exterior of 49 Baldpate Hill Rd. It should be noted it was snowing and there was snow on the driveway and roadway. There was front end damage to MV1 and damage to the exterior and garden of 49 Baldpate Hill Rd. Tody's responded to dislodge the vehicle from the home. MV1 was parked legally out front of 49 Baldpate Hill Rd. for the night. Both the operator and passenger of MV1 signed patient refusals. The homeowner of 49 Baldpate Hill Rd. was inside at the time of the crash but was unharmed. The homeowner took pictures of the damage, was made aware of the situation and advised to contact their insurance company regarding the damage to the home.
Keywords:
Crash, Night, Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3062052
Longitude:
-71.1776676
Location:
49 Baldpate Hill Rd, Newton, MA 02459, 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 560.689ms