home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where address = "260 NEEDHAM ST" and speed_limit = 10

✎ 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:
1900001177
Date:
2019-11-15
Time:
16:03
Address:
260 NEEDHAM ST
Speed limit:
10
Violation cited:
yes
Narrative:
OPMV#1 Was parked in the parking lot of Marshals located at 260 Needham St when she was attempting to exit her vehicle. When the OPMV#1 opened her car door, the door was struck by the OPMV#2. OPMV#1 Stated she was exiting her car and another vehicle wiped into the spot next to her. OPMV#2 Was attempting to pull into a parking spot in the Marshals parking lot located at 260 Needham St when she struck the left drivers side door of the OPMV#1. OPMV#2 Stated the person parked in the spot didn't even check to see if it was clear to open her car door before she pulled into her spot. OPMV#2 Was issued MA UNIFORM CITATION#T1442156 M.G.L. C.90 S.10 Unlicensed Operation. See INCIDENT REPORT#19049296.
Keywords:
Citation
Dcc:
Inattention, Unknown
Report url:
report
Image url:
image
Latitude:
42.3088013
Longitude:
-71.2144481
Location:
260 Needham St, Newton, MA 02461, USA
Case number:
2100000605
Date:
2021-08-13
Time:
14:15
Address:
260 NEEDHAM ST
Speed limit:
10
Violation cited:
no
Narrative:
On 08/13/21 at approximately 14:15 I responded to #260 Needham St.-Marshalls for a past H&R M.V.. Upon arrival I spoke with the owner of veh #1 who is an employee of Marshalls. She stated she parked her vehicle at approximately 09:00 this morning and when she finished her shift at approximately 14:15, she saw the passenger side rear quarter had been struck. It appears as if a small white colored car struck her parked vehicle while it was either pulling in or out. Owner of veh#1 stated she checked with her manager who told her there are no cameras in the area of the parking lot. Minor damage to veh #1.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3088013
Longitude:
-71.2144481
Location:
260 Needham 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 271.97ms