crash_reports

1 row where "datetime" is on date 2019-07-08 and speed_limit = 10

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

1900000695

Date:

2019-07-08

Time:

11:49

Address:

210 NEEDHAM ST

Speed limit:

10

Violation cited:

no

Narrative:

ON 7-8-19 AT APPROX. 1149HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT THE NEWTON POLICE STATION FRONT DESK I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES ON 7-6-19 BETWEEN 1500-1600HRS. WHILE SHE WAS PARKED IN THE PARKING STALL AT 210 NEEDHAM ST. ( HOME GOODS ) SOMEONE HIT THE LEFT REAR QTR. PANEL OF HER VEHICLE CAUSING DAMAGE TO THE FENDER AS WELL AS THE LEFT BRAKE LIGHT. OWNER STATED SHE DELAYED REPORTING THE INCIDENT BECAUSE HER VEHICLE WAS STILL OPERATIONAL. OWNER REPORTED NO INJURIES. WAS ADVISED TO CONTACT HER INSURANCE COMPANY.

Keywords:

Crash

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3107468

Longitude:

-71.2134511

Location:

210 Needham St, Newton, MA 02464, 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);