Import the CSV into a raw table:

.mode csv
.import <filename> import_raw

Normalize and transform the raw table into the final tables:

sqlite3 npi.db < npi.sql