Schedule of Changes to Tennessee newkeys

There were twelve regional libraries that reported as “region community” libraries in 1990 and 1991 then as “regional” libraries from 1992-1999. After 1999, the system was restructured and data from these regional libraries are now aggregated in the Tennessee State Library and Archives’ report to the NCES State Library Agencies (StLA) survey. These regional libraries are:

Tennessee regional libraries, 1990-1999
newkey Library name City
TN0011 Blue Grass Columbia
TN0022 Caney Fork Sparta
TN0030 Clinch-Powell Clinton
TN0041 Forked Deer Halls
TN0054 Fort Loudon Athens
TN0065 Highland Rim Murfreesboro
TN0079 Nolichucky Morristown
TN0090 Reelfoot Martin
TN0100 Shiloh Jackson
TN0110 Upper Cumberland Cookeville
TN0122 Warioto Clarksville
TN0131 Watauga Johnson City

As a related matter, a number of “community” libraries have data in the FSCS series in 1991, then miss 1992-1998, and begin reporting again in 1999. From 1992-1998, data from these libraries were aggregated in the various regionals listed above.

The public library in Bristol (newkey = TN0127) has data from 1990 through 1998. According to the library’s Web page:

The Bristol Public Library serves the citizens of both Bristol, VA, and Bristol, TN.

The main branch is in Virginia and the Avoca branch is in Tennessee. The Virginia data in the FSCS series are in newkey = VA0010. From examining the data, it currently appears that the data reported for Tennessee are system data and not just branch data.

In a few years of these data, the CITY has an extra designation such as “(S)” for system, (IN) for independent. This designation is for internal purposes in Tennessee and it is normally removed when the data are submitted to FSCS.

Here are the changes in FSCSKEYs to create the newkey:

/* LAKE CITY */ if year = 1990 and FSCSKEY = 'TN0026' then newkey = 'TN0197'; if year = 1991 and FSCSKEY = 'TN0026' then newkey = 'TN0197'; if year = 1992 and FSCSKEY = 'TN0026' then newkey = 'TN0197'; if year = 1993 and FSCSKEY = 'TN0026' then newkey = 'TN0197'; if year = 1994 and FSCSKEY = 'TN0026' then newkey = 'TN0197'; /* DYERSBURG */ if year = 1990 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; if year = 1991 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; if year = 1992 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; if year = 1993 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; if year = 1994 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; if year = 1995 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; if year = 1996 and FSCSKEY = 'TN0032' then newkey = 'TN0205'; /* MCKENZIE */ if year = 1990 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; if year = 1991 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; if year = 1992 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; if year = 1993 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; if year = 1994 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; if year = 1995 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; if year = 1996 and FSCSKEY = 'TN0082' then newkey = 'TN8049'; /* JAMESTOWN */ if year = 1990 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; if year = 1991 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; if year = 1992 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; if year = 1993 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; if year = 1994 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; if year = 1995 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; if year = 1996 and FSCSKEY = 'TN0104' then newkey = 'TN0203'; /* ARDMORE */ if year = 1991 and FSCSKEY = 'TN0137' then newkey = 'TN8001'; /* LYNNVILLE */ if year = 1991 and FSCSKEY = 'TN0138' then newkey = 'TN8002'; /* MINOR HILL */ if year = 1991 and FSCSKEY = 'TN0139' then newkey = 'TN8003'; /* BEERSHEBA SPRINGS */ if year = 1991 and FSCSKEY = 'TN0140' then newkey = 'TN8005'; /* COALMONT */ if year = 1991 and FSCSKEY = 'TN0141' then newkey = 'TN8006'; /* MONTEAGLE */ if year = 1991 and FSCSKEY = 'TN0142' then newkey = 'TN8007'; /* PALMER */ if year = 1991 and FSCSKEY = 'TN0143' then newkey = 'TN8008'; /* TRACY CITY */ if year = 1991 and FSCSKEY = 'TN0144' then newkey = 'TN8009'; /* BRICEVILLE */ if year = 1991 and FSCSKEY = 'TN0145' then newkey = 'TN8011'; /* NORRIS */ if year = 1991 and FSCSKEY = 'TN0146' then newkey = 'TN8016'; /* CARYVILLE */ if year = 1991 and FSCSKEY = 'TN0147' then newkey = 'TN8010'; /* JELLICO */ if year = 1991 and FSCSKEY = 'TN0148' then newkey = 'TN8013'; /* LAFOLLETTE */ if year = 1991 and FSCSKEY = 'TN0149' then newkey = 'TN8014'; /* DEER LODGE */ if year = 1991 and FSCSKEY = 'TN0150' then newkey = 'TN8012'; /* OAKDALE */ if year = 1991 and FSCSKEY = 'TN0151' then newkey = 'TN8020'; /* PETROS */ if year = 1991 and FSCSKEY = 'TN0153' then newkey = 'TN8017'; /* SUNBRIGHT */ if year = 1991 and FSCSKEY = 'TN0154' then newkey = 'TN8018'; /* ONEIDA */ if year = 1991 and FSCSKEY = 'TN0155' then newkey = 'TN0193'; /* WINFIELD */ if year = 1991 and FSCSKEY = 'TN0156' then newkey = 'TN8019'; /* LUTTRELL */ if year = 1991 and FSCSKEY = 'TN0157' then newkey = 'TN8015'; /* TRIMBLE */ if year = 1991 and FSCSKEY = 'TN0158' then newkey = 'TN8022'; /* HALLS */ if year = 1991 and FSCSKEY = 'TN0159' then newkey = 'TN8021'; /* GREENBACK */ if year = 1991 and FSCSKEY = 'TN0160' then newkey = 'TN8023'; /* LOUDON */ if year = 1991 and FSCSKEY = 'TN0161' then newkey = 'TN8024'; /* PHILADELPHIA */ if year = 1991 and FSCSKEY = 'TN0162' then newkey = 'TN8025'; /* CALHOUN */ if year = 1991 and FSCSKEY = 'TN0163' then newkey = 'TN8026'; /* ENGLEWOOD */ if year = 1991 and FSCSKEY = 'TN0164' then newkey = 'TN8027'; /* ETOWAH */ if year = 1991 and FSCSKEY = 'TN0165' then newkey = 'TN8031'; /* NIOTA */ if year = 1991 and FSCSKEY = 'TN0166' then newkey = 'TN8032'; /* VONORE */ if year = 1991 and FSCSKEY = 'TN0167' then newkey = 'TN0200'; /* TELLICO PLAINS */ if year = 1991 and FSCSKEY = 'TN0168' then newkey = 'TN8033'; /* BENTON */ if year = 1991 and FSCSKEY = 'TN0169' then newkey = 'TN8034'; /* COPPERHILL */ if year = 1991 and FSCSKEY = 'TN0170' then newkey = 'TN8035'; /* DUCKTOWN */ if year = 1991 and FSCSKEY = 'TN0171' then newkey = 'TN8036'; /* GRAYSVILLE */ if year = 1991 and FSCSKEY = 'TN0172' then newkey = 'TN8037'; /* OLIVER SPRINGS */ if year = 1991 and FSCSKEY = 'TN0173' then newkey = 'TN8038'; /* EAGLEVILLE */ if year = 1991 and FSCSKEY = 'TN0174' then newkey = 'TN8040'; /* LA VERGNE */ if year = 1994 and FSCSKEY = 'TN0195' then newkey = 'TN0175'; /* COSBY */ if year = 1991 and FSCSKEY = 'TN0176' then newkey = 'TN8042'; /* DEL RIO */ if year = 1991 and FSCSKEY = 'TN0177' then newkey = 'TN8043'; /* PARROTTSVILLE */ if year = 1991 and FSCSKEY = 'TN0178' then newkey = 'TN8044'; /* BEAN STATION */ if year = 1991 and FSCSKEY = 'TN0179' then newkey = 'TN8045'; /* BLAINE */ if year = 1991 and FSCSKEY = 'TN0180' then newkey = 'TN8046'; /* WASHBURN */ if year = 1991 and FSCSKEY = 'TN0181' then newkey = 'TN8047'; /* STRAWBERRY PLAINS */ if year = 1991 and FSCSKEY = 'TN0182' then newkey = 'TN8048'; /* WHITE PINE */ if year = 1991 and FSCSKEY = 'TN0183' then newkey = 'TN0196'; /* GLEASON */ if year = 1991 and FSCSKEY = 'TN0184' then newkey = 'TN8050'; /* GREENFIELD */ if year = 1991 and FSCSKEY = 'TN0185' then newkey = 'TN8051'; /* SHARON */ if year = 1991 and FSCSKEY = 'TN0186' then newkey = 'TN8052'; /* GRAND JUNCTION */ if year = 1991 and FSCSKEY = 'TN0187' then newkey = 'TN8055'; /* MIDDLETON */ if year = 1991 and FSCSKEY = 'TN0188' then newkey = 'TN8054'; /* WHITEVILLE */ if year = 1991 and FSCSKEY = 'TN0189' then newkey = 'TN8053'; /* MOSHEIM */ if year = 1991 and FSCSKEY = 'TN0190' then newkey = 'TN8056'; /*--------2009-------*/ /* DUCKTOWN */ if year = 1991 and FSCSKEY = 'TN0171' then newkey = 'TN0210'; if year = 1999 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2000 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2001 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2002 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2003 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2004 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2005 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2006 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2007 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; if year = 2008 and FSCSKEY = 'TN8036' then newkey = 'TN0210'; /*--------2009-------*/

August 12, 2012

Back to the Schedule of Changes
Back to PLDF3 main page
Back to LDA main page