| source year | kibs text class | gold standard | tenders | has report | avg docs | meat rich n | likely framework n |
|---|---|---|---|---|---|---|---|
|
2024
|
non_kibs
|
0
|
255
|
227
|
15.37
|
73
|
0
|
|
2024
|
non_kibs
|
1
|
23
|
23
|
15.09
|
9
|
1
|
|
2024
|
possible_kibs
|
0
|
45
|
40
|
21.33
|
22
|
0
|
|
2024
|
possible_kibs
|
1
|
8
|
8
|
16.75
|
3
|
0
|
|
2024
|
strict_kibs
|
0
|
141
|
120
|
16.41
|
51
|
0
|
|
2024
|
strict_kibs
|
1
|
21
|
19
|
19.43
|
13
|
1
|
|
2024
|
weak_signal
|
0
|
87
|
80
|
16.52
|
46
|
0
|
|
2024
|
weak_signal
|
1
|
7
|
6
|
22.57
|
5
|
0
|
|
2025
|
non_kibs
|
0
|
115
|
95
|
14.83
|
38
|
1
|
|
2025
|
non_kibs
|
1
|
5
|
5
|
17.6
|
1
|
1
|
|
2025
|
possible_kibs
|
0
|
38
|
32
|
17.18
|
19
|
0
|
|
2025
|
possible_kibs
|
1
|
1
|
1
|
10
|
1
|
0
|
|
2025
|
strict_kibs
|
0
|
74
|
58
|
15.04
|
29
|
0
|
|
2025
|
strict_kibs
|
1
|
11
|
11
|
19.09
|
6
|
1
|
|
2025
|
weak_signal
|
0
|
78
|
66
|
13.86
|
31
|
1
|
|
2025
|
weak_signal
|
1
|
4
|
4
|
12
|
0
|
0
|
SELECT
source_year,
kibs_text_class,
gold_standard,
count(*) AS tenders,
sum(CASE WHEN lower(coalesce(has_report_bool,'')) IN ('true','1','yes','jā','ja') THEN 1 ELSE 0 END) AS has_report,
round(avg(try_cast(total_docs AS DOUBLE)), 2) AS avg_docs,
sum(CASE WHEN lower(coalesce(meat_rich,'')) IN ('true','1','yes','jā','ja') THEN 1 ELSE 0 END) AS meat_rich_n,
sum(CASE WHEN lower(coalesce(likely_framework,'')) IN ('true','1','yes','jā','ja') THEN 1 ELSE 0 END) AS likely_framework_n
FROM xlsx_gold_standard_v12_b56445cb_4
GROUP BY 1,2,3
ORDER BY try_cast(source_year AS INT), kibs_text_class, gold_standard;