|
Schema: JCapper StarterHistory Table
file: c:\JCapper\exe\JCapper2.mdb last updated: 03/02/2018 |
Below is a list of the column or field names, data types, and a brief description of the data stored in a JCapper StarterHistory Table:
Column or Field Name Data Type Description
--------------------- ------------- ----------------------------------------------
horsename text 60 name of horse
track text 3 track code today’s race
tracklast text 3 track code most recent start
date date/time today’s race date (mo/day/year)
month number integer month from date of today’s race
year number integer year from date of today’s race
race number byte race number
dist number single distance in yards today’s race
distlastout number single distance in yards most recent start
surface text 1 surface type (D, d, O, T, t)
intsurface number integer surface type (1=D, 2=d, 3=O, 4=T, 5=t)
tkcond text 3 track condition (FT, GD, SY, MY, FM, SF, YL, etc.)
classdescriptor text 2 class descriptor (C=claiming, M=mdn claiming, etc.)
classdescrlast text 2 class descriptor most recent start (C=claiming, M=mdn claiming, etc.)
odds number single post time odds today’s race
rankodds number integer rank for odds today’s race (1=post time favorite)
vulnerablefav number integer vulnerable favorite indicator (0=legit 1=vulnerable)
officialfinishposition number integer official finish position today’s race
finPosFav1 number integer finish position favorite today’s race
finPosFav2 number integer finish position 2nd favorite today’s race
finPosFav3 number integer finish position 3rd favorite today’s race
finPosFav4 number integer finish position 4th favorite today’s race
finPosFav5 number integer finish position 5th favorite today’s race
finPosFav6 number integer finish position 6th favorite today’s race
finPosFav7 number integer finish position 7th favorite today’s race
finPosFav8 number integer finish position 8th favorite today’s race
finPosUPR1 number integer finish position UPR rank = 1 horse today’s race
finPosUPR2 number integer finish position UPR rank = 2 horse today’s race
finPosUPR3 number integer finish position UPR rank = 3 horse today’s race
finPosUPR4 number integer finish position UPR rank = 4 horse today’s race
finPosUPR5 number integer finish position UPR rank = 5 horse today’s race
finPosUPR6 number integer finish position UPR rank = 6 horse today’s race
finPosUPR7 number integer finish position UPR rank = 7 horse today’s race
finPosUPR8 number integer finish position UPR rank = 8 horse today’s race
winpayoff number single win mutuel $2.00 base
placepayoff number single place mutuel $2.00 base
showpayoff number single show mutuel $2.00 base
exoticWagerType text 3 description of exotic wager type ("EXA")
exoticWagerPayoff number single exotic wager payoff $2.00 base
mvp number long indicates (1=true 0=false) horse in the race with the highest combined parimutuel payoffs
fieldsize number integer number of starters today’s race
fieldsizelastout number integer number of starters most recent start
rgn number integer randomly generated number (1-100 for stat analysis)
racevolatility number single Race Volatility
espraceshape number integer race shape based on run styles of starters in current race
paceindex number single Pace Index
pacepressure number integer Pace Pressure from Race Shape
pctdirty number single Percent of field DIRTY
purse number single purse value today’s race
railposition number integer position in starting gate (1=closest to inside rail)
pscore number single PScore
runstyle number integer running style (1=E, 2=EP, 3=P, 4=S, 5=NA)
qspeedpoints number integer quirin style speed points (between 0 and 8)
racedays number integer number of days since most recent start
wodays number integer number of days since most recent work
cantrunxformattrib number integer 0=CLEAN, 1=XFORM, 2=CANTRUN
wosince number integer WOSINCE (0=worked since last, 1=no works since last)
stagereadiness number integer Stage Readiness (0=none, 1=type 1, 2=type 2)
sprintcycle number integer Sprint Cycle (0=no, 1=yes)
routecycle number integer Route Cycle (0=no, 1=yes)
fcycle number integer Form Cycle (1-9)
scycle number integer Speed Cycle (1-9)
dcycle number integer Distance Cycle (1-9)
sub number integer sprints under belt after layoff
rub number integer routes under belt after layoff
clshift number integer class shift using purse value
clshift2 number integer class shift using par and race strength
dtshift number single distance shift (in furlongs)
sfshift number integer surface shift
wtshift number integer weight shift
ftscount number integer first time starter count today’s race
routedebut number integer route debut today (0=false, 1=true)
routedebutcount number integer route debut starter count today’s race
turfdebut number integer turf debut today (0=false, 1=true)
turfdebutcount number integer turf debut starter count today’s race
foreign number integer foreign horse making North American debut today (0=no, 1=yes)
figimprov number integer (reserved for future use)
layoffhorsecount number integer layoff starter count today’s race
pacelow number integer new pace low
pacetop number integer new pace top
drivetype number integer Drive Type (0=none, 1=type 1, 2=type 2)
horsetype number integer Horse Type
mline number single morning line odds
rankmline number integer rank morning line odds
mlor number single MLOR - morning line odds ratio
mlor2 number single MLOR2 – morning line odds ratio 2
mlor3 number single MLOR3 – morning line odds ratio 3
bettorstoteprob number single BettorsToteProb - prob based on proprietary algorithm and post time odds
rankBettorsToteProb number integer rank BettorsToteProb
jprtoteprob number single JPRToteProb - prob based on JPR and post time odds
uprtoteprob number single UPRToteProb - prob based on UPR and post time odds
uprzscoreprob number single UPRZScoreProb - prob based on normalized ZScore distribution of UPR
upropinionprob number single UPROpinionProb - prob based on rank and gap of UPR
aprob number single AProb (JRating enabled users only)
rankaprob number integer rank AProb
gapaprob number single gap AProb
jprmlprob number single JPRMLProb
rankjprmlprob number integer rank JPRMLProb
gapjprmlprob number single gap JPRMLProb
uprmlprob number single UPRMLProb
rankuprmlprob number integer rank UPRMLProb
gapuprmlprob number single gap UPRMLProb
or3 number single OR3 Odds Ratio 3
ebettorstoteprob number single Expected Value BettorsToteProb
euprzscoreprob number single Expected Value UPRZScoreProb
ejprtoteprob number single Expected Value JPRToteProb
euprtoteprob number single Expected Value UPRToteProb
rider text 60 name of rider
trainer text 60 name of trainer
owner text 60 name of owner
sire text 60 name of sire
siressire text 60 name of sire’s sire
dam text 60 name of dam
damssire text 60 name of dam’s sire
ageofhorse number integer age of horse in years
sex number integer sex of horse (1=f, 2=m, 3=c, 4=h, 5=g, 6=r)
claimraces number integer claim races (0=not claimed, 1=claimed last start, 2=claimed 2 back, etc.)
claimdays number integer days since claim (0=not claimed, 19=claimed 19 days ago)
med number integer medication (0=none, 1=lasix, 2=bute, 3=lasix & bute, 4=1st time lasix, etc.)
equip number integer equipment change (0=none, 1=blinkers on, 2=blinkers off)
startslifetime number integer number of lifetime starts
xthstartrider number integer xth start for rider
xthstarttrainer number integer xth start for trainer
xthstartlasix number integer xth start after lasix
xthstartlayoff number integer xth start after layoff
xthstartmeet number integer xth start of current meet
len2call number single beaten lengths at second call last start
pos2call number integer position at second call last start
lenstrcall number single beaten lengths at stretch call last start
posstrcall number integer position at stretch call last start
lenfincall number single beaten lengths at finish call last start
posfincall number integer position at finish call last start
rankjpr number integer rank JPR
jpr number single JPR numeric value
gapjpr number single gap JPR
rankupr number integer rank UPR
upr number single UPR numeric value
gapupr number single gap UPR
rankalchemy number integer rank Alchemy
alchemy number single Alchemy numeric value
gapalchemy number single gap Alchemy
rankprating number integer rank PRating
prating number single Prating numeric value
gapprating number single gap Prating
rankqrating number integer rank QRating
qrating number single Qrating numeric value
gapqrating number single gap Qrating
rankF01 number integer rank of factor placed by user into slot 01
valF01 number single numeric value of factor placed by user into slot 01
gapF01 number single gap of factor placed by user into slot 01
rankF02 number integer rank of factor placed by user into slot 02
valF02 number single numeric value of factor placed by user into slot 02
gapF02 number single gap of factor placed by user into slot 02
rankF03 number integer rank of factor placed by user into slot 03
valF03 number single numeric value of factor placed by user into slot 03
gapF03 number single gap of factor placed by user into slot 03
rankF04 number integer rank of factor placed by user into slot 04
valF04 number single numeric value of factor placed by user into slot 04
gapF04 number single gap of factor placed by user into slot 04
rankF05 number integer rank of factor placed by user into slot 05
valF05 number single numeric value of factor placed by user into slot 05
gapF05 number single gap of factor placed by user into slot 05
rankF06 number integer rank of factor placed by user into slot 06
valF06 number single numeric value of factor placed by user into slot 06
gapF06 number single gap of factor placed by user into slot 06
rankF07 number integer rank of factor placed by user into slot 07
valF07 number single numeric value of factor placed by user into slot 07
gapF07 number single gap of factor placed by user into slot 07
rankF08 number integer rank of factor placed by user into slot 08
valF08 number single numeric value of factor placed by user into slot 08
gapF08 number single gap of factor placed by user into slot 08
rankF09 number integer rank of factor placed by user into slot 09
valF09 number single numeric value of factor placed by user into slot 09
gapF09 number single gap of factor placed by user into slot 09
rankF10 number integer rank of factor placed by user into slot 10
valF10 number single numeric value of factor placed by user into slot 10
gapF10 number single gap of factor placed by user into slot 10
rankF11 number integer rank of factor placed by user into slot 11
valF11 number single numeric value of factor placed by user into slot 11
gapF11 number single gap of factor placed by user into slot 11
rankF12 number integer rank of factor placed by user into slot 12
valF12 number single numeric value of factor placed by user into slot 12
gapF12 number single gap of factor placed by user into slot 12
rankF13 number integer rank of factor placed by user into slot 13
valF13 number single numeric value of factor placed by user into slot 13
gapF13 number single gap of factor placed by user into slot 13
rankF14 number integer rank of factor placed by user into slot 14
valF14 number single numeric value of factor placed by user into slot 14
gapF14 number single gap of factor placed by user into slot 14
rankF15 number integer rank of factor placed by user into slot 15
valF25 number single numeric value of factor placed by user into slot 15
gapF15 number single gap of factor placed by user into slot 15
rankF16 number integer rank of factor placed by user into slot 16
valF16 number single numeric value of factor placed by user into slot 16
gapF16 number single gap of factor placed by user into slot 16
rankF17 number integer rank of factor placed by user into slot 17
valF17 number single numeric value of factor placed by user into slot 17
gapF17 number single gap of factor placed by user into slot 17
rankF18 number integer rank of factor placed by user into slot 18
valF18 number single numeric value of factor placed by user into slot 18
gapF18 number single gap of factor placed by user into slot 18
rankF19 number integer rank of factor placed by user into slot 19
valF19 number single numeric value of factor placed by user into slot 19
gapF19 number single gap of factor placed by user into slot 19
rankF20 number integer rank of factor placed by user into slot 20
valF20 number single numeric value of factor placed by user into slot 20
gapF20 number single gap of factor placed by user into slot 20
rankF21 number integer rank of factor placed by user into slot 21
valF21 number single numeric value of factor placed by user into slot 21
gapF21 number single gap of factor placed by user into slot 21
rankF22 number integer rank of factor placed by user into slot 22
valF22 number single numeric value of factor placed by user into slot 22
gapF22 number single gap of factor placed by user into slot 22
rankF23 number integer rank of factor placed by user into slot 23
valF23 number single numeric value of factor placed by user into slot 23
gapF23 number single gap of factor placed by user into slot 23
rankF24 number integer rank of factor placed by user into slot 24
valF24 number single numeric value of factor placed by user into slot 24
gapF24 number single gap of factor placed by user into slot 24
rankF25 number integer rank of factor placed by user into slot 25
valF25 number single numeric value of factor placed by user into slot 25
gapF25 number single gap of factor placed by user into slot 25
rankF26 number integer rank of factor placed by user into slot 26
valF26 number single numeric value of factor placed by user into slot 26
gapF26 number single gap of factor placed by user into slot 26
rankF27 number integer rank of factor placed by user into slot 27
valF27 number single numeric value of factor placed by user into slot 27
gapF27 number single gap of factor placed by user into slot 27
rankF28 number integer rank of factor placed by user into slot 28
valF28 number single numeric value of factor placed by user into slot 28
gapF28 number single gap of factor placed by user into slot 28
rankF29 number integer rank of factor placed by user into slot 29
valF29 number single numeric value of factor placed by user into slot 29
gapF29 number single gap of factor placed by user into slot 29
rankF30 number integer rank of factor placed by user into slot 30
valF30 number single numeric value of factor placed by user into slot 30
gapF30 number single gap of factor placed by user into slot 30
rankF31 number integer rank of factor placed by user into slot 31
valF31 number single numeric value of factor placed by user into slot 31
gapF31 number single gap of factor placed by user into slot 31
rankF32 number integer rank of factor placed by user into slot 32
valF32 number single numeric value of factor placed by user into slot 32
gapF32 number single gap of factor placed by user into slot 32
rankF33 number integer rank of factor placed by user into slot 33
valF33 number single numeric value of factor placed by user into slot 33
gapF33 number single gap of factor placed by user into slot 33
rankF34 number integer rank of factor placed by user into slot 34
valF34 number single numeric value of factor placed by user into slot 34
gapF34 number single gap of factor placed by user into slot 34
rankF35 number integer rank of factor placed by user into slot 35
valF35 number single numeric value of factor placed by user into slot 35
gapF35 number single gap of factor placed by user into slot 35
|
Copyright © 2018 JCapper Software |