Keep observations if within two weeks of an event

[Monica Muller]

Hi,


I have a panel data of several branches of an organization over time. Variable newhire measures whether a new employee joined the branch in each week. I want to only keep observations that are within two weeks of an event of hiring in their branch.
I really appreciate it if you'd help me with this question.

Here's a small sample of my data:

* Example generated by -dataex-. To install: ssc install dataex
clear
input float year str8 week double newhire float(performance moderator id)
2015 "2015-2"  0  3.607143  3.360648 1
2015 "2015-3"  1  3.936667  3.390476 1
2015 "2015-4"  0  3.888889   3.75947 1
2015 "2015-6"  1  3.195238 3.6414285 1
2015 "2015-7"  0  3.934127  3.381349 1
2015 "2015-8"  0 4.1015873  3.081349 1
2015 "2015-9"  0  3.916667  3.836111 1
2015 "2015-11" 0 3.8466666      4.66 1
2015 "2015-12" 0 4.0466666      3.81 1
2015 "2015-13" 0  4.312143  3.354286 1
2015 "2015-14" 0 3.5666666  3.716667 1
2015 "2015-15" 1 4.4444804         4 1
2015 "2015-16" 1 4.0396824 4.1630955 1
2015 "2015-17" 0  4.122619  3.902778 1
2015 "2015-18" 0  4.038265  3.490476 1
2015 "2015-19" 0 4.0505953 3.5833335 1
2015 "2015-20" 0  3.992857     4.075 1
2015 "2015-21" 1   4.33109  3.145833 1
2015 "2015-22" 1  3.846032  3.666667 1
2015 "2015-23" 1  4.080357  3.708333 1
2015 "2015-24" 1 4.1833334  3.197619 1
2015 "2015-26" 0 4.0099206 3.8694444 1
2015 "2015-27" 0  3.736667 3.3933334 1
2015 "2015-29" 0      4.09 2.9285715 1
2015 "2015-30" 1  3.855612  3.870748 1
2015 "2015-31" 0 4.0311904 4.2066665 1
2015 "2015-32" 0 4.1977777      3.62 1
2015 "2015-33" 0  3.910238 3.8266666 1
2015 "2015-34" 0 3.7084656  3.888889 1
2015 "2015-35" 0  3.934524  3.340278 1
2015 "2015-36" 1 4.1435184  3.835714 1
2015 "2015-37" 0  3.734127  3.990476 1
2015 "2015-38" 0 4.2226853  3.336111 1
2015 "2015-39" 0  3.960979 3.6333334 1
2015 "2015-40" 0  4.080952 3.7857144 1
2015 "2015-41" 0 3.4761906       3.5 1
2015 "2015-42" 0      3.86 3.5766666 1
2015 "2015-43" 0 4.2190475 4.5208335 1
2015 "2015-44" 1     4.025     3.625 1
2015 "2015-45" 0  4.076667       3.8 1
2015 "2015-46" 0  4.035714 3.6438096 1
2015 "2015-47" 0  4.059307  3.909524 1
2015 "2015-48" 0 4.2110543      4.25 1
2015 "2015-49" 0 4.1475625  3.910544 1
2015 "2015-50" 0 4.0234694  4.054762 1
2015 "2015-51" 0 4.1306877 3.7305555 1
2015 "2015-52" 0  4.309921 4.1204762 1
2015 "2015-53" 0 4.0571427      3.93 1
2015 "2015-2"  1  4.201587  4.026786 2
2015 "2015-3"  0  4.024745 4.1367345 2
2015 "2015-4"  0  3.736364 3.2464285 2
2015 "2015-5"  0 3.8976514 3.6455026 2
2015 "2015-6"  0  3.893823  3.752551 2
2015 "2015-7"  0   3.89709 4.1236773 2
2015 "2015-8"  0  3.924762  3.669216 2
2015 "2015-9"  0  3.875794  3.822802 2
2015 "2015-10" 1  3.916766 4.0805554 2
2015 "2015-11" 0  3.981566  3.682381 2
2015 "2015-12" 1  3.720606  4.142491 2
2015 "2015-13" 0  3.672121 3.8128204 2
2015 "2015-14" 0 3.9285715  3.960227 2
2015 "2015-15" 0  3.711881    4.0375 2
2015 "2015-16" 0  3.665568      3.58 2
2015 "2015-17" 0  3.642857 4.1892858 2
2015 "2015-18" 1  3.579212  3.577778 2
2015 "2015-19" 1 3.5294695  4.186111 2
2015 "2015-20" 1  3.655789  3.722222 2
2015 "2015-21" 0  3.660385  4.258333 2
2015 "2015-22" 0 3.6055555  3.551389 2
2015 "2015-23" 1   3.73464 4.0894556 2
2015 "2015-24" 1   3.70754 4.1488094 2
2015 "2015-26" 1 3.4376984 4.0464287 2
2015 "2015-27" 1 3.5432575 3.7955556 2
2015 "2015-28" 1  3.704025 3.6812925 2
2015 "2015-29" 0  3.763546  3.795833 2
2015 "2015-30" 0  3.706061  4.076389 2
2015 "2015-31" 1 3.4234345  4.220476 2
2015 "2015-33" 1 3.7024956  3.962302 2
2015 "2015-35" 0  3.767677 4.1194444 2
2015 "2015-36" 0 4.1556826 4.1305556 2
2015 "2015-37" 1 4.1122694 4.2904763 2
2015 "2015-38" 1      4.15  4.346667 2
2015 "2015-39" 1 3.8907406 4.2738094 2
2015 "2015-40" 1 4.0149574 4.2940474 2
2015 "2015-41" 0  3.878628 4.4325395 2
2015 "2015-42" 1   3.78054  3.869709 2
2015 "2015-43" 1 3.9527116 4.1997356 2
2015 "2015-44" 0  3.748333 4.1738095 2
2015 "2015-45" 0  3.800144  4.196429 2
2015 "2015-46" 0 4.0257144  3.970476 2
2015 "2015-47" 0  3.983679  3.674206 2
2015 "2015-48" 0 3.9971154  4.099008 2
2015 "2015-49" 0 4.0386734 3.9484694 2
2015 "2015-50" 0 4.1584363  3.856944 2
2015 "2015-51" 0  3.695702  4.331741 2
2015 "2015-52" 0 4.1124654 4.2880955 2
2015 "2015-53" 0 4.0095525  3.782143 2
2015 "2015-2"  0  3.941587  4.127778 3
2015 "2015-3"  0  4.154422 4.1511903 3
2015 "2015-4"  0  3.911548  3.657407 3
end

