Cincinnati Bengals vs. Washington Commanders: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare players and teams or see head to head results between teams, players, or player vs. team. Data Coverage

THIS QUESTION WAS ANSWERED USING

Your All Access Pass to the Pro Football Database Go beyond the basics. Become a Stathead

--------------------------------------

header_comp

WITH
  t1 AS (
SELECT team_id, SUM(win AND type="reg") as rsw, SUM(loss AND type="reg") as rsl, SUM(tie AND type="reg") as rst, SUM(win AND type="post") as pow, SUM(loss AND type="post") as pol
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?  
  ),
  t2 AS (
SELECT team_id, SUM(win AND type="reg") as rsw, SUM(loss AND type="reg") as rsl, SUM(tie AND type="reg") as rst, SUM(win AND type="post") as pow, SUM(loss AND type="post") as pol
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?  
  )
SELECT team_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, SUM(games) AS games, SUM(wins) AS wins, SUM(losses) AS losses, IF(SUM(wins)+SUM(losses), (SUM(wins)+IF(year_id > 1971,0.5*SUM(ties),0))/(SUM(wins)+SUM(losses)+IF(year_id > 1971,SUM(ties),0)), NULL) as win_loss_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(wins)+SUM(losses), (SUM(wins)+IF(year_id > 1971,0.5*SUM(ties),0))/(SUM(wins)+SUM(losses)+IF(year_id > 1971,SUM(ties),0)), NULL),3)) AS win_loss_pct, SUM(points)/SUM(games) as team_ppg_csk, ROUND(SUM(points)/SUM(games),1) AS team_ppg, SUM(points_opp)/SUM(games) as team_oppg_csk, ROUND(SUM(points_opp)/SUM(games),1) AS team_oppg, SUM(is_playoff_team) AS is_playoff_team, SUM(is_conf_champion) AS is_conf_champion, SUM(is_champion) AS is_champion
FROM sup_team_seasons as ts
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN (SELECT t1.team_id, t1.rsw as rs_wins, t1.rsl as rs_losses, t1.rst as rs_ties, t1.pow as po_wins, t1.pol as po_losses FROM t1
  UNION SELECT t2.team_id, t2.rsw as rs_wins, t2.rsl as rs_losses, t2.rst as rs_ties, t2.pow as po_wins, t2.pol as po_losses
FROM t2) as xxx USING (team_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id
ORDER BY team_id 

SQL PARAMS -- $VAR1 = [
          'cin',
          'was',
          'was',
          'cin',
          'cin',
          'was'
        ];

--------------------------------------

h2h_gamelogs

Page Setup Time: 0.00067 seconds

SELECT IF(away_team_id="cin","@","") as loc, IF(away_team_id="cin",away_score,home_score) as team1_score, IF(away_team_id="was",away_score,home_score) as team2_score, game_id, date, game_id, sup_games.link as game_link, sup_venue_seasons.name as venue_name, city as venue_city, IF(overtimes, IF(overtimes>1, CONCAT(overtimes,"OT"), "OT"), "") as overtimes
FROM sup_games
  JOIN (SELECT game_id, year_id, comp_id, phase_id, team_id as away_team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral FROM sup_team_games) as tg USING (game_id, away_team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  LEFT JOIN sup_venues USING (venue_id)
  LEFT JOIN sup_venue_seasons USING (venue_id, year_id)
WHERE ((away_team_id=? AND home_team_id=?) OR (away_team_id=? AND home_team_id=?))
  AND home_score IS NOT NULL
  AND type="reg" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'cin',
          'was',
          'was',
          'cin'
        ];

Query Time: 0.04 seconds
SELECT IF(away_team_id="cin","@","") as loc, IF(away_team_id="cin",away_score,home_score) as team1_score, IF(away_team_id="was",away_score,home_score) as team2_score, game_id, date, game_id, sup_games.link as game_link, sup_venue_seasons.name as venue_name, city as venue_city, IF(overtimes, IF(overtimes>1, CONCAT(overtimes,"OT"), "OT"), "") as overtimes
FROM sup_games
  JOIN (SELECT game_id, year_id, comp_id, phase_id, team_id as away_team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral FROM sup_team_games) as tg USING (game_id, away_team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  LEFT JOIN sup_venues USING (venue_id)
  LEFT JOIN sup_venue_seasons USING (venue_id, year_id)
WHERE ((away_team_id=? AND home_team_id=?) OR (away_team_id=? AND home_team_id=?))
  AND home_score IS NOT NULL
  AND type="post" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'cin',
          'was',
          'was',
          'cin'
        ];

Query Time: 0.04 seconds
Table Build Time: 0.04 seconds


--------------------------------------

h2h_records

Page Setup Time: 0.00043 seconds

WITH
  tr1 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(points) AS points
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id 
  ),
  tr2 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(points) AS points
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id 
  )
