Game Day Weather

Use when you need every published snapshot for one game, oldest first. Pass gameId. Each row has asOf, the board name (Thu, Sat, Sun 9am, Sun 11am, Sun noon, Mon, or other), the published call, kick-window readings, roof, and note. A report-card grade is appended when that game has one. Returns those rows. flips lists each published call that left one call and landed on another, with gameId, from, to, and at. since is thursday when the latest call differs from the Thursday board, and prior when a snapshot differs from the previous snapshot. When the previous snapshot is the Thursday board and the calls and time match, since is thursday. Calls and readings are copied from published boards.

Use when you need games whose published call, roof, window, or kick-window reading moved since a time you give. Pass since (ISO time). Optional weekId; omit it for the current week. A reading counts at 10 or more rain-chance points, 3 mph sustained wind, 3°F on the low, or any wetField level. Roof changes count when the call holds. Going to final is not a call change. If no snapshot is at or before since, the week's first snapshot is the baseline. Returns those moves. flips lists each published call that left one call and landed on another, with gameId, from, to, and at. since is thursday when the current call differs from the Thursday board, and prior when it differs from the compared snapshot. When that snapshot is the Thursday board, since is thursday. Calls and readings are copied from published boards.

Use when you need every game whose published call is FLAG or WATCH, including domes. Optional weekId; omit it for the current week. Returns those games. For an outdoor kick-time checklist before Sunday lock, use get_sunday_lock_sheet.

Use when you need one game's published weather call. Pass team (a code such as BUF or NE) or gameId (such as 2026-w04-ne-buf). Optional weekId; omit it for the current week. A gameId selects that game's week when weekId is omitted. Returns that game plus asOf, stale, and nextUpdate.

Use when you need a published Sideline report card, the same cards as /report-cards. Optional week (1 to 18) or weekId (YYYY-wNN). Omit both for the newest published card. Returns that card and the season-to-date totals. Grades are historical. For the live weather call, use get_game.

Use before Sunday lock for a kick-time checklist of outdoor weather games that need a look. Prefer this over get_flags when the user wants that checklist. Optional weekId (YYYY-wNN); omit it for the current week. Returns FLAG and WATCH games whose roof is outdoor, or retractable and confirmed open, sorted by kickoff. Skips DOME, CLEAR, and closed or fixed roofs. Each game includes matchup, call, confidence, kickoff time, a one-sentence why, and the game page URL.

Use when you need published weather for NFL team codes on one week. Pass teams, such as ["PIT","HOU"]. Optional weekId; omit it for the current week. Each team includes the published call, kick-window readings, roof, and fantasy line. Unknown codes are returned in notFound. A team with no game that week is bye. Returns one row per code. GDW doesn't connect to fantasy platforms; pass team names.

Use when you need the full public board for one NFL week (regular season weeks 1 to 18). Returns every game, including the published call, note, chip, hours, and roof. Pass weekId (YYYY-wNN) or omit it for the current week, the same week as the homepage. After the last Week 18 kickoff window the current week stays on 18.