crash_reports

1 row where "date" is on date 2022-05-20 and latitude = "42.3274875"

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

22000431

Date:

2022-05-20

Time:

08:25

Address:

QUINOBEQUIN RD & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

On 5/20/2022 at approx 0825hrs while assigned to 497 I responded to the area of Washington St and Quinobequin Rd for a report of a two car crash with one operator being pregnant. Upon arrival I met with Marlow Hansen who was operating Ma Reg FRMGRL who stated she was taking the right onto Washington St from Quinobequin Rd when she was rear ended by the operator of Ma Reg 6961RC being operated by Jenna Limone. Jenna stated she thought Marlow was going and accidently rear ended her. Both operators signed patient refusals with Fallon Ambulance, minor damage to both vehicles, no tows required.

Keywords:

Crash, Ems

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3274875

Longitude:

-71.2531655

Location:

Quinobequin Rd & Washington St, Newton, MA 02462, 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);