/*

*** This do file creates the replication results for 

Asylum Recognition Rates in Western Europe - Their Determinants, Variation and Lack of Convergence, Journal of Conflict Resolution, 49 (1), 2005, pp. 43-66

Eric Neumayer (LSE)																			

Please report any errors to e.neumayer@lse.ac.uk

*/

use "Asylum JCR article.dta", replace

* Table 3
quietly xi: reg recognisedrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag
su recognisedrate approvalrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag if e(sample)

* Table 4
corr recognisedrate approvalrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag if e(sample)


* Table 5
preserve
collapse (mean) meanrecognisedrate=recognisedrate (sd) sdrecognisedrate=recognisedrate, by(origin year)
ge cvrecognisedrate=sd/mean
collapse cvrecognisedrate, by(year)
list
restore

preserve
collapse (mean) meanrecognisedrate=recognisedrate euplusasyl (sd) sdrecognisedrate=recognisedrate, by(origin year)
ge cvrecognisedrate=sd/mean
collapse cvrecognisedrate [weight=euplusasyl], by(year)
list
restore

preserve
collapse (mean) meanapprovalrate=approvalrate (sd) sdapprovalrate=approvalrate, by(origin year)
ge cvapprovalrate=sd/mean
collapse cvapprovalrate, by(year)
list
restore

preserve
collapse (mean) meanapprovalrate=approvalrate euplusasyl (sd) sdapprovalrate=approvalrate, by(origin year)
ge cvapprovalrate=sd/mean
collapse cvapprovalrate [weight=euplusasyl], by(year)
list
restore


* Table 6
preserve
drop if destination=="Luxembourg"
xi: reg  recognisedrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag , robust cluster(destination)
outreg using c:\table1, replace
xi: reg  recognisedrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag cdum1-cdum17 i.origin ,  nocons robust cluster(destination)
outreg l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag using c:\table1, append
lincom cdum1-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum2-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum3-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum4-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum5-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum6-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum7-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum8-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum9-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum11-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum12-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum13-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum14-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum15-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum16-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum17-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
xi: reg  recognisedrate lndestinationgdp free pts uppsalaexternalintensity genpoliticidemag cdum1-cdum17 i.origin , nocons robust cluster(destination)
outreg lndestinationgdp free pts uppsalaexternalintensity genpoliticidemag using c:\table1, append
lincom cdum1-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum2-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum3-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum4-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum5-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum6-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum7-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum8-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum9-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum11-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum12-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum13-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum14-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum15-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum16-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum17-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
restore 

* Table 7
preserve
xi: reg  approvalrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag , robust cluster(destination)
outreg using c:\table2, replace
xi: reg  approvalrate l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag cdum1-cdum17 i.origin , nocons robust cluster(destination)
outreg l52dyadasylumtotalpc l52dyadasylumcorrpc destinationrwpvote destinationunemployment  lndestinationgdp lngdp  free pts uppsalaexternalintensity sfallmax genpoliticidemag using c:\table2, append
lincom cdum1-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum2-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum3-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum4-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum5-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum6-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum7-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum8-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum9-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum11-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum12-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum13-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum14-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum15-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum16-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum17-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
xi: reg  approvalrate l52dyadasylumcorrpc destinationunemployment  lndestinationgdp free pts uppsalaexternalintensity genpoliticidemag cdum1-cdum17 i.origin , nocons robust cluster(destination)
outreg l52dyadasylumcorrpc destinationunemployment  lndestinationgdp free pts uppsalaexternalintensity genpoliticidemag using c:\table2, append
lincom cdum1-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum2-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum3-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum4-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum5-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum6-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum7-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum8-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum9-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum11-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum12-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum13-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum14-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum15-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum16-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
lincom cdum17-(cdum1+cdum2+cdum3+cdum4+cdum5+cdum6+cdum7+cdum8+cdum9+cdum11+cdum12+cdum13+cdum14+cdum15+cdum16+cdum17)/16
restore