crash_reports
2 rows where "date" is on date 2021-07-26, "retrieved" is on date 2021-08-02 and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-26
Time:
13:01
Address:
245 HARTMAN RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was backing out of the driveway of 245 Hartman Road when it crashed into motor vehicle 2 (MV2), which was legally parked across from that address. As a result of the crash, MV1 sustained minor rear end passengers side damage, while MV2 sustained minor drivers side damage.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3041161
Longitude:
-71.1815663
Location:
Case
number:
Date:
2021-07-26
Time:
14:07
Address:
COMMONWEALTH AVE & CHESTNUT TERR
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator 1 was pulling left onto Commonwealth Ave from the stop sign on Chestnut Terr when she struck the drivers side of vehicle 2. Operator 2 was traveling westbound on Commonwealth Ave when he was struck on the drivers side by vehicle 1 as she was pulling onto Commonwealth Ave. Neither vehicle required a tow and neither operator reported any injuries.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3361982
Longitude:
-71.1899502
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);