What it is
A screen over a state’s own published filings for the systems a consolidation or capacity program exists to find: the small ones, the ones that have stopped filing or file erratically, the ones whose reported figures rest largely on the default values the form supplies rather than on a measurement, and the ones that sit in the same county as a materially larger system that shows none of those signals.
Each of those is already in the record. None of them is published as a list you can work down.
What you hand us
Nothing. Every input is a file your agency has already published, and the screen names the file and the retrieval date for every row.
What you get back
One row per system: its size as most recently filed, how many years of the annual requirement it has filed and when it last filed one, how much of its most recent reported figure was measured rather than defaulted, how far its filed figures move year to year, and whether a larger system in the same county is filing without those signals.
Every figure names the document it came from, and every system that could not be screened is listed as refused with the reason — the identifier was malformed, two systems shared one identifier, or the filing was absent.
What it is built from
Your published filings, archived as published, and nothing that is not public.
What it does not do
It does not say a consolidation should happen. It says which systems match the pattern a program is looking for. Whether combining two systems is feasible, lawful or wanted is a study, and the boards involved have to want it.
It does not draw a service area. Where no published boundary exists, adjacency is stated at county level, which is coarse and is labeled as coarse. It is not a claim that two systems are neighbors.
It does not value a system and it does not price a transaction.
It does not mark a system as failing. This corpus holds a published threshold for one of its states and none for the rest, so a system here is small, or lapsed, or reporting defaults — never “over” anything.
It does not rank. A ranked list invites somebody to work down it, and the order would be ours rather than the program’s.