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:
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.
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:
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 ChangesBack to PLDF3 main page
Back to LDA main page