Coverage table · Court records and case files

Document coverage by program, court and year

Name: Document coverage by program, court and year
Creator: Pandemic Darlings
Published: 2026-10-16

Our list of known documents has 17,893 entries: court filings, case entries and oversight documents. Of those, 11,738 have a copy whose SHA-256 checksum matches the one on record, 65.7 percent of the 17,878 that exist. Another 1,913 are located on PACER and not yet bought, and 3,549 have no known location yet.

Rows162

Columns12

Files1 · 12 KB

FormatCSV

Source vintageDocument list and copy checksums as of 2026-10-16

Published byPandemic Darlings

Acquired / built2026-10-16

Built fromOur list of known court filings, case entries and oversight documents, with copy checksums, as of 2026-10-16; program and court from our case list

SHA-256478095542506b8e19d433cdd8b9fbf4cd5bd8347e32ad0f922fca325c69917bb

RightsCounts compiled by Pandemic Darlings from public court records and government documents; attribution requested.

Schema · dictionarydocument-coverage-by-program-court-and-year.json · dictionary.csv

Download CSV 12 KB Data dictionary CSV At a glance Preview Columns How to use Before you quote a row

At a glance

Measured on the file on 2026-10-16; the checksum above is the file these numbers describe.

Rows162

Columns12

Keydimension + value · unique

Cells left blank0 of 1,944 · 0.0%

Dimensions4 · program, court, year, record type

Entries per dimension17,893

Verified copies11,738 · 65.7% of 17,878 that exist

On PACER, not bought1,913

No location yet3,549

Program not recorded12,179

What it is

One row for each value of four dimensions: relief program (30 rows), court (96), year (14) and record type (22). Each dimension splits the same 17,893 entries.

An entry is a document the list says exists: a docket entry in a federal case, a congressional or oversight record, or a case-level entry for a prosecution where the individual filings have not been itemized. The columns count entries by where each one stands, from a verified copy to a document shown not to exist.

Criminal filings in federal district courts are the largest group, and 7,654 of the 7,949 have verified copies. Civil filings stand at 1,550 of 3,145, most of the rest being docket entries located on PACER and not bought. Of 2,515 entries tied to the Paycheck Protection Program alone, 910 are verified.

How it was built

An entry counts as verified when a stored file is linked to it and the file's SHA-256 checksum matches the checksum on its record. For 9,508 of the 11,738 verified entries, all of them federal docket entries, that checksum was recorded on 2026-10-16 from the stored file. A file linked without a checksum on record counts as a copy not yet verified.

Program and court come from our case list where the entry can be tied to a listed case, by the case's record identifier or by court and case number together. Federal docket entries carry their court in their identifier. Year is the year of the document's date; an entry with no date that is tied to a listed case takes the year the case was charged.

Preview

dimension	value	entries	copies_verified	copies_unverified	located_paywalled	located_free_not_downloaded	being_located	unavailable	sealed_or_confidential	does_not_exist	verified_pct_of_existing
program	Not recorded	12179	9795	2	1846	7	406	117	4	2	80.4
program	PPP	2515	910	160	67	38	1319	14	2	5	36.3
program	PPP+EIDL	1383	603	70	0	26	660	19	1	4	43.7
program	UI/PUA	502	84	10	0	6	401	1	0	0	16.7
program	COVID-19 relief	466	50	158	0	1	257	0	0	0	10.7
program	EIDL	406	173	7	0	3	222	0	0	1	42.7
program	PPP+UI/PUA	111	18	13	0	2	78	0	0	0	16.2
program	PPP+EIDL+UI/PUA	102	14	4	0	1	83	0	0	0	13.7
program	Other	55	18	3	0	0	33	0	0	1	33.3
program	ERC	36	14	4	0	1	16	0	0	1	40.0
program	PPP+RRF	28	11	0	0	1	16	0	0	0	39.3
program	EIDL+UI/PUA	24	0	0	0	2	22	0	0	0	0.0

First 12 of 162 rows · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.

Files

File	Rows	Size	SHA-256
`document-coverage-by-program-court-and-year.csv` CSV, UTF-8, header row	162	12,152 B	478095542506b8e19d433cdd8b9fbf4cd5bd8347e32ad0f922fca325c69917bb	Download ↓
`dictionary.csv` data dictionary, 12 rows	12	—	built with this page	Download ↓

Columns

Column	Type, measured	Distinct	Range / values	Meaning
`dimension`	text	4	court (96), program (30), record_type (22)	Which split the row belongs to: program, court, year or record_type.
`value`	text	160	Not recorded (3), PPP (1), PPP+EIDL (1)	The program, court, year or record type. "Not recorded" means the entry could not be tied to a value.
`entries`	integer	121	1 – 12.2K · median 87	Listed entries with this value.
`copies_verified`	integer	100	0 – 9.8K · median 40	Entries with a stored copy whose SHA-256 checksum matches the checksum on record.
`copies_unverified`	integer	32	0 – 412 · median 0	Entries with a stored copy and no checksum on record to check it against.
`located_paywalled`	integer	34	0 – 1.8K · median 0	Entries found on PACER and not yet bought.
`located_free_not_downloaded`	integer	14	0 – 75 · median 0	Entries found at a free location and not yet downloaded.
`being_located`	integer	76	0 – 3K · median 18	Entries with no known location yet.
`unavailable`	integer	20	0 – 137 · median 0	Entries marked unavailable at their source, such as access denied.
`sealed_or_confidential`	integer	5	0 – 4 · median 0	Entries the court or agency has sealed or restricted.
`does_not_exist`	integer	9	0 – 12 · median 0	Entries the source record shows do not exist.
`verified_pct_of_existing`	number	119	0.00 – 100.00 · median 58.55	copies_verified as a percentage of entries minus does_not_exist, one decimal.

Type, blanks, distinct count, and range are measured on the file. The same table as CSV: dictionary.csv.

How to use it

Specific to this file, measured on it: keys, joins, encodings, units, and the values that will trip a naive count.

Filter on dimension before summing. Each dimension repeats all 17,893 entries; adding rows across dimensions counts every entry four times.
The key is dimension plus value. Court values are full court names; 101 entries name a state court and 2,340 have no court recorded. Programs that appear together on one case are joined with a plus sign, such as PPP+EIDL.
The 8 status columns add up to entries on every row. The file is UTF-8 with LF line endings, 12,152 bytes.

Before you quote a row

Program is missing for most entries. 12,179 of 17,893 entries could not be tied to a listed case that names a program, mostly federal docket entries in cases our case list does not number. Read the program rows as a floor.
Year is missing where the document has no date. Docket entries known only from our copies of the filings carry no filing date; unless they are tied to a case with a charge date, they fall under "Not recorded" in the year split.
A case-level entry stands for a whole case. Record types that begin "Case or source entry" count prosecutions and sources listed before their filings were itemized; their filings, where itemized, are counted again under the federal court record types.
Coverage is of the list, not of every court record. A docket entry that the list does not name is not counted anywhere in this table.

Cite this table. Name the source vintage; the numbers depend on it.

Document coverage by program, court and year (document list as of 2026-10-16). Pandemic Darlings, https://pandemicdarlings.com/data/document-coverage-by-program-court-and-year/, SHA-256 478095542506b8e19d433cdd8b9fbf4cd5bd8347e32ad0f922fca325c69917bb