crash_reports
2 rows where "datetime" is on date 2019-02-06, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-02-06
Time:
09:27
Address:
333 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR WAS OPERATING A TRACTOR TRAILER. HE WAS LOOKING FOR NEEDHAM ST. HIS GPS TOOK HIM UP THE ACCESS ROAD TO 677 WINCHESTER ST. (THE JCC) ONCE UP HERE HE COULD NOT GET OUT. AS HE WAS ATTEMPTING TO TURN AROUND IN THE ROTARY, HE ACCIDENTALLY TOOK DOWN A LIGHT POLE ON THE TRAFFIC CIRCLE. NO INJURIES REPORTED.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2993233
Longitude:
-71.2036386
Location:
Case
number:
Date:
2019-02-06
Time:
14:07
Address:
697 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OWNER OF MV 1 STATED SHE PARKED HER 2015 TOYOTA VENZA LEGALLY ON WASHINGTON STREET IN FRONT OF 697 WASHINGTON STREET (GARDEN REMEDIES) AT 10:50 AM TODAY. AT 2:00 PM SHE WENT BACK TO HER VEHICLE AND NOTICED FRESH DAMAGE TO HER FRONT LEFT SIDE OF HER BUMPER. THERE ARE CAMERAS LOCATED OUTSIDE OF 697 WASHINGTON ST AND THE VEHICLE OWNER WHO WORKS AT GARDEN REMEDIES WILL INQUIRE WHETHER OR NOT THE CAMERAS CAPTURE VIDEO NEAR HER VEHICLE. NO NOTE WAS LEFTAND NO WITNESSES TO THE CRASH AT THIS TIME.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3529253
Longitude:
-71.2021966
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);