Spreadsheet: 49e5bda2-aeb5-4374-8a54-30becc521937
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | BE | BG | CZ | DK | DE | EE | EL | ES | FR | IE | IT | CY | LV | LT | LU | [NAME] | MT | NL | AT | PL | PT | RO | SI | SK | FI | SE | UK | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | EU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENG/W | N-IRL | SCOT
 | Classification
1 | a) No. of participating abattoirs slaughtering > 200 pigs weekly | 25 | 2 | 49 | 16 | 139 | 3 |  | 64 | 72 | 3 |  | 3 | 9 | 18 | 2 | 74 | 1 | 18 | 50 | 243 |  | 52 | 4 | 19 | 7 | 11 | 41 | 3 | 5 |  |  | 933
 | b) No. of participating abattoirs slaughtering 200 or less pigs weekly | 0 | 1 | 21 | 0 | 387 | 1 |  |  | 91 | 0 |  | 0 | 1 |  | 1 | 0 | 1 | 0 | 45 | 11 |  | 53 | 1 | 42 | 1 | 25 | 0 | 1 | 0 |  |  | 683
 | c) No. of abattoirs slaughtering > 200 pigs weekly, not participating in carcass classification | 0 | 1 | 0 | 0 | 0 | 2 |  |  | 0 | 4 |  | 1 | 0 |  | 0 | 0 | 0 | 0 | 0 | 11 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 20
 | Σ in the system | 25 | 3 | 70 | 16 | 526 | 4 | 0 | 64 | 163 | 3 | 0 | 3 | 10 | 18 | 3 | 74 | 2 | 18 | 95 | 254 | 0 | 105 | 5 | 61 | 8 | 36 | 41 | 4 | 5 |  |  | 1616
 | Σ out of the system | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 20
2 | Number of carcasses of pigs classified | 10575411 | 62548 | 2010583 | 20289888 | 55490615 | 298223 |  | 27000000 | 24000000 | 1965000 |  | 675230 | 192078 | 382120 | 90859 | 3409812 | 83140 | 14267175 | 14882 | 16401143 |  | 3077107 | 247000 | 622765 | 2239618 | 2834714 | 2694218 | 1599039 | 591246 |  |  | 191114414
 | a) as % of total slaughtering | 0.8708064866540938 | 0.08694781851999099 | 0.7952578510783906 | 0.9719939639272797 | 0.831698508685343 | 0.7576803861788618 | 0 | 0.9982537214898737 | 0.93298376173667 | 0.6763806167558581 | 0 | 0.9436438053611272 | 0.6140110285303286 | 0.5084236100577717 | 0.6917004171868817 | 3409.812 | 1.007053442465094 | 0.9866151096348266 | 0.002651312079066238 | 0.7817528586533152 | 0 | 0.9858130512367886 | 0.8616230504118231 | 0.945142978242001 | 0.785205903807767 | 0.9962430457687698 | 1 | 1 |  |  |  | 0.7041789425967173
3 | a) No. of inspectors for PCC controls | 4 | 3 | 11 | 3 | 30 | 2 |  | 66 | 55 | 2 |  | 7 | 5 | 2 | 3 | 3 | 2 | 5 | 4 | 30 |  | 10 | 3 | 3 | 3 | 3 | 6 | 2 | 2 |  |  | 269
 | b) Total number of control visits in abattoirs | 354 | 6 | 654 | 263 | 1113 | 27 |  |  | 641 | 6 |  | 19 | 85 | 96 | 18 | 285 | 260 | 265 | 486 | 1941 |  | 621 | 36 | 177 | 58 | 96 | 328 | 24 | 28 |  |  | 7887
 | c) Average no. of control visits per abattoir | 14.16 | 2 | 9.342857142857143 | 16.4375 | 2.11596958174905 | 6.75 |  | 0 | 3.932515337423313 | 2 |  | 6.333333333333333 | 8.5 | 5.333333333333333 | 6 | 3.851351351351351 | 130 | 14.72222222222222 | 5.11578947368421 | 7.641732283464567 |  | 5.914285714285715 | 7.2 | 2.901639344262295 | 7.25 | 2.666666666666667 | 8 | 6 | 5.6 |  |  | 4.880569306930693
 | d) Number of control visits in abattoirs slaughtering weekly > 200 pigs | 354 | 5 | 506 | 263 | 933 | 23 |  |  | 525 | 6 |  | 19 | 77 | 36 | 17 | 285 | 260 | 265 | 397 | 1893 |  | 416 | 32 | 60 | 58 | 91 | 328 | 24 | 28 |  |  | 6901
 | e) Average no. of control visits per abattoir slaughtering weekly > 200 pigs | 14.16 | 2.5 | 10.3265306122449 | 16.4375 | 6.712230215827338 | 7.666666666666667 | 0 | 0 | 7.291666666666667 | 2 | 0 | 6.333333333333333 | 8.555555555555555 | 2 | 8.5 | 3.851351351351351 | 260 | 14.72222222222222 | 7.94 | 7.790123456790123 | 0 | 8 | 8 | 3.157894736842105 | 8.285714285714286 | 8.272727272727273 | 8 | 8 | 5.6 |  |  | 7.396570203644159
