Schedule of FSCSKey Changes

Schedule of Changes to Arizona newkeys

It appears that in FY2003 that a number of consolidated libraries have been split up after data were reported in FY1991. By my count, we go from 35 libraries to 90.


/* SUN CITY WEST      */
if year = 1988 and FSCSKEY = 'AZ0037' then newkey = 'AZ0098';

/* YOUNGTOWN          */
if year = 1988 and FSCSKEY = 'AZ0041' then newkey = 'AZ0092';

/* HEBER              */
if year = 1988 and FSCSKEY = 'AZ0043' then newkey = 'AZ0093';

/* QUARTZSITE QUARTZITE */
if year = 1990 and FSCSKEY = 'AZ0091' then newkey = 'AZ0104';
if year = 1991 and FSCSKEY = 'AZ0091' then newkey = 'AZ0104';

/* PIMA               */
if year = 1989 and FSCSKEY = 'AZ0085' then newkey = 'AZ0106';
if year = 1990 and FSCSKEY = 'AZ0085' then newkey = 'AZ0106';

/* BENSON             */
if year = 1988 and FSCSKEY = 'AZ0010' then newkey = 'AZ0110';
if year = 1989 and FSCSKEY = 'AZ0010' then newkey = 'AZ0110';
if year = 1990 and FSCSKEY = 'AZ0010' then newkey = 'AZ0110';
if year = 1991 and FSCSKEY = 'AZ0010' then newkey = 'AZ0110';

/* COPPER QUEEN       */
if year = 1988 and FSCSKEY = 'AZ0011' then newkey = 'AZ0111';
if year = 1989 and FSCSKEY = 'AZ0011' then newkey = 'AZ0111';
if year = 1990 and FSCSKEY = 'AZ0011' then newkey = 'AZ0111';
if year = 1991 and FSCSKEY = 'AZ0011' then newkey = 'AZ0111';

/* DOUGLAS PUBLIC LIBRARY */
if year = 1988 and FSCSKEY = 'AZ0012' then newkey = 'AZ0112';
if year = 1989 and FSCSKEY = 'AZ0012' then newkey = 'AZ0112';
if year = 1990 and FSCSKEY = 'AZ0012' then newkey = 'AZ0112';
if year = 1991 and FSCSKEY = 'AZ0012' then newkey = 'AZ0112';

/* HUACHUCA CITY PUBLIC LIBRARY       */
if year = 1988 and FSCSKEY = 'AZ0013' then newkey = 'AZ0113';
if year = 1989 and FSCSKEY = 'AZ0013' then newkey = 'AZ0113';
if year = 1990 and FSCSKEY = 'AZ0013' then newkey = 'AZ0113';
if year = 1991 and FSCSKEY = 'AZ0013' then newkey = 'AZ0113';

/* SIERRA VISTA PUBLIC LIBRARY       */
if year = 1988 and FSCSKEY = 'AZ0014' then newkey = 'AZ0114';
if year = 1989 and FSCSKEY = 'AZ0014' then newkey = 'AZ0114';
if year = 1990 and FSCSKEY = 'AZ0014' then newkey = 'AZ0114';
if year = 1991 and FSCSKEY = 'AZ0014' then newkey = 'AZ0114';

/* TOMBSTONE CITY LIBRARY            */
if year = 1988 and FSCSKEY = 'AZ0015' then newkey = 'AZ0115';
if year = 1989 and FSCSKEY = 'AZ0015' then newkey = 'AZ0115';
if year = 1990 and FSCSKEY = 'AZ0015' then newkey = 'AZ0115';
if year = 1991 and FSCSKEY = 'AZ0015' then newkey = 'AZ0115';

/* ELSIE S. HOGAN COMMUNITY LIBRARY -- Willcox */
if year = 1988 and FSCSKEY = 'AZ0016' then newkey = 'AZ0116';
if year = 1989 and FSCSKEY = 'AZ0016' then newkey = 'AZ0116';
if year = 1990 and FSCSKEY = 'AZ0016' then newkey = 'AZ0116';
if year = 1991 and FSCSKEY = 'AZ0016' then newkey = 'AZ0116';

