is_* role flags are check-all-that-apply, read independently per box — a person can carry several. 0-vs-NULL is semantic: Form 990 rows use 1/0 (0 = box unchecked); 990-EZ/PF rows carry NULL (no Section-A structure on those forms). Comp columns: reportable_comp_filing_org (all forms) + reportable_comp_related_org/other_compensation (Form 990 only) or benefits/expense_account (990-EZ/PF only). compensation is deprecated (legacy, unwritten by parsers — NULL on re-derived rows); use reportable_comp_filing_org. Within-filing byte-duplicate person entries are collapsed under a keyed dedup; genuine variants stay distinct rows.
This data as json
| id | object_id | ein | person_name | title | avg_hours_per_week | compensation | benefits | expense_account | reportable_comp_filing_org | reportable_comp_related_org | other_compensation | is_highest_compensated_employee | is_officer | is_individual_trustee | is_institutional_trustee | is_key_employee | is_former |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 348 | 202300379349100040 | 232571610 | RIDGE FRANK-WHITE | CHAIR | 2.0 | 0 | 0 | 0 | 0 |