crash_reports
3 rows where "datetime" is on date 2020-01-01, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-01-01
Time:
12:53
Address:
18 THURSTON RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 stated that he parked his MV across from #19 Thurston Rd at approx. 1PM on 12/31/19 and retrieved it at 9PM the same day. Today he discovered damage to the front quarter on the drivers side that he believes occurred while parked on Thurston Rd sometime last night. MV#1 was parked in a driveway overnight and owner states the damage must of occurred prior to that. Owner suspects a small dump truck parked in the driveway at #19 Thurston Rd yesterday at 1PM and gone at 9PM may be responsible for the damage to his MV. I went to the residence at #19 Thurston Rd and there was no dump truck parked on or around the property and no one home at that time. I left my information for the owner of the dump truck to contact me. To be further investigated. Update on 1/6/20: I went to the residence at #19 Thurston Rd on 2 other occasions after not hearing from anyone and found no one there. I will update report if and when I speak with someone from the residence.
Keywords:
Night
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3156132
Longitude:
-71.2165225
Location:
Case
number:
Date:
2020-01-01
Time:
15:02
Address:
1200 BEACON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated she had parked her vehicle in the parking lot of "Cold Springs Playground" located at 1200 Beacon St in the area of the soccer field and went for a walk in the woods. When she returned to her vehicle she discovered the rear right side bumper had been damaged. MV#1 sustained minor damages to its rear right side bumper.
Keywords:
Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3311133
Longitude:
-71.2132723
Location:
Case
number:
Date:
2020-01-01
Time:
18:17
Address:
326 FULLER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday, January 1st 2020, at approximately 6:17pm, I, Officer Brooks, responded to 326 Fuller street for a single car MVA. I was able to observe MV1(MA REG 1DA662) which had two flat tires on the passenger side, as well as damage to the front passenger side bumper. The operator stated she was traveling eastbound on Fuller street, and struck a sidewalk bump out in front of 326 Fuller street. The bump outs were placed to create parking areas on Fuller street in front of the Brae Burn Country Club. The operator stated she was not able to see the bump outs, and that the area was not marked clearly. The operator stated she did not sustain any injuries as a result of the accident. I was able to observe the area in question, and the bump outs are not clearly marked. There is no colored paint, or reflective markings warning operators of the presence of the bump outs. MV1 was towed privately by CJ Auto due to the damage. I provided the operator with the report number.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3360988
Longitude:
-71.2354486
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);