How to find the range of dates

[BB Kim]

Recession ranges are lists below
local recession1 August 1929 March 1933
local recession2 May 1937 June 1938
local recession3 February 1945 October 1945
local recession4 November 1948 October 1949
local recession5 July 1953 May 1954
local recession6 August 1957 April 1958
local recession7 April 1960 February 1961
local recession8 December 1969 November 1970
local recession9 November 1973 March 1975
local recession10 January 1980 July 1980
local recession11 July 1981 November 1982
local recession12 July 1990 March 1991
local recession13 March 2001 November 2001
local recession14 December 2007 June 2009
local recession15 February 2020 April 2020


I want to find the first recession range number that CEO worked
If, for example, ID 0001 CEO's start_date is 01mar1999 and end_date is 19sep2001. In this case, the work duration period includes recession 13 ranges. (I want the coding result value=13)
If, for example ID 0002 CEO's start_date is 01oct2001 and end_date is 11sep2010. In this case, this ceo worked during recession 13, and 14 ranges. and so the the first recession range that ceo experienced is 13 (I want the result value=13)
if ID 0003 CEO 's start_date is 01mar1979 and end_date is 11sep2000. In this case, this ceo worked during recession 10,11,12 ranges, and I want the result value =10.

If i have data of each ID's start and end date, how do I find the number of recession ranges that ceo first experienced during the work duration dates

[Clyde Schechter]

I want to find the first recession range number that CEO worked

* Example generated by -dataex-. For more info, type help dataex
clear
input str5 id str11 start_date str10 end_date
"00003" "01dec1989" "31dec1998"
"00003" "01apr2001" "30oct2009"
"00006" "01nov1991" "15feb2001"
"00006" "02jul2007" "31mar2008"
"00008" "01may1969" "28dec2003"
"00026" "03jul2001" "01feb2002"
"99999" "01mar2008" "31may2020"
end

foreach v of varlist start_date end_date {
    gen _`v' = daily(`v', "DMY"), after(`v')
    assert missing(`v') == missing(_`v')
    drop `v'
    rename _`v' `v'
    format `v' %td
}

local recession1    August 1929     March 1933
local recession2    May 1937     June 1938
local recession3    February 1945     October 1945
local recession4    November 1948     October 1949
local recession5    July 1953     May 1954
local recession6    August 1957     April 1958
local recession7    April 1960     February 1961
local recession8    December 1969     November 1970
local recession9    November 1973     March 1975
local recession10   January 1980     July 1980
local recession11   July 1981     November 1982
local recession12   July 1990     March 1991
local recession13   March 2001     November 2001
local recession14   December 2007     June 2009
local recession15   February 2020     April 2020

//  CLEAN UP THE RECESSION LOCALS AND MAKE THEM NUMERIC
forvalues i = 1/15 {
    local m1: word 1 of `recession`i''
    local y1: word 2 of `recession`i''
    local m2: word 3 of `recession`i''
    local y2: word 4 of `recession`i''
    local recession_start`i' = dofm(monthly("`m1' `y1'", "MY"))
    local recession_end`i' = dofm(monthly("`m2' `y2'", "MY"))
    assert !missing(`recession_start`i'', `recession_end`i'')
}

gen first_recession_worked = .
forvalues i = 1/15 {
    replace first_recession_worked = `i' ///
        if min(end_date, `recession_end`i'') >= max(start_date, `recession_start`i'') ///
        & missing(first_recession_worked)
}
collapse (min) first_recession_worked, by(id)

If i have data of each ID's start and end date, how do I find the number of recession ranges that ceo first experienced during the work duration dates

You asked this elsewhere recently and already have an answer. See https://www.statalist.org/forums/for...-within-ranges.

However, you can combine the answers to the two problems as:

* Example generated by -dataex-. For more info, type help dataex
clear
input str5 id str11 start_date str10 end_date
"00003" "01dec1989" "31dec1998"
"00003" "01apr2001" "30oct2009"
"00006" "01nov1991" "15feb2001"
"00006" "02jul2007" "31mar2008"
"00008" "01may1969" "28dec2003"
"00026" "03jul2001" "01feb2002"
"99999" "01mar2008" "31may2020"
end

foreach v of varlist start_date end_date {
gen _`v' = daily(`v', "DMY"), after(`v')
assert missing(`v') == missing(_`v')
drop `v'
rename _`v' `v'
format `v' %td
}

local recession1 August 1929 March 1933
local recession2 May 1937 June 1938
local recession3 February 1945 October 1945
local recession4 November 1948 October 1949
local recession5 July 1953 May 1954
local recession6 August 1957 April 1958
local recession7 April 1960 February 1961
local recession8 December 1969 November 1970
local recession9 November 1973 March 1975
local recession10 January 1980 July 1980
local recession11 July 1981 November 1982
local recession12 July 1990 March 1991
local recession13 March 2001 November 2001
local recession14 December 2007 June 2009
local recession15 February 2020 April 2020

// CLEAN UP THE RECESSION LOCALS AND MAKE THEM NUMERIC
forvalues i = 1/15 {
local m1: word 1 of `recession`i''
local y1: word 2 of `recession`i''
local m2: word 3 of `recession`i''
local y2: word 4 of `recession`i''
local recession_start`i' = dofm(monthly("`m1' `y1'", "MY"))
local recession_end`i' = dofm(monthly("`m2' `y2'", "MY"))
assert !missing(`recession_start`i'', `recession_end`i'')
}

gen first_recession_worked = .
gen number_recessions_worked = 0
forvalues i = 1/15 {
replace first_recession_worked = `i' ///
if min(end_date, `recession_end`i'') >= max(start_date, `recession_start`i'') ///
& missing(first_recession_worked)
replace number_recessions_worked = number_recessions_worked + 1 ///
if min(end_date, `recession_end`i'') >= max(start_date, `recession_start`i'')
}
collapse (sum) number_recessions_worked (min) first_recession_worked, by(id)

[BB Kim]

Thank you so much!
I have two questions related to this data:

1) I want to make a code that if , for example, ID 00003's independent variable X was above the median (among all the other ID in year) before the first range recession (in year of 1986- 1989), conditional on this above x median, what is the dependent Y value after the recession years in 1992-1998? Also, Conditional on X is above the median before the second recession range years in 2000, what is the Y value after the recession years in 2002-2007?
That is to regress the y value of after the recession period , conditional on above and below med value of x before the recession


2) Also, since this person experienced multiple recession during her ceo tenure, I want to test the effect of recent vs past experience. Regression test whether Y value is different between 'after the recent recession range ( March 2001 to Nov 2001), so Y values during in 2002 to 2007', compared to 'after the past recession range.(July 1990-March 1991), so the y value during 1992-1998'

[Clyde Schechter]

I'm sorry, but I don't understand what is being asked in #3. Part of my not understanding is that I have no idea what X and Y refer to here. There are no variables in your example data with those names. In fact, the example data have no variables at all other than id's and dates. And as you have not up to this point mentioned any regressions, I do not understand your use of the terms dependent and independent variables.

Another part of my misunderstanding is, when you refer to above the median of X, are you referring to the median of X for all time for all id's? Or just the median of X for all time for just the current id. Or just the median of X for non-recession periods for the current id? Or the median of X for non-recession periods for all id's?

When you say "what is the Y value after the recession years in 2002-2007," again, I do not know what you are referring to. There will be 6 different Y values, one in each of the years 2002-2007. Which one are you talking about?

Also, since this person experienced multiple recession during her ceo tenure, I want to test the effect of recent vs past experience. Regression test whether Y value is different between 'after the recent recession range ( March 2001 to Nov 2001), so Y values during in 2002 to 2007', compared to 'after the past recession range.(July 1990-March 1991), so the y value during 1992-1998'

While I have some sense of what you want to do specifically in the case where a person experienced exactly two recessions, I don't understand how you want to proceed with people who have experienced more than 2 recessions. And while I assume that people who have experienced only 0 or 1 recession should just be excluded from this analysis, can you confirm that is the case.

Please be sure when you post back to include example data that includes these X and Y variables. And, of course, use -dataex- to do that.

[BB Kim]

X and Y are workplace injury rates.I want to test whether firms with recession experienced ceos which have less injury rates (below median) before the recession have also less injury rates in years after the recession.
For example, if ceo with below median injury rates (below median among all ID in each year) before recession ( year of 1986- 1989 for ID 0003 case), what is the injury rates value after the recession years( in 1992-1998)?

The purpose of this regression is that whether the recession experience affects the injury rates after recession periods compared to those of before recessions.

If I keep number_recessions_worked==1 samples.
for each recession range, Select IDs that are below median injury rates each year. and want the independent variable of after the recession injury rates.

[Clyde Schechter]

Thank you for answering some of my questions. But I can't help you without example data that includes these injury rate variables, and they must be available in every year. And you did not respond how you want to handle the people who experienced more than 1 recession.

Added: Before proceeding with this you might want to give some thought to some design issues here. It seems you want to divide the id's into below and above median injury rate before recession groups, and then compare their post-recession injury rates. The problem here is regression to the mean. While median is not the same as mean, I would guess that injury rate distributions are somewhat right skewed, which means that the median will be below the mean. Consequently, on average (as would be detected in a regression analysis), the below-median group's pre-recession injury rates can be expected to rise when they are observed again after recession even if there is no real effect of the recession. There is also a question of whether there is a long term secular trend in injury rates: one might expect, and one would certainly hope, that over the long term these rates have been declining. So both secular trend and regression to the mean will make the results of this kind of comparison uninterpretable. If you really want to analyze for an effect of recessions, you will need to have a control group who were unexposed to any recession during the same (or nearly the same) years and do a difference-in-differences analysis. Whether this is feasible or not depends on whether you have enough of the right data to do it.

[BB Kim]

