crash_reports
2 rows where "retrieved" is on date 2021-02-01 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-26
Time:
16:48
Address:
23 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator of MV1 backed into a pole anchor wire in the parking lot behind NewTV causing no damage to the pole and minor damage to the rear bumper of N499.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3163977
Longitude:
-71.2109845
Location:
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);