4 ms·
I've started uploading these CSVs to a public Google BigQuery dataset called [nfl], so you can run queries over them like this: SELECT off, COUNT(off) AS c
by ImJasonH 14y ago
I've started uploading these CSVs to a public Google BigQuery dataset called [nfl], so you can run queries over them like this:
SELECT off, COUNT(off) AS count
FROM [nfl.2012reg]
WHERE description CONTAINS "INTERCEPTED"
GROUP BY off
ORDER BY count DESC
(This counts the number of plays that resulted in an interception by the team that threw the interception, sorted from most to fewest INTs)
- danvoell 14y agoI'm new to BigQuery, how do I access a public dataset? I ran the query and got the error Not Found: Dataset 578707073226:nfl
- snake_plissken 14y agomean reversion between ints for NFL live betting on next int? i smell greenbacks!
- sethist 14y agoThat sounds like the dictionary definition of the gambler's fallacy. If anything, the odds of an interception likely increase after a previous interception as it would be a sign of a defensive advantage over the QB. If only there was somewhere we could get the data to figure out for sure...