crash_reports
1 row where dcc = "["Unknown"]" and "retrieved" is on date 2021-02-01
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-27
Time:
12:29
Address:
239 WATERTOWN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 1-27-21 AT APPROX. 1229HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 239 WASHINGTON ST. ( ST. JEANS HOUSING ).I SPOKE TO THE OWNER OF VEHICLE #1 ( MARIO SALVUCCI ). OWNER STATES SOMETIME BETWEEN 0800 AND 1229HRS. SOMEONE HIT THE REAR RIGHT QTR. PANEL OF HIS MOTOR VEHICLE WHILE IT WAS PARKED IN THE ST JEANS PARKING LOT. THERE WERE SCRAPES TO THE VEHICLES RIGHT REAR QTR. PANEL CONSISTENT WITH A VEHICLE THAT WAS BACKING OUT OF THE NEIGHBORING STALL. THERE WAS NO OTHER VEHICLE IN THE STALL AT THE TIME OF THIS REPORT. OWNER STATES HE BELIEVES HE KNOWS WHO WAS PARKED THERE AND IS GOING TO QUESTION HIM LATER THIS EVENING. OWNER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3616456
Longitude:
-71.1960462
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);