/* APACHE JUNCTION PUBLIC LIBRARY    */
if year = 1988 and FSCSKEY = 'AZ0051' then newkey = 'AZ0117';
if year = 1989 and FSCSKEY = 'AZ0051' then newkey = 'AZ0117';
if year = 1990 and FSCSKEY = 'AZ0051' then newkey = 'AZ0117';
if year = 1991 and FSCSKEY = 'AZ0051' then newkey = 'AZ0117';

/* CASA GRANDE PUBLIC LIBRARY        */
if year = 1988 and FSCSKEY = 'AZ0053' then newkey = 'AZ0118';
if year = 1989 and FSCSKEY = 'AZ0053' then newkey = 'AZ0118';
if year = 1990 and FSCSKEY = 'AZ0053' then newkey = 'AZ0118';
if year = 1991 and FSCSKEY = 'AZ0053' then newkey = 'AZ0118';

/* HAYDEN PUBLIC LIBRARY             */
if year = 1988 and FSCSKEY = 'AZ0019' then newkey = 'AZ0125';
if year = 1989 and FSCSKEY = 'AZ0019' then newkey = 'AZ0125';
if year = 1990 and FSCSKEY = 'AZ0019' then newkey = 'AZ0125';
if year = 1991 and FSCSKEY = 'AZ0019' then newkey = 'AZ0125';

/*=========================================================*/
/* GILA COUNTY LIBRARY DISTRICT */
/* See below. Gila County reports from Globe, 1994-2002    */
/* when  Gila County Library District last reports.        */
/* Miami Memorial Library and Globe PL begin reporting     */
/* again separately in FY 2003                             */
if year = 1989 and FSCSKEY = 'AZ0017' then newkey = 'AZ0102';
if year = 1990 and FSCSKEY = 'AZ0017' then newkey = 'AZ0102';

/* GLOBE PUBLIC LIBRARY                                    */
if year = 1988 and FSCSKEY = 'AZ0018' then newkey = 'AZ0124';
if year = 1989 and FSCSKEY = 'AZ0018' then newkey = 'AZ0124';
if year = 1990 and FSCSKEY = 'AZ0018' then newkey = 'AZ0124';
if year = 1991 and FSCSKEY = 'AZ0018' then newkey = 'AZ0124';

/* MIAMI MEMORIAL LIBRARY                                  */
/* From 1988-1991 it shares an address and phone number    */
/* Gila County Library District AZ0102                     */
if year = 1988 and FSCSKEY = 'AZ0017' then newkey = 'AZ0126';
if year = 1989 and FSCSKEY = 'AZ0083' then newkey = 'AZ0126';
if year = 1990 and FSCSKEY = 'AZ0083' then newkey = 'AZ0126';
if year = 1991 and FSCSKEY = 'AZ0083' then newkey = 'AZ0126';
/*=========================================================*/

/* PAYSON PUBLIC LIBRARY             */
if year = 1988 and FSCSKEY = 'AZ0020' then newkey = 'AZ0127';
if year = 1989 and FSCSKEY = 'AZ0020' then newkey = 'AZ0127';
if year = 1990 and FSCSKEY = 'AZ0020' then newkey = 'AZ0127';
if year = 1991 and FSCSKEY = 'AZ0020' then newkey = 'AZ0127';

/* ISABELLE HUNT MEMORIAL PUBLIC LIBRARY */
if year = 1988 and FSCSKEY = 'AZ0021' then newkey = 'AZ0128';
if year = 1989 and FSCSKEY = 'AZ0021' then newkey = 'AZ0128';
if year = 1990 and FSCSKEY = 'AZ0021' then newkey = 'AZ0128';
if year = 1991 and FSCSKEY = 'AZ0021' then newkey = 'AZ0128';

/* SAN CARLOS PUBLIC LIBRARY         */
if year = 1988 and FSCSKEY = 'AZ0022' then newkey = 'AZ0129';
if year = 1989 and FSCSKEY = 'AZ0022' then newkey = 'AZ0129';
if year = 1990 and FSCSKEY = 'AZ0022' then newkey = 'AZ0129';
if year = 1991 and FSCSKEY = 'AZ0022' then newkey = 'AZ0129';

