Schedule of Changes to Idaho newkeys

In compiling the FY 2009 data, I noticed what appeared to be three libraries with their data intertwined. Thanks to a clarifying email from the library, I have the solution. The Fremont spreadsheet (Fremont.ods, Fremont.xls provides the detail.

The first "library" was Fremont County District in Ashton, Idaho. It reported from 1987 through 1989 in two FSCSKEYs: ID0108 and ID0096. The examination of the data led to looking in more detail at the numbers reported in these three observations and they were almost completely empty of data. However, there was Ashton Public Library which reported from 1987 through 2002. The complete entries for those years were in newkey ID0004. I therefore deleted the three stub entries because those in ID0004 had data and are pretty clearly for the same libraries.

Meanwhile, a new library started reporting in 1999 Fremont County District [Island Park] in Macks Inn, Idaho. It reported from 1999 through 2002. This library was classed by NCES as a different library from Ashton Public Library / Fremont District—as it was known from 1998 through 2002. In 2003, reporting came from the Fremont District Library and NCES concluded that this was the same library as Fremont District [Island Park] and grouped them all in FSCSKEY ID0123. I don't believe that assignment to be correct. What happened was that in 2003, Fremont District Library was formed and merged the two libraries. PLDF3, then, has three libraries: the two in Ashton and Macks Inn through 2002, and the Fremont District Library with the then two branches—and now three with the addition of the St. Anthony Branch from 2003 forward. The Ashton library is now in newkey ID0004. The Island Park library is now in newkey ID9976, and the Fremont District Library is in ID0123. The changes are at the bottom of this copy of the code which runs on the Idaho data.

/* OAKLEY               */
if year = 1987 and FSCSKEY = 'ID0001' then newkey = 'ID0073';

/* LEWISTON             */
if year = 1987 and FSCSKEY = 'ID0002' then newkey = 'ID0051';

/* AMERICAN FALLS       */
if year = 1987 and FSCSKEY = 'ID0062' then newkey = 'ID0002';

/* WILDER               */
if year = 1987 and FSCSKEY = 'ID0003' then newkey = 'ID0110';

/* ARCO                 */
if year = 1987 and FSCSKEY = 'ID0067' then newkey = 'ID0003';

/* VICTOR               */
if year = 1987 and FSCSKEY = 'ID0004' then newkey = 'ID0106';

/* KUNA                 */
if year = 1987 and FSCSKEY = 'ID0005' then newkey = 'ID0050';

/* BOISE PUBLIC         */
if year = 1987 and FSCSKEY = 'ID0057' then newkey = 'ID0005';

/* IDAHO FALLS PL       */
if year = 1987 and FSCSKEY = 'ID0006' then newkey = 'ID0046';

/* BOISE (ADA COUNTY DISTRICT) */
if year = 1987 and FSCSKEY = 'ID0098' then newkey = 'ID0006';

/* KELLOGG              */
if year = 1987 and FSCSKEY = 'ID0007' then newkey = 'ID0111';

/* BELLEVUE             */
if year = 1987 and FSCSKEY = 'ID0102' then newkey = 'ID0007';

/* OSBURN               */
if year = 1987 and FSCSKEY = 'ID0008' then newkey = 'ID0072';

/* BLACKFOOT PL (BLACKFOOT RURAL/LUCY BOYLE) */
if year = 1987 and FSCSKEY = 'ID0037' then newkey = 'ID0008';

/* RICHFIELD            */
if year = 1987 and FSCSKEY = 'ID0009' then newkey = 'ID0088';

/* BLACKFOOT (SNAKE RIVER) */
if year = 1987 and FSCSKEY = 'ID0074' then newkey = 'ID0009';

/* ST. MARIES (BENEWAH COUNTY DISTRICT) */
if year = 1987 and FSCSKEY = 'ID0010' then newkey = 'ID0102';

/* BONNERS FERRY        */
if year = 1987 and FSCSKEY = 'ID0064' then newkey = 'ID0010';

/* POCATELLO            */
if year = 1987 and FSCSKEY = 'ID0011' then newkey = 'ID0080';

/* BRUNEAU              */
if year = 1987 and FSCSKEY = 'ID0063' then newkey = 'ID0011';

/* NEW PLYMOUTH         */
if year = 1987 and FSCSKEY = 'ID0012' then newkey = 'ID0071';

/* BUHL                 */
if year = 1987 and FSCSKEY = 'ID0085' then newkey = 'ID0012';

/* CHUBBUCK             */
if year = 1987 and FSCSKEY = 'ID0013' then newkey = 'ID0019';

/* BURLEY               */
if year = 1987 and FSCSKEY = 'ID0029' then newkey = 'ID0013';

/* TWIN FALLS           */
if year = 1987 and FSCSKEY = 'ID0014' then newkey = 'ID0105';

/* COEUR D'ALENE        */
if year = 1987 and FSCSKEY = 'ID0026' then newkey = 'ID0014';

/* MULLAN               */
if year = 1987 and FSCSKEY = 'ID0015' then newkey = 'ID0068';

/* CALDWELL             */
if year = 1987 and FSCSKEY = 'ID0040' then newkey = 'ID0015';

/* OROFINO              */
if year = 1987 and FSCSKEY = 'ID0016' then newkey = 'ID0075';

/* CAREY                */
if year = 1987 and FSCSKEY = 'ID0077' then newkey = 'ID0016';

/* SODA SPRINGS         */
if year = 1987 and FSCSKEY = 'ID0017' then newkey = 'ID0103';

/* HAYDEN LAKE          */
if year = 1987 and FSCSKEY = 'ID0023' then newkey = 'ID0120';
if year = 1988 and FSCSKEY = 'ID0017' then newkey = 'ID0120';
if year = 1989 and FSCSKEY = 'ID0017' then newkey = 'ID0120';
if year = 1990 and FSCSKEY = 'ID0017' then newkey = 'ID0120';
if year = 1991 and FSCSKEY = 'ID0017' then newkey = 'ID0120';
if year = 1992 and FSCSKEY = 'ID0017' then newkey = 'ID0120';
if year = 1993 and FSCSKEY = 'ID0017' then newkey = 'ID0120';
if year = 1994 and FSCSKEY = 'ID0017' then newkey = 'ID0120';

/* LEADORE              */
if year = 1987 and FSCSKEY = 'ID0018' then newkey = 'ID0052';

/* CHALLIS              */
if year = 1987 and FSCSKEY = 'ID0022' then newkey = 'ID0018';

/* OLA                  */
if year = 1987 and FSCSKEY = 'ID0019' then newkey = 'ID0074';

/* MOUNTAIN HOME (PRARIE DISTRICT) */
if year = 1987 and FSCSKEY = 'ID0020' then newkey = 'ID0064';

/* CLARKIA              */
if year = 1987 and FSCSKEY = 'ID0066' then newkey = 'ID0020';

/* WEIPPE               */
if year = 1987 and FSCSKEY = 'ID0021' then newkey = 'ID0076';

/* CAMBRIDGE            */
if year = 1987 and FSCSKEY = 'ID0034' then newkey = 'ID0021';

/* COUNCIL              */
if year = 1987 and FSCSKEY = 'ID0042' then newkey = 'ID0022';

/* CASCADE              */
if year = 1987 and FSCSKEY = 'ID0030' then newkey = 'ID0023';

/* RIGBY                */
if year = 1987 and FSCSKEY = 'ID0024' then newkey = 'ID0090';

/* DOWNEY               */
if year = 1987 and FSCSKEY = 'ID0054' then newkey = 'ID0024';

/* PAYETTE              */
if year = 1987 and FSCSKEY = 'ID0025' then newkey = 'ID0078';

/* DUBOIS               */
if year = 1987 and FSCSKEY = 'ID0101' then newkey = 'ID0025';

/* EAGLE                */
if year = 1987 and FSCSKEY = 'ID0081' then newkey = 'ID0026';

/* HAGERMAN             */
if year = 1987 and FSCSKEY = 'ID0027' then newkey = 'ID0040';

/* EMMETT               */
if year = 1987 and FSCSKEY = 'ID0055' then newkey = 'ID0027';

/* HARRISON             */
if year = 1987 and FSCSKEY = 'ID0028' then newkey = 'ID0044';

/* ELK RIVER            */
if year = 1987 and FSCSKEY = 'ID0075' then newkey = 'ID0028';

/* FAIRFIELD            */
if year = 1987 and FSCSKEY = 'ID0051' then newkey = 'ID0029';

/* FILER                */
if year = 1987 and FSCSKEY = 'ID0086' then newkey = 'ID0030';

/* GRANGEVILLE          */
if year = 1987 and FSCSKEY = 'ID0031' then newkey = 'ID0035';

/* [PRESTON] (FRANKLIN COUNTY) */
if year = 1987 and FSCSKEY = 'ID0038' then newkey = 'ID0031';

/* GRAND VIEW           */
if year = 1987 and FSCSKEY = 'ID0072' then newkey = 'ID0038';

/* PIERCE               */
if year = 1987 and FSCSKEY = 'ID0032' then newkey = 'ID0081';

/* GARDEN VALLEY        */
if year = 1987 and FSCSKEY = 'ID0096' then newkey = 'ID0032';

/* SANDPOINT            */
if year = 1987 and FSCSKEY = 'ID0033' then newkey = 'ID0098';

/* GARDEN CITY          */
if year = 1987 and FSCSKEY = 'ID0043' then newkey = 'ID0033';

/* GLENNS FERRY         */
if year = 1987 and FSCSKEY = 'ID0104' then newkey = 'ID0034';

/* NAMPA                */
if year = 1987 and FSCSKEY = 'ID0035' then newkey = 'ID0069';

/* GRACE                */
if year = 1987 and FSCSKEY = 'ID0071' then newkey = 'ID0037';

/* MARSING              */
if year = 1987 and FSCSKEY = 'ID0039' then newkey = 'ID0058';

/* HORSESHOE BEND       */
if year = 1987 and FSCSKEY = 'ID0091' then newkey = 'ID0039';

/* REXBURG              */
if year = 1987 and FSCSKEY = 'ID0041' then newkey = 'ID0086';

/* HAILEY               */
if year = 1987 and FSCSKEY = 'ID0095' then newkey = 'ID0041';

/* HOMEDALE             */
if year = 1987 and FSCSKEY = 'ID0087' then newkey = 'ID0042';

/* HANSEN               */
if year = 1987 and FSCSKEY = 'ID0082' then newkey = 'ID0043';

/* MERIDIAN             */
if year = 1987 and FSCSKEY = 'ID0044' then newkey = 'ID0061';

/* SUGAR CITY           */
if year = 1987 and FSCSKEY = 'ID0045' then newkey = 'ID0099';

/* IDAHO CITY           */
if year = 1987 and FSCSKEY = 'ID0056' then newkey = 'ID0045';

/* MACKAY               */
if year = 1987 and FSCSKEY = 'ID0046' then newkey = 'ID0057';

/* PINEHURST            */
if year = 1987 and FSCSKEY = 'ID0047' then newkey = 'ID0082';

/* [IDAHO FALLS] (BONNEVILLE COUNTY) */
if year = 1987 and FSCSKEY = 'ID0083' then newkey = 'ID0047';

/* PLUMMER              */
if year = 1987 and FSCSKEY = 'ID0048' then newkey = 'ID0083';

/* JEROME               */
if year = 1987 and FSCSKEY = 'ID0084' then newkey = 'ID0048';

/* PRESTON (CARNEGIE)   */
if year = 1987 and FSCSKEY = 'ID0049' then newkey = 'ID0085';

/* KIMBERLEY            */
if year = 1987 and FSCSKEY = 'ID0073' then newkey = 'ID0049';

/* ROCKLAND             */
if year = 1987 and FSCSKEY = 'ID0050' then newkey = 'ID0092';

/* MENAN                */
if year = 1987 and FSCSKEY = 'ID0052' then newkey = 'ID0062';

/* [ST. MARIES]         */
if year = 1987 and FSCSKEY = 'ID0053' then newkey = 'ID0101';

/* LEWISVILLE           */
if year = 1987 and FSCSKEY = 'ID0099' then newkey = 'ID0053';

/* KAMIAH               */
if year = 1987 and FSCSKEY = 'ID0078' then newkey = 'ID0054';

/* LAPWAI               */
if year = 1987 and FSCSKEY = 'ID0088' then newkey = 'ID0055';

/* MALAD                */
if year = 1987 and FSCSKEY = 'ID0093' then newkey = 'ID0056';

/* SHOSHONE             */
if year = 1987 and FSCSKEY = 'ID0058' then newkey = 'ID0100';

/* PARMA                */
if year = 1987 and FSCSKEY = 'ID0059' then newkey = 'ID0077';

/* MCCALL               */
if year = 1987 and FSCSKEY = 'ID0079' then newkey = 'ID0059';

/* POST FALLS           */
if year = 1987 and FSCSKEY = 'ID0060' then newkey = 'ID0079';

/* MOSCOW               */
if year = 1987 and FSCSKEY = 'ID0065' then newkey = 'ID0060';

/* RUPERT               */
if year = 1987 and FSCSKEY = 'ID0061' then newkey = 'ID0093';

/* MOUNTAIN HOME PUBLIC */
if year = 1987 and FSCSKEY = 'ID0090' then newkey = 'ID0063';

/* MIDDLETON            */
if year = 1987 and FSCSKEY = 'ID0094' then newkey = 'ID0065';

/* MIDVALE              */
if year = 1987 and FSCSKEY = 'ID0080' then newkey = 'ID0066';

/* MONTPELIER           */
if year = 1987 and FSCSKEY = 'ID0069' then newkey = 'ID0067';

/* SALMON               */
if year = 1987 and FSCSKEY = 'ID0068' then newkey = 'ID0097';

/* RIRIE                */
if year = 1987 and FSCSKEY = 'ID0070' then newkey = 'ID0089';

/* NOTUS                */
if year = 1987 and FSCSKEY = 'ID0100' then newkey = 'ID0070';

/* RIGGINS              */
if year = 1987 and FSCSKEY = 'ID0076' then newkey = 'ID0087';

/* PRIEST RIVER         */
if year = 1987 and FSCSKEY = 'ID0109' then newkey = 'ID0084';

/* WALLACE              */
if year = 1987 and FSCSKEY = 'ID0089' then newkey = 'ID0107';

/* WEISER               */
if year = 1987 and FSCSKEY = 'ID0092' then newkey = 'ID0108';

/* SHELLEY              */
if year = 1987 and FSCSKEY = 'ID0105' then newkey = 'ID0094';

/* ST ANTHONY           */
if year = 1987 and FSCSKEY = 'ID0106' then newkey = 'ID0095';

/* GIBBONSVILLE         */
if year = 1987 and FSCSKEY = 'ID0103' then newkey = 'ID9975';

/* WENDELL              */
if year = 1987 and FSCSKEY = 'ID0107' then newkey = 'ID0109';

/*---------2009---------*/
/* FREMONT COUNTY DISTRICT [stub?] */
if year = 1987 and FSCSKEY = 'ID0108' then delete;
if year = 1988 and FSCSKEY = 'ID0096' then delete;
if year = 1989 and FSCSKEY = 'ID0096' then delete;

/* ASHTON/FREMONT DISTRICT */
if year = 1987 and FSCSKEY = 'ID0097' then newkey = 'ID0004';

/* MACKS INN / ISLAND PARK */
if year = 1999 and FSCSKEY = 'ID0123' then newkey = 'ID9976';
if year = 2000 and FSCSKEY = 'ID0123' then newkey = 'ID9976';
if year = 2001 and FSCSKEY = 'ID0123' then newkey = 'ID9976';
if year = 2002 and FSCSKEY = 'ID0123' then newkey = 'ID9976';     

December 16, 2022