crash_reports

1 row where "datetime" is on date 2021-02-12, dcc = "[]" and speed_limit = 0

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

2100000111

Date:

2021-02-12

Time:

15:23

Address:

157 HERRICK RD

Speed limit:

0

Violation cited:

no

Narrative:

MV1 was parked off to the shoulder of the roadway inside the parking lot of the Adelaide. Operator of MV1 came out from getting his COVID-19 vaccine and saw his vehicle had suffered front end damage. Operator of MV1 canvassed the area yielding negative results for any vehicle that could have struck his vehicle. Operator of MV1 spoke with the staff from the Adelaide who informed him there are no cameras in the parking lot. Operator of MV1 wanted this hit and run documented.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3255677

Longitude:

-71.1910346

Location:

Farwell Hall, 157 Herrick Rd, Newton Centre, 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);