Data Explorer
Browse and query all 14 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).
Dataset inventory
| Dataset | Rows | Citation | Description |
|---|---|---|---|
| budget_lines | 8,557 | cited | Budget line items from R-1 and P-1 Excel rollups. Workbook-cited. |
| jbook_details | 4,421 | cited | Project-level cost figures from J-book XML (R-2/P-40 exhibits). PDF-cited. |
| fct_budget_trajectory | 1,982 | cited | FY2024–FY2026 budget trajectory per program element — actuals, enacted, proposed. |
| dim_programs | 326 | cited | 326 DoD R&D and procurement program elements with org, exhibit family, and reconciliation status. |
| dim_entities | 76,727 | cited | Contractor entity families normalized across USAspending UEI records. |
| fct_influence | 181 | cited | LDA lobbying filing totals by contractor family and filing year (income/expense/obligations). Non-additive. |
| fct_program_lobbying | 32,780 | cited | Program-level lobbying mentions — each row links a filing to a matched program element. |
| fct_budget_to_awards | 10,091 | cited | Crosswalk linking budget program elements to USAspending award records by recipient. Each link carries a derived citation (method + confidence). |
| dim_geography | 1,045 | cited | Congressional district-level obligation totals derived from USAspending place-of-performance data (derived-cited). |
| fct_program_concentration | 24 | cited | HHI market concentration scores for programs with sufficient award data. |
| fct_state_per_capita | 6 | cited | State-level per-capita defense obligation (pilot: CA + CT). |
| fct_improper_exposure | 15 | cited | Programs flagged for improper payment exposure from oversight reports. |
| dim_lobbyists | 1,416 | cited | Individual lobbyist records extracted from LDA filings, with disclosing-filing provenance columns (LDA-cited). |
| jbook_narratives | 2,457 | cited | Mission and accomplishment narrative text blocks from J-book exhibits. |
Built: July 2, 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).
Budget line items from R-1 and P-1 Excel rollups. Workbook-cited.
Canned queries