Data Explorer
Browse and query all 16 Fiscal Receipts datasets using SQL. Queries run entirely in your browser — no server receives your SQL or sees any intermediate results. Powered by DuckDB-WASM; parquet files are streamed on demand (HTTP range requests).
Corpus: 1,993 browsable program pages; 1,739 of them carry detail-grade R-2/P-40 J-book data — excludes personnel, O&M, and R-1/P-1 lines that lack R-2/P-40 project detail. what separates the two tiers? →
Dataset inventory
Row counts and sizes are read from the parquet files this build shipped — never authored by hand. Each scope line says what one row of that dataset is, so a row count can be compared against the right denominator.
| Dataset | Rows | Size | Citation | Scope — what one row is |
|---|---|---|---|---|
| budget_lines | 8,549 rows | 181 KB | cited | One row per (program element × amount type) figure in the FY2026 President's Budget R-1/P-1 workbooks, carrying the source sheet and cell address it was read from. Fenced to the PB2026 edition. |
| budget_lines_decade | 32,642 rows | 762 KB | cited | The decade sibling of budget_lines: one row per (President's Budget edition × program element × amount type) figure across all ten editions PB2017–PB2026, each cited to its own edition's workbook cell. Editions are parallel publications, never reconciled. |
| jbook_details | 21,028 rows | 365 KB | cited | One row per (program element × project × budget scenario) cost figure extracted from J-book R-2/P-40 XML, with its XML element path and source-PDF SHA-256. |
| jbook_narratives | 11,308 rows | 3.5 MB | cited | One row per J-book narrative text block — mission, description, justification, or accomplishment/planned-program — with its XML element path and source-PDF SHA-256. |
| fct_budget_trajectory | 1,980 rows | 32 KB | cited | One row per (program element × organization) with FY2024 actuals, FY2025 total, FY2026 total and the FY25→FY26 delta pivoted side by side. |
| dim_programs | 1,739 rows | 41 KB | cited | One row per program element that has full R-2/P-40 J-book detail — the detail-grade tier, NOT the full page universe (see the corpus statement above) — with org, exhibit family, project count and reconciliation status. |
| dim_entities | 114,806 rows | 2.6 MB | cited | One row per contractor entity family, name-normalized across USAspending/SAM.gov UEI registrations, with its UEI count, total DoD obligation and worst match-confidence tier. |
| fct_influence | 193 rows | 6 KB | cited | One row per (contractor family × filing year) of Senate LDA lobbying totals, alongside that family's DoD obligations. Income and expense are alternative disclosures — non-additive, never summed. |
| fct_program_lobbying | 10,560 rows | 180 KB | cited | One row per (LDA filing × matched program element) mention — a filing appears once for every program its issue text has keyword co-occurrence with (an exact PE/BLI code, a curated alias, or >=2 distinct title words; see evidence_kind), never a claim that the filing names the program. Rows count evidence-tiered mentions, not filings. |
| fct_budget_to_awards | 10,091 rows | 49 KB | cited | One row per (program element × USAspending award) crosswalk link, each carrying its match method and confidence tier. A link is an inference, not a reported fact. |
| dim_geography | 1,045 rows | 14 KB | cited | One row per (state × congressional district) place of performance, with transaction count and total obligation aggregated from the award crosswalk. |
| fct_district_totals | 106 rows | 2 KB | cited | One row per (state × congressional district), with obligation dollars counted once per DISTINCT high-confidence-crosswalked award — the district headline. Its per-(district, program element) sibling, fct_district_programs, is not summable: an award matched to N program elements appears N times with the same dollars there. |
| fct_program_concentration | 24 rows | 1 KB | cited | One row per program element with enough matched award dollars to compute an HHI market-concentration score. |
| fct_state_per_capita | 6 rows | 4 KB | cited | One row per (jurisdiction × comparable spending category × fiscal year) in the CA/CT state-checkbook pilot, with population and per-capita amount. |
| fct_improper_exposure | 15 rows | 1 KB | cited | One row per federal agency reporting improper payments, with the derived dollar exposure and weighted error rate from paymentaccuracy.gov. |
| dim_lobbyists | 1,456 rows | 89 KB | cited | One row per individual lobbyist named in Senate LDA filings, with covered-position and revolving-door flags and the UUID/URL of the filing that disclosed them. |
Built: August 12, 2026. Citation methodology: see methodology.
California data covers FY2025 only — CA Open Fi$Cal updates on a lag; prior years not yet ingested. why FY2025 only? →
Interactive SQL explorer
Queries run entirely in your browser — no data leaves your machine. The DuckDB-WASM engine loads on demand (~4 MB).
One row per (program element × amount type) figure in the FY2026 President's Budget R-1/P-1 workbooks, carrying the source sheet and cell address it was read from. Fenced to the PB2026 edition.
Canned queries