EXECID	YEAR	inj_hour	start_date	end_date	number_recessions_worked
57328	2011	00-Jan-00	17-Apr-15	01-Jan-23	1
57679	2008	00-Jan-00	01-Jan-88	01-Jan-23	4
59664	2007	00-Jan-00	01-Oct-09	08-May-13	0
59669	2007	00-Jan-00	01-Sep-97	01-Oct-09	2
59669	2008	00-Jan-00	01-Sep-97	01-Oct-09	2
59664	2008	00-Jan-00	01-Oct-09	08-May-13	0
19157	2002	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2003	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2004	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2005	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2006	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2007	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2008	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2009	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2010	00-Jan-00	09-Jun-06	31-Dec-17	1
19157	2011	00-Jan-00	09-Jun-06	31-Dec-17	1
18072	2002	00-Jan-00	01-Jan-89	01-May-04	2
31714	2009	00-Jan-00	23-Jan-98	30-Sep-18	2
20058	2002	00-Jan-00	01-Jan-02	14-May-04	0
20056	2002	00-Jan-00	01-Jan-94	01-Jan-02	1
20058	2003	00-Jan-00	01-Jan-02	14-May-04	0
28307	2004	00-Jan-00	01-Jul-04	01-Jan-23	2
20058	2004	00-Jan-00	01-Jan-02	14-May-04	0
28307	2006	00-Jan-00	01-Jul-04	01-Jan-23	2
28307	2007	00-Jan-00	01-Jul-04	01-Jan-23	2
28307	2008	00-Jan-00	01-Jul-04	01-Jan-23	2
42358	2008	00-Jan-00	01-Jun-16	01-Jan-23	1
42359	2008	00-Jan-00	01-Aug-01	01-Jul-08	2
26669	2002	00-Jan-00	01-Mar-00	01-Jun-12	2
26669	2003	00-Jan-00	01-Mar-00	01-Jun-12	2
26669	2004	00-Jan-00	01-Mar-00	01-Jun-12	2
26669	2006	00-Jan-00	01-Mar-00	01-Jun-12	2
40005	2007	00-Jan-00	01-Jun-12	01-Jan-23	1
26669	2007	00-Jan-00	01-Mar-00	01-Jun-12	2
40005	2009	00-Jan-00	01-Jun-12	01-Jan-23	1
26669	2009	00-Jan-00	01-Mar-00	01-Jun-12	2
14051	2007	00-Jan-00	01-Jan-99	09-Jul-07	1
24983	2007	00-Jan-00	09-Jul-07	25-Apr-08	1
34760	2007	00-Jan-00	20-Apr-11	01-Jul-13	0
24983	2008	00-Jan-00	09-Jul-07	25-Apr-08	1
34760	2008	00-Jan-00	20-Apr-11	01-Jul-13	0
34760	2010	00-Jan-00	20-Apr-11	01-Jul-13	0
19583	2005	00-Jan-00	01-Apr-93	01-Jan-23	3
19583	2006	00-Jan-00	01-Apr-93	01-Jan-23	3
19583	2008	00-Jan-00	01-Apr-93	01-Jan-23	3
19583	2010	00-Jan-00	01-Apr-93	01-Jan-23	3
49887	2007	00-Jan-00	01-Mar-94	01-Sep-12	2
49887	2007	00-Jan-00	01-Mar-94	01-Sep-12	2
49884	2007	00-Jan-00	01-Sep-12	01-Jan-23	1
49884	2008	00-Jan-00	01-Sep-12	01-Jan-23	1
49887	2008	00-Jan-00	01-Mar-94	01-Sep-12	2
49884	2009	00-Jan-00	01-Sep-12	01-Jan-23	1
49887	2009	00-Jan-00	01-Mar-94	01-Sep-12	2
49887	2010	00-Jan-00	01-Mar-94	01-Sep-12	2
49884	2010	00-Jan-00	01-Sep-12	01-Jan-23	1
49887	2011	00-Jan-00	01-Mar-94	01-Sep-12	2
49884	2011	00-Jan-00	01-Sep-12	01-Jan-23	1
12606	2003	00-Jan-00	07-Feb-99	20-Oct-11	2
12606	2004	00-Jan-00	07-Feb-99	20-Oct-11	2
12606	2005	00-Jan-00	07-Feb-99	20-Oct-11	2
12606	2006	00-Jan-00	07-Feb-99	20-Oct-11	2
12606	2007	00-Jan-00	07-Feb-99	20-Oct-11	2
12606	2008	00-Jan-00	07-Feb-99	20-Oct-11	2
12606	2009	00-Jan-00	07-Feb-99	20-Oct-11	2
19028	2002	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2003	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2004	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2005	00-Jan-00	06-Oct-09	01-Mar-15	0
12942	2005	00-Jan-00	01-Jul-05	01-Jan-23	2
19028	2006	00-Jan-00	06-Oct-09	01-Mar-15	0
12942	2006	00-Jan-00	01-Jul-05	01-Jan-23	2
19028	2007	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2008	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2008	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2008	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2008	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2008	00-Jan-00	06-Oct-09	01-Mar-15	0
19028	2008	00-Jan-00	06-Oct-09	01-Mar-15	0
34325	2005	00-Jan-00	10-May-03	01-Jan-23	2
34325	2006	00-Jan-00	10-May-03	01-Jan-23	2
34325	2008	00-Jan-00	10-May-03	01-Jan-23	2
24187	2008	00-Jan-00	01-Jan-04	01-Jan-23	2
31445	2006	00-Jan-00	01-Nov-95	01-Jul-05	1
31443	2006	00-Jan-00	01-Jul-05	30-Dec-13	1
31445	2006	00-Jan-00	01-Nov-95	01-Jul-05	1
31447	2006	00-Jan-00	01-Jan-14	01-Jan-20	0
31447	2008	00-Jan-00	01-Jan-14	01-Jan-20	0
31443	2008	00-Jan-00	01-Jul-05	30-Dec-13	1
31443	2010	00-Jan-00	01-Jul-05	30-Dec-13	1
31447	2010	00-Jan-00	01-Jan-14	01-Jan-20	0
31443	2010	00-Jan-00	01-Jul-05	30-Dec-13	1
31443	2011	00-Jan-00	01-Jul-05	30-Dec-13	1
31443	2011	00-Jan-00	01-Jul-05	30-Dec-13	1
31443	2011	00-Jan-00	01-Jul-05	30-Dec-13	1
31447	2011	00-Jan-00	01-Jan-14	01-Jan-20	0
48822	2007	00-Jan-00	15-Aug-07	04-Jan-08	1
48826	2007	00-Jan-00	11-Aug-05	15-Aug-07	0
48824	2008	00-Jan-00	17-Aug-15	29-Apr-20	1
16604	2008	00-Jan-00	07-Jan-08	17-Aug-15	1
48822	2008	00-Jan-00	15-Aug-07	04-Jan-08	1
48826	2008	00-Jan-00	11-Aug-05	15-Aug-07	0
16604	2010	00-Jan-00	07-Jan-08	17-Aug-15	1
48824	2010	00-Jan-00	17-Aug-15	29-Apr-20	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
21138	2002	00-Jan-00	19-Sep-01	20-Jul-06	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
21139	2002	00-Jan-00	20-Jul-06	01-Jan-23	2
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
12654	2002	00-Jan-00	01-Mar-99	19-Sep-01	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21139	2003	00-Jan-00	20-Jul-06	01-Jan-23	2
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21138	2003	00-Jan-00	19-Sep-01	20-Jul-06	1
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21138	2004	00-Jan-00	19-Sep-01	20-Jul-06	1
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2004	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21138	2005	00-Jan-00	19-Sep-01	20-Jul-06	1
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2005	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21138	2006	00-Jan-00	19-Sep-01	20-Jul-06	1
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2006	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2007	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2008	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2
21139	2009	00-Jan-00	20-Jul-06	01-Jan-23	2

[BB Kim]

"inj_hour" is the workplace injury rates

I think it is okay to use mean instead of median

[Clyde Schechter]

Your inj_hour variable in the example data tableau you posted is not valid. It shows up as 00-Jan-00. I can't even use that as if it were a number mistakenly formatted to display as a date because 00-Jan-00 is not a possible date.

Also, I specifically asked you to use -dataex- to show the example data. That's important: it avoids problems like this and assures me that the example faithfully reflects the actual kind of data you have in all respects. There are things that cannot be shown in a table that -dataex- picks up. It also makes it easy for me to import the data into my own Stata setup. If you want further assistance with this, post back using -dataex- to show the example data.

[BB Kim]

Sorry about it, there was error when I copied and pasted the data. GVKEY is company ID, EXECID is ceo ID. inj_hour is rate so the number is between 0 and 1



