discovered a way to make our results better and reduce redundant entities by using only the licensee
After looking through the results of entity table joins, I discovered that there were a lot of redundant values that bogged up the query results and ended up costing a lot of computational power. I got rid of half of them by discovering there we were loading the table twice. But I soon discovered that we were still getting duplicates because there were multiple entries for a call sign in the entity list due to the entity type. So as a result every antenna with a specific call sign would join with the multiple entity entries. So as a result instead of having the number of antennas with a call sign as our result, we could get the number of antennas * the number of entity entries. Through filtering, I discovered that every entity needs to have a licensee entry and usually the licensee was the company that owns the antenna. Other entries like contact licensor were the law firms the companies hired to file the registration.