[Clyde Schechter]

I am assuming that by "within 2 weeks" you mean that a new hire occurred in the previous two weeks or in the subsequent two weeks.

The main obstacle is that we need a numeric variable that sequences weeks properly. Your variable, week, cannot be translated into a Stata internal format week variable because Stata does not recognize a week 53 in year 2015. So we have to create something that will suit the purpose, where week numbers run from 1 to 53 rather than 1 to 52.

Once that is in place, it's just a matter of, for each observation, counting how many new hire events occurred within 2 weeks, and retaining only those observations for which the count exceeds 0.

* Example generated by -dataex-. To install: ssc install dataex
clear
input float year str8 week double newhire float(performance moderator id)
2015 "2015-2"  0  3.607143  3.360648 1
2015 "2015-3"  1  3.936667  3.390476 1
2015 "2015-4"  0  3.888889   3.75947 1
2015 "2015-6"  1  3.195238 3.6414285 1
2015 "2015-7"  0  3.934127  3.381349 1
2015 "2015-8"  0 4.1015873  3.081349 1
2015 "2015-9"  0  3.916667  3.836111 1
2015 "2015-11" 0 3.8466666      4.66 1
2015 "2015-12" 0 4.0466666      3.81 1
2015 "2015-13" 0  4.312143  3.354286 1
2015 "2015-14" 0 3.5666666  3.716667 1
2015 "2015-15" 1 4.4444804         4 1
2015 "2015-16" 1 4.0396824 4.1630955 1
2015 "2015-17" 0  4.122619  3.902778 1
2015 "2015-18" 0  4.038265  3.490476 1
2015 "2015-19" 0 4.0505953 3.5833335 1
2015 "2015-20" 0  3.992857     4.075 1
2015 "2015-21" 1   4.33109  3.145833 1
2015 "2015-22" 1  3.846032  3.666667 1
2015 "2015-23" 1  4.080357  3.708333 1
2015 "2015-24" 1 4.1833334  3.197619 1
2015 "2015-26" 0 4.0099206 3.8694444 1
2015 "2015-27" 0  3.736667 3.3933334 1
2015 "2015-29" 0      4.09 2.9285715 1
2015 "2015-30" 1  3.855612  3.870748 1
2015 "2015-31" 0 4.0311904 4.2066665 1
2015 "2015-32" 0 4.1977777      3.62 1
2015 "2015-33" 0  3.910238 3.8266666 1
2015 "2015-34" 0 3.7084656  3.888889 1
2015 "2015-35" 0  3.934524  3.340278 1
2015 "2015-36" 1 4.1435184  3.835714 1
2015 "2015-37" 0  3.734127  3.990476 1
2015 "2015-38" 0 4.2226853  3.336111 1
2015 "2015-39" 0  3.960979 3.6333334 1
2015 "2015-40" 0  4.080952 3.7857144 1
2015 "2015-41" 0 3.4761906       3.5 1
2015 "2015-42" 0      3.86 3.5766666 1
2015 "2015-43" 0 4.2190475 4.5208335 1
2015 "2015-44" 1     4.025     3.625 1
2015 "2015-45" 0  4.076667       3.8 1
2015 "2015-46" 0  4.035714 3.6438096 1
2015 "2015-47" 0  4.059307  3.909524 1
2015 "2015-48" 0 4.2110543      4.25 1
2015 "2015-49" 0 4.1475625  3.910544 1
2015 "2015-50" 0 4.0234694  4.054762 1
2015 "2015-51" 0 4.1306877 3.7305555 1
2015 "2015-52" 0  4.309921 4.1204762 1
2015 "2015-53" 0 4.0571427      3.93 1
2015 "2015-2"  1  4.201587  4.026786 2
2015 "2015-3"  0  4.024745 4.1367345 2
2015 "2015-4"  0  3.736364 3.2464285 2
2015 "2015-5"  0 3.8976514 3.6455026 2
2015 "2015-6"  0  3.893823  3.752551 2
2015 "2015-7"  0   3.89709 4.1236773 2
2015 "2015-8"  0  3.924762  3.669216 2
2015 "2015-9"  0  3.875794  3.822802 2
2015 "2015-10" 1  3.916766 4.0805554 2
2015 "2015-11" 0  3.981566  3.682381 2
2015 "2015-12" 1  3.720606  4.142491 2
2015 "2015-13" 0  3.672121 3.8128204 2
2015 "2015-14" 0 3.9285715  3.960227 2
2015 "2015-15" 0  3.711881    4.0375 2
2015 "2015-16" 0  3.665568      3.58 2
2015 "2015-17" 0  3.642857 4.1892858 2
2015 "2015-18" 1  3.579212  3.577778 2
2015 "2015-19" 1 3.5294695  4.186111 2
2015 "2015-20" 1  3.655789  3.722222 2
2015 "2015-21" 0  3.660385  4.258333 2
2015 "2015-22" 0 3.6055555  3.551389 2
2015 "2015-23" 1   3.73464 4.0894556 2
2015 "2015-24" 1   3.70754 4.1488094 2
2015 "2015-26" 1 3.4376984 4.0464287 2
2015 "2015-27" 1 3.5432575 3.7955556 2
2015 "2015-28" 1  3.704025 3.6812925 2
2015 "2015-29" 0  3.763546  3.795833 2
2015 "2015-30" 0  3.706061  4.076389 2
2015 "2015-31" 1 3.4234345  4.220476 2
2015 "2015-33" 1 3.7024956  3.962302 2
2015 "2015-35" 0  3.767677 4.1194444 2
2015 "2015-36" 0 4.1556826 4.1305556 2
2015 "2015-37" 1 4.1122694 4.2904763 2
2015 "2015-38" 1      4.15  4.346667 2
2015 "2015-39" 1 3.8907406 4.2738094 2
2015 "2015-40" 1 4.0149574 4.2940474 2
2015 "2015-41" 0  3.878628 4.4325395 2
2015 "2015-42" 1   3.78054  3.869709 2
2015 "2015-43" 1 3.9527116 4.1997356 2
2015 "2015-44" 0  3.748333 4.1738095 2
2015 "2015-45" 0  3.800144  4.196429 2
2015 "2015-46" 0 4.0257144  3.970476 2
2015 "2015-47" 0  3.983679  3.674206 2
2015 "2015-48" 0 3.9971154  4.099008 2
2015 "2015-49" 0 4.0386734 3.9484694 2
2015 "2015-50" 0 4.1584363  3.856944 2
2015 "2015-51" 0  3.695702  4.331741 2
2015 "2015-52" 0 4.1124654 4.2880955 2
2015 "2015-53" 0 4.0095525  3.782143 2
2015 "2015-2"  0  3.941587  4.127778 3
2015 "2015-3"  0  4.154422 4.1511903 3
2015 "2015-4"  0  3.911548  3.657407 3
end

