See section "3.1. Determination Of Column Affinity" in <u>[Datatypes In SQLite Version 3](https://sqlite.org/datatype3.html)</u>. Your 3rd (and last) column has the strange type, "String ProjectStartDate DATE", which you can see (per criterion 5) resolves to NUMERIC.