UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 247 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 970 AND Type_ = 10;
UPDATE data_universe SET Name = 'CALLAWAY GOLF CO COM' WHERE SecCode = 11800 AND Type_ = 1;
UPDATE data_universe SET Name = 'COSTCO WHOLESALE CORPORATION COM' WHERE SecCode = 17451 AND Type_ = 1;
UPDATE data_universe SET Name = 'DORCHESTER MINERALS L P COM UNIT' WHERE SecCode = 20323 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US36117V4023', RkdCUSIP = '36117V40', DsPrimQtSedol = 'BVMLJ00' WHERE SecCode = 23996 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 25593 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 25603 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 25604 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 25607 AND Type_ = 1;
UPDATE data_universe SET Name = 'HECLA MINING COMPANY PFD CV SER B' WHERE SecCode = 33143 AND Type_ = 1;
UPDATE data_universe SET Name = 'GRANITE REAL ESTATE INC TR UNIT NEW' WHERE SecCode = 43807 AND Type_ = 1;
UPDATE data_universe SET Name = 'MEDICAL FACS CORP COM NEW' WHERE SecCode = 45521 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-19' WHERE SecCode = 45794 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-16' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-19' WHERE SecCode = 72182 AND Type_ = 10;
UPDATE data_universe SET Name = 'US BANCORP PFD B 1/1000DP' WHERE SecCode = 77348 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'SUAL PHOTONICS TWD10' WHERE SecCode = 83819 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0, startDate = '1988-04-15' WHERE SecCode = 85934 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'XINHUA LANDE ''H''CNY0.10' WHERE SecCode = 87026 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 87281 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-15' WHERE SecCode = 87540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteRetireDate = '2026-01-19' WHERE SecCode = 88997 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALLIED PROPERTIES REIT UNIT' WHERE SecCode = 90267 AND Type_ = 1;
UPDATE data_universe SET Name = 'CANADIAN ENERGY SVCS & TECH COM' WHERE SecCode = 91786 AND Type_ = 1;
UPDATE data_universe SET Name = 'E-L FINANCIAL CORPORATION COM' WHERE SecCode = 93425 AND Type_ = 1;
UPDATE data_universe SET Name = 'E-L FINANCIAL CORPORATION PFD 1ST SER 1' WHERE SecCode = 93427 AND Type_ = 1;
UPDATE data_universe SET Name = 'FIRM CAP MORTGAGE INVT TR COM' WHERE SecCode = 93963 AND Type_ = 1;
UPDATE data_universe SET Name = 'GAMEHOST INCOME FUND COM' WHERE SecCode = 94266 AND Type_ = 1;
UPDATE data_universe SET Name = 'PLAZACORP RETAIL PPTYS LTD TR UNIT' WHERE SecCode = 98077 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 100453 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'OPTION NV NPV' WHERE SecCode = 104487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114537 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1994-06-06' WHERE SecCode = 126602 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 130028 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951780.0 WHERE SecCode = 134647 AND Type_ = 10;
UPDATE data_universe SET Name = 'E-L FINANCIAL CORPORATION PFD 4.75% SR 2' WHERE SecCode = 177934 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHENIERE ENERGY PARTNERS L P COM UNIT' WHERE SecCode = 292058 AND Type_ = 1;
UPDATE data_universe SET Name = 'CU INC MEDIUM TERM NT CDS- 4.60 PFD SER 1' WHERE SecCode = 293453 AND Type_ = 1;
UPDATE data_universe SET Name = 'JIANGSU CHINT POWE ''A''CNY1' WHERE SecCode = 309517 AND Type_ = 10;
UPDATE data_universe SET Name = 'MANHATTAN GOLD COR NPV' WHERE SecCode = 315090 AND Type_ = 10;
UPDATE data_universe SET Name = 'WELLS FARGO & CO PERP PFD CNV A' WHERE SecCode = 348300 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL WHERE SecCode = 522849 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-15' WHERE SecCode = 558747 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-15' WHERE SecCode = 558958 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 703292 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'bioh', RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 703360 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-15' WHERE SecCode = 798159 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 890627 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-19' WHERE SecCode = 1123551 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-15', endDate = '2026-01-15' WHERE SecCode = 1482699 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 1485705 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 2495862 AND Type_ = 10;
UPDATE data_universe SET Name = 'HAYDALE PLC ORD GBP0.0001' WHERE SecCode = 2543613 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 2586521 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE857P01021', RkdTicker = '538520', RkdSEDOL = 'BTN1V0', RkdCUSIP = 'Y7938J13', RkdRIC = 'SAMS.BO', RkdDisplayRIC = 'SAMS.BO', RkdCode = 143974.0, RkdIssueID = 1.0, RkdIssueCode = 183890.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2747736 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2993527 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3044827 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BEST AGROLIFE LTD INR1(POST SUBD)' WHERE SecCode = 3093751 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-19' WHERE SecCode = 3124058 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236801608204.0 WHERE SecCode = 3155992 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 3211294 AND Type_ = 10;
UPDATE data_universe SET Name = 'OPTIMUM RE SPAIN S EUR4.3' WHERE SecCode = 3247303 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NO0013711713', RkdSEDOL = 'BSWVGB', RkdCUSIP = 'R0832719', DsPrimQtSedol = 'BSWVGB9', PermSecMapEndDate = '2026-01-16', endDate = '2026-01-16' WHERE SecCode = 3320156 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-19' WHERE SecCode = 3404428 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5087114213.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 3418966 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POLYFAIR HLDGS LTD HKD0.1' WHERE SecCode = 3436254 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-15' WHERE SecCode = 3444707 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HANJIA DIGITAL INT A CNY1' WHERE SecCode = 3504663 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5087114213.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 3717242 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-16', SecMapEndDate = '2026-01-15', PermQuoteRetireDate = '2026-01-16', PermSecMapEndDate = '2026-01-16', endDate = '2026-01-15' WHERE SecCode = 3998151 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3999456 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4012179 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-15' WHERE SecCode = 4211733 AND Type_ = 10;
UPDATE data_universe SET Name = 'ATC MUSIC GP PLC ORD GBP0.01' WHERE SecCode = 4812249 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET Name = 'DOLPHIN DRILLING NOK3' WHERE SecCode = 5155393 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5087114213.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5293388 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 127557.0 WHERE SecCode = 5674481 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5087114213.0, PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5740526 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5822373 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0022760229', RkdTicker = 'GIG SDB', RkdSEDOL = 'BSNR2R', RkdCUSIP = 'X320CF10', RkdRIC = 'GIGsdb.ST', RkdDisplayRIC = 'GIGsdb.ST', RkdCode = 143989.0, RkdIssueID = 1.0, RkdIssueCode = 183906.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'EDR', RkdExchCode = 'STO', RkdExchCtry = 'SWE', ShPerListing = 1.0, PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 5940212 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SETL', PermIDTicker = 'SETL' WHERE SecCode = 6074808 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 6211060 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LMAI11', DsPrimQtSedol = 'BVMVH06', PermSecMapEndDate = '2026-01-16', endDate = '2026-01-16' WHERE SecCode = 6258211 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 6453918 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y680CK11' WHERE SecCode = 6538870 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMAL HOLDINGS AD L NPV' WHERE SecCode = 6571951 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y006XN10' WHERE SecCode = 6589132 AND Type_ = 10;
UPDATE data_universe SET Name = 'US BANCORP DEP PFD SER A' WHERE SecCode = 10963681 AND Type_ = 1;
UPDATE data_universe SET Name = 'CITIGROUP CAPITAL XIII TR PFD SECS' WHERE SecCode = 10970877 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9630257700', RkdCUSIP = '96302577', DsPrimQtSedol = 'BVMLJ77' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe SET Name = 'CT REAL ESTATE INVT UNIT' WHERE SecCode = 11108715 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = 143752.0, RelType = 1.0 WHERE SecCode = 11136753 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA91831M2040', RkdCUSIP = '91831M20', DsPrimQtSedol = 'BVMLMD4' WHERE SecCode = 11152692 AND Type_ = 1;
UPDATE data_universe SET Name = 'WILLAMETTE VALLEY VINEYARDS RED PFD SER A' WHERE SecCode = 11153710 AND Type_ = 1;
UPDATE data_universe SET Name = 'WELLS FARGO & CO NON CUM PFD Y' WHERE SecCode = 11171533 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 11176964 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US29415J2050', RkdCUSIP = '29415J20', DsPrimQtSedol = 'BVMLJN3' WHERE SecCode = 11180147 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASE INDL HLDG CO LTD SPONSORED ADS' WHERE SecCode = 11184689 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET Name = 'US BANCORP DEP PERP PFD K' WHERE SecCode = 11188843 AND Type_ = 1;
UPDATE data_universe SET Name = 'JPMORGAN CHASE & CO 5.75% SHS PFD DD' WHERE SecCode = 11190112 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASSOCIATED BANC-CORP DEP SHS PFD E' WHERE SecCode = 11190165 AND Type_ = 1;
UPDATE data_universe SET Name = 'J & FRIENDS HOLDINGS LTD SPONSORED ADS' WHERE SecCode = 11191346 AND Type_ = 1;
UPDATE data_universe SET Name = 'JPMORGAN CHASE & CO 6 DEP NCM PFD EE' WHERE SecCode = 11193440 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA29478G1063', RkdTicker = 'NOVA', RkdCUSIP = '29478G10', RkdRIC = 'NOVA.V', RkdDisplayRIC = 'NOVA.V', DsPrimQtSedol = 'BVMLMG7' WHERE SecCode = 11197041 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVMLJ88' WHERE SecCode = 11199544 AND Type_ = 1;
UPDATE data_universe SET Name = 'JPMORGAN CHASE & CO 4.75% DP SH GG' WHERE SecCode = 11201765 AND Type_ = 1;
UPDATE data_universe SET Name = 'WELLS FARGO & CO DP PF CL A SR Z' WHERE SecCode = 11204332 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASSOCIATED BANC-CORP 5.625 DP PF SR F' WHERE SecCode = 11208548 AND Type_ = 1;
UPDATE data_universe SET Name = 'US BANCORP DEP PER PFD SR L' WHERE SecCode = 11213986 AND Type_ = 1;
UPDATE data_universe SET Name = 'WELLS FARGO & CO DEP SH PFD CL A' WHERE SecCode = 11214021 AND Type_ = 1;
UPDATE data_universe SET Name = 'US BANCORP 4% DEP PFD SER M' WHERE SecCode = 11218203 AND Type_ = 1;
UPDATE data_universe SET Name = 'JPMORGAN CHASE & CO 4.55 DEP PFD JJ' WHERE SecCode = 11220639 AND Type_ = 1;
UPDATE data_universe SET Name = 'JPMORGAN CHASE & CO 4.625 DEP PFD LL' WHERE SecCode = 11224266 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK HAWAII HONOLULU MTN BE 4.375% DEP PFD A' WHERE SecCode = 11225319 AND Type_ = 1;
UPDATE data_universe SET Name = 'JPMORGAN CHASE & CO 4.20% DP PFD MM' WHERE SecCode = 11227758 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVMLHZ1' WHERE SecCode = 11235543 AND Type_ = 1;
UPDATE data_universe SET Name = 'US BANCORP 4.50% DEP PFD O' WHERE SecCode = 11237944 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11238161 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVMLJD3' WHERE SecCode = 11253812 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'PDC', RkdRIC = 'PDC.O', RkdDisplayRIC = 'PDC.OQ', DsTypeCode = 'EQ' WHERE SecCode = 11255441 AND Type_ = 1;
UPDATE data_universe SET Country = 'VGB' WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289419 AND Type_ = 1;
