01 / IDENTITYOne row. One play.
The within-snapshot key is (game_id, play_id). Across snapshots it is (snapshot_id, game_id, play_id). drive remains nullable: 13,750 rows have no drive value. They remain searchable and inspectable.
Each season uses one pinned PBP snapshot. 1999–2025: retrieved=2026-10-24; 2026: retrieved=2026-11-03. A season never contains duplicate vintages.
02 / PARTICIPATIONCoverage has boundaries.
449,971 staged participation rows, seasons 2016–2025. The current 2023 vintage is used; old_2023 is excluded. The staging view excludes 5,349 information-free placeholders and unmatched records.
2026 participation is unavailable in this snapshot. A missing row means “unavailable,” not zero players. Credited players and on-field players are separate filters.
03 / SUMMARIESShow the denominator.
Matched rows include non-scrimmage events. Efficiency metrics use play_type IN ('run','pass'), excluding QB kneels and spikes. Sacks count as pass plays. EPA/play and success rate use only non-NULL EPA; success means EPA > 0. Yards/play excludes NULL yards. Dropback rate uses qb_dropback = 1.
These are play-derived metrics, not official player season statistics. Team abbreviations retain the source era (e.g. OAK/LV). “Either side” means offense or defense on that play.
04 / SNAPSHOTFrozen, full-schema data.
28 full-schema season files, 1999–2026, verified against source SHA-256 hashes. The updated 2026 snapshot contains 21,191 plays in 121 games, complete through Week 8. Three source games are absent: 1999 BAL @ STL; 2000 SD @ KC; 2000 BUF @ MIA. Schedule data is separately pinned to Oct 21 and can lag PBP.
All 373 source fields plus snapshot_id are in the play inspector. The hosted export follows the archived staging definitions; the 2026 update uses a separately versioned staging view. It does not connect to or update your local warehouse.
05 / ATTRIBUTIONSources and licenses.
PBP and schedules: nflverse, CC BY 4.0. Participation: NFL NextGenStats via nflverse (through 2022); FTN Data via nflverse (2023 onward), CC BY-SA 4.0. Participation derivatives retain that license. Source values are preserved; browser exports reorganize rows into query and detail files.
nflverse data · CC BY 4.0 · CC BY-SA 4.0
06 / AUDIT TRAILDefinitions you can inspect.
Export manifest & source hashes
v_fact_play.sql
v_play_participation.sql
Canonical key definition
License register
Read-only · self-hosted · weekly snapshots are imported locally.