home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

15 rows where keywords contains "Glare" and speed_limit = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: address, street2, intersection, 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:
1900000317
Date:
2019-03-26
Time:
10:54
Address:
CHERRY ST & WEBSTER ST
Speed limit:
30
Violation cited:
yes
Narrative:
ON 3-26-19 AT APPROX. 1054HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WEBSTER AND CHERRY ST. I S[POKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WEBSTER AND HAD THE GREEN LIGHT. WHEN HE WENT THROUGH THE INTERSECTION HE WAS HIT IN THE LEFT SIDE BY VEHICLE #2. VEHICLE #1 STATES AFTER BEING HIT HIS VEHICLE SPUN AND HIS RIGHT REAR SIDE HIT A EVERSOURCE UTILITY POLE ( 453/7 ). AFTER HITTING THE UTILITY POLE HIS VEHICLE CONTINUED TO MOVE ACROSS THE STREET TO 35 WEBSTER WHERE HE HIT A ROCK WALL CAUSING DAMAGE TO HIS LEFT FRONT. VEHICLE #2 STATES SHE WAS TRAVELING S-BOUND ON CHERRY ST. AS SHE APPROACHED WEBSTER ST. SHE STATES SHE WAS BLINDED BY SUN GLARE AND CONFUSED THE LIGHTS AT CHERRY AND WASHINGTON AS BEING THE CORRECT LIGHTS ( THEY WERE GREEN AT THE TIME ). WHEN SHE REALIZED THE LIGHT AT CHERRY AND WEBSTER WAS RED SHE WAS UNABLE TO AVOID HITTING VEHICLE #1. VEHICLE #1 HAD EXTENSIVE REAR AND LEFT FRONT END DAMAGE AND WAS TOWED BY TODYS. VEHICLE #2 HAD EXTENSIVE FRONT END DAMAGE AND WAS TOWED BY TODYS. OPERATOR OF VEHICLE #2 WAS MAILED CITATION ( T1442287 ) FOR CHAPTER 89/9 FAILURE TO YIELD. VEHICLE #1 WAS MAILED CITATION ( T1442286 ) FOR PASSENGER RESTRICTION VIOLATIONS UNDER JUNIOR OPERATOR LICENSE. ALL PARTIES , ( WITH THE EXCEPTION OF WRIGLEY LOWE ) REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. CHRISTOPHER CAMPBELL AND SERGIO ALVAREZ WERE TURNED OVER TO THEIR PARENTS. WRIGLEY LOWE WAS TRANSPORTED BY MEDIC2 TO NEWTON WELLESLEY HOSPITAL FOR MINOR CUTS. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. I TOOK APPROX. 7 PICTURES OF THE UTILITY POLE AND THE ROCK WALL. DISC TURNED OVER TO I.T. DIRECTOR SMITH. NEW DISC PLACED IN 492 CAMERA.
Keywords:
Citation, Crash, Glare, Hospital, Pictures, Severe, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.350159
Longitude:
-71.228704
Location:
Cherry St & Webster St, Newton, MA 02465, USA
Case number:
1900000895
Date:
2019-08-30
Time:
07:17
Address:
ALBEMARLE RD & NORTH ST
Speed limit:
30
Violation cited:
no
Narrative:
OPERATOR#1 REPORTS THAT SHE WAS GOING S/B ON CRAFT ST ATTEMPTING TO MAKE A LEFT TURN ONTO NORTH ST WHEN VEHICLE #2 STRUCK HER VEHICLE IN THE INTERSECTION. VEHICLE #2 CONTINUED N/B ON CRAFT ST WITHOUT STOPPING. VEHICLE WAS DESCRIBED ONLY AS A SILVER SUV WITH FRONT PASSENGER SIDE DAMAGE. DUE TO THE SUN GLARE OPERATOR #1 WAS UNABLE TO GET A BETTER DESCRIPTION. OPERATOR THOUGHT SHE LATER SAW THE INVOLVED VEHICLE STOPPED ON CRAFT ST AFTER SHE HAD TURNED ONTO NORTH ST THEN PULLED ONTO ALBEMARLE RD. THERE WERE NO CALLS ABOUT THIS ACCIDENT LOCATION OTHER THAN FROM OPERATOR #1. WALTHAM PD WAS NOTIFIED AND GIVEN THE LIMITED INFORMATION PROVIDED. OPERATOR #1 REPORTED NO INJURY AND HER VEHICLE WAS NOT TOWED.
Keywords:
Crash, Glare, Solar
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.36081
Longitude:
-71.2164
Location:
North St & Albemarle Rd, Newton, MA 02460, USA
Case number:
1900000979
Date:
2019-09-27
Time:
07:23
Address:
COMMONWEALTH AVE & MORTON ST
Speed limit:
30
Violation cited:
yes
Narrative:
The operator of MV#1 stated he was travelling eastbound on Commonwealth Ave making a left turn onto Morton St when he was struck by MV#2. The operator of MV#1 stated he was unsure of where MV#2 came from. There was a strong solar glare facing westbound on Commonwealth Ave during this accident. MV#1 sustained heavy driver's side front end damages. Both front airbags were deployed. The operator of MV#1 stated he was not injured. The front passenger of MV#1 was not injured and had already left the scene to attend school. The driver's side rear passenger sustained a bleeding nose from this accident. She was unsure what caused her injuries because it happened too quickly. She was evluated by Newton Paramedics and signed a patient refusal of treatment. The initial point of impact for both vehicles was in the middle intersection of Commonwealth Ave at Morton St. There were broken vehicle parts and tire skid marks starting from the point of impact and onto the berm on Commonwealth Ave on the carriage lane side. MV#2's final resting spot was directly accross from 808 Commonwealth Ave. MV#2 sustained heavy front end damages to its driver's side wheel (Broken axle) and flat front right side tire. MV#2's driver's side airbag was deployed. The operator of MV#2 was transported by Newton Paramedics to the Boston Medical Center. I spoke to the operator of MV#2 via telephone and she stated she was travelling westbound on Commonwealth Ave when she was struck by MV#1 and caused her swerve onto the carriage lane berm. The operator of MV#1 is 6.5 months into her pregnancy and sustained neck, back, bruises and left hand injuries. She was transported to Boston Medical Center and was later discharged the same day. She was provided with this accident report number and was advised to contact her insurance provider. I spoke to the witness who was at the intersection of Cedar St and Commonwealth Ave. The witness stated MV#1 was travelling eastbound on Commonwealth Ave and had stopped, attempting to make a left turn onto Morton St. The witness stated she then observed MV#2 travelling westbound on Commonwealth Ave and struck MV#1. The witness stated she believed MV#2 was travelling at a high rate of speed because it continued to travel onto the berm after striking MV#1. I took digital photographs of the damaged berm on Commonwealth Ave. Based on the statements made to me, I issued in hand to the operator of MV#1 citation #T1268357 for violation of c89 s8 failure to yield when turning left. Both vehicles were towed by "Tody's Towing".
Keywords:
Airbag, Citation, Crash, Glare, Pictures, School, Solar, Speed
Dcc:
Failed to yield, Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3380161
Longitude:
-71.200842
Location:
Commonwealth Avenue & Morton St, Newton, MA 02459, USA
Case number:
1900001323
Date:
2019-12-21
Time:
07:57
Address:
64 HOMER ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated he was parked at the street bend of 64 Homer St when he was struck from behind by MV#2. MV#1 sustained heavy damages to its driver's side rear bumper area. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated he was travelling eastbound on Homer St when his visibility was obstructed by the solar glare and struck MV#1. MV#2 sustained heavy front end damages with both front airbags deployment. The operator of MV#2 sustained a cut lower lip. He was evaluated by Newton Paramedics and signed a patient refusal of treatment. It should be noted when this accident occurred, there was a solar glare obstruction that faced all oncoming eastbound traffic. Tody's Towing took possession of MV#2.
Keywords:
Airbag, Crash, Glare, Solar
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3350688
Longitude:
-71.1962327
Location:
64 Homer St, Newton, MA 02459, USA
Case number:
2000000338
Date:
2020-06-19
Time:
08:28
Address:
216 AUSTIN ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 6-19-20 AT APPROX. 0828HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 216 AUSTIN ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON AUSTIN ST. WHEN HE WAS BLINDED BY THE GLARE OF THE RISING SUN. DRIVER STATES HE CRASHED INTO VEHICLE #2 WHILE BLINDED. VEHICLE #2 WAS PARKED IN FRONT OF 216 AUSTIN ST. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE WITH AIRBAG DEPLOYMENT AND WAS TOWED BY TODYS. VEHICLE #2 HAD LEFT REAR BUMPER DAMAGE BUT WAS STILL OPERATIONAL. DRIVER OF VEHICLE #1 WAS EXAMINED BY MEDICS AND SIGNED A PATIENT REFUSAL. VEHICLE #2 IS OWNED BY A CONSTRUCTION COMPANY BUT NONE OF THE WORKERS WITNESSED THE ACCIDENT. ALL PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Glare, Severe, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.349191
Longitude:
-71.2167694
Location:
216 Austin St, Newton, MA 02465, USA
Case number:
2000000486
Date:
2020-08-31
Time:
07:00
Address:
WASHINGTON ST & NORTH CHESTNUT
Speed limit:
30
Violation cited:
no
Narrative:
The operator of vehicle 1 states she was traveling north on Chestnut Street, taking a left onto Washington Street. Operator of vehicle 1 states she has a green light, as she proceeded into the intersection vehicle 1 was struck on the left side by vehicle 2. The operator of vehicle 2 also claims he had a green light, while traveling east on Washington Street. The operator of vehicle 2 states as he proceeded into the intersection, so did vehicle 1. At that time vehicle 2 struck vehicle 1 with the front of vehicle 2. Medics responded due to airbag deployment and transported the operator of vehicle 2 to NWH for an evaluation. It should be noted at the time of the accident the glare while traveling east on Washington Street makes is difficult to see. Todys towed both vehicles.
Keywords:
Airbag, Crash, Glare
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3493354
Longitude:
-71.2253682
Location:
Chestnut St & Washington St, Newton, MA 02465, USA
Case number:
2000000740
Date:
2020-12-16
Time:
07:55
Address:
778 DEDHAM ST
Speed limit:
30
Violation cited:
no
Narrative:
VEHICLE #2 WAS STOPPED IN TRAFFIC IN FRONT OF 778 DEDHAM ST, HEADING EASTBOUND. VEHICLE #1 WAS TRAVELING EASTBOUND ON DEDHAM ST, DID NOT NOTICE VEHICLE #2 STOPPED DUE TO EXTREME SOLAR GLARE WHICH WAS BLINDING. AT THIS TIME VEHICLE #1 REAR ENDED VEHICLE #2. NO INJURIES REPORTED, VEHICLE #1 TOWED BY TODYS TOWING OF NEWTON.
Keywords:
Glare, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.2993567
Longitude:
-71.1866602
Location:
778 Dedham St, Newton, MA 02459, USA
Case number:
2000000765
Date:
2020-12-22
Time:
11:56
Address:
1357 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that she was traveling Westbound on Washington Street and as she was slowing down for the red light was struck from behind by motor vehicle #2. Motor vehicle #1 sustained moderate rear end damage. Operator of Motor Vehicle #2 stated that he was traveling Westbound on Washington Street and due to the glare of the sun struck motor vehicle #1 from behind. Motor vehicle #2 sustained moderate front end damage. There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Crash, Glare, Moderate, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3489391
Longitude:
-71.2286452
Location:
1357 Washington St, Newton, MA 02465, USA
Case number:
2100000338
Date:
2021-05-12
Time:
17:23
Address:
NAHANTON ST & WINCHESTER ST
Speed limit:
30
Violation cited:
yes
Narrative:
The operator of MV3 stated he was stopped at the traffic light Westbound on Nahanton St. at the intersection of Winchester St. He stated he took his foot off the break to proceed straight, and due to the glare of the sun impairing his vision, he rear ended MV2. MV3 sustained minor front end damage and the operator was able to drive away from the scene. As a result of being rear ended by MV3, MV2 then rear ended MV1. The operator of MV1 left prior to my arrival after exchanging information. MV2 sustained minor damage to the front and rear end. The operator and passenger of MV2 reported no injuries. The operator of MV2 was given Massachusetts Uniform Citation # T2012850 in hand for Ch. 90 Sec. 10 Unlicensed Operation. MV2 was driven from the scene by a licensed operator. See incident report # 21020378.
Keywords:
Citation, Glare, Impairment, Solar
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.2969738
Longitude:
-71.2009796
Location:
Nahanton St & Winchester St, Newton, MA 02459, USA
Case number:
2100000664
Date:
2021-09-03
Time:
08:01
Address:
CHERRY ST & WEBSTER ST
Speed limit:
30
Violation cited:
yes
Narrative:
ON 9-3-21 AT APPROX. 0801HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WEBSTER AND CHERRY I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING N-BOUND ON CHERRY APPROACHING THE INTERSECTION OF CHERRY AND WEBSTER. DRIVER STATES SHE HAD THE GREEN LIGHT AND WHILE GOING THROUGH THE INTERSECTION WAS HIT IN THE FRONT LEFT BY VEHICLE #2. DRIVER OF VEHICLE #2 STATES HE WAS TRAVELING E-BOUND ON WEBSTER APPROACHING THE INTERSECTION OF CHERRY AND WEBSTER. DRIVER STATES HIS VISIBILITY WAS OBSTRUCTED BY THE GLARE OF THE SUN RISING IN THE EAST AND THOUGHT HE HAD A GREEN LIGHT. WHEN VEHICLE #2 WENT THROUGH THE INTERSECTION HE HIT VEHICLE #1, BOUNCED OFF AND HIT THE TRAFFIC POLE LIGHT ON THE CORNER OF CHERRY AND WEBSTER. THE LIGHT WAS DISLODGED AND HIS VEHICLE STOPPED WHEN HE HIT THE ROCK WALL AT THE SIDEWALK OF WEBSTER ST. BOTH VEHICLES WERE TOWED BY TODYS. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE AND LEFT SIDE AIR BAG DEPLOYMENT. VEHICLE #2 ALSO HAD EXTENSIVE FRONT END DAMAGE. OPERATOR OF VEHICLE #1 REPORTED NO INJURIES AND SIGNED A PATIENT REFUSAL. OPERATOR OF VEHICLE #2 HAD MINOR INJURIES AND WAS TRANSPORTED BY MEDIC2 TO NEWTON WELLESLEY HOSPITAL. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. VEHICLE #2 WAS ISSUED CITATION # T2080808 ( 89/9 F/C RED LIGHT ). CITATION WAS MAILED TO OPERATOR. N524 ( OFF. GAUDET ) TOOK PICTURES OF THE SCENE AND PROPERTY DAMAGE. PICTURES TURNED OVER TO I.T. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Citation, Crash, Glare, Hospital, Pictures, Severe, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.350159
Longitude:
-71.228704
Location:
Cherry St & Webster St, Newton, MA 02465, USA
Case number:
2100000832
Date:
2021-10-15
Time:
08:04
Address:
DERBY ST & MILO ST
Speed limit:
30
Violation cited:
no
Narrative:
ON 10-15-21 AT APPROX. 0804HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF DERBY AND MILO ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING E-BOUND ON DERBY ST. AS SHE APPROACHED THE INTERSECTION OF MILO AND DERBY SHE WAS BLINDED BY THE GLARE OF THE SUNLIGHT THAT WAS RISING IN THE EAST. DRIVER LOST SIGHT OF THE ROAD AND CRASHED INTO A LANDSCAPING TRAILER THAT WAS PARKED IN FRONT OF 258 DERBY ST. I SPOKE TO THE OWNER OF VEHICLE #2. THEY STATED THEY HEARD THE VEHICLE CRASH BUT DID NOT ACTUALLY SEE THE ACCIDENT. VEHICLE #1 HAD EXTENSIVE FRONT RIGHT END DAMAGE AND WAS TOWED BY PRIVATE TOW. VEHICLE #2 HAD NO DAMAGE AND WAS STILL OPERATIONAL. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Glare, Severe, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3599475
Longitude:
-71.2342846
Location:
Derby St & Milo St, Newton, MA 02465, USA
Case number:
2100001031
Date:
2021-12-09
Time:
07:53
Address:
326 RIVER ST
Speed limit:
30
Violation cited:
no
Narrative:
OPERATOR OF MV 1 STATED THAT HE WAS TRAVELING EAST ON RIVER ST AND HIS FRONT PASSENGER BUMPER STRUCK A LEGALLY PARKED MV (MV2), WHICH WAS PARKED IN FRONT OF 330 RIVER ST DUE TO THE GLARE FROM THE SUN. MV 1 SUSTAINED HEAVY DAMAGE TO THE FRONT AND WAS TOWED BY TODY'S TO THEIR LOT. OWNER OF MV 2 WAS ON SCENE WHEN I ARRIVED. MV 2 SUSTAINED MINOR DAMAGE TO ITS REAR LEFT SIDE.
Keywords:
Glare, Solar
Dcc:
Glare, Inattention
Report url:
report
Image url:
image
Latitude:
42.3572129
Longitude:
-71.2389871
Location:
326 River St, West Newton, MA 02465, USA
Case number:
22000153
Date:
2022-02-15
Time:
08:44
Address:
172 PEARL ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 (MA reg 2RBG35) was traveling EB on Pearl Street when she stopped for a vehicle pulling out of a driveway. While stopped the Operator of MV2 (MA reg 2YDP98) also traveling EB on Pearl Street rear ended MV1. Operator of MV2 stated the solar glare obstructed her vision and by the time she observed MV1 stopped it was too late. MV1 sustained minor damage to the rear of the vehicle and was able to drive away safely. MV2 sustained heavy front end damage and was leaking fluid. Air bags were also deployed from MV2. Medic 5 arrived on scene for an evaluation. Operator of MV2 was claiming a possible head injury and signed a medical refusal. Tody's arrived on scene and towed the vehicle.
Keywords:
Glare, Solar
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3589322
Longitude:
-71.1933784
Location:
172 Pearl St, Newton, MA 02458, USA
Case number:
22000258
Date:
2022-03-29
Time:
11:16
Address:
10 BURNHAM RD
Speed limit:
30
Violation cited:
no
Narrative:
ON 3-29-22 AT APPROX. 1116HRS. WHILE WORKING N492 I TOOK A REPORT FOR SINGLE VEHICLE ACCIDENT. UPON ARRIVAL AT 22 BURNHAM RD. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER IS A U.S. POSTAL MAIL CARRIER AND STATES SHE WAS BACKING FROM 40 BURNHAM TO DELIVER MAIL TO 22 BURNHAM. SHE STATES WHILE BACKING HER VISIBILITY WAS OBSTRUCTED BY THE GLARE OF THE SUN IN THE REAR VIEW MIRROR. AS A RESULT OF THE GLARE SHE COULD NOT SEE THE BLACK COLORED UTILITY GAS LIGHT POLE AND CRASHED INTO IT. THE GAS LIGHT IS LOCATED AT THE FRONT ENTRANCE TO 22 BURNHAM. VEHICLE #1 HAD LEFT REAR DENTS AND SCRAPES. THE GAS LIGHT HAD DAMAGE TO THE TOP CASING AND BULB WHICH HAD SMASHED AND WAS LOCATED ON THE GROUND NEAR THE POLE. CITY OF NEWTON WAS NOTIFIED FOR THE DEBRIS. NATIONAL GRID WAS NOTIFIED AND RESPONDED TO SHUT OFF THE GAS. I TOOK SEVERAL PICTURES OF THE DAMAGE AND GAVE THEM TO THE I.T. DEPARTMENT. DRIVER REPORTED NO INJURIES. SHE WAS ABLE TO LEAVE THE SCENE IN HER VEHICLE WHICH WAS STILL OPERATIONAL. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Glare, Pictures, Solar
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3425322
Longitude:
-71.2221992
Location:
10 Burnham Rd, West Newton, MA 02465, USA
Case number:
22000305
Date:
2022-04-12
Time:
19:04
Address:
HENSHAW ST & RIVER ST
Speed limit:
30
Violation cited:
no
Narrative:
MV 1 was traveling straight, westbound on River St. MV 1 was approaching the intersection of River St and Henshaw St he was blinded by solar glare and struck the fire hydrant on the corner of the road. MV 1 sustained damage to the right front tire and bumper. The fire hydrant was disabled. Photos of the fire hydrant and damage to MV 1 were taken with the camera in 492 and submitted into IT. The driver of MV 1 was not injured. I assisted the driver of MV 1 with changing his tire and he was able to drive MV 1.
Keywords:
Fire, Glare, Pictures, Solar
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.352151
Longitude:
-71.228182
Location:
Henshaw St & 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 483.381ms