crash_reports
2 rows where intersection = 0 and "retrieved" is on date 2022-03-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-03-13
Time:
06:03
Address:
14 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Based on observations, and statements made, the follwoing occoured. M/V#1 was traveling east on Needham St. M/V#2 was traveling in the same direction in the lane to the left of M/V#1. M/V#2 thought M/V#1 had passed him, and attempted to turn right into 14 Neehamd St. to turn around. M/V#1 was slightly ahead of M/V#2 and was struck in the left rear.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3161487
Longitude:
-71.209135
Location:
Case
number:
Date:
2022-03-18
Time:
00:21
Address:
1255 WASHINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV 1 was backing out of her parking spot when she backed onto the sidewalk and into a parking meter. The operator of MV1 (Ms. Pengwynne Blevins) sustained a possible neck injury and was transported to Newton Wellesley Hospital. MV 1 was towed for being on the sidewalk and no driver was available to pick it up. MV 1 sustained minor damage to the right front and right rear (few scratches). The passenger, Ms. Amanda Simeone, sustained no injuries and called an uber home. Pengwynne was issued citation T1445557 for OUI, Negligent operation of a motor vehicle, and marked lane violation. An immediate threat has been filled out and faxed over to the RMV.
Keywords:
Citation, Hospital
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.349595
Longitude:
-71.2250448
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);