crash_reports

1 row where "datetime" is on date 2020-07-22, dcc = "["Unknown"]" and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2000000399

Date:

2020-07-22

Time:

19:14

Address:

271 AUBURN ST

Speed limit:

10

Violation cited:

no

Narrative:

MV#1 was parked in a parking lot at 271 Auburn St. The owner of MV#1 stated that while she was in work, her car was struck in the parking lot. She stated that she did not notice the vehicle was damaged until after she left work at 1815 hrs. Owner stated that she did not get any information about the vehicle that stuck hers. She also stated that there are no cameras at her office that would have recorded the incident. MV#1 sustained minor damage to the front drivers side quarter panel of her vehicle.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3465566

Longitude:

-71.2465397

Location:

271 Auburn 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);