/* TONTO BASIN PUBLIC LIBRARY        */
if year = 1988 and FSCSKEY = 'AZ0023' then newkey = 'AZ0130';
if year = 1989 and FSCSKEY = 'AZ0023' then newkey = 'AZ0130';
if year = 1990 and FSCSKEY = 'AZ0023' then newkey = 'AZ0130';
if year = 1991 and FSCSKEY = 'AZ0023' then newkey = 'AZ0130';

/* YOUNG PUBLIC LIBRARY              */
if year = 1988 and FSCSKEY = 'AZ0024' then newkey = 'AZ0131';
if year = 1989 and FSCSKEY = 'AZ0024' then newkey = 'AZ0131';
if year = 1990 and FSCSKEY = 'AZ0024' then newkey = 'AZ0131';
if year = 1991 and FSCSKEY = 'AZ0024' then newkey = 'AZ0131';

/* ARIZONA CITY COMMUNITY LIBRARY    */
if year = 1988 and FSCSKEY = 'AZ0052' then newkey = 'AZ0132';
if year = 1989 and FSCSKEY = 'AZ0052' then newkey = 'AZ0132';
if year = 1990 and FSCSKEY = 'AZ0052' then newkey = 'AZ0132';
if year = 1991 and FSCSKEY = 'AZ0052' then newkey = 'AZ0132';

/* COOLIDGE PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0054' then newkey = 'AZ0133';
if year = 1989 and FSCSKEY = 'AZ0054' then newkey = 'AZ0133';
if year = 1990 and FSCSKEY = 'AZ0054' then newkey = 'AZ0133';
if year = 1991 and FSCSKEY = 'AZ0054' then newkey = 'AZ0133';

/* ELOY PUBLIC LIBRARY               */
if year = 1988 and FSCSKEY = 'AZ0055' then newkey = 'AZ0134';
if year = 1989 and FSCSKEY = 'AZ0055' then newkey = 'AZ0134';
if year = 1990 and FSCSKEY = 'AZ0055' then newkey = 'AZ0134';

/* FLORENCE COMMUNITY LIBRARY        */
/* Florence PL apparently was absorbed into the Pinal      */
/* County Library District in 1992 and stopped reporting.  */
/* Pinal County Library District did not report in FY2003  */
/* and now Florence reports separately again.              */
if year = 1988 and FSCSKEY = 'AZ0056' then newkey = 'AZ0135';
if year = 1989 and FSCSKEY = 'AZ0056' then newkey = 'AZ0135';
if year = 1990 and FSCSKEY = 'AZ0056' then newkey = 'AZ0135';
if year = 1991 and FSCSKEY = 'AZ0056' then newkey = 'AZ0135';

/* ARTHUR E. POMEROY PUBLIC LIBRARY --Kearny   */
if year = 1988 and FSCSKEY = 'AZ0057' then newkey = 'AZ0136';
if year = 1989 and FSCSKEY = 'AZ0057' then newkey = 'AZ0136';
if year = 1990 and FSCSKEY = 'AZ0057' then newkey = 'AZ0136';
if year = 1991 and FSCSKEY = 'AZ0057' then newkey = 'AZ0136';

/* MAMMOTH PUBLIC LIBRARY            */
if year = 1988 and FSCSKEY = 'AZ0058' then newkey = 'AZ0137';
if year = 1989 and FSCSKEY = 'AZ0058' then newkey = 'AZ0137';
if year = 1990 and FSCSKEY = 'AZ0058' then newkey = 'AZ0137';
if year = 1991 and FSCSKEY = 'AZ0058' then newkey = 'AZ0137';

/* MARICOPA COMMUNITY LIBRARY        */
if year = 1988 and FSCSKEY = 'AZ0059' then newkey = 'AZ0138';
if year = 1990 and FSCSKEY = 'AZ0094' then newkey = 'AZ0138';
if year = 1991 and FSCSKEY = 'AZ0094' then newkey = 'AZ0138';