SELECT year_id as year_id_csk, year_id as year_id, tr1.comp_id, tr1.games AS tr1_games, tr2.games AS tr2_games, tr1.wins AS tr1_wins, tr2.wins AS tr2_wins, tr1.losses AS tr1_losses, tr2.losses AS tr2_losses, tr1.points AS tr1_points, tr2.points AS tr2_points
FROM tr1
  JOIN tr2 USING (year_id)
WHERE 1 
GROUP BY year_id
ORDER BY year_id 

SQL PARAMS -- $VAR1 = [
          'cin',
          'was',
          'was',
          'cin'
        ];

Query Time: 0.02 seconds
WITH
  tr1 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(points) AS points
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id 
  ),
  tr2 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(points) AS points
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id 
  )
SELECT year_id as year_id_csk, year_id as year_id, tr1.comp_id, tr1.games AS tr1_games, tr2.games AS tr2_games, tr1.wins AS tr1_wins, tr2.wins AS tr2_wins, tr1.losses AS tr1_losses, tr2.losses AS tr2_losses, tr1.points AS tr1_points, tr2.points AS tr2_points
FROM tr1
  JOIN tr2 USING (year_id)
WHERE 1 
GROUP BY year_id
ORDER BY year_id 

SQL PARAMS -- $VAR1 = [
          'cin',
          'was',
          'was',
          'cin'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds


--------------------------------------

h2h_pass

Page Setup Time: 0.00164 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_cmp) AS pass_cmp, SUM(pass_att) AS pass_att, (SUM(pass_att)-SUM(pass_cmp)) AS pass_inc, IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds) AS pass_yds, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int, SUM(int_ret_td) AS int_ret_td, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL)),1) AS pass_td_pct, IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL) as pass_int_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL)),1) AS pass_int_pct, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds) AS pass_sacked_yds, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL) as pass_sacked_pct_csk, ROUND(100 * (IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL)),2) AS pass_sacked_pct, IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL),1) AS pass_yds_per_att, IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL),2) AS pass_adj_yds_per_att, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL) as pass_adj_net_yds_per_att_csk, ROUND(IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL),2) AS pass_adj_net_yds_per_att, IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL) as pass_yds_per_cmp_csk, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.02 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_cmp) AS pass_cmp, SUM(pass_att) AS pass_att, (SUM(pass_att)-SUM(pass_cmp)) AS pass_inc, IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds) AS pass_yds, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int, SUM(int_ret_td) AS int_ret_td, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL)),1) AS pass_td_pct, IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL) as pass_int_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL)),1) AS pass_int_pct, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds) AS pass_sacked_yds, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL) as pass_sacked_pct_csk, ROUND(100 * (IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL)),2) AS pass_sacked_pct, IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL),1) AS pass_yds_per_att, IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL),2) AS pass_adj_yds_per_att, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL) as pass_adj_net_yds_per_att_csk, ROUND(IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL),2) AS pass_adj_net_yds_per_att, IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL) as pass_yds_per_cmp_csk, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.03 seconds


--------------------------------------

h2h_rec

Page Setup Time: 0.00053 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.02 seconds


--------------------------------------

h2h_kick

Page Setup Time: 0.00093 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(xpm) AS xpm, SUM(xpa) AS xpa, IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL) as xp_pct_csk, ROUND(100 * (IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL)),1) AS xp_pct, SUM(fgm) AS fgm, SUM(fga) AS fga, IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL) as fg_pct_csk, ROUND(100 * (IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL)),1) AS fg_pct, SUM(two_pt_md) AS two_pt_md, SUM(punt) AS punt, SUM(punt_yds) AS punt_yds, IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL) as punt_yds_per_punt_csk, ROUND(IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL),1) AS punt_yds_per_punt, SUM(punt_blocked) AS punt_blocked
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(xpm) AS xpm, SUM(xpa) AS xpa, IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL) as xp_pct_csk, ROUND(100 * (IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL)),1) AS xp_pct, SUM(fgm) AS fgm, SUM(fga) AS fga, IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL) as fg_pct_csk, ROUND(100 * (IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL)),1) AS fg_pct, SUM(two_pt_md) AS two_pt_md, SUM(punt) AS punt, SUM(punt_yds) AS punt_yds, IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL) as punt_yds_per_punt_csk, ROUND(IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL),1) AS punt_yds_per_punt, SUM(punt_blocked) AS punt_blocked
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.03 seconds


