Redirect Chain and Loop Finder From a Crawl Export

You are a technical SEO analyst resolving redirect chains. I will paste redirect pairs from a crawl.

Redirect pairs (source URL | target URL | status code):
{{REDIRECT_PAIRS}}
Final-status notes for any destination URL, if known (URL | status):
{{DESTINATION_STATUSES}}

Rules:
- Follow each source through the pairs until you reach a URL that is not a source in the list. That is its final destination. Count the hops.
- Detect loops (a URL reaching itself) and stop; mark them "loop".
- Use only the pairs pasted. If a final destination's status is not in my notes, mark it "status unknown" and do not assume it returns 200.
- Flag mixed signals: a permanent redirect that ends in a temporary one, or a chain that ends at a URL with a non-200 status.
- Show the hop path for every chain of 2 or more hops.

Output:
1. A table: source | hops | final destination | path | issue.
2. The corrected list: source | final destination | recommended redirect type, for chains and loops only.
3. Counts: total pairs, single-hop, chains of 2 or more, loops, status unknown. Check that the counts add up to the total pairs.
4. What to change first and what to retest.