crash_reports
2 rows where "datetime" is on date 2019-03-12 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-12
Time:
14:36
Address:
30 TOWER RD
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated he parked his vehicle in the parking lot of 30 Tower Rd and went inside the store to shop. He returned to his vehicle and discovered that the front and rear passenger side doors had been damaged. The owner of MV#1 stated he went back into the store in hopes to view surveillance videos of the accident but came up with negative results.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3102612
Longitude:
-71.2156323
Location:
Case
number:
Date:
2019-03-12
Time:
15:49
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The OP. of MV#1 states she has been having issues with controlling her right leg recently and went to Newton-Wellesley Hospital today to precisely see her doctor about it. As she was pulling up to stop for the Valet, her leg hit the gas pedal instead of the brakes. She steered around pedestrians, went up on the curb, through a frozen snow mound before managing to stop on a roadway towards the other hospital buildings. The OP. of MV#1 understands that she shouldn't be driving for the time being. Immediate Threat Form was faxed to the Driver Control Unit.
Keywords:
Hospital, Ped, Snow
Dcc:
Physical impairment
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);