crash_reports

Table actions

1 row where dcc = "["Signs/Signals", "Other improper action"]", intersection = 0 and keywords contains "Pictures"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000253
Date:
2021-04-09
Time:
15:47
Address:
1280 CENTRE ST
Speed limit:
25
Violation cited:
yes
Narrative:
Vehicle 1 was parked in a proper parking spot on the right side of 1280 Centre St. Witness 1 stated that she saw vehicle 2 traveling westbound around the corner of 1280 Centre St building. (should be noted that Vehicle 2 was driving the wrong way down a one way road) Witness 1 stated vehicle 2 then attempted to make a U-Turn (3 point turn) to properly turn around and drive the correct way. Witness 1 stated she saw vehicle 2's front bumper make contact with vehicle 1's rear bumper approximately 4 times to the point of vehicle 1 being pushed forward twice. Witness 1 then took out her cell phone and took 2 pictures of Vehicle 2 leaving the scene without leaving proper information. Witness 1 left a note on vehicle 1 car with proper information of vehicle 2. Dispatcher Capoli contacted the owner of Vehicle 2. Vehicle 2 owner denied he was in a motor vehicle accident. Needham Officer went to Vehicle 2 residence to check damage on vehicle. Vehicle 2 owner would not allow Needham Officer into his garage to inspect damage.
Keywords:
Crash, Phone, Pictures
Dcc:
Signs/Signals, Other improper action
Report url:
report
Image url:
image
Latitude:
42.3296269
Longitude:
-71.1943762
Location:
1280 Centre St, Newton, MA 02459, 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);