--------------------------------------

h2h_return

Page Setup Time: 0.00120 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td) AS punt_ret_td
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td) AS punt_ret_td
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.04 seconds


--------------------------------------

h2h_defense

Page Setup Time: 0.00107 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_sacked_opp) AS pass_sacked_opp, SUM(tackles_loss) AS tackles_loss, SUM(qb_knockdown) AS qb_knockdown, SUM(pressures) AS pressures, SUM(def_int) AS def_int, SUM(def_int_td) AS def_int_td, SUM(fumbles) AS fumbles, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced) AS fumbles_forced
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_sacked_opp) AS pass_sacked_opp, SUM(tackles_loss) AS tackles_loss, SUM(qb_knockdown) AS qb_knockdown, SUM(pressures) AS pressures, SUM(def_int) AS def_int, SUM(def_int_td) AS def_int_td, SUM(fumbles) AS fumbles, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced) AS fumbles_forced
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.04 seconds


--------------------------------------

sum_pass

Page Setup Time: 0.00307 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_cmp IS NULL) as pass_cmp_incomplete, SUM(pass_cmp) AS pass_cmp, SUM(pass_att IS NULL) as pass_att_incomplete, SUM(pass_att) AS pass_att, SUM(pass_cmp IS NULL)+SUM(pass_att IS NULL) as pass_inc_incomplete, (SUM(pass_att)-SUM(pass_cmp)) AS pass_inc, IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL) as pass_cmp_pct_csk, SUM(pass_att IS NULL)+SUM(pass_cmp IS NULL) as pass_cmp_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds IS NULL) as pass_yds_incomplete, SUM(pass_yds) AS pass_yds, SUM(pass_td IS NULL) as pass_td_incomplete, SUM(pass_td) AS pass_td, SUM(pass_int IS NULL) as pass_int_incomplete, SUM(pass_int) AS pass_int, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, SUM(pass_att IS NULL)+SUM(pass_td IS NULL) as pass_td_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL)),1) AS pass_td_pct, IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL) as pass_int_pct_csk, SUM(pass_int IS NULL)+SUM(pass_att IS NULL) as pass_int_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL)),1) AS pass_int_pct, IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  )
  as pass_rating_csk, SUM(pass_int IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_att IS NULL)+SUM(pass_td IS NULL)+SUM(pass_cmp IS NULL) as pass_rating_incomplete, ROUND(IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ),
  1) AS pass_rating, SUM(pass_sacked IS NULL) as pass_sacked_incomplete, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds IS NULL) as pass_sacked_yds_incomplete, SUM(pass_sacked_yds) AS pass_sacked_yds, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL) as pass_sacked_pct_csk, SUM(pass_sacked IS NULL)+SUM(pass_att IS NULL) as pass_sacked_pct_incomplete, ROUND(100 * (IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL)),2) AS pass_sacked_pct, IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL) as pass_yds_per_att_csk, SUM(pass_yds IS NULL)+SUM(pass_att IS NULL) as pass_yds_per_att_incomplete, ROUND(IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL),1) AS pass_yds_per_att, IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL) as pass_adj_yds_per_att_csk, SUM(pass_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_int IS NULL)+SUM(pass_td IS NULL) as pass_adj_yds_per_att_incomplete, ROUND(IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL),2) AS pass_adj_yds_per_att, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL) as pass_adj_net_yds_per_att_csk, SUM(pass_td IS NULL)+SUM(pass_sacked_yds IS NULL)+SUM(pass_sacked IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_int IS NULL) as pass_adj_net_yds_per_att_incomplete, ROUND(IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL),2) AS pass_adj_net_yds_per_att, IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL) as pass_yds_per_cmp_csk, SUM(pass_yds IS NULL)+SUM(pass_cmp IS NULL) as pass_yds_per_cmp_incomplete, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_cmp IS NULL) as pass_cmp_incomplete, SUM(pass_cmp) AS pass_cmp, SUM(pass_att IS NULL) as pass_att_incomplete, SUM(pass_att) AS pass_att, SUM(pass_cmp IS NULL)+SUM(pass_att IS NULL) as pass_inc_incomplete, (SUM(pass_att)-SUM(pass_cmp)) AS pass_inc, IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL) as pass_cmp_pct_csk, SUM(pass_att IS NULL)+SUM(pass_cmp IS NULL) as pass_cmp_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds IS NULL) as pass_yds_incomplete, SUM(pass_yds) AS pass_yds, SUM(pass_td IS NULL) as pass_td_incomplete, SUM(pass_td) AS pass_td, SUM(pass_int IS NULL) as pass_int_incomplete, SUM(pass_int) AS pass_int, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, SUM(pass_att IS NULL)+SUM(pass_td IS NULL) as pass_td_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL)),1) AS pass_td_pct, IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL) as pass_int_pct_csk, SUM(pass_int IS NULL)+SUM(pass_att IS NULL) as pass_int_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL)),1) AS pass_int_pct, IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  )
  as pass_rating_csk, SUM(pass_int IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_att IS NULL)+SUM(pass_td IS NULL)+SUM(pass_cmp IS NULL) as pass_rating_incomplete, ROUND(IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ),
  1) AS pass_rating, SUM(pass_sacked IS NULL) as pass_sacked_incomplete, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds IS NULL) as pass_sacked_yds_incomplete, SUM(pass_sacked_yds) AS pass_sacked_yds, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL) as pass_sacked_pct_csk, SUM(pass_sacked IS NULL)+SUM(pass_att IS NULL) as pass_sacked_pct_incomplete, ROUND(100 * (IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL)),2) AS pass_sacked_pct, IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL) as pass_yds_per_att_csk, SUM(pass_yds IS NULL)+SUM(pass_att IS NULL) as pass_yds_per_att_incomplete, ROUND(IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL),1) AS pass_yds_per_att, IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL) as pass_adj_yds_per_att_csk, SUM(pass_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_int IS NULL)+SUM(pass_td IS NULL) as pass_adj_yds_per_att_incomplete, ROUND(IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL),2) AS pass_adj_yds_per_att, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL) as pass_adj_net_yds_per_att_csk, SUM(pass_td IS NULL)+SUM(pass_sacked_yds IS NULL)+SUM(pass_sacked IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_int IS NULL) as pass_adj_net_yds_per_att_incomplete, ROUND(IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL),2) AS pass_adj_net_yds_per_att, IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL) as pass_yds_per_cmp_csk, SUM(pass_yds IS NULL)+SUM(pass_cmp IS NULL) as pass_yds_per_cmp_incomplete, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


