crash_reports
2 rows where "datetime" is on date 2019-03-08 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-03-08
Time:
11:54
Address:
111 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV1 stopped short to allow an unidentified MV back of of a parking space. He stopped behind MV2. MV2 did not see MV1 stop and backed into MV1.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3137685
Longitude:
-71.2121457
Location:
Case
number:
Date:
2019-03-08
Time:
17:14
Address:
275 CENTRE ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 03/08/2019, at 1714 hrs, I responded to 275 Centre St, Bertucci's parking lot, for a two car MVA. Upon arrival, I observed MV1 to have no damage to the rear end where she collided with MV2. MV2 had damage to the front passenger side door. The operator of MV1 stated that she did not see MV2 while she attempted to back out of a parking spot and collided with her passenger side. The operator of MV2 corroborated the story and stated she was attempting to exit the parking lot when MV1 backed into her passenger side.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.358572
Longitude:
-71.185233
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);