Downloads do not require an account. To continue to the AERO app, please sign in.

Downloads

Files from the current publish, as CSV. Each one is built when you download it, so it matches what the site shows now. The filename carries the publish date, which is how you tell two downloads apart a month later.

Entity relationships

One row per relationship between two registrations: whose audit covers whom, and which registrations are the same organization.

14,411 rows — 11,301 audit coverage · 3,110 succession

Download CSV

Columns

parent_uei: The registration whose audit covers, or the one in use now
parent_uei_name: Its name, where it has one registered
child_uei: The registration covered, or the one it replaced
child_uei_name: Its name, where it has one registered
link_type: audit_coverage or succession
source: Where the relationship came from: the Clearinghouse, SAM, or a decision made here
link_confidence: declared by the filer, inferred by rule, or curated by a reviewer

About the data

What a row is

One row for each pair of registrations and the kind of relationship between them, so parent_uei, child_uei and link_type together never repeat. The file holds 12,973 child registrations under 4,490 parents. The same registration can be a parent in one row and a child in another, and a child can have both a coverage row and a succession row.

The identifiers

Both are SAM Unique Entity IDs, so they join to federal award data and to Federal Audit Clearinghouse filings. A few are not real UEIs: some auditees typed a grant or contract number into that field when they filed, and we keep what was filed.

Which way a row points

The parent comes first in both kinds of row. In an audit_coverage row, the parent's audit covers the child's federal spending. In a succession row, the parent is the registration in use now and the child is the one it replaced. Parent does not mean owner: ownership is not in this file.

Updates

The relationships are rebuilt every night, and the file is built when you download it from whatever has been published at that point. Two downloads on the same day match each other. Downloads either side of a nightly run may not, which is why the filename carries the publish date.

Where each row came from

Read source and link_confidence together. declared means the filer said so on its own audit. inferred means we matched it by rule from filings or registrations. curated means a reviewer decided it. Every combination in today's file is below.

link_type	source	link_confidence	rows	What it means
audit_coverage	fac	declared	9,923	The filer listed this registration on its own audit as one the report covers. Nothing is inferred: it is the organization telling the Clearinghouse what its audit includes.
audit_coverage	app	curated	1,189	A reviewer accepted a proposal. Proposals come from tests that all ask the same thing — does the covering audit report the programs this registration receives money under? Either its corporate parent filed for the same year, or a state or local government audit accounts for at least 99% of its federal spending.
audit_coverage	sefa_pdf	curated	188	A reviewer read the covering audit itself — its schedule of federal awards, its notes or its findings — and recorded what the document says.
audit_coverage	fac	curated	1	A reviewer decided this one from a Clearinghouse filing rather than from one of the tests.
succession	app	curated	1,651	A reviewer decided the two registrations are the same organization. This is how a pair no rule can find gets recorded, including a registration that never filed an audit.
succession	fac	inferred	1,422	Both registrations file under the same taxpayer number and the same name, and the filing history hands off from one to the other. If the two filed their own audits in the same year twice or more, the pair is excluded: one organization cannot have two single audits for one year.
succession	sam	inferred	37	Matched from SAM registration records rather than from filings: one registration replaced another for the same organization.

Worth knowing before you use it

Rejected relationships are already out. If a reviewer ruled against one, or the Clearinghouse no longer supports it, it is not in the file. There is no status column to filter on.
A curated row is our decision, not a federal record. Use link_confidence to separate what filers declared from what we established.
There are no years. We see a relationship through filings, so a first and last year would tell you when we saw it, not when it applied. Do not read a relationship as limited to the years it was filed in.
Join on UEI, not on name. Names are as registered, and 1,046 rows are missing one: some registrations appear in federal award data and never registered in SAM, so nothing names them.
Coverage does not chain. If A covers B and B covers C, there is no row for A and C. Follow the chain yourself if you need it.

Decision support only. These files describe the evidence behind the delinquency queue; nothing in them is an official HHS determination.