crash_reports
4 rows where "datetime" is on date 2019-09-10, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime, time, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-09-10
Time:
09:06
Address:
2370 COMMONWEALTH AVE
Speed
limit:
5
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he was traveling east on Commonwealth Ave and had just entered the property at #2370 Commonwealth Ave when crash occurred with MV#2. The operator of MV#2 stated that she was traveling north on Auburn St and had just entered the property at #2370 Commonwealth Ave when crash occurred with MV#1. No injuries, no tows.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3446149
Longitude:
-71.258025
Location:
Case
number:
Date:
2019-09-10
Time:
09:00
Address:
56 EXETER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 9-10-19 AT APPROX. 0900HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 56 EXETER ST. I SPOKE TO THE COMPLAINANT ( MARK TERNULLO ). COMP. STATES HE HAD PARKED HIS COMPANY VEHICLE ( MA REG: S24731 ) IN FRONT OF 56 EXETER ST. HE WENT IN TO SPEAK TO THE RESIDENT HE WAS GOING TO DO WORK FOR. WHEN HE RETURNED TO HIS VEHICLE AT 0845HRS. HE NOTICED THE LEFT REAR QTR PANEL HAD A LARGE DENT AND SCRAPES. COMP. STATES HE DID NOT SEE WHO DAMAGED HIS VEHICLE. COMP. REPORTS NO INJURIES. COMP ADVISED TO CONTACT HIS INSURANCE COMPANY.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.339252
Longitude:
-71.2275129
Location:
Case
number:
Date:
2019-09-10
Time:
17:29
Address:
95 WELLS AVE
Speed
limit:
0
Violation
cited:
no
Narrative:
MV1 was parked at 95 wells ave and Owner1 came out to see that there was moderate damage to the vehicle. Vehicle was towed by AAA towing. A witness stated that they heard a bang and thought a gray SUV may have been involved. No cameras on the exterior of the building.
Keywords:
Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2922215
Longitude:
-71.199726
Location:
Case
number:
Date:
2019-09-10
Time:
17:29
Address:
401 WINCHESTER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 states he was in bumper to bumper traffic traveling southbound on Winchester Street when he was rear ended by MV2. MV1 sustained minor damage to the rear fender. Operator of MV2 states she was in bumper to bumper traffic traveling southbound on Winchester Street. Operator of MV2 states MV1 was in front of her and when the flow of traffic moved she accidently hit the accelerator too hard and rear ended MV1. MV2 sustained heavy front end damage and was towed by Tody's.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3067023
Longitude:
-71.2061415
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);