//    CREATE A NUMERIC VARIABLE THAT TICKS OFF
//    THE WEEKS
split week, parse("-") gen(w) destring
assert w1 == year
drop w1
gen nweek = (year-2015)*53 + w2

//    FOR EACH OBSERVATION IDENTIFY THE
//    COUNT OF  NEWHIRE === 1 OBSERVATIONS THAT ARE WITHIN 2
//    WEEKS OF A NEW HIRE (BEFORE OR AFTER)
rangestat (sum) newhire, interval(nweek -2 2)

keep if newhire_sum > 0

Note: To run this you need Robert Picard, Nick Cox, & Roberto Ferrer's -rangestat- command, available from SSC.

[Monica Muller]

Thank you very much. I didn't know about rangestat. I really appreciate your help.

[Nick Cox]

Your weeks will, most likely, be defined externally in terms of the days that begin or end them. It's best to translate them to equivalent daily dates and then work with periods of that are multiples of 7 days. For much more, see

SJ-12-3 dm0065 . . . . . . . . . . Stata tip 111: More on working with weeks
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox
Q3/12 SJ 12(3):565--569 (no commands)
discusses how to convert data presented in yearly and weekly
form to daily dates and how to aggregate such data to months
or longer intervals

http://www.stata-journal.com/sjpdf.h...iclenum=dm0085

