The findings CSV columns
| Column | What it holds |
|---|---|
recording, recorded_at, meeting_id | Which recording, when it was recorded, and its id |
time | Where in the recording the moment is |
policy, severity | The rule it was read against, and that rule's severity |
found_by | Whether it came from reading the recording or from a keyword |
in, term | Whether it was said or on screen, and the keyword that matched |
speaker, speaker_role | Who said it |
quote, quote_from | The quote, and whether it was said, text on screen, a description of the screen, or a claim missing a disclosure |
repeated_claim | The pattern this moment belongs to, when it is one of several |
reason, mitigation | Why it was flagged, and what elsewhere balances it |
assessment, likelihood | The verdict and the estimate behind it |
asr_confidence | How confident the transcription is of those words |
excluded | Whether a known harmless use applies |
status, review_note, reviewed_at | Your decision, its note, and when it was made |
pack_version | The policy set in force when the review ran |
fingerprint | A stable id for the moment, so re-imports match rather than duplicate |
pack_version is the column to keep when you re-export later. It is what
lets you show that a decision was made against the policies in force at the
time, rather than today's.
recordings.csv carries the review-level record, one row per recording:
recorded_at, title, review, closed_by, closed_at, closing_note,
reviewed_at, policies_version, current_policies (whether the review
still reflects today's policies), the counts moments, need_attention,
worth_a_look, look_fine, escalated, cleared and not_decided, plus
video, folder and meeting_id. policies.csv carries each policy's key, name, rule,
severity, terms, harmless_uses, examples, missing_disclosure,
enabled and built_in.
Every decision carries who made it and when. Every quote carries its recording and timestamp, and says whether it came from what was said, what was on screen, our description of the screen, or a missing disclosure. That provenance is the point: an export should let a reader verify a conclusion rather than take it on trust.