/* ORACLE                            */
if year = 1988 and FSCSKEY = 'AZ0060' then newkey = 'AZ0139';
if year = 1990 and FSCSKEY = 'AZ0095' then newkey = 'AZ0139';
if year = 1991 and FSCSKEY = 'AZ0095' then newkey = 'AZ0139';

/* SAN MANUEL PUBLIC LIBRARY         */
if year = 1988 and FSCSKEY = 'AZ0061' then newkey = 'AZ0140';
if year = 1989 and FSCSKEY = 'AZ0061' then newkey = 'AZ0140';
if year = 1990 and FSCSKEY = 'AZ0061' then newkey = 'AZ0140';
if year = 1991 and FSCSKEY = 'AZ0061' then newkey = 'AZ0140';

/* SUPERIOR PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0063' then newkey = 'AZ0141';
if year = 1989 and FSCSKEY = 'AZ0063' then newkey = 'AZ0141';
if year = 1990 and FSCSKEY = 'AZ0063' then newkey = 'AZ0141';
if year = 1991 and FSCSKEY = 'AZ0063' then newkey = 'AZ0141';

/* ASH FORK PUBLIC LIBRARY           */
if year = 1990 and FSCSKEY = 'AZ0096' then newkey = 'AZ0142';
if year = 1991 and FSCSKEY = 'AZ0096' then newkey = 'AZ0142';

/* BAGDAD PUBLIC LIBRARY             */
if year = 1988 and FSCSKEY = 'AZ0068' then newkey = 'AZ0143';
if year = 1989 and FSCSKEY = 'AZ0068' then newkey = 'AZ0143';
if year = 1990 and FSCSKEY = 'AZ0068' then newkey = 'AZ0143';
if year = 1991 and FSCSKEY = 'AZ0068' then newkey = 'AZ0143';

/* BLACK CANYON CITY COMMUNITY LIBRARY */
if year = 1988 and FSCSKEY = 'AZ0069' then newkey = 'AZ0144';
if year = 1989 and FSCSKEY = 'AZ0069' then newkey = 'AZ0144';
if year = 1990 and FSCSKEY = 'AZ0069' then newkey = 'AZ0144';
if year = 1991 and FSCSKEY = 'AZ0069' then newkey = 'AZ0144';

/* CAMP VERDE COMMUNITY LIBRARY      */
if year = 1988 and FSCSKEY = 'AZ0070' then newkey = 'AZ0145';
if year = 1989 and FSCSKEY = 'AZ0070' then newkey = 'AZ0145';
if year = 1990 and FSCSKEY = 'AZ0070' then newkey = 'AZ0145';
if year = 1991 and FSCSKEY = 'AZ0070' then newkey = 'AZ0145';

/* CHINO VALLEY PUBLIC LIBRARY       */
if year = 1988 and FSCSKEY = 'AZ0071' then newkey = 'AZ0146';
if year = 1989 and FSCSKEY = 'AZ0071' then newkey = 'AZ0146';
if year = 1990 and FSCSKEY = 'AZ0071' then newkey = 'AZ0146';
if year = 1991 and FSCSKEY = 'AZ0071' then newkey = 'AZ0146';

/* CLARK MEMORIAL LIBRARY            */
if year = 1988 and FSCSKEY = 'AZ0072' then newkey = 'AZ0147';
if year = 1989 and FSCSKEY = 'AZ0072' then newkey = 'AZ0147';
if year = 1990 and FSCSKEY = 'AZ0072' then newkey = 'AZ0147';
if year = 1991 and FSCSKEY = 'AZ0072' then newkey = 'AZ0147';

/* CONGRESS PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0073' then newkey = 'AZ0148';
if year = 1989 and FSCSKEY = 'AZ0073' then newkey = 'AZ0148';
if year = 1990 and FSCSKEY = 'AZ0073' then newkey = 'AZ0148';
if year = 1991 and FSCSKEY = 'AZ0073' then newkey = 'AZ0148';

/* CORDES LAKES PUBLIC LIBRARY       */
if year = 1988 and FSCSKEY = 'AZ0074' then newkey = 'AZ0149';
if year = 1989 and FSCSKEY = 'AZ0074' then newkey = 'AZ0149';
if year = 1990 and FSCSKEY = 'AZ0074' then newkey = 'AZ0149';
if year = 1991 and FSCSKEY = 'AZ0074' then newkey = 'AZ0149';