--------------------------------------

sum_rec

Page Setup Time: 0.00055 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(rush_att IS NULL) as rush_att_incomplete, SUM(rush_att) AS rush_att, SUM(rush_yds IS NULL) as rush_yds_incomplete, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, SUM(rush_att IS NULL)+SUM(rush_yds IS NULL) as rush_yds_per_att_incomplete, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td IS NULL) as rush_td_incomplete, SUM(rush_td) AS rush_td, SUM(rush_first_down IS NULL) as rush_first_down_incomplete, SUM(rush_first_down) AS rush_first_down
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.00 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(rush_att IS NULL) as rush_att_incomplete, SUM(rush_att) AS rush_att, SUM(rush_yds IS NULL) as rush_yds_incomplete, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, SUM(rush_att IS NULL)+SUM(rush_yds IS NULL) as rush_yds_per_att_incomplete, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td IS NULL) as rush_td_incomplete, SUM(rush_td) AS rush_td, SUM(rush_first_down IS NULL) as rush_first_down_incomplete, SUM(rush_first_down) AS rush_first_down
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


--------------------------------------

sum_kick

Page Setup Time: 0.00099 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(xpm IS NULL) as xpm_incomplete, SUM(xpm) AS xpm, SUM(xpa IS NULL) as xpa_incomplete, SUM(xpa) AS xpa, IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL) as xp_pct_csk, SUM(xpm IS NULL)+SUM(xpa IS NULL) as xp_pct_incomplete, ROUND(100 * (IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL)),1) AS xp_pct, SUM(fgm IS NULL) as fgm_incomplete, SUM(fgm) AS fgm, SUM(fga IS NULL) as fga_incomplete, SUM(fga) AS fga, IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL) as fg_pct_csk, SUM(fgm IS NULL)+SUM(fga IS NULL) as fg_pct_incomplete, ROUND(100 * (IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL)),1) AS fg_pct, SUM(two_pt_md IS NULL) as two_pt_md_incomplete, SUM(two_pt_md) AS two_pt_md, SUM(punt IS NULL) as punt_incomplete, SUM(punt) AS punt, SUM(punt_yds IS NULL) as punt_yds_incomplete, SUM(punt_yds) AS punt_yds, IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL) as punt_yds_per_punt_csk, SUM(punt_yds IS NULL)+SUM(punt IS NULL) as punt_yds_per_punt_incomplete, ROUND(IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL),1) AS punt_yds_per_punt, SUM(punt_blocked IS NULL) as punt_blocked_incomplete, SUM(punt_blocked) AS punt_blocked
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(xpm IS NULL) as xpm_incomplete, SUM(xpm) AS xpm, SUM(xpa IS NULL) as xpa_incomplete, SUM(xpa) AS xpa, IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL) as xp_pct_csk, SUM(xpm IS NULL)+SUM(xpa IS NULL) as xp_pct_incomplete, ROUND(100 * (IF(SUM(xpa), SUM(IF(IFNULL(xpa,0),xpm,0))/SUM(IF(IFNULL(xpa,0),xpa,0)), NULL)),1) AS xp_pct, SUM(fgm IS NULL) as fgm_incomplete, SUM(fgm) AS fgm, SUM(fga IS NULL) as fga_incomplete, SUM(fga) AS fga, IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL) as fg_pct_csk, SUM(fgm IS NULL)+SUM(fga IS NULL) as fg_pct_incomplete, ROUND(100 * (IF(SUM(fga), SUM(IF(IFNULL(fga,0),fgm,0))/SUM(IF(IFNULL(fga,0),fga,0)), NULL)),1) AS fg_pct, SUM(two_pt_md IS NULL) as two_pt_md_incomplete, SUM(two_pt_md) AS two_pt_md, SUM(punt IS NULL) as punt_incomplete, SUM(punt) AS punt, SUM(punt_yds IS NULL) as punt_yds_incomplete, SUM(punt_yds) AS punt_yds, IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL) as punt_yds_per_punt_csk, SUM(punt_yds IS NULL)+SUM(punt IS NULL) as punt_yds_per_punt_incomplete, ROUND(IF(SUM(punt), SUM(punt_yds)/SUM(punt), NULL),1) AS punt_yds_per_punt, SUM(punt_blocked IS NULL) as punt_blocked_incomplete, SUM(punt_blocked) AS punt_blocked
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.05 seconds

