You’re killin’ me, smalls

Were the 90’s really the mecca for live action kids movies? And how much more profitable are animated movies these days?

 Note: The PG-13 rating did not exist until half-way through 1984.

Curious what caused those huge 2016 numbers? Finding Dory, Zootopia, and Moana.

I haven’t written a post in a while because I tried creating this database of all high school mascots and that got a bit too tedious, had to find too many manually.  Still working on it, hope to finish someday.

I was thinking back to what movies I really enjoyed in my childhood in the 90’s. The Sandlot, Mighty Ducks, Casper, The Big Green, Blank Check, Andre, A League of their Own, The Rookie, Now and Then, Matilda, Home Alone, Heavyweights, Toy Story, Camp Nowhere, Free Willy. The list goes on and on. Notice that they’re all live action, except for Toy Story? The 80’s and 90’s had a ton of good live-action kids movies. Nowadays, it seems like there are way more animated movies and a lot less Mighty Ducks. Were the mid-90’s really the mecca of live action kid movies? I set out to find out if this is really true.

At first, I started combing the internet manually, putting together lists of kids movies per decade. I also wrote SPARQL, the query language for wikipedia, to pull down movies with the genre “children’s film”. I looked at trailers and synopses to determine if a movie could be branded a kid’s movie if it wasn’t obvious to me. There were some tough dilemmas, like Now & Then is rated PG-13 but as an 11-year-old, I loved it and it featured kids around my age. Is that a kids movie? I think so, but the rating disagrees.  What about PG romantic comedies, like Sleepless in Seattle? In the end, this proved too cumbersome, especially considering there are way too many movies in the 1980s and 2000s that I was not familiar with, so I started all over. I resorted to simply copying down lists of movies from the site boxofficemojo. You can get lists per year and rating, so I took down all the G and PG-rated movies for each year, 1982-2017 (1982 was the earliest year using the aforementioned filters).  I then marked which ones were animated, which took a bit of time, but at least it was an unambiguous task, I thought, until I ran into movies like Space Jam, Hop, and the Muppet movies. I decided to label those live action.  Of course, I wouldn’t call all PG movies “kids movies”- there are definitely a lot from the 80s that looked like adult movies to me- but I figure this is good enough criteria to answer my research question without spending a million hours.

The first graph shows simply the number of movies rated G or PG per year, broken up by animated or live action.*  The second shows their box office numbers. As you can see, animated movies are becoming more common and raking in a ton of money for movie studios, while live-action G/PG movies are on the decline. There were 67 live action G/PG movies 1984 and it has slipped a lot since then, with only nine being released in all of 2013! One thing to consider is that the PG-13 rating did not exist until part way through 1984 and something that was G back then wouldn’t necessarily be G now.  The fact that you see a sharp drop off in PG movies after 1984 can attributed partly to this. There was a bit of a peak in the mid 90’s, during the height of my childhood (I was born in 1986), like I suspected.  I grew up on live-action movies and to this day, don’t care as much for animated movies, but I know that’s not true for everyone my age.

Continue reading

States With Most Private School Students

Click to enlarge in a new tab

I went to a fine suburban public school, but sometimes I wondered what it would be like to go to a fancy private school with a fancy sounding name like The Summit Country Day School or The Seven Hills School (the “the” in front is how you know it’s fancy). Those are two of the most expensive and top-rated schools in Cincinnati, which run just over $20,000 a year. That doesn’t have much on New York City private schools, like Dalton, Marymount, or the Ethical Cultural Fieldston School, the latter of which is $47,000 a year. Cities like Cincinnati, where I live, are full of Catholic schools. We have 7 all-girls, 5 all-boys, and many co-ed Catholic high schools in the greater Cincinnati area. So I was curious- where are there a high percentage of private schools? Would NYC or somewhere in the Northeast top the list?

I ran this analysis of the percentage of private school students using both the state population and the total number of students (public + private) as the denominator (the results were pretty similar, but note how DC goes down a lot further, relatively speaking, in the bottom graph).  DC has the highest private to public ratio of students and Utah and Wyoming are among the lowest.

Continue reading

NCAAW Basketball (part 2)


Click to enlarge in a new window.

