RECORD FORMAT FOR SA05 - SA50 FILES FILE NAMES -- the names of the detail county data files found on the SPI CD-ROM have a standard format: SAnn.DFX where nn = table number (05,07,25,27,30,35,45,50) The files, grouped by table number, are located in directories with the name SAnn, where "nn" is the table number. FILE CONTENTS -- the estimates contained in these files are annual, from 1958 to the latest available year. Generally, the estimates become available 8 months after the close of the calendar year. With the exception of "average" type data (per capita personal income), the income estimates are shown in thousands of dollars. The population estimates, which in most cases are prepared by the Bureau of the Census, are in number of persons. Employment estimates are number of jobs. RECORD FORMAT -- the files contain two types of records: area title records and data records. Both types have the same record format with the exception of the data area. The format is as follows: 001 - 005 2-digit State FIPS code and "000". 006 - 006 Table code for data records, an "A" for area title records. The codes are as follows: A (all) - area title record Y = SA05 - Total Personal Income & Earnings U = SA07 - Wage & Salary Disbursements E = SA25 - Full- & Part-time Employment R = SA27 - Full- & Part-time Wage & Salary Employment V = SA30 - Regional Economic Profiles J = SA35 - Transfer Payments S = SA45 - Farm Income & Expenses X = SA50 - Tax & Nontax Payments 007 - 009 Line code - a unique code which identifies each component (line) shown on the table. NOTE - these codes just provide unique identifiers for the data. They do not indicate anything about the data structure, i.e., which lines are subtotals and which are maximum detail. Line codes are identified in files SAnnTITL.TXT, where nn is the table number. 010 - 010 BEA region code: 1 = New England 2 = Mideast 3 = Great Lakes 4 = Plains 5 = Southeast 6 = Southwest 7 = Rocky Mountain 8 = Far West 011 - 017 Zero filled. 018 - 018 space 019 - 022 Year group code - the initial year of the data series on each record, usually "1958" 023 - 517 DATA RECORDS: 45 11-digit data fields; each field contains the data for one year. The data are shown with leading signs (both + and -) and leading zeros. With the exception of per capita personal income estimates, the income estimates are shown in thousands of dollars. The employment estimates are shown in number of jobs. 023-033 1958 188-198 1973 353-363 1988 034-044 1959 199-209 1974 364-374 1989 045-055 1960 210-220 1975 375-385 1990 056-066 1961 221-231 1976 386-396 1991 067-077 1962 232-242 1977 397-407 1992 078-088 1963 243-253 1978 408-418 1993 122-132 1964 254-264 1979 419-429 1994 089-099 1965 265-275 1980 430-440 1995 100-110 1966 276-286 1981 441-451 1996 111-121 1967 287-297 1982 133-143 1968 298-308 1983 144-154 1969 309-319 1984 155-165 1970 320-330 1985 166-176 1971 331-341 1986 177-187 1972 342-352 1987 Data fields that contain suppressed data are zero filled, "+0000000000", and the disclosure code, in the rightmost 45 characters of the record, show a "1" or "9" for that field. See below for further explanation. When using the SPI program, those suppressed fields will be shown as "(D)" or "(N)". TITLE RECORDS: 23-42: State name 43-517: blanks 518 - 562 Disclosure codes - each digit corresponds to a data field on the record. Thus, an entry in cc 520 refers to the data in cc 45 - 55, or the data for the year 1960. 518 1958 533 1973 548 1988 519 1959 534 1974 549 1989 520 1960 535 1975 550 1990 521 1961 536 1976 551 1991 522 1962 537 1977 552 1992 523 1963 538 1978 553 1993 524 1964 539 1979 554 1994 525 1965 540 1980 555 1995 526 1966 541 1981 556 1996 527 1967 542 1982 528 1968 543 1983 529 1969 544 1984 530 1970 545 1985 531 1971 546 1986 532 1972 547 1987 The disclosure codes are as follows: 0 = data shown 1 = data not shown to avoid disclosure of confidential information - shown as (D) on printed tables 9 = not available - shown as (N) on printed tables 563 - 564 Carriage return / line feed characters -- if the file is being read as a sequential file, these characters indicate the end of the record and are NOT READ into the machine as part of the record, i.e., the record length appears to be 562 characters. If the file is read as a random, these characters must be included in the record format specification.