Select specific column from sqlite query as specific array?

I have a query similar to this:

c.execute('''select FileSize, FileName, FileType from ExampleTable
    where FileType = ?''', [FileType])
bestCRThLocal = list(c.fetchall())
print(bestCRThLocal[0]);

I want to have arrays for FileName, FileType and FileSize each own their own.

What is best way to do this in python?