How are line and total calculated for NFL SDQL?

[jake spam]

I understand these variables are the “Vegas consensus”. Does that mean this is the last available line, averaged vegas line, or other?

Thanks 

[johnrya...@gmail.com]

Great question Jake,

I am not sure if all of the sports books listed as parameters on the S3 sportsdatbase and GimmeTheDog dot com site are 100% updated, but if you look at this page you will many sportsbooks opening and closing lines. I will reach out to GimmeThe Dog and Joe Meyer to see if they have been updated and will be updated each week of the season. In the past the lines did change during the week ahead of any game.

https://s3.sportsdatabase.com/NFL/query.html?sdql=Record%28points-o%3Apoints%29%2C+Record%28%28points%2Bline-o%3Apoints%2C-110%2C1%29%29%2C+Record%28%28points%2Btotal-o%3Apoints%2C-110%2C1%29%29%2C+R%28team%29%2Cdate%2C+team%2Cpoints%2Co%3Apoints%2Cmargin%2Co%3Apoints%2Cline%2Ctotal%2C+ou+margin%40playoffs%3D1+and+p%3Agame+type%3DWC+and+H+and+line%3C%3D3.5&submit=++S+D+Q+L+%21++

[jake spam]

Thanks for reply I truly appreciate the response. It seems that 'line' and 'total' variables are the most populated when going back in time (~2005 for NFL). Things such as "line mgm, line wyn, line mir, line pb, etc" are much more sporadically populated. I'm more specifically wondering which sportsbook (or multiple) is the "line" and "total" derived/scraped from. Wish you the best of luck in the upcoming season.