'team' column in play_player

[denutza]

One of the first queries I tried was this:
select * from
play_player
where gsis_id='2009080950'

and i noticed that the first 15 drives (drive_id), all showed BUF as the 'team'.
Not sure if this is a bug, or im supposed to rely on the pos_team column from 'play' table.

Obviously BUF didn't make every single play in the first 15 drives.

To simplify finding the bug, this query returns the result where TEN ran for -3 yards as BUF defended, however both plays (the offensive run, and defensive tackle) both show 'BUF' in the 'team' field:

select * from
play_player
where gsis_id='2009080950' and drive_id=1 and play_id=83

[andr3w321]

This looks like a bug with this game only. It's a preseason game and one of the first games entered into nfldb. The week is listed as 0 which is strange too. It's the only game that shows up for.

select * from game where season_year = 2009 and week = 0;

select gsis_id,drive_id,team from play_player where gsis_id = '2009080950' order by drive_id;

  gsis_id   | drive_id | team 
------------+----------+------
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF
 2009080950 |        1 | BUF

select gsis_id,drive_id,team from play_player where gsis_id = '2015092800' order by drive_id;

  gsis_id   | drive_id | team 
------------+----------+------
 2015092800 |        1 | GB
 2015092800 |        1 | GB
 2015092800 |        1 | GB
 2015092800 |        1 | KC
 2015092800 |        1 | GB
 2015092800 |        1 | KC
 2015092800 |        1 | GB
 2015092800 |        1 | GB
 2015092800 |        1 | KC
 2015092800 |        1 | KC
 2015092800 |        1 | GB
 2015092800 |        1 | KC
 2015092800 |        1 | GB
 2015092800 |        2 | KC
 2015092800 |        2 | GB
 2015092800 |        2 | GB
 2015092800 |        2 | KC
 2015092800 |        2 | GB
 2015092800 |        2 | KC
 2015092800 |        2 | GB
 2015092800 |        2 | KC
 2015092800 |        2 | KC
 2015092800 |        2 | GB