Where are the regular profile field stored?

[rcane]

I know the customs are in custom table (cross checked with the themes table), but I cannot find the regular fields.

Specifically, I'm looking for "location".
I hijacked that for a different purpose before needing to build custom fields.

So, I need that table to grab peoples' "location" and put it in the right place for a report.

It's not showing in the themes from what i see.

[Kindred]

smf_members table > location column

[rcane]

smf_members table > location column

hahah, i was in the kitchen thinking "..it's probably someplace simple like the members..."