Last year I wrote a blog post outlining my use of DBHub.io as a serverless backend for typecode lookups in my Planes Overhead app. Unfortunately, DBHub.io ceased operations at the end of February, putting me back in the market for a new solution!

The Need

As a reminder, my Tidbyt app uses the OpenSky API to obtain the closest plane overhead and populate the display. The typecode detail on the middle-left was a late addition that leverages the unique icao24 identifier for a given plane, which is checked against a flat-file database to fetch the relevant aircraft model.

Read More

It should come as no surprise to regular readers of this blog that I frequently have planes on the brain…

Recently, this obsession interest led me towards building a small ADS-B ground station in my house! It’s got a dinky little antenna, so it can’t really pick up planes too far away, but it works great within the reaches of LA County and provides a pretty incredible live view of all of the traffic overhead.

The setup is almost dead simple if you choose to deploy the FlightAware PiAware solution - one just needs to snap together a Raspberry Pi, connect a 1090 MHz antenna to a receiver dongle/antenna filter, and flash a Micro SD card with their software.

Read More

With Spring Training well underway in Florida and Arizona, I’ve started doing a little reading and research in anticipation of Opening Day - set to be March 18th for the Dodgers and Cubs in Tokyo, and March 27th for rest of the league.

One of the biggest topics of conversation this offseason for the Washington Nationals was whether or not they would be active on the high-end free agent market, potentially signing a few veterans to augment their promising young core. While they did make a key trade to address a clear area of weakness at first base, acquiring Nathaniel Lowe from the Texas Rangers, they didn’t sign any marquee free agents to bolster their roster or rotation, much like the 2024 offseason, 2023 offseason, 2022 offseason, and 2021 offseason.

Read More

Yesterday the NFL Players Association (NFLPA) released their latest set of Team Report cards, following the 2024 release and 2023’s inaugural data. These report cards include grades by 1,695 players, scoring their own teams on a variety of player experience dimensions from A+ to F-:

• Treatment of Families
• Food/Cafeteria
• Nutritionist/Dietician
• Locker Room
• Training Room
• Training Staff
• Weight Room
• Strength Coaches
• Team Travel
• Head Coach
• Ownership

As I’ve done the last two seasons, I spent a bit of time this evening sprucing the data up into a few easy-to-read visuals!

Read More

A few days ago, CNBC released their latest valuations of NBA franchises. The data shows the Golden State Warriors with a nearly $2B lead on the Knicks as the most valuable franchise, and biggest revenue earner in the 2023-2024 season.

The Warriors’ move to the Chase Center and San Francisco has clearly earned huge financial dividends, though I can’t help but feel that their departure from Oakland has cost them something spiritually - trading away that blue-collar soul which made Oracle Arena so electric in exchange for more luxury boxes…

Read More

On December 18th, the Senate Budget Committee dropped a doozy of a blog post, titled “New Data Reveal Climate Change-Driven Insurance Crisis is Spreading”.

They didn’t bury the lede at all, getting right to their conclusion that “climate change is increasing insurance non-renewals around the country” and that “the failure to deal with climate change is also affecting whether families can even get homeowners insurance”.

How I Found This Data

I wish I could say that I stumbled upon this post and the accompanying data as part of a research project. Unfortunately, that is not the case - I was turned onto this data in the aftermath of the enormous Palisades fire, which burned about 3 miles north of my house.

Read More

Yesterday I wrote a quick blog post discussing how the distribution of field goal attempts by distance has shifted quite a bit over the last twenty five years: teams are attempting fewer short field goals and more long field goals.

In this post, I’ll look to round out my analysis, focusing not on attempts, but the actual make rate of kicks by distance, and how that has evolved over time.

Visualizations

What we find when we slice the data by time is that kickers have NFL kickers have become more accurate at every level of accuracy since 1999. We find that kickers in 2024 are:

Read More

A major storyline this NFL season has been the unprecedented success of kickers on extra-long field goals. In this post, we’ll look at how the kicks being attempted have skewed longer and longer over time - I plan to fast-follow this post with another focusing on how field goal make rate has also evolved through the years!

What’s Going On

It should stand as no surprise to NFL fans that two big trends have emerged in the kicking game:

Read More

Most fantasy football leagues have a notion of “start percentage” for players - as ESPN says, “start percentage shows the number of fantasy leagues a player is started in divided by the number of leagues he is eligible in. This helps indicate how the public views a player.”

Watching football last weekend, I was struck by the number of touchdowns being scored by users who I knew weren’t being started! Particularly in the Broncos vs Chargers matchup, it seemed like the players who might have been “broadly started” in fantasy (like Courtland Sutton and Ladd McConkey) did very little, while the following fantasy-unknowns all grabbed receiving scores: DeVaughn Vele, Michael Burton, Hassan Haskins, and Derius Davis.

Read More

Well, at least the wait is over. In the latest bit of intra-NL East star player migration, yet another former National has signed a megadeal with a hated rival.

Throughout the Boras-led bidding process, I had expected the Yankees to retain Juan Soto, but it seems that Steve Cohen decided he would simply not be outbid, and the Mets flexed their financial muscles to lock Soto down with a fifteen year deal valued at $765 million.

Read More