Data on how much the states are borrowing from the Federal Unemployment Trust Fund in order to pay unemployment benefits.
Advances to State Unemployment Funds (Social Security Act Title XII)
About This Dataset
Description:
The Advances to State Unemployment Funds (Social Security Act Title XII) dataset shows how much states and territories are borrowing from the Unemployment Trust Fund in order to pay out unemployment benefits and the interest. This includes the state or territories' outstanding borrowing balance, amount they are authorized to borrow for the current month, current month borrowings, interest accrued for current fiscal year, and interest received.
Data Table Name
Field Name
Display Name
Description
Data Type
Is Required
Showing 1 - 1 rows of 15 rows
Table Name
Description
Row Description
File Sizes
Row Count
Name
Definition
Notes & Known Limitations
The states and territories represented in this dataset are those that have been approved to borrow by the Department of Labor and/or have an outstanding borrowing balance with the Unemployment Trust Fund. The Advance Activities Schedule for September 17th through the 30th will have an interest received column for the states paying the interest due by September 30th. Section 1202(b)(10)(A) of the Social Security Act as amended by Section 9021 of PL 117-2 deferred the accrual of interest on state advances until September 6, 2021.
Refer to About This Dataset above for a data dictionary with field names and descriptions, as well as notes and known limitations.
Field Name
Display Name
Data Type
Showing 1 - 1 rows of 15 rows
Data Types
All data is returned as a string, including nulls. Refer to the chart above for the intended data type of each field.
Parameters
Refer to About This Dataset above for a data dictionary with field names and descriptions as well as notes and known limitations
Fields
toggle contents
Parameter: fields=
Definition: The fields parameter allows you to select which field(s) should be included in the response.
Accepts: The fields= parameter accepts a comma-separated list of field names (no parentheses).
Required: No, specifying fields is not required to make an API request.
Default: If desired fields are not specified, all fields will be returned.
Notes: When a field named passed to the fields= parameter is not available for the endpoint accessed, an error will occur. Note that omitting fields can result in automatically aggregated and summed data results. For more information, view the full documentation on Aggregation and Sums.
EXAMPLE
?fields=
Filters
toggle contents
Parameter: filter=
Definition: Filters are used to view a subset of the data based on specific criteria. For example, you may want to find data that falls within a certain date range, or only show records which contain a value larger than a certain threshold.
Accepts: The filter parameter filter= accepts filters from the list below, as well as specified filter criteria. Use a colon at the end of a filter parameter to pass a value or list of values. For lists passed as filter criteria, use a comma-separated list within parentheses. Filter for specific dates using the format YYYY-MM-DD.
Required: No, filters are not required to make an API request.
Default: When no filters are provided, the default response will return all fields and all data.
The filter parameter accepts the following filters:
Definition: The sort parameter allows a user to sort a field in ascending (least to greatest) or descending (greatest to least) order.
Accepts: The sort parameter sort= accepts a comma-separated list of field names.
Required: No, sorting is not required to make an API request.
Default: When no sort parameter is specified, the default is to sort by the first column listed. Most API endpoints are thus sorted by date in ascending order (historical to most current).
Notes: You can nest sorting by passing the sort= parameter a comma-separated list.
Definition: The format parameter allows a user to define the output method of the response (CSV, JSON, XML).
Accepts: The format= parameter accepts xml, json, or csv as an input.
Required: No, the format parameter is not required to make an API request.
Default: When no format is specified, the default response format is JSON.
EXAMPLE
?format=csv
Pagination
toggle contents
Parameter: page[size]= and page[number]=
Definition: The page size will set the number of rows that are returned on a request, and page number will set the index for the pagination, starting at 1. This allows the user to paginate through the records returned from an API request.
Accepts: The page[number]= and page[size]= parameters both accept integers.
Required: No, neither pagination parameters are required to make an API request.
Default: When no page number or page size parameter is specified, the default response is
Page number: 1
Page size: 100
EXAMPLE
Methods
Our APIs accept the GET method, one of the most common HTTP methods.
