The spreadsheet isn't supposed to supplant an individual's own research of programs (finding out university-based vs. community-based). You can use FREIDA database which has information provided by programs that has some of the fields you're interested in (STEP/COMLEX minimum score, # of interviews, academic vs. community, etc). FREIDA is not always the most up to date, but it is usually pretty accurate in my experience. Also for the spreadsheet if you look at the applicant info tab, it does have information about what type of applicant someone is (DO vs. MD vs. IMG), board scores, how many applications an applicant sent, and how many invites they received.
Just a note on university-based vs. community-based, I think there are a ton of hybrid programs for FM that don't fall strictly into academic or community. For example, I have seen programs with:
1. University-based with FM inpatient service at their main university, but also have a community hospital FM service that is unopposed (programs like UC-Denver and UW-Madison come to mind).
2. University-affiliated: Behaves more like a community program where inpatient service is done at community hospital, but have specialty rotations with specialists associated with a university and also have additional resources provided by the academic affiliation. I've noticed these programs are usually in more urban areas.
So all of that to say, for family medicine, it's a lot more nuanced than just looking at community-based vs. university-based.
If you don't mind me asking, is there a specific reason that you are focusing on university-based FM programs?
