{"id":"ch.astra.unfaelle-personenschaeden_alle","name":"Accidents with personal injury","fields":[{"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,2025]},{"name":"accidenttypecode","type":"INTEGER","alias":"Code - Unfalltyp","values":["at0","at1","at2","at3","at4"]},{"name":"accidenthour","type":"VARCHAR","alias":"Hour of accident","values":["11","12","16","17","22"]},{"name":"accidentmonth_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.accidentmonth_en","values":["August","July","June","November","October"]},{"name":"severitycategorycode","type":"VARCHAR","alias":"Code - Unfallschwerekategorie","values":["as2","as3"]},{"name":"fsocommunecode","type":"VARCHAR","alias":"Community code (FSO)","values":["0069","0096","0573","4566","5451"]},{"name":"accidentday_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.accidentday_en","values":["Saturday","Sunday","Thursday","Tuesday","Wednesday"]},{"name":"canton","type":"VARCHAR","alias":"Canton","values":["BE","SG","TG","VD","ZH"]},{"name":"accidenthour_text","type":"VARCHAR","alias":"Hour of accident","values":["11h-12h","12h-13h","16h-17h","17h-18h","22h-23h"]},{"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":"roadtypecode","type":"INTEGER","alias":"Code - Strassenart","values":["rt430","rt431","rt432","rt433","rt439"]},{"name":"severitycategory_en","type":"VARCHAR","alias":"ch.astra.unfaelle-personenschaeden_alle.severitycategory_en","values":["Accident with light injuries","Accident with severe injuries"]}]}