I renamed the database file and this fixed the issue. As mentioned in the post below there must be some kind of caching in play that means if you update an asset file it doesn't necessarily update what's being used in Expo Go.

Thanks to this post for helping me solve this: React Native - Expo SQLite returns mixed up values for columns