| kibs class | buyer category | tenders | avg planned value eur | pct meat award method | pct multi lot | pct likely framework | pct likely disqualification | avg docs |
|---|---|---|---|---|---|---|---|---|
|
non_kibs
|
agency
|
148
|
206291
|
45.9
|
17.6
|
0
|
25
|
15.3
|
|
non_kibs
|
municipality
|
116
|
56413
|
19
|
19
|
0
|
22.4
|
14.1
|
|
strict_kibs
|
agency
|
96
|
167950
|
60.4
|
16.7
|
1
|
16.7
|
18.5
|
|
weak_signal
|
agency
|
88
|
279096
|
59.1
|
12.5
|
0
|
14.8
|
15.4
|
|
possible_kibs
|
agency
|
56
|
2000212
|
64.3
|
16.1
|
0
|
19.6
|
23.7
|
|
strict_kibs
|
municipality
|
52
|
63299
|
28.8
|
11.5
|
0
|
40.4
|
12.8
|
|
non_kibs
|
SOE
|
39
|
260628
|
35.9
|
12.8
|
7.7
|
5.1
|
14.3
|
|
non_kibs
|
university
|
39
|
148253
|
71.8
|
2.6
|
0
|
23.1
|
19.5
|
|
strict_kibs
|
ministry
|
35
|
83354
|
71.4
|
11.4
|
0
|
22.9
|
14.1
|
|
non_kibs
|
other_entity
|
29
|
115033
|
44.8
|
20.7
|
0
|
27.6
|
15.7
|
|
non_kibs
|
ministry
|
27
|
140268
|
70.4
|
11.1
|
0
|
18.5
|
14.5
|
|
strict_kibs
|
university
|
27
|
83649
|
55.6
|
7.4
|
0
|
22.2
|
20.9
|
|
weak_signal
|
university
|
23
|
123811
|
47.8
|
8.7
|
4.3
|
17.4
|
14.2
|
|
strict_kibs
|
other_entity
|
21
|
97738
|
52.4
|
9.5
|
0
|
14.3
|
17.8
|
|
weak_signal
|
municipality
|
19
|
459290
|
47.4
|
15.8
|
0
|
15.8
|
11.5
|
|
weak_signal
|
other_entity
|
17
|
162406
|
52.9
|
0
|
0
|
29.4
|
14.7
|
|
strict_kibs
|
SOE
|
16
|
230667
|
56.3
|
6.3
|
6.3
|
25
|
10.9
|
|
weak_signal
|
SOE
|
16
|
305361
|
62.5
|
0
|
0
|
18.8
|
21.4
|
|
possible_kibs
|
municipality
|
15
|
58857
|
46.7
|
0
|
0
|
26.7
|
11.2
|
|
weak_signal
|
ministry
|
13
|
606354
|
69.2
|
7.7
|
0
|
7.7
|
18.1
|
|
possible_kibs
|
ministry
|
7
|
956371
|
71.4
|
0
|
0
|
42.9
|
11.7
|
|
possible_kibs
|
other_entity
|
6
|
416250
|
83.3
|
0
|
0
|
33.3
|
13
|
|
possible_kibs
|
university
|
6
|
86833
|
50
|
0
|
0
|
0
|
13.7
|
|
possible_kibs
|
SOE
|
2
|
41999
|
50
|
0
|
0
|
0
|
9.5
|
SELECT
COALESCE(kibs_text_class, '(blank)') AS kibs_class,
COALESCE(buyer_cat, '(blank)') AS buyer_category,
COUNT(*) AS tenders,
ROUND(AVG(try_cast(planota_ligumcena AS DOUBLE)), 0) AS avg_planned_value_eur,
ROUND(100.0 * AVG(CASE WHEN uzvaretaja_izveles_metode LIKE 'SaimnieciskÄ%' THEN 1 ELSE 0 END), 1) AS pct_meat_award_method,
ROUND(100.0 * AVG(CASE WHEN is_multi_lot IN ('1','true','TRUE','yes','Yes') THEN 1 ELSE 0 END), 1) AS pct_multi_lot,
ROUND(100.0 * AVG(CASE WHEN likely_framework IN ('1','true','TRUE','yes','Yes') THEN 1 ELSE 0 END), 1) AS pct_likely_framework,
ROUND(100.0 * AVG(CASE WHEN likely_disqualification IN ('1','true','TRUE','yes','Yes') THEN 1 ELSE 0 END), 1) AS pct_likely_disqualification,
ROUND(AVG(try_cast(total_docs AS DOUBLE)), 1) AS avg_docs
FROM xlsx_gold_standard_v12_b56445cb_4
GROUP BY 1,2
ORDER BY tenders DESC, kibs_class, buyer_category