About this Dataset

Daily Cash And Debt Operations Of U.S. Treasury

Context

The Daily Treasury Statement (DTS) dataset contains a series of tables showing the daily cash and debt operations of the U.S. Treasury.

The data includes operating cash balance, deposits and withdrawals of cash, public debt transactions, federal tax deposits, income tax refunds issued (by check and electronic funds transfer (EFT)), short-term cash investments, and issues and redemptions of securities. All figures are rounded to the nearest million.

Tables

Dts Debtsubjlim 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_debtsubjlim_20051003_20230403

325.28 KB
34034 rows
17 columns


CREATE TABLE dts_debtsubjlim_20051003_20230403 (
  "record_date" TIMESTAMP,
  "debt_category" VARCHAR,
  "debt_category_description" VARCHAR,
  "closing_balance_today" DOUBLE,
  "opening_balance_today" DOUBLE,
  "opening_balance_this_month" DOUBLE,
  "opening_balance_this_fiscal_year" DOUBLE,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "sub_table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Fedtaxdpst 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_fedtaxdpst_20051003_20230403

593.97 KB
47284 rows
16 columns


CREATE TABLE dts_fedtaxdpst_20051003_20230403 (
  "record_date" TIMESTAMP,
  "federal_tax_deposit_type" VARCHAR,
  "federal_tax_deposit_type_description" VARCHAR,
  "federal_tax_deposits_today" BIGINT,
  "federal_tax_deposits_month_to_date" BIGINT,
  "federal_tax_deposits_fiscal_year_to_date" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "sub_table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Incmtaxrfnd 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_incmtaxrfnd_20051003_20230403

234.7 KB
15575 rows
16 columns


CREATE TABLE dts_incmtaxrfnd_20051003_20230403 (
  "record_date" TIMESTAMP,
  "federal_tax_refund_type" VARCHAR,
  "federal_tax_refund_type_description" VARCHAR,
  "federal_tax_refunds_today" BIGINT,
  "federal_tax_refunds_month_to_date" BIGINT,
  "federal_tax_refunds_fiscal_year_to_date" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "sub_table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Opcashbal 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_opcashbal_20051003_20230403

174.66 KB
13150 rows
16 columns


CREATE TABLE dts_opcashbal_20051003_20230403 (
  "record_date" TIMESTAMP,
  "type_of_account" VARCHAR,
  "closing_balance_today" DOUBLE,
  "opening_balance_today" BIGINT,
  "opening_balance_this_month" BIGINT,
  "opening_balance_this_fiscal_year" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "sub_table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Opcashdpstwdrl 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_opcashdpstwdrl_20051003_20230403

2.83 MB
326036 rows
17 columns


CREATE TABLE dts_opcashdpstwdrl_20051003_20230403 (
  "record_date" TIMESTAMP,
  "type_of_account" VARCHAR,
  "transaction_type" VARCHAR,
  "transaction_category" VARCHAR,
  "transaction_category_description" VARCHAR,
  "transactions_today" BIGINT,
  "transactions_month_to_date" BIGINT,
  "transactions_fiscal_year_to_date" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Pubdebtcashadj 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_pubdebtcashadj_20051003_20230403

683.32 KB
64211 rows
17 columns


CREATE TABLE dts_pubdebtcashadj_20051003_20230403 (
  "record_date" TIMESTAMP,
  "transaction_type" VARCHAR,
  "adjustment_type" VARCHAR,
  "adjustment_type_description" VARCHAR,
  "adjustments_today" BIGINT,
  "adjustments_month_to_date" BIGINT,
  "adjustments_fiscal_year_to_date" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "sub_table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Pubdebttrans 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_pubdebttrans_20051003_20230403

904.47 KB
108183 rows
17 columns


CREATE TABLE dts_pubdebttrans_20051003_20230403 (
  "record_date" TIMESTAMP,
  "transaction_type" VARCHAR,
  "security_marketability" VARCHAR,
  "security_type" VARCHAR,
  "security_type_description" VARCHAR,
  "transactions_today" BIGINT,
  "transactions_month_to_date" BIGINT,
  "transactions_fiscal_year_to_date" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Dts Stcashinvest 20051003–20230403

@kaggle.nakulshahdadpuri314_daily_treasury_statement.dts_stcashinvest_20051003_20230403

178.77 KB
49516 rows
17 columns


CREATE TABLE dts_stcashinvest_20051003_20230403 (
  "record_date" TIMESTAMP,
  "transaction_type" VARCHAR,
  "transaction_type_description" VARCHAR,
  "type_a_depositary_amount" BIGINT,
  "type_b_depositary_amount" BIGINT,
  "type_c_depositary_amount" BIGINT,
  "total_amount" BIGINT,
  "table_number" VARCHAR,
  "table_name" VARCHAR,
  "sub_table_name" VARCHAR,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Daily Cash And Debt Operations Of U.S. Treasury

About this Dataset

Daily Cash And Debt Operations Of U.S. Treasury

Context

Contents

Tables

Dts Debtsubjlim 20051003–20230403

Dts Fedtaxdpst 20051003–20230403

Dts Incmtaxrfnd 20051003–20230403

Dts Opcashbal 20051003–20230403

Dts Opcashdpstwdrl 20051003–20230403

Dts Pubdebtcashadj 20051003–20230403

Dts Pubdebttrans 20051003–20230403

Dts Stcashinvest 20051003–20230403

Share link