crash_reports
2 rows where "datetime" is on date 2020-01-22 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-22
Time:
14:01
Address:
101 EXETER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/22/2020 at approx 1400 hrs while assigned to 497 I responded to 101 Exeter St for a report of a crash without injury. Upon arrival I met with Kyle FRAZIER who stated he had just pulled his work van to the side of the road when he was struck from behind by the operator of Ma Reg 777EK4 Jane FRANTZ. FRANTZ had left the area after providing FRAZIER with her info due to the minor nature of the crash. FRAZIER stated he is required to have a police report regardless of damage.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3384243
Longitude:
-71.2296477
Location:
Case
number:
Date:
2020-01-22
Time:
17:00
Address:
239 WATERTOWN ST
Speed
limit:
0
Violation
cited:
no
Narrative:
Owner of V1 stated between the hours of 3:00pm and 5:00pm her vehicle was hit by an unknown vehicle. V1 was parked in the parking lot of 239 Watertown Street. The unknown vehicle left the crash and did not leave any information. V1 sustained significant damage to the right rear side of the vehicle. No injuries and no tows.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3616588
Longitude:
-71.1959663
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);