crash_reports
2 rows where "date" is on date 2019-03-09 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-09
Time:
01:28
Address:
135 WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she parked her vehicle on the street in front of 135 Winchester Street at approximately 8:00pm and when she came out to her vehicle at 1:28am there was damage to the front left fender and tire. No witnesses to the accident. MV1 was disabled due to the damage and towed by Tody's. UPDATE: On 03/10/2019, Timothy Grady came to the Newton Police Station to report he hit a vehicle on Winchester Street. He stated he thought he hit snow, but with the damage on the front right he realized he hit another vehilce and wanted to report it. Grady's statements (date, time, and location) matched with this hit and run. Grady was advised of the process.
Keywords:
Crash, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3154113
Longitude:
-71.209198
Location:
Case
number:
Date:
2019-03-09
Time:
11:30
Address:
108 JACKSON RD
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR#1 REPORTS THAT SHE WAS GOING N/B ON JACKSON RD WHEN SHE OBSERVED VEHICLE #2 BACKING UP IN HER DIRECTION. OPERATOR#1 THEN STOPPED AND ATTEMPTED TO REVERSE HER DIRECTION WHILE BEEPING HER HORN. VEHICLE #2 STILL ENDED UP BACKING INTO HER VEHICLE. OPERATOR #2 REPORTED THAT SHE HAD JUST BACKED OUT OF HER DRIVEWAY TO #108 JACKSON RD TO ALLOW HER MOTHER TO GET HER VEHICLE OUT OF SAME DRIVEWAY. VEHICLE #2 BACKED OUT S/B BUT WAS FACING N/B ON JACKSON RD. SHE FURTHER REPORTED THAT SHE WAS STOPPED PRIOR TO THE CRASH AND VEHICLE#1 DROVE INTO HER VEHICLE AS SHE WAS STOPPED WAITING FOR HER MOM TO BACK OUT OF THE DRIVEWAY. SHE DENIES BACKING UP INTO VEHICLE #1.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3592482
Longitude:
-71.1945851
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);