crash_reports

1 row where "date" is on date 2022-06-25, "retrieved" is on date 2022-07-26 and speed_limit = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

22000565

Date:

2022-06-25

Time:

16:57

Address:

71 NEEDHAM ST

Speed limit:

15

Violation cited:

no

Narrative:

MV1 operator states she was inside of 71 Needham St with MV1 parked in the back parking lot around 1700 hours. When she came out, she saw that her vehicle had been hit in the front left of her bumper. I observed fresh light damage to MV1s front left bumper. No security cameras were in view of the incident. No tows or injuries reported.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3151251

Longitude:

-71.2109914

Location:

71 Needham St, Newton, MA 02461, 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);