crash_reports
2 rows where "datetime" is on date 2019-01-14, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-01-14
Time:
16:44
Address:
77 NEWELL RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of MV1 was parked across the street from 77 Newell rd from the hours of 345pm to 450pm. When she had come out of the residence to her vehicle, she noticed red paint and several dents to the front fender of her vehicle. There was minor damage and was able to drive. The vehicle was unoccupied and there are no cameras in the surrounding houses.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.351057
Longitude:
-71.243825
Location:
Case
number:
Date:
2019-01-14
Time:
14:06
Address:
2150 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/14/2019 at approx 1406Hrs while assigned to 497 I responded to the area of 2150 Washington St for a report of a 2 car collision. Upon arrival I met with the operators of Ma Reg 5NG581 Jeff LONDON and Ma Reg RT35K2 Lori GANS. LONDON was signing a refusal with Cataldo Ambulance and stated he had already exchanged all his information with the other operator. I spoke with GANS who stated LONDON stopped suddenly for a turkey that walked into the roadway, GANS was able to brake but lightly tapped LONDON.
Keywords:
Ems, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3291503
Longitude:
-71.2501096
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);