INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (4049140, 10, '@LANDI27', NULL, 'JP3968750004', '2981', '2981', 'BL4KJ9', 'J3876710', '2981.T', '2981.T', 'LANDIX INC NPV', 'JP', 'JPN', 321562, 231457, 181727, 'Y', 'A', 'BL4KJ94', 'EQ', 'TKS', 'JP', 'JPY', 121203, 1, 152973, 'C', 1, 1, 'OSR', 'TYO', 'JPN', NULL, 'EQU', NULL, NULL, 'IND', 21721939695, 21721474844, 5071544829, NULL, 21721939695.0, 21721474844.0, 1, 1, 'AC', 'AC', 'TYO', 'ORD', 'ORD', 'COM', 'JPN', 'JPN', 4294951324.0, NULL, '2019-12-19', '2019-12-19', '2079-06-06', NULL, '2019-12-19', '2019-11-18', NULL, '2019-11-18', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (4689960, 10, '@RAVBA1', NULL, 'IL0011799934', 'BRIH', 'BRIH', 'BMZ67N', 'M8S99X10', 'BRIH.TA', 'BRIH.TA', 'RAV BARIACH 08 IND ILS0.001', 'IL', 'ISR', 343687, 243756, 189865, 'Y', 'A', 'BMZ67N8', 'EQ', 'TAE', 'IL', 'ILS', 130110, 1, 165044, 'C', 1, 1, 'OSR', 'TLV', 'ISR', NULL, 'EQU', NULL, NULL, 'IND', 25727235326, 25727235375, 5039649428, NULL, 25727235326.0, 25727235375.0, 1, 1, 'AC', 'AC', 'TLV', 'ORD', 'ORD', 'COM', 'ISR', 'ISR', 4294951639.0, NULL, '2021-08-27', '2021-08-27', '2079-06-06', NULL, '2021-08-29', '2021-08-27', NULL, '2021-08-27', NULL);
INSERT INTO model_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (10902895, 1, 'GUSP.V', NULL, 'CA0705051021', 'BAT', 'BAT', 'B4WY6T', '07050510', 'BAT.V', 'BAT.V', 'BATERO GOLD CORP COM', 'CA', 'CAN', 171755, 136126, 108242, 'Y', 'A', 'B4WY6T8', 'EQ', 'TSX', 'CA', 'CAD', 71169, 1, 89762, 'C', 1, 1, 'OSR', 'CVE', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 55847106909, 8591272583, 4298016275, NULL, 55847106909.0, 8591272583.0, 1, 1, 'AC', 'AC', 'CVE', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951922.0, NULL, '2009-02-13', '2009-02-06', '2079-06-06', NULL, '2009-02-13', '2009-02-06', NULL, '2009-02-06', NULL);
