crash_reports
3 rows where "datetime" is on date 2019-05-06 and dcc = "["Unknown"]"
This data as json, CSV (advanced)
Suggested facets: keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-06
Time:
11:32
Address:
91 CHURCH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle # 1 was parked on Church Street in front of #91 at 09:00 on 5/6/19 and owner noticed damage on 5/6/19 at 11:15. Appears that unknown vehicle # 2 was coming WB on Church St and sideswiped vehicle #1. No tows.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3527677
Longitude:
-71.1833068
Location:
Case
number:
Date:
2019-05-06
Time:
11:36
Address:
76 ELDREDGE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle # 1 was parked on Church Street at the intersection with Eldredge St. There was fresh damage to the front half of the vehicle. Another vehicle was struck on this road between 09:00 and 11:15. I left a note on Vehicle # 1 to notify her that a police report was taken.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3531774
Longitude:
-71.1834229
Location:
Case
number:
Date:
2019-05-06
Time:
14:27
Address:
325 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPER OF MV1 STATED THAT HE WAS PULLING OUT FROM A BOSTON COLLEGE DRIVEWAY (ON TO BEACON ST), WHEN MV2 DROVE AROUND ANOTHER STOPPED VEHICLE, CAUSING THEM TO COLLIDE. OPER OF MV#2 STATED THAT HE WAS TRAVELLING WB ON BEACON ST. OPER OF MV#2 STATED THAT HE DROVE AROUND A STOPPED VEHICLE (LEFT SIDE) AND ENTERED A LEFT TURN LANE. WHILE DOING SO, MV#1 EMERGED FROM A DRIVEWAY (WB SIDE) AND THE VEHICLES COLLIDED. MV1 SUSTAINED MINOR FRONT DAMAGE. MV2 SUSTAINED MODERATE PASSENGER SIDE DAMAGE.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3333408
Longitude:
-71.1719303
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);