crash_reports

1 row where "date" is on date 2019-10-27 and speed_limit = 20

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

1900001104

Date:

2019-10-27

Time:

19:49

Address:

181 LEXINGTON ST

Speed limit:

20

Violation cited:

no

Narrative:

Vehicle 1 owner stated that he parked the car in his designated parking spot in the back of 181 Lexington St apartments. He returned home from work around 430pm with no damage on his vehicle. At approximately 1930hrs he went out to take the trash and noticed his vehicle had damage. No note was left with no information on other vehicle. Checked the area with negative results of other vehicles with damage.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3551907

Longitude:

-71.2433377

Location:

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