Pandemic Darlings The pandemic economy, in original documents
Home Data downloads Treasury airline payroll support files and the section 4003 loan page

Source collection · Payroll Support Program

Treasury airline payroll support files and the section 4003 loan page

PSP1, PSP2 and PSP3 payments as Treasury published them — 611, 489 and 484 rows — with the raw HTML of the CARES section 4003 loan page, which Treasury never published as a data file.

Files4 · 286 KB
FormatsCSV, HTML
Source vintage2023-08-17 (PSP1); 2022-07-27 (PSP2 and PSP3); 2026-07-21 (section 4003 page capture)
Published byU.S. Department of the Treasury
Acquired2026-07-21
Releasepandemic-darlings-data-v3-2026-09-18
Official sourcehome.treasury.gov ↗
RightsU.S. government public data; no additional rights asserted over the source files.
Schematreasury-psp-2026-07-21.json

Files 4RegisterColumnsCaveats

What it is

Payroll support paid airlines, cargo carriers and aviation contractors to keep employees on payroll. Treasury ran it three times: the CARES Act round, the December 2020 extension, and the American Rescue Plan round. Each CSV lists participants, where they are, the agreement date and the payroll support total, plus note principal, warrant count and warrant exercise price for the larger recipients that had to give Treasury financial instruments in return.

The fourth file is different. CARES section 4003 loans — the separate loan program for air carriers and national-security businesses — were never published as a CSV or a spreadsheet. Treasury put the recipients in HTML tables and hung a transaction summary and a transaction documentation PDF off each one, so the page itself is the record and it is preserved here as the bytes that were served on 2026-07-21.

Where it comes from

The three CSVs come from Treasury's own file URLs, each carrying the publisher's data-as-of date in its name: 2023-08-17 for PSP1, 2022-07-27 for PSP2 and PSP3. They are three separate rounds, not a series, and the later files do not supersede the earlier ones.

Files

Every file below was re-hashed on 2026-09-18 against the checksum written in its acquisition manifest on 2026-07-21 and against the audit evidence file. 4 of 4 matched.

FileRowsSizeSHA-256Preserved copy
PSP1-08-17-2023.csv611
measured
55 KB0ed8f9d85bed145150aebee687b83f0f5fb57ccb4e843be735ac5da6a7707470verified 2026-07-21Official copy ↗
Download (55 KB)
PSP2-07-27-2022.csv489
measured
48 KB03225823428476fa110233b058c709fd32dae6678c134b1565a9aa8e66c6bee0verified 2026-07-21Official copy ↗
Download (48 KB)
PSP3-07-27-2022.csv484
measured
43 KBcb544f06a8f85d98fa3252cd9270024c06e2e6a2cf0b7bd769fd584ae82516a3verified 2026-07-21Official copy ↗
Download (43 KB)
cares-4003-loans-page.htmlHTML capture140 KBda3756c037bdb7dd08d345de6e015325e44cdb13b87280dd93ba03ba14ae1a6everified 2026-07-21Official copy ↗
Download (140 KB)
ChecksumsThe SHA-256 values above are the checksums of the exact bytes this archive holds. A copy taken from the publisher today can be checked against them; if it differs, the publisher changed the file.

Transaction documents

Treasury's section 4003 page links a transaction summary and a transaction documentation PDF for each loan, and the monthly loan reports it files with Congress under section 4026. None of those documents was pulled in the 2026-07-21 run. Every one of them is listed here with its publisher URL, taken from the captured page, so the gap is countable: 155 documents held by the publisher and not by this archive, 0 held here, and 3 classes of document — the per-participant payroll support agreements, notes and warrants — that the page does not link at all.

Document typeRowsHeld herePublic elsewhereNot acquired
CARES Act section 4026 loan report to Congress830830
transaction summary350350
transaction documentation (loan agreement, note, warrant exhibits as published)350350
payroll support agreements, notes and warrants, per participant3003
other linked document1010
programme procedures / minimum requirements1010
How to read itStatus in the register means what it says: held is a byte-verified copy in this archive, public elsewhere is a document the publisher's captured page links and this archive does not hold, not acquired is a document that exists but has no published URL on that page. The full register is a CSV: transaction-documents.csv.

Columns

The three CSVs share a shape: participant type, participant, city, state, agreement date, payroll support, note principal, number of warrants, warrant exercise price. PSP2 adds an application date. Every file ends in two unnamed empty columns left over from Treasury's spreadsheet export, and PSP2 carries a stray #REF! in one of them. The bytes are published as served.

Column-level detail for each file, with observed types and value counts, is in the schema JSON linked above.

Caveats

  • Each CSV carries the publisher's data-as-of date in its file name: PSP1 2023-08-17, PSP2 and PSP3 2022-07-27. They are three separate rounds, not one time series.
  • Every file ends in two unnamed empty columns from Treasury's spreadsheet export; PSP2 additionally carries the literal #REF! in one of them. The bytes are published unchanged.
  • PSP2 and PSP3 do not decode as UTF-8: their header rows carry footnote markers in Windows-1252 bytes. Read them as cp1252 (PSP1 decodes as UTF-8).
  • Money columns are strings with a leading $, thousands separators and a trailing space; unused note and warrant columns hold the literal N/A.
  • Payroll support is a grant with note and warrant conditions for larger recipients only: 37 of 611 PSP1 rows, 20 of 489 PSP2 rows and 19 of 484 PSP3 rows carry note principal.
  • Treasury published no CSV or XLSX for CARES section 4003 loans, so the loan page is preserved as raw HTML. The per-transaction summary and documentation PDFs it links were not acquired in the 2026-07-21 run; they are enumerated with status in the collection's transaction-document register.
Cite this collection. Name the source vintage; the numbers depend on it.Treasury airline payroll support files and the section 4003 loan page, 2023-08-17 (PSP1); 2022-07-27 (PSP2 and PSP3); 2026-07-21 (section 4003 page capture), as preserved by Pandemic Darlings, release pandemic-darlings-data-v3-2026-09-18, https://pandemicdarlings.com/data/treasury-psp-2026-07-21/
Back to top