Compid = 130861Number Of Rows Found :1
Compid Found :130861 Tic Found :SUR
FINALSUR | 130861
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130861 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :0
virgina 0
virgina2 0
SELECT * from sectors where level3num = '303004'Number Of Rows Found :1
The Sector is Property & Casualty Insurance
CRAIG TOTAL SHARES VALE : 0
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001044566',
'130861',
'CNA Surety Corp',
'SUR',
'',
'12612L108',
'44240',
'0',
'303004',
'Property & Casualty Insurance',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye