D4 sparql, run 2: the query session
25 queries0 failed5 rounds
The opening prompt
## The data
You can't see the data, but you can query it. It is in an RDF store, described below. Write SPARQL 1.1 SELECT or ASK queries.
To run queries, reply with one or more fenced blocks (```sparql), and nothing else is needed:
each is run and its results sent back to you. You have up to 8 rounds of queries.
When you have what you need, reply with the final answers and no queries.
Prefixes:
```
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX lad: <https://example.org/ladder/>
```
Classes and the properties their resources use:
- `lad:Entity`: `rdf:type`, `rdfs:label`, `lad:country`, `lad:entityType`, `lad:lei`, `lad:name`, `lad:parent`, `lad:sourceSystem`
- `lad:Instrument`: `rdf:type`, `rdfs:label`, `lad:currency`, `lad:description`, `lad:guarantor`, `lad:issuer`, `lad:maturity`, `lad:seniority`
- `lad:RatingAction`: `rdf:type`, `rdfs:label`, `lad:action`, `lad:ccyBasis`, `lad:comment`, `lad:date`, `lad:outlook`, `lad:ratedThing`, `lad:rating`, `lad:ratingType`, `lad:watch`
## Questions
Answer each question below from the data above. Start each answer on a new line with its
number in bold, like **Q1.**, give the direct answer first, then at most two sentences of
reasoning that cite the records (IDs) you relied on.
Then end with one JSON block (```json) holding the structured answer to each question listed
here, with exactly these fields, shaped like {"Q1": {"field": value}, ...}. Name entities by their record ID: the entity_id in the CSV files, or the part of the IRI after lad: in the RDF (E01, not Kestrel Energy plc).
- Q1: rating (a rating, or "none")
- Q2: downgraded ("yes", "no" or "depends")
- Q3: investment_grade ("yes", "no" or "depends"), rating (a rating, or "none")
- Q4: outlook (an outlook)
- Q5: risk_of (a record ID), rating (a rating, or "none")
- Q7: issuers (a list of record IDs)
- Q8: entities (a list of record IDs)
- Q9: count (a number)
- Q10: investment_grade ("yes", "no" or "depends")
- Q11: rating (a rating, or "none")
- Q12: rating (a rating, or "none")
- Q13: count (a number)
- Q14: rating (a rating, or "none")
- Q15: rating (a rating, or "none")
- Q16: changed ("yes", "no" or "depends")
- Q17: downgraded ("yes", "no" or "depends")
- Q18: issuers (a list of record IDs)
- Q19: issuers (a list of record IDs)
- Q20: in_default ("yes", "no" or "depends")
- Q21: entities (a list of record IDs)
- Q22: entities (a list of record IDs)
- Q23: rating (a rating, or "none")
- Q24: investment_grade ("yes", "no" or "depends")
- Q25: count (a number)
- Q26: rating (a rating, or "none")
- Q27: rating (a rating, or "none")
- Q28: rating (a rating, or "none")
- Q29: rating (a rating, or "none")
- Q30: entities (a list of record IDs)
- Q31: any ("yes", "no" or "depends")
- Q32: parent (a record ID)
- Q33: risk_of (a record ID), rating (a rating, or "none")
- Q34: same_group ("yes", "no" or "depends")
- Q35: count (a number)
- Q36: count (a number)
- Q37: count (a number)
- Q38: same ("yes", "no" or "depends")
- Q39: rating (a rating, or "none")
- Q40: count (a number)
- Q41: rating (a rating, or "none")
- Q42: country (a country code)
- Q43: count (a number)
- Q44: local_currency ("yes", "no" or "depends")
- Q45: above_ceiling ("yes", "no" or "depends")
- Q46: issuer_rating ("yes", "no" or "depends")
- Q47: rating (a rating, or "none")
- Q48: count (a number)
Q1. What was Kestrel Energy's rating on 1 January 2025?
Q2. Has Kestrel Energy been downgraded in 2026?
Q3. Is Kestrel Energy's 2031 note investment grade?
Q4. What is Northwind Holdings' current outlook?
Q5. Whose credit risk does a holder of the Northwind Finance 2030 notes take, and how is it rated?
Q6. Why is Valdoria Telecom's foreign-currency rating lower than its local-currency rating?
Q7. Which issuers were downgraded in 2026?
Q8. Which entities were in default on 1 October 2026?
Q9. As of 1 October 2026, how many distinct issuers hold an issuer rating?
Q10. Is Valdoria Telecom investment grade?
Q11. What was Marlow Utilities' rating on 1 June 2025?
Q12. What was Marlow Utilities' rating on 1 January 2024?
Q13. How many times has Marlow Utilities been downgraded?
Q14. What was Halden Foods' rating on 1 January 2024?
Q15. What was Halden Bank's rating on 1 January 2026?
Q16. Has Marlow Utilities' rating changed since 1 January 2025?
Q17. Was Orrin Bank downgraded in 2026?
Q18. Which issuers were on Rating Watch Negative on 1 October 2026?
Q19. Which issuers had a Negative outlook on 1 October 2026?
Q20. Is Pellam Retail in default?
Q21. Which entities had an issuer rating at some point but no longer had one on 1 October 2026?
Q22. Which entities have ever been in default?
Q23. What is Kestrel Energy's short-term rating?
Q24. Is Kestrel Energy's issuer rating investment grade?
Q25. How many instruments held an investment-grade rating on 1 October 2026?
Q26. What is Corvenia Power's local-currency rating?
Q27. How is Corvenia Power's 2032 note rated?
Q28. What is the Republic of Corvenia's foreign-currency issuer rating?
Q29. What is the Republic of Valdoria's issuer rating?
Q30. Which entities had a foreign-currency issuer rating exactly at their country's ceiling on 1 October 2026?
Q31. Did any company have a foreign-currency issuer rating above its country's ceiling on 1 October 2026?
Q32. Who is Halden Leasing's ultimate parent?
Q33. Whose credit risk does a holder of the Halden Leasing 2028 notes take, and how is it rated?
Q34. Is Halden Foods part of the same group as Halden Bank?
Q35. How many entities are in the Halden group, the parent included?
Q36. How many entities are in the Northwind group, the parent included?
Q37. How many distinct legal entities does the data describe?
Q38. Are Orrin Bank AG and Orrin Bancorp Inc the same entity?
Q39. What is Northwind Holdings' current rating?
Q40. How many distinct issuers domiciled in GB held an issuer rating on 1 October 2026?
Q41. What is Brindle Capital's current rating?
Q42. In which country is Halden Bank domiciled?
Q43. How many distinct entities are domiciled in Luxembourg (LU)?
Q44. Is Valdoria Telecom's 2027 note a local-currency obligation?
Q45. Is Valdoria Telecom's 2027 note rated above what Valdoria's Country Ceiling allows?
Q46. Does Halden Leasing have an issuer rating?
Q47. How is Corvenia Power's 2034 note rated?
Q48. How many instruments held a rating on 1 October 2026?The model
I'll start by exploring the data.
```sparql
SELECT ?s ?p ?o WHERE { ?s ?p ?o . FILTER(?s IN (lad:E01, lad:E02)) } LIMIT 50
```
```sparql
SELECT ?s ?l ?t ?c ?et ?par ?lei ?ss WHERE { ?s a lad:Entity . OPTIONAL{?s rdfs:label ?l} OPTIONAL{?s lad:country ?c} OPTIONAL{?s lad:entityType ?et} OPTIONAL{?s lad:parent ?par} OPTIONAL{?s lad:lei ?lei} OPTIONAL{?s lad:sourceSystem ?ss} OPTIONAL{?s lad:name ?t} } ORDER BY ?s
```
```sparql
SELECT ?s ?l ?cur ?d ?g ?i ?m ?sen WHERE { ?s a lad:Instrument . OPTIONAL{?s rdfs:label ?l} OPTIONAL{?s lad:currency ?cur} OPTIONAL{?s lad:description ?d} OPTIONAL{?s lad:guarantor ?g} OPTIONAL{?s lad:issuer ?i} OPTIONAL{?s lad:maturity ?m} OPTIONAL{?s lad:seniority ?sen} } ORDER BY ?s
```
```sparql
SELECT ?s ?thing ?date ?rt ?r ?ccy ?o ?w ?a ?c WHERE { ?s a lad:RatingAction . OPTIONAL{?s lad:ratedThing ?thing} OPTIONAL{?s lad:date ?date} OPTIONAL{?s lad:ratingType ?rt} OPTIONAL{?s lad:rating ?r} OPTIONAL{?s lad:ccyBasis ?ccy} OPTIONAL{?s lad:outlook ?o} OPTIONAL{?s lad:watch ?w} OPTIONAL{?s lad:action ?a} OPTIONAL{?s lad:comment ?c} } ORDER BY ?thing ?date
```Query results
Query 1:
| s | p | o |
|---|---|---|
| lad:E01 | lad:country | GB |
| lad:E02 | lad:name | Northwind Holdings plc |
| lad:E02 | rdfs:label | Northwind Holdings plc |
| lad:E01 | lad:lei | 7245002OOPBG04092E43 |
| lad:E01 | rdfs:label | Kestrel Energy plc |
| lad:E02 | lad:sourceSystem | RATINGS |
| lad:E01 | lad:entityType | lad:etype-CORP |
| lad:E02 | lad:country | GB |
| lad:E02 | lad:entityType | lad:etype-CORP |
| lad:E01 | rdf:type | lad:Entity |
| lad:E02 | rdf:type | lad:Entity |
| lad:E01 | lad:name | Kestrel Energy plc |
| lad:E01 | lad:sourceSystem | RATINGS |
| lad:E02 | lad:lei | 213800PHEIYNJMHTDV74 |
Query 2:
| s | l | t | c | et | par | lei | ss |
|---|---|---|---|---|---|---|---|
| lad:CV | Republic of Corvenia | Republic of Corvenia | CV | lad:etype-SOV | | | RATINGS |
| lad:E01 | Kestrel Energy plc | Kestrel Energy plc | GB | lad:etype-CORP | | 7245002OOPBG04092E43 | RATINGS |
| lad:E02 | Northwind Holdings plc | Northwind Holdings plc | GB | lad:etype-CORP | | 213800PHEIYNJMHTDV74 | RATINGS |
| lad:E03 | NORTHWIND HLDGS | NORTHWIND HLDGS | GB | lad:etype-CORP | | 213800PHEIYNJMHTDV74 | RESEARCH |
| lad:E04 | Northwind Finance BV | Northwind Finance BV | NL | lad:etype-FINSUB | lad:E02 | 213800LA5RYJLGXV2T85 | RATINGS |
| lad:E05 | Valdoria Telecom SA | Valdoria Telecom SA | VD | lad:etype-CORP | | 391200LESH03LMOY2U61 | RATINGS |
| lad:E06 | Orrin Bank AG | Orrin Bank AG | DE | lad:etype-BANK | | 549300AMVE3VRVG7HK43 | RATINGS |
| lad:E07 | Pellam Retail Ltd | Pellam Retail Ltd | GB | lad:etype-CORP | | 969500B6IUACELPI2291 | RATINGS |
| lad:E08 | Saxby Shipping SA | Saxby Shipping SA | GR | lad:etype-CORP | | 969500KOTZ1JFIZSG796 | RATINGS |
| lad:E09 | Halden Group plc | Halden Group plc | GB | lad:etype-CORP | | 815600ASM9EHDG931T89 | RATINGS |
| lad:E10 | Halden Bank AG | Halden Bank AG | DE | lad:etype-BANK | lad:E09 | 391200QYPVFF2O9K2039 | RATINGS |
| lad:E1001 | Tunod Steel SA | Tunod Steel SA | FR | lad:etype-CORP | | 3912003R00FP6CNV6210 | RATINGS |
| lad:E1002 | TUNOD STEEL SA | TUNOD STEEL SA | FR | lad:etype-CORP | | 3912003R00FP6CNV6210 | RESEARCH |
| lad:E1003 | Rilol Telecom plc | Rilol Telecom plc | GB | lad:etype-BANK | | 3912009W4J483WB8PZ97 | RATINGS |
| lad:E1004 | Munem Retail SA | Munem Retail SA | ES | lad:etype-CORP | | 969500IBYK0X2ZT52780 | RATINGS |
| lad:E1005 | Setan Airlines Inc | Setan Airlines Inc | US | lad:etype-CORP | | 815600JRN7AOE36KFR35 | RATINGS |
| lad:E1006 | Soson Airlines Inc | Soson Airlines Inc | US | lad:etype-CORP | lad:E1005 | 213800WSVEOAQ5HD4C43 | RATINGS |
| lad:E1007 | Golod Property plc | Golod Property plc | GB | lad:etype-BANK | | 815600N2UAHQREHHWF76 | RATINGS |
| lad:E1008 | Sotil Retail plc | Sotil Retail plc | GB | lad:etype-CORP | | 213800RPNJ2OSQ387M40 | RATINGS |
| lad:E1009 | Malam Chemicals Inc | Malam Chemicals Inc | US | lad:etype-CORP | | 3912006EIY6TU9NVSC86 | RATINGS |
| lad:E1010 | Buvir Industries Inc | Buvir Industries Inc | US | lad:etype-CORP | | 3912004R2GZJL49URX69 | RATINGS |
| lad:E1011 | Falom Media Inc | Falom Media Inc | US | lad:etype-BANK | | 549300XX6U9N4Y7KPH74 | RATINGS |
| lad:E1012 | Posad Industries SA | Posad Industries SA | FR | lad:etype-CORP | | 9695002JIQI5QYDN0G98 | RATINGS |
| lad:E1013 | Pisol Pharma BV | Pisol Pharma BV | NL | lad:etype-BANK | lad:E1004 | 969500U072SAPPW32N81 | RATINGS |
| lad:E1014 | Toral Utilities BV | Toral Utilities BV | NL | lad:etype-CORP | | 391200J700D8T2H18W16 | RATINGS |
| lad:E1015 | Civen Steel Inc | Civen Steel Inc | US | lad:etype-CORP | | 815600JSNIJ4UFCBF662 | RATINGS |
| lad:E1016 | Ponar Telecom SA | Ponar Telecom SA | ES | lad:etype-BANK | | 5493008DQ96XI37KZG24 | RATINGS |
| lad:E1017 | Nisid Steel SA | Nisid Steel SA | FR | lad:etype-BANK | | 391200K600X7LWZTTM85 | RATINGS |
| lad:E1018 | Tosem Mining Inc | Tosem Mining Inc | US | lad:etype-CORP | | 549300SEMGL6OXLWHQ59 | RATINGS |
| lad:E1019 | Losol Mining SA | Losol Mining SA | CV | lad:etype-CORP | | 391200GSFO0F68KKUC67 | RATINGS |
| lad:E1020 | Finel Media AG | Finel Media AG | DE | lad:etype-CORP | | 549300FCSHHELSCZX562 | RATINGS |
| lad:E1021 | Niner Pharma plc | Niner Pharma plc | GB | lad:etype-CORP | | 391200KLG6G4KVIMIU52 | RATINGS |
| lad:E1022 | NINER PHARMA | NINER PHARMA | GB | lad:etype-CORP | | 391200KLG6G4KVIMIU52 | RESEARCH |
| lad:E1023 | Heled Water plc | Heled Water plc | GB | lad:etype-CORP | | 3912006FHXTH5V6WNK07 | RATINGS |
| lad:E1024 | Susin Shipping BV | Susin Shipping BV | NL | lad:etype-CORP | | 3912005J04HB7X0GTN24 | RATINGS |
| lad:E1025 | Tulol Shipping SA | Tulol Shipping SA | ES | lad:etype-BANK | | 2138007MIV2OS05PET94 | RATINGS |
| lad:E1026 | Vunam Water BV | Vunam Water BV | NL | lad:etype-CORP | | 969500C8XYHXZBFMUO41 | RATINGS |
| lad:E1027 | Tesad Media Inc | Tesad Media Inc | US | lad:etype-CORP | | 969500T86HNH5S920X18 | RATINGS |
| lad:E1028 | Mutir Retail SA | Mutir Retail SA | VD | lad:etype-CORP | | 213800TJ32NARU0BI982 | RATINGS |
| lad:E1029 | Leson Telecom Inc | Leson Telecom Inc | US | lad:etype-BANK | | 8156008DPX4I9DNKWN26 | RATINGS |
| lad:E1030 | LESON TELECOM INC | LESON TELECOM INC | US | lad:etype-BANK | | 8156008DPX4I9DNKWN26 | RESEARCH |
| lad:E1031 | Kuvir Logistics SA | Kuvir Logistics SA | ES | lad:etype-CORP | | 969500GRHP48SQNEWH44 | RATINGS |
| lad:E1032 | Helom Chemicals BV | Helom Chemicals BV | NL | lad:etype-BANK | | 2138006H9XCYN2P1K228 | RATINGS |
| lad:E1033 | Kunid Pharma SA | Kunid Pharma SA | ES | lad:etype-CORP | lad:E1004 | 213800Q84PS4FTJJB947 | RATINGS |
| lad:E1034 | Tanad Capital SpA | Tanad Capital SpA | IT | lad:etype-CORP | | 815600KLV84WAQGPSX27 | RATINGS |
| lad:E1035 | Kavod Utilities AG | Kavod Utilities AG | DE | lad:etype-CORP | | 724500YHN51API4SE179 | RATINGS |
| lad:E1036 | Lilor Retail AG | Lilor Retail AG | DE | lad:etype-CORP | | 9695000N72OQ0Q07IW61 | RATINGS |
| lad:E1037 | Natil Retail SA | Natil Retail SA | FR | lad:etype-CORP | | 391200OBAXI8590VQN12 | RATINGS |
| lad:E1038 | Lanon Telecom BV | Lanon Telecom BV | NL | lad:etype-CORP | | 549300EZ4HXP0L5RAZ01 | RATINGS |
| lad:E1039 | Pulor Airlines SA | Pulor Airlines SA | CV | lad:etype-BANK | | 969500HA9D5I7F73PW83 | RATINGS |
| lad:E1040 | Dorid Mining AG | Dorid Mining AG | DE | lad:etype-CORP | | 549300SPMD9MEMFWMR12 | RATINGS |
| lad:E1041 | Hiral Steel SA | Hiral Steel SA | ES | lad:etype-CORP | | 549300JU1O5MP1HSKQ01 | RATINGS |
| lad:E1042 | Rerod Steel BV | Rerod Steel BV | NL | lad:etype-CORP | | 391200LC6V921W096L49 | RATINGS |
| lad:E1043 | Vitom Property plc | Vitom Property plc | GB | lad:etype-CORP | | 5493007IVTPIWJZLFF29 | RATINGS |
| lad:E1044 | Hesid Telecom Inc | Hesid Telecom Inc | US | lad:etype-BANK | | 3912003Y7VZHUGN50755 | RATINGS |
| lad:E1045 | Nesid Logistics Inc | Nesid Logistics Inc | US | lad:etype-BANK | | 96950029VB162U3K1976 | RATINGS |
| lad:E1046 | Ditin Shipping Inc | Ditin Shipping Inc | US | lad:etype-BANK | lad:E1026 | 549300ZM08IADSAK3L87 | RATINGS |
| lad:E1047 | Vaved Pharma plc | Vaved Pharma plc | GB | lad:etype-CORP | lad:E1020 | 391200WGA8OE30KZUD08 | RATINGS |
| lad:E1048 | Lised Pharma AG | Lised Pharma AG | DE | lad:etype-CORP | | 9695000T21G05UQMGF10 | RATINGS |
| lad:E1049 | Paser Utilities plc | Paser Utilities plc | GB | lad:etype-CORP | | 391200R2EH7FELZFOV27 | RATINGS |
(310 more rows not shown)
Query 3:
| s | l | cur | d | g | i | m | sen |
|---|---|---|---|---|---|---|---|
| lad:I01 | Kestrel Energy 4.50% 2030 | GBP | Kestrel Energy 4.50% notes due 2030 | | lad:E01 | 2030-03-15 | lad:seniority-SU |
| lad:I02 | Kestrel Energy 6.25% 2031 | GBP | Kestrel Energy 6.25% notes due 2031 | | lad:E01 | 2031-09-30 | lad:seniority-SUB |
| lad:I03 | Northwind Finance 3.75% 2030 | EUR | Northwind Finance 3.75% notes due 2030 | lad:E02 | lad:E04 | 2030-05-01 | lad:seniority-SU |
| lad:I04 | Valdoria Telecom 5.00% 2029 | USD | Valdoria Telecom 5.00% notes due 2029 | | lad:E05 | 2029-11-20 | lad:seniority-SU |
| lad:I05 | Halden Leasing 2.90% 2028 | EUR | Halden Leasing 2.90% notes due 2028 | lad:E10 | lad:E11 | 2028-06-30 | lad:seniority-SU |
| lad:I06 | Corvenia Power 7.10% 2032 | USD | Corvenia Power 7.10% notes due 2032 | | lad:E15 | 2032-02-15 | lad:seniority-SUB |
| lad:I07 | Valdoria Telecom 4.25% 2027 | XVD | Valdoria Telecom 4.25% notes due 2027 | | lad:E05 | 2027-08-31 | lad:seniority-SU |
| lad:I08 | Corvenia Power 6.00% 2034 | USD | Corvenia Power 6.00% notes due 2034 | | lad:E15 | 2034-09-01 | lad:seniority-SU |
| lad:I1001 | Soson Airlines 5.50% 2031 | USD | Soson Airlines 5.50% notes due 2031 | | lad:E1006 | 2035-06-30 | lad:seniority-SUB |
| lad:I1002 | Golod Property 8.75% 2031 | USD | Golod Property 8.75% notes due 2031 | | lad:E1007 | 2033-06-30 | lad:seniority-SU |
| lad:I1003 | Sotil Retail 3.00% 2031 | GBP | Sotil Retail 3.00% notes due 2031 | | lad:E1008 | 2034-06-30 | lad:seniority-SU |
| lad:I1004 | Malam Chemicals 2.25% 2035 | USD | Malam Chemicals 2.25% notes due 2035 | | lad:E1009 | 2028-06-30 | lad:seniority-SU |
| lad:I1005 | Posad Industries 4.00% 2033 | EUR | Posad Industries 4.00% notes due 2033 | | lad:E1012 | 2031-06-30 | lad:seniority-SU |
| lad:I1006 | Pisol Pharma 4.75% 2030 | USD | Pisol Pharma 4.75% notes due 2030 | | lad:E1013 | 2030-06-30 | lad:seniority-SUB |
| lad:I1007 | Toral Utilities 7.75% 2028 | EUR | Toral Utilities 7.75% notes due 2028 | | lad:E1014 | 2033-06-30 | lad:seniority-SU |
| lad:I1008 | Ponar Telecom 4.75% 2035 | EUR | Ponar Telecom 4.75% notes due 2035 | | lad:E1016 | 2033-06-30 | lad:seniority-SU |
| lad:I1009 | Tosem Mining 2.75% 2031 | USD | Tosem Mining 2.75% notes due 2031 | | lad:E1018 | 2036-06-30 | lad:seniority-SUB |
| lad:I1010 | Finel Media 6.50% 2035 | EUR | Finel Media 6.50% notes due 2035 | | lad:E1020 | 2036-06-30 | lad:seniority-SU |
| lad:I1011 | Niner Pharma 3.25% 2029 | USD | Niner Pharma 3.25% notes due 2029 | | lad:E1021 | 2035-06-30 | lad:seniority-SU |
| lad:I1012 | Heled Water 6.25% 2030 | GBP | Heled Water 6.25% notes due 2030 | | lad:E1023 | 2031-06-30 | lad:seniority-SU |
| lad:I1013 | Kuvir Logistics 2.00% 2027 | EUR | Kuvir Logistics 2.00% notes due 2027 | | lad:E1031 | 2027-06-30 | lad:seniority-SU |
| lad:I1014 | Kavod Utilities 2.50% 2032 | USD | Kavod Utilities 2.50% notes due 2032 | | lad:E1035 | 2036-06-30 | lad:seniority-SU |
| lad:I1015 | Lanon Telecom 4.75% 2033 | EUR | Lanon Telecom 4.75% notes due 2033 | | lad:E1038 | 2032-06-30 | lad:seniority-SUB |
| lad:I1016 | Hiral Steel 6.00% 2035 | USD | Hiral Steel 6.00% notes due 2035 | | lad:E1041 | 2034-06-30 | lad:seniority-SU |
| lad:I1017 | Lised Pharma 4.50% 2036 | EUR | Lised Pharma 4.50% notes due 2036 | | lad:E1048 | 2029-06-30 | lad:seniority-SU |
| lad:I1018 | Paser Utilities 3.75% 2027 | GBP | Paser Utilities 3.75% notes due 2027 | | lad:E1049 | 2034-06-30 | lad:seniority-SUB |
| lad:I1019 | Sunar Holdings 8.50% 2036 | USD | Sunar Holdings 8.50% notes due 2036 | | lad:E1050 | 2034-06-30 | lad:seniority-SUB |
| lad:I1020 | Witad Steel 5.00% 2033 | EUR | Witad Steel 5.00% notes due 2033 | | lad:E1052 | 2027-06-30 | lad:seniority-SU |
| lad:I1021 | Duver Shipping 8.50% 2032 | EUR | Duver Shipping 8.50% notes due 2032 | | lad:E1056 | 2030-06-30 | lad:seniority-SU |
| lad:I1022 | Levem Foods 6.50% 2035 | EUR | Levem Foods 6.50% notes due 2035 | | lad:E1067 | 2030-06-30 | lad:seniority-SUB |
| lad:I1023 | Mored Utilities 4.25% 2032 | USD | Mored Utilities 4.25% notes due 2032 | | lad:E1071 | 2033-06-30 | lad:seniority-SUB |
| lad:I1024 | Ganed Holdings 5.75% 2035 | EUR | Ganed Holdings 5.75% notes due 2035 | | lad:E1077 | 2032-06-30 | lad:seniority-SU |
| lad:I1025 | Menir Shipping 7.50% 2028 | EUR | Menir Shipping 7.50% notes due 2028 | | lad:E1078 | 2034-06-30 | lad:seniority-SUB |
| lad:I1026 | Nevar Property 6.75% 2036 | GBP | Nevar Property 6.75% notes due 2036 | | lad:E1079 | 2028-06-30 | lad:seniority-SU |
| lad:I1027 | Gilen Capital 2.00% 2031 | USD | Gilen Capital 2.00% notes due 2031 | | lad:E1082 | 2034-06-30 | lad:seniority-SUB |
| lad:I1028 | Givim Mining 5.75% 2036 | EUR | Givim Mining 5.75% notes due 2036 | | lad:E1085 | 2034-06-30 | lad:seniority-SU |
| lad:I1029 | Gorar Steel 7.25% 2033 | USD | Gorar Steel 7.25% notes due 2033 | | lad:E1086 | 2035-06-30 | lad:seniority-SUB |
| lad:I1030 | Vitid Holdings 5.75% 2032 | EUR | Vitid Holdings 5.75% notes due 2032 | | lad:E1087 | 2034-06-30 | lad:seniority-SU |
| lad:I1031 | Koved Holdings 2.50% 2032 | EUR | Koved Holdings 2.50% notes due 2032 | | lad:E1088 | 2033-06-30 | lad:seniority-SUB |
| lad:I1032 | Getel Utilities 7.25% 2033 | USD | Getel Utilities 7.25% notes due 2033 | | lad:E1090 | 2032-06-30 | lad:seniority-SU |
| lad:I1033 | Vavam Pharma 8.75% 2032 | USD | Vavam Pharma 8.75% notes due 2032 | | lad:E1103 | 2032-06-30 | lad:seniority-SUB |
| lad:I1034 | Kisil Logistics 8.50% 2031 | EUR | Kisil Logistics 8.50% notes due 2031 | | lad:E1108 | 2033-06-30 | lad:seniority-SU |
| lad:I1035 | Verod Logistics 3.00% 2035 | GBP | Verod Logistics 3.00% notes due 2035 | | lad:E1114 | 2029-06-30 | lad:seniority-SU |
| lad:I1036 | Piren Foods 2.50% 2030 | USD | Piren Foods 2.50% notes due 2030 | | lad:E1115 | 2033-06-30 | lad:seniority-SU |
| lad:I1037 | Reter Shipping 8.00% 2028 | EUR | Reter Shipping 8.00% notes due 2028 | | lad:E1118 | 2027-06-30 | lad:seniority-SU |
| lad:I1038 | Conan Capital 4.75% 2033 | EUR | Conan Capital 4.75% notes due 2033 | | lad:E1131 | 2031-06-30 | lad:seniority-SU |
| lad:I1039 | Larid Steel 8.50% 2028 | GBP | Larid Steel 8.50% notes due 2028 | | lad:E1141 | 2033-06-30 | lad:seniority-SU |
| lad:I1040 | Woner Media 5.75% 2027 | EUR | Woner Media 5.75% notes due 2027 | | lad:E1143 | 2027-06-30 | lad:seniority-SUB |
| lad:I1041 | Kanim Pharma 3.25% 2033 | EUR | Kanim Pharma 3.25% notes due 2033 | | lad:E1145 | 2036-06-30 | lad:seniority-SUB |
| lad:I1042 | Daren Mining 5.75% 2030 | EUR | Daren Mining 5.75% notes due 2030 | | lad:E1147 | 2035-06-30 | lad:seniority-SU |
| lad:I1043 | Honel Shipping 4.50% 2028 | EUR | Honel Shipping 4.50% notes due 2028 | | lad:E1149 | 2029-06-30 | lad:seniority-SUB |
| lad:I1044 | Wavad Foods 6.75% 2035 | USD | Wavad Foods 6.75% notes due 2035 | | lad:E1155 | 2036-06-30 | lad:seniority-SU |
| lad:I1045 | Ruven Airlines 5.75% 2032 | EUR | Ruven Airlines 5.75% notes due 2032 | | lad:E1156 | 2036-06-30 | lad:seniority-SUB |
| lad:I1046 | Diled Steel 8.75% 2027 | EUR | Diled Steel 8.75% notes due 2027 | | lad:E1160 | 2029-06-30 | lad:seniority-SU |
| lad:I1047 | Wunam Telecom 5.25% 2032 | EUR | Wunam Telecom 5.25% notes due 2032 | | lad:E1162 | 2029-06-30 | lad:seniority-SU |
| lad:I1048 | Wenar Water 8.25% 2028 | EUR | Wenar Water 8.25% notes due 2028 | | lad:E1163 | 2028-06-30 | lad:seniority-SUB |
| lad:I1049 | Ranim Shipping 8.00% 2028 | USD | Ranim Shipping 8.00% notes due 2028 | | lad:E1166 | 2036-06-30 | lad:seniority-SUB |
| lad:I1050 | Fivan Holdings 2.25% 2035 | EUR | Fivan Holdings 2.25% notes due 2035 | | lad:E1168 | 2027-06-30 | lad:seniority-SU |
| lad:I1051 | Molar Shipping 3.25% 2031 | EUR | Molar Shipping 3.25% notes due 2031 | | lad:E1188 | 2028-06-30 | lad:seniority-SU |
| lad:I1052 | Divid Property 4.25% 2033 | GBP | Divid Property 4.25% notes due 2033 | | lad:E1189 | 2032-06-30 | lad:seniority-SUB |
(55 more rows not shown)
Query 4:
| s | thing | date | rt | r | ccy | o | w | a | c |
|---|---|---|---|---|---|---|---|---|---|
| lad:A37 | lad:CV | 2024-01-01 | lad:type-CC | A | | | | lad:action-AS | |
| lad:A38 | lad:CV | 2024-01-01 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A39 | lad:CV | 2024-01-01 | lad:type-LTIDR | A- | lad:basis-LC | lad:outlook-STA | | lad:action-AS | |
| lad:A01 | lad:E01 | 2024-03-12 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A02 | lad:E01 | 2025-06-20 | lad:type-LTIDR | BBB | lad:basis-FC | lad:outlook-STA | | lad:action-DG | weaker cash flow after asset sale |
| lad:A03 | lad:E01 | 2026-02-10 | lad:type-LTIDR | BBB | lad:basis-FC | lad:outlook-NEG | | lad:action-AF | |
| lad:A04 | lad:E01 | 2026-02-10 | lad:type-STIDR | F2 | lad:basis-FC | | | lad:action-AF | |
| lad:A08 | lad:E02 | 2023-11-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A09 | lad:E03 | 2025-09-15 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-POS | | lad:action-AF | |
| lad:A13 | lad:E05 | 2025-04-01 | lad:type-LTIDR | BBB- | lad:basis-LC | lad:outlook-STA | | lad:action-AS | |
| lad:A14 | lad:E05 | 2025-04-01 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A16 | lad:E06 | 2024-05-01 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A17 | lad:E06 | 2026-09-03 | lad:type-LTIDR | A- | lad:basis-FC | | lad:watch-RWN | lad:action-RW | |
| lad:A18 | lad:E07 | 2024-01-10 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A19 | lad:E07 | 2026-05-12 | lad:type-LTIDR | WD | lad:basis-FC | | | lad:action-WD | commercial reasons |
| lad:A20 | lad:E08 | 2024-06-01 | lad:type-LTIDR | B | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A21 | lad:E08 | 2026-01-20 | lad:type-LTIDR | CCC | lad:basis-FC | | | lad:action-DG | |
| lad:A22 | lad:E08 | 2026-07-08 | lad:type-LTIDR | RD | lad:basis-FC | | | lad:action-DG | distressed debt exchange completed |
| lad:A24 | lad:E09 | 2023-05-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A25 | lad:E09 | 2026-03-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-NEG | | lad:action-AF | |
| lad:A26 | lad:E10 | 2023-05-01 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | support from parent |
| lad:A27 | lad:E10 | 2026-04-15 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-DG | |
| lad:A1001 | lad:E1002 | 2022-08-18 | lad:type-LTIDR | A+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1002 | lad:E1002 | 2025-07-20 | lad:type-LTIDR | WD | lad:basis-FC | | | lad:action-WD | commercial reasons |
| lad:A1003 | lad:E1003 | 2024-07-05 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1004 | lad:E1004 | 2023-05-02 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1005 | lad:E1005 | 2022-05-02 | lad:type-LTIDR | BBB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1006 | lad:E1005 | 2023-03-19 | lad:type-LTIDR | BB+ | lad:basis-FC | lad:outlook-POS | | lad:action-DG | |
| lad:A1007 | lad:E1005 | 2025-08-02 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-NEG | | lad:action-DG | |
| lad:A1008 | lad:E1006 | 2025-08-26 | lad:type-LTIDR | AA- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1009 | lad:E1006 | 2026-04-15 | lad:type-LTIDR | AA | lad:basis-FC | lad:outlook-STA | | lad:action-UG | |
| lad:A1010 | lad:E1006 | 2026-06-17 | lad:type-LTIDR | AA | lad:basis-FC | | lad:watch-RWN | lad:action-RW | |
| lad:A1012 | lad:E1007 | 2023-06-03 | lad:type-LTIDR | BB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1013 | lad:E1007 | 2026-06-27 | lad:type-LTIDR | WD | lad:basis-FC | | | lad:action-WD | commercial reasons |
| lad:A1015 | lad:E1008 | 2022-12-09 | lad:type-LTIDR | BBB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1017 | lad:E1009 | 2022-05-02 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1019 | lad:E1010 | 2023-08-18 | lad:type-LTIDR | BBB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1020 | lad:E1011 | 2025-12-13 | lad:type-LTIDR | B+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1021 | lad:E1012 | 2024-11-09 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1022 | lad:E1012 | 2025-04-03 | lad:type-LTIDR | BB | lad:basis-FC | | lad:watch-RWN | lad:action-RW | |
| lad:A1023 | lad:E1012 | 2026-02-06 | lad:type-LTIDR | BB+ | lad:basis-FC | lad:outlook-POS | | lad:action-UG | |
| lad:A1025 | lad:E1013 | 2022-06-02 | lad:type-LTIDR | BB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1026 | lad:E1013 | 2025-07-09 | lad:type-LTIDR | BB- | lad:basis-FC | | lad:watch-RWN | lad:action-RW | |
| lad:A1028 | lad:E1014 | 2025-07-11 | lad:type-LTIDR | AA- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1030 | lad:E1015 | 2025-11-24 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1031 | lad:E1016 | 2022-06-10 | lad:type-LTIDR | B+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1032 | lad:E1016 | 2025-06-28 | lad:type-LTIDR | B+ | lad:basis-FC | lad:outlook-STA | | lad:action-AF | |
| lad:A1034 | lad:E1017 | 2022-03-03 | lad:type-LTIDR | AA- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1035 | lad:E1017 | 2024-08-09 | lad:type-LTIDR | AA | lad:basis-FC | lad:outlook-STA | | lad:action-UG | |
| lad:A1036 | lad:E1017 | 2025-04-20 | lad:type-LTIDR | AA | lad:basis-FC | lad:outlook-STA | | lad:action-AF | |
| lad:A1037 | lad:E1018 | 2025-08-11 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1039 | lad:E1019 | 2022-12-11 | lad:type-LTIDR | BB+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1040 | lad:E1019 | 2022-12-11 | lad:type-LTIDR | BBB- | lad:basis-LC | lad:outlook-STA | | lad:action-AS | |
| lad:A1041 | lad:E1019 | 2024-02-08 | lad:type-LTIDR | BBB- | lad:basis-LC | | lad:watch-RWN | lad:action-RW | |
| lad:A1042 | lad:E1019 | 2024-03-20 | lad:type-LTIDR | BBB- | lad:basis-LC | | lad:watch-RWN | lad:action-RW | |
| lad:A1043 | lad:E1020 | 2024-06-15 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1045 | lad:E1021 | 2022-06-19 | lad:type-LTIDR | BBB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1046 | lad:E1021 | 2025-11-08 | lad:type-LTIDR | WD | lad:basis-FC | | | lad:action-WD | commercial reasons |
| lad:A1048 | lad:E1023 | 2022-06-05 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A1049 | lad:E1023 | 2023-03-02 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-POS | | lad:action-DG | |
(727 more rows not shown)
Run more queries, or give the final answers.The model
```sparql
SELECT ?s ?l ?c ?et ?par ?lei WHERE { ?s a lad:Entity . OPTIONAL{?s rdfs:label ?l} OPTIONAL{?s lad:country ?c} OPTIONAL{?s lad:entityType ?et} OPTIONAL{?s lad:parent ?par} OPTIONAL{?s lad:lei ?lei} FILTER(!REGEX(STR(?s),"E1[0-9]{3}$")) } ORDER BY ?s
```
```sparql
SELECT ?s ?thing ?date ?rt ?r ?ccy ?o ?w ?a ?c WHERE { ?s a lad:RatingAction . ?s lad:ratedThing ?thing . OPTIONAL{?s lad:date ?date} OPTIONAL{?s lad:ratingType ?rt} OPTIONAL{?s lad:rating ?r} OPTIONAL{?s lad:ccyBasis ?ccy} OPTIONAL{?s lad:outlook ?o} OPTIONAL{?s lad:watch ?w} OPTIONAL{?s lad:action ?a} OPTIONAL{?s lad:comment ?c} FILTER(REGEX(STR(?thing),"/(E[0-9]{2}|I0[0-9]|CV|VD|[A-Z]{2})$")) } ORDER BY ?thing ?date
```
```sparql
SELECT ?s ?p ?o WHERE { ?s ?p ?o . FILTER(?p IN (skos:prefLabel, skos:definition, skos:note, rdfs:comment, skos:notation, skos:broader, skos:inScheme) || ?s IN (lad:CV, lad:VD)) } LIMIT 300
```
```sparql
SELECT ?s ?l ?cur ?g ?i ?m ?sen WHERE { ?s a lad:Instrument . OPTIONAL{?s rdfs:label ?l} OPTIONAL{?s lad:currency ?cur} OPTIONAL{?s lad:guarantor ?g} OPTIONAL{?s lad:issuer ?i} OPTIONAL{?s lad:maturity ?m} OPTIONAL{?s lad:seniority ?sen} FILTER(REGEX(STR(?s),"I0[0-9]$")) }
```Query results
Query 1:
| s | l | c | et | par | lei |
|---|---|---|---|---|---|
| lad:CV | Republic of Corvenia | CV | lad:etype-SOV | | |
| lad:E01 | Kestrel Energy plc | GB | lad:etype-CORP | | 7245002OOPBG04092E43 |
| lad:E02 | Northwind Holdings plc | GB | lad:etype-CORP | | 213800PHEIYNJMHTDV74 |
| lad:E03 | NORTHWIND HLDGS | GB | lad:etype-CORP | | 213800PHEIYNJMHTDV74 |
| lad:E04 | Northwind Finance BV | NL | lad:etype-FINSUB | lad:E02 | 213800LA5RYJLGXV2T85 |
| lad:E05 | Valdoria Telecom SA | VD | lad:etype-CORP | | 391200LESH03LMOY2U61 |
| lad:E06 | Orrin Bank AG | DE | lad:etype-BANK | | 549300AMVE3VRVG7HK43 |
| lad:E07 | Pellam Retail Ltd | GB | lad:etype-CORP | | 969500B6IUACELPI2291 |
| lad:E08 | Saxby Shipping SA | GR | lad:etype-CORP | | 969500KOTZ1JFIZSG796 |
| lad:E09 | Halden Group plc | GB | lad:etype-CORP | | 815600ASM9EHDG931T89 |
| lad:E10 | Halden Bank AG | DE | lad:etype-BANK | lad:E09 | 391200QYPVFF2O9K2039 |
| lad:E11 | Halden Leasing SA | FR | lad:etype-FINSUB | lad:E10 | 549300XBZH4ULO9MQV55 |
| lad:E12 | Halden Foods Ltd | GB | lad:etype-CORP | | 213800IJDL4OJ4DG5T19 |
| lad:E13 | Orrin Bancorp Inc | US | lad:etype-BANK | | 815600O8X8K2F154N214 |
| lad:E14 | Marlow Utilities plc | GB | lad:etype-CORP | | 3912005AH2C1I9YF8106 |
| lad:E15 | Corvenia Power SA | CV | lad:etype-CORP | | 213800PBQVHVBBH6GV02 |
| lad:E16 | Brindle Capital Ltd | GB | lad:etype-CORP | | 5493003Z3PXXR7KNFM81 |
| lad:E17 | HALDEN BANK | LU | lad:etype-BANK | | 391200QYPVFF2O9K2039 |
| lad:VD | Republic of Valdoria | VD | lad:etype-SOV | | |
Query 2:
| s | thing | date | rt | r | ccy | o | w | a | c |
|---|---|---|---|---|---|---|---|---|---|
| lad:A37 | lad:CV | 2024-01-01 | lad:type-CC | A | | | | lad:action-AS | |
| lad:A38 | lad:CV | 2024-01-01 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A39 | lad:CV | 2024-01-01 | lad:type-LTIDR | A- | lad:basis-LC | lad:outlook-STA | | lad:action-AS | |
| lad:A01 | lad:E01 | 2024-03-12 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A02 | lad:E01 | 2025-06-20 | lad:type-LTIDR | BBB | lad:basis-FC | lad:outlook-STA | | lad:action-DG | weaker cash flow after asset sale |
| lad:A03 | lad:E01 | 2026-02-10 | lad:type-LTIDR | BBB | lad:basis-FC | lad:outlook-NEG | | lad:action-AF | |
| lad:A04 | lad:E01 | 2026-02-10 | lad:type-STIDR | F2 | lad:basis-FC | | | lad:action-AF | |
| lad:A08 | lad:E02 | 2023-11-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A09 | lad:E03 | 2025-09-15 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-POS | | lad:action-AF | |
| lad:A13 | lad:E05 | 2025-04-01 | lad:type-LTIDR | BBB- | lad:basis-LC | lad:outlook-STA | | lad:action-AS | |
| lad:A14 | lad:E05 | 2025-04-01 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A16 | lad:E06 | 2024-05-01 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A17 | lad:E06 | 2026-09-03 | lad:type-LTIDR | A- | lad:basis-FC | | lad:watch-RWN | lad:action-RW | |
| lad:A18 | lad:E07 | 2024-01-10 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A19 | lad:E07 | 2026-05-12 | lad:type-LTIDR | WD | lad:basis-FC | | | lad:action-WD | commercial reasons |
| lad:A20 | lad:E08 | 2024-06-01 | lad:type-LTIDR | B | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A21 | lad:E08 | 2026-01-20 | lad:type-LTIDR | CCC | lad:basis-FC | | | lad:action-DG | |
| lad:A22 | lad:E08 | 2026-07-08 | lad:type-LTIDR | RD | lad:basis-FC | | | lad:action-DG | distressed debt exchange completed |
| lad:A24 | lad:E09 | 2023-05-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A25 | lad:E09 | 2026-03-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-NEG | | lad:action-AF | |
| lad:A26 | lad:E10 | 2023-05-01 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | support from parent |
| lad:A27 | lad:E10 | 2026-04-15 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-DG | |
| lad:A46 | lad:E11 | 2025-02-01 | lad:type-CO | BBB | | | | lad:action-AS | |
| lad:A30 | lad:E12 | 2024-02-01 | lad:type-LTIDR | BB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A31 | lad:E12 | 2025-08-01 | lad:type-LTIDR | BB | lad:basis-FC | lad:outlook-STA | | lad:action-UG | |
| lad:A32 | lad:E13 | 2024-07-01 | lad:type-LTIDR | BBB | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A34 | lad:E14 | 2023-01-15 | lad:type-LTIDR | A- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A36 | lad:E14 | 2024-09-30 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-DG | |
| lad:A35 | lad:E14 | 2025-11-20 | lad:type-LTIDR | BBB+ | lad:basis-FC | | lad:watch-RWN | lad:action-RW | |
| lad:A33 | lad:E14 | 2026-05-01 | lad:type-LTIDR | BBB+ | lad:basis-FC | lad:outlook-STA | | lad:action-AF | |
| lad:A40 | lad:E15 | 2024-03-01 | lad:type-LTIDR | A+ | lad:basis-LC | lad:outlook-STA | | lad:action-AS | |
| lad:A41 | lad:E15 | 2024-03-01 | lad:type-LTIDR | A | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A43 | lad:E16 | 2024-04-01 | lad:type-LTIDR | BBB- | lad:basis-FC | lad:outlook-STA | | lad:action-AS | |
| lad:A44 | lad:E16 | 2026-06-01 | lad:type-LTIDR | BB+ | lad:basis-FC | lad:outlook-STA | | lad:action-DG | |
| lad:A05 | lad:I01 | 2024-03-12 | lad:type-INST | A- | | | | lad:action-AS | |
| lad:A06 | lad:I01 | 2025-06-20 | lad:type-INST | BBB | | | | lad:action-DG | |
| lad:A23 | lad:I02 | 2024-03-12 | lad:type-INST | BBB | | | | lad:action-AS | |
| lad:A07 | lad:I02 | 2025-06-20 | lad:type-INST | BB+ | | | | lad:action-DG | |
| lad:A10 | lad:I03 | 2023-11-01 | lad:type-INST | A | | | | lad:action-AS | |
| lad:A11 | lad:I03 | 2025-09-15 | lad:type-INST | A | | | | lad:action-AF | |
| lad:A15 | lad:I04 | 2025-04-01 | lad:type-INST | BB | | | | lad:action-AS | |
| lad:A28 | lad:I05 | 2023-06-01 | lad:type-INST | A- | | | | lad:action-AS | |
| lad:A29 | lad:I05 | 2026-04-15 | lad:type-INST | BBB+ | | | | lad:action-DG | |
| lad:A42 | lad:I06 | 2024-03-01 | lad:type-INST | A- | | | | lad:action-AS | |
| lad:A45 | lad:I07 | 2025-04-01 | lad:type-INST | BBB- | | | | lad:action-AS | |
| lad:A47 | lad:I08 | 2026-09-01 | lad:type-INST | A | | | | lad:action-EX | |
| lad:A12 | lad:VD | 2025-04-01 | lad:type-CC | BB | | | | lad:action-AS | |
Query 3:
| s | p | o |
|---|---|---|
| lad:CV | lad:name | Republic of Corvenia |
| lad:VD | lad:name | Republic of Valdoria |
| lad:VD | lad:country | VD |
| lad:CV | rdf:type | lad:Entity |
| lad:VD | lad:entityType | lad:etype-SOV |
| lad:CV | lad:country | CV |
| lad:VD | rdf:type | lad:Entity |
| lad:CV | rdfs:label | Republic of Corvenia |
| lad:CV | lad:sourceSystem | RATINGS |
| lad:VD | rdfs:label | Republic of Valdoria |
| lad:VD | lad:sourceSystem | RATINGS |
| lad:CV | lad:entityType | lad:etype-SOV |
Query 4:
| s | l | cur | g | i | m | sen |
|---|---|---|---|---|---|---|
| lad:I04 | Valdoria Telecom 5.00% 2029 | USD | | lad:E05 | 2029-11-20 | lad:seniority-SU |
| lad:I06 | Corvenia Power 7.10% 2032 | USD | | lad:E15 | 2032-02-15 | lad:seniority-SUB |
| lad:I07 | Valdoria Telecom 4.25% 2027 | XVD | | lad:E05 | 2027-08-31 | lad:seniority-SU |
| lad:I08 | Corvenia Power 6.00% 2034 | USD | | lad:E15 | 2034-09-01 | lad:seniority-SU |
| lad:I01 | Kestrel Energy 4.50% 2030 | GBP | | lad:E01 | 2030-03-15 | lad:seniority-SU |
| lad:I02 | Kestrel Energy 6.25% 2031 | GBP | | lad:E01 | 2031-09-30 | lad:seniority-SUB |
| lad:I03 | Northwind Finance 3.75% 2030 | EUR | lad:E02 | lad:E04 | 2030-05-01 | lad:seniority-SU |
| lad:I05 | Halden Leasing 2.90% 2028 | EUR | lad:E10 | lad:E11 | 2028-06-30 | lad:seniority-SU |
Run more queries, or give the final answers.The model
```sparql
SELECT ?t ?d ?r ?a WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:action ?a; lad:rating ?r; lad:ratingType ?rt . FILTER(?a=lad:action-DG && ?d>="2026-01-01"^^xsd:date && ?d<="2026-12-31"^^xsd:date && ?rt=lad:type-LTIDR) } ORDER BY ?t
```
```sparql
SELECT ?t ?d ?r ?ccy WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-LTIDR . OPTIONAL{?s lad:ccyBasis ?ccy} FILTER(?r IN ("RD","D","C")) } ORDER BY ?t ?d
```
```sparql
SELECT ?t ?c ?r ?ccy ?o ?w ?d WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-LTIDR . OPTIONAL{?s lad:ccyBasis ?ccy} OPTIONAL{?s lad:outlook ?o} OPTIONAL{?s lad:watch ?w} OPTIONAL{?t lad:country ?c}
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . OPTIONAL{?s2 lad:ccyBasis ?c2} FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d && COALESCE(?c2,"")=COALESCE(?ccy,"")) }
FILTER(?r!="WD" && (?w=lad:watch-RWN || ?o=lad:outlook-NEG || ?c IN ("CV","VD","LU"))) } ORDER BY ?t
```
```sparql
SELECT (COUNT(DISTINCT ?t) AS ?n) (COUNT(DISTINCT ?lei) AS ?nl) (COUNT(DISTINCT ?gb) AS ?ngb) WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-LTIDR . ?t lad:lei ?lei . OPTIONAL{?t lad:country "GB" . BIND(?lei AS ?gb)}
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d) }
FILTER(?r!="WD") }
```
```sparql
SELECT ?i ?r ?d WHERE { ?s lad:ratedThing ?i; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-INST .
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?i; lad:ratingType lad:type-INST; lad:date ?d2 . FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d) } FILTER(?i NOT IN (lad:I01,lad:I02,lad:I03,lad:I04,lad:I05,lad:I06,lad:I07)) }
```
```sparql
SELECT ?e ?c WHERE { ?e lad:country ?c . FILTER(?c="LU") }
```Query results
Query 1:
| t | d | r | a |
|---|---|---|---|
| lad:E08 | 2026-01-20 | CCC | lad:action-DG |
| lad:E08 | 2026-07-08 | RD | lad:action-DG |
| lad:E10 | 2026-04-15 | BBB+ | lad:action-DG |
| lad:E1034 | 2026-05-02 | BBB+ | lad:action-DG |
| lad:E1051 | 2026-04-05 | A+ | lad:action-DG |
| lad:E1051 | 2026-06-01 | A+ | lad:action-DG |
| lad:E1053 | 2026-03-20 | BB | lad:action-DG |
| lad:E1057 | 2026-06-25 | BB | lad:action-DG |
| lad:E1058 | 2026-07-14 | BBB- | lad:action-DG |
| lad:E1064 | 2026-03-04 | BBB+ | lad:action-DG |
| lad:E1080 | 2026-02-14 | A- | lad:action-DG |
| lad:E1093 | 2026-07-25 | B | lad:action-DG |
| lad:E1112 | 2026-02-20 | BBB | lad:action-DG |
| lad:E1144 | 2026-06-06 | B+ | lad:action-DG |
| lad:E1151 | 2026-01-26 | BBB | lad:action-DG |
| lad:E1159 | 2026-06-16 | BBB+ | lad:action-DG |
| lad:E1161 | 2026-07-28 | B | lad:action-DG |
| lad:E1163 | 2026-03-19 | BB+ | lad:action-DG |
| lad:E1167 | 2026-09-07 | BB | lad:action-DG |
| lad:E1170 | 2026-08-16 | BB- | lad:action-DG |
| lad:E1186 | 2026-01-04 | BBB+ | lad:action-DG |
| lad:E1213 | 2026-02-13 | A- | lad:action-DG |
| lad:E1213 | 2026-06-16 | BBB+ | lad:action-DG |
| lad:E1228 | 2026-06-28 | BB+ | lad:action-DG |
| lad:E1229 | 2026-06-02 | BB+ | lad:action-DG |
| lad:E1229 | 2026-05-06 | BB | lad:action-DG |
| lad:E1243 | 2026-01-13 | BB | lad:action-DG |
| lad:E1255 | 2026-01-19 | BBB+ | lad:action-DG |
| lad:E1263 | 2026-03-03 | BBB | lad:action-DG |
| lad:E1263 | 2026-06-16 | BBB- | lad:action-DG |
| lad:E1285 | 2026-02-17 | A | lad:action-DG |
| lad:E1290 | 2026-08-16 | B | lad:action-DG |
| lad:E1294 | 2026-07-11 | A+ | lad:action-DG |
| lad:E1299 | 2026-02-06 | BBB | lad:action-DG |
| lad:E1300 | 2026-04-09 | BBB+ | lad:action-DG |
| lad:E1300 | 2026-05-06 | BBB | lad:action-DG |
| lad:E1307 | 2026-02-08 | BB- | lad:action-DG |
| lad:E1340 | 2026-06-26 | BBB+ | lad:action-DG |
| lad:E1341 | 2026-11-09 | BBB+ | lad:action-DG |
| lad:E1342 | 2026-07-17 | BBB+ | lad:action-DG |
| lad:E1343 | 2026-08-08 | BBB+ | lad:action-DG |
| lad:E1344 | 2026-03-18 | A- | lad:action-DG |
| lad:E1345 | 2026-09-22 | BB- | lad:action-DG |
| lad:E1346 | 2026-10-15 | BBB+ | lad:action-DG |
| lad:E1347 | 2026-03-10 | BBB- | lad:action-DG |
| lad:E1348 | 2026-03-18 | BBB- | lad:action-DG |
| lad:E1349 | 2026-10-14 | A- | lad:action-DG |
| lad:E1350 | 2026-09-03 | BB | lad:action-DG |
| lad:E1351 | 2026-09-27 | A- | lad:action-DG |
| lad:E16 | 2026-06-01 | BB+ | lad:action-DG |
Query 2:
| t | d | r | ccy |
|---|---|---|---|
| lad:E08 | 2026-07-08 | RD | lad:basis-FC |
Query 3:
| t | c | r | ccy | o | w | d |
|---|---|---|---|---|---|---|
| lad:CV | CV | BBB+ | lad:basis-FC | lad:outlook-STA | | 2024-01-01 |
| lad:CV | CV | A- | lad:basis-LC | lad:outlook-STA | | 2024-01-01 |
| lad:E01 | GB | BBB | lad:basis-FC | lad:outlook-NEG | | 2026-02-10 |
| lad:E05 | VD | BBB- | lad:basis-LC | lad:outlook-STA | | 2025-04-01 |
| lad:E05 | VD | BB | lad:basis-FC | lad:outlook-STA | | 2025-04-01 |
| lad:E06 | DE | A- | lad:basis-FC | | lad:watch-RWN | 2026-09-03 |
| lad:E09 | GB | A | lad:basis-FC | lad:outlook-NEG | | 2026-03-01 |
| lad:E1005 | US | BB | lad:basis-FC | lad:outlook-NEG | | 2025-08-02 |
| lad:E1006 | US | AA | lad:basis-FC | | lad:watch-RWN | 2026-06-17 |
| lad:E1013 | NL | BB- | lad:basis-FC | | lad:watch-RWN | 2025-07-09 |
| lad:E1019 | CV | BB+ | lad:basis-FC | lad:outlook-STA | | 2022-12-11 |
| lad:E1019 | CV | BBB- | lad:basis-LC | | lad:watch-RWN | 2024-03-20 |
| lad:E1028 | VD | BB | lad:basis-FC | lad:outlook-STA | | 2025-12-25 |
| lad:E1028 | VD | BBB | lad:basis-LC | lad:outlook-STA | | 2025-12-05 |
| lad:E1029 | US | A- | lad:basis-FC | lad:outlook-NEG | | 2025-08-08 |
| lad:E1034 | IT | BBB+ | lad:basis-FC | lad:outlook-NEG | | 2026-05-02 |
| lad:E1037 | FR | A | lad:basis-FC | | lad:watch-RWN | 2022-05-07 |
| lad:E1039 | CV | A | lad:basis-FC | | lad:watch-RWN | 2025-12-09 |
| lad:E1039 | CV | AA- | lad:basis-LC | lad:outlook-STA | | 2025-11-22 |
| lad:E1046 | US | AA- | lad:basis-FC | lad:outlook-NEG | | 2025-05-28 |
| lad:E1055 | GB | BBB- | lad:basis-FC | lad:outlook-NEG | | 2024-12-04 |
| lad:E1056 | IT | A+ | lad:basis-FC | lad:outlook-NEG | | 2023-01-01 |
| lad:E1059 | CV | BB- | lad:basis-LC | | lad:watch-RWN | 2026-02-23 |
| lad:E1060 | CV | BB- | lad:basis-FC | lad:outlook-NEG | | 2025-02-16 |
| lad:E1061 | DE | A | lad:basis-FC | | lad:watch-RWN | 2025-06-06 |
| lad:E1064 | NL | A- | lad:basis-FC | lad:outlook-NEG | | 2026-06-03 |
| lad:E1066 | ES | A- | lad:basis-FC | | lad:watch-RWN | 2026-05-03 |
| lad:E1071 | CV | B+ | lad:basis-FC | lad:outlook-STA | | 2023-01-11 |
| lad:E1072 | GB | BB- | lad:basis-FC | lad:outlook-NEG | | 2026-02-07 |
| lad:E1079 | GB | BB+ | lad:basis-FC | lad:outlook-NEG | | 2024-01-26 |
| lad:E1080 | US | A- | lad:basis-FC | lad:outlook-NEG | | 2026-02-14 |
| lad:E1088 | FR | B+ | lad:basis-FC | | lad:watch-RWN | 2024-01-16 |
| lad:E1096 | CV | BBB | lad:basis-FC | lad:outlook-STA | | 2024-04-04 |
| lad:E1096 | CV | BBB+ | lad:basis-LC | lad:outlook-POS | | 2025-02-17 |
| lad:E1098 | US | BBB- | lad:basis-FC | | lad:watch-RWN | 2026-04-28 |
| lad:E1099 | FR | BB+ | lad:basis-FC | | lad:watch-RWN | 2023-11-05 |
| lad:E1101 | VD | BB | lad:basis-FC | lad:outlook-STA | | 2022-10-26 |
| lad:E1101 | VD | BB+ | lad:basis-LC | lad:outlook-STA | | 2022-10-26 |
| lad:E1105 | GR | A+ | lad:basis-FC | lad:outlook-NEG | | 2024-01-13 |
| lad:E1106 | VD | B+ | lad:basis-FC | lad:outlook-STA | | 2024-10-26 |
| lad:E1109 | NL | A+ | lad:basis-FC | | lad:watch-RWN | 2025-12-25 |
| lad:E1118 | DE | BB+ | lad:basis-FC | lad:outlook-NEG | | 2025-07-14 |
| lad:E1126 | VD | BB | lad:basis-FC | | lad:watch-RWN | 2025-07-10 |
| lad:E1126 | VD | BBB- | lad:basis-LC | lad:outlook-STA | | 2024-04-11 |
| lad:E1132 | US | B+ | lad:basis-FC | | lad:watch-RWN | 2025-08-24 |
| lad:E1133 | US | B+ | lad:basis-FC | | lad:watch-RWN | 2025-10-11 |
| lad:E1136 | CV | A- | lad:basis-FC | lad:outlook-STA | | 2023-07-04 |
| lad:E1144 | CV | B+ | lad:basis-FC | lad:outlook-POS | | 2026-06-06 |
| lad:E1144 | CV | BB- | lad:basis-LC | lad:outlook-POS | | 2024-07-19 |
| lad:E1146 | US | BB | lad:basis-FC | | lad:watch-RWN | 2025-08-12 |
| lad:E1158 | ES | BBB | lad:basis-FC | lad:outlook-NEG | | 2026-08-14 |
| lad:E1161 | FR | B | lad:basis-FC | lad:outlook-NEG | | 2026-07-28 |
| lad:E1168 | US | BBB- | lad:basis-FC | | lad:watch-RWN | 2023-10-12 |
| lad:E1181 | IT | A- | lad:basis-FC | | lad:watch-RWN | 2025-01-06 |
| lad:E1185 | CV | BB+ | lad:basis-FC | lad:outlook-STA | | 2025-02-28 |
| lad:E1188 | GR | BB- | lad:basis-FC | lad:outlook-NEG | | 2024-09-05 |
| lad:E1190 | GB | BBB | lad:basis-FC | lad:outlook-NEG | | 2025-05-24 |
| lad:E1194 | CV | A | lad:basis-FC | | lad:watch-RWN | 2025-01-20 |
| lad:E1194 | CV | A | lad:basis-LC | lad:outlook-STA | | 2024-03-23 |
| lad:E1203 | DE | BBB+ | lad:basis-FC | | lad:watch-RWN | 2023-09-02 |
(47 more rows not shown)
Query 4:
| n | nl | ngb |
|---|---|---|
| 290 | 288 | 0 |
Query 5:
| i | r | d |
|---|---|---|
| lad:I1002 | BB- | 2023-06-03 |
| lad:I1003 | BBB- | 2022-12-09 |
| lad:I1004 | A | 2022-05-02 |
| lad:I1005 | BB | 2024-11-09 |
| lad:I1006 | B+ | 2022-06-02 |
| lad:I1008 | B+ | 2026-05-23 |
| lad:I1009 | A- | 2025-08-11 |
| lad:I1010 | A- | 2024-06-15 |
| lad:I1011 | BBB- | 2022-06-19 |
| lad:I1012 | A- | 2026-07-22 |
| lad:I1013 | BB+ | 2025-12-06 |
| lad:I1014 | A- | 2022-10-23 |
| lad:I1016 | A+ | 2023-01-01 |
| lad:I1017 | BB | 2022-12-22 |
| lad:I1018 | BB+ | 2022-04-18 |
| lad:I1019 | BB+ | 2025-09-02 |
| lad:I1020 | BB+ | 2024-03-25 |
| lad:I1021 | AA- | 2026-09-18 |
| lad:I1022 | BB+ | 2022-07-09 |
| lad:I1023 | B | 2023-01-11 |
| lad:I1024 | BB | 2022-05-09 |
| lad:I1025 | BB+ | 2022-02-01 |
| lad:I1026 | BB+ | 2022-06-05 |
| lad:I1027 | BBB | 2024-12-28 |
| lad:I1028 | A- | 2022-04-17 |
| lad:I1029 | A+ | 2025-02-24 |
| lad:I1030 | BBB- | 2024-10-14 |
| lad:I1031 | B | 2022-07-14 |
| lad:I1032 | BB- | 2024-07-05 |
| lad:I1033 | B | 2024-12-05 |
| lad:I1034 | A- | 2025-03-25 |
| lad:I1035 | BB | 2024-09-12 |
| lad:I1036 | A+ | 2022-09-01 |
| lad:I1037 | BBB- | 2022-10-15 |
| lad:I1038 | BBB+ | 2025-11-01 |
| lad:I1039 | AA- | 2023-01-03 |
| lad:I1040 | A+ | 2023-02-16 |
| lad:I1041 | BB | 2025-06-04 |
| lad:I1042 | A+ | 2025-04-10 |
| lad:I1043 | A+ | 2025-11-14 |
| lad:I1044 | BB- | 2025-02-14 |
| lad:I1045 | A | 2025-09-01 |
| lad:I1046 | B+ | 2026-05-18 |
| lad:I1047 | A+ | 2025-10-19 |
| lad:I1048 | BB+ | 2023-09-18 |
| lad:I1049 | BB- | 2026-03-17 |
| lad:I1050 | BBB- | 2023-07-22 |
| lad:I1051 | B+ | 2023-09-26 |
| lad:I1052 | BBB | 2023-06-07 |
| lad:I1053 | BBB- | 2023-07-09 |
| lad:I1054 | A+ | 2025-04-07 |
| lad:I1055 | A | 2024-02-23 |
| lad:I1056 | A- | 2025-03-28 |
| lad:I1057 | AA- | 2025-05-09 |
| lad:I1058 | A- | 2023-11-16 |
| lad:I1059 | BB+ | 2023-06-18 |
| lad:I1060 | A | 2022-06-20 |
| lad:I1061 | A+ | 2024-11-12 |
| lad:I1062 | BBB- | 2024-11-01 |
| lad:I1063 | BBB- | 2023-03-06 |
(45 more rows not shown)
Query 6:
| e | c |
|---|---|
| lad:E17 | LU |
Run more queries, or give the final answers.The model
```sparql
SELECT ?t ?r ?o ?w ?d ?ccy WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-LTIDR . OPTIONAL{?s lad:ccyBasis ?ccy} OPTIONAL{?s lad:outlook ?o} OPTIONAL{?s lad:watch ?w}
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . OPTIONAL{?s2 lad:ccyBasis ?c2} FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d && COALESCE(?c2,"")=COALESCE(?ccy,"")) }
FILTER(?w=lad:watch-RWN || ?o=lad:outlook-NEG) FILTER(?ccy=lad:basis-FC) } ORDER BY ?t
```
```sparql
SELECT ?t (MAX(?d) AS ?last) WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating "WD"; lad:ratingType lad:type-LTIDR . FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d) } } GROUP BY ?t ORDER BY ?t
```
```sparql
SELECT (COUNT(DISTINCT ?i) AS ?n) (SUM(IF(?r IN ("AAA","AA+","AA","AA-","A+","A","A-","BBB+","BBB","BBB-"),1,0)) AS ?ig) WHERE { ?s lad:ratedThing ?i; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-INST . ?i a lad:Instrument .
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?i; lad:ratingType lad:type-INST; lad:date ?d2 . FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d) } FILTER(?r!="WD") }
```
```sparql
SELECT ?e ?s ?r ?d WHERE { ?s lad:ratedThing ?e; lad:rating ?r; lad:date ?d; lad:ratingType lad:type-LTIDR . FILTER(?r IN ("D","RD","C")) }
```Query results
Query 1:
| t | r | o | w | d | ccy |
|---|---|---|---|---|---|
| lad:E01 | BBB | lad:outlook-NEG | | 2026-02-10 | lad:basis-FC |
| lad:E06 | A- | | lad:watch-RWN | 2026-09-03 | lad:basis-FC |
| lad:E09 | A | lad:outlook-NEG | | 2026-03-01 | lad:basis-FC |
| lad:E1005 | BB | lad:outlook-NEG | | 2025-08-02 | lad:basis-FC |
| lad:E1006 | AA | | lad:watch-RWN | 2026-06-17 | lad:basis-FC |
| lad:E1013 | BB- | | lad:watch-RWN | 2025-07-09 | lad:basis-FC |
| lad:E1029 | A- | lad:outlook-NEG | | 2025-08-08 | lad:basis-FC |
| lad:E1034 | BBB+ | lad:outlook-NEG | | 2026-05-02 | lad:basis-FC |
| lad:E1037 | A | | lad:watch-RWN | 2022-05-07 | lad:basis-FC |
| lad:E1039 | A | | lad:watch-RWN | 2025-12-09 | lad:basis-FC |
| lad:E1046 | AA- | lad:outlook-NEG | | 2025-05-28 | lad:basis-FC |
| lad:E1055 | BBB- | lad:outlook-NEG | | 2024-12-04 | lad:basis-FC |
| lad:E1056 | A+ | lad:outlook-NEG | | 2023-01-01 | lad:basis-FC |
| lad:E1060 | BB- | lad:outlook-NEG | | 2025-02-16 | lad:basis-FC |
| lad:E1061 | A | | lad:watch-RWN | 2025-06-06 | lad:basis-FC |
| lad:E1064 | A- | lad:outlook-NEG | | 2026-06-03 | lad:basis-FC |
| lad:E1066 | A- | | lad:watch-RWN | 2026-05-03 | lad:basis-FC |
| lad:E1072 | BB- | lad:outlook-NEG | | 2026-02-07 | lad:basis-FC |
| lad:E1079 | BB+ | lad:outlook-NEG | | 2024-01-26 | lad:basis-FC |
| lad:E1080 | A- | lad:outlook-NEG | | 2026-02-14 | lad:basis-FC |
| lad:E1088 | B+ | | lad:watch-RWN | 2024-01-16 | lad:basis-FC |
| lad:E1098 | BBB- | | lad:watch-RWN | 2026-04-28 | lad:basis-FC |
| lad:E1099 | BB+ | | lad:watch-RWN | 2023-11-05 | lad:basis-FC |
| lad:E1105 | A+ | lad:outlook-NEG | | 2024-01-13 | lad:basis-FC |
| lad:E1109 | A+ | | lad:watch-RWN | 2025-12-25 | lad:basis-FC |
| lad:E1118 | BB+ | lad:outlook-NEG | | 2025-07-14 | lad:basis-FC |
| lad:E1126 | BB | | lad:watch-RWN | 2025-07-10 | lad:basis-FC |
| lad:E1132 | B+ | | lad:watch-RWN | 2025-08-24 | lad:basis-FC |
| lad:E1133 | B+ | | lad:watch-RWN | 2025-10-11 | lad:basis-FC |
| lad:E1146 | BB | | lad:watch-RWN | 2025-08-12 | lad:basis-FC |
| lad:E1158 | BBB | lad:outlook-NEG | | 2026-08-14 | lad:basis-FC |
| lad:E1161 | B | lad:outlook-NEG | | 2026-07-28 | lad:basis-FC |
| lad:E1168 | BBB- | | lad:watch-RWN | 2023-10-12 | lad:basis-FC |
| lad:E1181 | A- | | lad:watch-RWN | 2025-01-06 | lad:basis-FC |
| lad:E1188 | BB- | lad:outlook-NEG | | 2024-09-05 | lad:basis-FC |
| lad:E1190 | BBB | lad:outlook-NEG | | 2025-05-24 | lad:basis-FC |
| lad:E1194 | A | | lad:watch-RWN | 2025-01-20 | lad:basis-FC |
| lad:E1203 | BBB+ | | lad:watch-RWN | 2023-09-02 | lad:basis-FC |
| lad:E1210 | BB | | lad:watch-RWN | 2024-09-09 | lad:basis-FC |
| lad:E1211 | BBB- | lad:outlook-NEG | | 2024-09-26 | lad:basis-FC |
| lad:E1228 | BB+ | lad:outlook-NEG | | 2026-06-28 | lad:basis-FC |
| lad:E1238 | AA- | | lad:watch-RWN | 2026-07-27 | lad:basis-FC |
| lad:E1242 | BBB | | lad:watch-RWN | 2025-09-11 | lad:basis-FC |
| lad:E1248 | A- | lad:outlook-NEG | | 2026-05-02 | lad:basis-FC |
| lad:E1260 | BBB- | | lad:watch-RWN | 2025-09-05 | lad:basis-FC |
| lad:E1262 | B+ | lad:outlook-NEG | | 2024-10-13 | lad:basis-FC |
| lad:E1263 | BBB- | lad:outlook-NEG | | 2026-06-16 | lad:basis-FC |
| lad:E1264 | B+ | | lad:watch-RWN | 2024-05-18 | lad:basis-FC |
| lad:E1266 | BBB | | lad:watch-RWN | 2026-07-20 | lad:basis-FC |
| lad:E1267 | A- | | lad:watch-RWN | 2023-12-15 | lad:basis-FC |
| lad:E1271 | A- | lad:outlook-NEG | | 2025-10-15 | lad:basis-FC |
| lad:E1282 | BB+ | lad:outlook-NEG | | 2024-03-20 | lad:basis-FC |
| lad:E1294 | A+ | lad:outlook-NEG | | 2026-07-11 | lad:basis-FC |
| lad:E1297 | BBB | | lad:watch-RWN | 2026-09-01 | lad:basis-FC |
| lad:E1300 | BBB | lad:outlook-NEG | | 2026-05-06 | lad:basis-FC |
| lad:E1314 | BBB | | lad:watch-RWN | 2024-06-26 | lad:basis-FC |
| lad:E1317 | BB | | lad:watch-RWN | 2024-09-11 | lad:basis-FC |
| lad:E1323 | AA- | | lad:watch-RWN | 2025-01-06 | lad:basis-FC |
| lad:E1340 | BBB+ | lad:outlook-NEG | | 2026-06-26 | lad:basis-FC |
| lad:E1342 | BBB+ | lad:outlook-NEG | | 2026-07-17 | lad:basis-FC |
(7 more rows not shown)
Query 2:
| t | last |
|---|---|
| lad:E07 | 2026-05-12 |
| lad:E1002 | 2025-07-20 |
| lad:E1007 | 2026-06-27 |
| lad:E1021 | 2025-11-08 |
| lad:E1032 | 2026-09-15 |
| lad:E1041 | 2024-04-09 |
| lad:E1048 | 2023-04-15 |
| lad:E1057 | 2026-09-19 |
| lad:E1062 | 2025-03-28 |
| lad:E1063 | 2025-01-12 |
| lad:E1076 | 2024-04-28 |
| lad:E1084 | 2025-08-02 |
| lad:E1106 | 2025-08-10 |
| lad:E1107 | 2024-10-16 |
| lad:E1121 | 2024-10-23 |
| lad:E1124 | 2024-06-15 |
| lad:E1138 | 2024-12-26 |
| lad:E1140 | 2025-09-15 |
| lad:E1155 | 2026-03-22 |
| lad:E1159 | 2026-09-22 |
| lad:E1166 | 2023-07-26 |
| lad:E1172 | 2026-03-12 |
| lad:E1200 | 2023-11-03 |
| lad:E1205 | 2025-11-16 |
| lad:E1206 | 2025-11-20 |
| lad:E1218 | 2026-05-22 |
| lad:E1219 | 2026-04-11 |
| lad:E1225 | 2025-06-12 |
| lad:E1233 | 2025-01-24 |
| lad:E1234 | 2026-09-22 |
| lad:E1244 | 2024-04-18 |
| lad:E1254 | 2025-08-13 |
| lad:E1277 | 2025-12-14 |
| lad:E1279 | 2024-11-17 |
| lad:E1308 | 2025-06-19 |
| lad:E1316 | 2024-07-07 |
| lad:E1320 | 2023-10-15 |
Query 3:
| n | ig |
|---|---|
| 112 | 69 |
Query 4:
| e | s | r | d |
|---|---|---|---|
| lad:E08 | lad:A22 | RD | 2026-07-08 |
Run more queries, or give the final answers.The model
```sparql
SELECT ?p ?o WHERE { lad:action-EX ?p ?o }
```
```sparql
SELECT ?s ?p ?o WHERE { ?s ?p ?o . FILTER(?s IN (lad:E17, lad:E11, lad:E12, lad:E13)) FILTER(?p IN (lad:sourceSystem, lad:parent, lad:country)) }
```
```sparql
SELECT (COUNT(DISTINCT ?e) AS ?ents) (COUNT(DISTINCT ?lei) AS ?leis) WHERE { ?e a lad:Entity . OPTIONAL{?e lad:lei ?lei} }
```
```sparql
SELECT (COUNT(DISTINCT ?lei) AS ?gb) WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-LTIDR . ?t lad:lei ?lei; lad:country "GB" .
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d) }
FILTER(?r!="WD") }
```
```sparql
SELECT DISTINCT ?t WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:ratingType lad:type-LTIDR . OPTIONAL{?s lad:ccyBasis ?ccy} ?s lad:watch lad:watch-RWN .
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . OPTIONAL{?s2 lad:ccyBasis ?c2} FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d && COALESCE(?c2,"")=COALESCE(?ccy,"")) } } ORDER BY ?t
```
```sparql
SELECT DISTINCT ?t WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:ratingType lad:type-LTIDR . OPTIONAL{?s lad:ccyBasis ?ccy} ?s lad:outlook lad:outlook-NEG .
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . OPTIONAL{?s2 lad:ccyBasis ?c2} FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d && COALESCE(?c2,"")=COALESCE(?ccy,"")) } } ORDER BY ?t
```
```sparql
SELECT ?t ?c ?r ?ccy ?d WHERE { ?s lad:ratedThing ?t; lad:date ?d; lad:rating ?r; lad:ratingType lad:type-LTIDR . ?t lad:country ?c . OPTIONAL{?s lad:ccyBasis ?ccy} FILTER(?c IN ("CV","VD"))
FILTER(?d<="2026-10-01"^^xsd:date)
FILTER NOT EXISTS { ?s2 lad:ratedThing ?t; lad:ratingType lad:type-LTIDR; lad:date ?d2 . OPTIONAL{?s2 lad:ccyBasis ?c2} FILTER(?d2<="2026-10-01"^^xsd:date && ?d2>?d && COALESCE(?c2,"")=COALESCE(?ccy,"")) } } ORDER BY ?c ?t
```Query results
Query 1:
(no rows)
Query 2:
| s | p | o |
|---|---|---|
| lad:E17 | lad:sourceSystem | RESEARCH |
| lad:E11 | lad:country | FR |
| lad:E12 | lad:country | GB |
| lad:E13 | lad:sourceSystem | RATINGS |
| lad:E13 | lad:country | US |
| lad:E11 | lad:parent | lad:E10 |
| lad:E17 | lad:country | LU |
| lad:E11 | lad:sourceSystem | RATINGS |
| lad:E12 | lad:sourceSystem | RATINGS |
Query 3:
| ents | leis |
|---|---|
| 370 | 342 |
Query 4:
| gb |
|---|
| 74 |
Query 5:
| t |
|---|
| lad:E06 |
| lad:E1006 |
| lad:E1013 |
| lad:E1019 |
| lad:E1037 |
| lad:E1039 |
| lad:E1059 |
| lad:E1061 |
| lad:E1066 |
| lad:E1088 |
| lad:E1098 |
| lad:E1099 |
| lad:E1109 |
| lad:E1126 |
| lad:E1132 |
| lad:E1133 |
| lad:E1146 |
| lad:E1168 |
| lad:E1181 |
| lad:E1194 |
| lad:E1203 |
| lad:E1210 |
| lad:E1238 |
| lad:E1242 |
| lad:E1260 |
| lad:E1264 |
| lad:E1266 |
| lad:E1267 |
| lad:E1297 |
| lad:E1314 |
| lad:E1317 |
| lad:E1323 |
Query 6:
| t |
|---|
| lad:E01 |
| lad:E09 |
| lad:E1005 |
| lad:E1029 |
| lad:E1034 |
| lad:E1046 |
| lad:E1055 |
| lad:E1056 |
| lad:E1060 |
| lad:E1064 |
| lad:E1072 |
| lad:E1079 |
| lad:E1080 |
| lad:E1105 |
| lad:E1118 |
| lad:E1158 |
| lad:E1161 |
| lad:E1188 |
| lad:E1190 |
| lad:E1211 |
| lad:E1228 |
| lad:E1248 |
| lad:E1262 |
| lad:E1263 |
| lad:E1271 |
| lad:E1282 |
| lad:E1294 |
| lad:E1300 |
| lad:E1340 |
| lad:E1342 |
| lad:E1343 |
| lad:E1344 |
| lad:E1345 |
| lad:E1347 |
| lad:E1348 |
| lad:E1350 |
| lad:E1351 |
Query 7:
| t | c | r | ccy | d |
|---|---|---|---|---|
| lad:CV | CV | BBB+ | lad:basis-FC | 2024-01-01 |
| lad:CV | CV | A- | lad:basis-LC | 2024-01-01 |
| lad:E1019 | CV | BB+ | lad:basis-FC | 2022-12-11 |
| lad:E1019 | CV | BBB- | lad:basis-LC | 2024-03-20 |
| lad:E1039 | CV | A | lad:basis-FC | 2025-12-09 |
| lad:E1039 | CV | AA- | lad:basis-LC | 2025-11-22 |
| lad:E1059 | CV | BB- | lad:basis-LC | 2026-02-23 |
| lad:E1060 | CV | BB- | lad:basis-FC | 2025-02-16 |
| lad:E1071 | CV | B+ | lad:basis-FC | 2023-01-11 |
| lad:E1096 | CV | BBB | lad:basis-FC | 2024-04-04 |
| lad:E1096 | CV | BBB+ | lad:basis-LC | 2025-02-17 |
| lad:E1136 | CV | A- | lad:basis-FC | 2023-07-04 |
| lad:E1144 | CV | B+ | lad:basis-FC | 2026-06-06 |
| lad:E1144 | CV | BB- | lad:basis-LC | 2024-07-19 |
| lad:E1185 | CV | BB+ | lad:basis-FC | 2025-02-28 |
| lad:E1194 | CV | A | lad:basis-FC | 2025-01-20 |
| lad:E1194 | CV | A | lad:basis-LC | 2024-03-23 |
| lad:E1217 | CV | BB- | lad:basis-FC | 2025-09-07 |
| lad:E1223 | CV | BB+ | lad:basis-FC | 2023-08-20 |
| lad:E1229 | CV | BB+ | lad:basis-FC | 2026-06-02 |
| lad:E1229 | CV | BBB- | lad:basis-LC | 2025-09-16 |
| lad:E1243 | CV | BB | lad:basis-FC | 2026-08-19 |
| lad:E1243 | CV | BBB+ | lad:basis-LC | 2026-01-15 |
| lad:E1245 | CV | B+ | lad:basis-FC | 2025-09-11 |
| lad:E1245 | CV | B | lad:basis-LC | 2025-09-20 |
| lad:E1283 | CV | BB | lad:basis-FC | 2024-11-03 |
| lad:E1283 | CV | B+ | lad:basis-LC | 2024-06-19 |
| lad:E1304 | CV | BB | lad:basis-FC | 2026-07-25 |
| lad:E15 | CV | A+ | lad:basis-LC | 2024-03-01 |
| lad:E15 | CV | A | lad:basis-FC | 2024-03-01 |
| lad:E05 | VD | BBB- | lad:basis-LC | 2025-04-01 |
| lad:E05 | VD | BB | lad:basis-FC | 2025-04-01 |
| lad:E1028 | VD | BB | lad:basis-FC | 2025-12-25 |
| lad:E1028 | VD | BBB | lad:basis-LC | 2025-12-05 |
| lad:E1101 | VD | BB | lad:basis-FC | 2022-10-26 |
| lad:E1101 | VD | BB+ | lad:basis-LC | 2022-10-26 |
| lad:E1106 | VD | B+ | lad:basis-FC | 2024-10-26 |
| lad:E1106 | VD | WD | lad:basis-LC | 2025-08-10 |
| lad:E1126 | VD | BB | lad:basis-FC | 2025-07-10 |
| lad:E1126 | VD | BBB- | lad:basis-LC | 2024-04-11 |
| lad:E1236 | VD | BB | lad:basis-FC | 2023-09-17 |
| lad:E1279 | VD | WD | lad:basis-FC | 2024-11-17 |
| lad:E1279 | VD | BB | lad:basis-LC | 2023-12-16 |
| lad:E1307 | VD | BB- | lad:basis-FC | 2026-09-25 |
| lad:E1313 | VD | BB- | lad:basis-FC | 2025-09-02 |
| lad:E1313 | VD | BBB- | lad:basis-LC | 2024-01-24 |
Run more queries, or give the final answers.The model
**Q1.** A-. Kestrel Energy (E01) was rated A- from A01 (2024-03-12) until the downgrade to BBB in A02 (2025-06-20).
**Q2.** No. A03 (2026-02-10) only affirmed BBB; the downgrade was A02 in 2025.
**Q3.** No. The 2031 note (I02) is rated BB+ (A07, 2025-06-20), which is below investment grade.
**Q4.** Positive. E03 is the research duplicate of E02 (same LEI). Its latest action, A09 (2025-09-15), has a Positive outlook and is more recent than A08 (Stable).
**Q5.** A holder takes the credit risk of the guarantor Northwind Holdings (E02), rated A (A08/A09). The issuer is E04 and the guarantor is E02 on I03.
**Q6.** I can't confirm the cause from the data. FC is BB and LC is BBB- (A13/A14), and the Republic of Valdoria's country ceiling (A12) is BB. That is consistent with the ceiling capping the FC rating, but no comment states it.
**Q7.** 43 issuers have a downgrade action (DG) dated in 2026, listed in the JSON. I excluded E1341, whose DG is dated 2026-11-09, after today. I counted entities by action label and did not check each for an actual rating drop; E1051 shows A+ on both of its DG actions.
**Q8.** Saxby Shipping (E08) was in default, rated RD from A22 (2026-07-08).
**Q9.** 290. That is 288 distinct LEIs plus the two sovereigns (CV, VD), counting each issuer's latest long-term issuer rating (LTIDR) that is not WD as of 2026-10-01.
**Q10.** Depends. Valdoria Telecom (E05) is BBB- in local currency (investment grade) and BB in foreign currency (not).
**Q11.** BBB+. Marlow Utilities (E14) was downgraded by A36 on 2024-09-30 and nothing changed before 2025-06-01.
**Q12.** A-, from A34.
**Q13.** 1 time (A36).
**Q14.** None. Halden Foods' first rating is A30 on 2024-02-01.
**Q15.** A-. Halden Bank (E10) was cut to BBB+ only on 2026-04-15 (A27).
**Q16.** No. The rating was BBB+ on 2025-01-01 and is still BBB+; A35/A33 only added and then removed a watch.
**Q17.** No. Orrin Bank (E06) was placed on Rating Watch Negative (A17) with the rating unchanged at A-.
**Q18.** 32 issuers are on Rating Watch Negative, listed in the JSON. This includes watches on local-currency (LC) ratings only (E1019, E1059).
**Q19.** 37 issuers have a Negative outlook, listed in the JSON.
**Q20.** No. Pellam Retail (E07) was withdrawn (WD, A19), not defaulted.
**Q21.** 35 entities, listed in the JSON. Their latest LTIDR action is WD. I left out E1106 and E1279, which withdrew one currency basis but still hold a rating on the other.
**Q22.** Only Saxby Shipping (E08), via A22.
**Q23.** F2 (A04).
**Q24.** Yes. Kestrel's issuer rating is BBB (A03).
**Q25.** 69 instruments held an investment-grade rating on 2026-10-01, out of 112 rated. This counts I08's A (A47, action EX), whose meaning isn't defined in the data.
**Q26.** A+ (A40).
**Q27.** A- (A42).
**Q28.** BBB+ (A38).
**Q29.** None. Valdoria has only a country ceiling (A12), BB, and no issuer rating.
**Q30.** Eight entities have an FC rating exactly at their country ceiling. The ceilings are CV = A and VD = BB: E15, E1039 and E1194 at A, and E05, E1028, E1101, E1126 and E1236 at BB.
**Q31.** No. No CV entity is above A and no VD entity is above BB.
**Q32.** Halden Group plc (E09), via E11 → E10 → E09.
**Q33.** A holder takes the guarantor's risk, Halden Bank (E10), rated BBB+ (A27). The issuer is E11 and the guarantor is E10 on I05.
**Q34.** No. Halden Foods (E12) has no parent link; only E10 and E11 link to E09, so the shared name proves nothing.
**Q35.** 3 (E09, E10, E11). E17 is a duplicate of E10 (same LEI).
**Q36.** 2 (E02, E04). E03 is a duplicate of E02.
**Q37.** 344. There are 370 entity records, with 342 distinct LEIs plus the two sovereigns that have none.
**Q38.** No. They have different LEIs and countries (E06 is DE, E13 is US).
**Q39.** A. E02 and E03 both show A.
**Q40.** 74 distinct LEIs.
**Q41.** BB+ (A44, downgraded 2026-06-01).
**Q42.** DE (E10). The duplicate record E17 says LU, but it shares E10's LEI and comes from the RESEARCH source.
**Q43.** 0. The only LU record is E17, which is a duplicate of the DE entity E10. If you count records instead, the answer is 1.
**Q44.** Yes, probably. I07 is in XVD, which looks like Valdoria's currency, but the data has no explicit currency-to-country mapping.
**Q45.** No. Its rating is BBB-, above the BB ceiling, but the ceiling constrains foreign-currency obligations and this is a local-currency note.
**Q46.** No. E11 has only a credit opinion (CO, A46), no issuer rating.
**Q47.** A (A47, 2026-09-01). The action code EX isn't defined in the data, so this rating may be provisional or expected.
**Q48.** 112 instruments.
```json
{
"Q1":{"rating":"A-"},
"Q2":{"downgraded":"no"},
"Q3":{"investment_grade":"no","rating":"BB+"},
"Q4":{"outlook":"Positive"},
"Q5":{"risk_of":"E02","rating":"A"},
"Q7":{"issuers":["E08","E10","E1034","E1051","E1053","E1057","E1058","E1064","E1080","E1093","E1112","E1144","E1151","E1159","E1161","E1163","E1167","E1170","E1186","E1213","E1228","E1229","E1243","E1255","E1263","E1285","E1290","E1294","E1299","E1300","E1307","E1340","E1342","E1343","E1344","E1345","E1346","E1347","E1348","E1349","E1350","E1351","E16"]},
"Q8":{"entities":["E08"]},
"Q9":{"count":290},
"Q10":{"investment_grade":"depends"},
"Q11":{"rating":"BBB+"},
"Q12":{"rating":"A-"},
"Q13":{"count":1},
"Q14":{"rating":"none"},
"Q15":{"rating":"A-"},
"Q16":{"changed":"no"},
"Q17":{"downgraded":"no"},
"Q18":{"issuers":["E06","E1006","E1013","E1019","E1037","E1039","E1059","E1061","E1066","E1088","E1098","E1099","E1109","E1126","E1132","E1133","E1146","E1168","E1181","E1194","E1203","E1210","E1238","E1242","E1260","E1264","E1266","E1267","E1297","E1314","E1317","E1323"]},
"Q19":{"issuers":["E01","E09","E1005","E1029","E1034","E1046","E1055","E1056","E1060","E1064","E1072","E1079","E1080","E1105","E1118","E1158","E1161","E1188","E1190","E1211","E1228","E1248","E1262","E1263","E1271","E1282","E1294","E1300","E1340","E1342","E1343","E1344","E1345","E1347","E1348","E1350","E1351"]},
"Q20":{"in_default":"no"},
"Q21":{"entities":["E07","E1002","E1007","E1021","E1032","E1041","E1048","E1057","E1062","E1063","E1076","E1084","E1107","E1121","E1124","E1138","E1140","E1155","E1159","E1166","E1172","E1200","E1205","E1206","E1218","E1219","E1225","E1233","E1234","E1244","E1254","E1277","E1308","E1316","E1320"]},
"Q22":{"entities":["E08"]},
"Q23":{"rating":"F2"},
"Q24":{"investment_grade":"yes"},
"Q25":{"count":69},
"Q26":{"rating":"A+"},
"Q27":{"rating":"A-"},
"Q28":{"rating":"BBB+"},
"Q29":{"rating":"none"},
"Q30":{"entities":["E15","E1039","E1194","E05","E1028","E1101","E1126","E1236"]},
"Q31":{"any":"no"},
"Q32":{"parent":"E09"},
"Q33":{"risk_of":"E10","rating":"BBB+"},
"Q34":{"same_group":"no"},
"Q35":{"count":3},
"Q36":{"count":2},
"Q37":{"count":344},
"Q38":{"same":"no"},
"Q39":{"rating":"A"},
"Q40":{"count":74},
"Q41":{"rating":"BB+"},
"Q42":{"country":"DE"},
"Q43":{"count":0},
"Q44":{"local_currency":"yes"},
"Q45":{"above_ceiling":"no"},
"Q46":{"issuer_rating":"no"},
"Q47":{"rating":"A"},
"Q48":{"count":112}
}
```