

UPDATE State set admin_entered=1 WHERE state_name='Vermont';
UPDATE State set admin_entered=1 WHERE state_name='Kentucky';
UPDATE State set admin_entered=2 WHERE state_name='Tennesee';
UPDATE State set admin_entered=4 WHERE state_name='Ohio';
UPDATE State set admin_entered=6 WHERE state_name='Louisiana';
UPDATE  State set admin_entered=7 WHERE state_name='Indiana';
UPDATE  State set admin_entered=8 WHERE state_name='Mississippi';
UPDATE  State set admin_entered=8 WHERE state_name='Illinois';
UPDATE  State set admin_entered=8 WHERE state_name='Alabama';
UPDATE  State set admin_entered=8 WHERE state_name='Maine';
UPDATE  State set admin_entered=9 WHERE state_name='Missouri';
UPDATE  State set admin_entered=12 WHERE state_name='Arkansas';
UPDATE  State set admin_entered=12 WHERE state_name='Michigan';
UPDATE  State set admin_entered=14 WHERE state_name='Florida';
UPDATE  State set admin_entered=15 WHERE state_name='Texas';
UPDATE  State set admin_entered=15 WHERE state_name='Iowa';
UPDATE  State set admin_entered=15 WHERE state_name='Wisconsin';
UPDATE  State set admin_entered=16 WHERE state_name='California';
UPDATE  State set admin_entered=18 WHERE state_name='Minnesota';
UPDATE  State set admin_entered=18 WHERE state_name='Oregon';
UPDATE  State set admin_entered=18 WHERE state_name='Kansas';
UPDATE  State set admin_entered=19 WHERE state_name='West Virginia';
UPDATE  State set admin_entered=19 WHERE state_name='Nevada';
UPDATE  State set admin_entered=20 WHERE state_name='Nebraska';
UPDATE  State set admin_entered=22 WHERE state_name='Colorado';
UPDATE  State set admin_entered=26 WHERE state_name='North Dakota';
UPDATE  State set admin_entered=26 WHERE state_name='South Dakota';
UPDATE  State set admin_entered=26 WHERE state_name='Montana';
UPDATE  State set admin_entered=26 WHERE state_name='Washington';
UPDATE  State set admin_entered=26 WHERE state_name='Idaho';
UPDATE  State set admin_entered=26 WHERE state_name='Wyoming';
UPDATE  State set admin_entered=27 WHERE state_name='Utah';
UPDATE  State set admin_entered=30 WHERE state_name='Oklahoma';
UPDATE  State set admin_entered=31 WHERE state_name='New Mexico';
UPDATE  State set admin_entered=31 WHERE state_name='Arizona';
UPDATE  State set admin_entered=43 WHERE state_name='Alaska';
UPDATE  State set admin_entered=43 WHERE state_name='Hawaii';