I am struggling with working with my AGOL hosted feature layer in Pro. I have 5,819 records in my attribute table to which each of them are points in the United States. When I select by attributes, for example, CA (California) shows up twice, but if I select either of them it gives me the same selected records. But this is posing an issue for when I need to do joins by state or symbolize by state for any reason.
This was happening two days ago for CA and NY, and now it has appeared for FL, MN, and TX. Please see my screenshot below, highlighted in yellow. I tried running tools like trim() and strip() but doing so makes my ArcGIS Pro crash minutes later, so it's not a great solution, especially if this is occurring for new states that didn't have this issue earlier.
Please help offer any solutions - this is a seemingly small issue that has been a bit of a nuisance. I also don't want to run into any issues in the future if it's treating points in one state as two different "unique" states.