field,type,definition,example,blank_rule
row_id,string,Stable row key: 'XW' + first 12 hex of SHA-256 of security_id|segment_start|segment_end_exclusive|evidence_tier. Unique.,XW3f9a...,Never blank
security_id,string,"Persistfolio's own security identifier, identical to `security_id` in Historical Cohort Release 1.1 and the US$49 Membership & Turnover file. Not a ticker, CIK, FIGI or CUSIP.",PFHC-0034395AD0,Never blank
company_name,string,"Legal issuer name evidenced for the membership period containing the segment, as carried in the frozen research build.",Hewlett-Packard Co.,Never blank
segment_start,date,"First day of the segment (inclusive). Segments are half-open: [segment_start, segment_end_exclusive).",2004-09-30,Never blank
segment_end_exclusive,date,"First day after the segment. Segments of one security never overlap, and together they cover exactly that security's Cohort 1.1 membership days.",2005-10-01,Never blank
days,integer,Calendar days in the segment (end minus start).,366,Never blank
evidence_tier,categorical,"Strength of the identity evidence for the segment. A, B, B2_FTD, INFERRED, C_UNRESOLVED. Tiers are never merged; see METHODOLOGY.md.",B,Never blank
evidence_basis,categorical,"Filing family the evidence rests on (SEC_FORM4_ISSUER_FILINGS, SEC_PERIODIC_REPORT, SEC_13DG_PLUS_FTD_BOUNDED, SEC_DOCUMENTED_SINGLE_DAY_POINT, BRACKETED_BY_TWO_SEC_ANCHORS_GAP_NOT_WITNESSED, SEC_EVENT_AND_OWNERSHIP_FILINGS, SEC_ORIGINAL_FILINGS_BOUNDED_WINDOW, NONE). Derived by a fixed keyword rule from the build's scope label; full labels are in the provenance file.",SEC_FORM4_ISSUER_FILINGS,Never blank
ticker,string,Ticker symbol the issuer's own SEC filings used during the segment. Not proof that the symbol traded on an exchange on those days.,HPQ,Blank for C_UNRESOLVED rows
issuer_cik,string,"10-digit SEC CIK of the legal issuer evidenced for the segment (zero-padded, keep as text).",0000047217,Blank for C_UNRESOLVED rows
class_evidence,categorical,"What the evidence says about share class, without verifying it: FILER_PRINTED_TITLE (a security title printed in a filing is in security_class_as_filed), UNCLASSIFIED_COMMON (issuer common stock, class not established), CLASS_LETTER_STATED_A/B/C/P, SOLE_LISTED_CLASS_STATED, OTHER_EVIDENCE_CODE, NONE. No value means the share class is verified for trading.",UNCLASSIFIED_COMMON,NONE for C_UNRESOLVED rows
security_class_as_filed,string,"Security title exactly as printed in the cited filing, only when one was captured.","Common Stock, $0.01 par value",Blank when not captured
provenance: baseline_row,integer,Line number of this segment in Persistfolio's frozen internal research file (v2.21). Internal reference.,412,Never blank
provenance: evidence_scope_code,string,"Persistfolio's internal evidence-scope label for the segment, unchanged.",B_2017_ORIGINAL_SEC_FORM4_ISSUER_COMMON_EQUITY_NOT_TRADING,Never blank
provenance: evidence_statement,string,"What the evidence for this tier and filing family is, in plain words.",,Never blank
provenance: limitations,string,What the evidence does not show. Read this before relying on a row.,,Never blank
provenance: evidence_urls,string,"SEC documents behind the row, separated by ' ; '. Tier assignment rests on these. Blank for unresolved rows.",,Blank for C_UNRESOLVED
provenance: supplementary_references,string,"Non-SEC web pages that appear in Persistfolio's research record for the row (for example an exchange notice or press release). Context only: not tier evidence, and their content is not redistributed.",,Usually blank
provenance: bracketing_anchor_segments,string,INFERRED rows only: the date ranges of the SEC-evidenced segments immediately before and after the gap. They are rows of this file for the same security. The after-segment can extend beyond 2025-09-30.,before: 2017-09-18..2017-12-19; after: 2018-01-10..2018-12-19,Blank unless INFERRED
provenance: unresolved_reason,string,C_UNRESOLVED rows only: why no evidence was accepted.,,Blank unless C_UNRESOLVED
provenance: internal_claim_sha256,string,"SHA-256 of the original internal claim text for this segment, which Persistfolio preserves unchanged in its research record. Lets Persistfolio show that no internal claim was dropped.",,Never blank
exchange_listing_certified,categorical,"Always NO in this release: no exchange listing, venue, or trading-continuity certification is claimed for any row.",NO,Never blank