SJ-10-4 dm0052 . . . . . . . . . . . . . . . . Stata tip 68: Week assumptions
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox
Q4/10 SJ 10(4):682--685 (no commands)
tip on Stata's solution for weeks and on how to set up
your own alternatives given different definitions of the
week

http://www.stata-journal.com/sjpdf.h...iclenum=dm0052


Let's try this for your example. Evidently you had a week 53 in 2015; the only day of the week that occurred 53 times in 2015 was Thursday. So, one guess runs like this:

* Example generated by -dataex-. To install: ssc install dataex
clear
input float year str8 week double newhire float id
2015 "2015-2"  0 1
2015 "2015-3"  1 1
2015 "2015-4"  0 1
2015 "2015-6"  1 1
2015 "2015-7"  0 1
2015 "2015-8"  0 1
2015 "2015-9"  0 1
2015 "2015-11" 0 1
2015 "2015-12" 0 1
2015 "2015-13" 0 1
2015 "2015-14" 0 1
2015 "2015-15" 1 1
2015 "2015-16" 1 1
2015 "2015-17" 0 1
2015 "2015-18" 0 1
2015 "2015-19" 0 1
2015 "2015-20" 0 1
2015 "2015-21" 1 1
2015 "2015-22" 1 1
2015 "2015-23" 1 1
2015 "2015-24" 1 1
2015 "2015-26" 0 1
2015 "2015-27" 0 1
2015 "2015-29" 0 1
2015 "2015-30" 1 1
2015 "2015-31" 0 1
2015 "2015-32" 0 1
2015 "2015-33" 0 1
2015 "2015-34" 0 1
2015 "2015-35" 0 1
2015 "2015-36" 1 1
2015 "2015-37" 0 1
2015 "2015-38" 0 1
2015 "2015-39" 0 1
2015 "2015-40" 0 1
2015 "2015-41" 0 1
2015 "2015-42" 0 1
2015 "2015-43" 0 1
2015 "2015-44" 1 1
2015 "2015-45" 0 1
2015 "2015-46" 0 1
2015 "2015-47" 0 1
2015 "2015-48" 0 1
2015 "2015-49" 0 1
2015 "2015-50" 0 1
2015 "2015-51" 0 1
2015 "2015-52" 0 1
2015 "2015-53" 0 1
2015 "2015-2"  1 2
2015 "2015-3"  0 2
2015 "2015-4"  0 2
2015 "2015-5"  0 2
2015 "2015-6"  0 2
2015 "2015-7"  0 2
2015 "2015-8"  0 2
2015 "2015-9"  0 2
2015 "2015-10" 1 2
2015 "2015-11" 0 2
2015 "2015-12" 1 2
2015 "2015-13" 0 2
2015 "2015-14" 0 2
2015 "2015-15" 0 2
2015 "2015-16" 0 2
2015 "2015-17" 0 2
2015 "2015-18" 1 2
2015 "2015-19" 1 2
2015 "2015-20" 1 2
2015 "2015-21" 0 2
2015 "2015-22" 0 2
2015 "2015-23" 1 2
2015 "2015-24" 1 2
2015 "2015-26" 1 2
2015 "2015-27" 1 2
2015 "2015-28" 1 2
2015 "2015-29" 0 2
2015 "2015-30" 0 2
2015 "2015-31" 1 2
2015 "2015-33" 1 2
2015 "2015-35" 0 2
2015 "2015-36" 0 2
2015 "2015-37" 1 2
2015 "2015-38" 1 2
2015 "2015-39" 1 2
2015 "2015-40" 1 2
2015 "2015-41" 0 2
2015 "2015-42" 1 2
2015 "2015-43" 1 2
2015 "2015-44" 0 2
2015 "2015-45" 0 2
2015 "2015-46" 0 2
2015 "2015-47" 0 2
2015 "2015-48" 0 2
2015 "2015-49" 0 2
2015 "2015-50" 0 2
2015 "2015-51" 0 2
2015 "2015-52" 0 2
2015 "2015-53" 0 2
2015 "2015-2"  0 3
2015 "2015-3"  0 3
2015 "2015-4"  0 3
end

