{"id":"ch.astra.unfaelle-personenschaeden_alle","name":"Accidents with personal injury","fields":[{"name":"accidenthour","type":"VARCHAR","alias":"Hour of accident","values":["06","12","16","17","22"]},{"name":"canton","type":"VARCHAR","alias":"Canton","values":["AG","BE","SG","VD","ZH"]},{"name":"severitycategorycode","type":"VARCHAR","alias":"Code - Unfallschwerekategorie","values":["as2","as3"]},{"name":"accidenttypecode","type":"INTEGER","alias":"Code - Unfalltyp","values":["at0","at1","at2","at3","at4"]},{"name":"accidenthour_text","type":"VARCHAR","alias":"Hour of accident","values":["06h-07h","12h-13h","16h-17h","17h-18h","22h-23h"]},{"name":"roadtype_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.roadtype_en","values":["Expressway","Minor road","Motorway","Other","Principal road"]},{"name":"accidentyear","type":"INTEGER","alias":"Year of accident","values":[2014,2023,2024]},{"name":"roadtypecode","type":"INTEGER","alias":"Code - Strassenart","values":["rt430","rt431","rt432","rt433","rt439"]},{"name":"accidenttype_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.accidenttype_en","values":["Accident when overtaking or changing lanes","Accident when turning left or right","Accident when turning-into main road","Accident with rear-end collision","Accident with skidding or self-accident"]},{"name":"fsocommunecode","type":"VARCHAR","alias":"Community code (FSO)","values":["0069","0096","0573","3212","5451"]},{"name":"accidentday_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.accidentday_en","values":["Saturday","Sunday","Thursday","Tuesday","Wednesday"]},{"name":"accidentmonth_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.accidentmonth_en","values":["April","August","July","June","November"]},{"name":"severitycategory_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.severitycategory_en","values":["Accident with light injuries","Accident with severe injuries"]}]}