Table Build Time: 0.03 seconds


--------------------------------------

sum_return

Page Setup Time: 0.00074 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(kick_ret IS NULL) as kick_ret_incomplete, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds IS NULL) as kick_ret_yds_incomplete, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, SUM(kick_ret_yds IS NULL)+SUM(kick_ret IS NULL) as kick_ret_yds_per_ret_incomplete, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td IS NULL) as kick_ret_td_incomplete, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret IS NULL) as punt_ret_incomplete, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds IS NULL) as punt_ret_yds_incomplete, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, SUM(punt_ret IS NULL)+SUM(punt_ret_yds IS NULL) as punt_ret_yds_per_ret_incomplete, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td IS NULL) as punt_ret_td_incomplete, SUM(punt_ret_td) AS punt_ret_td
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.00 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(kick_ret IS NULL) as kick_ret_incomplete, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds IS NULL) as kick_ret_yds_incomplete, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, SUM(kick_ret_yds IS NULL)+SUM(kick_ret IS NULL) as kick_ret_yds_per_ret_incomplete, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td IS NULL) as kick_ret_td_incomplete, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret IS NULL) as punt_ret_incomplete, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds IS NULL) as punt_ret_yds_incomplete, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, SUM(punt_ret IS NULL)+SUM(punt_ret_yds IS NULL) as punt_ret_yds_per_ret_incomplete, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td IS NULL) as punt_ret_td_incomplete, SUM(punt_ret_td) AS punt_ret_td
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


--------------------------------------

sum_defense

Page Setup Time: 0.00102 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_sacked_opp IS NULL) as pass_sacked_opp_incomplete, SUM(pass_sacked_opp) AS pass_sacked_opp, SUM(tackles_loss IS NULL) as tackles_loss_incomplete, SUM(tackles_loss) AS tackles_loss, SUM(qb_knockdown IS NULL) as qb_knockdown_incomplete, SUM(qb_knockdown) AS qb_knockdown, SUM(pressures IS NULL) as pressures_incomplete, SUM(pressures) AS pressures, SUM(def_int IS NULL) as def_int_incomplete, SUM(def_int) AS def_int, SUM(def_int_td IS NULL) as def_int_td_incomplete, SUM(def_int_td) AS def_int_td, SUM(fumbles IS NULL) as fumbles_incomplete, SUM(fumbles) AS fumbles, SUM(fumbles_rec IS NULL) as fumbles_rec_incomplete, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds IS NULL) as fumbles_rec_yds_incomplete, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td IS NULL) as fumbles_rec_td_incomplete, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced IS NULL) as fumbles_forced_incomplete, SUM(fumbles_forced) AS fumbles_forced
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.00 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(pass_sacked_opp IS NULL) as pass_sacked_opp_incomplete, SUM(pass_sacked_opp) AS pass_sacked_opp, SUM(tackles_loss IS NULL) as tackles_loss_incomplete, SUM(tackles_loss) AS tackles_loss, SUM(qb_knockdown IS NULL) as qb_knockdown_incomplete, SUM(qb_knockdown) AS qb_knockdown, SUM(pressures IS NULL) as pressures_incomplete, SUM(pressures) AS pressures, SUM(def_int IS NULL) as def_int_incomplete, SUM(def_int) AS def_int, SUM(def_int_td IS NULL) as def_int_td_incomplete, SUM(def_int_td) AS def_int_td, SUM(fumbles IS NULL) as fumbles_incomplete, SUM(fumbles) AS fumbles, SUM(fumbles_rec IS NULL) as fumbles_rec_incomplete, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds IS NULL) as fumbles_rec_yds_incomplete, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td IS NULL) as fumbles_rec_td_incomplete, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced IS NULL) as fumbles_forced_incomplete, SUM(fumbles_forced) AS fumbles_forced
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'cin',
          'was'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          't1yrto' => 2025,
          'team_id1' => 'cin',
          'match' => 'versus_teamvteam',
          't2yrto' => 2025,
          'team_id2' => 'was'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'team_id1' => 'cin',
          'match' => 'versus_teamvteam',
          'team_id2' => 'was'
        };

