Schedule of Changes to Kansas newkeys

Kansas required a series of changes.

In 1991, there are 17 dummy records for FSCSKEYs KS0323 through KS0339. There are no data in these records and except for the different FSCSKEYs, the records are identical–all values are zero. They are not related to the four libraries which start reporting in 1994 in overlapping numbers. It appears these records result from a keying error of some kind. They have been deleted from PLDF3. These dummy records are different from those in Connecticut in 1988 which are not deleted.

Most of the changes were to CITY and LIBNAME in the last year (usually but not always 2003) of the data. These changes were made so that the form of these entries would be comparable across the country in the List of Libraries. These changes are made only for 2003 and last year’s changes are reversed so these entries appear as they do in the NCES datasets. It should be noted that there are fewer of these editorial changes in the FY2003 datan than in the FY2002 data. The code listed below preserves the code for changes for FY2002 that were not necessary in FY2003 by commenting them out (that is, “/* */” marks.

The changes in CITY occured for 2003 in one case where “LAKIN/KEARNY COUN” was changed to “LAKIN.” When the name of the city appears at the end of the LIBNAME it is unedited because it will not affect how these names file in the List. As a result, the library in Belpre, Kansas appears as: HENRY LAIRD LIBRARY BELPRE in PLDF3.

Changes in LIBNAME were similar to those for CITY: in the last year of the data in some cases the LIBNAMEs were changed. Kansas LIBNAMEs often have a format with the CITY/LIBNAME as in “LAKIN/KEARNY COUNTY LIBRARY” where, as we have seen, the Kearny County Library is in Lakin city. The LIBNAME in this case was changed to “KEARNY COUNTY LIBRARY.” A few county library district LIBNAMEs were also edited so they were in the same format. Examples of these are discussed immediately below.

A more complex problem arose with a set of county district libraries where the data for two of them were mixed up and inconsistently named over the years. As mentioned, the LIBNAMEs were edited in these cases and in a few others to make them conform to the same format. The two are:

The Two Kansas District Libraries
newkey year CITY LIBNAME (in raw data) Edited LIBNAME
KS0072 2002 Louisburg LOUISBURG/LIBRARY DIST #1 MIAMI CO MIAMI COUNTY LIBRARY DISTRICT #1
KS0126 2002 Allen ALLEN/LYON COUNTY LIBRARY DIST 1 LYON COUNTY LIBRARY DISTRICT #1

Let’s take an example to see what the problem is first. BKVOL is the FSCS variable reporting volumes held by the library in the various years.

Lyon or Miami County?
FSCSKEY year CITY Zipcode LIBNAME (in raw data) BKVOL
KS0072 1989 Allen 66833 Library District #1, Lyon County, Allen 7,875
KS0072 1990 Allen 66833 Library District #1, Lyon County, Allen 8,163
KS0072 1991 Allen 66833 Library District #1, Lyon County, Allen 8,535
KS0072 1992 Allen 66833 Library District #1, Lyon County, Allen 8,745
KS0072 1993 Allen 66833 Library District #1, Lyon County, Allen 8,927
KS0072 1994 Allen 66833 Library District #1 Miami County Louisburg 26,616
KS0072 1995 Allen 66833 Library District #1 Miami County Louisburg 27,642
KS0072 1996 Allen 66053 Library District #1 Miami County Louisburg 29,328
KS0072 1997 ALLEN 66053 LIBRARY DISTRICT #1 MIAMI COUNTY LOUISBURG 30,176
KS0072 1998 LOUISBURG 66053 LIBRARY DISTRICT #1 MIAMI COUNTY LOUISBURG 41,719
KS0072 1999 LOUISBURG 66053 LOUISBURG/LIBRARY DIST #1 MIAMI CO 37,000
KS0072 2000 LOUISBURG 66053 LOUISBURG/LIBRARY DIST #1 MIAMI CO 40,267
KS0072 2001 LOUISBURG 66053 LOUISBURG/LIBRARY DIST #1 MIAMI CO 40,868
KS0072 2002 LOUISBURG 66053 LOUISBURG/LIBRARY DIST #1 MIAMI CO 40,578

An interesting anomaly. It appears that in 1994, we start getting the data from Louisburg (Miami County Library District #1) as reflected in LIBNAME and in BKVOLs but the city and Zipcode continue being from Allen. The Zipcode changes in 1996 to the Louisburg Zipcode and the CITY itself changes in 1998. All four of these libraries have a similar pattern. Looking at the data more deeply, phone numbers, street addresses, and such demographic information change later than the data as in the CITY and Zipdcodes. What follows is the solution adopted here using the example of Lyon County and the added variable newkey. Later evidence may suggest a better solution after PLDF3 is completely assembled:

Lyon County Library District #1
newkey FSCSKEY year CITY Zipcode LIBNAME (in raw data) BKVOL
KS0126 KS0072 1989 Allen 66833 Library District #1, Lyon County, Allen 7,875
KS0126 KS0072 1990 Allen 66833 Library District #1, Lyon County, Allen 8,163
KS0126 KS0072 1991 Allen 66833 Library District #1, Lyon County, Allen 8,535
KS0126 KS0072 1992 Allen 66833 Library District #1, Lyon County, Allen 8,745
KS0126 KS0072 1993 Allen 66833 Library District #1, Lyon County, Allen 8,927
KS0126 KS0126 1994 Troy 66087 Library District #1 Lyon County Allen 9,255
KS0126 KS0126 1995 Troy 66087 Library District #1 Lyon County Allen 8,927
KS0126 KS0126 1996 Troy 66883 Library District #1 Lyon County Allen 8,850
KS0126 KS0126 1997 TROY 66883 LIBRARY DISTRICT #1 LYON COUNTY ALLEN 8,889
KS0126 KS0126 1998 ALLEN 66883 LYON COUNTY LIBRARY DISTRICT #1 ALLEN 8,244
KS0126 KS0126 1999 ALLEN 66883 ALLEN/LYON COUNTY LIBRARY DIST 1 8,345
KS0126 KS0126 2000 ALLEN 66883 ALLEN/LYON COUNTY LIBRARY DIST 1 8,560
KS0126 KS0126 2001 ALLEN 66883 ALLEN/LYON COUNTY LIBRARY DIST 1 8,781
KS0126 KS0126 2002 ALLEN 66883 ALLEN/LYON COUNTY LIBRARY DIST 1 9,099

It appears from this and other evidence that the newkey of KS0126 has the Lyon County data together but we have the curious fact that the CITY Troy (which is where Doniphan County Library District #1 is) is in this series, much like the CITY of Allen for these years is with the data from Louisburg (Miami County Library District #1) as we saw above.

And here are the detailed chanages to the PLDF3 data for Kansas:


/* PRAIRIE VIEW/SUNSHINE CITY LIB */ if year = 2003 and FSCSKEY = 'KS0002' then LIBNAME = 'SUNSHINE CITY LIB'; /* AGRA/F LEE DOCTOR LIBRARY */ if year = 2003 and FSCSKEY = 'KS0014' then LIBNAME = 'F LEE DOCTOR LIBRARY'; /* WILSON/LANG MEMORIAL */ if year = 2003 and FSCSKEY = 'KS0031' then LIBNAME = 'LANG MEMORIAL'; /* ELLSWORTH/J H ROBBINS MEM LIB */ if year = 2003 and FSCSKEY = 'KS0043' then LIBNAME = 'J H ROBBINS MEM LIB'; /* BELOIT/PORT LIBRARY */ if year = 2003 and FSCSKEY = 'KS0048' then LIBNAME = 'PORT LIBRARY'; /* CONCORDIA/FRANK CARLSON LIBRARY */ if year = 2003 and FSCSKEY = 'KS0050' then LIBNAME = 'FRANK CARLSON LIBRARY'; /* LARNED/JORDAAN MEMORIAL LIBRARY */ if year = 2003 and FSCSKEY = 'KS0051' then LIBNAME = 'JORDAAN MEMORIAL LIBRARY'; /* WILSEY/ELM CREEK TOWNSHIP LIBRARY */ if year = 2003 and FSCSKEY = 'KS0058' then LIBNAME = 'ELM CREEK TOWNSHIP LIBRARY'; /* LOUISBURG/LIBRARY DIST #1 MIAMI CO */ if year = 1989 and FSCSKEY = 'KS0124' then newkey = 'KS0072'; if year = 1990 and FSCSKEY = 'KS0124' then newkey = 'KS0072'; if year = 1991 and FSCSKEY = 'KS0124' then newkey = 'KS0072'; if year = 1992 and FSCSKEY = 'KS0124' then newkey = 'KS0072'; if year = 1993 and FSCSKEY = 'KS0124' then newkey = 'KS0072'; if year = 2003 and FSCSKEY = 'KS0072' then LIBNAME = 'MIAMI COUNTY LIBRARY DISTRICT #1'; /* COTTONWOOD FALLS/BURNLEY MEMORIAL */ if year = 2003 and FSCSKEY = 'KS0073' then LIBNAME = 'BURNLEY MEMORIAL'; /* HARTFORD/ELMENDARO TOWNSHIP */ if year = 2003 and FSCSKEY = 'KS0077' then LIBNAME = 'ELMENDARO TOWNSHIP'; /* ST MARYS/POTTAWATOMIE WABAUNSEE RL */ if year = 2003 and FSCSKEY = 'KS0088' then LIBNAME = 'POTTAWATOMIE WABAUNSEE RL'; /* BURLINGAME, KANSA */ /* if year = 2002 and FSCSKEY = 'KS0103' then CITY = 'BURLINGAME'; */ /* BECK-BOOKMAN LIBRARY HOLTON */ if year = 1989 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1990 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1991 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1992 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1993 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1994 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1995 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1996 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; if year = 1997 and FSCSKEY = 'KS0118' then newkey = 'KS8002'; /* HIAWATHA/MORRILL PUBLIC LIBRARY */ if year = 2003 and FSCSKEY = 'KS0120' then LIBNAME = 'MORRILL PUBLIC LIBRARY'; /* PARKER/LINN COUNTY LIBRARY DIST #1 */ if year = 1989 and FSCSKEY = 'KS0258' then newkey = 'KS0124'; if year = 1990 and FSCSKEY = 'KS0258' then newkey = 'KS0124'; if year = 1991 and FSCSKEY = 'KS0258' then newkey = 'KS0124'; if year = 1992 and FSCSKEY = 'KS0258' then newkey = 'KS0124'; if year = 1993 and FSCSKEY = 'KS0258' then newkey = 'KS0124'; /* ALLEN/LYON COUNTY LIBRARY DIST 1 */ if year = 1989 and FSCSKEY = 'KS0072' then newkey = 'KS0126'; if year = 1990 and FSCSKEY = 'KS0072' then newkey = 'KS0126'; if year = 1991 and FSCSKEY = 'KS0072' then newkey = 'KS0126'; if year = 1992 and FSCSKEY = 'KS0072' then newkey = 'KS0126'; if year = 1993 and FSCSKEY = 'KS0072' then newkey = 'KS0126'; if year = 2003 and FSCSKEY = 'KS0126' then LIBNAME = 'LYON COUNTY LIBRARY DISTRICT #1'; /* GRINNELL/MOORE FAMILY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0140' then LIBNAME = 'MOORE FAMILY LIBRARY'; /* QUINTER/JAY JOHNSON PUBLIC LIBRARY */ if year = 2003 and FSCSKEY = 'KS0145' then LIBNAME = 'JAY JOHNSON PUBLIC LIBRARY'; /* HOXIE/SHERIDAN COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0151' then LIBNAME = 'SHERIDAN COUNTY LIBRARY'; /* HILL CITY/GRAHAM COUNTY PUBLIC LIB */ if year = 2003 and FSCSKEY = 'KS0153' then LIBNAME = 'GRAHAM COUNTY PUBLIC LIB'; /* COLBY/PIONEER MEMORIAL LIBRARY */ if year = 2003 and FSCSKEY = 'KS0156' then LIBNAME = 'PIONEER MEMORIAL LIBRARY'; /* ARGONIA/DIXON TOWNSHIP LIBRARY */ if year = 2003 and FSCSKEY = 'KS0177' then LIBNAME = 'DIXON TOWNSHIP LIBRARY'; /* STAFFORD/NORA E LARABEE MEM LIB */ if year = 2003 and FSCSKEY = 'KS0188' then LIBNAME = 'NORA E LARABEE MEM LIB'; /* SEDGWICK/LILLIAN TEAR LIBRARY */ /* if year = 2002 and FSCSKEY = 'KS0194' then CITY = 'SEDGWICK'; */ if year = 2003 and FSCSKEY = 'KS0194' then LIBNAME = 'LILLIAN TEAR LIBRARY'; /* ST. JOHN/IDA LONG GOODMAN MEM LIB */ /* if year = 2003 and FSCSKEY = 'KS0195' then LIBNAME = 'IDA LONG GOODMAN MEM LIB'; */ /* CITY OF GODDARD */ if year = 2003 and FSCSKEY = 'KS0201' then CITY = 'GODDARD'; /* MEDICINE LODGE/LINCOLN LIBRARY */ if year = 2003 and FSCSKEY = 'KS0206' then LIBNAME = 'LINCOLN LIBRARY'; /* GREENSBURG/KIOWA COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0212' then LIBNAME = 'KIOWA COUNTY LIBRARY'; /* EL DORADO / BRADFORD MEMORIAL LIBRARY */ /* if year = 2002 and FSCSKEY = 'KS0219' then LIBNAME = 'BRADFORD MEMORIAL LIBRARY'; */ /* MOUND CITY/LINN COUNTY DISTRICT #4 */ if year = 2003 and FSCSKEY = 'KS0246' then LIBNAME = 'LINN COUNTY LIBRARY DISTRICT #4'; /* TROY/LIBRARY DISTRICT #1 */ if year = 1989 and FSCSKEY = 'KS0126' then newkey = 'KS0258'; if year = 1990 and FSCSKEY = 'KS0126' then newkey = 'KS0258'; if year = 1991 and FSCSKEY = 'KS0126' then newkey = 'KS0258'; if year = 1992 and FSCSKEY = 'KS0126' then newkey = 'KS0258'; if year = 1993 and FSCSKEY = 'KS0126' then newkey = 'KS0258'; /* if year = 2002 and FSCSKEY = 'KS0258' then LIBNAME = 'DONIPHAN COUNTY LIBRARY DISTRICT #1'; */ /* THAYER FRIDAY READING CLUB CITY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0243' then LIBNAME = 'FRIDAY READING CLUB CITY LIBRARY'; /* NEODESHA/W.A. RANKIN MEMORIAL */ if year = 2003 and FSCSKEY = 'KS0268' then LIBNAME = 'W.A. RANKIN MEMORIAL'; /* BAXTER SPRINGS/JOHNSTON PUBLIC LIB */ if year = 2003 and FSCSKEY = 'KS0271' then LIBNAME = 'JOHNSTON PUBLIC LIB'; /* LEWIS/MEADOWLARK LIBRARY */ if year = 2003 and FSCSKEY = 'KS0290' then LIBNAME = 'MEADOWLARK LIBRARY'; /* SATANTA/DUDLEY TOWNSHIP PUB LIB */ /* if year = 2002 and FSCSKEY = 'KS0298' then LIBNAME = 'DUDLEY TOWNSHIP PUB LIB'; */ /* SYRACUSE/HAMILTON COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0300' then LIBNAME = 'HAMILTON COUNTY LIBRARY'; /* SUBLETTE/HASKELL TOWNSHIP LIBRARY */ /* if year = 2002 and FSCSKEY = 'KS0303' then LIBNAME = 'HASKELL TOWNSHIP LIBRARY'; */ /* JOHNSON/STANTON COUNTY PUBLIC LIB */ if year = 2003 and FSCSKEY = 'KS0307' then LIBNAME = 'STANTON COUNTY PUBLIC LIB'; /* DIGHTON/LANE COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0308' then LIBNAME = 'LANE COUNTY LIBRARY'; /* LEOTI/WICHITA COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0309' then LIBNAME = 'WICHITA COUNTY LIBRARY'; /* ELKHART/MORTON COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0310' then LIBNAME = 'MORTON COUNTY LIBRARY'; /* LAKIN/KEARNY COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0311' then CITY = 'LAKIN'; if year = 2003 and FSCSKEY = 'KS0311' then LIBNAME = 'KEARNY COUNTY LIBRARY'; /* HUGOTON/STEVENS COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0312' then LIBNAME = 'STEVENS COUNTY LIBRARY'; /* SCOTT CITY/SCOTT COUNTY LIBRARY */ /* if year = 2002 and FSCSKEY = 'KS0313' then LIBNAME = 'SCOTT COUNTY LIBRARY'; */ /* ULYSSES/GRANT COUNTY LIBRARY */ if year = 2003 and FSCSKEY = 'KS0314' then LIBNAME = 'GRANT COUNTY LIBRARY'; /* DUPS */ if year = 1991 and FSCSKEY = 'KS0323' then delete; if year = 1991 and FSCSKEY = 'KS0324' then delete; if year = 1991 and FSCSKEY = 'KS0325' then delete; if year = 1991 and FSCSKEY = 'KS0326' then delete; if year = 1991 and FSCSKEY = 'KS0327' then delete; if year = 1991 and FSCSKEY = 'KS0328' then delete; if year = 1991 and FSCSKEY = 'KS0329' then delete; if year = 1991 and FSCSKEY = 'KS0330' then delete; if year = 1991 and FSCSKEY = 'KS0331' then delete; if year = 1991 and FSCSKEY = 'KS0332' then delete; if year = 1991 and FSCSKEY = 'KS0333' then delete; if year = 1991 and FSCSKEY = 'KS0334' then delete; if year = 1991 and FSCSKEY = 'KS0335' then delete; if year = 1991 and FSCSKEY = 'KS0336' then delete; if year = 1991 and FSCSKEY = 'KS0337' then delete; if year = 1991 and FSCSKEY = 'KS0338' then delete; if year = 1991 and FSCSKEY = 'KS0339' then delete;

October 31, 2012

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