UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 618 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 849 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 1629 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2005 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2565 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 2819 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 3549 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 3707 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 4851 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 5186 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 5517 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 6049 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 6306 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 7483 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 9041 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 9081 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 9516 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 10123 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 10991 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 25727323364.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11205 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11508 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 12680 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 12986 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 13228 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 13270 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 13285 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 13313 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 13569 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 15088 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 15268 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 15794 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 17561 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'CULP.O', RkdDisplayRIC = 'CULP.OQ', RkdExchCode = 'NASD', ExchCode = 'NAS' WHERE SecCode = 18019 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 19735 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 24503 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 25011 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 28579 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1998-11-23', SecMapEndDate = '2079-06-06' WHERE SecCode = 28777 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2004-10-06', SecMapEndDate = '2079-06-06' WHERE SecCode = 30421 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 31512 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 32073 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 32515 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 32689 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 36807 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2000-01-03' WHERE SecCode = 39135 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 39198 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 42391 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'NOR' WHERE SecCode = 44840 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 45135 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 45976 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 48545 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 48860 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 49913 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 50699 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 52953 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 54506 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 54969 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 55171 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 55237 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'NOR' WHERE SecCode = 55401 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'XET', DsExchQtStartDate = '1999-06-18', startDate = '1999-06-18' WHERE SecCode = 56395 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DNK' WHERE SecCode = 56880 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 57172 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 57825 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 57997 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FIN' WHERE SecCode = 58768 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 65616 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 68847 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 69421 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', startDate = '1960-01-01' WHERE SecCode = 69724 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 69795 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'KHEN.SI', RkdDisplayRIC = 'KHEN.SI', PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 71417 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 72440 AND Type_ = 10;
UPDATE data_universe SET Name = 'AQYLON NEXUS LTD INR1 (POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 72629 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 72945 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 73138 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951872.0 WHERE SecCode = 73527 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 74548 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74558 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'CCR', PrimaryIssueCode = 23650.0, PriTRBCIndPermID = 4294951190.0, PermOrgIPODate = '1990-01-01' WHERE SecCode = 74992 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 23650.0, PriTRBCIndPermID = 4294951190.0, PermOrgIPODate = '1990-01-01' WHERE SecCode = 74993 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 75012 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = '2008-10-29' WHERE SecCode = 76061 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TWN' WHERE SecCode = 76145 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951906.0 WHERE SecCode = 76246 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 77417 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 78402 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79236 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80964 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-05-24' WHERE SecCode = 81821 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 81935 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 82147 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 82200 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'Q4468821' WHERE SecCode = 82262 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 83798 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 83799 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'BE', DomCntry = 'BEL' WHERE SecCode = 86606 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 86638 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 89199 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 90015 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90115 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90117 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 90389 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2001-08-07', SecMapEndDate = '2079-06-06', startDate = '2001-08-07', endDate = '2013-02-22' WHERE SecCode = 90400 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-04-29' WHERE SecCode = 90416 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 90619 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2003-02-03', SecMapEndDate = '2079-06-06' WHERE SecCode = 90729 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 91255 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2004-07-20', SecMapEndDate = '2079-06-06' WHERE SecCode = 91374 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 91490 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 91937 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2005-06-15', SecMapEndDate = '2079-06-06' WHERE SecCode = 93182 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 93436 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 93483 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2006-04-17', SecMapEndDate = '2079-06-06' WHERE SecCode = 93627 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-07-02' WHERE SecCode = 93662 AND Type_ = 1;
UPDATE data_universe SET Name = 'ENWAVE ENERGY CORP COM' WHERE SecCode = 93676 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 93727 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 93824 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN', PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 93952 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2005-06-30' WHERE SecCode = 94209 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 94257 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2005-10-27', SecMapEndDate = '2079-06-06', startDate = '2005-10-27', endDate = '2012-12-21' WHERE SecCode = 94261 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'COSMO ADVANCED MAT KRW1000' WHERE SecCode = 94278 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2002-05-03', SecMapEndDate = '2079-06-06', startDate = '2002-05-03' WHERE SecCode = 94313 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 94584 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 95148 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2012-10-18' WHERE SecCode = 95216 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 95224 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 95309 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 95353 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-02-05' WHERE SecCode = 95653 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 95734 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2005-01-19', SecMapEndDate = '2079-06-06', startDate = '2005-01-19', endDate = '2008-11-11' WHERE SecCode = 95817 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 96574 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 97041 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1998-07-22', SecMapEndDate = '2079-06-06', startDate = '1998-07-22' WHERE SecCode = 97570 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-04-16' WHERE SecCode = 97623 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 97858 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 98385 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-10-17' WHERE SecCode = 98466 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01', endDate = '2013-07-18' WHERE SecCode = 98874 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 98955 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 99035 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 99094 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '4957.T^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-03-06', SecMapEndDate = '2026-03-05', endDate = '2026-03-05' WHERE SecCode = 99200 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 99697 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0, PermOrgIPODate = '1990-01-01', startDate = '1990-01-01' WHERE SecCode = 100020 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'POL' WHERE SecCode = 100130 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 101019 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06', startDate = '1960-01-01' WHERE SecCode = 101048 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2079-06-06' WHERE SecCode = 101249 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 101308 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 101493 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 101513 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'AUT' WHERE SecCode = 101851 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 105393 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SWE' WHERE SecCode = 105521 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115802 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 123540 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'Y935JF10' WHERE SecCode = 128522 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951254.0 WHERE SecCode = 130394 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IRL' WHERE SecCode = 131961 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 132695 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 136906 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'POL' WHERE SecCode = 137660 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR' WHERE SecCode = 139138 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 139461 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'CN', DomCntry = 'CHN' WHERE SecCode = 141137 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'NOR' WHERE SecCode = 141882 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 142093 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-19' WHERE SecCode = 142232 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 142813 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 143357 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-05' WHERE SecCode = 143539 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DNK' WHERE SecCode = 145785 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'CN', DomCntry = 'CHN' WHERE SecCode = 160832 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 188616 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 195696 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU000000STM0', RkdTicker = 'STM', PermIDTicker = 'STM', RkdSEDOL = 'BDGS4B', RkdCUSIP = 'Q8804M10', RkdRIC = 'STM.AX', RkdDisplayRIC = 'STM.AX', DsPrimQtSedol = 'BDGS4B7' WHERE SecCode = 202343 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 206800 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 216036 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2006-12-07', SecMapEndDate = '2079-06-06', endDate = '2013-02-01' WHERE SecCode = 216771 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'IND' WHERE SecCode = 255431 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256226 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 283463 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 285924 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 288114 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 290874 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 292047 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 293242 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'NOR' WHERE SecCode = 296673 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DNK' WHERE SecCode = 302936 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 313652 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2079-06-06' WHERE SecCode = 313872 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 321377 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 325276 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 329967 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 333932 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 347651 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2008-08-08', SecMapEndDate = '2079-06-06' WHERE SecCode = 367107 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2013-02-14', endDate = '2013-02-14' WHERE SecCode = 376084 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 487810 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DNK' WHERE SecCode = 522348 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 301733, DsSecCode = 221611, IsMajorSec = 'N', DsCtryQtStatus = 'D', DsPrimQtSedol = 'BF29F59', DsSecDelistDate = '2017-11-29', DsExchQtStartDate = '2017-11-07', SecMapStartDate = '2026-03-05', endDate = '2017-11-29' WHERE SecCode = 703142 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 820885 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'FBA.HNO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-06', SecMapEndDate = '2019-10-16', PermQuoteRetireDate = '2026-03-06', endDate = '2019-10-16' WHERE SecCode = 1019998 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'ES', DomCntry = 'ESP' WHERE SecCode = 1028456 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 1265152 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KHL.HNO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-05', SecMapEndDate = '2023-12-08', PermQuoteRetireDate = '2026-03-06', endDate = '2023-12-08' WHERE SecCode = 1529243 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 1570496 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1775623 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'FIN' WHERE SecCode = 2221795 AND Type_ = 10;
UPDATE data_universe SET Name = 'B&M EURO VAL RE PL ORD GBP0.1', Country = 'JEY' WHERE SecCode = 2576985 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NZMPGE0001S5', RkdSEDOL = 'BP07NS', DsPrimQtSedol = 'BP07NS4' WHERE SecCode = 2600875 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'STM', DsPrimQtSedol = 'BDGS4B7' WHERE SecCode = 2653604 AND Type_ = 10;
UPDATE data_universe SET Name = 'WHA PREMIUM GROWTH THB8.8678 (LOCAL)' WHERE SecCode = 2736320 AND Type_ = 10;
UPDATE data_universe SET Name = 'WORLD DIGITAL ECO HKD0.02' WHERE SecCode = 2753942 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2770580 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 98187.0 WHERE SecCode = 2831975 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'DPS.HNO^C26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-03-05', SecMapEndDate = '2024-05-31', PermQuoteRetireDate = '2026-03-06', endDate = '2024-05-31' WHERE SecCode = 2879975 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2906979 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2918018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2930562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2984547 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3038403 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3196985 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3200920 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3216909 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-05' WHERE SecCode = 3317156 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE343X01026', RkdSEDOL = 'BV89NZ', RkdCUSIP = 'Y594H512', DsPrimQtSedol = 'BV89NZ1' WHERE SecCode = 3347652 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NUVG.DE^C26', RkdIssueStatus = 0.0 WHERE SecCode = 3365643 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE625X01026', RkdSEDOL = 'BWTWT2', RkdCUSIP = 'Y793AJ12', DsPrimQtSedol = 'BWTWT25' WHERE SecCode = 3430809 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3441675 AND Type_ = 10;
UPDATE data_universe SET Name = 'GLOBAL CHINESE BUS HKD0.01' WHERE SecCode = 3513957 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3536026 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AMIGO RES PLC ORD GBP0.0025' WHERE SecCode = 3536031 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3629677 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3783087 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4038316 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4302356 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21767264575.0, IsPrimaryInstr = 0.0 WHERE SecCode = 4362696 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 4375233 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 4432469 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4499135 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-05' WHERE SecCode = 4627915 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 4707154 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4711624 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860598463.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET Name = 'EVERPURE INC BDR EACH 4 REPR 1 COM' WHERE SecCode = 4854787 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951768.0 WHERE SecCode = 4911146 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5072156 AND Type_ = 10;
UPDATE data_universe SET Name = 'SINOHEALTH TECH USD0.01' WHERE SecCode = 5082420 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 5152280 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'INA', RkdRIC = 'INSN.NS', RkdDisplayRIC = 'INSN.NS', RkdExchCode = 'NSE' WHERE SecCode = 5188788 AND Type_ = 10;
UPDATE data_universe SET Name = 'CYTECH GROUP CO LT CNY1' WHERE SecCode = 6159023 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-05' WHERE SecCode = 6185552 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-05-23' WHERE SecCode = 6281753 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-05' WHERE SecCode = 6643260 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6664663 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10782539 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SKEL', Name = 'SKELETON COAST URANIUM CORP COM NEW', PriTRBCIndPermID = 4294951901.0, PermSecMapEndDate = '2026-03-05', endDate = '2026-03-05' WHERE SecCode = 10922742 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10926316 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10972631 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10980747 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 10982743 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11030077 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CIMG', PermIDTicker = NULL, RkdRIC = 'CIMG.PK', RkdDisplayRIC = 'CIMG.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-06', endDate = '2026-03-06' WHERE SecCode = 11035773 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11072576 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 11073795 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11111050 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11132995 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11149438 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11155992 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11156060 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11159225 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 11162499 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11168203 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000048799.0 WHERE SecCode = 11174984 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11179103 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11188276 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11194026 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11194141 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11195253 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11195740 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11196043 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe SET Name = 'RAPT THERAPEUTICS INC COM NEW' WHERE SecCode = 11198988 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 11199469 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11200193 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11210762 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727323364.0, IsPrimaryInstr = 1.0, startDate = '2010-01-05' WHERE SecCode = 11212083 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11212420 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11213192 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11221147 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11224477 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11224590 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11232126 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-05', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-03-05' WHERE SecCode = 11232550 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US88165K2006', RkdSEDOL = 'BVCHP9', RkdCUSIP = '88165K20', DsPrimQtSedol = 'BVCHP99' WHERE SecCode = 11236680 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CMTNF' WHERE SecCode = 11243216 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG3514S1048', RkdSEDOL = 'BW47P3', RkdCUSIP = 'G3514S10', DsPrimQtSedol = 'BW47P38' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3730L1317', RkdSEDOL = 'BVCHNR', RkdCUSIP = 'G3730L13', DsPrimQtSedol = 'BVCHNR3' WHERE SecCode = 11260194 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11264781 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-05', PermSecMapEndDate = '2026-03-05' WHERE SecCode = 11268211 AND Type_ = 1;
UPDATE data_universe SET Name = 'PRESIDIO PRODTN CO CL A COM', Country = 'USA' WHERE SecCode = 11270085 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9545M1235', RkdCUSIP = 'G9545M12', DsPrimQtSedol = 'BVCHPK0' WHERE SecCode = 11270239 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 11271946 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11275118 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 25727366625.0 WHERE SecCode = 11278125 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5094089997.0, PriInstrPermID = 232840585779.0, IncCntry = 'CYM', PermOrgIPODate = NULL WHERE SecCode = 11278260 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2023-03-03' WHERE SecCode = 11285607 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236803762162.0, PriTrdQuotePermID = 236803762162.0, ExchCode = 'NYS', PermSecMapStartDate = '2026-03-04' WHERE SecCode = 11292454 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 47763877089.0, ExchCode = 'NYS', PermSecMapStartDate = '2026-03-03' WHERE SecCode = 11292486 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292579 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292620 AND Type_ = 1;
UPDATE data_universe SET Name = 'SUNBELT RENTALS HOLDINGS INC SHS' WHERE SecCode = 11292663 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236803718456.0, IsPrimaryQuote = 1.0, ExchCode = 'CVE' WHERE SecCode = 11292733 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLED.U', ModelCntry = 'US', QuotePermID = 236797716628.0, InstrPermID = 232904799530.0, OrgPermID = 5096945912.0, PriTrdQuotePermID = 236797716628.0, PriValQuotePermID = 25727050435.0, PriInstrPermID = 232904799530.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-04', PermSecMapStartDate = '2026-03-03' WHERE SecCode = 11292836 AND Type_ = 1;
