crash_reports
2 rows where "retrieved" is on date 2021-03-01 and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-20
Time:
11:40
Address:
WATERTOWN ST & BARRIEAU COURT
Speed
limit:
15
Violation
cited:
no
Narrative:
Owner of Veh 1 stated that he believes his car was struck around 4:30 earlier this morning, when he heard a loud noise. His vehicle was parked on Barrieau Court next to 368 Watertown Street. Damage makes owner believe it was hit by a plow during the snow storm. No cameras were located in the area. Owner may call for a tow later due to damage. Owner contacted me to let know that Antonellis Construction plows the area.
Keywords:
Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3585632
Longitude:
-71.204393
Location:
Case
number:
Date:
2021-02-22
Time:
17:03
Address:
427 WATERTOWN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she was sitting in her parked motor vehicle when the rear driver's side was struck by Vehicle #2 causing minor damage. Vehicle #2 then left the area. When I spoke with the operator of Vehicle #2 he stated that was unaware that he struck a vehicle, but "that doesn't mean it didn't happen". He also reported that his vehicle was not damaged. Neither party complained of injury when they were asked. This occured in the rear parking lot of 425 Watertown St.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3596277
Longitude:
-71.203289
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);