Show Criteria

Compare Players

Head-to-head stats or multi-player comparisons

Compare Teams

Head-to-head results and comparisons

Player vs. Team

Head-to-head stats for a single player against a team

Search Criteria

Seasons

All seasons

Choose season(s) for each choice

Choose same season(s) for all choices

Team 1

Team 2

Clear All

You have edited your search criteria

or keep editing your search

clear changes

Fetching Results

Cincinnati Bengals

Washington Commanders

5-6-1

Reg Season

6-5-1

899

407

487

.455

21.1

22.2

W-L%

PS/G

PA/G

Playoff Apps.

Finals Apps.

Championships

1330

644

657

.495

20.0

20.6

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Stats

Cincinnati Bengals vs. Washington Commanders: Recent Games

Regular Season

Subscribe to Stathead Pro Football for full results.

Go inside the Pro Football database and access the sports search engine that was made for fans like you. Subscriptions start at just $9/month. Learn More.

Get your first month FREE

Already a paid subscriber? Log in for full results.

Cincinnati Bengals vs. Washington Commanders: Recent Games Table
Rk	Date	CIN		WAS	OT	Venue	City
1	2024-09-23	33		38		Paycor Stadium	Cincinnati
2	2020-11-22	9	@	20		FedExField	Landover
3	2016-10-30	27		27	OT	Wembley Stadium	London
4	2012-09-23	38	@	31		FedExField	Landover
5	2008-12-14	20		13		Paul Brown Stadium	Cincinnati
6	2004-11-14	17	@	10		FedExField	Landover
7	1991-09-22	27		34		Riverfront Stadium	Cincinnati
8	1988-12-17	20		17	OT	Riverfront Stadium	Cincinnati
9	1985-12-15	24	@	27		Robert F. Kennedy Memorial Stadium	Washington
10	1979-12-09	14	@	28		Robert F. Kennedy Memorial Stadium	Washington

Cincinnati Bengals vs. Washington Commanders: Yearly Records

Regular Season

Cincinnati Bengals vs. Washington Commanders: Yearly Records Table
		Cincinnati Bengals				Washington Commanders
Rk	Season	G	W	L	Pts	G	W	L	Pts
1	1970	1	0	1	0	1	1	0	20
2	1974	1	1	0	28	1	0	1	17
3	1979	1	0	1	14	1	1	0	28
4	1985	1	0	1	24	1	1	0	27
5	1988	1	1	0	20	1	0	1	17
6	1991	1	0	1	27	1	1	0	34
7	2004	1	1	0	17	1	0	1	10
8	2008	1	1	0	20	1	0	1	13
9	2012	1	1	0	38	1	0	1	31
10	2016	1	0	0	27	1	0	0	27
11	2020	1	0	1	9	1	1	0	20
12	2024	1	0	1	33	1	1	0	38
	Totals	12	5	6	257	12	6	5	282

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Passing Totals

Regular Season

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Passing Totals Table
Rk	Team	From	To	Cmp	Att	Inc	Cmp%	Yds	TD	Int	IntTD	TD%	Int%	Sk	Yds	Sk%	Y/A	AY/A	ANY/A	Y/C
1	CIN	1970	2024	235	398	163	59.0	2747	18	9	0	4.5	2.3	30	218	7.01	6.9	6.79	5.80	11.7
2	WAS	1970	2024	243	391	148	62.1	2689	17	10	1	4.3	2.6	24	171	5.78	6.9	6.60	5.80	11.1

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Rushing Totals

