The data will be loaded into a table called features - based on the name of the shapefile. You can specify an alternative table name using --table: $ shapefile-to ...

Read more on my blog, in this series of posts on New features in sqlite-utils and other entries tagged sqliteutils. $ sqlite-utils memory dogs.csv "select * from t ...