dataex GVKEY EXECID YEAR inj_hour start_date end_date, count(500)

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input str6(GVKEY EXECID) double YEAR float(inj_hour start_date end_date)
"100243" "57326" 2007  .006067207     .     .
"100243" "57333" 2007 .0028061275     .     .
"100243" "57333" 2007  .015241192     .     .
"100243" "57333" 2007  .003824911     .     .
"100243" "57333" 2007   .07596014     .     .
"100243" "57333" 2007 .0044252095     .     .
"100243" "57335" 2007  .005036769     .     .
"100243" "57333" 2007  .008341861     .     .
"100243" "57333" 2007  .011624978     .     .
"100243" "57333" 2007   .02066692     .     .
"100243" "57333" 2007  .011575146     .     .
"100243" "57333" 2007  .006847908     .     .
"100243" "57334" 2008   .01365859     .     .
"100243" "57334" 2008  .008391233     .     .
"100243" "57334" 2008   .01382904     .     .
"100243" "57334" 2008           0     .     .
"100243" "57334" 2008  .009904962     .     .
"100243" "57335" 2008           0     .     .
"100243" "57334" 2008  .018747656     .     .
"100243" "57334" 2008   .00497879     .     .
"100243" "57334" 2008  .003934545     .     .
"100243" "57335" 2009  .009264979     .     .
"100243" "57335" 2009           0     .     .
"100243" "57335" 2009  .003073953     .     .
"100243" "57335" 2009  .014764506     .     .
"100243" "57335" 2009  .007492742     .     .
"100243" "57335" 2009  .004510661     .     .
"100243" "57335" 2009  .013495732     .     .
"100243" "57335" 2009           0     .     .
"100243" "57335" 2009           0     .     .
"100243" "57335" 2009           0     .     .
"100243" "57335" 2009  .007557018     .     .
"100243" "57335" 2009           0     .     .
"100243" "57335" 2009  .006733485     .     .
"100243" "57335" 2009  .007319858     .     .
"100243" "57334" 2009  .004714001     .     .
"100243" "57335" 2010           0     .     .
"100243" "57334" 2010           0     .     .
"100243" "57328" 2011  .014235855 20195 23011
"100243" "57335" 2011  .014235855     .     .
"105936" "53620" 2008   .03079576     .     .
"105936" "57679" 2008   .03079576 10227 23011
"105936" "57681" 2008   .03079576     .     .
"105936" "57676" 2008   .03079576     .     .
"105936" "21254" 2008   .03079576     .     .
"110039" "59664" 2007           0 18171 19486
"110039" "59669" 2007           0 13758 18171
"110039" "59671" 2007           0     .     .
"110039" "59682" 2007           0     .     .
"110039" "34725" 2007           0     .     .
"110039" "59671" 2008           0     .     .
"110039" "59669" 2008           0 13758 18171
"110039" "59664" 2008           0 18171 19486
"110039" "59679" 2008           0     .     .
"110039" "59682" 2008           0     .     .
"110685" "19157" 2002  .026750684 16961 21184
"110685" "19156" 2002    .0860215     .     .
"110685" "21996" 2002  .026750684     .     .
"110685" "28770" 2002  .026750684     .     .
"110685" "19157" 2003   .00813875 16961 21184
"110685" "19156" 2003   .01939601     .     .
"110685" "19156" 2003   .02073328     .     .
"110685" "19156" 2003   .02444928     .     .
"110685" "28770" 2003  .019413276     .     .
"110685" "21996" 2003  .011636566     .     .
"110685" "19156" 2003   .06867503     .     .
"110685" "19156" 2004  .012957564     .     .
"110685" "19156" 2004  .003596346     .     .
"110685" "19156" 2004   .08303005     .     .
"110685" "19157" 2004  .029926173 16961 21184
"110685" "21996" 2004  .013461668     .     .
"110685" "19156" 2004  .035002198     .     .
"110685" "28770" 2004  .012406394     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005   .02093855     .     .
"110685" "19156" 2005   .03867175     .     .
"110685" "19156" 2005   .01510089     .     .
"110685" "19156" 2005  .007331325     .     .
"110685" "19156" 2005  .006325911     .     .
"110685" "19156" 2005  .004418184     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005   .07580735     .     .
"110685" "19156" 2005   .03698225     .     .
"110685" "19156" 2005  .012121816     .     .
"110685" "19156" 2005   .01068376     .     .
"110685" "19156" 2005   .07042254     .     .
"110685" "19156" 2005   .01035503     .     .
"110685" "19156" 2005  .003743505     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005  .003745908     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005  .016657228     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005  .005944508     .     .
"110685" "19156" 2005  .012956066     .     .
"110685" "19156" 2005  .014368332     .     .
"110685" "19156" 2005  .007502523     .     .
"110685" "19156" 2005  .009393707     .     .
"110685" "19156" 2005  .005767583     .     .
"110685" "19156" 2005   .01050928     .     .
"110685" "19156" 2005  .004763262     .     .
"110685" "21996" 2005           0     .     .
"110685" "28770" 2005  .024705363     .     .
"110685" "19156" 2005  .007998101     .     .
"110685" "19156" 2005  .004800691     .     .
"110685" "19156" 2005  .014801126     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005  .002742649     .     .
"110685" "19156" 2005 .0013602462     .     .
"110685" "19156" 2005  .013227863     .     .
"110685" "19156" 2005   .01453554     .     .
"110685" "19157" 2005           0 16961 21184
"110685" "19156" 2005  .004376751     .     .
"110685" "19156" 2005           0     .     .
"110685" "19156" 2005  .005027892     .     .
"110685" "19156" 2005           0     .     .
"110685" "19157" 2006  .010255042 16961 21184
"110685" "19157" 2006  .008438818 16961 21184
"110685" "19157" 2006 .0035763844 16961 21184
"110685" "19157" 2006  .013922535 16961 21184
"110685" "19157" 2006  .014100756 16961 21184
"110685" "19157" 2006   .02060938 16961 21184
"110685" "30932" 2006           0     .     .
"110685" "19157" 2006  .011819493 16961 21184
"110685" "19157" 2006  .007330465 16961 21184
"110685" "28770" 2006           0     .     .
"110685" "19157" 2006  .012674472 16961 21184
"110685" "19157" 2006  .028032405 16961 21184
"110685" "19157" 2006   .02323636 16961 21184
"110685" "19157" 2006  .005167879 16961 21184
"110685" "19157" 2006 .0043826397 16961 21184
"110685" "19157" 2006  .016617246 16961 21184
"110685" "19157" 2006           0 16961 21184
"110685" "19157" 2006   .04788512 16961 21184
"110685" "19157" 2006  .014164975 16961 21184
"110685" "19157" 2006  .004850296 16961 21184
"110685" "19157" 2006  .014960206 16961 21184
"110685" "19157" 2006  .006969321 16961 21184
"110685" "19157" 2006  .032312267 16961 21184
"110685" "19157" 2006   .01097237 16961 21184
"110685" "19157" 2006    .0196256 16961 21184
"110685" "19157" 2006           0 16961 21184
"110685" "19157" 2006  .027710853 16961 21184
"110685" "19157" 2006 .0026719144 16961 21184
"110685" "19157" 2006  .029617343 16961 21184
"110685" "19157" 2006  .006126695 16961 21184
"110685" "32541" 2007  .008630783     .     .
"110685" "32541" 2007  .005710011     .     .
"110685" "32541" 2007           0     .     .
"110685" "32541" 2007  .007166917     .     .
"110685" "32541" 2007   .00622355     .     .
"110685" "32541" 2007  .031262353     .     .
"110685" "32541" 2007   .01935861     .     .
"110685" "32541" 2007  .020559963     .     .
"110685" "32541" 2007  .007754252     .     .
"110685" "32541" 2007           0     .     .
"110685" "28770" 2007   .11021227     .     .
"110685" "32541" 2007  .017284341     .     .
"110685" "32541" 2007  .008405057     .     .
"110685" "32541" 2007  .016005917     .     .
"110685" "32541" 2007   .04699543     .     .
"110685" "32541" 2007  .007618467     .     .
"110685" "32541" 2007  .011952196     .     .
"110685" "32541" 2007  .016687982     .     .
"110685" "32541" 2007  .010024874     .     .
"110685" "19157" 2007   .01003658 16961 21184
"110685" "32540" 2007           0     .     .
"110685" "30932" 2008  .009832938     .     .
"110685" "30932" 2008  .006377022     .     .
"110685" "30932" 2008    .0221992     .     .
"110685" "30932" 2008  .007321359     .     .
"110685" "30932" 2008  .028578777     .     .
"110685" "30932" 2008   .01767808     .     .
"110685" "30932" 2008   .00869535     .     .
"110685" "30932" 2008  .020334875     .     .
"110685" "30932" 2008  .004640795     .     .
"110685" "30932" 2008  .003961102     .     .
"110685" "30932" 2008           0     .     .
"110685" "30932" 2008  .005242107     .     .
"110685" "30932" 2008 .0011262402     .     .
"110685" "30932" 2008   .00708436     .     .
"110685" "30932" 2008           0     .     .
"110685" "32540" 2008   .00684149     .     .
"110685" "30932" 2008  .007424387     .     .
"110685" "30932" 2008  .002896309     .     .
"110685" "30932" 2008   .01452475     .     .
"110685" "30932" 2008  .013860462     .     .
"110685" "30932" 2008  .012535688     .     .
"110685" "30932" 2008  .025974026     .     .
"110685" "30932" 2008           0     .     .
"110685" "30932" 2008  .020934517     .     .
"110685" "30932" 2008  .002371433     .     .
"110685" "30932" 2008  .003610069     .     .
"110685" "30932" 2008   .01180824     .     .
"110685" "30932" 2008           0     .     .
"110685" "30932" 2008  .010950357     .     .
"110685" "30932" 2008   .01657825     .     .
"110685" "30932" 2008 .0027941116     .     .
"110685" "30932" 2008  .005863396     .     .
"110685" "30932" 2008   .01180824     .     .
"110685" "30932" 2008  .005380278     .     .
"110685" "30932" 2008  .001800634     .     .
"110685" "30932" 2008  .017387554     .     .
"110685" "30932" 2008  .006301138     .     .
"110685" "30932" 2008 .0043395623     .     .
"110685" "30932" 2008  .016949153     .     .
"110685" "35172" 2008   .01197048     .     .
"110685" "30932" 2008  .008070439     .     .
"110685" "30932" 2008  .031881146     .     .
"110685" "30932" 2008  .015520198     .     .
"110685" "30932" 2008   .02641504     .     .
"110685" "30932" 2008  .015719743     .     .
"110685" "30932" 2008  .003508772     .     .
"110685" "30932" 2008  .034185503     .     .
"110685" "30932" 2008  .005764092     .     .
"110685" "19157" 2008   .05504587 16961 21184
"110685" "30932" 2008   .01960823     .     .
"110685" "30932" 2008   .04200763     .     .
"110685" "30932" 2008  .008594683     .     .
"110685" "30932" 2008  .005196873     .     .
"110685" "30932" 2008  .016957583     .     .
"110685" "30932" 2008           0     .     .
"110685" "30932" 2008  .011128496     .     .
"110685" "19157" 2009   .02255427 16961 21184
"110685" "35172" 2009  .023423776     .     .
"110685" "32540" 2009  .031750854     .     .
"110685" "30932" 2009  .023423776     .     .
"110685" "35172" 2010  .018085962     .     .
"110685" "35172" 2010 .0043998593     .     .
"110685" "35172" 2010  .005685097     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .007854333     .     .
"110685" "35172" 2010 .0035200936     .     .
"110685" "35172" 2010  .007929098     .     .
"110685" "35172" 2010 .0028134936     .     .
"110685" "32540" 2010  .011747913     .     .
"110685" "30932" 2010 .0022322077     .     .
"110685" "35172" 2010  .012528665     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010 .0036567885     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .014399055     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .001789091     .     .
"110685" "35172" 2010  .015700327     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010           0     .     .
"110685" "19157" 2010  .007123293 16961 21184
"110685" "35172" 2010  .005209923     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010   .09298248     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .006486199     .     .
"110685" "35172" 2010  .007165377     .     .
"110685" "35172" 2010  .002765747     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010 .0030132916     .     .
"110685" "35172" 2010  .004761508     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .017311446     .     .
"110685" "35172" 2010  .004547423     .     .
"110685" "35172" 2010  .013120203     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .016112676     .     .
"110685" "35172" 2010 .0005330036     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .015100893     .     .
"110685" "35172" 2010    .0410942     .     .
"110685" "35172" 2010  .018491125     .     .
"110685" "35172" 2010   .01316985     .     .
"110685" "35172" 2010  .013046176     .     .
"110685" "35172" 2010  .007120124     .     .
"110685" "35172" 2010           0     .     .
"110685" "35172" 2010  .012058362     .     .
"110685" "35172" 2010  .007365913     .     .
"110685" "35172" 2010  .005942477     .     .
"110685" "35172" 2010  .011207015     .     .
"110685" "35172" 2011 .0027645195     .     .
"110685" "35172" 2011   .00726016     .     .
"110685" "35172" 2011           0     .     .
"110685" "35172" 2011  .014709343     .     .
"110685" "35172" 2011  .017862055     .     .
"110685" "35172" 2011  .018830264     .     .
"110685" "32540" 2011  .007308385     .     .
"110685" "30932" 2011           0     .     .
"110685" "19157" 2011   .01624548 16961 21184
"110685" "35172" 2011 .0015838298     .     .
"110685" "35172" 2011   .01695998     .     .
"110685" "35172" 2011  .004528493     .     .
"110685" "35172" 2011  .006131208     .     .
"110685" "35172" 2011           0     .     .
"110685" "35172" 2011 .0035150496     .     .
"110685" "35172" 2011 .0018948545     .     .
"110685" "35172" 2011  .009922604     .     .
"110685" "35172" 2011           0     .     .
"110685" "35172" 2011  .028846154     .     .
"110760" "18072" 2002  .009426848 10593 16192
"111103" "40702" 2009   .04329379     .     .
"111103" "31715" 2009   .04329379     .     .
"111103" "36691" 2009   .04329379     .     .
"111103" "36692" 2009   .04329379     .     .
"111103" "31716" 2009   .04329379     .     .
"111103" "31714" 2009   .04329379 13902 21457
"111491" "15819" 2003   .04136334     .     .
"111491" "25298" 2003   .04961906     .     .
"111491" "15819" 2004    .0512387     .     .
"111491" "25298" 2004    .0512387     .     .
"111491" "25298" 2005   .06120111     .     .
"111491" "15819" 2005   .06120111     .     .
"111491" "32057" 2006   .04940915     .     .
"111491" "32059" 2006   .04940915     .     .
"111491" "15819" 2006   .04940915     .     .
"111491" "32060" 2006   .04940915     .     .
"111491" "25298" 2006   .04940915     .     .
"111491" "32058" 2006   .04940915     .     .
"111491" "32057" 2007   .06064649     .     .
"111491" "32060" 2007   .06064649     .     .
"111491" "33893" 2007   .06064649     .     .
"111491" "32058" 2007   .06064649     .     .
"111491" "32059" 2007   .06064649     .     .
"111491" "32060" 2007   .06064649     .     .
"111491" "32057" 2008           0     .     .
"111491" "32059" 2008   .01399937     .     .
"111491" "32058" 2008   .01399937     .     .
"112033" "28309" 2002   .07531299     .     .
"112033" "20058" 2002   .07531299 15341 16205
"112033" "20057" 2002   .07531299     .     .
"112033" "20056" 2002   .07531299 12419 15341
"112033" "26099" 2002   .07531299     .     .
"112033" "21783" 2002   .07531299     .     .
"112033" "20059" 2002   .07531299     .     .
"112033" "25549" 2002   .03942622     .     .
"112033" "20057" 2003   .06738544     .     .
"112033" "20058" 2003   .06738544 15341 16205
"112033" "28309" 2003   .06738544     .     .
"112033" "25549" 2003   .06738544     .     .
"112033" "26099" 2003   .06738544     .     .
"112033" "21783" 2003   .06738544     .     .
"112033" "26099" 2004  .021486085     .     .
"112033" "21783" 2004  .021486085     .     .
"112033" "25549" 2004  .021486085     .     .
"112033" "28308" 2004  .021486085     .     .
"112033" "28307" 2004  .021486085 16253 23011
"112033" "20058" 2004  .021486085 15341 16205
"112033" "28309" 2004  .021486085     .     .
"112033" "28308" 2006  .031324558     .     .
"112033" "29782" 2006  .031324558     .     .
"112033" "28307" 2006  .031324558 16253 23011
"112033" "29783" 2006  .031324558     .     .
"112033" "31109" 2006  .031324558     .     .
"112033" "31109" 2007  .004910771     .     .
"112033" "28307" 2007  .004910771 16253 23011
"112033" "28308" 2007  .004910771     .     .
"112033" "29783" 2007  .004910771     .     .
"112033" "29782" 2007  .004910771     .     .
"112033" "29783" 2008  .008438818     .     .
"112033" "28308" 2008  .008438818     .     .
"112033" "31109" 2008  .008438818     .     .
"112033" "28307" 2008  .008438818 16253 23011
"112033" "29782" 2008  .008438818     .     .
"112095" "34115" 2011           0     .     .
"113490" "42358" 2008  .004338395 20606 23011
"113490" "42360" 2008  .004338395     .     .
"113490" "42354" 2008  .004338395     .     .
"113490" "42359" 2008  .004338395 15188 17714
"114524" "35212" 2009           0     .     .
"114524" "26136" 2009           0     .     .
"114524" "35213" 2009           0     .     .
"114524" "37634" 2009           0     .     .
"114524" "24555" 2009           0     .     .
"116504" "26669" 2002  .003892868 14670 19145
"116504" "26669" 2003  .016025642 14670 19145
"116504" "26669" 2004  .009811617 14670 19145
"116504" "29489" 2006  .010204081     .     .
"116504" "26669" 2006  .010204081 14670 19145
"116504" "33508" 2007  .010238908     .     .
"116504" "40005" 2007  .010238908 19145 23011
"116504" "26669" 2007  .010238908 14670 19145
"116504" "29489" 2007  .010238908     .     .
"116504" "40005" 2009  .008012821 19145 23011
"116504" "26669" 2009  .008012821 14670 19145
"116504" "29489" 2009  .008012821     .     .
"116526" "14051" 2007   .00622479 14245 17356
"116526" "34759" 2007   .00622479     .     .
"116526" "18127" 2007   .00622479     .     .
"116526" "32356" 2007   .00622479     .     .
"116526" "24330" 2007   .00622479     .     .
"116526" "24983" 2007   .00622479 17356 17647
"116526" "34760" 2007   .00622479 18737 19540
"116526" "24983" 2008   .01927092 17356 17647
"116526" "20174" 2008 .0023503364     .     .
"116526" "32356" 2008 .0023503364     .     .
"116526" "34759" 2008 .0023503364     .     .
"116526" "34760" 2008 .0023503364 18737 19540
"116526" "32356" 2008 .0023503364     .     .
"116526" "34760" 2010  .003904115 18737 19540
"116526" "36681" 2010  .003904115     .     .
"116526" "20174" 2010  .003904115     .     .
"116526" "34759" 2010  .003904115     .     .
"117768" "24786" 2005           0     .     .
"117768" "19584" 2005           0     .     .
"117768" "19583" 2005           0 12144 23011
"117768" "31171" 2006           0     .     .
"117768" "24786" 2006           0     .     .
"117768" "19583" 2006           0 12144 23011
"117768" "19583" 2008 .0015759735 12144 23011
"117768" "24786" 2008 .0015759735     .     .
"117768" "31171" 2008 .0015759735     .     .
"117768" "31171" 2010           0     .     .
"117768" "24786" 2010           0     .     .
"117768" "28992" 2010  .002961734     .     .
"117768" "19583" 2010           0 12144 23011
"117861" "49887" 2007  .067760214 12478 19237
"117861" "49887" 2007   .05619137 12478 19237
"117861" "49878" 2007 .0035511365     .     .
"117861" "49883" 2007   .05658697     .     .
"117861" "49884" 2007   .02878816 19237 23011
"117861" "49879" 2007  .021215454     .     .
"117861" "49879" 2008    .0934478     .     .
"117861" "49878" 2008   .05749956     .     .
"117861" "49883" 2008  .024936827     .     .
"117861" "49884" 2008  .024936827 19237 23011
"117861" "49887" 2008   .02134922 12478 19237
"117861" "49884" 2009    .0491148 19237 23011
"117861" "49886" 2009    .0491148     .     .
"117861" "49878" 2009   .04666543     .     .
"117861" "49887" 2009    .0491148 12478 19237
"117861" "49879" 2009    .0491148     .     .
"117861" "49883" 2009    .0491148     .     .
"117861" "49886" 2010  .016391158     .     .
"117861" "49887" 2010   .04296786 12478 19237
"117861" "49878" 2010  .016391158     .     .
"117861" "49883" 2010   .04337877     .     .
"117861" "49884" 2010  .016391158 19237 23011
"117861" "49887" 2011  .020319615 12478 19237
"117861" "49884" 2011  .020319615 19237 23011
"117861" "49883" 2011  .022468304     .     .
"117861" "49886" 2011  .020319615     .     .
"117862" "19722" 2003  .003416281     .     .
"117862" "19721" 2003  .003416281     .     .
"117862" "12606" 2003  .003416281 14282 18920
"117862" "25018" 2003  .003416281     .     .
"117862" "26235" 2003  .003416281     .     .
"117862" "19722" 2004   .01847343     .     .
"117862" "19721" 2004   .01847343     .     .
"117862" "12606" 2004   .01847343 14282 18920
"117862" "25018" 2004   .01847343     .     .
"117862" "25018" 2005  .002825729     .     .
"117862" "19721" 2005  .002825729     .     .
"117862" "19722" 2005  .002825729     .     .
"117862" "12606" 2005  .002825729 14282 18920
"117862" "25018" 2006  .005791036     .     .
"117862" "12606" 2006  .006276124 14282 18920
"117862" "19722" 2006  .005791036     .     .
"117862" "19721" 2006  .005791036     .     .
"117862" "25018" 2007 .0018761304     .     .
"117862" "33632" 2007 .0018761304     .     .
"117862" "19722" 2007 .0018761304     .     .
"117862" "19721" 2007    .0283084     .     .
"117862" "12606" 2007 .0043140827 14282 18920
"117862" "33632" 2008  .010821603     .     .
"117862" "12606" 2008  .010821603 14282 18920
"117862" "25018" 2008  .010821603     .     .
"117862" "19721" 2008  .010821603     .     .
"117862" "19721" 2009           0     .     .
"117862" "25018" 2009           0     .     .
"117862" "12606" 2009           0 14282 18920
"117862" "33632" 2009  .002692312     .     .
"117862" "37640" 2009           0     .     .
"118122" "17698" 2002  .021633783     .     .
"118122" "17698" 2002   .05894858     .     .
"118122" "17698" 2002           0     .     .
"118122" "17698" 2002  .019616613     .     .
"118122" "19028" 2002  .006348664 18176 20148
"118122" "17698" 2002  .003030303     .     .
"118122" "19029" 2002  .026565576     .     .
"118122" "17698" 2002   .03059281     .     .
"118122" "17698" 2002  .010297786     .     .
"118122" "17701" 2002   .02812386     .     .
"118122" "19029" 2003   .00331049     .     .
"118122" "17698" 2003  .016942117     .     .
"118122" "19029" 2003   .02361108     .     .
"118122" "30351" 2003  .022348955     .     .
"118122" "19029" 2003   .02884825     .     .
"118122" "19029" 2003  .016433703     .     .
"118122" "19029" 2003  .023421973     .     .
"118122" "19029" 2003  .019780703     .     .
"118122" "19029" 2003   .01684568     .     .
"118122" "19029" 2003   .01432586     .     .
"118122" "19029" 2003   .00651688     .     .
"118122" "19029" 2003   .02308673     .     .
"118122" "19029" 2003  .008469732     .     .
"118122" "19029" 2003   .03355261     .     .
"118122" "19029" 2003   .03108638     .     .
"118122" "19029" 2003   .03433629     .     .
"118122" "19029" 2003 .0010729786     .     .
"118122" "19029" 2003  .010839722     .     .
end
format %td start_date
format %td end_date

