Variable pages · IRS 990 Master Concordance

SH_05_HOSPITAL_ADDR_ZIP

Hospital facility zip

Description
Address - ZIPCode
Table
SH-P05-T01-HOSPITAL-FACILITY (many)
Part
Part V - Facility Information
Location
SCHED-H-PART-05-SECTION-A-COL-01
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
4 / 6
xpaths observed / mapped
36k
filings with a value
2009–2024
tax years observed
0 + 4 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues have the ZIP format100.0% of values match ^(99999|999999999|99999-9999)$
✓ passStored as textdata type is text
✓ passNo placeholder valuesno all-zero / all-nine placeholders among the most common values

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleH/HospitalFacilitiesGrp/USAddress/ZIPCdmany-to-one table, but 83% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 17.1% of 24,360 filings, max 43/filing, TY2014-2024; repeat_root: ''=83% ; IRS990ScheduleH/HospitalFacilitiesGrp=17%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleH/Form990ScheduleHPartVSectionA/Address/ZIPCodemany-to-one table, but 81% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 18.7% of 7,398 filings, max 68/filing, TY2010-2012; repeat_root: ''=81% ; IRS990ScheduleH/Form990ScheduleHPartVSectionA=19%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleH/HospitalFacilitiesGrp/USAddress/ZIPCodemany-to-one table, but 83% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 17.1% of 2,426 filings, max 38/filing, TY2013-2013; repeat_root: ''=83% ; IRS990ScheduleH/HospitalFacilitiesGrp=17%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleH/Form990ScheduleHPartV/Address/ZIPCodemany-to-one table, but 55% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 44.8% of 1,521 filings, max 104/filing, TY2009-2009; repeat_root: ''=55% ; IRS990ScheduleH/Form990ScheduleHPartV=45%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleH/Form990ScheduleHPartV/Address/ZIPCodeSZ2009–20091,5214.57%44.8%
x2IRS990ScheduleH/Form990ScheduleHPartVSectionA/Address/ZIPCodeSZ2010–20127,3981.37%18.7%
x3IRS990ScheduleH/HospitalFacilitiesGrp/USAddress/ZIPCodeSZ2013–20132,4261.22%17.1%
x4IRS990ScheduleH/HospitalFacilitiesGrp/USAddress/ZIPCdSZ2014–202424,3600.353%17.1%
x5IRS990ScheduleH/Form990ScheduleHPartV/Address/AddressForeign/PostalCodeSZnot observed0
x6IRS990ScheduleH/Form990ScheduleHPartV/Address/AddressUS/ZIPCodeSZnot observed0

% 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
x11.5k
x22.5k2.5k2.5k
x32.4k
x42.3k2.4k2.3k2.4k2.3k2.3k2.3k2.3k2.3k2.3k980
Fill rate: % of all filings of the return type (largest xpath)
990522111111111111<1

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

FormatFilingsShare
9999933,70393.4%
9999999992,3966.6%

Format of the values: 9 a digit, A a letter.

Example filings

Tax yearReturnXpathOrganizationValue
2024990x4THE CLEVELAND CLINIC FOUNDATION44195XML
2013990x3OHIO VALLEY MEDICAL CENTER INCORPORATED26003XML
2012990x2SOUTH LYON HEALTH CENTER DBA89447XML
2009990x1QUEEN OF THE VALLEY MEDICAL CENTER94558XML