crash_reports
2 rows where "datetime" is on date 2020-07-22 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2020-07-22
Time:
06:54
Address:
165 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Based on observations and statements made, the following occoured. M/V#1 was traveling east on Needham St. when the operator abruptly turned left to enter 165 Neddham St. M/V#2 was traveling behind M/V#1, and collided with the left rear of M/V#1 as it turned left.
Keywords:
[]
Dcc:
Emotional, Unknown
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2020-07-22
Time:
19:14
Address:
271 AUBURN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV#1 was parked in a parking lot at 271 Auburn St. The owner of MV#1 stated that while she was in work, her car was struck in the parking lot. She stated that she did not notice the vehicle was damaged until after she left work at 1815 hrs. Owner stated that she did not get any information about the vehicle that stuck hers. She also stated that there are no cameras at her office that would have recorded the incident. MV#1 sustained minor damage to the front drivers side quarter panel of her vehicle.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3465566
Longitude:
-71.2465397
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);