/* COTTONWOOD PUBLIC LIBRARY         */
if year = 1988 and FSCSKEY = 'AZ0075' then newkey = 'AZ0150';
if year = 1989 and FSCSKEY = 'AZ0075' then newkey = 'AZ0150';
if year = 1990 and FSCSKEY = 'AZ0075' then newkey = 'AZ0150';
if year = 1991 and FSCSKEY = 'AZ0075' then newkey = 'AZ0150';

/* CROWN KING PUBLIC LIBRARY         */
if year = 1988 and FSCSKEY = 'AZ0076' then newkey = 'AZ0151';
if year = 1989 and FSCSKEY = 'AZ0076' then newkey = 'AZ0151';
if year = 1990 and FSCSKEY = 'AZ0076' then newkey = 'AZ0151';
if year = 1991 and FSCSKEY = 'AZ0076' then newkey = 'AZ0151';

/* JEROME PUBLIC LIBRARY             */
if year = 1988 and FSCSKEY = 'AZ0077' then newkey = 'AZ0152';
if year = 1989 and FSCSKEY = 'AZ0077' then newkey = 'AZ0152';
if year = 1990 and FSCSKEY = 'AZ0077' then newkey = 'AZ0152';
if year = 1991 and FSCSKEY = 'AZ0077' then newkey = 'AZ0152';

/* MAYER PUBLIC LIBRARY              */
if year = 1988 and FSCSKEY = 'AZ0078' then newkey = 'AZ0153';
if year = 1989 and FSCSKEY = 'AZ0078' then newkey = 'AZ0153';
if year = 1990 and FSCSKEY = 'AZ0078' then newkey = 'AZ0153';
if year = 1991 and FSCSKEY = 'AZ0078' then newkey = 'AZ0153';

/* PRESCOTT VALLEY PUBLIC LIBRARY    */
if year = 1988 and FSCSKEY = 'AZ0080' then newkey = 'AZ0154';
if year = 1989 and FSCSKEY = 'AZ0080' then newkey = 'AZ0154';
if year = 1990 and FSCSKEY = 'AZ0080' then newkey = 'AZ0154';
if year = 1991 and FSCSKEY = 'AZ0080' then newkey = 'AZ0154';

/* SEDONA PUBLIC LIBRARY             */
if year = 1988 and FSCSKEY = 'AZ0006' then newkey = 'AZ0155';
if year = 1989 and FSCSKEY = 'AZ0006' then newkey = 'AZ0155';
if year = 1990 and FSCSKEY = 'AZ0006' then newkey = 'AZ0155';
if year = 1991 and FSCSKEY = 'AZ0006' then newkey = 'AZ0155';

/* SELIGMAN PUBLIC LIBRARY           */
if year = 1990 and FSCSKEY = 'AZ0097' then newkey = 'AZ0156';
if year = 1991 and FSCSKEY = 'AZ0097' then newkey = 'AZ0156';

/* PRESCOTT PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0079' then newkey = 'AZ0158';
if year = 1989 and FSCSKEY = 'AZ0079' then newkey = 'AZ0158';
if year = 1990 and FSCSKEY = 'AZ0079' then newkey = 'AZ0158';
if year = 1991 and FSCSKEY = 'AZ0079' then newkey = 'AZ0158';

/* YARNELL PUBLIC LIBRARY            */
if year = 1988 and FSCSKEY = 'AZ0081' then newkey = 'AZ0159';
if year = 1989 and FSCSKEY = 'AZ0081' then newkey = 'AZ0159';
if year = 1990 and FSCSKEY = 'AZ0081' then newkey = 'AZ0159';
if year = 1991 and FSCSKEY = 'AZ0081' then newkey = 'AZ0159';