gen Week = real(substr(week, 6, .)) 
gen Dow1Jan = dow(mdy(1, 1, year)) 
gen doy = (Week * 7) - cond(Dow1Jan < 4, 4 - Dow1Jan, 11 - Dow1Jan) 
gen DailyDate = mdy(1, 1, year) + doy - 1 
format DailyDate %td 

 list, sepby(year id) 

     +------------------------------------------------------------------+
     | year      week   newhire   id   Week   Dow1Jan   doy   DailyDate |
     |------------------------------------------------------------------|
  1. | 2015    2015-2         0    1      2         4     7   07jan2015 |
  2. | 2015    2015-3         1    1      3         4    14   14jan2015 |
  3. | 2015    2015-4         0    1      4         4    21   21jan2015 |
  4. | 2015    2015-6         1    1      6         4    35   04feb2015 |
  5. | 2015    2015-7         0    1      7         4    42   11feb2015 |
  6. | 2015    2015-8         0    1      8         4    49   18feb2015 |
  7. | 2015    2015-9         0    1      9         4    56   25feb2015 |
  8. | 2015   2015-11         0    1     11         4    70   11mar2015 |
  9. | 2015   2015-12         0    1     12         4    77   18mar2015 |
 10. | 2015   2015-13         0    1     13         4    84   25mar2015 |
 11. | 2015   2015-14         0    1     14         4    91   01apr2015 |
 12. | 2015   2015-15         1    1     15         4    98   08apr2015 |
 13. | 2015   2015-16         1    1     16         4   105   15apr2015 |
 14. | 2015   2015-17         0    1     17         4   112   22apr2015 |
 15. | 2015   2015-18         0    1     18         4   119   29apr2015 |
 16. | 2015   2015-19         0    1     19         4   126   06may2015 |
 17. | 2015   2015-20         0    1     20         4   133   13may2015 |
 18. | 2015   2015-21         1    1     21         4   140   20may2015 |
 19. | 2015   2015-22         1    1     22         4   147   27may2015 |
 20. | 2015   2015-23         1    1     23         4   154   03jun2015 |
 21. | 2015   2015-24         1    1     24         4   161   10jun2015 |
 22. | 2015   2015-26         0    1     26         4   175   24jun2015 |
 23. | 2015   2015-27         0    1     27         4   182   01jul2015 |
 24. | 2015   2015-29         0    1     29         4   196   15jul2015 |
 25. | 2015   2015-30         1    1     30         4   203   22jul2015 |
 26. | 2015   2015-31         0    1     31         4   210   29jul2015 |
 27. | 2015   2015-32         0    1     32         4   217   05aug2015 |
 28. | 2015   2015-33         0    1     33         4   224   12aug2015 |
 29. | 2015   2015-34         0    1     34         4   231   19aug2015 |
 30. | 2015   2015-35         0    1     35         4   238   26aug2015 |
 31. | 2015   2015-36         1    1     36         4   245   02sep2015 |
 32. | 2015   2015-37         0    1     37         4   252   09sep2015 |
 33. | 2015   2015-38         0    1     38         4   259   16sep2015 |
 34. | 2015   2015-39         0    1     39         4   266   23sep2015 |
 35. | 2015   2015-40         0    1     40         4   273   30sep2015 |
 36. | 2015   2015-41         0    1     41         4   280   07oct2015 |
 37. | 2015   2015-42         0    1     42         4   287   14oct2015 |
 38. | 2015   2015-43         0    1     43         4   294   21oct2015 |
 39. | 2015   2015-44         1    1     44         4   301   28oct2015 |
 40. | 2015   2015-45         0    1     45         4   308   04nov2015 |
 41. | 2015   2015-46         0    1     46         4   315   11nov2015 |
 42. | 2015   2015-47         0    1     47         4   322   18nov2015 |
 43. | 2015   2015-48         0    1     48         4   329   25nov2015 |
 44. | 2015   2015-49         0    1     49         4   336   02dec2015 |
 45. | 2015   2015-50         0    1     50         4   343   09dec2015 |
 46. | 2015   2015-51         0    1     51         4   350   16dec2015 |
 47. | 2015   2015-52         0    1     52         4   357   23dec2015 |
 48. | 2015   2015-53         0    1     53         4   364   30dec2015 |
     |------------------------------------------------------------------|
 49. | 2015    2015-2         1    2      2         4     7   07jan2015 |
 50. | 2015    2015-3         0    2      3         4    14   14jan2015 |
 51. | 2015    2015-4         0    2      4         4    21   21jan2015 |
 52. | 2015    2015-5         0    2      5         4    28   28jan2015 |
 53. | 2015    2015-6         0    2      6         4    35   04feb2015 |
 54. | 2015    2015-7         0    2      7         4    42   11feb2015 |
 55. | 2015    2015-8         0    2      8         4    49   18feb2015 |
 56. | 2015    2015-9         0    2      9         4    56   25feb2015 |
 57. | 2015   2015-10         1    2     10         4    63   04mar2015 |
 58. | 2015   2015-11         0    2     11         4    70   11mar2015 |
 59. | 2015   2015-12         1    2     12         4    77   18mar2015 |
 60. | 2015   2015-13         0    2     13         4    84   25mar2015 |
 61. | 2015   2015-14         0    2     14         4    91   01apr2015 |
 62. | 2015   2015-15         0    2     15         4    98   08apr2015 |
 63. | 2015   2015-16         0    2     16         4   105   15apr2015 |
 64. | 2015   2015-17         0    2     17         4   112   22apr2015 |
 65. | 2015   2015-18         1    2     18         4   119   29apr2015 |
 66. | 2015   2015-19         1    2     19         4   126   06may2015 |
 67. | 2015   2015-20         1    2     20         4   133   13may2015 |
 68. | 2015   2015-21         0    2     21         4   140   20may2015 |
 69. | 2015   2015-22         0    2     22         4   147   27may2015 |
 70. | 2015   2015-23         1    2     23         4   154   03jun2015 |
 71. | 2015   2015-24         1    2     24         4   161   10jun2015 |
 72. | 2015   2015-26         1    2     26         4   175   24jun2015 |
 73. | 2015   2015-27         1    2     27         4   182   01jul2015 |
 74. | 2015   2015-28         1    2     28         4   189   08jul2015 |
 75. | 2015   2015-29         0    2     29         4   196   15jul2015 |
 76. | 2015   2015-30         0    2     30         4   203   22jul2015 |
 77. | 2015   2015-31         1    2     31         4   210   29jul2015 |
 78. | 2015   2015-33         1    2     33         4   224   12aug2015 |
 79. | 2015   2015-35         0    2     35         4   238   26aug2015 |
 80. | 2015   2015-36         0    2     36         4   245   02sep2015 |
 81. | 2015   2015-37         1    2     37         4   252   09sep2015 |
 82. | 2015   2015-38         1    2     38         4   259   16sep2015 |
 83. | 2015   2015-39         1    2     39         4   266   23sep2015 |
 84. | 2015   2015-40         1    2     40         4   273   30sep2015 |
 85. | 2015   2015-41         0    2     41         4   280   07oct2015 |
 86. | 2015   2015-42         1    2     42         4   287   14oct2015 |
 87. | 2015   2015-43         1    2     43         4   294   21oct2015 |
 88. | 2015   2015-44         0    2     44         4   301   28oct2015 |
 89. | 2015   2015-45         0    2     45         4   308   04nov2015 |
 90. | 2015   2015-46         0    2     46         4   315   11nov2015 |
 91. | 2015   2015-47         0    2     47         4   322   18nov2015 |
 92. | 2015   2015-48         0    2     48         4   329   25nov2015 |
 93. | 2015   2015-49         0    2     49         4   336   02dec2015 |
 94. | 2015   2015-50         0    2     50         4   343   09dec2015 |
 95. | 2015   2015-51         0    2     51         4   350   16dec2015 |
 96. | 2015   2015-52         0    2     52         4   357   23dec2015 |
 97. | 2015   2015-53         0    2     53         4   364   30dec2015 |
     |------------------------------------------------------------------|
 98. | 2015    2015-2         0    3      2         4     7   07jan2015 |
 99. | 2015    2015-3         0    3      3         4    14   14jan2015 |
100. | 2015    2015-4         0    3      4         4    21   21jan2015 |
     +------------------------------------------------------------------+