Hey y’all
The following dataset from treasury.gov allows you to see what the U.S. government spends on per day, on a line item basis, out of the TGA (treasury general account):
Daily cash and debt operations of the U.S. Treasury, including cash balance, deposits, and withdrawals; tax deposits and refunds; and debt transactions.
Here’s a streamlit application that allows you to explore this dataset:
Live app:https://dharmatech.dev/fed-net-liquidity/TGA_Explorer
Source code:
Intro video:
A look at outlier spending by the EPA this year:
2 Likes
Hey y’all
I’ve added a variation of the dashboard page that allows you to easily compare Federal government spending from year to year:
import pandas as pd
import treasury_gov_pandas.datasets.deposits_withdrawals_operating_cash.load
import streamlit as st
import plotly.express as px
@st.cache_data
def load_dataframe():
return treasury_gov_pandas.datasets.deposits_withdrawals_operating_cash.load.load()
df = load_dataframe()
df['record_date'] = pd.to_datetime(df['record_date'])
df['transaction_today_amt'] = pd.to_numeric(df['transaction_today_amt'], errors='coerce')
df['transaction_mtd_amt'] = pd.to_numeric(df['transaction_mtd_amt'], errors='coerce')
df['transaction_fytd_amt'] = pd.to_numeric(df['transaction_fytd_amt'], errors='coerce')
df = df.query('transaction_catg != "null"')
show original
Here’s a quick demo showing how you can do your own government efficiency research:
1 Like
system
July 26, 2025, 11:26pm
3
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.