/* HOLBROOK PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1989 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1990 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1991 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1992 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1993 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1994 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1995 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1996 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1997 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1998 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 1999 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';
if year = 2000 and FSCSKEY = 'AZ0044' then newkey = 'AZ0160';

/* LARSON MEMORIAL PUBLIC LIBRARY    */
if year = 1988 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1989 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1990 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1991 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1992 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1993 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1994 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1995 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1996 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1997 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1998 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 1999 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';
if year = 2000 and FSCSKEY = 'AZ0045' then newkey = 'AZ0161';

/* SHOW LOW PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1989 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1990 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1991 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1992 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1993 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1994 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1995 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1996 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1997 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1998 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 1999 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';
if year = 2000 and FSCSKEY = 'AZ0046' then newkey = 'AZ0162';

/* SNOWFLAKE-TAYLOR PUBLIC LIBRARY   */
if year = 1988 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1989 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1990 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1991 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1992 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1993 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1994 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1995 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1996 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1997 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1998 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 1999 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';
if year = 2000 and FSCSKEY = 'AZ0047' then newkey = 'AZ0163';

/* WINSLOW PL (ROXANNE WHIPPLE MEMORIAL LIBRARY) */
if year = 1988 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1989 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1990 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1991 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1992 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1993 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1994 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1995 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1996 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1997 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1998 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 1999 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';
if year = 2000 and FSCSKEY = 'AZ0049' then newkey = 'AZ0164';

/* FREDONIA PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0003' then newkey = 'AZ0165';
if year = 1989 and FSCSKEY = 'AZ0003' then newkey = 'AZ0165';
if year = 1990 and FSCSKEY = 'AZ0003' then newkey = 'AZ0165';
if year = 1991 and FSCSKEY = 'AZ0003' then newkey = 'AZ0165';

/* GRAND CANYON COMMUNITY LIBRARY    */
if year = 1988 and FSCSKEY = 'AZ0004' then newkey = 'AZ0166';
if year = 1989 and FSCSKEY = 'AZ0004' then newkey = 'AZ0166';
if year = 1990 and FSCSKEY = 'AZ0004' then newkey = 'AZ0166';
if year = 1991 and FSCSKEY = 'AZ0004' then newkey = 'AZ0166';

/* PAGE PUBLIC LIBRARY               */
if year = 1988 and FSCSKEY = 'AZ0005' then newkey = 'AZ0167';
if year = 1989 and FSCSKEY = 'AZ0005' then newkey = 'AZ0167';
if year = 1990 and FSCSKEY = 'AZ0005' then newkey = 'AZ0167';
if year = 1991 and FSCSKEY = 'AZ0005' then newkey = 'AZ0167';

/* WILLIAMS PUBLIC LIBRARY           */
if year = 1988 and FSCSKEY = 'AZ0008' then newkey = 'AZ0168';
if year = 1989 and FSCSKEY = 'AZ0008' then newkey = 'AZ0168';
if year = 1990 and FSCSKEY = 'AZ0008' then newkey = 'AZ0168';
if year = 1991 and FSCSKEY = 'AZ0008' then newkey = 'AZ0168';    

/*-------------------2010----------------------------------------------------*/
/* Hopi Public Library                                                       */
if year = 2001 and FSCSKEY = 'AZ0108' then newkey = 'AZ0181';
if year = 2002 and FSCSKEY = 'AZ0108' then newkey = 'AZ0181';
if year = 2003 and FSCSKEY = 'AZ0108' then newkey = 'AZ0181';
if year = 2004 and FSCSKEY = 'AZ0108' then newkey = 'AZ0181';
if year = 2004 and FSCSKEY = 'AZ0108' then newkey = 'AZ0181';

/* Gila Bend Public Library AZ0087 reporting FY 1989 - FY 1991               */
/* San Lucy Public Library, Gila Bend, AZ0183 reporting FY 2010              */
/* I think the first one closed and the new one is new and different library */
/*-------------------2010----------------------------------------------------*/
Schedule of Changes to Arizona newkeys

It appears that in FY2003 that a number of consolidated libraries have been split up after data were reported in FY1991. By my count, we go from 35 libraries to 90.

December 16, 2022
