Dallas Cowboys vs. Pittsburgh Steelers: 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 = [
          'dal',
          'pit',
          'pit',
          'dal',
          'pit',
          'dal'
        ];

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

h2h_gamelogs

Page Setup Time: 0.00089 seconds

SELECT IF(away_team_id="dal","@","") as loc, IF(away_team_id="dal",away_score,home_score) as team1_score, IF(away_team_id="pit",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 = [
          'dal',
          'pit',
          'pit',
          'dal'
        ];

Query Time: 0.04 seconds
SELECT IF(away_team_id="dal","@","") as loc, IF(away_team_id="dal",away_score,home_score) as team1_score, IF(away_team_id="pit",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 = [
          'dal',
          'pit',
          'pit',
          'dal'
        ];

Query Time: 0.05 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.03 seconds


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

h2h_records

Page Setup Time: 0.00066 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 = [
          'dal',
          'pit',
          'pit',
          'dal'
        ];

Query Time: 0.03 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 = [
          'dal',
          'pit',
          'pit',
          'dal'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.05 seconds

Table Build Time: 0.04 seconds


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

h2h_pass

Page Setup Time: 0.00274 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 = [
          'dal',
          'pit'
        ];

Query Time: 0.03 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 = [
          'dal',
          'pit'
        ];

Query Time: 0.04 seconds
Table Build Time: 0.07 seconds

Table Build Time: 0.04 seconds


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

h2h_rec

Page Setup Time: 0.00096 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 = [
          'dal',
          'pit'
        ];

Query Time: 0.03 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 = [
          'dal',
          'pit'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.05 seconds

Table Build Time: 0.04 seconds


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

h2h_kick

Page Setup Time: 0.00144 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 = [
          'dal',
          'pit'
        ];

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(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 = [
          'dal',
          'pit'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.09 seconds

Table Build Time: 0.05 seconds


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

h2h_return

Page Setup Time: 0.00113 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 = [
          'dal',
          'pit'
        ];

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(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 = [
          'dal',
          'pit'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.05 seconds


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

h2h_defense

Page Setup Time: 0.00437 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 = [
          'dal',
          'pit'
        ];

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_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 = [
          'dal',
          'pit'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.09 seconds

Table Build Time: 0.04 seconds


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

sum_pass

Page Setup Time: 0.00301 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_td IS NULL)+SUM(pass_att 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_att IS NULL)+SUM(pass_int 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_yds IS NULL)+SUM(pass_att IS NULL)+SUM(pass_td IS NULL)+SUM(pass_cmp IS NULL)+SUM(pass_int 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_att IS NULL)+SUM(pass_sacked 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_att IS NULL)+SUM(pass_yds 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_int IS NULL)+SUM(pass_td IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds 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_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_int IS NULL)+SUM(pass_sacked 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 = [
          'pit',
          'dal'
        ];

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_td IS NULL)+SUM(pass_att 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_att IS NULL)+SUM(pass_int 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_yds IS NULL)+SUM(pass_att IS NULL)+SUM(pass_td IS NULL)+SUM(pass_cmp IS NULL)+SUM(pass_int 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_att IS NULL)+SUM(pass_sacked 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_att IS NULL)+SUM(pass_yds 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_int IS NULL)+SUM(pass_td IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds 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_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_int IS NULL)+SUM(pass_sacked 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 = [
          'pit',
          'dal'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.08 seconds

Table Build Time: 0.05 seconds


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

sum_rec

Page Setup Time: 0.00079 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 = [
          'pit',
          'dal'
        ];

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(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 = [
          'pit',
          'dal'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.07 seconds

Table Build Time: 0.05 seconds


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

sum_kick

Page Setup Time: 0.01849 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 IS NULL)+SUM(punt_yds 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 = [
          'pit',
          'dal'
        ];

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 IS NULL)+SUM(punt_yds 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 = [
          'pit',
          'dal'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.08 seconds

Table Build Time: 0.04 seconds


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

sum_return

Page Setup Time: 0.00109 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 IS NULL)+SUM(kick_ret_yds 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 = [
          'pit',
          'dal'
        ];

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(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 IS NULL)+SUM(kick_ret_yds 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 = [
          'pit',
          'dal'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


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

sum_defense

Page Setup Time: 0.00110 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 = [
          'pit',
          'dal'
        ];

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_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 = [
          'pit',
          'dal'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.06 seconds

Table Build Time: 0.04 seconds


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

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

Pittsburgh Steelers

Dallas Cowboys

14-17

2-1

Reg Season

Playoffs

17-14

1-2

1300

687

591

.538

19.8

19.0

W-L%

PS/G

PA/G

Playoff Apps.

Finals Apps.

Championships

1011

575

429

.573

23.1

20.3

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Stats

Dallas Cowboys vs. Pittsburgh Steelers: 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.

Dallas Cowboys vs. Pittsburgh Steelers: Recent Games Table
Rk	Date	DAL		PIT	OT	Venue	City
1	2024-10-06	20	@	17		Acrisure Stadium	Pittsburgh
2	2020-11-08	19		24		AT&T Stadium	Arlington
3	2016-11-13	35	@	30		Heinz Field	Pittsburgh
4	2012-12-16	27		24	OT	Cowboys Stadium	Arlington
5	2008-12-07	13	@	20		Heinz Field	Pittsburgh
6	2004-10-17	20		24		Texas Stadium	Irving
7	1997-08-31	37	@	7		Three Rivers Stadium	Pittsburgh
8	1994-09-04	26	@	9		Three Rivers Stadium	Pittsburgh
9	1991-11-28	20		10		Texas Stadium	Irving
10	1988-09-04	21	@	24		Three Rivers Stadium	Pittsburgh

Dallas Cowboys vs. Pittsburgh Steelers: Yearly Records

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: Yearly Records Table
		Dallas Cowboys				Pittsburgh Steelers
Rk	Season	G	W	L	Pts	G	W	L	Pts
1	1960	1	0	1	28	1	1	0	35
2	1961	2	1	1	34	2	1	1	61
3	1962	2	1	1	70	2	1	1	57
4	1963	2	0	2	40	2	2	0	51
5	1964	2	1	1	34	2	1	1	37
6	1965	2	1	1	37	2	1	1	39
7	1966	2	2	0	72	2	0	2	28
8	1967	1	1	0	24	1	0	1	21
9	1968	1	1	0	28	1	0	1	7
10	1969	1	1	0	10	1	0	1	7
11	1972	1	1	0	17	1	0	1	13
12	1977	1	0	1	13	1	1	0	28
13	1979	1	0	1	3	1	1	0	14
14	1982	1	0	1	28	1	1	0	36
15	1985	1	1	0	27	1	0	1	13
16	1988	1	0	1	21	1	1	0	24
17	1991	1	1	0	20	1	0	1	10
18	1994	1	1	0	26	1	0	1	9
19	1997	1	1	0	37	1	0	1	7
20	2004	1	0	1	20	1	1	0	24
21	2008	1	0	1	13	1	1	0	20
22	2012	1	1	0	27	1	0	1	24
23	2016	1	1	0	35	1	0	1	30
24	2020	1	0	1	19	1	1	0	24
25	2024	1	1	0	20	1	0	1	17
	Totals	31	17	14	703	31	14	17	636

Dallas Cowboys vs. Pittsburgh Steelers: Yearly Records Table
		Dallas Cowboys				Pittsburgh Steelers
Rk	Season	G	W	L	Pts	G	W	L	Pts
1	1975	1	0	1	17	1	1	0	21
2	1978	1	0	1	31	1	1	0	35
3	1995	1	1	0	27	1	0	1	17
	Totals	3	1	2	75	3	2	1	73

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Passing Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2024	548	1008	460	54.4	7182	57	44	2	5.7	4.4	71	638	8.10	7.1	6.29	5.06	13.1
2	PIT	1960	2024	483	945	462	51.1	6083	51	31	4	5.4	3.3	80	595	9.49	6.4	6.04	4.25	12.6

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1975	1995	47	77	30	61.0	536	6	4	0	7.8	5.2	14	105	15.38	7.0	6.18	4.08	11.4
2	PIT	1975	1995	54	98	44	55.1	688	7	4	0	7.1	4.1	10	78	9.26	7.0	6.61	5.28	12.7

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Rushing Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Rushing Totals Table
Rk	Team	From	To	Att	Yds	Y/A	TD
1	DAL	1960	2024	928	3629	3.9	23
2	PIT	1960	2024	908	3350	3.7	22

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Rushing Totals Table
Rk	Team	From	To	Att	Yds	Y/A	TD
1	DAL	1975	1995	88	318	3.6	2
2	PIT	1975	1995	101	318	3.1	2

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Kicking & Punting Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2024	79	81	97.5	40	64	62.5	0	148	5998	40.5	1
2	PIT	1960	2024	67	73	91.8	29	49	59.2	0	173	7387	42.7	1

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1975	1995	9	9	100.0	4	4	100.0	0	17	366	21.5	1
2	PIT	1975	1995	8	9	88.9	3	6	50.0	0	11	175	15.9	0

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Kick & Punt Return Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2024	5	180	36.0	1	7	164	23.4	1
2	PIT	1960	2024	9	229	25.4	1	5	73	14.6	0

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1975	1995	0	0		0	0	0		0
2	PIT	1975	1995	0	0		0	0	0		0

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Defense Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2024	80	15	5	16	31	2	57	3	0	0	3
2	PIT	1960	2024	71	13	9	30	44	4	53	5	-1	2	4

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1975	1995	10				4	0	7	0	0	1	0
2	PIT	1975	1995	14				4	0	8	0	0	0	0

Dallas Cowboys vs. Pittsburgh Steelers: Team Comparison

Dallas Cowboys vs. Pittsburgh Steelers: Overall Passing Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2025	18874	31684	12810	59.6	215232	1503	1125	4.7	3.6	81.0	2281	16747	6.72	6.8	6.14	5.24	11.4
2	PIT	1933	2025	19727	36656	16929	53.8	231390	1551	1844	4.2	5.0	66.4	2241	19666	6.19	6.3	4.89	4.47	11.7

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1966	2023	1192	2067	875	57.7	13069	97	80	4.7	3.9	76.0	172	1168	7.68	6.3	5.52	4.57	11.0
2	PIT	1947	2024	1211	2069	858	58.5	14147	93	83	4.5	4.0	77.6	123	840	5.66	6.8	5.93	5.23	11.7

Dallas Cowboys vs. Pittsburgh Steelers: Overall Rushing Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: Overall Rushing Totals Table
				Rushing
Rk	Team	From	To	Att	Yds	Y/A	TD	1D
1	DAL	1960	2025	30914	129943	4.2	1010	3190
2	PIT	1933	2025	42662	164191	3.8	1183	3227

Dallas Cowboys vs. Pittsburgh Steelers: Overall Rushing Totals Table
				Rushing
Rk	Team	From	To	Att	Yds	Y/A	TD	1D
1	DAL	1966	2023	2164	8953	4.1	74	99
2	PIT	1947	2024	2109	8381	4.0	79	183

Dallas Cowboys vs. Pittsburgh Steelers: Overall Kicking & Punting Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2025	2575	2630	97.9	1428	1956	73.0	41	4588	193913	42.3	30
2	PIT	1933	2025	2741	2868	95.6	1643	2269	71.2	52	6111	248588	40.7	46

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1966	2023	170	178	95.5	93	120	77.5	4	318	8672	27.3	3
2	PIT	1947	2024	160	168	95.2	88	112	78.6	6	283	8422	29.8	6

Dallas Cowboys vs. Pittsburgh Steelers: Overall Kick & Punt Return Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2025	3268	72251	22.1	19	2392	20693	8.7	30
2	PIT	1933	2025	3902	85124	21.8	21	3285	31055	9.5	29

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1966	2023	22	534	24.3	1	12	107	8.9	1
2	PIT	1947	2024	30	618	20.6	0	16	111	6.9	2

Dallas Cowboys vs. Pittsburgh Steelers: Overall Defense Totals

Regular Season

Playoffs

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1960	2025	2548	1929	420	2288	1142	96	1723	1026	2512	55	161
2	PIT	1933	2025	2547	2234	435	2466	1787	111	2501	1503	3623	75	172

Dallas Cowboys vs. Pittsburgh Steelers: 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	DAL	1966	2023	166	35					129	9	0	6	6
2	PIT	1947	2024	156	96					109	7	19	5	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.

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare Players

Compare Teams

Player vs. Team

Search Criteria

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Stats

Dallas Cowboys vs. Pittsburgh Steelers: Recent Games

Dallas Cowboys vs. Pittsburgh Steelers: Recent Games

Subscribe to Stathead Pro Football for full results.

Dallas Cowboys vs. Pittsburgh Steelers: Yearly Records

Dallas Cowboys vs. Pittsburgh Steelers: Yearly Records

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Passing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Passing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Rushing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Rushing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Kicking & Punting Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Kicking & Punting Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Kick & Punt Return Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Kick & Punt Return Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Defense Totals

Dallas Cowboys vs. Pittsburgh Steelers: Head-to-Head Defense Totals

Dallas Cowboys vs. Pittsburgh Steelers: Team Comparison

Dallas Cowboys vs. Pittsburgh Steelers: Overall Passing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Passing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Rushing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Rushing Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Kicking & Punting Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Kicking & Punting Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Kick & Punt Return Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Kick & Punt Return Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Defense Totals

Dallas Cowboys vs. Pittsburgh Steelers: Overall Defense Totals

Full Site Menu

FAQs, Tip & Tricks