SQLite

show tables .tables

describe table pragma table_info('moz_hosts');

where and like select host from moz_hosts where host like 'marathon%';

exit quit .exit

import csv into sqlite

create table foo (publishedAt INT, observedAt NUMREIC, market TEXT, source TEXT) .mode csv .import test.csv foo

more info at quackit.com