# Contractor Credit trial: data dictionary

Publisher: Tensorust LLC (tensorust.com). Build of Nov 6 2026, about 4 AM ET (federal data through Nov 5 2026). All sources are public records.

## cc_snapshot_2026-11-05.csv (one row per federal contractor, 202 rows)

The universe: every BDC first-lien borrower (3,214 in the cross-lender marks book) whose holdco name resolves, at confidence A or B, to an operating company with positive federal obligations FY2025 to date. One row per distinct operating-company UEI.

| Column | Type | Meaning | Source | Point-in-time? |
|---|---|---|---|---|
| snapshot_date | date | Date the row was built | Tensorust | yes (build date) |
| uei | string | SAM Unique Entity ID of the operating company | USAspending / SAM | current |
| operating_company | string | Recipient legal name | USAspending | current |
| bdc_borrower_name | string | Name as the BDC files it in its schedule of investments | SEC BDC data sets / EDGAR 10-Q | as filed |
| match_tier | string | How the name resolved: T1 exact, T2 holdco words stripped, T4 via Form 5500 EIN | Tensorust resolver | current |
| match_confidence | A/B | A = exact or corroborated; B = corroborated non-exact. Grade C is never included | Tensorust resolver | current |
| state | string | Recipient state | USAspending | current |
| sam_parent_uei | string | SAM-reported parent UEI (not trusted alone; see README) | USAspending | current |
| pe_owner_reported | string | Parent name as SAM reports it | USAspending | current |
| market_priced | bool | True if the name has listed equity or a rated broadly syndicated loan (hand-curated list of 52) | Tensorust | current |
| priced_reason | string | Why it counts as priced | Tensorust | current |
| ein | string | Employer ID from the matched Form 5500 sponsor | DOL Form 5500 | plan year |
| naics | string | Primary NAICS description on awards | USAspending | current |
| top_agency | string | Agency with the most obligations | USAspending | current |
| fed_obligations_fy2025_to_date_usd | number | Net obligations, all agencies, Oct 1 2024 to Nov 5 2026, whole parent-UEI family that carries the borrower's name | USAspending | NO: snapshot, revised by agencies |
| fed_dod_obligations_fy2024_2026_usd | number | Net DoD obligations FY2024-FY2026 (overlaps the column above; never add them) | USAspending | NO |
| fed_obligations_fy2026_usd | number | FY2026 net obligations | USAspending | NO |
| last_federal_action_date | date | Latest award action date | USAspending | as reported |
| subawards_n / subawards_usd | number | FSRS subawards received as sub-recipient, Oct 1 2024 to Nov 5 2026 | USAspending subawards (FSRS) | NO |
| subaward_primes | string | Primes that reported the subawards | FSRS | NO |
| f5500_sponsor | string | Matched Form 5500 plan sponsor | DOL EFAST2 | plan year |
| f5500_participants_2024 / _2025 | number | Plan participants, plan years 2024 and 2025 | DOL EFAST2 | NO: filing dates not kept |
| f5500_change | number | (2025 - 2024) / 2024, only when 2024 >= 50 | Tensorust | NO |
| bdc_first_lien_par_usd | number | First-lien term loan par across all BDCs, Jun 30 2026 book | SEC BDC data sets | as of Jun 30 2026 |
| first_lien_lowest_current_mark | number | Lowest manager mark (fair value / par) using each lender's latest filed quarter (Sep 30 2026 if filed, else Jun 30 2026) | SEC / EDGAR | mixed quarters: see all_debt_mark_quarter and history files |
| first_lien_lowest_mark_jun30 | number | Lowest manager mark at Jun 30 2026 | SEC | yes (filed Jul-Aug 2026) |
| first_lien_highest_current_mark | number | Highest manager mark | SEC / EDGAR | as above |
| lender_gap | number | Highest minus lowest manager mark | Tensorust | as above |
| managers / funds | number | Distinct manager families / funds holding the loan | SEC | as above |
| first_lien_lowest_mark_mar31 | number | Lowest manager mark Mar 31 2026 | SEC | yes |
| first_lien_lowest_mark_sep30 | number | Lowest Sep 30 2026 mark among filers so far | EDGAR 10-Q | yes, partial quarter |
| q3_filers | number | BDCs holding this loan that have filed Q3 so far | EDGAR | as of build |
| worst_cut_q1_to_q2 / worst_cut_q2_to_q3 | number | Largest single-manager change between quarters (negative = cut) | Tensorust | yes |
| all_debt_mark_latest | number | Par-weighted mark across every term-debt line (1st and 2nd lien, unitranche), latest quarter | SEC / EDGAR | see history files |
| all_debt_mark_quarter | date | Quarter end of that mark | | |
| all_debt_mark_filers | number | BDC filers in that quarter's mark | | |
| signals | string | Pipe list: marked_below_90, marked_below_80, lenders_10pt_apart, cut_5pt_q2, cut_5pt_q3, all_debt_lines_below_90/80, headcount_down_20pct | Tensorust | derived |
| stressed | bool | Any signal other than headcount_down_20pct | Tensorust | derived |
| lobbying_firms_lda_2025_2026 | number | Lobbying registrants reporting this company as a client, 2025-2026 LD-2 reports | Senate/House LDA (lda.gov) | NO |
| connected_pacs_fec | number | FEC separate segregated funds connected to the company | FEC committee master | NO |
| ofac_sanctions_matches | number | OFAC SDN + Consolidated list entity matches on the company or its family (0 for all 202 in this build) | OFAC | NO |
| fcc_licenses | number | FCC licenses held | FCC ULS | NO |
| turbine_aircraft | number | Turbine aircraft registered | FAA registry | NO |
| federal_rule_flags | string | Federal rules the company is flagged under (rule:status) | Tensorust ontology | NO |

## cc_history_pit.csv (one row per contractor per quarter, 197 contractors, Sep 30 2022 to Sep 30 2026)

| Column | Meaning |
|---|---|
| uei, operating_company, borrower_key | Join keys to the snapshot |
| quarter_end | Schedule of investments date |
| first_available_at | Filing date of the FIRST BDC that reported a mark for this name for this quarter |
| available_at | Filing date of the LAST BDC included in the mark. Use this as the no-look-ahead stamp for the aggregate mark. A few quarters have a late straggler (for example one Sep 30 2025 schedule filed Jul 2 2026); use the filer-level file to avoid waiting for it |
| all_debt_mark_par_weighted | Sum of fair value / sum of principal over every term-debt line over $250K par (no revolvers, delayed draws or equity) |
| all_debt_mark_lowest_line | Lowest single line mark |
| par_usd | Principal across those lines |
| bdc_filers | BDCs in the mark |

The Sep 30 2026 quarter is partial until about Nov 21 2026.

## cc_history_filer_level.csv (one row per contractor x quarter x BDC filer)

| Column | Meaning |
|---|---|
| uei, operating_company, borrower_key, quarter_end | as above |
| bdc_cik | SEC CIK of the filing BDC |
| available_at | That BDC's filing date for the quarter (the moment this mark became public) |
| par_usd, fv_usd, mark | That filer's term-debt lines for the name |

Re-aggregating this file by (borrower_key, quarter_end) reproduces cc_history_pit.csv exactly.

## backtest_results.json
Machine-readable results of BACKTEST.md.