------------------ copy up to and including the previous line ------------------

Listed 500 out of 5300 observations

.

[Clyde Schechter]

Thank you. Unfortunately, there is a big problem with the data itself now. There are many, many instances of the same combination of GVKEY, EXECID, and YEAR occurring with contradictory values of inj_hour. In one case, there are actually 48 different values of inj_hour for the same EXECID at the same GVKEY and same YEAR. While that is an extreme case, it is not the only one, and not the only one with a large number of contradictions. Are these "surplus" contradictory observations measured at different months, or weeks, or something like that? If so, do you have a variable that shows the date when they were actually measured? If so, that would resolve this.

If not, you need to review how you arrived at this injury rate data and fix this problem. We can't proceed until the data are correct or properly explained.

[BB Kim]

I found the reason why. The data is not only differentiated by GVKEY(company name), but also city, state, estab_name (establishment name 1) and estab_name2 (establishment name 2)
Here is the revised data set. there are 4367 obs in total but I posted 200



dataex city state estab_name estab_name2 GVKEY EXECID YEAR inj_hour start_date end_date, count(200)

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input str100 city str8 state str77 estab_name str62 estab_name2 str6(GVKEY EXECID) double YEAR float(inj_hour start_date end_date)
"Sidney"               "NE" "ADC Digital Communications"                    ""                                        "177267" "34262" 2007  .020279275 20886 23011
"Eden Prairie"         "MN" "ADC Telecommunications Inc"                    ""                                        "177267" "34262" 2007  .004152192 20886 23011
"Eden Prairie"         "MN" "ADC Telecommunications Inc"                    ""                                        "177267" "24546" 2008   .00136643 16802 20886
"Eden Prairie"         "MN" "ADC Telecommunications Inc"                    ""                                        "177267" "34262" 2010  .005478361 20886 23011
"THOMSON"              "GA" "ADVANCE STORES COMPANY INC"                    "ADVANCE AUTO PARTS"                      "145977" "28101" 2003  .028846154 16557 17257
"THOMSON"              "GA" "ADVANCE STORES COMPANY INC"                    "ADVANCE AUTO PARTS"                      "145977" "28099" 2004  .032467533 14641 16574
"ROANOKE"              "VA" "ADVANCE STORES COMPANY INC"                    "ADVANCED AUTO PARTS"                     "145977" "32731" 2007   .01923077 17263 17532
"San Antonio"          "TX" "AECOM"                                         ""                                        "147988" "37774" 2007           0 16710 19788
"SIMI VALLEY"          "CA" "AEROVIRONMENT INC"                             ""                                        "176362" "37909" 2011  .009368043 11688 20575
"SIMI VALLEY"          "CA" "AEROVIRONMENT INC"                             ""                                        "176362" "43628" 2011  .009368043 20576 23011
"Chicopee"             "MA" "AGE Institute of Massachusetts Inc dba"        "Williamsett Center East"                 "157355" "09105" 2004   .06012024 15826 23011
"Chicopee"             "MA" "AGE Institute of Massachusetts Inc dba"        "Williamsett Center East"                 "157355" "09105" 2005   .11219488 15826 23011
"Chicopee"             "MA" "AGE Institute of Massachusetts Inc dba"        "Williamsett Center East"                 "157355" "09105" 2006   .06610522 15826 23011
"ALLENTOWN"            "PA" "AGERE SYSTEMS"                                 ""                                        "141845" "20559" 2002           0 14823 16735
"SANTA CLARA"          "CA" "AGILENT TECHNOLOGIES, INC"                     ""                                        "126554" "18350" 2011 .0036873526 16496 20165
"SAN JOSE"             "CA" "ALIGN TECHNOLOGY, INC"                         ""                                        "141384" "36420" 2011  .002467223 15400 20240
"DETROIT"              "MI" "AMERICAN AXLE & MANUFACTURING, INC"            ""                                        "117861" "49887" 2011  .022468304 12478 19237
"LATHAM"               "NY" "ANGIODYNAMICS, INC"                            ""                                        "264387" "46668" 2011           0 18877 20548
"LATHAM"               "NY" "ANGIODYNAMICS, INC"                            ""                                        "264387" "46669" 2011           0 17957 18791
"LATHAM"               "NY" "ANGIODYNAMICS, INC"                            ""                                        "264387" "46673" 2011           0 18791 18877
"BLOOMINGTON"          "MN" "ARAMARK"                                       ""                                        "144519" "23098" 2002   .05744221 16071 16335
"LUBBOCK"              "TX" "ARAMARK SERVICES INC"                          "ARAMARK"                                 "144519" "23098" 2002   .07878254 16071 16335
"LUBBOCK"              "TX" "ARAMARK SERVICES INC"                          "ARAMARK"                                 "144519" "23097" 2003   .08651829 16335 23011
"LUBBOCK"              "TX" "ARAMARK SERVICES INC"                          "ARAMARK"                                 "144519" "23097" 2004  .029571403 16335 23011
"FARMINGDALE"          "NY" "ARAMARK SERVICES INC."                         "ARAMARK- Farmingdale State College"      "144519" "23097" 2005           0 16335 23011
"FARMINGDALE"          "NY" "ARAMARK SERVICES INC."                         "ARAMARK- Farmingdale State College"      "144519" "23097" 2008           0 16335 23011
"DECATUR"              "IL" "ARAMARK UNF & CAREER AP INC"                   "ARAMARK"                                 "144519" "23097" 2002  .071821615 16335 23011
"DECATUR"              "IL" "ARAMARK UNF & CAREER AP INC"                   "ARAMARK"                                 "144519" "23098" 2003  .017610801 16071 16335
"DECATUR"              "IL" "ARAMARK UNF & CAREER AP INC"                   "ARAMARK"                                 "144519" "23097" 2004   .03859152 16335 23011
"DECATUR"              "IL" "ARAMARK UNF & CAREER AP INC"                   "ARAMARK"                                 "144519" "23097" 2005   .03012357 16335 23011
"DECATUR"              "IL" "ARAMARK UNF & CAREER AP INC"                   "ARAMARK"                                 "144519" "23097" 2007  .029962907 16335 23011
"DECATUR"              "IL" "ARAMARK UNF & CAREER AP INC"                   "ARAMARK"                                 "144519" "23097" 2008  .034225713 16335 23011
"LANSING"              "KS" "ARAMARK UNIFORM SERVICES"                      "Aramark"                                 "144519" "23097" 2008    .0563878 16335 23011
"GREENSBORO"           "NC" "ARAMARK UNIFORM SERVICES (NORTH CAROLINA) LLC" "Aramark"                                 "144519" "23097" 2008  .019103413 16335 23011
"Sacramento"           "CA" "AT&T Wireless"                                 "EH&S Compliance"                         "134845" "12739" 2003  .004875406 14245 23011
"MONTEREY PARK"        "CA" "AXT INC"                                       "AXT OPTO ELECTRONICS"                    "110760" "09026" 2002  .009426848 16192 16527
"MONTEREY PARK"        "CA" "AXT INC"                                       "AXT OPTO ELECTRONICS"                    "110760" "18072" 2002  .009426848 10593 16192
"Fresno"               "CA" "Activision Blizzard"                           ""                                        "180405" "22978" 2008   .02418965 11354 23011
"Fresno"               "CA" "Activision Blizzard"                           ""                                        "180405" "22978" 2010   .07525587 11354 23011
"Fresno"               "CA" "Activision Blizzard"                           ""                                        "180405" "22978" 2011   .01495439 11354 23011
"Conyers"              "GA" "Acuity Brands Lighting"                        "Conyers Complex"                         "146017" "11057" 2002   .02063944 16315 21945
"Edison"               "NJ" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2002   .03434066 16315 21945
"Austin"               "TX" "Acuity Brands Lighting"                        "Josh Dowis"                              "146017" "12125" 2004   .02998642 15310 16314
"Edison"               "NJ" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "12125" 2004  .019132653 15310 16314
"Winona"               "MN" "Acuity Brands Lighting"                        ""                                        "146017" "12125" 2004  .015332296 15310 16314
"Hanover Park"         "IL" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2004   .07307189 16315 21945
"Conyers"              "GA" "Acuity Brands Lighting"                        "Conyers Complex"                         "146017" "12125" 2004   .07071278 15310 16314
"Hanover Park"         "IL" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2005   .04533502 16315 21945
"Hanover Park"         "IL" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2006   .07354744 16315 21945
"Austin"               "TX" "Acuity Brands Lighting"                        "Josh Dowis"                              "146017" "11057" 2006   .07742824 16315 21945
"Winona"               "MN" "Acuity Brands Lighting"                        ""                                        "146017" "11057" 2006  .019170953 16315 21945
"Austin"               "TX" "Acuity Brands Lighting"                        "Josh Dowis"                              "146017" "11057" 2007  .062741786 16315 21945
"Conyers"              "GA" "Acuity Brands Lighting"                        "Conyers Complex"                         "146017" "11057" 2007  .014861388 16315 21945
"Chatsworth"           "CA" "Acuity Brands Lighting"                        "Hydrel"                                  "146017" "11057" 2007   .05749822 16315 21945
"Edison"               "NJ" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2007    .1005747 16315 21945
"Hanover Park"         "IL" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2007    .1005747 16315 21945
"Hanover Park"         "IL" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2008   .07672203 16315 21945
"Edison"               "NJ" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2008   .12482663 16315 21945
"Conyers"              "GA" "Acuity Brands Lighting"                        "Conyers Complex"                         "146017" "11057" 2008  .010201412 16315 21945
"Winona"               "MN" "Acuity Brands Lighting"                        ""                                        "146017" "11057" 2008   .02415274 16315 21945
"Austin"               "TX" "Acuity Brands Lighting"                        "Josh Dowis"                              "146017" "11057" 2008  .024758736 16315 21945
"Chatsworth"           "CA" "Acuity Brands Lighting"                        "Hydrel"                                  "146017" "11057" 2008  .029438894 16315 21945
"Edison"               "NJ" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2010   .09155966 16315 21945
"Conyers"              "GA" "Acuity Brands Lighting"                        "Conyers Complex"                         "146017" "11057" 2010  .007968845 16315 21945
"Winona"               "MN" "Acuity Brands Lighting"                        ""                                        "146017" "11057" 2010   .02657005 16315 21945
"Austin"               "TX" "Acuity Brands Lighting"                        "Josh Dowis"                              "146017" "11057" 2010   .02612279 16315 21945
"Hanover Park"         "IL" "Acuity Brands Lighting"                        "Mark Architectrual Lighting"             "146017" "11057" 2010   .06424166 16315 21945
"Edison"               "NJ" "Acuity Brands Lighting"                        ""                                        "146017" "11057" 2011   .06223098 16315 21945
"Hanover Park"         "IL" "Acuity Brands Lighting"                        ""                                        "146017" "11057" 2011   .00707664 16315 21945
"Vermilion"            "OH" "Acuity Lighting Group Inc"                     "Lithonia Lighting"                       "146017" "11057" 2002  .031351548 16315 21945
"Northbrook"           "IL" "Acuity Lighting Group Inc"                     "Major Reflector"                         "146017" "12125" 2002   .03919484 15310 16314
"Newark"               "OH" "Acuity Lighting Group Inc"                     "Holophane"                               "146017" "11057" 2003  .034499645 16315 21945
"Northbrook"           "IL" "Acuity Lighting Group Inc"                     "Major Reflector"                         "146017" "12125" 2003   .04321059 15310 16314
"Berkeley"             "CA" "Acuity Lighting Group Inc"                     "Peerless"                                "146017" "12125" 2004  .020577084 15310 16314
"Vermilion"            "OH" "Acuity Lighting Group Inc"                     "Lithonia Lighting"                       "146017" "12125" 2004    .0210246 15310 16314
"Conyers"              "GA" "Acuity Lighting Group Inc"                     "Lithonia Lighting"                       "146017" "12125" 2004  .008231128 15310 16314
"Conyers"              "GA" "Acuity Lighting Group Inc"                     "Lithonia Lighting"                       "146017" "11057" 2005  .015099945 16315 21945
"Austin"               "TX" "Acuity Lighting Group Inc"                     "Austin Lighting Products"                "146017" "11057" 2005   .03933246 16315 21945
"Berkeley"             "CA" "Acuity Lighting Group Inc"                     "Peerless"                                "146017" "11057" 2008           0 16315 21945
"COCHRAN"              "GA" "Acuity Lighting Group, Inc."                   "Georgia Production Facility"             "146017" "11057" 2002    .0755611 16315 21945
"COCHRAN"              "GA" "Acuity Lighting Group, Inc."                   "Georgia Production Facility"             "146017" "12125" 2004    .0559379 15310 16314
"COCHRAN"              "GA" "Acuity Lighting Group, Inc."                   "Georgia Production Facility"             "146017" "11057" 2005    .0530684 16315 21945
"COCHRAN"              "GA" "Acuity Lighting Group, Inc."                   "Georgia Production Facility"             "146017" "11057" 2006  .027968567 16315 21945
"COCHRAN"              "GA" "Acuity Lighting Group, Inc."                   "Georgia Production Facility"             "146017" "11057" 2008   .02291336 16315 21945
"COCHRAN"              "GA" "Acuity Lighting Group, Inc."                   "Georgia Production Facility"             "146017" "11057" 2010   .01699699 16315 21945
"Jeffersonville"       "OH" "Advance Auto Parts"                            "Advance Stores Company Inc"              "145977" "28099" 2002   .03105376 14641 16574
"Jeffersonville"       "OH" "Advance Auto Parts"                            "Advance Stores Company Inc"              "145977" "28101" 2002   .03105376 16557 17257
"Jeffersonville"       "OH" "Advance Auto Parts"                            "Advance Stores Company Inc"              "145977" "28099" 2003   .07250448 14641 16574
"Jeffersonville"       "OH" "Advance Auto Parts"                            "Advance Stores Company Inc"              "145977" "28101" 2004  .023196295 16557 17257
"Catoosa"              "OK" "Advance Research Chemicals Inc"                ""                                        "117862" "12606" 2009           0 14282 18920
"Delaware"             "OH" "Advance Stores Company Inc"                    "Delaware Distribution Center"            "145977" "28101" 2003    .1213807 16557 17257
"Andersonville"        "TN" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "28101" 2003  .018957347 16557 17257
"Delaware"             "OH" "Advance Stores Company Inc"                    "Delaware Distribution Center"            "145977" "28101" 2004    .0895755 16557 17257
"Delaware"             "OH" "Advance Stores Company Inc"                    "Delaware Distribution Center"            "145977" "28101" 2005    .0459219 16557 17257
"Andersonville"        "TN" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "28099" 2005  .007571169 14641 16574
"Andersonville"        "TN" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "28101" 2006   .01390911 16557 17257
"Delaware"             "OH" "Advance Stores Company Inc"                    "Delaware Distribution Center"            "145977" "28101" 2006   .03858202 16557 17257
"Byron"                "GA" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "28101" 2007           0 16557 17257
"Thomson"              "GA" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "32731" 2007   .03159341 17263 17532
"Temple"               "TX" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "13283" 2009           0 17538 20455
"Andersonville"        "TN" "Advance Stores Company Inc"                    "Advance Auto Parts"                      "145977" "13283" 2010  .011126874 17538 20455
"Painesville"          "OH" "Aero Fluid Products"                           "Gerry Van Schoick"                       "148349" "49893" 2008           0 15706 21299
"Painesville"          "OH" "Aero Fluid Products"                           "Gerry Van Schoick"                       "148349" "49893" 2010  .010443864 15706 21299
"Orlando"              "FL" "Agere Systems Inc"                             ""                                        "141845" "20559" 2003  .008305585 14823 16735
"Allentown"            "PA" "Agere Systems Inc"                             ""                                        "141845" "20559" 2005           0 14823 16735
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "05669" 2005 .0028326125 14368 16496
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "18350" 2006 .0025221636 16496 20165
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "18350" 2008  .008773546 16496 20165
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "37687" 2009  .006683554 20165 23011
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "18350" 2009  .006683554 16496 20165
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "37687" 2010  .006499774 20165 23011
"Lexington"            "MA" "Agilent Technologies"                          ""                                        "126554" "18350" 2010  .006499774 16496 20165
"LAKE FOREST"          "CA" "Agilent Technologies"                          "(Formerly Varian/Ansys)"                 "126554" "37687" 2011 .0040283273 20165 23011
"Cary"                 "NC" "Agilent Technologies - Dissolution Testing"    ""                                        "126554" "18350" 2011           0 16496 20165
"Loveland"             "CO" "Agilent Technologies Inc"                      ""                                        "126554" "18350" 2005 .0007641696 16496 20165
"Wilmington"           "DE" "Agilent Technologies Inc"                      ""                                        "126554" "05669" 2005 .0015968063 14368 16496
"Loveland"             "CO" "Agilent Technologies Inc"                      ""                                        "126554" "18350" 2006  .001833584 16496 20165
"Wilmington"           "DE" "Agilent Technologies Inc"                      ""                                        "126554" "18350" 2007  .003160606 16496 20165
"Loveland"             "CO" "Agilent Technologies Inc"                      ""                                        "126554" "18350" 2007  .001200757 16496 20165
"Wilmington"           "DE" "Agilent Technologies Inc"                      ""                                        "126554" "18350" 2008 .0007941676 16496 20165
"Loveland"             "CO" "Agilent Technologies Inc"                      ""                                        "126554" "18350" 2008 .0012807787 16496 20165
"Lawrenceville"        "GA" "Air Mark Unf & Career AP Co"                   ""                                        "144519" "23097" 2005  .032431733 16335 23011
"Lawrenceville"        "GA" "Air Mark Unf & Career AP Co"                   ""                                        "144519" "23097" 2007           0 16335 23011
"Youngsville"          "NC" "Alcan Global Phrm Packg Inc"                   "Alcan Global Pharmaceutical Packaging"   "100243" "57336" 2007 .0044252095 16618 20195
"Westport"             "IN" "Alcan Global Phrm Packg Inc"                   ""                                        "100243" "57336" 2007  .005036769 16618 20195
"Youngsville"          "NC" "Alcan Global Phrm Packg Inc"                   "Alcan Global Pharmaceutical Packaging"   "100243" "57336" 2008   .01382904 16618 20195
"Westport"             "IN" "Alcan Global Phrm Packg Inc"                   ""                                        "100243" "57336" 2009  .004714001 16618 20195
"Santa Clara"          "CA" "Align Technology Inc"                          "Invisalign"                              "141384" "36420" 2006  .002405668 15400 20240
"Madison"              "WI" "Amcor Flexibles"                               ""                                        "100243" "57336" 2008  .018747656 16618 20195
"Madison"              "WI" "Amcor Flexibles"                               ""                                        "100243" "57336" 2010           0 16618 20195
"Mundelein"            "IL" "Amcor Flexibles Healthcare"                    ""                                        "100243" "57336" 2007  .011575146 16618 20195
"Mundelein"            "IL" "Amcor Flexibles Healthcare"                    ""                                        "100243" "57336" 2009  .013495732 16618 20195
"Lathrop"              "CA" "Amcor PET Packaging"                           ""                                        "100243" "57336" 2008   .00497879 16618 20195
"Orlando"              "FL" "Amcor Pet Packaging"                           ""                                        "100243" "57336" 2008  .008391233 16618 20195
"Orlando"              "FL" "Amcor Pet Packaging"                           ""                                        "100243" "57336" 2009           0 16618 20195
"Fort Worth"           "TX" "Amcor Pet Packaging USA Inc"                   ""                                        "100243" "57336" 2007  .015241192 16618 20195
"Allentown"            "PA" "Amcor Pet Packaging USA Inc"                   ""                                        "100243" "57336" 2007   .02066692 16618 20195
"Allentown"            "PA" "Amcor Pet Packaging USA Inc"                   ""                                        "100243" "57336" 2008  .009904962 16618 20195
"Fort Worth"           "TX" "Amcor Pet Packaging USA Inc"                   ""                                        "100243" "57336" 2009           0 16618 20195
"Allentown"            "PA" "Amcor Pet Packaging USA Inc"                   ""                                        "100243" "57336" 2009  .007557018 16618 20195
"Shelbyville"          "KY" "Amcor Pharmaceutical Packaging USA, Inc."      "Mark Casey"                              "100243" "57336" 2007  .008341861 16618 20195
"Commerce"             "CA" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2007 .0028061275 16618 20195
"Itasca"               "IL" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2007  .011624978 16618 20195
"Dunkirk"              "NY" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2008           0 16618 20195
"Kenosha"              "WI" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2009           0 16618 20195
"Itasca"               "IL" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2009  .007492742 16618 20195
"Dunkirk"              "NY" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2009  .014764506 16618 20195
"Commerce"             "CA" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2009  .006733485 16618 20195
"Fairfield"            "CA" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2009  .009264979 16618 20195
"BATAVIA"              "IL" "Amcor Rigid Plastics"                          ""                                        "100243" "57336" 2011  .014235855 16618 20195
"BATAVIA"              "IL" "Amcor Rigid Plastics"                          ""                                        "100243" "57328" 2011  .014235855 20195 23011
"Shawnee Mission"      "KS" "Amcor Rigid Plastics North America"            ""                                        "100243" "57336" 2007  .006847908 16618 20195
"Shawnee Mission"      "KS" "Amcor Rigid Plastics North America"            ""                                        "100243" "57336" 2008  .003934545 16618 20195
"Shawnee Mission"      "KS" "Amcor Rigid Plastics North America"            ""                                        "100243" "57336" 2009  .004510661 16618 20195
"Nicholasville"        "KY" "Amcor Rigid Plastics USA Inc"                  ""                                        "100243" "57336" 2007  .006067207 16618 20195
"Nicholasville"        "KY" "Amcor Rigid Plastics USA Inc"                  ""                                        "100243" "57336" 2009  .007319858 16618 20195
"Napoleon"             "OH" "Amcor Rigid Plastics, NA"                      ""                                        "100243" "57336" 2009           0 16618 20195
"Millville"            "NJ" "Amcor Specialty Packaging"                     ""                                        "100243" "57336" 2008   .01365859 16618 20195
"Millville"            "NJ" "Amcor Specialty Packaging"                     ""                                        "100243" "57336" 2009  .003073953 16618 20195
"Buffalo"              "NY" "American Axle & Manufacturing"                 "Buffalo Gear & Axle Facility"            "117861" "49887" 2007   .05658697 12478 19237
"Three Rivers"         "MI" "American Axle & Manufacturing"                 "Propeller Shaft Plant"                   "117861" "49887" 2007   .05619137 12478 19237
"Tonawanda"            "NY" "American Axle & Manufacturing"                 "Tonawanda Forge Facility"                "117861" "49884" 2007  .067760214 19237 23011
"Three Rivers"         "MI" "American Axle & Manufacturing"                 "Propeller Shaft Plant"                   "117861" "49887" 2008   .05749956 12478 19237
"Detroit"              "MI" "American Axle & Manufacturing"                 "Detroit Mfg Center"                      "117861" "49884" 2008    .0934478 19237 23011
"Three Rivers"         "MI" "American Axle & Manufacturing"                 "Propeller Shaft Plant"                   "117861" "49887" 2009   .04666543 12478 19237
"Detroit"              "MI" "American Axle & Manufacturing"                 "Detroit Mfg Center"                      "117861" "49884" 2009    .0491148 19237 23011
"Three Rivers"         "MI" "American Axle & Manufacturing"                 "Propeller Shaft Plant"                   "117861" "49887" 2010   .04296786 12478 19237
"Three Rivers"         "MI" "American Axle & Manufacturing"                 "Propeller Shaft Plant"                   "117861" "49884" 2011  .020319615 19237 23011
"Detroit"              "MI" "American Axle & Mfg Holdings"                  ""                                        "117861" "49887" 2007 .0035511365 12478 19237
"Knoxville"            "TN" "American Safety Razor Company"                 ""                                        "133367" "22884" 2003  .017180212 16461 20269
"Knoxville"            "TN" "American Safety Razor Company"                 ""                                        "133367" "22884" 2007    .0601723 16461 20269
"Knoxville"            "TN" "American Safety Razor Company"                 ""                                        "133367" "22884" 2010   .02689859 16461 20269
"Santa Clara"          "CA" "Amkor Technology Inc"                          ""                                        "110039" "59664" 2007           0 18171 19486
"Santa Clara"          "CA" "Amkor Technology Inc"                          ""                                        "110039" "59669" 2007           0 13758 18171
"Santa Clara"          "CA" "Amkor Technology Inc"                          ""                                        "110039" "59664" 2008           0 18171 19486
"Santa Clara"          "CA" "Amkor Technology Inc"                          ""                                        "110039" "59669" 2008           0 13758 18171
"Queensbury"           "NY" "AngioDynamics"                                 ""                                        "264387" "46671" 2007  .003561254 13301 17957
"Fremont"              "CA" "AngioDynamics"                                 ""                                        "264387" "46671" 2008           0 13301 17957
"Queensbury"           "NY" "AngioDynamics"                                 ""                                        "264387" "46669" 2008  .010821172 17957 18791
"Bakersfield"          "CA" "Aramark Corporation"                           "Aramark"                                 "144519" "23097" 2007    .1656452 16335 23011
"DENVER"               "CO" "Aramark Refreshment Svcs Inc"                  ""                                        "144519" "23097" 2004  .026768267 16335 23011
"Norristown"           "PA" "Aramark Refreshment Svcs Inc"                  "Aramark"                                 "144519" "23097" 2004   .07796055 16335 23011
"Denali National Park" "AK" "Aramark Services Inc"                          "Aramark"                                 "144519" "23097" 2003           0 16335 23011
"Denali National Park" "AK" "Aramark Services Inc"                          "Aramark"                                 "144519" "23097" 2004           0 16335 23011
"Rochester"            "NY" "Aramark Sports & Entertainment"                "Aramark"                                 "144519" "23098" 2004   .06918021 16071 16335
"Madison"              "WI" "Aramark Uniform & Career AP"                   "Aramark"                                 "144519" "23097" 2007    .0505649 16335 23011
"Sacramento"           "CA" "Aramark Uniform & Career AP"                   "Aramark"                                 "144519" "23097" 2007  .032198112 16335 23011
"Memphis"              "TN" "Aramark Uniform Services"                      "Aramark Uniform and Career Apparel, LLC" "144519" "23097" 2004   .03006669 16335 23011
"Lincoln"              "NE" "Aramark Uniform Services"                      ""                                        "144519" "23097" 2004   .07827635 16335 23011
"Memphis"              "TN" "Aramark Uniform Services"                      "Aramark Uniform and Career Apparel, LLC" "144519" "23097" 2007  .014814522 16335 23011
"Lincoln"              "NE" "Aramark Uniform Services"                      ""                                        "144519" "23097" 2007  .032545198 16335 23011
"Lincoln"              "NE" "Aramark Uniform Services"                      ""                                        "144519" "23097" 2008   .02183435 16335 23011
"Memphis"              "TN" "Aramark Uniform Services"                      "Aramark Uniform and Career Apparel, LLC" "144519" "23097" 2008  .017932314 16335 23011
"Rochester"            "NY" "Arch Chemicals Inc"                            ""                                        "117862" "12606" 2003  .003416281 14282 18920
"Rochester"            "NY" "Arch Chemicals Inc"                            ""                                        "117862" "12606" 2004   .01847343 14282 18920
"Charleston"           "TN" "Arch Chemicals Inc"                            "Charles Caudill"                         "117862" "12606" 2005  .002825729 14282 18920
"BRANDENBURG"          "KY" "Arch Chemicals Inc"                            ""                                        "117862" "12606" 2006  .005791036 14282 18920
"Rochester"            "NY" "Arch Chemicals Inc"                            ""                                        "117862" "12606" 2006  .006276124 14282 18920
"Rochester"            "NY" "Arch Chemicals Inc"                            ""                                        "117862" "12606" 2007    .0283084 14282 18920
"BRANDENBURG"          "KY" "Arch Chemicals Inc"                            ""                                        "117862" "12606" 2007 .0018761304 14282 18920
end
format %td start_date
format %td end_date

