r/datasets • • 10h ago

dataset [self-promotion] US IEEPA tariff-refund claim sales and pass-through obligations, extracted from SEC filings (324 events, 2026)

2 Upvotes

i put together a dataset of US IEEPA tariff-refund claims as they show up in 10-Q, 10-K and 8-K filings. not every tariff mention. just filings that talk about IEEPA and a refund, from April 2026 onward.

324 claim events so far: sales, loans, refund receipts, customer or supplier obligations, payments, and accruals. plus 1,189 filing candidates. each event has the company, amounts, an implied price when a sale lists both face value and proceeds, the quoted sentence, and a link back to the sec.gov filing. it rebuilds daily.

one example already in the data: Funko's participatory sale transferred $22.1 million in claims for $19.2 million proceeds. that's about 87 cents on the dollar.

a few caveats before anyone sums the column. repeated disclosures are not separate deals. amendments stay as their own rows. coverage is search-derived, so a missing company does not mean they have no claim. Court of International Trade dockets and private-company activity are out of scope. some amounts were checked by an AI review against the quote; that is not a human audit. read the original filing.

format is parquet (and a json api). first 500 rows of each table are readable with no account, which covers the whole claim_events table (324 rows). a free account is needed to query, filter or download past that, and it counts against a monthly allowance.

disclosure: i built this at mostly right, my company.

https://mostlyright.md/datasets/us-tariff-refund-claims-sales-and-pass-through-2026


r/datasets • • 11h ago

resource Census county building-permit files: monthly, year-to-date and annual are different inputs

2 Upvotes

The Census Building Permits Survey has an official county-level download directory for new privately owned residential construction: https://www2.census.gov/econ/bps/County/

Before combining files, choose the time basis. In the county documentation, CO<YYMM>C is the current month, CO<YYMM>Y is year-to-date, and CO<YYYY>A is annual. Adding successive year-to-date files would count earlier months repeatedly. The year-to-date series can also incorporate late reports and corrections, so it need not equal a sum of previously downloaded current-month snapshots.

The record layout contains separate buildings, housing units and valuation fields. It also separates estimates with imputation from reported-only values. For a county housing-unit panel, choose one of those bases consistently and retain the reference period and download date. Read state and county FIPS fields as text so leading zeros survive the join.

A reproducible starting table would therefore identify county FIPS, reference period, time basis, construction type, measurement field and reported/imputed basis before adding the value. That is a proposed schema, not a tested extract or a new dataset of my own.

Official record layout and filename definitions: https://www.census.gov/construction/bps/sample/cntyasc.pdf

The scope is new residential authorizations. It is not a census of every local renovation or commercial permit, and it does not show completed homes.