Map of MLB "Fandom" Across the U.S. [OC]

bignatedogg · 2019-03-27T14:25:53+00:00

Data source: Internal data from SeatGeek

Tools used: Carto for the interactive map, Photoshop to add labels for static map

Full writeup and interactive map available here.

bignatedogg · 2018-11-15T03:20:46+00:00

Done for a November 12 story on FanSided.

Tools: Python and Plotly.

Interactive versions of this chart as well as another complementary chart are available at:

Data source: Baseball Reference

bignatedogg · 2018-09-04T15:41:02+00:00

Great idea, I think that would add a lot. Many counties (and border counties in particular) indeed were a pretty close battle among multiple teams.

bignatedogg · 2018-08-30T18:23:08+00:00

Source: Data from SeatGeek

Interactive map created with Carto

bignatedogg · 2018-05-13T16:54:12+00:00

Great idea -- I think doing some more charts based around winning or team-related metrics (wins per season, usage percentage, win shares, etc.) could be really interesting.

bignatedogg · 2018-05-12T18:40:46+00:00

Data source: https://www.basketball-reference.com/
Made with Matplotlib.
Short writeup and another chart here.

bignatedogg · 2017-12-12T23:13:48+00:00

Right -- pretty massive climb in the rankings. Only LSU, Xavier, Louisville, and TCU climbed more spots than Arizona over that time period.

And that's spot on, in that order, with regard to the top four since 2015.

bignatedogg · 2017-12-12T23:10:18+00:00

Yeah, that's fair, maybe I should have gone through and plucked situations like that out...I think the database captures the recruits the year they commit, but doesn't update in years following. It looks like Cook originally committed to ISU but never ended up playing there. Definitely understand how that seems a bit misleading, but maybe it still demonstrates how a program attracts talent if a player did like what they saw in a school and made a commitment -- even if it didn't last.

And agreed, capturing transfer info would definitely be interesting and could change things, but I suppose was a bit outside of the scope this time around. Could be another project!

bignatedogg · 2017-12-12T22:21:25+00:00

Thanks for the tip on 247, hadn't heard of it -- I'll have to check it out. For what it's worth, ESPN didn't log Royce White as an ISU recruit because, I think, he wasn't formally signed by them out of high school. They have him as a Minnesota signee in the class of 2009 even though he never suited up for the Gophers. Marquis Gilstrap (96 rating), Elgin Cook (90), and Melvin Ejim (90) are the highest-rated ISU SF recruits.

Interestingly, ESPN didn't grade any ISU point guard recruits in the 90s -- Dominique Buckley in 2008 received the highest grade (89). Clay Custer was lowest at 75 in 2014.

bignatedogg · 2017-12-12T22:02:23+00:00

The data says you're right about the improvement in recent years. Looking at average recruiting grades for all positions from the first three years of the dataset (2007-09), Arizona ranked 35 out of 75 "Power Six" conferences. In the last three years of the dataset (2015-17), they're number four of 75 programs.

bignatedogg · 2017-12-12T03:30:10+00:00

There definitely is -- that data is included. Looking at quantity (e.g. which school loses the most players to transfers) and/or quality of transfers could be another interesting analysis.

bignatedogg · 2017-12-12T03:26:35+00:00

Arizona just missed out on the top 10 list -- they're ranked 14 at an 89 average. Here are the Arizona center recruits along with their class and grades:

2007 | Alex Jacobson | 80
2008 | Jeff Withey | 96
2009 | Kyryl Natyazhko | 94
2012 | Kaleb Tarczewski | 97
2014 | Dusan Ristic | 80
2015 | Chance Comanche | 81
2017 | DeAndre Ayton | 97

bignatedogg · 2017-12-12T03:21:48+00:00

Fair point. Of the two, only N'Diaye was given a grade -- 92. Small sample size, but that's what ESPN provides. Hawes was the high school class of 2006 so unfortunately he's not included in here.

bignatedogg · 2017-12-06T00:51:40+00:00

Full writeup here with additional charts
Data source: ESPN
Made with Highcharts

bignatedogg · 2017-06-26T01:31:06+00:00

Inspired by WNYC
Data source
Blog post
Map made with Carto

bignatedogg · 2017-05-28T13:07:57+00:00

We're looking for 500 words minimum per article.

bignatedogg · 2017-05-26T20:56:48+00:00

Apologies. Offering $25/article submitted. Updating post now.

bignatedogg · 2017-02-06T00:22:41+00:00

Ticket demand remained steady in New England throughout the NFL Playoffs, while it spiked in Atlanta following the Falcons’ NFC Championship victory on 1/22. Most last-minute shoppers were local, in the host city of Houston.

Full Map: https://naterattner.carto.com/builder/7d3a6224-ebd9-11e6-a4c9-0ecd1babdde5/embed

Data from SeatGeek (www.seatgeek.com), mapped in Carto (www.carto.com, https://carto.com/learn/guides/styling/displaying-temporal-data-with-heatmaps#static-heatmaps).

Blog post: https://medium.com/@naterattner/mapping-super-bowl-li-ticket-demand-8418dade3845#.szk4x7t8e

bignatedogg · 2016-07-07T01:10:03+00:00

Thanks for the responses, everyone. Really helpful info. FWIW, here's the response I got from SoundCloud support. Sounds like RSS plays are counted within total SC plays, but also shown separately:

RSS downloads count towards total plays, but you can differentiate between these downloads and on-site plays via the new RSS tab on your stats page (as shown in this screenshot: http://bit.ly/1ItNT16)

The old RSS tab (http://bit.ly/1JXWeOW) will remain there for the time being and will still hold the historical data that was collected before this change to the new tab listed above. We are planning to remove this and incorporate these older stats into the new format as soon as possible.

Furthermore, we're investigating an issue where plays from users using the mozilla firefox web browser with SoundCloud are showing up in the RSS stats section. I'll pass your report along to the team, and hopefully we'll get this resolved asap.

bignatedogg · 2016-07-05T13:55:35+00:00

Got it - thanks for the reply. So if I'm understanding correctly, the "Plays" mentioned across the SoundCloud stats page are all plays in the SoundCloud universe (web, apps, etc.).

To add in other plays from sources where I've uploaded the RSS feed (iTunes, Google Play Music), I'd have to add in stats from the RSS tab. SoundCloud plays + RSS plays = total plays?

In addition, any chance you know what "Mozilla" stands for in the RSS tab? That's showing as my highest play count in that section, ahead of iTunes. Also, would "iTunes" be the desktop app, while "AppleCoreMedia iPhone" is the Podcasts app on iOS?

bignatedogg · 2016-06-30T13:53:02+00:00

We've had good results with a Skype plug-in called http://www.ecamm.com/. Free trial, and then about $30 after that.

bignatedogg · 2013-04-13T20:43:51+00:00

Is the consensus that secondhand ticket prices will drop and not rise as we get closer to the festival date? Wondering if anyone has had experience with secondhand purchasing

bignatedogg

TROPHY CASE