------------------ copy up to and including the previous line ------------------

Listed 200 out of 4367 observations

[BB Kim]

Also, using the above dataset, if I want to regress at the firm level (GVKEY) using reghdfe (each firm has several establishments, firm>establishment 1>establishment 2, so belong all establishments to each firm), what is the right code with fixed effects (firm and year fixed effect)?
Does the code at the bottom line is right (bysort GVKEY: eststo: quietly reghdfe inj_hour dummy_recession_worked $firm_controls $estab_controls $ceo_controls, $cluster absorb(GVKEY YEAR))?


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
global firm_controls " log_asset_ sale_asset_ debt_asset_ market_to_book_ ppe_asset_ capex_asset_ cash_asset_ cashflow_asset_ div_asset_ "
global estab_controls "log_emp hour_emp strike_q3 shut_q3 seasonal_q3 disaster_q3"
global executive_controls "AGE ceo_tenure sex"
global ceo_controls "AGE co_tenure sex"
global cluster "vce(cluster GVKEY)"
estimates clear
set more off

bysort GVKEY: eststo: quietly reghdfe inj_hour dummy_recession_worked $firm_controls $estab_controls $ceo_controls, $cluster absorb(GVKEY YEAR)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(inj_hour is dependent variable and dummy_recession_worked is independent variable)


