crash_reports

1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-12-03

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

2100001000

Date:

2021-11-30

Time:

10:10

Address:

292 LANGLEY RD

Speed limit:

30

Violation cited:

no

Narrative:

On November 30, 2021, N524(Ofc. Iarossi) was parked unoccupied at 292 langley Rd(north bound). Motor vehicle 2 Ma Reg 60760 was driving north on Langley Rd. MV2 was traveling/passing too close to N524 and the side view mirrors hit. Ofc. Iarossi was able to stop the MV at 210 Langley Rd and identify the operator. Lawrence Seder stated that he heard something but did not know what had happened. Ofc. Iarossi took pictures and submitted them to IT.

Keywords:

Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3237246

Longitude:

-71.1855347

Location:

292 Langley Rd, Newton, MA 02459, 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);