4 | Are the classifiers licensed? |  | yes | yes | yes | yes | yes |  | no | no | no |  | yes | yes | yes | yes/no | yes | no | yes | yes | yes |  | yes | yes | yes | yes | yes | no | no | no |  |  | 0
 | a) Status of classifiers (**) |  | AB | AB | AB | AG | AB |  |  | 67%AB, 33%AG |  |  | AB |  |  | AB | AG; CL | AB | AG | licensed | AB |  | AG, CL | AG | AG | AB | AB | AG/AB | AG/AB | AG/AB |  |  | 0
 | b) No. of licensed classifiers | 85 | 4 | 138 | 39 | 492 | 10 |  |  | 0 |  |  | 13 | 41 | 24 | 6 | 80 | 0 | 88 | 159 | 538 |  | 310 | 9 | 61 | 38 | 127 | 0 |  | 0 |  |  | 2262
5 | No. of classifiers checked | 83 | 4 | 106 | 34 | 351 | 9 |  |  | 257 |  |  | 4 | 18 | 24 | 4 | 80 | 0 | 85 | 159 | 392 |  | 100 | 7 | 61 | 23 | 44 | 377 | 4 | 10 |  |  | 2236
 | Average no. of controls per checked classifier | 4.265060240963855 | 1.5 | 6.169811320754717 | 7.735294117647059 | 3.170940170940171 | 3 | 0 | 0 | 2.494163424124514 |  | 0 | 4.75 | 4.722222222222222 | 4 | 4.5 | 3.5625 |  | 3.117647058823529 | 3.056603773584906 | 4.951530612244898 | 0 | 6.21 | 5.142857142857143 | 2.901639344262295 | 2.521739130434783 | 2.181818181818182 | 0.870026525198939 | 6 | 2.8 |  |  | 3.527280858676208
6 | a) Total number of carcasses of pigs checked during control visits | 20625 | 294 | 28877 | 26300 | 61320 | 880 |  |  | 56281 |  |  | 349 | 2487 | 3710 | 540 | 7150 | 10 | 24957 | 14882 | 85981 |  | 33434 | 771 | 5310 | 3064 | 7433 | 7210 | 1189 | 560 |  |  | 393614
 | Checked carcasses as % of total no. of carcases classified | 0.001950278811858943 | 0.00470039010040289 | 0.01436250082687459 | 0.001296212182147087 | 0.001105051728116547 | 0.002950811976272789 | 0 | 0 | 0.002345041666666667 |  | 0 | 0.0005168609214637975 | 0.01294786492987224 | 0.009708991939704805 | 0.005943274744384156 | 0.002096889799203006 | 0.0001202790473899447 | 0.001749260102297757 | 1 | 0.005242378534227767 | 0 | 0.01086540052068388 | 0.003121457489878542 | 0.008526490730853532 | 0.001368090451139435 | 0.002622134014225068 | 0.002676101191514569 | 0.0007435716076968729 | 0.0009471522851740224 |  |  | 0.002059572544852635
 | Average no. of carcasses checked per control visit | 58.26271186440678 | 58.8 | 57.06916996047431 | 100 | 65.72347266881029 | 38.26086956521739 | 0 | 0 | 107.2019047619048 |  | 0 | 18.36842105263158 | 32.2987012987013 | 103.0555555555556 | 31.76470588235294 | 25.08771929824561 | 0.03846153846153846 | 94.17735849056604 | 37.48614609571788 | 45.42049656629688 | 0 | 80.3701923076923 | 24.09375 | 88.5 | 52.82758620689656 | 81.68131868131869 | 21.98170731707317 | 49.54166666666666 | 20 |  |  | 57.03724097956818
 | b) No. of carcasses checked in abattoirs slaughtering weekly > 200 pigs | 20625 | 269 | 24360 | 26300 | 46385 | 720 |  |  | 52242 |  |  | 349 | 2296 | 3710 | 540 | 7150 | 10 | 24957 | 12651 | 84198 |  | 18720 | 686 | 1800 | 3064 | 7199 | 7210 | 1189 | 560 |  |  | 347190
 | Average no. of carcasses checked per control visit in abattoirs slaughtering weekly > 200 pigs | 58.26271186440678 | 53.8 | 53.8 | 100 | 49.71596998928189 | 31.30434782608696 | 0 | 0 | 99.50857142857143 |  | 0 | 18.36842105263158 | 29.81818181818182 | 103.0555555555556 | 31.76470588235294 | 25.08771929824561 | 0.03846153846153846 | 94.17735849056604 | 31.86649874055416 | 44.47860538827258 | 0 | 45 | 21.4375 | 30 | 52.82758620689656 | 79.10989010989012 | 21.98170731707317 | 49.54166666666666 | 20 |  |  | 50.31009998550935
