Name: Daily Cash And Debt Operations Of U.S. Treasury
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

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

333.09 kB
34,034 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

608.23 kB
47,284 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

240.33 kB
15,575 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

178.85 kB
13,150 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.97 MB
326,036 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

699.72 kB
64,211 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

926.18 kB
108,183 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

183.06 kB
49,516 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