crash_reports

1 row where "datetime" is on date 2020-09-23, intersection = 0 and "retrieved" is on date 2020-10-14

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2000000551

Date:

2020-09-23

Time:

16:08

Address:

19 WOODBINE ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 (Cataldo Ambulance) travelling North on Woodbine St. struck the driver side mirror and driver side rim of MV2 that was parked on the side of the road. MV1 stated there were vehicles parked on both sides of the street. Pictures of the road and of the damage of both vehicles were taken and sent to the IT Bureau to be attached to this report. Driver of MV 1 stated he was unsure if the damage on the vehicle was old or new. Owner of MV 2 was on scene and was given a crash report number for insurance purposes.

Keywords:

Crash, Ems, Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3463429

Longitude:

-71.2517603

Location:

19 Woodbine St, Auburndale, MA 02466, 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);