crash_reports

1 row where keywords = "["Severe", "Solar"]" and "retrieved" is on date 2021-11-16

✎ 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:

2100000924

Date:

2021-11-09

Time:

16:49

Address:

50 EDDY ST

Speed limit:

25

Violation cited:

no

Narrative:

On 11/9/21 Alexandra Hogan came to NPD Headquarters to report a past mva that occurred at 0730hrs today. Hogan states she was driving southbound on Eddy St in MA reg WS1543 (vehicle #1), when she observed MA reg CI396B (vehicle #2) driving down the middle of the road northbound. Hogan was unable to swerve out of the way and contact was made. She reports extensive damage to the front left side of her vehicle. Operator #2 left her information with Hogan and allegedly stated that the sun was in her eyes. She was apologetic. Attempts to call operator #2 were met with negative results. Hogan reports no injuries but needed documentation for her insurance company.

Keywords:

Severe, Solar

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3513132

Longitude:

-71.2160988

Location:

50 Eddy St, Newton, MA 02460, USA

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);