Schedule of Changes to Connecticut newkeys
173 of the 190 records for the first year of these data (1988) are dummy records with little, if any, data in them. They do have information on addresses, phone numbers, and population served information unlike the dummy records in Kansas in 1991 which have no information at all in them. Also, the values for the variables are set at "missing" rather than 0 as in the Kansas records.
/* PLAINVILLE */
if year = 1988 and FSCSKEY = 'CT0001' then newkey = 'CT0124';
/* ANDOVER */
if year = 1988 and FSCSKEY = 'CT0002' then newkey = 'CT0001';
/* ANSONIA */
if year = 1988 and FSCSKEY = 'CT0003' then newkey = 'CT0002';
/* ASHFORD */
if year = 1988 and FSCSKEY = 'CT0004' then newkey = 'CT0003';
/* AVON */
if year = 1988 and FSCSKEY = 'CT0005' then newkey = 'CT0004';
/* BEACON FALLS */
if year = 1988 and FSCSKEY = 'CT0006' then newkey = 'CT0005';
/* BERLIN (EAST BERLIN) */
if year = 1988 and FSCSKEY = 'CT0007' then newkey = 'CT0006';
/* BERLIN (PECK MEMORIAL) */
if year = 1988 and FSCSKEY = 'CT0008' then newkey = 'CT0007';
/* BERLIN (FREE LIBRARY) */
if year = 1988 and FSCSKEY = 'CT0009' then newkey = 'CT0008';
/* BETHANY */
if year = 1988 and FSCSKEY = 'CT0010' then newkey = 'CT0009';
/* BETHEL */
if year = 1988 and FSCSKEY = 'CT0011' then newkey = 'CT0010';
/* BETHLEHEM */
if year = 1988 and FSCSKEY = 'CT0012' then newkey = 'CT0011';
/* BLOOMFIELD */
if year = 1988 and FSCSKEY = 'CT0013' then newkey = 'CT0012';
/* BOLTON */
if year = 1988 and FSCSKEY = 'CT0014' then newkey = 'CT0013';
/* BRANFORD (JAMES BLACKSTONE) */
if year = 1988 and FSCSKEY = 'CT0015' then newkey = 'CT0014';
/* BRANFORD (WILLOUGHBY WALLACE) */
if year = 1988 and FSCSKEY = 'CT0016' then newkey = 'CT0015';
/* BRIDGEPORT */
if year = 1988 and FSCSKEY = 'CT0017' then newkey = 'CT0016';
/* BRIDGEWATER */
if year = 1988 and FSCSKEY = 'CT0018' then newkey = 'CT0017';
/* BRISTOL */
if year = 1988 and FSCSKEY = 'CT0019' then newkey = 'CT0018';
/* BROOKFIELD */
if year = 1988 and FSCSKEY = 'CT0020' then newkey = 'CT0019';
/* BROOKLYN */
if year = 1988 and FSCSKEY = 'CT0021' then newkey = 'CT0020';
/* BURLINGTON */
if year = 1988 and FSCSKEY = 'CT0022' then newkey = 'CT0021';
/* CANAAN */
if year = 1988 and FSCSKEY = 'CT0023' then newkey = 'CT0022';
/* CANTERBURY */
if year = 1988 and FSCSKEY = 'CT0024' then newkey = 'CT0023';
/* CANTON */
if year = 1988 and FSCSKEY = 'CT0025' then newkey = 'CT0024';
/* CHAPLIN */
if year = 1988 and FSCSKEY = 'CT0026' then newkey = 'CT0025';
/* CHESTER */
if year = 1988 and FSCSKEY = 'CT0027' then newkey = 'CT0026';
/* CLINTON */
if year = 1988 and FSCSKEY = 'CT0028' then newkey = 'CT0027';
/* COLCHESTER */
if year = 1988 and FSCSKEY = 'CT0029' then newkey = 'CT0028';
/* COLUMBIA */
if year = 1988 and FSCSKEY = 'CT0030' then newkey = 'CT0029';
/* CORNWALL (LIBRARY ASSOCIATION) */
if year = 1988 and FSCSKEY = 'CT0031' then newkey = 'CT0030';
/* CORNWALL (WEST CORNWALL LIBRARY ASSOCIATION) */
/* (1988-1991) -- basically blank records. What about CT0196? (1992-2001) */
/* Maybe but no way to know because there is no information to compare. */
if year = 1988 and FSCSKEY = 'CT0032' then newkey = 'CT0031';
/* CROMWELL */
if year = 1988 and FSCSKEY = 'CT0033' then newkey = 'CT0032';
/* DANBURY PL */
if year = 1988 and FSCSKEY = 'CT0034' then newkey = 'CT0033';
/* DANBURY (LONG RIDGE) */
if year = 1988 and FSCSKEY = 'CT0035' then newkey = 'CT0034';
/* DARIEN */
if year = 1988 and FSCSKEY = 'CT0036' then newkey = 'CT0035';
/* DEEP RIVER */
if year = 1988 and FSCSKEY = 'CT0037' then newkey = 'CT0036';
/* DERBY (DERBY NECK) */
if year = 1988 and FSCSKEY = 'CT0038' then newkey = 'CT0037';
/* DERBY PL */
if year = 1988 and FSCSKEY = 'CT0039' then newkey = 'CT0038';
/* DURHAM */
if year = 1988 and FSCSKEY = 'CT0040' then newkey = 'CT0039';
/* EAST GRANBY */
if year = 1988 and FSCSKEY = 'CT0041' then newkey = 'CT0040';
/* EAST HADDAM (RATHBUN) */
if year = 1988 and FSCSKEY = 'CT0042' then newkey = 'CT0041';
/* EAST HADDAM (FREE PL) */
if year = 1988 and FSCSKEY = 'CT0043' then newkey = 'CT0042';
/* EAST HAMPTON PL */
if year = 1988 and FSCSKEY = 'CT0044' then newkey = 'CT0043';
/* EAST HAMPTON (MIDDLE HADDAM) */
if year = 1988 and FSCSKEY = 'CT0045' then newkey = 'CT0044';
/* EAST HARTFORD */
if year = 1988 and FSCSKEY = 'CT0046' then newkey = 'CT0045';
/* EAST HAVEN */
if year = 1988 and FSCSKEY = 'CT0047' then newkey = 'CT0046';
/* NIANTIC (EAST LYME) */
if year = 1988 and FSCSKEY = 'CT0048' then newkey = 'CT0047';
/* EASTON */
if year = 1988 and FSCSKEY = 'CT0049' then newkey = 'CT0048';
/* EAST WINDSOR (BROAD BROOK) */
if year = 1988 and FSCSKEY = 'CT0050' then newkey = 'CT0049';
/* EAST WINDSOR (WAREHOUSE POINT) */
if year = 1988 and FSCSKEY = 'CT0051' then newkey = 'CT0050';
/* ELLINGTON */
if year = 1988 and FSCSKEY = 'CT0052' then newkey = 'CT0051';
/* ENFIELD */
if year = 1988 and FSCSKEY = 'CT0053' then newkey = 'CT0052';
/* ESSEX (LIBRARY ASSOCIATION) */
if year = 1988 and FSCSKEY = 'CT0054' then newkey = 'CT0053';
/* ESSEX (IVORYTON LIBRARY ASSOCIATION) */
if year = 1988 and FSCSKEY = 'CT0055' then newkey = 'CT0054';
/* FAIRFIELD PL */
if year = 1988 and FSCSKEY = 'CT0056' then newkey = 'CT0055';
/* FAIRFIELD (PEQUOT PL) */
if year = 1988 and FSCSKEY = 'CT0057' then newkey = 'CT0056';
/* FARMINGTON */
if year = 1988 and FSCSKEY = 'CT0058' then newkey = 'CT0057';
/* GLASTONBURY (EAST GLASTONBURY) */
if year = 1988 and FSCSKEY = 'CT0059' then newkey = 'CT0058';
/* GLASTONBURY (WELLES-TURNER) */
if year = 1988 and FSCSKEY = 'CT0060' then newkey = 'CT0059';
/* GLASTONBURY (SOUTH GLASTONBURY) */
if year = 1988 and FSCSKEY = 'CT0061' then newkey = 'CT0060';
/* GOSHEN */
if year = 1988 and FSCSKEY = 'CT0062' then newkey = 'CT0061';
/* GRANBY */
if year = 1988 and FSCSKEY = 'CT0063' then newkey = 'CT0062';
/* GREENWICH LIBRARY */
if year = 1988 and FSCSKEY = 'CT0064' then newkey = 'CT0063';
/* GREENWICH (PERROT MEMORIAL) */
if year = 1988 and FSCSKEY = 'CT0065' then newkey = 'CT0064';
/* GRISWOLD (COIT) */
if year = 1988 and FSCSKEY = 'CT0066' then newkey = 'CT0065';
/* GRISWOLD (SLATER) */
if year = 1988 and FSCSKEY = 'CT0067' then newkey = 'CT0066';
/* GROTON (BILL MEMORIAL) */
if year = 1988 and FSCSKEY = 'CT0068' then newkey = 'CT0067';
/* GROTON PL */
if year = 1988 and FSCSKEY = 'CT0069' then newkey = 'CT0068';
/* MYSTIC */
if year = 1988 and FSCSKEY = 'CT0070' then newkey = 'CT0069';
/* GUILFORD */
if year = 1988 and FSCSKEY = 'CT0071' then newkey = 'CT0070';
/* HADDAM */
if year = 1988 and FSCSKEY = 'CT0072' then newkey = 'CT0071';
/* HAMDEN */
if year = 1988 and FSCSKEY = 'CT0073' then newkey = 'CT0072';
/* HARTFORD */
if year = 1988 and FSCSKEY = 'CT0074' then newkey = 'CT0073';
/* HARTLAND */
if year = 1988 and FSCSKEY = 'CT0075' then newkey = 'CT0195';
/* HARWINTON */
if year = 1988 and FSCSKEY = 'CT0076' then newkey = 'CT0075';
/* HEBRON */
if year = 1988 and FSCSKEY = 'CT0077' then newkey = 'CT0076';
/* KENT */
if year = 1988 and FSCSKEY = 'CT0078' then newkey = 'CT0077';
/* DANIELSON */
if year = 1988 and FSCSKEY = 'CT0079' then newkey = 'CT0078';
/* KILLINGWORTH */
if year = 1988 and FSCSKEY = 'CT0080' then newkey = 'CT0079';
/* LEBANON */
if year = 1988 and FSCSKEY = 'CT0081' then newkey = 'CT0080';
/* LEDYARD */
if year = 1988 and FSCSKEY = 'CT0082' then newkey = 'CT0081';
/* LITCHFIELD (GILBERT) */
if year = 1988 and FSCSKEY = 'CT0083' then newkey = 'CT0082';
/* LITCHFIELD (OLIVER WOLCOTT) */
if year = 1988 and FSCSKEY = 'CT0084' then newkey = 'CT0083';
/* LYME */
if year = 1988 and FSCSKEY = 'CT0085' then newkey = 'CT0084';
/* MADISON */
if year = 1988 and FSCSKEY = 'CT0086' then newkey = 'CT0085';
/* MANCHESTER */
if year = 1988 and FSCSKEY = 'CT0087' then newkey = 'CT0086';
/* MANSFIELD */
if year = 1988 and FSCSKEY = 'CT0088' then newkey = 'CT0087';
/* MARLBOROUGH */
if year = 1988 and FSCSKEY = 'CT0089' then newkey = 'CT0088';
/* MERIDEN */
if year = 1988 and FSCSKEY = 'CT0090' then newkey = 'CT0089';
/* MIDDLEBURY */
if year = 1988 and FSCSKEY = 'CT0091' then newkey = 'CT0090';
/* MIDDLEFIELD */
if year = 1988 and FSCSKEY = 'CT0092' then newkey = 'CT0091';
/* MIDDLETOWN */
if year = 1988 and FSCSKEY = 'CT0093' then newkey = 'CT0092';
/* MILFORD */
if year = 1988 and FSCSKEY = 'CT0094' then newkey = 'CT0093';
/* MONROE */
if year = 1988 and FSCSKEY = 'CT0095' then newkey = 'CT0094';
/* MONTVILLE */
if year = 1988 and FSCSKEY = 'CT0096' then newkey = 'CT0095';
/* MORRIS */
if year = 1988 and FSCSKEY = 'CT0097' then newkey = 'CT0096';
/* NAUGATUCK */
if year = 1988 and FSCSKEY = 'CT0098' then newkey = 'CT0097';
/* NEW BRITAIN */
if year = 1988 and FSCSKEY = 'CT0099' then newkey = 'CT0098';
/* NEW CANAAN */
if year = 1988 and FSCSKEY = 'CT0100' then newkey = 'CT0099';
/* NEW FAIRFIELD */
if year = 1988 and FSCSKEY = 'CT0101' then newkey = 'CT0100';
/* NEW HARTFORD (BAKERVILLE) */
if year = 1988 and FSCSKEY = 'CT0102' then newkey = 'CT0101';
/* NEW HARTFORD (NEW HARTFORD MEMORIAL LIBRARY, INC.) */
if year = 1988 and FSCSKEY = 'CT0103' then newkey = 'CT0102';
/* NEW HAVEN */
if year = 1988 and FSCSKEY = 'CT0104' then newkey = 'CT0103';
/* NEWINGTON */
if year = 1988 and FSCSKEY = 'CT0105' then newkey = 'CT0104';
/* NEW LONDON */
if year = 1988 and FSCSKEY = 'CT0106' then newkey = 'CT0105';
/* NEW MILFORD */
if year = 1988 and FSCSKEY = 'CT0107' then newkey = 'CT0106';
/* NEWTOWN */
if year = 1988 and FSCSKEY = 'CT0108' then newkey = 'CT0107';
/* NORFOLK */
if year = 1988 and FSCSKEY = 'CT0109' then newkey = 'CT0108';
/* NORTH BRANFORD */
if year = 1988 and FSCSKEY = 'CT0110' then newkey = 'CT0109';
/* NORTH CANAAN */
if year = 1988 and FSCSKEY = 'CT0111' then newkey = 'CT0110';
/* NORTH HAVEN */
if year = 1988 and FSCSKEY = 'CT0112' then newkey = 'CT0111';
/* NORTH STONINGTON */
if year = 1988 and FSCSKEY = 'CT0113' then newkey = 'CT0112';
/* NORWALK (EAST NORWALK IMPROVEMENT ASSOCIATION) */
if year = 1988 and FSCSKEY = 'CT0114' then newkey = 'CT0113';
/* NORWALK PL */
if year = 1988 and FSCSKEY = 'CT0115' then newkey = 'CT0114';
/* NORWALK (ROWAYTON) */
if year = 1988 and FSCSKEY = 'CT0116' then newkey = 'CT0115';
/* NORWICH */
if year = 1988 and FSCSKEY = 'CT0117' then newkey = 'CT0116';
/* OLD LYME */
if year = 1988 and FSCSKEY = 'CT0118' then newkey = 'CT0117';
/* OLD SAYBROOK */
if year = 1988 and FSCSKEY = 'CT0119' then newkey = 'CT0118';
/* ORANGE */
if year = 1988 and FSCSKEY = 'CT0120' then newkey = 'CT0119';
/* OXFORD */
if year = 1988 and FSCSKEY = 'CT0121' then newkey = 'CT0120';
/* PLAINFIELD (ALDRICH) */
if year = 1988 and FSCSKEY = 'CT0122' then newkey = 'CT0121';
/* PLAINFIELD PL */
if year = 1988 and FSCSKEY = 'CT0123' then newkey = 'CT0122';
/* PLAINFIELD (CENTRAL VILLAGE) */
if year = 1988 and FSCSKEY = 'CT0124' then newkey = 'CT0123';
December 16, 2022