One data point I’d love to have for elementary schools is what percentage of kids in, say, the 1st grade at a school will finish out 4th grade there. Speaks to community, transience, how happy families are there, etc, and would have a real impact on any individual kid’s experience. Even if you’ve got a great school with great teachers, if half your friends leave every year, that’s rough.
This site kinda gets to that:
https://edscape.dc.gov/page/student-enrollment-pathways
But since it doesn’t tell you the total number of students each year, and most of the bars are “n < 10” you can’t calculate a percent. I guess you could cross reference with enrollment by year and grade but that would be onerous. Does this data exist anywhere in a more digestible format?