7 | a) No. of carcasses checked on carcass presentation | 20625 | 294 | 28877 | 26300 | 59696 | 880 |  |  | 56281 |  |  | 349 | 440 | 2675 | 50 | 7150 | 83140 | * | 12651 | 85981 |  | 18720 | 0 | 5310 | 1120 | 680 | 7210 | 1189 | 560 |  |  | 420178
 | b) No. of carcases checked with incorrect carcass presentation | 206 | 3 | 383 | 295 | 1751 | 0 |  |  | 4080 |  |  | 15 | 131 |  | 50 | 143 | 831 | * | 133 | 3610 |  | 1709 | 0 | 72 | 0 | 104 | 7210 | 49 | 40 |  |  | 20815
 | Checked carcasses with incorrect carcass presentation as % of total no. of carcasses checked on carcass presentation | 0.009987878787878789 | 0.01020408163265306 | 0.01326315060428715 | 0.01121673003802281 | 0.02933194853926561 | 0 | 0 | 0 | 0.07249338142534781 |  | 0 | 0.04297994269340974 | 0.2977272727272727 | 0 | 1 | 0.02 | 0.009995188838104402 |  | 0.01051300292466999 | 0.04198602016724625 | 0 | 0.09129273504273504 |  | 0.0135593220338983 | 0 | 0.1529411764705882 | 1 | 0.04121110176619008 | 0.07142857142857142 |  |  | 0.04953852890917659
8 | No. of carcasses checked with incorrect carcass marking | 0 | 0 | 0 | 0 | 384 | 0 |  |  | 13601 |  |  | 145 | 0 | 0 | 0 | 56 | 831 |  | 0 | 6638 |  | 8 |  | 211 |  | 0 | 212 | 0 | 25 |  |  | 22111
 | Checked carcasses with incorrect carcass carcass marking as % of total no. of carcasses checked on carcass presentation | 0 | 0 | 0 | 0 | 0.006432591798445457 | 0 | 0 | 0 | 0.2416623727368028 |  | 0 | 0.4154727793696275 | 0 | 0 | 0 | 0.007832167832167832 | 0.009995188838104402 | 0 | 0 | 0.07720310301113037 | 0 | 0.0004273504273504274 | 0 | 0.03973634651600753 | 0 | 0 | 0.02940360610263523 | 0 | 0.04464285714285714 |  |  | 0.05262293599379311
 | Price reporting
 | Authorised different than standard presentation of pig carcasses | D |  | D |  |  | D | D | D | D |  |  | D | D |  |  | D |  |  |  | D |  |  |  |  |  |  | D | D | D
9 | Who is monitoring the price reporting: classification body (C); agency (B), competent authority (A) or other (O) ? | A | A | O | A+O | A | A |  | A | A |  |  | A | A | A | A | A/B/C/O | O | A | A | A |  | A | A/B/C/O | B | B | A | O | O | B
10 | Number of price controls on representative markets or quotation centres | - |  | 23 | 1 | 4 | 3 |  | [NAME] | - | 0 |  | 5 | 0 | 13 | 1 |  | 0 | ** | 0 |  |  |  |  | 4 | 5 | 3 | 9 |  | 1 |  |  | 72
11 | Number of monitored price reports | - |  | 1196 | 1 | 47 | 18 |  | [NAME] | - | 0 |  | 52 | 39 | 13 | 1 |  | 0 | ** | 27 |  |  | 52 |  | 4 | 15 | 3 | c70,000 | c25-30k | c7k |  |  | 1468
12 | Number of monitored carcasses for price reporting | - |  | 1895840 | 700 | 192525 | 720 |  |  | - | 0 |  | 0 | 1404 | 365 | 38 |  | 0 | ** | 127998 |  |  | 208000 |  | 628 | 60 | 380 | 0 |  | 0 |  |  | 2428658
13 | Is there a control report made for each visit? | - | yes | yes | yes | yes | yes |  | yes | - | no |  | no | yes | yes | No | yes/no | no | ** | yes |  |  | yes | yes/no | yes | yes | yes | no
14 | a) Is the supplier or pig producer informed about classification results? | yes | yes | yes | yes | yes and no | yes |  | yes | yes | yes |  | no | yes | yes | Yes | yes/no | yes | yes | yes | yes/no |  | yes | yes/no | yes | yes | yes | no | yes | no
 | b) If yes, is there any control of that comunication? | yes | yes | yes | yes | yes and no | no |  | yes | no | no |  | no | no | yes | Yes | yes/no | yes | yes | no | yes |  | yes | yes/no | yes | yes | yes | yes/no | no