Regular Season

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Rushing Totals Table
Rk	Team	From	To	Att	Yds	Y/A	TD
1	CIN	1970	2024	329	1316	4.0	12
2	WAS	1970	2024	404	1647	4.1	14

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Kicking & Punting Totals

Regular Season

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Kicking & Punting Totals Table
				PAT			FG				Punting
Rk	Team	From	To	XPM	XPA	XP%	FGM	FGA	FG%	2PM	Pnt	Yds	Y/P	Blck
1	CIN	1970	2024	29	31	93.5	12	19	63.2	0	53	2247	42.4	0
2	WAS	1970	2024	33	33	100.0	17	25	68.0	0	47	2079	44.2	0

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Kick & Punt Return Totals

Regular Season

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Kick & Punt Return Totals Table
				Kick Returns				Punt Returns
Rk	Team	From	To	Ret	Yds	Y/Ret	KRTD	Ret	Yds	Y/Ret	PRTD
1	CIN	1970	2024	9	257	28.6	0	9	52	5.8	1
2	WAS	1970	2024	10	282	28.2	0	5	35	7.0	1

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Defense Totals

Regular Season

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Defense Totals Table
						Pass Rush		Def Interceptions		Fumbles
Rk	Team	From	To	Sk	TFL	QBKD	Prss	Int	IntTD	Fmb	FR	Yds	FRTD	FF
1	CIN	1970	2024	24	11	4	12	10	0	13	1	0	1	3
2	WAS	1970	2024	30	13	9	22	9	1	17	5	0	0	2

Cincinnati Bengals vs. Washington Commanders: Team Comparison

Cincinnati Bengals vs. Washington Commanders: Overall Passing Totals

Regular Season

Playoffs

Cincinnati Bengals vs. Washington Commanders: Overall Passing Totals Table
Rk	Team	From	To	Cmp	Att	Inc	Cmp%	Yds	TD	Int	TD%	Int%	Rate	Sk	Yds	Sk%	Y/A	AY/A	ANY/A	Y/C
1	CIN	1968	2025	17006	28618	11612	59.4	183709	1245	896	4.4	3.1	79.8	2197	15133	7.13	6.4	5.88	4.97	10.8
2	WAS	1932	2025	21779	38828	17049	56.1	250710	1744	1740	4.5	4.5	72.0	2231	20146	6.01	6.5	5.34	4.68	11.5

Cincinnati Bengals vs. Washington Commanders: Overall Passing Totals Table
Rk	Team	From	To	Cmp	Att	Inc	Cmp%	Yds	TD	Int	TD%	Int%	Rate	Sk	Yds	Sk%	Y/A	AY/A	ANY/A	Y/C
1	CIN	1970	2022	495	821	326	60.3	4791	27	24	3.3	2.9	75.4	89	575	9.78	5.8	5.18	4.04	9.7
2	WAS	1936	2024	775	1410	635	55.0	9056	59	61	4.2	4.3	70.6	73	586	5.65	6.4	5.31	4.92	11.7

Cincinnati Bengals vs. Washington Commanders: Overall Rushing Totals

Regular Season

Playoffs

Cincinnati Bengals vs. Washington Commanders: Overall Rushing Totals Table
				Rushing
Rk	Team	From	To	Att	Yds	Y/A	TD	1D
1	CIN	1968	2025	26169	107637	4.1	780	2865
2	WAS	1932	2025	41618	162462	3.9	1147	3052

Cincinnati Bengals vs. Washington Commanders: Overall Rushing Totals Table
				Rushing
Rk	Team	From	To	Att	Yds	Y/A	TD	1D
1	CIN	1970	2022	685	2878	4.2	24	85
2	WAS	1936	2024	1543	5282	3.4	45	62

Cincinnati Bengals vs. Washington Commanders: Overall Kicking & Punting Totals

Regular Season

Playoffs

Cincinnati Bengals vs. Washington Commanders: Overall Kicking & Punting Totals Table
				PAT			FG				Punting
Rk	Team	From	To	XPM	XPA	XP%	FGM	FGA	FG%	2PM	Pnt	Yds	Y/P	Blck
1	CIN	1968	2025	2027	2103	96.4	1221	1644	74.3	30	4287	183041	42.7	33
2	WAS	1932	2025	2836	3025	93.8	1564	2345	66.1	41	6084	250874	41.2	50

Cincinnati Bengals vs. Washington Commanders: Overall Kicking & Punting Totals Table
				PAT			FG				Punting
