crash_reports

1 row where "datetime" is on date 2021-04-27, intersection = 0 and "retrieved" is on date 2021-04-28

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

2100000289

Date:

2021-04-27

Time:

15:54

Address:

33 AUSTIN ST

Speed limit:

10

Violation cited:

no

Narrative:

Ms. Samantha Mirrer stated that she left her vehicle in the Star Market parking lot at 33 Austin St. She returned to find that the vehicle had been struck on the driver's side. Of yet, the other vehicle is unknown. Star Market has video surveillance of the parking lot, however the view of Ms. Mirrer's vehicle is blocked, and license plates are unable to be made out.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3498004

Longitude:

-71.2087985

Location:

33 Austin St, Newton, MA 02460, 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);