home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

21 rows where dcc contains "Too fast for conditions" and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, address, street1, street2, intersection, speed_limit, violation_cited, keywords, dcc, dcc_code, geocoded_address, latitude, longitude, 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:
1900000072
Date:
2019-01-19
Time:
19:13
Address:
173 GRANT AVE
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle #1 stated she was traveling south bound on Grant Ave. Vehicle #1 stated that in the area where Grant Ave. bends to the left the roadway is dark and she had trouble seeing the road. Vehicle #1 stated at the last second she saw the road bending left and attempted to turn but skid on the snow and struck a small boulder in the front lawn of 173 Grant Ave. moving the rock a few feet. Vehicle #1 then skidded and came to a stop in the middle of the lawn of 173 Grant Ave. Vehicle # 1 then pulled off the lawn and to the side of the road. The owner of the property of 173 Grant Ave. was also present and was notified of the accident. Vehicle #1 had moderate damage to the front of the vehicle but was still able to be driven and was driven home. Both the operator and passenger in Vehicle #1 stated they were uninjured in the accident and refused any medical treatment.
Keywords:
Crash, Moderate, Snow
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3340429
Longitude:
-71.1883194
Location:
173 Grant Ave, Newton, MA 02459, USA
Case number:
1900000120
Date:
2019-01-30
Time:
08:50
Address:
CHRISTINA ST & GODDARD ST
Speed limit:
30
Violation cited:
no
Narrative:
MV1 was slowing as she approached the stop sign at Christina St. She began sliding due to the icy roads. MV2 began sliding down the road and rear ended MV1. Goddard St was very icy at the time of the MVA.
Keywords:
Ice
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3047144
Longitude:
-71.2093949
Location:
Christina St & Goddard St, Newton, MA 02461, USA
Case number:
1900000130
Date:
2019-02-01
Time:
15:35
Address:
15 CYPRESS ST
Speed limit:
25
Violation cited:
no
Narrative:
On 2/1/19 I was working N496 when I responded to a 2 car MVA at 15 Cypress St. with a road rage incident ( incident # 19004330). Upon arrival I spoke with Edward Macaleese. Macaleese stated MA reg 2EE232 (being operated by Fabian Castillo) was tailgating him while traveling southbound on Cypress St. so he pulled to the side to allow him to pass. After Castillo passed Macaleese he slammed on his brakes causing Macaleese to rear end Castillo. I spoke with Castillo who stated that he was traveling southbound on Cypress St. when the vehicle in front of him (Macaleese) began driving "much slower than the speed limit". Castillo stated the Macaleese pulled over to allow him to pass, after Castillo began to slow in traffic due to a vehicle pulling out. Macaleese struck Castillo from behind. Both parties stated they were not injured. Both vehicle were still drive able. Both parties were provided an accident report number.
Keywords:
Crash, Speed
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3285638
Longitude:
-71.1951188
Location:
15 Cypress St, Newton, MA 02459, USA
Case number:
1900000132
Date:
2019-02-01
Time:
17:01
Address:
MASSACHUSETTS TPK WEST & WASHINGTON ST
Speed limit:
35
Violation cited:
yes
Narrative:
MV1 stated he was "driving to fast around the corner and hit the pole." MV1 actually hit a curb, took down a street light, went up on the island hitting another street light prior to hitting the curb. The second light he struck fell on MV2. MV1 sustained heavy front end damage and was removed from the scene by Tody's Towing. MV2 stated that MV1 "came flying across the intersection, crashed into 2 poles, one of which hit my car and he crashed over there." I then observed minor damage to MV2, however it did not require a tow. Both parties signed patient refusals with Cataldo Ambulance. Operator of MV1 was arrested and charged with the following: M.G.L. 90/24/J OUI Liquor M.G.L. 90//24/E Negligent Operation M.G.L. 89/4A Marked Lanes Photos of the scene were captured and turned over to the IT Bureau. Daigle Electric notified of the damaged lights.
Keywords:
Crash, Ems, Pictures
Dcc:
Too fast for conditions, Other improper action
Report url:
report
Image url:
image
Latitude:
42.3364517
Longitude:
-71.0770265
Location:
Washington St & Massachusetts Ave, Boston, MA 02118, USA
Case number:
1900000182
Date:
2019-02-12
Time:
14:50
Address:
BOYLSTON ST & CHESTNUT ST
Speed limit:
15
Violation cited:
yes
Narrative:
MV1 was coming down the Rte 9 West off ramp to Chestnut St. Operator was traveling too fast for the snowy road conditions and failed to stop for the stop sign at the bottom of the ramp. A snow storm had started 2 hours prior to the accident and road conditions were slippery. MV1 struck MV2 broadside who was traveling north on Chestnut St with the right of way. MV1 struck MV2 hard enough that MV2 was pushed across the lane and into MV3 that was stopped at the stop sign southbound. According to the operator of MV2, MV1 was traveling "way too fast for conditions" over 30mph. Operator MV1 was cited for 89/9 failed to stop for stop sign and 90/17 speeding too fast for road conditions. Operator was also cited on Citation T1272992 for 90/23 operating after suspended license. Boylston St and Chestnut St are public ways in the city of Newton.
Keywords:
Citation, Crash, Snow, Speed
Dcc:
Signs/Signals, Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Chestnut St & Boylston St, Newton, MA 02464, USA
Case number:
1900000202
Date:
2019-02-21
Time:
06:53
Address:
240 NAHANTON ST
Speed limit:
30
Violation cited:
no
Narrative:
On Thursday 2/21/19 at approximately 0653 while assigned to marked unit N499 I was travelling westbound on Nahanton Street when I observed a motor vehicle pulled over to the right side of the road with its emergency flashers on. I pulled behind the vehicle and spoke with the operator, FINCH Robert L, who states that he was travelling Westbound on Nahanton Street and due to the weather conditions he lost control of his vehicle and slid into utility pole #14. There was very minimal damage done to the utility pole, however FINCH's car was disabled due to the collision. The weather conditions were poor as it was raining and there were several inches of snow on the ground from a storm that morning causing the roads to be slushy and slippery. FINCH was uninjured and stated that he had AAA on the way to tow his motor vehicle.
Keywords:
Rain, Snow
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.297167
Longitude:
-71.1986149
Location:
240 Nahanton St, Newton, MA 02459, USA
Case number:
1900000203
Date:
2019-02-21
Time:
08:35
Address:
BEACON ST & HAMMOND ST
Speed limit:
25
Violation cited:
no
Narrative:
Oper of Veh # 1 stated he was going WB on Beacon Street and wasn't able to stop at red light due to the icy roads. He struck Veh # 2 in the middle of the intersection. Oper of Veh 2 stated she had a green light when she was going through intersection and saw veh # 1 go through intersection and hit her. Veh # 1 had a plow equipped was unable to put that in diagram. No Injuries, No Tows
Keywords:
Ice
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3328654
Longitude:
-71.1727828
Location:
Beacon St & Hammond St, Newton, MA 02467, USA
Case number:
1900000218
Date:
2019-02-27
Time:
06:33
Address:
1091 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
On February 27, 2019 at approximately 06:33 hours I responded to the area of 1091 Centre St for a motor vehicle crash with minor injuries. Upon arrival, fire and medics were evaluating all parties involved. The operator of MV2 complained of neck and back pain but refused medical transport but will be seeking care if pain continues. All motor vehicles were traveling Northbound on Centre St. slowing in traffic. MV1 crashed into the rear MV2, which in turn made MV2 crash into rear of MV3. MV1 admitted fault, claiming that she hit the gas pedal instead of the brake. MV2 was towed by the scene by Tody's.
Keywords:
Crash, Fire
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3349344
Longitude:
-71.1937961
Location:
1091 Centre St, Newton, MA 02459, USA
Case number:
1900000230
Date:
2019-03-04
Time:
06:58
Address:
428 HAMMOND ST
Speed limit:
30
Violation cited:
no
Narrative:
On 3/4/19 I responded to the area of Hammond St and Chestnut Hill Rd for a report of a two car MVA. Upon arrival it was determined there were no injuries and the two drivers signed patient refusals with the ambulance. I first spoke with the operator of MV#1 who stated he was driving northbound on Hammond St near the Chestnut Hill T station where it bends and MV#2 was coming southbound and skidded on the snow and came into his lane. I then spoke with the operator of MV#2 who stated he was driving southbound on Hammond St when his vehicle lost control around the turn and drifted into the opposite lane and struck MV#1. I issued the operator of MV#2 MA Citation T1268628 for Chapter 89/4A; Marked Lanes Violation. At the time of this accident there were heavy snow conditions. Tody's Towing responded and towed both vehicles from the scene.
Keywords:
Citation, Crash, Ems, Snow
Dcc:
Too fast for conditions, Lane departure
Report url:
report
Image url:
image
Latitude:
42.3284846
Longitude:
-71.1650892
Location:
428 Hammond St, Chestnut Hill, MA 02467, USA
Case number:
1900000259
Date:
2019-03-10
Time:
09:29
Address:
370 WOLCOTT ST
Speed limit:
25
Violation cited:
no
Narrative:
Motor vehicle 1 was traveling eastbound on Wolcott St when she lost control of the vehicle and exited the roadway. The vehicle went across the front lawn of #370 Wolcott causing damage to the property including several trees/bushes. The roadway was covered in snow due to recent snowfall at the time of the accident. The operator of the vehicle reported no injuries and the property owner was notified of the incident. Motor vehicle 1 was towed from the scene by Todys.
Keywords:
Crash, Snow, Tree
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3483447
Longitude:
-71.2429433
Location:
370 Wolcott St, Auburndale, MA 02466, USA
Case number:
1900000291
Date:
2019-03-16
Time:
14:49
Address:
CHERRY ST & WEBSTER ST
Speed limit:
25
Violation cited:
no
Narrative:
On the above date/time I responded to the area of Cherry Street and Webster Street for a three motor vehicle crash with injuries. Upon arrival along with Sgt. Dempsey, Fire/medics. I spoke with the operator of vehicle one. He stated he was stopped on Webster Street facing westbound a the red traffic signal. He further stated the traffic signal on Webster Street turned green, he accelerated forward. He stated vehicle two traveled north on Cherry Street at a high rate of speed through the red traffic signal. He stated he had no reaction time due to the speed of vehicle two and had impact. I spoke to the operator of vehicle two. He stated he was traveling north on Cherry Street going too fast, he stated he thought it was a school zone so he slowed down and he did not observe the color of the traffic signal. He stated he observed vehicle one come out of the Webster Street at the last second at impact. I spoke with the operator of vehicle three. She stated only remembered being stopped on Cherry Street facing south. She stated she did not remember what color the traffic signal was, just knew she was stopped when she felt heavy impact from vehicle two. Injuries: Oper of V1 none at this time- patient refusal Oper of V2 none at this time - patient refusal Oper of V3 Head laceration and head trauma, transported to Newton- Wellesley Hospital Tody's towing arrived on scene and towed vehicles two, three to their tow lot. All proper paper work was done for a towed vehicle(s). All parties advised of the process. After the vehicles were towed, and the scene was cleared I watched the cycling of the traffic signals in the intersection and observed they were functioning properly. It appears a this time based on statements and physical characteristics of the impact area on the roadway, that vehicle two went through the red light on Cherry Street, which caused the crash.
Keywords:
Crash, Fire, Hospital, School, Speed
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.350159
Longitude:
-71.228704
Location:
Cherry St & Webster St, Newton, MA 02465, USA
Case number:
1900000397
Date:
2019-04-20
Time:
10:36
Address:
285 CRAFTS STREET
Speed limit:
30
Violation cited:
no
Narrative:
Mrs. Weiss stated that she was attempting to back out of her driveway at 285 Crafts Street when her vehicle accelerated for no reason "like a bat out of hell." The vehicle then crossed Crafts street at a high rate of speed, jumped the curb, crossed the large grass island, and only stopped when the vehicle crashed into a tree. Mrs. Weiss was uninjured and signed a patient refusal. The vehicle sustained moderate damage to the tires, undercarriage, and rear bumper and was towed from the scene by Todys. Photos were taken of the damaged city tree and were placed in the IT bureaus mailbox to be attached to this report. Based on the facts that Mrs. Weiss could not explain the reason for the cars acceleration, the distance the vehicle traveled without stopping, and the close proximity of the crash to an elementary and middle school I filed a request for Immediate Threat License Suspension/Revocation. All proper paperwork as well as a copy of this report were faxed to the Registry of Motor Vehicles.
Keywords:
Crash, Moderate, Pictures, School, Speed, Tree
Dcc:
Speeding, Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.358733
Longitude:
-71.2108289
Location:
285 Crafts St, Newton, MA 02460, USA
Case number:
1900000524
Date:
2019-05-22
Time:
19:07
Address:
DEDHAM ST & OAK HILL ST
Speed limit:
25
Violation cited:
no
Narrative:
On Wednesday 5/22/19 at approximately 1907 hours I was dispatched to the area of Oak Hill Street and Dedham Street for a report of a minor motor vehicle crash with no injuries. Upon arrival I spoke with the operator, LOZANO Jose, of MV1 (Ma Reg 8DC139) who states that he was stopped at the stop sign at the end of Oak Hill Street waiting for traffic to clear to take a left on Dedham Street when he was struck in the rear by motor vehicle #2. Operator, ROBISON James, of MV2 (Ma Reg 625XT2) states that he was traveling down Oak Hill Street toward Dedham Street coming down the hill. As he started stepping on his brakes he stated that the ABS began pushing back and he was unable to stop causing him to crash into the rear of motor vehicle 1. There were no injuries to any of the parties and motor vehicle 1 sustaind damage to the rear bumper. Motor vehicle 2 only sustained damage to its front license plate.
Keywords:
Crash
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.296388
Longitude:
-71.1810296
Location:
Oak Hill St & Dedham St, Newton, MA 02459, USA
Case number:
1900000622
Date:
2019-06-16
Time:
14:40
Address:
CENTRE ST & HYDE AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator # 1 stated that he was coming to a stop in traffic while driving SB on Centre Street at Hyde Street when he was rear ended by vehicle #2. Operator #2 stated that he was driving SB on Centre Street, he saw the vehicle in front of him stopping. He attempted to stop but wasn't able too stop in time. He stated his car wouldn't stop due to the wet road. NFD was able to separate the two vehicle which were stuck by the tow hitch. Medics got 3 refusals. Vehicle #2 was towed.
Keywords:
Fire
Dcc:
Followed too closely, Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3497298
Longitude:
-71.1869015
Location:
Hyde Ave & Centre St, Newton, MA 02458, USA
Case number:
1900000676
Date:
2019-06-30
Time:
20:25
Address:
549 CRAFTS ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of vehicle one stated that he lost control of his motorcycle near 549 Crafts St due to wet road surface conditions. Operator of vehicle one stated that his motorcycle hit the cub causing him to be thrown from his bike. Operator of vehicle one was transported via EMS to the Beth Israel Hospital in Boston for treatment for a broken leg. Vehicle one was towed by Tody's towing and I filled out a motor vehicle form. Photos of the crash scene and motorcycle were taken and the disk was download by the NPD's It Bureau.
Keywords:
Crash, Ems, Hospital, Pictures
Dcc:
Too fast for conditions, Swerving
Report url:
report
Image url:
image
Latitude:
42.3605648
Longitude:
-71.2225241
Location:
549 Crafts St, Newton, MA 02465, USA
Case number:
2000000043
Date:
2020-01-11
Time:
22:28
Address:
MEREDITH AVE & ROUTE 9
Speed limit:
45
Violation cited:
yes
Narrative:
Operator of MV1 was traveling Westbound on Rt. 9 at a high rate of speed and veered off the road colliding with a street sign then landing in the backyard of 4 Meredith Ave damaging a fence. It should be noted MV1 failed to stop for police previously in a motor vehicle pursuit. MV1 sustained heavy front end damage. Operator sustained minor injuries and was transported to Newton Wellesley Hospital on a section 12. The vehicle was then towed by Tody's. A motor vehicle inventory form was filled out in regards. A message was left for the city to repair the street sign. Pictures were taken and placed into property and evidence. It should be noted a fence had to be removed at 4 Meredith Ave in order to removed the vehicle. I was able to get permission by the owner of the home to remove the fence.
Keywords:
Hospital, Pictures, Speed
Dcc:
Too fast for conditions, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3182355
Longitude:
-71.2170802
Location:
MA-9 & Meredith Ave, Newton, MA 02461, USA
Case number:
2000000068
Date:
2020-01-18
Time:
19:39
Address:
BOYLSTON ST & CHESTNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
Based on observations, and statements made, the following occurred. M/V#1 was traveling east on the Rte 9 off ramp, and came to a stop, at the intersection of Chestnut St. He stated that north bound traffic, on Chestnut St. had stopped to allow him to enter the intersection, and as he did, he was struck by M/V#2. The operator of M/V#2 stated that she was traveling north on Chestnut St., and as she came over the hill, she attempted to stop, but her car began to slide. She stated that to avoid hitting the stopped traffic in front of her, she pulled into the left lane, and her M/V continued to slide downhill, past the stop sign, and into the intersection, where she collided with M/V#1. The passenger of M/V#2 corroborated operator #2's statements.
Keywords:
[]
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Chestnut St & Boylston St, Newton, MA 02464, USA
Case number:
2000000077
Date:
2020-01-18
Time:
22:25
Address:
BEACON ST & HAMMOND ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle #1 stated they were stopped at the traffic lights on beacon st facing westbound when they were struck in the rear by Vehicle #2. Vehicle #2 stated they were traveling westbound on beacon st and attempted to stop for the red light. Vehicle #2 stated they started to slide due to the snow and was unable to stop and struck Vehicle #1 in the rear. Vehicle #1 had major damage to the rear and was unable to be driven. Vehicle #2 had major damage to the front and was unable to be driven. Both vehicle were towed away by tody's towing. Both operators and passenger were asked if they were injured and all parties stated they were not injured and refused any medical treatment.
Keywords:
Snow
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3328654
Longitude:
-71.1727828
Location:
Beacon St & Hammond St, Newton, MA 02467, USA
Case number:
2000000151
Date:
2020-02-13
Time:
17:56
Address:
199 BOYLSTON ST
Speed limit:
5
Violation cited:
no
Narrative:
The operator of MV#1 stated she was driving around MV#2 as it was parked outside the establishment. As MV#1 passed, the driver side door of MV#2 opened creating a collision. MV#1 sustained significant damage to its front end as well as passenger side door. MV#2's driver side door sustained significant damage. No injuries were reported and MV#1 was able to be driven away from the scene, while MV#2 arranged for a private tow. A witness to the collision reports MV#1 was driving at a high rate of speed as it drove around MV#2.
Keywords:
Speed
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
199 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
2000000351
Date:
2020-06-27
Time:
17:42
Address:
210 NAHANTON ST
Speed limit:
30
Violation cited:
no
Narrative:
On 6/27/20 at 1742 I responded with multiple units, NFD and medics for a report of a MVA with injuries on Nahanton St. Upon arrival I observed NH Reg 4539251 wrapped around Verizon utility pole 6/15 facing eastbound on Nahanton St. The operator and the passenger behind the operator were trapped inside the vehicle. The front right passenger was able to get out of the car. Multiple witnesses stated that the vehicle was traveling WB and when it came around the bend in the road the operator lost control and spun clockwise into the pole. The vehicle ultimately rested facing the direction it came from, eastbound. NFD responded and was able to free the remaining two passengers from the vehicle. All passengers were transported to Beth Israel Boston for treatment. While on scene, I spoke with the passenger from the front seat who stated they were traveling westbound towards Needham and the operator just lost control around the bend due to the wet surface. There were no other vehicles involved in the accident, Tody's responded to tow the vehicle. Verizon was notified of their utility pole being damaged. Pictures were taken of the scene and turned over to IT to be uploaded to this report. I responded to the hospital to follow up with the occupants but was only allowed to speak with the passengers and not the operator as he was in critical condition with a broken femur and head injuries. The rear passenger stated that he didn't think his son, the operator, was going that fast but he lost control around the bend, he was suffering from neck pain and is in fair condition. The passenger in the front seat suffered minor/unknown leg injuries but hospital staff believed he would be discharged tonight.
Keywords:
Crash, Fire, Hospital, Pictures
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.2969814
Longitude:
-71.1958963
Location:
210 Nahanton St, Newton, MA 02459, USA
Case number:
2000000559
Date:
2020-09-27
Time:
22:29
Address:
565 CHESTNUT ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 9/27/20 I was Working N497 when I responded to an MVA with rollover in the area of Chestnut and Beacon St. along with multiple other units. Upon arrival at 565 Chestnut St. (which is a publicway in the city of Newton) I spoke with the operator of Veh 1 Jenna Wolf. Wolf stated that she was traveling northbound on Chestnut St. when a Vehicle traveling southbound swerved at her causing her to swerve to the left causing her to jump the curb and collide with a parked car. Wolf stated the car then rolled over and she was able to climb out on her own. Wolf had a laceration to the head that was bleeding so Newton Medics transported her to NWH for treatment. Wolf had a moderate smell of alcoholic beverages emanating from her person and glassy eyes and was slurring her words. Wolf was not asked to do field sobriety due to her injuries. The first parked car (Veh 2) that was struck by Veh 1 slid across the driveway and struck Veh 3, also causing damages to the driveway and yard. The Vehicles owner Vladimir Berezovsky was notified and provided a report number. Veh 2, and Veh 3 were disabled and towed away by Todys at the owners request. A witness named Reza Dana spoke with Ofc. T Keefe and stated "We were traveling down Beacon St. and had a green light at the intersection of Chestnut St. when two cars came speeding northbound on Chestnut St. and ran the red light at Beacon St. almost killing him". Then one of the cars went off the road and struck a parked car causing it to rollover. Veh 1 came back through dispatch as unregistered. Due to the fact that it was a residental area, the vehicle almost struck a home and the witness statment, Wolf was issued a Ma Uniform Citation T2080019 for 90/24/j Oui, 90/24/E MV Negligent Operation, 90/9/b Unregistered, 90/17/A Speeding. Pictures were taken by Ofc Keefe and submitted to IT.
Keywords:
Alcohol, Citation, Moderate, Pictures, Speed
Dcc:
Too fast for conditions, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3305312
Longitude:
-71.2254362
Location:
565 Chestnut St, Waban, MA 02468, 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 380.332ms