Rk	Team	From	To	XPM	XPA	XP%	FGM	FGA	FG%	2PM	Pnt	Yds	Y/P	Blck
1	CIN	1970	2022	51	52	98.1	38	44	86.4	2	115	4151	36.1	0
2	WAS	1936	2024	107	110	97.3	58	90	64.4	1	237	6650	28.1	3

Cincinnati Bengals vs. Washington Commanders: Overall Kick & Punt Return Totals

Regular Season

Playoffs

Cincinnati Bengals vs. Washington Commanders: Overall Kick & Punt Return Totals Table
				Kick Returns				Punt Returns
Rk	Team	From	To	Ret	Yds	Y/Ret	KRTD	Ret	Yds	Y/Ret	PRTD
1	CIN	1968	2025	3234	69317	21.4	14	2054	16952	8.3	17
2	WAS	1932	2025	4429	98430	22.2	28	3128	31151	10.0	36

Cincinnati Bengals vs. Washington Commanders: Overall Kick & Punt Return Totals Table
				Kick Returns				Punt Returns
Rk	Team	From	To	Ret	Yds	Y/Ret	KRTD	Ret	Yds	Y/Ret	PRTD
1	CIN	1970	2022	33	789	23.9	1	24	207	8.6	0
2	WAS	1936	2024	17	382	22.5	1	4	34	8.5	1

Cincinnati Bengals vs. Washington Commanders: Overall Defense Totals

Regular Season

Playoffs

Cincinnati Bengals vs. Washington Commanders: Overall Defense Totals Table
						Pass Rush		Def Interceptions		Fumbles
Rk	Team	From	To	Sk	TFL	QBKD	Prss	Int	IntTD	Fmb	FR	Yds	FRTD	FF
1	CIN	1968	2025	1934	1806	423	2073	976	82	1420	830	2257	43	132
2	WAS	1932	2025	2411	1924	362	2147	1768	101	2481	1464	1988	70	137

Cincinnati Bengals vs. Washington Commanders: Overall Defense Totals Table
						Pass Rush		Def Interceptions		Fumbles
Rk	Team	From	To	Sk	TFL	QBKD	Prss	Int	IntTD	Fmb	FR	Yds	FRTD	FF
1	CIN	1970	2022	43	39					34	7	115	1	5
2	WAS	1936	2024	100	30					67	5	0	2	4

Data coverage:

Player game data: since 1933. Scoring statistics (TD, XP, FG) are complete. Yardage and attempts statistics are nearly complete. Game participation data since 1970.

Player season data: all-time (since 1920). Scoring statistics (TD, XP, FG) are complete all-time. Yardage and attempts statistics were not recorded until 1932. Advanced stats since 2018.

Team Game data: since 1920. Before 1940, only wins, losses, points for, and points allowed are available. Scoring statistics (TD, XP, FG) are complete since 1920. Yardage and attempts statistics are nearly complete since 1933.

Team Season data: since 1940. Scoring statistics (TD, XP, FG) are complete all-time.

Please see our data coverage page for details.

If you utilize material unique to a Sports Reference site for a tweet, an article, or for research for a broadcast or podcast, please strongly consider citing this site as the source for the material. It would be greatly appreciated and would help us continue to produce this material.

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare Players

Compare Teams

Player vs. Team

Search Criteria

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Stats

Cincinnati Bengals vs. Washington Commanders: Recent Games

Subscribe to Stathead Pro Football for full results.

Cincinnati Bengals vs. Washington Commanders: Yearly Records

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Passing Totals

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Rushing Totals

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Kicking & Punting Totals

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Kick & Punt Return Totals

Cincinnati Bengals vs. Washington Commanders: Head-to-Head Defense Totals

Cincinnati Bengals vs. Washington Commanders: Team Comparison

Cincinnati Bengals vs. Washington Commanders: Overall Passing Totals

Cincinnati Bengals vs. Washington Commanders: Overall Passing Totals

Cincinnati Bengals vs. Washington Commanders: Overall Rushing Totals

Cincinnati Bengals vs. Washington Commanders: Overall Rushing Totals

Cincinnati Bengals vs. Washington Commanders: Overall Kicking & Punting Totals

Cincinnati Bengals vs. Washington Commanders: Overall Kicking & Punting Totals

Cincinnati Bengals vs. Washington Commanders: Overall Kick & Punt Return Totals

Cincinnati Bengals vs. Washington Commanders: Overall Kick & Punt Return Totals

Cincinnati Bengals vs. Washington Commanders: Overall Defense Totals

Cincinnati Bengals vs. Washington Commanders: Overall Defense Totals

Full Site Menu

FAQs, Tip & Tricks