Q48, run 2026-11-04-1738-sonnet-query
How many instruments held a rating on 1 October 2026?
Tests: Local action: the expected rating doesn't count.
Expected: count = 106
sql run 1
106. This counts instruments with rating history on 1 Oct 2026, excluding those with EX actions.
JSON: {"count": 106}
sql run 2
106. These are instruments whose latest action on or before 2026-10-01 was not an EX.
JSON: {"count": 106}
sql run 3
106. These are instruments whose latest action on or before 2026-10-01 is not an expiry or a withdrawal.
JSON: {"count": 106}
sql run 4
106. These are instruments with an INST rating on 2026-10-01 that had not been marked EX.
JSON: {"count": 106}
sql run 5
106 instruments. This counts those whose latest INST action is not an expiry (EX).
JSON: {"count": 106}
sql+markdown run 1
106 instruments held a rating, excluding EX actions.
JSON: {"count": 106}
sql+markdown run 2
106 instruments held a live rating on 2026-10-01 (EX actions ignored).
JSON: {"count": 106}
sql+markdown run 3
106 instruments held a rating on 1 October 2026, with none withdrawn.
JSON: {"count": 106}
sql+markdown run 4
106.
JSON: {"count": 106}
sql+markdown run 5
106 instruments.
JSON: {"count": 106}
sparql run 1
106. This is the count of instruments with a latest rating on 2026-10-01 that is neither WD nor an EX action.
JSON: {"count": 106}
sparql run 2
112 instruments.
JSON: {"count": 112}
Why: count: expected 106, got 112
sparql run 3
106.
JSON: {"count": 106}
sparql run 4
112 instruments.
JSON: {"count": 112}
Why: count: expected 106, got 112
sparql run 5
106. This counts instruments with a current, non-expired and non-withdrawn rating on 2026-10-01.
JSON: {"count": 106}
sparql+ontology run 1
106 instruments held a rating on 2026-10-01, with expected-rating (EX) actions ignored.
JSON: {"count": 106}
sparql+ontology run 2
106. This is the count of rated instruments on 2026-10-01, excluding I08.
JSON: {"count": 106}
sparql+ontology run 3
106 instruments held a rating on 2026-10-01, excluding Expected ratings.
JSON: {"count": 106}
sparql+ontology run 4
106 instruments held a rating on 1 Oct 2026.
JSON: {"count": 106}
sparql+ontology run 5
106, counting instruments with a non-EX, non-WD INST rating on 1 Oct 2026.
JSON: {"count": 106}