Help for Select Series
DQS contains 82 revenue, 138 expenditure, and 67 debt variables. Some variables are only valid for certain levels of government and certain states.
Notes for Use
Definitions of the Census variables are available from the Classification Manual.
We have coded the variables so that they appear in an order that roughly corresponds to the summary tables provided by Census. All variable names begin with a two- or three-digit code that starts with R, E, or D for Revenue, Expenditure, or Debt. The R, E, and D numbers are not official Census codes.
Census codes, where applicable, are in parentheses after the variable name. For example, for "(R06) Property Tax (T01)" "T01" is the official Census code. Either the variable name or the Census code can be used to look up the definition of the variable in the Classification Manual.
If a variable does not have a code in parenthesis after its name (e.g., "(R26) Total Income Taxes"), then it is a summary variable. Summary variables are composed of two or more individual variables. In this case, R26 is the sum of R27 (Individual Income Tax) and R28 (Corporate Income Tax) (or T40 and T41 under Census codes). For more information on summary methodology, see Methodology for Summary Tabulations: State and Local Government Finance
The following tables provide a guide to the variables. The tables can be used either as an index for finding variables by variable code or as an accounting guide to see which variables belong to which categories.
Not all variables are available or valid for every level and every state. For example, "(R34) Total State IG Revenue" and "(R35) Tot Local IG Rev" are not available at the "State and Local" level because that analysis level treats all state and local governments as one observation. The Functional Code definitions (left column) provide availability information for each functional code (the last two digits in Census code).
These variables are the same as found in the Govt_Finances.mdb file released by Census in previous years. This file may be posted by request for 60 days at http://www2.census.gov/pub/outgoing/govs/special60/.