home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

18 rows where dcc = "["Inattention"]", intersection = 0 and "retrieved" is on date 2022-07-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, time, speed_limit, hit_run, violation_cited, keywords, 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:
22000498
Date:
2022-06-07
Time:
16:53
Address:
0 WINDSOR RD
Speed limit:
20
Violation cited:
no
Narrative:
On 6/7/2022. I responded to Windsor Rd for a report of a 2 MV accident. Upon Arrival I spoke to the operator of MV1 who stated she clipped the front of MV2 which was parked. She stated that she tried parking in front of MV2 and turned to early which caused her to hit MV2. MV2 Had moderate damage to the front right bumper. The owner of MV2 was not in the vehicle but stated she heard the crash. Both parties denied medical attention and both were given the report numbers.
Keywords:
Crash, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.329621
Longitude:
-71.23079
Location:
Windsor Rd, Newton, MA 02468, USA
Case number:
22000546
Date:
2022-06-20
Time:
12:33
Address:
331 WALNUT ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 6-20-22 AT APPROX. 1233HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 331 WALNUT ST. I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES SOMETIME BETWEEN 1215HRS-1233HRS WHILE HIS VEHICLE WAS PARKED IN FRONT 0F331 WALNUT ST. SOMEONE HAD HIT HIS FRONT LEFT BUMPER OF HIS MOTOR VEHICLE CAUSING DAMAGE. THERE WERE NO WITNESSES IN THE AREA AND NO ONE HAD LEFT A NOTE. VEHICLE #1 HAD LEFT FRONT BUMPER DAMAGE. OWNER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3497031
Longitude:
-71.2071277
Location:
331 Walnut St, Newton, MA 02460, USA
Case number:
22000548
Date:
2022-06-20
Time:
15:05
Address:
300 NEEDHAM ST
Speed limit:
5
Violation cited:
no
Narrative:
Operator of MV1 was parking in a parking spot outside of Pressed Cafe located at 300 Needham St. Operator believed she was in Park but was actually in Drive. Operator mistakenly pressed on the gas and accelerated over the curb and through a large window and ended up inside of Pressed Cafe. Operator and her daughter, Brynn Bryant, were trapped in the vehicle and freed by NFD. Operator and Brynn were transported to Newton Wellesley Hospital. The other 2 passengers, Gabe Cohen and Marc Andrew, were not trapped and declined any medical attention and left the scene after speaking with the medics. MV1 was towed by Todys. Nobody inside Pressed Cafe was injured. John Faggiano was standing next to where the car went through the building but declined any medical attention. Pictures and a video of the accident from the security system was sent to IT to attach to the report.
Keywords:
Crash, Fire, Hospital, Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000554
Date:
2022-06-22
Time:
13:32
Address:
38 ELDREDGE ST
Speed limit:
25
Violation cited:
no
Narrative:
On 06/22/22 at 13:32 hours, I (Traffic Unit 523) was dispatched to 38 Eldredge Street for a two car motor vehicle crash involving a City of Newton Dept. of Public Works truck. Sgt. Mclean called in the crash to Dispatch after seeing it occur. Eldredge Street is a public way owned and maintained by the City of Newton. The weather conditions were clear and sunny and the road conditions were dry at the time of the crash. On arrival, I spoke to the operator of M/V # 1 identified as Elizabeth Langston (MA D/L # S89458234) who was operating a 2013 Nissan Rogue color black bearing MA reg. # 3BMK31. Ms. Langston states that she was parked across the street from 38 Eldredge Street. When she went to pull out in to the travel lane going southbound, she never saw another vehicle going by her and struck M/V # 2 on it's passenger side. She further stated that she believed it was a blind spot in her side view mirror. I observed damage to her driver's side door handle and driver's side bumper. As a result of the crash, the entire bumper was dislodged from the vehicle. Langston called for a private tow (Pro-Tech Waltham) to have her vehicle removed. Next, I spoke to the operator of M/V # 2 Richard Leone (MA D/L # S61672498) who works for the City of Newton Department of Public Works. At the time, he was operating a 2019 Ford 350 color white bearing MA Official reg.# M3106A. He stated that he was traveling straight ahead (SB) on Eldredge Street when M/V # 1 pulled out and struck him on the passenger side. I observed scrapes to the passenger side door that extend down to the wheel well of the cab to the truck. I also observed a dent on the truck between the passenger side door and bed of the truck. No injuries reported by either operator. Photos taken of the scene and submitted to the I.T. Bureau.
Keywords:
Crash, Pictures, Solar
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3543557
Longitude:
-71.1833381
Location:
38 Eldredge St, Newton, MA 02458, USA
Case number:
22000564
Date:
2022-06-25
Time:
15:08
Address:
804 BOYLSTON STREET
Speed limit:
25
Violation cited:
yes
Narrative:
On Saturday 06/25/22 at approximately 1508 hours while assigned to patrol sector n498 operating marked unit n503 I was dispatched to the area of Rt 9 Eastbound and Walnut Street (Both public ways in the City of Newton) for a report of a 2 car motor vehicle crash. Upon arrival I spoke with the operator,(BROWNE Sarah Ann) of MV#1(MA REG 514HH4) who states that she was stopped at the stop sign at the intersection of Rt 9 Eastbound. She was attempting to enter Rt 9 Eastbound waiting for traffic to clear when she was struck in the rear by motor vehicle#2. After speaking with BROWNE I spoke with the operator, (REED Ethyn) of MV#2, (NY REG JNZ6912) who states he was behind MV#1 also attempting to get on to Rt 9 Eastbound. He states he saw MV#1 pull forward and at that point he looked over his left shoulder to see if traffic was clear. He saw a clearing and began to accelerate forward not realizing that MV#1 had not yet entered traffic, striking MV#1 in the rear. While on scene REED gave me registration papers that were not matching his vehicle, therefore, I queried the license plate, REED's drivers license and VIN number. REED's license plate, (NY REG JNZ6912) came back to a 1999 Brown Toyota Camry, however this license plate was attached to a 2011 White Honda Civic belonging to Luis Rios. Subsequently I queried the Vin number on the vehicle (2HGFA1F88BH525771) Which came back to the vehicle on scene, a 2011 White Honda Civic owned by REED with a suspended registration due to invalid proof of insurance. Finally I queried REED's California Drivers License (Y2616596) which came back as EXPIRED with a status of "Withdrawn Pending PDPS Clearance". While I was conducting the investigation Tody's was en route to tow the vehicle. Due to the damage from the crash the vehicle was inoperable. I informed REED the vehicle was being towed due to the damage and for not having insurance. I explained to REED I would further investigate the status of his license and the vehicle and Mail him the citation once my investigation was complete. At this time I am issuing Massachusetts Uniform Citations T3044941 and T3044942 for the following offenses: C90 S23 Attaching Registration Plates C90 S34J Operating a MV without Insurance C90 S9 Operating Unregistered MV C90 S10 Operating without a License I also confiscated the New York Registration plate, JNZ6912, and placed it into property and evidence locker #1. Vehicle was towed by Tody's Towing. Also see CC# 22022600
Keywords:
Citation, Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000568
Date:
2022-06-25
Time:
20:57
Address:
78 LEXINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was traveling southbound on Lexington Street. Operator of MV1 said she looked down to grab her phone and struck MV2. MV2 was unoccupied and parked legally in front of 78 Lexington Street. Operator of MV1 sustained a minor cut on the top of her head and was transported to Newton Wellesley Hospital by Fallon Medics. MV1 had damage to the front right bumper and was towed by Tody's. MV2 had damage done to the left rear bumper and was able to drive away from the scene.
Keywords:
Hospital, Phone
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3573578
Longitude:
-71.2395881
Location:
78 Lexington St, Auburndale, MA 02466, USA
Case number:
22000578
Date:
2022-06-27
Time:
21:32
Address:
185 PARMENTER RD
Speed limit:
25
Violation cited:
no
Narrative:
MV 1 was traveling straight Southbound on Parameter Rd. MV 1 struck MV 2 in its rear and rear left at 185 Parameter RD. MV 1 sustained major damage to it front right and right side. MV 1 also had front and side air bag deployment. MV 1 was towed by Tody's towing. The operator of MV 1 had no injuries and signed a refusal with Fallon medics. The operator of MV 1, Mr. David Brand, stated he was changing the radio station and not paying attention to the road when he crashed into MV 2. MV 2 was legally parked on the side of Parameter Rd at 185 Parameter Rd. MV 2 was unoccupied while legally parked. MV 1 struck MV 2 in its rear and left rear. MV 2 sustained major damage to the front left or left side and left rear. MV 2 was towed due to it being disabled.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3600061
Longitude:
-71.2320609
Location:
185 Parmenter Rd, West Newton, MA 02465, USA
Case number:
22000598
Date:
2022-07-04
Time:
18:00
Address:
367 ALBEMARLE RD
Speed limit:
25
Violation cited:
no
Narrative:
Operator of vehicle one stated that while passing parked vehicle two the right side of the his vehicle scraped up against vehicle two's front driver's side bumper. Vehicle two was a City of Newton DPW truck that was parked in front of 367 Albemarle Rd waiting to block off the street for the Fourth of July fireworks at Albemarle field. Vehicle one's operator stated that he could not pull to the side of the road after the crash because of heavy traffic due to the Fourth of July activities in the area. He did stop at his residence approximately two blocks from the crash area. Vehicle one had damage to the passenger side front and rear as well as the rear bumper. None of the occupants of vehicle one stated that they were injured. The owner of vehicle one had concerns about the amount of room that the DPW tuck took up on the roadway. It should be noted that a City of Newton DPW worker measured out the length of the roadway from the truck's front bumper to the grass line and it was 11 1/2 feet. According to the General Motors web site the width of vehicle one is 6 feet 7 inches. Operator of vehicle two stated that he was sitting in the driver side of the truck when vehicle one passenger side scraped up against it, and that he was not injured. Vehicle two front bumper had damage to it. It took photos of both vehicles and forward the disk to the NPD's IT Bureau for downloading. I issued operator of vehicle one MA Uniform Citation T 3045462 and cited him for a violation of City of Newton Ordnance 19/75 failure to use care while passing. Albemarle Rd is a public way in the City of Newton.
Keywords:
Citation, Crash, Fire, Pictures
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3542638
Longitude:
-71.2142632
Location:
367 Albemarle Rd, Newton, MA 02460, USA
Case number:
22000604
Date:
2022-06-09
Time:
14:05
Address:
808 BEACON ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 07/07/22 at 11:44 hours, I (Traffic Unit # 523) responded to 68 Wyman Street Apt. # 5 for a past motor vehicle crash involving a pedestrian that occurred on 06/09/22 at 808 Beacon Street. This area of Beacon Street is a public way maintained and owned by the City of Newton. The weather at the time was 81 degrees and partly cloudy (wunderground.com). The road conditions at the time were dry. On arrival, I spoke to the pedestrian involved in the crash identified as Thomas Jones. He stated the crash took place on 06/09/22 approximately between the hours of 14:05 and 14:10. He further stated that this occurred at 808 Beacon Street while he was crossing Beacon Street near the Bank of America. He says that he pushed the button to activate the crosswalk yellow flashing signal lights. It should be noted that I am familiar with this location and it does have a marked crosswalk on both sides of 808 Beacon Street with yellow flashing signals that can be activated. Once activated, he says a vehicle traveling eastbound on Beacon Street stopped for him. He then entered the crosswalk from the eastbound side of Beacon Street going across the street with his walking cane. He kept walking in to the westbound travel lane of Beacon Street when he was suddenly struck by a motor vehicle. Thomas could not provide what type or color of the vehicle. As a result, Thomas fell forward and was knocked down to the ground on both hands and knees. He also says that his right cheek and eyeglasses struck the pavement which damaged the lens to his glasses. He sustained a bruised (black and blue) right eye. He says approximately seven days later he started having neck pain to which he has been receiving medical attention for. He also states an upper right side tooth implant fell out of his mouth. After the crash, he states he was helped up by two unknown bystanders. An elderly white female who was operating the vehicle that struck him approached him. Thomas says that the female told him that she did not see him crossing the street as she was looking down and not up at the time. She provided him with her name of Jill Levin and her telephone number before leaving. Thomas states he was wearing gray colored khaki pants, sneakers, and a light blue t-shirt at the time of the crash. Next, I attempted to call the number for Jill Levin and left her a message to call me back. At approximately 14:45 hours on this date, Ms. Levin came in to NPD Headquarters and spoke to me. I asked her if she was involved in a accident during the month of June. She stated that there was an incident on a Thursday approximately three weeks ago in June of 2022 at approximately 14:30 hours. She says she was driving her 2013 Lexus 450RX color gray bearing MA reg. # 6RK464 westbound on Beacon Street near address number 808. She saw an older male crossing in the crosswalk and she says that she stopped for him. The male then suddenly fell down in front of her car. She states that she never struck him with her vehicle. She then got of her vehicle and asked him if he needed any assistance to which he replied that he was fine and did not need anything. He provided his name to her. She then provided her name and phone number on a piece of paper. I asked Ms. Levin why she would provide her information to Mr. Jones if no accident occurred. She replied that it was the right thing to do as far as checking on him and seeing if he needed any assistance. I then inquired why Mr. Jones would alledge that she stated to him on scene that you did not see him crossing the street. Also, that you were looking down and not up. Ms. Levin denied ever stating this to Jones. I then went outside and looked at her Lexus 450RX to check for any damage to the front end of the vehicle. I observed two small scratches to the passenger side front bumper which appear unrelated. The marks were indicative of white paint transfer from having contact with another vehicle. Ms. Levin did not know where the marks came from. I advised her that I would investigate this further and check to see if there is surveillance footage from the Bank of America or other source. After, I attempted to call Bank of America and could not reach anyone there. I will check the area and go to the bank on 07/08/22 during my next shift. On 07/08/22 at approximately 09:10 hours, I went up to 808 Beacon Street and observed no other surveillance cameras in the area. I went in to the Bank of America and spoke to the branch manager. He showed me the multiple camera angles they have, but none show out in to Beacon Street. As a result of this investigation and the statements made by both parties, I believe that Mr. Jones was struck by Ms. Levin's vehicle. The fact that Ms. Levin got out of her vehicle to check on Jones and provide her information to him even though she claims no accident took place is highly unlikely. Therefore, I am issuing Ms. Levin MA Uniform Citation # 507419AB for Chapter 89/11 Crosswalk Violation. The citation was mailed out on 07/08/22. I spoke to Ms. Levin on the phone explaining a citation was issued and mailed to her.
Keywords:
Citation, Crash, Crosswalk, Ped, Phone, Walk
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.330038
Longitude:
-71.1938425
Location:
808 Beacon St, Newton, MA 02459, USA
Case number:
22000605
Date:
2022-07-07
Time:
13:48
Address:
1000 COMMONWEALTH AVE
Speed limit:
15
Violation cited:
no
Narrative:
The operator of MV#1 stated he was travelling southbound at the entrance of 1000 Commonwealth Ave when MV#2 pulled out of her parking spot and struck him. MV#1 sustained moderate damages to its passenger side front and rear door area. There were no reported injuries to the operator of MV#1 or its passengers. The operator of MV#2 stated she was attempting to pull out of her parking spot and did not see MV#1 when she struck it. MV#2 sustained moderate damage to its driver's side front bumper. There were no reported injuries to the operator of MV#2.
Keywords:
Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3374309
Longitude:
-71.2088565
Location:
1000 Commonwealth Ave, Newton, MA 02459, USA
Case number:
22000612
Date:
2022-07-08
Time:
18:53
Address:
19 COMMONWEALTH AVE
Speed limit:
20
Violation cited:
yes
Narrative:
The operator of MV1 stated he was traveling eastbound on Commonwealth Ave. while attempting to pull off to the road due to a flat tire on the drivers rear side, he struck the door of MV2 when the operator opened the door. The operator of MV2 stated he was parked, went to exit his vehicle and after opening the door MV1 struck the drivers side door to his vehicle. The damage that MV1 had was minor damage to the passenger side mirror. The damage MV2 had significant damage to the drivers door, causing it to not close. All parties stated they were not injured. MV1 was towed by Tody's due to a suspended registration.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3400456
Longitude:
-71.1674332
Location:
19 Commonwealth Ave, Chestnut Hill, MA 02467, USA
Case number:
22000621
Date:
2022-07-12
Time:
09:43
Address:
1255 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
Mv#2 was parked on side of street in the area of 1255 Centre St S/B. #2 turned left to pull out of the space attempting a U-turn. Mv#1 was travelling straight ahead in the left lane on Centre St S/B. At this time, #2 driver's side front end struck Mv#1 passenger side. #1 and #2 sustained moderate damage to those areas. No injuries.
Keywords:
Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3304655
Longitude:
-71.1950492
Location:
1255 Centre St, Newton Centre, MA 02459, USA
Case number:
22000622
Date:
2022-07-12
Time:
12:17
Address:
720 DEDHAM ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV#1 stated she was travelling northbound on Dedham St in the right side travel lane when she was struck by MV#2 merging from the left travel lane. MV#1 sustained heavy damages to its rear driver's side area. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated he was travelling northbound on Dedham St in the left side travel lane attempting to merge onto the right side travel lane when he struck MV#1. The operator of MV#2 stated MV#1 was in his blind spot and he did not see it (MV#2 is a large commercial dump truck). MV#2 sustained minor non-visible damages to its passenger side front area. There were no reported injuries to the operator of MV#2.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000630
Date:
2022-07-14
Time:
01:31
Address:
601 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV1 stated she was traveling west bound on Washington Street. As she was approaching Crafts Street, she struck MV2 that was parked on the side of the road on in front of 601 Washington Street. The operator stated she was not injured. MV1 had damage to the front passenger side and MV2 had damage to the rear driver side.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3544272
Longitude:
-71.1981843
Location:
601 Washington St, Newton, MA 02458, USA
Case number:
22000631
Date:
2022-07-14
Time:
13:48
Address:
899 WASHINGTON ST
Speed limit:
10
Violation cited:
no
Narrative:
ON 7-14-22 AT APPROX. 1348HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 899 WASHINGTON ST ( V-NAILS SPA PARKING LOT ) I SPOKE TO THE DRIVER OF VEHICLE #1. DRIVER STATES SHE WAS PARKED IN A STALL IN THE LOT CHECKING DIRECTIONS TO SEE WHERE SHE WAS GOING WHEN SHE WAS HIT BY VEHICLE #2. VEHICLE #2 DRIVER STATES SHE WAS TRYING TO PULL INTO THE LOT NEXT TO VEHICLE #1. SHE STATES SHE CUT IT TOO CLOSE AND HIT VEHICLE #1 WITH HER VEHICLE. VEHICLE #1 HAD LEFT REAR SCRAPES. VEHICLE #2 HAD FRONT RIGHT SCRAPES. BOTH PARTIES REPORTED NO INJURIES. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000643
Date:
2022-07-18
Time:
12:15
Address:
401 WATERTOWN ST
Speed limit:
5
Violation cited:
no
Narrative:
On 7/14/22 at approximately 13:30 oper #1 parked his vehicle in a parking spot at 401 Watertown Street. MV #2 did not see him park and backed into him as he was trying to leave the parking lot. Minor damage on both vehicles.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000651
Date:
2022-07-19
Time:
13:40
Address:
2014 WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
Operator of Motor Vehicle # 1 stated they were traveling Eastbound on Washington Street and used their right turn signal and started slowing down to take a right turn into the main entrance of Newton Wellesley Hospital and was struck from behind by Motor Vehicle # 2 causing moderate rear end damage. Operator of Motor Vehicle #2 stated that he was traveling Eastbound on Washington Street and moved into the right lane in an attempt to get out of the ambulances way which had its lights and sirens activated. Operator of Motor Vehicle #2 stated that Motor Vehicle #1 stopped short and he did not have enough time to break and struck the vehicle from behind. Motor Vehicle # 2 sustained no damage. All parties signed medical refusal forms.
Keywords:
Ems, Hospital, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000657
Date:
2022-07-20
Time:
12:23
Address:
16 HARTFORD ST
Speed limit:
10
Violation cited:
no
Narrative:
The owner of MV#1 stated she parked her vehicle in the municipal parking lot located at 16 Hartford St. When she returned to her vehicle she observed MV#2 (Parked behind her vehicle) touching her rear bumper. The owner of MV#1 stated she had parked her vehicle approximately 1.5 hours ago and MV#2 was not parked behind her previously. The owner of MV#1 showed me her parking receipt (Parking space #5548) and it displayed a time stamp of 11:19 AM. The owner of MV#2 arrived shortly after and stated to me, "don't give me a ticket. I'm leaving". I stated to the owner of MV#2 that I responded for a vehicle accident and not for a parking violation. I showed the owner of MV#2 that the front of her vehicle was touching the rear of MV#1 and she stated that MV#1 hit her vehicle instead of the other way around. The owner of MV#2 stated she had parked her vehicle (Parking space #5549 ) approximately 40 minutes prior to my arrival but did not have a parking receipt because she never paid for parking. The owner of MV#2 stated she may not have been aware she made contact with MV#1 when she parked her vehicle. Both involved vehicles were unoccupied during this accident. both vehicle owners exchanged information and were advised to notify their insurance providers. There were minor/ non visible damages to the rear end area of MV#1 and minor/ non visible damages to the front end of MV#2.
Keywords:
Citation, Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3210731
Longitude:
-71.2076694
Location:
16 Hartford St, Newton, MA 02461, 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 491.157ms