On the other hand, what is the right code if I want to regress at the establishment 1 level?

[Clyde Schechter]

We have never resolved the question of how to handle situations where the exec has worked through 2 or more recessions. In the code below, we exclude them from the analysis.

The variable timing, created in this code, distinguishes pre-recession from post-recession. (It takes on missing values in years where there is a recession.)

The first -reghdfe- command does the analyses at the GVKEY level, and the second at the establishment level. If the number of gvkeys or establishments is large enough, you would probably use cluster robust standard errors as well. I have ignored the issue of the covariates ("control" variables) as they are not in the example data.

In the example data, during the regressions problems arise with singleton observations, and also, in the establishment level analysis, there is a problem with colinearity in the YEAR variable. I think that this is due to the sparsity of the example once all excluded observations are removed, and I think it will not happen in the full data set. But if it does, it is definitely a problem.

I also note that if, instead of including i.YEAR, I -absorb(gvkey YEAR)-, -reghdfe- terminates with some mata errors. I do not know why that is the case: the two ways of doing it should be equivalent. I'm not enough of a -reghdfe- expert to know what is going on here.

Again, I want to remind you that all you are getting here is a pre-post comparison, with no control group. Consequently you must not attempt to draw causal conclusions.

local recession1 August 1929 March 1933
local recession2 May 1937 June 1938
local recession3 February 1945 October 1945
local recession4 November 1948 October 1949
local recession5 July 1953 May 1954
local recession6 August 1957 April 1958
local recession7 April 1960 February 1961
local recession8 December 1969 November 1970
local recession9 November 1973 March 1975
local recession10 January 1980 July 1980
local recession11 July 1981 November 1982
local recession12 July 1990 March 1991
local recession13 March 2001 November 2001
local recession14 December 2007 June 2009
local recession15 February 2020 April 2020

