⌘K commands · ? keys
Play by play
One play: the situation, what happened and the engine's aggregates over plays.
- One row
play_id· per play- Stamped at
- play time Join on this time to read only what was known.
- Known at
- After final (22)
- Source
- League and data-provider feeds
Fields (22)
Operators: sport: dataset: role: known: grain: entity: type: in: status: -word "a phrase" name:/^opp_/. Try , , , , .
Matching (22) of (22) fieldsOrder: most widely usable, then name
Showing (22) of (22) · Fields
| Formula name | Label | Known at | Role | Sports | Dataset | Type | Grain |
|---|---|---|---|---|---|---|---|
| after | Down, distance, yards to the goal and spot after the play | After final | feature | Any sport | Play by play | number | play |
| before | Down, distance, yards to the goal and spot before the play | After final | feature | Any sport | Play by play | number | play |
| big | A big play: a 20+ yard pass, a 10+ yard run, a turnover or a score | After final | feature | Any sport | Play by play | number | play |
| clock | The game clock at the play | After final | feature | Any sport | Play by play | number | play |
| corrected | On a corrected play: the earlier text and when it changed | After final | feature | Any sport | Play by play | number | play |
| drive_id | The play's drive (the provider's drive ID, or null) | After final | identifier | Any sport | Play by play | id | play |
| id | Play ID (ply_), stable per provider play | After final | identifier | Any sport | Play by play | id | play |
| ingest_ts | When Kelly stored this version of the play | After final | dimension | Any sport | Play by play | datetime | play |
| kind | Kelly's play kind (run, pass, sack, kick, punt, field_goal, ...) | After final | feature | Any sport | Play by play | number | play |
| latency_ms | Milliseconds from the play's wallclock to Kelly first storing it | After final | feature | Any sport | Play by play | number | play |
| period | The play's period (Q1..Q4, OT) | After final | feature | Any sport | Play by play | number | play |
| players | Players in the play (player_id, name, role, yards, position, points, stats) | After final | feature | Any sport | Play by play | number | play |
| score | The score after the play | After final | feature | Any sport | Play by play | number | play |
| scoring | Whether the play scored | After final | feature | Any sport | Play by play | number | play |
| seq | The play's place in the game, numbered by Kelly in arrival order (kept through corrections) | After final | feature | Any sport | Play by play | number | play |
| source | The play's source (a register source key) | After final | feature | Any sport | Play by play | number | play |
| source_ts | Upstream time of the play | After final | dimension | Any sport | Play by play | datetime | play |
| team_id | The offence (tm_) | After final | identifier | Any sport | Play by play | id | play |
| text | The play in Kelly's words (template-written) | After final | feature | Any sport | Play by play | number | play |
| wallclock | When the play happened (the provider's time) | After final | feature | Any sport | Play by play | number | play |
| win_prob_home | The provider's home win probability after the play | After final | price | Any sport | Play by play | probability | play |
| yards | Yards the play gained | After final | feature | Any sport | Play by play | number | play |