The SQLite website recommends using the “sl3” extension to signify that we're working with an SQLite version 3 database. If we examine the resulting file, ljdata.sl3 using the strings command, we see ...

SQLite will assume an explicitly named integer primary key is just an alias for the rowid if the type is spelled out as "INTEGER" rather than "INT." I can simply change my create table statement as ...