// CLEAN UP THE RECESSION LOCALS AND MAKE THEM NUMERIC
forvalues i = 1/15 {
local m1: word 1 of `recession`i''
local y1: word 2 of `recession`i''
local m2: word 3 of `recession`i''
local y2: word 4 of `recession`i''
local recession_start`i' = dofm(monthly("`m1' `y1'", "MY"))
local recession_end`i' = dofm(monthly("`m2' `y2'", "MY"))
assert !missing(`recession_start`i'', `recession_end`i'')
}

//  IDENTIFY FIRST RECESSION WORKED
gen first_recession_worked_start = .
gen first_recession_worked_end = .
format first_recession_worked* %td
gen n_recessions_worked = 0
forvalues i = 1/15 {
    replace first_recession_worked_start = `recession_start`i'' ///
        if min(end_date, `recession_end`i'') >= max(start_date, `recession_start`i'') ///
        & missing(first_recession_worked_start)
    replace first_recession_worked_end = `recession_end`i'' ///
        if min(end_date, `recession_end`i'') >= max(start_date, `recession_start`i'') ///
        & missing(first_recession_worked_end)
    replace n_recessions_worked = n_recessions_worked + 1 ///
        if min(end_date, `recession_end`i'') >= max(start_date, `recession_start`i'')
    
}

keep if n_recessions_worked == 1
label define timing 1   "Pre-Recession" 2   "Post-Recession"
gen byte timing:timing = 1 if YEAR < year(first_recession_worked_start)
replace timing = 2 if YEAR > year(first_recession_worked_end)

egen gvkey = group(GVKEY)
egen establishment = group(city state estab_name estab_name2 gvkey)

preserve
collapse (mean) inj_hour, by(gvkey EXECID YEAR timing)
reghdfe inj_hour i.timing i.YEAR, absorb(gvkey)

restore
collapse (mean) inj_hour (first) establishment, ///
    by(city state estab_name estab_name2 gvkey EXECID YEAR timing)
reghdfe inj_hour i.timing i.YEAR, absorb(establishment)

[BB Kim]

I want to get the variable of the number of "Past" recession work experience

co_start_date is lifetime career start date, co_end_date is lifetime career end date (CEO 's total career year in his lifetime from co_start_date to co_end_date ; this career is from different firms)


YEAR GVKEY EXECID co_start_date co_end_date
2000 5680 04970 01jan1997 01jan2006
2001 5681 04970 01jan1997 01jan2006
2002 5680 04970 01jan1997 10may2006
2003 24668 04970 01jan1997 10may2006
2004 10920 04970 01jan1997 10may2006
2005 184748 04970 01jan1997 10may2006
2006 8479 04970 01jan1997 10may2006


YEAR GVKEY EXECID co_start_date co_end_date
2002 4598 00016 01mar1955 01oct1994
2003 157415 00016 01mar1955 01oct1994
2004 10920 00016 01mar1955 01oct1994


From example above, CEO id of EXECID 04970 worked in her whole life since 01jan1997 to 10may2006 from 5 different companies (GVKEY)
CEO id of 04970 worked in her whole life since 01mar1955 to 01oct1994 from 3 different companies (GVKEY)



I first want to change career end date (co_end_date) at each YEAR as below.
For ceo id EXECID 04970, I change the co_end_date as the first date of Current calendar year since CEO have worked till the current Year, his lifetime career end date is beyond the current year)

YEAR GVKEY EXECID co_start_date co_end_date
2000 5680 04970 01jan1997 01jan2000
2001 5681 04970 01jan1997 01jan2001
2002 5683 04970 01jan1997 01jan2002
2003 24668 04970 01jan1997 01jan2003
2004 10920 04970 01jan1997 01jan2004
2005 184748 04970 01jan1997 01jan2005
2006 8479 04970 01jan1997 10may2006

