Variable pages · IRS 990 Master Concordance
F9_07_COMP_DTK_ADDR_ZIP
Officer, director, trustee, or key employee zip
- Description
- Address US - ZIPCode (see F9-FORM-VERSION-2011-PART-04)
- Table
F9-P07-T01-COMPENSATION(many)- Part
- Part VII - Compensation of Officers, Directors, Trustees, Key Employees, Highest Compensated Employees, and Independent Contractors
- Location
F990-EZ-PART-04-COL-A- Type
- text
- Scope
- EZ – 990-EZ only
- Database
- F990
- Forms
- EZ
2 / 2
xpaths observed / mapped
162k
filings with a value
2009–2011
tax years observed
0 + 1 reviewed
open flags
Checks
Value checks
| Result | Value check | Detail |
|---|---|---|
| ✓ pass | Values have the ZIP format | 99.7% of values match ^(99999|999999999|99999-9999)$ |
| ✓ pass | Stored as text | data type is text |
| ▲ warn | No placeholder values | 10 filings use a placeholder such as 000000000 |
Flags
| Flag | Severity | Xpath | Detail | Review |
|---|---|---|---|---|
COLLISION | ⚠ error | IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressForeign/PostalCode | 799 filings contain 2+ of its xpaths; most common set: /Return/ReturnData/IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressForeign/PostalCode ; /Return/ReturnData/IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode | ✓ acceptednoteFalse positive: counted per filing. Recounted per repeating-element row in the TY2012 and TY2019 DuckDB builds: 0 rows hold both the US and the foreign address xpath (different rows of the table hold different address types). build_evidence() now counts collisions per row. |
Xpaths
| Xpath (under /Return/ReturnData or /Return/ReturnHeader) | Form | Years | Filings | % filers | Repeats in | |
|---|---|---|---|---|---|---|
| x1 | IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressUS/ZIPCode | EZ | 2009–2011 | 160,785 | 100% | 95.2% |
| x2 | IRS990EZ/OfficerDirectorTrusteeKeyEmpl/AddressForeign/PostalCode | EZ | 2009–2011 | 838 | 0.557% | 39.5% |
% filers: percent of in-scope filers whose return has the xpath, in its latest year. Repeats in: share of filings where the element occurs more than once.
Coverage by tax year
| Filings | ’09 | ’10 | ’11 | ’12 | ’13 | ’14 | ’15 | ’16 | ’17 | ’18 | ’19 | ’20 | ’21 | ’22 | ’23 | ’24 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| x1 | 15k | 63k | 82k | |||||||||||||
| x2 | 47 | 334 | 457 | |||||||||||||
| Fill rate: % of all filings of the return type (largest xpath) | ||||||||||||||||
| 990-EZ | 100 | 100 | 100 | |||||||||||||
Filings with a value, by xpath (rows, numbered as in the xpath table) and tax year. A change of row from one year to the next is usually the IRS renaming the element (most were renamed in 2013). Hover a cell for the exact count.
Values
| Format | Filings | Share |
|---|---|---|
99999 | 155,704 | 92.9% |
999999999 | 11,380 | 6.8% |
A9A 9A9 | 222 | 0.1% |
9999 | 93 | 0.1% |
A9A9A9 | 75 | 0.0% |
999999 | 30 | 0.0% |
Format of the values: 9 a digit, A a letter.