All providers
Sign in
Sign up to use US Treasury Fiscal Data
Firecrawl Alexandria
Public records

US Treasury Fiscal Data

1Request
stringRequired

Table path under /services/api/fiscal_service/, e.g. v2/accounting/od/debt_to_penny (the `endpoint` of a table in `datasets`).

string

next_cursor from the previous page of the same query.

string[]

Columns to return (record_date is always included). Omitted or null returns every column. Notes: Fiscal Data aggregates rows that become identical when columns are dropped, and sort keys must be among the returned columns (sorting on a dropped column is rejected upstream). Separate values with commas.

object[]

Clauses are ANDed.

5 credits
Codefollows the fields above
const result = await firecrawl.scrape({
  alexandria: {
    provider: "fiscaldata-treasury-gov",
    capability: "fiscal-data/data",
    options: {
      endpoint: "v2/accounting/od/debt_to_penny",
      filter: [
        {
          field: "record_date",
          op: "eq",
          value: "2024-01-31",
        },
      ],
    },
  },
});
2Response example

This is a sample shape. Press Run to see live data from US Treasury Fiscal Data.

{
  "api_url": "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/debt_to_penny",
  "count": 1,
  "endpoint": "v2/accounting/od/debt_to_penny",
  "fields": [
    {
      "currency": "USD",
      "data_type": "CURRENCY",
      "format": "$10.20",
      "label": "Debt Held by the Public",
      "name": "debt_held_public_amt"
    },
    {
      "currency": "USD",
      "data_type": "CURRENCY",
      "format": "$10.20",
      "label": "Intragovernmental Holdings",
      "name": "intragov_hold_amt"
    },
    {
      "currency": null,
      "data_type": "DAY",
      "format": "DD",
      "label": "Calendar Day Number",
      "name": "record_calendar_day"
    },
    {
      "currency": null,
      "data_type": "MONTH",
      "format": "MM",
      "label": "Calendar Month Number",
      "name": "record_calendar_month"
    },
    {
      "currency": null,
      "data_type": "QUARTER",
      "format": "Q",
      "label": "Calendar Quarter Number",
      "name": "record_calendar_quarter"
    },
    {
      "currency": null,
      "data_type": "YEAR",
      "format": "YYYY",
      "label": "Calendar Year",
      "name": "record_calendar_year"
    },
    {
      "currency": null,
      "data_type": "DATE",
      "format": "YYYY-MM-DD",
      "label": "Record Date",
      "name": "record_date"
    },
    {
      "currency": null,
      "data_type": "QUARTER",
      "format": "Q",
      "label": "Fiscal Quarter Number",
      "name": "record_fiscal_quarter"
    },
    {
      "currency": null,
      "data_type": "YEAR",
      "format": "YYYY",
      "label": "Fiscal Year",
      "name": "record_fiscal_year"
    },
    {
      "currency": null,
      "data_type": "INTEGER",
      "format": "10",
      "label": "Source Line Number",
      "name": "src_line_nbr"
    },
    {
      "currency": "USD",
      "data_type": "CURRENCY",
      "format": "$10.20",
      "label": "Total Public Debt Outstanding",
      "name": "tot_pub_debt_out_amt"
    }
  ],
  "filter": "record_date:eq:2024-01-31",
  "next_cursor": null,
  "observed_at_ms": 1790008936959,
  "page": 1,
  "page_size": 100,
  "records": [
    {
      "debt_held_public_amt": "27071861894841.00",
      "intragov_hold_amt": "7119288507552.64",
      "record_calendar_day": "31",
      "record_calendar_month": "01",
      "record_calendar_quarter": "1",
      "record_calendar_year": "2024",
      "record_date": "2024-01-31",
      "record_fiscal_quarter": "2",
      "record_fiscal_year": "2024",
      "src_line_nbr": "1",
      "tot_pub_debt_out_amt": "34191150402393.64"
    }
  ],
  "sort": "-record_date",
  "source_url": "https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/debt_to_penny?filter=record_date:eq:2024-01-31&sort=-record_date&page%5Bsize%5D=100&page%5Bnumber%5D=1",
  "total_count": 1,
  "total_pages": 1
}

Related providers

Browse the library