For ceo id EXECID 00016, since co_end_date is before YEAR (CEO's career already ended before current YEAR), I do not change and leave as it is.

YEAR GVKEY EXECID co_start_date co_end_date
2002 4598 00016 01mar1955 01oct1994
2003 157415 00016 01mar1955 01oct1994
2004 10920 00016 01mar1955 01oct1994



I want the value of n_recessions_worked of 04970

the value of n_recessions_worked in 2000 is 1 (recession range of 12 before 2000)
the value of n_recessions_worked in 2001 is 1 (recession range of 12 before 2001; current year is 2001 thus does not count the starting year of recession 13;
Do NOT count if starting of recession range year is equal current year since i'm looking at "PAST" recession experience )
the value of n_recessions_worked in 2002 is 2 (recession range of 12 and recession 13 before 2002)
...
the value of n_recessions_worked in 2007 is 2
the value of n_recessions_worked in 2008 is 3 (recession range of 12, 13, 14 before 2008)
...
...
the value of n_recessions_worked in 2011 is 3



(since
local recession12 July 1990 March 1991
local recession13 March 2001 November 2001
local recession14 December 2007 June 2009)

could you please revise previous code to get the value of n_recessions_work?













-----------------------------------------------------------------------------------------------------------------------------------------------------------------
My code was:



gen end_date=dofy(YEAR)

format %td end_date

replace co_end_date= end_date if co_end_date >end_date

% I replaced co_end_date if it is later than current year.


From your code, I wanted to replace end_date with co_end_date



foreach v of varlist co_start_date co_end_date {
gen _`v' = daily(`v', "DMY"), after(`v')
assert missing(`v') == missing(_`v')
drop `v'
rename _`v' `v'
format `v' %td
}


But this shows "type mismatch " and

gen n_co_recessions_worked = 0
forvalues i = 1/15 {

replace n_co_recessions_worked = n_co_recessions_worked + 1 if min(co_end_date, `recession_end`i'') >= max(co_start_date, `recession_start`i'')
}





forvalues loop, it says "if not found" error
So what is the problem?






. dataex YEAR GVKEY EXECID co_start_date co_end_date, count(300)

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input double YEAR str6(GVKEY EXECID) float(co_start_date co_end_date)
2002 "119417" "00008"  3408 16067
2003 "6307"   "00008"  3408 16067
2002 "4598"   "00016" -1767 12692
2003 "157415" "00016" -1767 12692
2004 "10920"  "00016" -1767 12692
2002 "10498"  "00026" 11504 14701
2002 "148294" "00042"   366 21305
2003 "24607"  "00042"   366 21305
2008 "3662"   "00042"   366 21305
2009 "7435"   "00042"   366 21305
2002 "24607"  "00043"  3804 15096
2002 "11456"  "00062" -1095 15521
2003 "147885" "00062" -1095 15521
2004 "15444"  "00062" -1095 15521
2005 "4598"   "00062" -1095 15521
2002 "7139"   "00066"  6118 15796
2003 "10920"  "00066"  6118 15796
2004 "25777"  "00066"  6118 15796
2002 "25313"  "00074"  8248 15584
2006 "62374"  "00075" 17015 17166
2002 "28930"  "00116" 12585 16560
2003 "11259"  "00116" 12585 16560
2004 "5680"   "00116" 12585 16560
2005 "2721"   "00116" 12585 16560
2002 "64902"  "00117"  4169 15796
2003 "3138"   "00117"  4169 15796
2004 "11649"  "00117"  4169 15796
2005 "179741" "00117"  4169 15796
2006 "3362"   "00117"  4169 15796
2007 "30170"  "00117"  4169 15796
2008 "10005"  "00117"  4169 15796
2009 "10920"  "00117"  4169 15796
2010 "5680"   "00117"  4169 15796
2011 "112168" "00117"  4169 15796
2002 "3813"   "00125"  1827 23011
2003 "2393"   "00125"  1827 23011
2004 "10920"  "00125"  1827 23011
2005 "5680"   "00125"  1827 23011
2006 "10983"  "00125"  1827 23011
2007 "17239"  "00125"  1827 23011
2008 "133367" "00125"  1827 23011
2009 "11264"  "00125"  1827 23011
2010 "10443"  "00125"  1827 23011
2011 "24610"  "00125"  1827 23011
2002 "10920"  "00134"  9375 18333
2003 "2710"   "00134"  9375 18333
2004 "65702"  "00134"  9375 18333
2005 "241216" "00134"  9375 18333
2006 "5680"   "00134"  9375 18333
2007 "3144"   "00134"  9375 18333
2008 "5680"   "00134"  9375 18333
2002 "2193"   "00172"  4018 16908
2003 "16603"  "00172"  4018 16908
2005 "6307"   "00172"  4018 16908
2006 "10795"  "00172"  4018 16908
2007 "1722"   "00172"  4018 16908
2008 "6349"   "00172"  4018 16908
2002 "15444"  "00182"  9191 16161
2003 "8215"   "00182"  9191 16161
2002 "10405"  "00210" -1095 12996
2003 "5680"   "00210" -1095 12996
2004 "148256" "00210" -1095 12996
2005 "10920"  "00210" -1095 12996
2002 "1677"   "00229"  1277 17348
2003 "175689" "00229"  1277 17348
2004 "6829"   "00229"  1277 17348
2005 "24607"  "00229"  1277 17348
2006 "4598"   "00229"  1277 17348
2007 "11456"  "00229"  1277 17348
2002 "11456"  "00260"   731 13264
2003 "5680"   "00260"   731 13264
2004 "160163" "00260"   731 13264
2005 "64389"  "00260"   731 13264
2002 "6649"   "00281"  8887 23011
2003 "8214"   "00281"  8887 23011
2004 "10920"  "00281"  8887 23011
2005 "10920"  "00281"  8887 23011
2006 "62374"  "00281"  8887 23011
2007 "10920"  "00281"  8887 23011
2008 "3505"   "00281"  8887 23011
2002 "146500" "00296"  9313 20910
2003 "5071"   "00296"  9313 20910
2004 "6829"   "00296"  9313 20910
2005 "6829"   "00296"  9313 20910
2006 "4213"   "00296"  9313 20910
2007 "10920"  "00296"  9313 20910
2008 "8717"   "00296"  9313 20910
2009 "10816"  "00296"  9313 20910
2010 "6104"   "00296"  9313 20910
2011 "3138"   "00296"  9313 20910
2002 "24931"  "00297"  1827 15655
2002 "24607"  "00325" 10409 16801
2003 "8463"   "00325" 10409 16801
2004 "4598"   "00325" 10409 16801
2005 "150481" "00325" 10409 16801
2002 "62865"  "00339" 12419 15721
2003 "7486"   "00339" 12419 15721
2002 "5071"   "00347" 14835 16427
2003 "5680"   "00347" 14835 16427
2004 "8215"   "00347" 14835 16427
2007 "5680"   "00393"  2677 16040
2008 "121553" "00393"  2677 16040
2009 "20338"  "00393"  2677 16040
2010 "139804" "00393"  2677 16040
2011 "3662"   "00393"  2677 16040
2010 "8358"   "00407" 18506 19738
2011 "2176"   "00407" 18506 19738
2002 "10920"  "00418"  -579 16299
2003 "28742"  "00418"  -579 16299
2004 "6649"   "00418"  -579 16299
2008 "3416"   "00419"  9466 23011
2009 "2251"   "00419"  9466 23011
2010 "5680"   "00419"  9466 23011
2002 "11259"  "00456" 11535 23011
2003 "5680"   "00456" 11535 23011
2004 "24283"  "00456" 11535 23011
2005 "5680"   "00456" 11535 23011
2006 "8463"   "00456" 11535 23011
2002 "10540"  "00458"  9587 14976
2003 "100609" "00458"  9587 14976
2004 "31673"  "00458"  9587 14976
2005 "27980"  "00458"  9587 14976
2004 "11259"  "00472" 16390 17501
2004 "6034"   "00472" 11323 16387
2005 "161075" "00472" 16390 17501
2006 "16603"  "00472" 16390 17501
2007 "112168" "00472" 16390 17501
2002 "9647"   "00476" 13865 17036
2003 "14477"  "00476" 13865 17036
2004 "6207"   "00476" 13865 17036
2005 "179437" "00476" 13865 17036
2006 "5680"   "00476" 13865 17036
2002 "25627"  "00498"  3104 14019
2003 "11649"  "00498"  3104 14019
2004 "10920"  "00510"  9862 23011
2002 "1397"   "00516"   731  7671
2002 "5691"   "00517"  2435 15614
2003 "5680"   "00517"  2435 15614
2002 "4598"   "00518"  3653 15461
2003 "4390"   "00518"  3653 15461
2004 "11649"  "00518"  3653 15461
2005 "6829"   "00518"  3653 15461
2006 "24610"  "00518"  3653 15461
2007 "63892"  "00518"  3653 15461
2008 "10540"  "00518"  3653 15461
2009 "10005"  "00518"  3653 15461
2010 "5680"   "00518"  3653 15461
2002 "22177"  "00532"  5479 15764
2002 "13992"  "00537"  7487 16223
2003 "29008"  "00537"  7487 16223
2004 "161075" "00537"  7487 16223
2002 "13634"  "00588" -1461 19083
2003 "2193"   "00588" -1461 19083
2004 "13992"  "00588" -1461 19083
2005 "5047"   "00588" -1461 19083
2006 "14477"  "00588" -1461 19083
2007 "6502"   "00588" -1461 19083
2008 "65613"  "00588" -1461 19083
2009 "5125"   "00588" -1461 19083
2010 "12053"  "00588" -1461 19083
2011 "14477"  "00588" -1461 19083
2002 "117961" "00593"  -730 17348
2003 "4598"   "00593"  -730 17348
2004 "1382"   "00593"  -730 17348
2005 "11636"  "00593"  -730 17348
2006 "6307"   "00593"  -730 17348
2007 "11259"  "00593"  -730 17348
2008 "29634"  "00593"  -730 17348
2009 "6104"   "00593"  -730 17348
2006 "64275"  "00643" 15492 21221
2007 "6829"   "00643" 15492 21221
2008 "8358"   "00643" 15492 21221
2009 "119417" "00643" 15492 21221
2010 "8479"   "00643" 15492 21221
2011 "5125"   "00643" 15492 21221
2002 "64839"  "00649"  1643 16437
2003 "2811"   "00649"  1643 16437
2004 "5680"   "00649"  1643 16437
2005 "8479"   "00649"  1643 16437
2006 "11649"  "00649"  1643 16437
2007 "110685" "00649"  1643 16437
2008 "5047"   "00649"  1643 16437
2009 "164652" "00649"  1643 16437
2010 "5680"   "00649"  1643 16437
2002 "10618"  "00685"  3288 16433
2003 "7199"   "00685"  3288 16433
2004 "22140"  "00685"  3288 16433
2002 "119417" "00695"  5479 15979
2003 "119417" "00695"  5479 15979
2008 "5680"   "00702"  8401 23011
2009 "3835"   "00702"  8401 23011
2010 "7291"   "00702"  8401 23011
2011 "10000"  "00702"  8401 23011
2002 "1045"   "00721" 11657 15431
2002 "11259"  "00722" 10958 16070
2003 "5680"   "00722" 10958 16070
2002 "3138"   "00745"  6879 15823
2003 "5680"   "00745"  6879 15823
2003 "10793"  "00788" 11323 12053
2004 "5047"   "00788" 11323 12053
2005 "3580"   "00788" 11323 12053
2006 "6774"   "00788" 11323 12053
2007 "7921"   "00791"  9313 16618
2008 "119417" "00791"  9313 16618
2008 "25389"  "00816" 11596 15186
2010 "1300"   "00816" 11596 15186
2011 "5680"   "00816" 11596 15186
2002 "24607"  "00826" 11962 19492
2003 "5680"   "00826" 11962 19492
2004 "10540"  "00826" 11962 19492
2005 "138466" "00826" 11962 19492
2006 "65613"  "00826" 11962 19492
2007 "1618"   "00826" 11962 19492
2008 "6829"   "00826" 11962 19492
2009 "4036"   "00826" 11962 19492
2010 "112168" "00826" 11962 19492
2011 "20029"  "00826" 11962 19492
2002 "3144"   "00836"     0 15737
2003 "2193"   "00836"     0 15737
2002 "5047"   "00837"   731 22436
2004 "2193"   "00837"   731 22436
2005 "6774"   "00837"   731 22436
2006 "5680"   "00837"   731 22436
2007 "2606"   "00837"   731 22436
2002 "15289"  "00849"   731 16468
2003 "5680"   "00849"   731 16468
2004 "1382"   "00849"   731 16468
2005 "11304"  "00849"   731 16468
2006 "11124"  "00849"   731 16468
2007 "7085"   "00849"   731 16468
2008 "8479"   "00849"   731 16468
2009 "10581"  "00849"   731 16468
2010 "14027"  "00849"   731 16468
2011 "1356"   "00849"   731 16468
2002 "4598"   "00864" 11323 23011
2002 "1743"   "00866"  -730 13984
2010 "177697" "00874" 18232 18506
2002 "62967"  "00885"  9497 15372
2003 "22140"  "00885"  9497 15372
2002 "4611"   "00896"  6241 16437
2003 "11259"  "00896"  6241 16437
2004 "11259"  "00896"  6241 16437
2002 "2193"   "00899"  8067 16892
2003 "23252"  "00899"  8067 16892
2004 "11443"  "00899"  8067 16892
2005 "6829"   "00899"  8067 16892
2006 "17239"  "00899"  8067 16892
2007 "16477"  "00899"  8067 16892
2008 "113490" "00899"  8067 16892
2009 "6242"   "00899"  8067 16892
2002 "6649"   "00902" 13727 15492
2003 "14477"  "00902" 13727 15492
2004 "11259"  "00902" 13727 15492
2005 "3138"   "00902" 13727 15492
2002 "4598"   "00919"  9609 17185
2003 "157355" "00919"  9609 17185
2004 "11649"  "00919"  9609 17185
2005 "3158"   "00919"  9609 17185
2006 "3851"   "00919"  9609 17185
2007 "7085"   "00919"  9609 17185
2007 "10405"  "00957"  -306 14153
2008 "119417" "00957"  -306 14153
2009 "148257" "00957"  -306 14153
2010 "6829"   "00957"  -306 14153
2002 "11259"  "00981"  2404 15705
2003 "6774"   "00981"  2404 15705
2002 "12756"  "00996" 13515 16800
2003 "157355" "00996" 13515 16800
2004 "10405"  "00996" 13515 16800
2005 "11259"  "00996" 13515 16800
2002 "3813"   "01007"   731 16437
2003 "119417" "01007"   731 16437
2004 "14049"  "01007"   731 16437
2005 "13712"  "01007"   731 16437
2006 "1045"   "01007"   731 16437
2007 "7921"   "01007"   731 16437
2008 "177827" "01007"   731 16437
2009 "148394" "01007"   731 16437
2010 "3138"   "01007"   731 16437
2011 "1382"   "01007"   731 16437
2002 "10920"  "01028" 14976 15918
2003 "24931"  "01028" 14976 15918
2002 "6829"   "01039"  3104 16252
2003 "30671"  "01039"  3104 16252
2004 "119316" "01039"  3104 16252
2004 "23577"  "01078" 14426 23011
2005 "17436"  "01078" 14426 23011
2006 "4213"   "01078" 14426 23011
2007 "12379"  "01078" 14426 23011
2008 "29830"  "01078" 14426 23011
2009 "105089" "01078" 14426 23011
2010 "14477"  "01078" 14426 23011
2002 "3144"   "01081" 10652 23011
2003 "2193"   "01081" 10652 23011
2004 "22140"  "01081" 10652 23011
2002 "6552"   "01101"  1096 16815
2003 "11649"  "01101"  1096 16815
2004 "5878"   "01101"  1096 16815
2005 "4598"   "01101"  1096 16815
2002 "10793"  "01108" 12965 14245
end
format %td co_start_date
format %td co_end_date

------------------ copy up to and including the previous line ------------------

Listed 300 out of 44487 observations