EDITIONID | SETID | TIER | MINTSIZE | EVENT_DATA | TIMESTAMP | EVENT_TYPE | PLAYID | TEAMNAME | FIRSTNAME | PLAYERLASTNAME | POSITION | PLAYERNUMBER | PLAYTYPE | GAMEDATE | DESCRIPTION | PLAYDATA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 3784 | 35 | RARE | 240 | {"id":"3784","maxMintSize":"240","playID":"3604","seriesID":"7","setID":... | 2025-01-06 15:13:25.215 | PlayCreated | 3604 | This Banner Year Moment commemorates the story of the 2024 Baltimore Ravens season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Baltimore Ravens | Team Melt | {"classification":"TEAM_MELT","id":"3604","metadata":[{"key":{"type":"St... | |||||
2 | 3785 | 35 | RARE | 240 | {"id":"3785","maxMintSize":"240","playID":"3605","seriesID":"7","setID":... | 2025-01-06 15:13:38.088 | PlayCreated | 3605 | This Banner Year Moment commemorates the story of the 2024 Buffalo Bills season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Buffalo Bills | Team Melt | {"classification":"TEAM_MELT","id":"3605","metadata":[{"key":{"type":"St... | |||||
3 | 3786 | 35 | RARE | 240 | {"id":"3786","maxMintSize":"240","playID":"3606","seriesID":"7","setID":... | 2025-01-06 15:13:48.304 | PlayCreated | 3606 | This Banner Year Moment commemorates the story of the 2024 Denver Broncos season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Denver Broncos | Team Melt | {"classification":"TEAM_MELT","id":"3606","metadata":[{"key":{"type":"St... | |||||
4 | 3787 | 35 | RARE | 240 | {"id":"3787","maxMintSize":"240","playID":"3607","seriesID":"7","setID":... | 2025-01-06 15:14:01.738 | PlayCreated | 3607 | This Banner Year Moment commemorates the story of the 2024 Detroit Lions season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Detroit Lions | Team Melt | {"classification":"TEAM_MELT","id":"3607","metadata":[{"key":{"type":"St... | |||||
5 | 3788 | 35 | RARE | 240 | {"id":"3788","maxMintSize":"240","playID":"3608","seriesID":"7","setID":... | 2025-01-06 15:14:13.321 | PlayCreated | 3608 | This Banner Year Moment commemorates the story of the 2024 Green Bay Packers season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Green Bay Packers | Team Melt | {"classification":"TEAM_MELT","id":"3608","metadata":[{"key":{"type":"St... | |||||
6 | 3789 | 35 | RARE | 240 | {"id":"3789","maxMintSize":"240","playID":"3609","seriesID":"7","setID":... | 2025-01-06 15:14:22.858 | PlayCreated | 3609 | This Banner Year Moment commemorates the story of the 2024 Houston Texans season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Houston Texans | Team Melt | {"classification":"TEAM_MELT","id":"3609","metadata":[{"key":{"type":"St... | |||||
7 | 3790 | 35 | RARE | 240 | {"id":"3790","maxMintSize":"240","playID":"3610","seriesID":"7","setID":... | 2025-01-06 15:14:34.226 | PlayCreated | 3610 | This Banner Year Moment commemorates the story of the 2024 Kansas City Chiefs season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Kansas City Chiefs | Team Melt | {"classification":"TEAM_MELT","id":"3610","metadata":[{"key":{"type":"St... | |||||
8 | 3791 | 35 | RARE | 240 | {"id":"3791","maxMintSize":"240","playID":"3611","seriesID":"7","setID":... | 2025-01-06 15:14:49.042 | PlayCreated | 3611 | This Banner Year Moment commemorates the story of the 2024 Los Angeles Chargers season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Los Angeles Chargers | Team Melt | {"classification":"TEAM_MELT","id":"3611","metadata":[{"key":{"type":"St... | |||||
9 | 3792 | 35 | RARE | 240 | {"id":"3792","maxMintSize":"240","playID":"3612","seriesID":"7","setID":... | 2025-01-06 15:15:01.362 | PlayCreated | 3612 | This Banner Year Moment commemorates the story of the 2024 Los Angeles Rams season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Los Angeles Rams | Team Melt | {"classification":"TEAM_MELT","id":"3612","metadata":[{"key":{"type":"St... | |||||
10 | 3793 | 35 | RARE | 240 | {"id":"3793","maxMintSize":"240","playID":"3613","seriesID":"7","setID":... | 2025-01-06 15:15:10.782 | PlayCreated | 3613 | This Banner Year Moment commemorates the story of the 2024 Minnesota Vikings season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Minnesota Vikings | Team Melt | {"classification":"TEAM_MELT","id":"3613","metadata":[{"key":{"type":"St... | |||||
11 | 3794 | 35 | RARE | 240 | {"id":"3794","maxMintSize":"240","playID":"3614","seriesID":"7","setID":... | 2025-01-06 15:15:22.513 | PlayCreated | 3614 | This Banner Year Moment commemorates the story of the 2024 Philadelphia Eagles season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Philadelphia Eagles | Team Melt | {"classification":"TEAM_MELT","id":"3614","metadata":[{"key":{"type":"St... | |||||
12 | 3795 | 35 | RARE | 240 | {"id":"3795","maxMintSize":"240","playID":"3615","seriesID":"7","setID":... | 2025-01-06 15:15:36.356 | PlayCreated | 3615 | This Banner Year Moment commemorates the story of the 2024 Pittsburgh Steelers season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Pittsburgh Steelers | Team Melt | {"classification":"TEAM_MELT","id":"3615","metadata":[{"key":{"type":"St... | |||||
13 | 3796 | 35 | RARE | 240 | {"id":"3796","maxMintSize":"240","playID":"3616","seriesID":"7","setID":... | 2025-01-06 15:15:49.311 | PlayCreated | 3616 | This Banner Year Moment commemorates the story of the 2024 Tampa Bay Buccaneers season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Tampa Bay Buccaneers | Team Melt | {"classification":"TEAM_MELT","id":"3616","metadata":[{"key":{"type":"St... | |||||
14 | 3797 | 35 | RARE | 240 | {"id":"3797","maxMintSize":"240","playID":"3617","seriesID":"7","setID":... | 2025-01-06 15:16:01.815 | PlayCreated | 3617 | This Banner Year Moment commemorates the story of the 2024 Washington Commanders season. It includes five plays from regular season wins, and will be updated following the NFL Playoffs with a play from each Playoff game the team plays in - emphasis on teamwork, scoring plays, turnovers, memorable reactions or plays late in the game. | Washington Commanders | Team Melt | {"classification":"TEAM_MELT","id":"3617","metadata":[{"key":{"type":"St... | |||||
15 | 3798 | 16 | LEGENDARY | 49 | {"id":"3798","maxMintSize":"49","playID":"3618","seriesID":"7","setID":"... | 2025-01-07 14:42:53.703 | PlayCreated | 3618 | Houston Texans | Kamari | Lassiter | DB | 4 | Safety | 12/25/2024 | "Not many defensive backs have the strength and confidence to take on De... | {"classification":"PLAYER_GAME","id":"3618","metadata":[{"key":{"type":"... |
16 | 3799 | 16 | LEGENDARY | 49 | {"id":"3799","maxMintSize":"49","playID":"3619","seriesID":"7","setID":"... | 2025-01-07 14:44:58.102 | PlayCreated | 3619 | Minnesota Vikings | Dallas | Turner | LB | 15 | Interception | 12/22/2024 | "Dropping back into coverage and showing off his diverse skillset as an ... | {"classification":"PLAYER_GAME","id":"3619","metadata":[{"key":{"type":"... |
17 | 3800 | 16 | LEGENDARY | 49 | {"id":"3800","maxMintSize":"49","playID":"3620","seriesID":"7","setID":"... | 2025-01-07 14:45:11.857 | PlayCreated | 3620 | New Orleans Saints | Spencer | Rattler | QB | 18 | Pass | 12/29/2024 | "Why not add a little trickery to the game plan to aid your rookie signa... | {"classification":"PLAYER_GAME","id":"3620","metadata":[{"key":{"type":"... |
18 | 3801 | 16 | LEGENDARY | 49 | {"id":"3801","maxMintSize":"49","playID":"3621","seriesID":"7","setID":"... | 2025-01-07 14:45:23.063 | PlayCreated | 3621 | Tampa Bay Buccaneers | Jalen | McMillan | WR | 15 | Player Melt | 12/29/2024 | "Continuing his remarkable late-season stretch that has seen him find th... | {"classification":"PLAYER_MELT","id":"3621","metadata":[{"key":{"type":"... |
19 | 3802 | 97 | LEGENDARY | 49 | {"id":"3802","maxMintSize":"49","playID":"3622","seriesID":"7","setID":"... | 2025-01-07 14:45:34.679 | PlayCreated | 3622 | Cincinnati Bengals | Tee | Higgins | WR | 5 | Player Melt | 12/28/2024 | "With an incredibly talented, 6'4" receiver on the roster, the question ... | {"classification":"PLAYER_MELT","id":"3622","metadata":[{"key":{"type":"... |
20 | 3803 | 97 | LEGENDARY | 49 | {"id":"3803","maxMintSize":"49","playID":"3623","seriesID":"7","setID":"... | 2025-01-07 14:45:45.359 | PlayCreated | 3623 | Dallas Cowboys | CeeDee | Lamb | WR | 88 | Player Melt | 12/09/2024 | "When the lights are brightest, Cowboys star CeeDee Lamb is going to shi... | {"classification":"PLAYER_MELT","id":"3623","metadata":[{"key":{"type":"... |
adamoyahknow-VupHe3tart-blue
Updated 2025-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Play and Edition metadata since a given date
WITH Plays AS (
SELECT
CONVERT_TIMEZONE('UTC', 'America/Los_Angeles', fe.block_timestamp) AS timestamp,
fe.event_type,
fe.event_data:id AS PlayId,
fe.event_data:metadata[2].value.value AS teamName,
fe.event_data:metadata[11].value.value AS FirstName,
fe.event_data:metadata[9].value.value AS playerLastName,
fe.event_data:metadata[10].value.value AS Position,
fe.event_data:metadata[6].value.value AS playerNumber,
fe.event_data:metadata[1].value.value AS playType,
fe.event_data:metadata[0].value.value AS gameDate,
'"' || fe.event_data:metadata[3].value.value || '"' AS description,
fe.event_data AS playdata
FROM flow.core.fact_events fe
WHERE fe.event_contract = 'A.e4cf4bdc1751c65d.AllDay'
AND fe.event_type = 'PlayCreated'
AND DATE(fe.block_timestamp) > {{FromDt}} -- Replace with e.g. '2024-12-01'
ORDER BY fe.block_timestamp, fe.event_index
)
SELECT
fe.event_data:id AS EditionId,
fe.event_data:setID AS SetId,
fe.event_data:tier AS tier,
fe.event_data:maxMintSize AS MintSize,
fe.event_data,
p.*
FROM Plays p
LEFT JOIN flow.core.fact_events fe
ON fe.event_data:playID = p.PlayId
WHERE fe.event_contract = 'A.e4cf4bdc1751c65d.AllDay'
AND fe.event_type = 'EditionCreated'
AND DATE(fe.block_timestamp) > {{FromDt}}
ORDER BY fe.block_timestamp, fe.event_index;
Last run: about 1 month ago
...
309
792KB
5s