{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["General Farm Data"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"General Farm Data","index":0,"n_rows":232,"n_cols":9,"rows_kept":232,"merged":[[1,0,14,0],[15,0,46,0],[15,1,20,1],[15,2,20,2],[15,3,20,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[25,1,27,1],[25,2,27,2],[25,3,27,3],[36,2,38,2],[36,3,38,3],[41,1,45,1],[41,2,45,2],[41,3,45,3],[47,0,60,0],[50,1,52,1],[50,2,52,2],[50,3,52,3],[61,0,77,0],[62,1,63,1],[62,2,63,2],[62,3,63,3],[66,1,68,1],[66,2,68,2],[66,3,68,3],[70,1,71,1],[70,2,71,2],[70,3,71,3],[78,0,114,0],[80,1,81,1],[80,2,81,2],[80,3,81,3],[83,1,91,1],[83,2,91,2],[83,3,91,3],[84,8,91,8],[93,1,96,1],[93,2,96,2],[93,3,96,3],[97,1,98,1],[97,2,98,2],[97,3,98,3],[106,1,109,1],[106,2,109,2],[106,3,109,3],[110,1,112,1],[110,2,112,2],[110,3,112,3],[113,1,114,1],[113,2,114,2],[113,3,114,3],[115,0,154,0],[115,1,125,1],[115,2,125,2],[115,3,125,3],[126,1,137,1],[126,2,137,2],[126,3,137,3],[138,1,143,1],[138,2,143,2],[138,3,143,3],[144,1,149,1],[144,2,149,2],[144,3,149,3],[155,0,182,0],[155,6,182,6],[183,0,202,0],[185,1,187,1],[185,2,187,2],[185,3,187,3],[197,1,198,1],[197,2,198,2],[197,3,198,3],[199,1,200,1],[199,2,200,2],[199,3,200,3],[201,1,202,1],[201,2,202,2],[201,3,202,3],[203,0,231,0],[230,1,231,1],[230,2,231,2],[230,3,231,3]],"flags":["formulas_cached_only"]}
["Category","ID in Questionnaire","Original German question","English translation","Explanatory variable","Variable type","Included in final analysis","Reason for exclusion","* Comments"]
["General farm data",1,"Höchste Ausbildung des Betriebsleiters","Highest educational degree of the farmer","Educational background of farmer","Categorical","No","Considered as irrelevant for PWD"]
[null,2,"Jahre der Berufserfahrung","Years of working experience of the farmer","Years of experience","Metric","No","Considered as irrelevant for PWD"]
[null,3,"Betreuungstierarzt","Attending herd veterinarian","Herd veterinarian","Categorical","No","Number of observations for one factor level < 10"]
[null,4,"Betriebsart","Farming system","Ecological farming","Categorical","No","Number of observations for one factor level < 10"]
[null,5,"Betriebssystem","Production system","Production system","Categorical","No","Considered as irrelevant for PWD"]
[null,6,"Anzahl der Zuchtsauen","Number of sows","Number of sows","Metric","No","Collinearity with \"feeding system\""]
[null,7,"Herkunft des Samens","Origin of the semen","Origin of semen","Categorical","No","Considered as irrelevant for PWD"]
[null,8,"Remontierungsrate","Replacement rate of sows","Replacement rate of sows","Metric","No","Collinearity with \"rearing own gilts\""]
[null,9,"Eigenremontierung","Rearing of own gilts","Rearing of own gilts","Categorical","Yes"]
[null,10,"Lebendgeborene Ferkel / Wurf","Liveborn piglets / litter","Liveborn piglets / litter","Metric","No","Collinearity with \"weaned piglets / sow / year\""]
[null,11,"Abgesetzte Ferkel / Sau / Jahr","Weaned piglets / sow / year","Weaned piglets / sow / year","Metric","No","Collinearity"]
[null,12,"Produktions/Einstallrhythmus","Batch system","Batch system","Categorical","No","Number of observations for one factor level < 10"]
[null,13,"PRRS-Status","PRRS status","PRRS status","Categorical","No","Considered as irrelevant for PWD"]
[null,14,"Wurden im Laufe des letzten Jahres größere betriebliche Änderungen vorgenommen","Were there any major changes within the previous year?","Changes within the year prior to data collection","Categorical","No","Number of observations for one factor level < 10"]
["Suckling piglet period",15,"Welche gesundheitlichen Probleme bestanden bei Saugferkeln ","Which health problems of suckling piglets did you frequently observe within the last year","Neonatal diarrhoea","Categorical","Yes"]
[{"$nulls":4},"Arthritis","Categorical","No","Considered as irrelevant for PWD"]
[{"$nulls":4},"Central nervous disease","Categorical","No","Considered as irrelevant for PWD"]
[{"$nulls":4},"Exudative epidermitis","Categorical","No","Considered as irrelevant for PWD"]
[{"$nulls":4},"Coughing","Categorical","No","Considered as irrelevant for PWD"]
[{"$nulls":4},"Weak born piglets","Categorical","No","Considered as irrelevant for PWD"]
[null,16,"An welchem Lebenstag trat Saugferkeldurchfall vor allem auf?","On what day of life does neonatal diarrhoea occur most frequently?","Day of life ND","Metric","No","Missing data (Subquestion)"]
[null,17,"Wenn ja: waren vermehrt Jungsauenwürfe betroffen?","Are litters of gilts predominantly affected by neonatal diarrhoea?","Litters of gilts ND","Categorical","No","Missing data (Subquestion)"]
[null,18,"Trat Saugferkeldurchfall bei bestimmten Gruppen / Stallbereichen auf?","Did neonatal diarrhoea occur especially in certain areas of the farrowing units / certain farrowing groups?","Other groups ND","Categorical","No","Missing data (Subquestion)"]
[null,19,"Wenn ja, in welchen Bereichen / bei welchen Gruppen?","If yes, which groups / areas were affected?"]
[null,20,"Wurden in den letzten zwölf Monaten Saugferkel versetzt?","Were suckling piglets transferred to other sows etc. within the last twelve months?","Transfer piglets","Categorical","No","Collinearity with \"cross fostering\""]
[{"$nulls":4},"Nurse sows","Categorical","Yes"]
[{"$nulls":4},"Rescue decks","Categorical","No","Number of observations for one factor level < 10"]
[null,21,"Wohin wurden Ferkel versetzt?","Where are suckling piglets transferred to?","Cross fostering","Categorical","Yes"]
[null,22,"Welche Ferkel wurden versetzt?","Which suckling piglets do you transfer?","Which piglets transferred","Categorical","No","Missing data (Subquestion)"]
[null,23,"Welche Nachteile sehen Sie im Versetzen von Saugferkeln?","What are the disadvantages of transferring suckling piglets?","Disadvantages transfer","Categorical","No","Missing data (Subquestion)"]
[null,24,"Bis wann wurde versetzt?","Until what day of life do you transfer suckling piglets?","Day of transfer","Ordinal","No","Missing data (Subquestion)"]
[null,25,"Bei wie viel Prozent aller Sauen einer Abferkelgruppe wurden Ferkel versetzt?","In how many percent of all litters did transfer of piglets occur?","Percent litters transfer","Ordinal","No","Missing data (Subquestion)"]
[null,26,"Wurde in den letzten zwölf Monaten Prästarter in der Saugferkelphase verabreicht?","Did you use creep feeding?","Number of creep feeding phases","Metric","No","Collinearity with \"number of feeding phases\""]
[null,27,"Wenn ja, ab welchem Lebenstag?","If yes, from what day onwards?","Creep feeding first day of administration","Metric","No","Missing data (Subquestion)"]
[null,28,"Welcher Prästarter wurde verabreicht?","What product did you administer for creep feeding?","Product of creep feeding","Categorical","No","Missing data (Subquestion)"]
[null,null,"Komponenten (Inhaltsstoffe & Makronährstoffe) des Prästarter","What are the components of creep feeding?","Major starch source","Categorical","No","Collinearity with \"fibre in creep feeding\""]
[{"$nulls":4},"Major protein source","Categorical","No","Collinearity with \"fibre in creep feeding\""]
[null,29,null,null,"Fibre in creep feeding","Categorical","Yes"]
[null,30,"Wurde Prästarter auch nach dem Absetzen noch mitverfüttert?","Did you also administer creep feeding after weaning?","Creep feeding after weaning","Categorical","No","Collinearity with \"fibre in creep feeding\""]
[null,31,"Wenn ja, für wie viele Tage?","If yes, for how many days","Creep feeding days after weaning","Metric","No","Missing data (Subquestion)"]
[null,32,"Werden zusätzlich andere Futtermittel während der Saugferkelphase angeboten?","What other supplements were administered during suckling piglet period","Milk substitution","Categorical","Yes"]
[{"$nulls":4},"Muesli","Categorical","Yes"]
[{"$nulls":4},"Commercial peat*","Categorical","Yes",null,"*Variable was combined with administration of commercial peat AFTER weaning"]
[{"$nulls":4},"Booster/Electrolytes/Glucose*","Categorical","Yes",null,"*Variable was combined with administration of booster/electrolytes/glucose  AFTER weaning"]
[{"$nulls":4},"Coke*","Categorical","Yes",null,"*Variable was combined with \"phosphoric acid\" to \"coke, phosporic acid\""]
[null,33,"Wenn ja, bitte um Angabe des Produktnamens","Product name of supplement","Product name of supplement","Categorical","No","Missing data (Subquestion)"]
["Weaning Management",34,"Alter der Ferkel zum Absetzzeitpunkt","Age of piglets at weaning","Age at weaning (days)","Metric","Yes"]
[null,35,"Zu/Verkauf von Babyferkeln","Selling / Purchase of four-week old piglets","Selling/Purchase of piglets","Categorical","No","Number of observations for one factor level < 10"]
[null,36,"Ungefähre Anzahl der verkauften / zugekauften Ferkel pro Absetzgruppe","Estimated number of sold / purchased piglets per group","N (sold/purchased piglets)","Metric","No","Missing data (subquestion)"]
[null,37,"Zum Absetzzeitpunkt war das gesamte Abteil immer ausnahmslos unbesetzt","Are the nursery units completely empty, whenever the next weaned piglets are transferred into the respective nursery unit?","Weaning in farrowing units","Categorical","Yes"]
[{"$nulls":4},"Split weaning","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"All in - all out in nursery units","Categorical","Yes"]
[null,38,"Wie viele Tage/Stunden steht das Abteil zwischen zwei Belegungen leer?","For how many hours are the nursery units empty?","Hours - empty nursery units","Metric","No","Missing data (subquestion)"]
[null,39,"Durchschnittsgewicht zum Absetzzeitpunkt","Estimated weight of piglets at weaning","Weight of piglets","Metric","No","Missing data"]
[null,40,"Wurfweises Absetzen","Grouping of weaned piglets","Grouping of weaned piglets","Categorical","Yes"]
[null,41,"Wenn ja, wie viele Würfe kommen gemeinsam in dieselbe Bucht?","If yes, how many litters are transferred into one pen?","N (Litters/Pen)","Metric","No","Missing data (subquestion)"]
[null,42,"Wenn nein, wonach wird sortiert?","If no, how do you sort the piglets?","Way of sorting","Categorical","No","Missing data (subquestion)"]
[null,43,"Rücksetzen von Kümmerern","Do you transfer wasting piglets to younger groups?","Weak piglets transferred younger groups","Categorical","No","Considered as irrelevant for PWD (happens too late)"]
[null,44,"Wurden in der Aufzucht Neugruppierungen durchgeführt","Do you mix piglets from different pens during the nursery period?","Mixing of piglets","Categorical","No","Considered as irrelevant for PWD (happens too late)"]
[null,45,"Was passierte beim Absetzen mit besonders schwachen/kleinen Ferkeln?","What happens to piglets which are particularly weak at weaning?","Hospital pens","Categorical","Yes"]
["Housing",46,"Aufstallungsart(en) in der Aufzucht","Housing system of nursery piglets","Housing system","Categorical","No","Collinearity with \"Fully slatted floors\""]
[null,47,"Art des Bodens und dessen Beschaffenheit in der Aufzucht","Floor system (Slats & Material)","Fully slatted floors*","Categorical","Yes",null,"Farms with partially slatted floors and farms with only solid floor were grouped together"]
[{"$nulls":4},"Plastic or metal floors","Categorical","Yes"]
[null,48,"Vorhandene Strukturelemente der Buchten","Structure elements in nursery pens","Structure elements","Categorical","No","Collinearity with \"Microclimate zones\""]
[null,49,"Welche Art(en) von Beschäftigungsmaterial wird (werden) in der Aufzucht angeboten?","What kind of enrichment material is used in the nursery units?","Enrichment material","Categorical","Yes"]
[null,50,"Art der Heizung in der Aufzucht","Which heating system is used in the nursery units?","Heating system (yes/no)?","Categorical","No","Collinearity with \"Heating of nursery units before weaning\""]
[{"$nulls":4},"Microclimate zones","Categorical","Yes"]
[{"$nulls":4},"Heated surfaces","Categorical","No","Collinearity with \"Microclimate zones\""]
[null,51,"Wärmeerzeugung","Way of heat generation","Heat generation","Categorical","No","Considered as irrelevant for PWD"]
[null,52,"Auf welche Zieltemperatur wird im Flat Deck vor dem Absetzen geachtet?","Do you heat the nursery unit before weaning?","Heating nursery before weaning","Categorical","Yes"]
[{"$nulls":4},"Temperature (°C)","Metric","No","Missing data (subquestion)"]
[null,53,"Anzahl der Absetzabteile (Kammern) im Betrieb","Total number of nursery units on the farm","N (Nursery units)","Metric","No","Considered as irrelevant for PWD"]
[null,54,"Anzahl der Absetzbuchten/Abteil","Number of pens / nursery unit","Pens per nursery unit","Metric","No","Considered as irrelevant for PWD"]
[null,55,"Anzahl der Würfe/Absetzbucht","Number of litters / pen (in case of litter wise weaning)","Litters per pen ","Metric","No","Missing data (subquestion)"]
[null,56,"Anzahl der Tiere /Absetzbucht","Number of piglets / pen","Piglets per pen","Metric","Yes"]
[null,57,"Bleiben die Ferkel nach dem Absetzen bis zum Verkauf in dieser Bucht?","Do piglets remain in the same pen for the whole nursery period?","Piglets remain in pens","Categorical","No","Considered as irrelevant for PWD (happens too late)"]
[null,"153 (last page!)","Größe von einer Bucht, in der sich Absetzferkel befinden","Size of one pen in the nursery unit","Square meters per piglet*","Metric","Yes",null,"*Size of one pen divided by the number of piglets per pen"]
["Feed & feeding managment",58,"Bekamen/bekommen die Ferkel zum Zeitpunkt des Absetzens ein eigenes Absetzfutter?","Did/do piglets get a special weaner diet?","Weaner diet","Categorical","No","Collinearity with \"number of feeding phases\""]
[null,59,"Ab welchem Tag bekommen die Ferkel den Absetzstarter?","On what day prior/after weaning do piglets first receive that weaner diet?","Weaner diet before weaning","Categorical","Yes"]
[null,60,"Der Absetzstarter wird für ___ Tage alleine eingesetzt und danach für ___ Tage verschnitten"," Weaner diet is only fed for ___ days. Then it is mixed with feed of the consecutive phase for ___ days.","Only weaner diet (d)","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[{"$nulls":4},"Mixed with next phase (d)","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[null,61,"Hofeigene Anteile des Absetzstarters","Ingredients produced on-site","Produced on-site","Categorical","No","Number of observations for one factor level < 10"]
[null,62,"Zugekaufte Anteile des Absetzstarters (Produkt)","Purchased ingredients (product)","Purchased ingredient","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"Wheat, rye, triticale*","Categorical","Yes",null,"Variables were evaluated based on knowledge on ingredients being benificial to prevent PWD. Variables are based on ingredients of the weaner diet, which were produced on-site (Question 61) and ingredients contained in the purchased product (Question 62)  "]
[{"$nulls":4},"Main protein source*","Categorical","Yes"]
[{"$nulls":4},"Main soy processing method*","Categorical","Yes"]
[{"$nulls":4},"Potato protein*","Categorical","Yes"]
[{"$nulls":4},"Linseed, chicory*","Categorical","Yes"]
[{"$nulls":4},"Oats*","Categorical","Yes"]
[{"$nulls":4},"Wheat bran*","Categorical","Yes"]
[{"$nulls":4},"Cellulose*","Categorical","Yes"]
[null,63,"Anteile (%) des Absetzstarters: Mais (%), Gerste (%), Präparat (%), Faserergänzer (%), Weizen (%), Andere (%)","Amount (%) of corn (%), barley (%), product (%), fibre supplement (%), wheat (%), others (%) ","Main starch source*","Categorical","Yes",null,"Bases on the values of \"Corn (%)\" and \"Barley (%)\""]
[null,64,"Futtermittelanalyse des Absetzstarters","Nutrients of weaner diet","Crude protein (g/kg DM)","Metric","Yes"]
[{"$nulls":4},"Crude Fibre (g/kg DM)","Metric","Yes"]
[{"$nulls":4},"Lysine (g/kg DM)","Metric","No","Collinearity with \"crude proteine (g/kg DM)\""]
[{"$nulls":4},"Methionine /cysteine (g/kg DM)","Metric","No","Missing data"]
[{"$nulls":4},"Moist or dry feed","Categorical","No","Collinearity with \"automatic feeding\""]
[{"$nulls":4},"Automatic feeding","Categorical","Yes"]
[null,69,"Werden zum Absetzen andere Maßnahmen getroffen, um die Futteraufnahme der Ferkel nach dem Absetzen anzuregen?","What other measures are taken in order to stimulate feed intake?","Stimulation of feed intake","Categorical","Yes"]
[null,70,"Wenn ja, welche?","If yes, what measures are taken?","Measures of stimulation","Categorical","No","Missing data (subquestions)"]
[null,71,"Das Aufzuchtfutter 1 wird ab dem ___ Tag nach dem Absetzen eingesetzt","Nursery feed is used from day ___ after weaning onwards","Nursery Feed used on day","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[null,72,"Art der Fütterung","Feeding System","Feeding system II","Categorical","No","Considered as irrelevant for PWD (happens too late)"]
[null,73,"Hofeigene Anteile des Aufzuchtfutters","Ingredients produced on-site","Produced on-site (nursery feed)","Categorical","No","Considered as irrelevant for PWD (happens too late)"]
[null,74,"Zugekaufte Anteile des Aufzuchtfutters ","Purchased ingredients (product)","Purchased ingredient (nursery feed)","Categorical","No","Considered as irrelevant for PWD (happens too late)"]
[null,75,"Rezeptur (%) des Aufzuchtfutters Mais (%), Gerste (%), Präparat (%), Faserergänzer (%), Weizen (%), Andere (%)","Amount (%) of corn (%), barley (%), product (%), fibre supplement (%), wheat (%), others (%) ","*","Metric","No","Considered as irrelevant for PWD (happens too late)","Various variables including amount of corn, barley, wheat, soy, fibre supplement and mineral supplement"]
[null,76,"Futtermittelanalyse des Aufzuchtfutters","Analyse of nursery diet","Crude protein (g/kg DM)","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[{"$nulls":4},"Crude Fibre (g/kg DM)","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[{"$nulls":4},"Lysine (g/kg DM)","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[{"$nulls":4},"Methionine /cysteine (g/kg DM)","Metric","No","Considered as irrelevant for PWD (happens too late)"]
[null,77,"Besonderheiten im Fütterungsmanagement (Übergangsfutter etc.)","Particular feeding management (transitional food etc.)","Transitional food 1*","Categorical","No","Collinearity with \"Number of feeding phases\"","Transitional feeding phase between creep feeding and weaning diet"]
[{"$nulls":4},"Transitional food 2*","Categorical","No","Collinearity with \"Number of feeding phases\"","Transitional feeding phase between weaning diet and nursery diet"]
[{"$nulls":4},"Number of phases*","Metric","Yes",null,"Sum of all feeding phases from birth until 21 days after weaning (This includes the variables \"Number of creep feeding phases\", \"transitional food 1\", \"weaning diet\" and \"transitional food 2\")"]
[null,"78 (last page!)","Gesamte Fressplatzlänge der Futterautomaten/Tröge in einer Bucht","Total length of troughs and automatic feeders","Feeding space (cm)","Metric","No","Collinearity with \"feeding space (cm) per piglet\""]
[{"$nulls":4},"Feeding space (cm) per piglet*","Metric","Yes",null,"\"Feeding space (cm)\" divided by \"number of piglets per pen\""]
["Feed additives & prevention",65,"Futterzusätze (Säuren, Probiotika, pflanzliche Zusätze)","Feed additives (acids, probiotics, plant based)","Formiate, acetate or propionate","Categorical","Yes"]
[{"$nulls":4},"Citric acid","Categorical","Yes"]
[{"$nulls":4},"Lauric acid","Categorical","Yes"]
[{"$nulls":4},"Lactic acid","Categorical","Yes"]
[{"$nulls":4},"Benzoic acid","Categorical","Yes"]
[{"$nulls":4},"Sorbic acid","Categorical","Yes"]
[{"$nulls":4},"Phosphoric acid --> \"coke & phosphoric acid\"*","Categorical","Yes"]
[{"$nulls":4},"Probiotics","Categorical","Yes"]
[{"$nulls":4},"Horseradish","Categorical","Yes"]
[{"$nulls":4},"Other herbs","Categorical","Yes"]
[{"$nulls":4},"Seaweed","Categorical","No","Number of observations for one factor level < 10"]
[null,66,"Andere Maßnahmen, die getroffen wurden, um Absetzdurchfall zu verhindern","Other measures to prevent PWD","Enzymes","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"Commercial Peat*","Categorical","Yes",null,"*Variable was combined with administration of commercial peat BEFORE weaning"]
[{"$nulls":4},"Booster/Electrolytes/Glucose*","Categorical","Yes",null,"*Variable was combined with administration of booster/electrolytes/glucose  BEFORE weaning"]
[{"$nulls":4},"Coal","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"Apple pomace","Categorical","Yes"]
[{"$nulls":4},"Dairy products","Categorical","Yes"]
[{"$nulls":4},"Rock salt","Categorical","Yes"]
[{"$nulls":4},"Yeast","Categorical","Yes"]
[{"$nulls":4},"Tannins","Categorical","Yes"]
[{"$nulls":4},"Vitamin E / Selene","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"NSAIDs","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"Dried pulp","Categorical","No","Number of observations for one factor level < 10"]
[null,146,"Sauenimpfungen","Vaccinations of sows","Vaccination against PRRSV","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against PPV & Erysipelothrix rhusiopathiae","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against PCV2","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against Influenza A Virus","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against APP","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against E. coli & C. perfringens","Categorical","No","Collinearity with \"neonatal diarrhoea\""]
[null,147,"Ferkelimpfungen","Vaccinations of piglets","Vaccination against Mycoplasma hyopneumoniae","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against PCV2","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against PRRSV","Categorical","No","Considered as irrelevant for PWD "]
[{"$nulls":4},"Vaccination against Lawsonia intracellularis","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"Vaccination against Shiga toxin","Categorical","No","Number of observations for one factor level < 10"]
[{"$nulls":4},"Vaccination against ETEC","Categorical","No","Number of observations for one factor level < 10"]
[null,148,"Parasitenbekämpfung - Welche Altersgruppe(n)?","Which age groups are treated with anthemintics?","Age groups treated with anthelmintics","Categorical","No","Considered as irrelevant for PWD "]
[null,149,"Wann (Ferkel) vor/nach dem Absetzen?","Anthelmintic treatment regime of piglets","Anthelmintic treatment regime of piglets","Metric","No","Considered as irrelevant for PWD "]
[null,150,"Welches Präparat wurde eingesetzt?","Products used for anthelmintic treatment of piglets","Product for anthelmintic treatment of piglets","Categorical","No","Considered as irrelevant for PWD "]
[null,151,"Regime - Sauen","Anthelmintic treatment regime of sows","Anthelmintic treatment regime of sows","Categorical","No","Considered as irrelevant for PWD "]
[null,152,"Toltrazuril/Kokzidienprophylaxe","Administration of anticoccidials","Anticoccidials","Categorical","Yes"]
["PWD and treatments",79,"Wurde im letzten Jahr Zinkoxid eingesetzt?","Was zinc oxide administered last year?","Treatment with zinc oxide","Categorical","The purpose of variables belonging to this category was not to be included in the risk evaluation but rather to describe the frequency of PWD an zinc oxide usage "]
[null,80,"Wenn ja, welche Tiere wurden behandelt","If yes, which piglets were treated?","Piglets treated with zinc oxide","Categorical"]
[null,81,"Bei wie viel Prozent der Absetzgruppen wurde Zinkoxid eingesetzt?","How many percent of weaned groups were treated with zinc oxide?","Percent of treated groups","Ordinal"]
[null,82,"Auf welcher Grundlage wurde die Entscheidung zur Behandlung gefällt?","Decision for treatment was done based on?","Reason of treatment","Categorical"]
[null,83,"Welches Präparat wurde verwendet?","What product was used?","Product zinc oxide","Categorical"]
[null,84,"Wie wurde Zinkoxid eingesetzt?","How was zinc oxide administered?","Administration of zinc oxide","Categorical"]
[null,85,"In welcher Dosierung wurde Zinkoxid eingesetzt","Dosage of zinc oxide","Dosage of zinc oxide","Categorical"]
[null,86,"Ab welchem Tag vor/nach dem Absetzen wurde Zinkoxid eingesetzt","Zinc oxide was administered from what day before/after weaning onwards","First day of zinc oxide treatment","Metric"]
[null,87,"Für die Dauer von wie vielen Tagen wurde es eingesetzt?","For how many days was zinc oxide administered?","Duration of zinc oxide treatment","Metric"]
[null,88,"Der Einsatz von Zinkoxid kann zur Entwicklung von Antibiotikaresistenzen führen","Can the usage of zinc oxide lead to antimicrobial resistances?","Q1 antimicrobil resistance","Categorical"]
[null,89,"Zinkoxid ist das ideale Mittel zur Behandlung von Zinkmangelerscheinungen","Is zinc oxide the perfect remedy for treatment of zinc deficiency?","Q2 zinc deficiency","Categorical"]
[null,90,"Der Einsatz von Zinkoxid wird ab 2022 in der EU verboten","Will the usage of zinc oxide be forbidden by 2022?","Q3 zinc ban","Categorical"]
[null,91,"Bestand im letzten Jahr ein Problem (> 10% aller Gruppen) mit Absetzdurchfall","Did PWD occur (>10% of weaned groups) within the last twelve months?","PWD yes no","Categorical"]
[null,92,"Wie viel Prozent aller Absetzgruppen waren im letzten Jahr von Absetzdurchfall betroffen?","How many percent of weaned groups were affected with PWD last year?","Percent PWD","Ordinal"]
[null,93,"Wurde E. coli vom Kot/Darm der Absetzgruppen im Labor nachgewiesen?","Was E. coli detected from faecal or jejunal samples of weaned piglets?","E. coli detected","Categorical"]
[null,94,"Am wievielten Tag nach dem Absetzen trat der Durchfall meistens auf?","On what day did PWD occur most frequently?","Day PWD","Metric"]
[null,95,"Wie lange dauerte der Durchfall","How long did PWD last?","Duration PWD","Metric"]
[null,96,"Wurde aufgrund eines Bestandsproblemes mit Absetzdurchfall ein Antibiotikum nach erfolgtem Erregernachweis inkl. Resistenztest regelmäßig eingesetzt?","Did you regularly apply antimicrobials based on antimicrobial resistance testing in order to treat PWD, which is considered as a herd problem","Antimicrobials regularly","Categorical"]
[null,97,"Wenn ja, welche Tiere wurden behandelt","If yes, which piglets were treated?","Antimicrobials which piglet treated","Categorical"]
[null,98,"Wie viel Prozent der Absetzgruppen wurden antibiotisch behandelt?","How many percent of weaned groups were treated with antimicrobials","Percent antimicrobials","Ordinal"]
[null,99,"Wenn ja, welches Präparat?","What product was used?","Product antimicrobials","Categorical"]
[null,100,"Wie wurde das Antibiotikum eingesetzt?","How was the antimicrobial administered?","Administration of antimicrobials","Categorical"]
[null,101,"Ab welchem Tag vor/nach dem Absetzen wurde das Antibiotikum eingesetzt","The antimicrobial was administered from what day before/after weaning onwards  ","Antimicrobials day of administration","Metric"]
[null,102,"Für die Dauer von wie vielen Tagen wurde es eingesetzt?","For how many days was it administered?","Antimicrobials animals treated","Metric"]
[null,103,"Welches Therapeutikum wurde zur Therapie von stark erkrankten Tieren in Einzelfällen gewählt?","What treatment was used to treat heavily diseased piglets?","Antimicrobials diseased piglets","Categorical"]
[null,104,"Wie wurde das Antibiotikum eingesetzt?","How was the antimicrobial administered?","Administration of antimicrobials heavy diseased","Categorical"]
[null,105,"Für die Dauer von wie vielen Tagen wurde es eingesetzt?","For how many days was it administered?","Duration of administration","Metric"]
[null,67,"Wie oft tritt Absetzdurchfall seit der Umsetzung dieser Maßnahmen noch auf?","How often does PWD occur after implementation of those measures","PWD after implementation","Categorical"]
["Water supply",106,"Trinkwasserquelle","Water source","Water source","Categorical","Yes"]
[null,107,"Wurde im Zuge der letzten Trinkwasseruntersuchung (< 1 Jahr) eine erhöhte Keimzahl nachgewiesen?","Was the number of bacteria increased in the last examination of drinking water (< 1 year)","Bacteria in water","Categorical","No","Missing data "]
[null,108,"Was war im Zuge der letzten chemischen Trinkwasseruntersuchung erhöht?","What are the chemical deviations of your drinking water?","Calcareous water","Categorical","Yes"]
[{"$nulls":4},"High amount of iron","Categorical","No","Considered as irrelevant for PWD"]
[{"$nulls":4},"High amount of manganese","Categorical","No","Considered as irrelevant for PWD"]
[null,109,"Befinden sich Brauchwasserbehältnisse am Betrieb?","Are water basins included to the water distribution system?","Water Basin","Categorical","No","Missing data"]
[null,110,"Wie oft wurden 2019 die Leitungen gereinigt","How frequently did you clean the water pipes last year?","Cleaning of water pipes","Categorical","No","Number of observations for one factor level < 10"]
[null,111,"Wie oft wurden 2019 die Leitungen desinfiziert","How frequently did you disinfect the water pipes last year?","Disinfection of water pipes","Categorical","Yes"]
[null,112,"Womit wurde desinfiziert","Which substance is used for disinfection of water pipes?","Substance for water pipe disinfection","Categorical","No","Missing data (Subquestion)"]
[null,113,"Welches Leitungssystem wird für die Aufzucht verwendet?","Which water distribution system is used in the nursery","Looped water distribution system","Categorical","Yes"]
[null,114,"Durchmesser der Rohrleitungen in der Aufzucht (geschätzt)?","Diameter of water pipes in the nursery (estimated)?","Diameter of water pipes in nursery","Categorical","Yes"]
[null,115,"Werden die Leitungen vor jeder Neubelegung so lange gespült, bis frisches Wasser nachkommt?","Do you rinse water pipes until you see fresh water, before transfer of piglets?","Rinsing of water pipes","Categorical","Yes"]
[null,116,"Art der Tränken","Kind of drinkers","Drinkers","Categorical","Yes"]
[null,117,"Werden die Nippel extra gereinigt und desinfiziert","Do you additionally clean and disinfect all drinkers?","Cleaning and disinfection of drinkers","Categorical","No","Number of observations for one factor level < 10"]
[null,154,"Anzahl der Nippel / Absetzbucht (Eigenmessung in  \"Problembuchten\")","Counting number of drinkers in two pens","Number of drinkers in pen 1","Metric","No","Collinearity with \"Number of piglets per drinking spot\""]
[{"$nulls":4},"Number of piglets per drinking spot","Metric","Yes",null,"*\"Number of piglets per pen\" divided by \"Number of drinkers in pen 1\""]
[null,155,"Die Fließgeschwindigkeit der Nippeltränken ist subjektiv","Measurement of flow rate of two drinkers","Flow rate of drinker 1","Ordinal","No","Missing data"]
[{"$nulls":4},"Flow rate of drinker 2","Ordinal","No","Missing data"]
[null,156,"Höhe dieser zwei Nippeltränken","Measurement of height of those drinkers","Height of drinker 1","Metric","No","Missing data"]
[{"$nulls":4},"Height of drinker 2","Metric","No","Missing data"]
["Hygiene & Biosecurity",118,"Wie oft wird die Aufzucht gereinigt","How often do you clean the nursery units?","Regular cleaning (--> regular cleaning and disinfection)","Categorical","Yes*",null,"Combined with \"regular disinfection\" to \"regular cleaning and disinfection\""]
[null,119,"Wer reinigt?","Who is cleaning the nursery units?","Person cleaning","Categorical","No","Number of observations for one factor level < 10"]
[null,120,"Womit / wie wird gereinigt?","How do you clean the nursery units?","Cleaning method","Categorical",null,"Considered as irrelevant for PWD"]
[null,121,"Produktname des Seifenmittels","Detergent (product name) ","Usage of detergents","Categorical","Yes*",null,"General usage of detergent (yes/no) was analysed instead of product"]
[null,122,"Wie lange wird eingeweicht?","How long is the detergent soaked?","Soaking time","Metric",null,"Missing data (Subquestion)"]
[null,123,"Wann wird die Aufzucht desinfiziert","When do you disinfect the nursery units?","Regular disinfection (--> reglular cleaning and disinfection)","Categorical","Yes*",null,"Combined with \"regular cleaning to \"regular cleaning and disinfection\""]
[null,124,"Zeitabstand zwischen Reinigung und Desinfektion","Time gap between cleaning and disinfection.","Time between cleaning and disinfection","Metric","No","Missing data (Subquestion)"]
[null,125,"Wird vor der Desinfektion darauf penibel geachtet, ob alles trocken ist?","Do you wait for disinfection until all pens are dry?","Dry pens before disinfection","Categorical","No","Missing data (Subquestion)"]
[null,126,"Name des zur Desinfektion verwendeten Präparates","Product used for disinfection ","Product disinfection","Categorical","No","Missing data (Subquestion)"]
[null,127,"Wird im Zuge der Desinfektion die Lüftung in den leeren Abteilen abgeschaltet?","Do you switch off the ventilation during disinfection of the nursery pens?","Ventilation during disinfection","Categorical","No","Missing data (Subquestion)"]
[null,128,"Wird nach Aufbringen des Desinfektionsmittels darauf geachtet, dass die Flächen feucht bleiben?","Do you pay attention, if surfaces remain wet after applying disinfection?","Wet surfaces during disinfection","Categorical","No","Missing data (Subquestion)"]
[null,129,"Wird berücksichtigt, dass das verwendete Mittel zur adäquaten Desinfektion eine bestimmte Mindesttemperatur benötigt?","Can the minimal temperature needed for proper disinfection be reached?","Minimal temperature for disinfection","Categorical","No","Missing data (Subquestion)"]
[null,130,"In welcher Konzentration / Gesamtvolumen wird das Desinfektionsmittel aufgebracht?","Which concentration / volume is used for disinfection?","Concentration of disinfection","Metric","No","Missing data (Subquestion)"]
[null,131,"Wurde die Gesamtoberfläche, auf der das Desinfektionsmittel aufgebracht wird, berechnet?","Was the total surface for proper application of disinfection calculated?","Total surface calculated","Categorical","No","Missing data (Subquestion)"]
[null,132,"Dauer des Einwirkens des Desinfektionsmittels:","Exposure time ","Exposure time (disinfection)","Metric","No","Missing data (Subquestion)"]
[null,133,"Befinden sich vor den Absetzabteilen Stiefeldesinfektionswannen?","Are disinfection baths for boots provided in front of nursery units?","Disinfection baths","Categorical","Yes*",null,"Combined with \"Separate footwear\" to \"Footwear hygiene\""]
[null,134,"Präparat ","Product used for disinfection baths for boots","Product (disinfection baths)","Categorical","No","Missing data (Subquestion)"]
[null,135,"Wie oft werden diese Wannen gewechselt?","How often do you change the content of those baths?","Changing disinfection baths","Metric","No","Missing data (Subquestion)"]
[null,136,"Verwendung von separatem Schuhwerk für die Aufzucht","Using separate footwear explicitly for nursery units","Separate footwear","Categorical","Yes*",null,"Combined with \"Disinfection baths\" to \"Footwear hygiene\""]
[null,137,"Eigene Geräte (Treibbretter etc.), die ausnahmslos in der Aufzucht verwendet werden","Using separate equipment explicitly for nursery units","Equipment only for nursery units","Categorical","Yes"]
[null,138,"Anzahl der am Betrieb regelmäßig arbeitenden Personen","Number of people working on the farm","Number of employees","Metric","No","Considered as irrelevant for PWD"]
[null,139,"Umkleidemöglichkeit vorhanden","Do you have a separate changing room?","Changing room","Categorical","No","Collinearity with \"hygiene lock\""]
[null,140,"Adäquate Hygieneschleuse vorhanden","Do you have a proper hygiene lock?","Hygiene lock","Categorical","Yes"]
[null,141,"Betriebseigene Kleidung","Do you wear clothes only in the stable","Clothes","Categorical","No","Collinearity with \"hygiene lock\""]
[null,142,"Einduschen vor Betreten des Stalles","Taking a shower before entering the stable","Shower","Categorical","No","Number of observations for one factor level < 10"]
[null,143,"Schadnagerbelastung","Rodent burden","Rodent burden","Categorical","Yes"]
[null,144,"Fliegenbelastung","Fly burden","Fly burden","Categorical","No","Considered as irrelevant for PWD"]
[null,145,"Welche gesundheitlichen Probleme traten bei Sauen auf?","Which diseases of sows were observed?","PDS","Categorical","Yes"]
[{"$nulls":4},"Disorders of the locomotry system","Categorical","No","Considered as irrelevant for PWD"]