Variable pages · IRS 990 Master Concordance

SN_02_DOA_RECIP_ADDR_CITY

Recipient city

Description: Foreign Address - City
Table: SN-P02-T01-DISPOSITION-OF-ASSETS (many)
Part: Part II - Sale, Exchange, Disposition, or Other Transfer of More Than 25% of the Organization's Assets
Location: SCHED-N-PART-02-LINE-01-COL-F
Type: text
Scope: PZ – 990 and 990-EZ
Database: F990
Forms: SZ

6 / 8

xpaths observed / mapped

15k

filings with a value

2009–2024

tax years observed

0 + 5 reviewed

open flags

Checks

Value checks

Result	Value check	Detail
✓ pass	Values are text, not numbers	0% of values are numeric
✓ pass	No sign of truncation	longest values do not sit at a common field limit

Flags

Flag	Severity	Xpath	Detail	Review
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleN/DispositionOfAssetsDetail/USAddress/CityNm`	many-to-one table, but 72% of values sit in no repeating element	✓ accepted note Genuine 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 27.2% of 11,669 filings, max 167/filing, TY2014-2024; repeat_root: ''=72% ; IRS990ScheduleN/DispositionOfAssetsDetail=28%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleN/DispositionTable/AddressUS/City`	many-to-one table, but 73% of values sit in no repeating element	✓ accepted note Genuine 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 26.4% of 2,276 filings, max 74/filing, TY2009-2012; repeat_root: ''=73% ; IRS990ScheduleN/DispositionTable=27%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleN/DispositionOfAssetsDetail/USAddress/City`	many-to-one table, but 70% of values sit in no repeating element	✓ accepted note Genuine 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 29.4% of 868 filings, max 50/filing, TY2013-2013; repeat_root: ''=70% ; IRS990ScheduleN/DispositionOfAssetsDetail=30%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleN/DispositionOfAssetsDetail/ForeignAddress/CityNm`	many-to-one table, but 58% of values sit in no repeating element	✓ accepted note Genuine 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 33.3% of 165 filings, max 35/filing, TY2014-2024; repeat_root: ''=58% ; IRS990ScheduleN/DispositionOfAssetsDetail=42%.
`MANY_NOT_REPEATING`	ⓘ info	`IRS990ScheduleN/DispositionTable/AddressForeign/City`	many-to-one table, but 52% of values sit in no repeating element	✓ accepted note Genuine 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 33.3% of 33 filings, max 12/filing, TY2009-2012; repeat_root: ''=52% ; IRS990ScheduleN/DispositionTable=48%.

Xpaths

	Xpath (under /Return/ReturnData or /Return/ReturnHeader)	Form	Years	Filings	% filers	Repeats in
x1	`IRS990ScheduleN/DispositionTable/AddressUS/City`	SZ	2009–2012	2,276	0.273%	26.4%
x2	`IRS990ScheduleN/DispositionTable/AddressForeign/City`	SZ	2009–2012	33	0.00256%	33.3%
x3	`IRS990ScheduleN/DispositionOfAssetsDetail/USAddress/City`	SZ	2013–2013	868	0.286%	29.4%
x4	`IRS990ScheduleN/DispositionOfAssetsDetail/ForeignAddress/City`	SZ	2013–2013	13	0.00429%	38.5%
x5	`IRS990ScheduleN/DispositionOfAssetsDetail/USAddress/CityNm`	SZ	2014–2024	11,669	0.186%	27.2%
x6	`IRS990ScheduleN/DispositionOfAssetsDetail/ForeignAddress/CityNm`	SZ	2014–2024	165	0.0046%	33.3%
x7	`IRS990ScheduleN/Form990ScheduleNPartII/DispositionTable/AddressForeign/City`	SZ	not observed	0
x8	`IRS990ScheduleN/Form990ScheduleNPartII/DispositionTable/AddressUS/City`	SZ	not observed	0

% 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	211	606	713	746
x2	4	12	10	7
x3					868
x4					13
x5						964	969	1.1k	1.1k	1.1k	978	1.1k	1.1k	1.2k	1.2k	850
x6						11	12	9	16	10	10	19	15	25	17	21
Fill rate: % of all filings of the return type (largest xpath)
990	1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1
990-EZ	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1	<1

Filings

’09

’10

’11

’12

’13

’14

’15

’16

’17

’18

’19

’20

’21

’22

’23

’24

211

606

713

746

868

964

969

1.1k

978

1.1k

1.2k

850

Fill rate: % of all filings of the return type (largest xpath)

990

990-EZ

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

Return	Filings	Average length	Longest
990	11,788	9	44
990-EZ	3,236	9	23

Most common values

Value	Filings	Share
`NEW YORK`	288	15.0%

Example filings

Tax year	Return	Xpath	Organization	Value
2024	990	x6	DECENTRALIZED PICTURES FOUNDATION INC	ZUG	XML
2024	990	x5	MISSION HOPE	ALPHARETTA	XML
2013	990	x4	WORLD TRADE CENTER SAN DIEGO	NOT APPLICABLE	XML
2013	990	x3	ELDERTRUST OF FLORIDA INC	MURFREESBORO	XML
2012	990	x2	THE EXUMA FOUNDATION	GEORGETOWN	XML
2012	990	x1	UNITE HERE IU LOCAL NO 54	ATLANTIC CITY	XML