crash_reports
2 rows where "datetime" is on date 2019-02-06 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-06
Time:
12:34
Address:
340 RIVER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Thomas Mellino stated that on 02/06/2018 at 12:34 hours he was standing next to the cab of his 2019 Volvo tractor trailer ( IN APP reg 2660662 ) facing west in front of 340 River St. River St is a public way in the city of Newton. Mellino stated that a green box like SUV, possibly a KIA Soul was driving east on River St and passed his truck. It should be noted that Mellino's truck was complexly taking up the entire east bound lane of River St. Mellion stated that as the green vehicle passed by him it stuck on his right wrist. Mellion stated that the green vehicle did not stop and continued to drive east on River St. Mellion stated he believed that the green vehicle registration was MA 774GBI. A check of the MA RMV data base came back with no matching record. Several different combinations of the plate that Mellion gave were entered into the MA RMV data base with negative results. Mellion was evaluated by medics and singed a patient refusal. Several units checked the area with negative results.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3575768
Longitude:
-71.2394369
Location:
Case
number:
Date:
2019-02-06
Time:
14:07
Address:
697 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OWNER OF MV 1 STATED SHE PARKED HER 2015 TOYOTA VENZA LEGALLY ON WASHINGTON STREET IN FRONT OF 697 WASHINGTON STREET (GARDEN REMEDIES) AT 10:50 AM TODAY. AT 2:00 PM SHE WENT BACK TO HER VEHICLE AND NOTICED FRESH DAMAGE TO HER FRONT LEFT SIDE OF HER BUMPER. THERE ARE CAMERAS LOCATED OUTSIDE OF 697 WASHINGTON ST AND THE VEHICLE OWNER WHO WORKS AT GARDEN REMEDIES WILL INQUIRE WHETHER OR NOT THE CAMERAS CAPTURE VIDEO NEAR HER VEHICLE. NO NOTE WAS LEFTAND NO WITNESSES TO THE CRASH AT THIS TIME.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3529253
Longitude:
-71.2021966
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);