Finally, part 2 of my women’s NCAA Basketball stats. The above data shows which states the players from the top 15 schools hail from (at end of 2016 season). Texas soars to the top with 20, followed by 12 from Ohio, and 9 from California and Georgia.  But don’t forget that the University of Texas and Baylor are in the top 15, and Ohio State is as well, and they recruited a lot of Ohioans. California has UCLA and Stanford. Georgia doesn’t have any schools but have a few close by- South Carolina, Florida State, and Tennessee. So that begs the question- are these schools so good because these areas are hotbeds for basketball talent, or are these athletes a bit lucky to live in an area with a top program, or a bit of both?  UConn has been the #1 team for years and they consistently recruit far from Connecticut for their top players. However, they, like most teams, have more local players filling out their roster, which explains some of the results.

The tables to the right show analysis I did combining my Athletes data with my Schools data to answer the question- do players come from wealthier towns, and therefore likely wealthier families? By using school data on the number of students on free or reduced lunch, I bucketed all 99,000 public schools in my data set into 5 equal-sized buckets. Level 1 is the poorest schools, or the bottom 20% (highest percentage of free/reduced lunch), and Level 5 is the top 20%. 43 of the athletes were in Level 5, and the numbers keep decreasing through Level 1. So the answer to my question is yes, players are, on average, coming from richer public schools. And just for fun, I also ran their private schools through and found that the majority went to Catholic school, but that’s no shock given the sheer number in this country.

For reference, the top 15 schools at the end of 2016 were (in alphabetical order): Arizona State, Baylor, Florida State, Kentucky, Louisville, Maryland, Notre Dame, Ohio State, Oregon State, South Carolina, Stanford, Tennessee, Texas, UCLA, and the University of Connecticut.

USA Olympians on Instagram

USA Olympians Ranked by Growth in followers during August

I’m a huge fan of the Olympics and hold a party every time to watch the Opening Ceremonies. I thought it would be fun to see which athletes at the 2016 Rio games had the most social media followers and which ones saw the most growth in followers during the Games. The list above is all the USA Olympians who saw their Instagram follower counts double after the Games were over (only those with at least 4000 followers were included). The list below is the top 20  with the most followers regardless of growth. Male basketball players feature prevalently, not to my surprise. But it was nice to see Serena and Alex Morgan up there in the top 5 along with Simone Biles at #7.


Continue reading

NCAAW Basketball (part 1)


I compiled statistics on the top 15 women’s college basketball teams during March Madness this year using their rosters. I calculated the average height for each team as well as figured out who the shortest and tallest players are. The shortest stands at 5’3″ and the tallest two are 6’7″. While UConn was the number one team, it ranked 12th in height out of the 15 teams I analyzed.  I also did some race/ethnicity statistics based on their photos and articles I found, so it is by no means an exact science since it’s not like they list that in people’s bios (also note that if they are half non-Caucasian, they tend to be listed as the non-Caucasian race/ethnicity). All the rosters list the women’s high schools, so I was able to see what percentage go to public versus private school or homeschool. The majority are public schooled (72%).  The 19 “Blank” entries represent the 18 international students and 1 homeschooled student- Moriah Jefferson of UConn.  In addition to AAU, Moriah played for a homeschool team in Texas during the winter season.  Florida State has the most international players of any team.

On the next post, I’ll share some other interesting stats and charts, like which states these athletes come from as well as analysis using the schools they came from.


Christian Book Overload

Disclaimer: The data in this post is approximate and not 100% verified or factual.

Click the chart to enlarge

I did a previous post on the Top 20 Megachurches and noticed while researching the pastors that, boy, have they written a lot of books! Holy cow. I thought it was just Joel Osteen, but I was wrong. The graphic above is the approximate number of books written* by the pastors of the top 50 megachurches according to one ranking list I found**. 476 books total! How do they have so much to say to write 10, 15, 30 books?! And are they writing these during work time when they should be doing other things for their church? Are they getting rich off these books? Tons of the these churches or pastors have an online store on their website to sell the books and dvds and study guide companions, which is a huge turn off for me. The whole thing just made me groan. It’s such a business and kind of feels like a scam. I doubt Jesus would have wanted it this way.

Continue reading

Serena versus the world


Above is a graph showing the ranking points by country for the top 100 women players on the WTA tour as of August 10, 2015. As you can see, the United States is the clear #1 with over 25,000 points (for reference, winning a grand slam like Wimbledon nets you 2000 points; a large event like Cincinnati’s Western & Southern Open gives you 900, and an ITF event (the minor leagues) adds around 50-150 points). The WTA uses a rolling 12 month point system so you never reset to zero (the ATP tour, the last I checked, does reset each year in January).

I made some more cool visualizations with Microsoft’s Power BI technology that shows there’s more than meets than eye when evaluating which country is dominating. Continue reading