UPDATE briiz_number SET county = 1 WHERE cid BETWEEN 69696000 AND 69696999;
UPDATE briiz_number SET county = 2 WHERE cid BETWEEN 63009000 AND 63009999;
UPDATE briiz_number SET county = 3 WHERE cid BETWEEN 21970000 AND 21973999;
UPDATE briiz_number SET county = 4 WHERE cid BETWEEN 62796000 AND 62796299;
UPDATE briiz_number SET county = 5 WHERE cid BETWEEN 61496000 AND 61496199;
UPDATE briiz_number SET county = 6 WHERE cid BETWEEN 31908500 AND 31908999;
UPDATE briiz_number SET county = 7 WHERE cid BETWEEN 33296000 AND 33296499;
UPDATE briiz_number SET county = 8 WHERE cid BETWEEN 35196000 AND 35196499;
UPDATE briiz_number SET county = 9 WHERE cid BETWEEN 37396000 AND 37396499;
UPDATE briiz_number SET county = 10 WHERE cid BETWEEN 38906000 AND 38906499;
UPDATE briiz_number SET county = 11 WHERE cid BETWEEN 52906000 AND 52906999;
UPDATE briiz_number SET county = 12 WHERE cid BETWEEN 56906000 AND 56906999;
UPDATE briiz_number SET county = 14 WHERE cid BETWEEN 57216000 AND 57216299;
UPDATE briiz_number SET county = 15 WHERE cid BETWEEN 71396000 AND 71396299;
UPDATE briiz_number SET county = 16 WHERE cid BETWEEN 73796000 AND 73796999;
UPDATE briiz_number SET county = 17 WHERE cid BETWEEN 74796000 AND 74796199;
UPDATE briiz_number SET county = 18 WHERE cid BETWEEN 75996000 AND 75996499;
UPDATE briiz_number SET county = 19 WHERE cid BETWEEN 77296000 AND 77296499;
UPDATE briiz_number SET county = 20 WHERE cid BETWEEN 78396000 AND 78396199;