home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-04-26 and hit_run = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000420
Date:
2019-04-26
Time:
16:15
Address:
303 WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was parallel parked in front of Bank of America on Walnut St when he began to pull out, MV2, ( suspected to be MA Reg:8WX995) hit MV1 on his driver's side door. MV2 backed up in the road and then sped off without stopping to give his information. MV1 operator, Marcus Klevan, came into the police station to report this hit and run which occurred around 1430hrs today. MV1 operator and passenger were able to identify the license plate of the vehicle as it left the scene. The plate came back to a 1997 Toyota Tercel, blue, registered to John Twinomujuni out of Waltham. Waltham PD was notified and was unable to locate the vehicle at this time. UPDATE: Waltham PD was requested to check again for this vehicle at it's registered address tonight, 5/1/2019. This check resulted in negative results for the vehicle. No citation will be issued at this time until there is verification that this vehicle was indeed involved in this accident.
Keywords:
Citation, Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3504026
Longitude:
-71.2072553
Location:
303 Walnut St, Newton, MA 02460, USA
Case number:
1900000424
Date:
2019-04-26
Time:
17:16
Address:
333 NAHANTON ST
Speed limit:
5
Violation cited:
no
Narrative:
Owner of MV1 states his vehicle was backed into a parking spot at the JCC, 333 Nahanton St. Sometime between 0720 to 0815 his vehicle was struck on the drivers side bumper (minor damage). There was possibly some white paint transfer however it was cleaned off prior to my arrival. I contacted the JCC, they stated they may have cameras, however the only person that can access them is not working (617 558 6552 - Brian Morris). There were no witnesses to the accident and it was not reported until later in the day.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.2993233
Longitude:
-71.2036386
Location:
333 Nahanton St, Newton, MA 02461, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 775.289ms