crash_reports
4 rows where date = "2022-05-15" and "retrieved" is on date 2022-05-23
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-15
Time:
02:51
Address:
BEACON ST & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 PROCEEDING S/B CENTRE STREET REAR ENDED MV2 WHILE MV2 WAS STOPPED AT A RED LIGHT AT CENTRE STREET AND BEACON STREET. DRIVER MV1 STATED SHE HAD WOKEN UP VERY EARLY IN THE MORNING AND WAS EXHAUSTED WHICH CAUSED HER TO NOT SEE MV2 MV1 TOWED VIA TODY'S BOTH PARTIES STATED THEY DID NOT REQUIRE MEDICAL ATTENTION.
Keywords:
[]
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3300268
Longitude:
-71.1948254
Location:
Case
number:
Date:
2022-05-15
Time:
10:22
Address:
35 PELHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 5/14/22 at 1628hrs, Mv#1 was parked unoccupied in front of 35 Pelham St. #1 owner Mr Brian Larsen was not home at this time. Mr Larsen's front door video system captured a grey possible Honda CRV, with passenger side front spare donut tire (no hubcap), with rear body damage above the passenger side rear tire veer to the right sideswiping his parked vehicle causing minor damage to his driver's side rear. Unknown vehicle fled continuing down Pelham St out of view. Video system was unable to zoom in on a plate number. A neighbor witness, Ms Claire Johannes, sitting on her front stoop across the street observed the collision and was also unable to see a plate number. Unknown vehicle operator was described by her as a W/F, with brown hair. Mr Larsen will email the footage to policerecords@newtonma.gov
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3313535
Longitude:
-71.1962327
Location:
Case
number:
Date:
2022-05-15
Time:
13:23
Address:
CENTRE ST & WARD ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 was traveling south bound on Centre Street coming up to the intersection at Ward Street when she rear ended MV#2 who was pushed into MV#3. MV#2 and MV#3 were stopped at the red light. There was major damage to the front of MV#1 and rear end damage to MV#2 and MV#3. MV#1 was towed by Tody's towing. The operator of MV#1 and passenger signed a medical refusal. There was no airbag deployment.
Keywords:
Airbag
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3381285
Longitude:
-71.1930229
Location:
Case
number:
Date:
2022-05-15
Time:
14:07
Address:
DEDHAM ST & NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR 1 OF MV1 WAS TURNING FROM NAHANTON ST ONTO DEDHAM ST (S/B) AND PULLED INTO THE LEFT (INSIDE ) LANE AND WENT TO SWITCH LANES INTO THE RIGHT (OUTSIDE) LANE AND COLLIDED WITH MOTORCYCLE1. MINOR DAMAGE TO MV1. MC1 WAS TURNING ONTO DEDHAM ST (S/B) FROM NAHANTON ST AND WAS IN THE RIGHT LANE. MV1 DID NOT SEE MC1 AND SIDESWIPED MC1. MC1 SLID THE MC TO THE GROUND. MINOR INJURIES TO OPERATOR2 OF MC1. OPERATOR2 WAS EVALUATED BY THE MEDICS AND REFUSED TRANSPORTATION. MINOR DAMAGE TO MC1. NO TOWS NEEDED. NO CITATIONS ISSUED AT THIS TIME.
Keywords:
Citation
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3003288
Longitude:
-71.1881827
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);