Variable
Label
Code
Description
ASSETID
AssetID
Range: 1-1909
Unique Apartment Id. 
EXPSTAT
Intervention Status
0 = Control 
1 = IPM Intervention

SRBLDG
Senior Building
0 = No
1 = Yes
Senior buildings are designated for senior citizens occupancy only
SITE
Site
1=Bushwick
2=East Harlem
Neighborhood where building is located.
DVPMNT
Development
1=Bushwick 2E
2=Hope Gardens
3=Palmetto Gardens
4=Metro North
5=White
Unique Housing Development Id. The study population consists of apartments selected from 30 buildings, from these 5 housing developments in Bushwick and East Harlem.
BUILDING
Building


Building Address. Apartments are selected from 30 building addresses. Some share a common entrance, so cannot be considered “separate”.
bldgset
Building Group

Building addresses belong to 13 building groups. These are groups of buildings that may share an attached wall, but do not share common entrance doors. They can be considered “separate”. 
Chute
Presence of garbage chute in building
0 = No
1 = Yes

Stories
Number of stories in building
Range: 3 - 20

Building_year
Year building constructed
Range: 1964 - 1986

SEASN_Z
Season of enrollment
1=Spring
2=Summer
3=Fall
4=Winter
Season of the year in which the baseline interview was conducted

r2_seasn_z
Season of R2 Interview
1=Spring
2=Summer
3=Fall
4=Winter
Season of the year in which the Round 2 interview was conducted
EXN_1
Last time exterminator came
0=Has never come
1 => 6 mo ago
2=3-6 mo ago
3 =1-2 mo ago
4 =in lst 2 wk
Q 7. When was the last time that an exterminator came to your apartment?
extrm6mo
Exterminator within 6 months prior to baseline
1=Yes
0=No
Recoded variable. If EXN_1 > 1 then extrm6mo = 1     
BOMFQN_1
How often use bombs numeric

1=Never
2=< 1 month
3=1-3 times mo
4=1-6 time wk
5=Daily
Q 8g1. How often do you use insecticide bombs or foggers?

SPRFQN_1
How often use sprays numeric
1=Never
2=< 1 month
3=1-3 times mo
4=1-6 time wk
5=Daily
Q 8h1. How often do you use insecticide spray?
K06_1
Number of Children 0-6 Living in Apt
Range 0-4
Q13a. How many children 6 years or younger live most of the time in this apartment?
NUMRES_1
Number of people living in apartment
Range 1-14
Recoded variable equal to the sum of kids plus adults.
Crowding
People per room
Range: .20 – 2.00 
Calculated: NUMRES_1/apartment size
FDSTV_1
Open Food/Food Waste on Stove
0=None
1=Low
2=Moderate
3=Heavy
The Interviewer was asked to rate conditions in the kitchen.
Q 29e. Open food and/or food waste on stovetop
FDRFG_1
Open Food/Food Waste on Refrigerator
0=None
1=Low
2=Moderate
3=Heavy
The Interviewer was asked to rate conditions in the kitchen.
Q 29e. Open food and/or food waste on refrigerator
FDCAB_1
Open Food on counter and in cabinets
0=None
1=Low
2=Moderate
3=Heavy
The Interviewer was asked to rate conditions in the kitchen.
Q 29e. Open food on counters and in cabinets
SMKRW_Z        
Number of cockroaches collected at baseline over 7 days (using 5 traps)
Range: 0 – 450.0
Cockroaches were summed across all traps. The sum was standardized to account for situations where there were less than 5 traps, and/or where traps were out for less or more than 7 days
lnsmkrw_z      
Natural log of the number of cockroaches collected at baseline over 7 days (using 5 traps)
Range: 0 - 6.11
Log value of  lnsmkrw_z+1           
r2_smkrw_z     
Number of cockroaches collected at round 2 over 7 days (using 5 traps)
Range 0 - 357.00
Cockroaches were summed across all traps. The sum was standardized to account for situations where there were less than 5 traps, and/or where traps were out for less or more than 7 days
r2_lnskrw_z    
Natural log of the number of cockroaches collected at round 2 over 7 days (using 5 traps)
Rane: 0 - 5.88
Log value of  r2_smkrw_z+1     
dfsmkrw_z2     
Difference in roach counts: R2 minus baseline
Range:
-346.25 – +176.89
Calculated: r2_smkrw_z  - smkrw_z minus
SASintdt_1     
Date that the baseline traps were laid
Range:
08/11/02 – 05/05/04
Date of Baseline interview. Cockroach traps were set out at the time of the Baseline interview.
SAScoll_1      
Date that baseline traps were collected
Range:
08/18/02-05/12/04
We aimed to collect baseline traps after 7 days.
r2_encdate     
Date that the round 2 traps were laid
Range:
11/25/02-11/30/04
Date of Round 2 interview. Cockroach traps were set out at the time of the Round 2 interview.
r2_dcollect    
Date that round 2 traps were collected 
Range:
12/02/02-12/07/04
We aimed to collect round 2 traps after 7 days.
Hasround2      
Has Round 2 Data
1=Yes
0=No
60 apartments were not followed up at Round 2
Fup_2          
Num Days Between Baseline and Round2
Range: 87 - 382
Calculated:  r2_encdate - SASintdt_1. We aimed for a 3-month interval. 
base_rcat      
Categorized baseline roach count
0 = 0
1 = 1 - 3.18
2 = 3.5 - 16.25
3 = 17 - 57.5
4 = > 58
Categorized roach count based on quartile distribution of non-zero values at baseline.
r2_rcat     
Categorized round 2 roach count
0= 0
1= 1 - 3.18
2= 3.5 - 16.25
3 = 17 - 57.5
4 = > 58
Categorized roach count based on quartile distribution of non-zero values at baseline.
rc_cat_chg  
Difference in category values: Round 2 minus baseline
Range -4 – 4
Calculated: r2_rcat -  base_rcat . A negative number indicates a decrease in roach counts from Baseline to Round 2.   
Success
Success vs. failure of intervention
1 = Successful control
0 = Failure
Success=1 if a) 0 roaches at Round 2 or  b) At least 1 quartile reduction in roaches from Baseline to Round 2
Success2
Success vs. failure of intervention
1 = Successful control
0 = Failure
Success=1 if a) 0 roaches at Round 2 or  b) At least 50% reduction in roaches from Baseline to Round 2
		
??

??

??

??

Data Dictionary for Analysis of Effectiveness of IPM on Reducing Cockroach Infestation (Baseline and Round 2 Data)




4


