crash_reports

1 row where "date" is on date 2022-03-23, "datetime" is on date 2022-03-23 and latitude = "42.3306679"

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

22000243

Date:

2022-03-23

Time:

16:44

Address:

2014 WASHINGTON ST

Speed limit:

10

Violation cited:

no

Narrative:

Operator of Vehicle 1 parked Vehicle 1 in the employee lot at Newton Wellesley Hospital. When she came back out to Vehicle 1, she observed damage to the passenger-side corner of the rear bumper with blue paint transfer. She does not know who caused the damage and security do not have cameras in the area. An incident report was completed for this incident (See Report #22010401)

Keywords:

Hospital

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3306679

Longitude:

-71.2477866

Location:

2014 Washington St, Newton, MA 02462, 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);