log using FOI_Tables.log, replace /********************************************************************************** Freedom of information (FOI) as a data collection tool for social scientists By Joanna Clifton-Sprigg (University of Bath), Jonathan James(University of Bath), Sunčica Vujić (University of Antwerp) Antwerp, Belgium **********************************************************************************/ * ACCEPTED IN * MANUSCRIPT No. /******************************************************************************** ***THIS DO FILE TAKES THE POLICE FORCE AND UNIVERSITY DATA AND PRODUCES ***TABLES 2, 4, B1, B2, B3, B4, B5, B6 & B7 *To run: Put PF_Final.dta, Unis_FinalData.dta and FOI_vars.do into a folder and set the directory there, then run the following code. ********************************************************************************/ cd C:\Research\FOI /******************************************************************************** ***Table 2. The determinants of the response to an FOI request of all police forces in the UK ********************************************************************************/ use PF_Final, clear quietly do FOI_vars.do *Cols 1-5: Any Data dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total JJ SV, robust dprobit2 Any_Data spop_HateCrime_14_15 JJ SV, robust dprobit2 Any_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV, robust dprobit2 Any_Data dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 /// spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC dinc_head NSSEC_1674_Unem JJ SV, robust *Cols 6 - 10: Right Data dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total JJ SV, robust dprobit2 Right_Data spop_HateCrime_14_15 JJ SV, robust dprobit2 Right_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV, robust dprobit2 Right_Data dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust /******************************************************************************** ***Table 4. The effect of university characteristics on response to the FOI request ********************************************************************************/ use Unis_FinalData, clear gen totalstaff=Academic_TotalStaff + NonAcademic_totalstaff gen all_under35= (Academic_Under35 + NonAcademic_Under35) / 2 gen padmin = NonAcademic_totalstaff / (NonAcademic_totalstaff + Academic_TotalStaff) gen income_staff_ratio = totalincome_1617 / (NonAcademic_totalstaff + Academic_TotalStaff) gen acad_sal_k=AllAcademic/1000 gen nonacad_sal_k=NonAcadAll/1000 keep Responded Dataprovided totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio LeagueRank reftotalstaff reffourstar refthreestar *Responded Cols 1-4 dprobit Responded totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio, robust dprobit Responded LeagueRank, robust dprobit Responded reftotalstaff reffourstar refthreestar, robust dprobit Responded totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio LeagueRank reftotalstaff reffourstar refthreestar, robust *Data provided Cols 5 - 8 dprobit Dataprovided totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio, robust dprobit Dataprovided LeagueRank, robust dprobit Dataprovided reftotalstaff reffourstar refthreestar, robust dprobit Dataprovided totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio LeagueRank reftotalstaff reffourstar refthreestar, robust /******************************************************************************** ***Table B1. The determinants of the response to an FOI request of all police forces in the UK ********************************************************************************/ use PF_Final, clear do FOI_vars.do *Cols 1 - 5: Late dprobit Late spop_total_police spop_Total_Admin spop_Fund_total JJ SV, robust dprobit Late spop_HateCrime_14_15 JJ SV, robust dprobit Late spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV, robust dprobit Late dinc_head NSSEC_1674_Unem JJ SV, robust dprobit Late total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC dinc_head NSSEC_1674_Unem JJ SV, robust *Cols 6 - 10: All Data dprobit All_Data total_police spop_Total_Admin spop_Fund_total JJ SV, robust dprobit All_Data spop_HateCrime_14_15 JJ SV, robust dprobit All_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV, robust dprobit All_Data dinc_head NSSEC_1674_Unem JJ SV, robust dprobit All_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC dinc_head NSSEC_1674_Unem JJ SV, robust /******************************************************************************** ***Table B2. The determinants of the response to an FOI request of police forces in the UK (excluding City of London and the Metropolitan Police Service) ********************************************************************************/ use PF_Final, clear do FOI_vars.do drop if PF_no==6 | PF_no==27 *Cols 1-5: Any Data dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total JJ SV, robust dprobit2 Any_Data spop_HateCrime_14_15 JJ SV, robust dprobit2 Any_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV, robust dprobit2 Any_Data dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 /// spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC dinc_head NSSEC_1674_Unem JJ SV, robust *Cols 6 - 10: Right Data dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total JJ SV, robust dprobit2 Right_Data spop_HateCrime_14_15 JJ SV, robust dprobit2 Right_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV, robust dprobit2 Right_Data dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust ******************************************************************************** ***Table B3. The determinants of the response to an FOI request of all police forces in the UK (Estimation of logistic model by penalized maximum likelihood regression) ******************************************************************************** use PF_Final, clear do FOI_vars.do *Cols 1-5: Any Data firthlogit Any_Data spop_total_police spop_Total_Admin spop_Fund_total JJ SV firthlogit Any_Data spop_HateCrime_14_15 JJ SV firthlogit Any_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV firthlogit Any_Data dinc_head NSSEC_1674_Unem JJ SV firthlogit Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 /// spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC dinc_head NSSEC_1674_Unem JJ SV *Cols 6 - 10: Right Data firthlogit Right_Data spop_total_police spop_Total_Admin spop_Fund_total JJ SV firthlogit Right_Data spop_HateCrime_14_15 JJ SV firthlogit Right_Data spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC JJ SV firthlogit Right_Data dinc_head NSSEC_1674_Unem JJ SV firthlogit Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV /******************************************************************************** ***Table B4. The (alternative) determinants of the response to an FOI request of all police forces in the UK (Any Data) ********************************************************************************/ *Any data ***Original Full model: dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_BME_Police_Total spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Police_Staff_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_Core spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_Violencewithinjury spop_Violencewithoutinjury spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_Publicorderoffences spop_Robbery spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_Asian spop_Black spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_OtherEurope_born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Any_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Muslim spop_Sikh /// dinc_head NSSEC_1674_Unem JJ SV, robust /******************************************************************************** ***Table B5. The (alternative) determinants of the response to an FOI request of all police forces in the UK (Right Data) ********************************************************************************/ dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_BME_Police_Total spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Police_Staff_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_Core spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_Violencewithinjury spop_Violencewithoutinjury spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_Publicorderoffences spop_Robbery spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_Asian spop_Black spop_NonUK_Born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_Asia_born spop_OtherEurope_born spop_Rel_NonC /// dinc_head NSSEC_1674_Unem JJ SV, robust dprobit2 Right_Data spop_total_police spop_Total_Admin spop_Fund_total spop_HateCrime_14_15 spop_Pop_WorkAge spop_White spop_NonUK_Born spop_Muslim spop_Sikh /// dinc_head NSSEC_1674_Unem JJ SV, robust /******************************************************************************** ***Table B6. The effect of university characteristics on response to the FOI request (Estimation of logistic model by penalized maximum likelihood regression) ********************************************************************************/ use Unis_FinalData, clear gen totalstaff=Academic_TotalStaff + NonAcademic_totalstaff gen all_under35= (Academic_Under35 + NonAcademic_Under35) / 2 gen padmin = NonAcademic_totalstaff / (NonAcademic_totalstaff + Academic_TotalStaff) gen income_staff_ratio = totalincome_1617 / (NonAcademic_totalstaff + Academic_TotalStaff) gen acad_sal_k=AllAcademic/1000 gen nonacad_sal_k=NonAcadAll/1000 *Responded Cols 1-4 firthlogit Responded totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio firthlogit Responded LeagueRank firthlogit Responded reftotalstaff reffourstar refthreestar firthlogit Responded totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio LeagueRank reftotalstaff reffourstar refthreestar *Data provided Cols 5 - 8 firthlogit Dataprovided totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio firthlogit Dataprovided LeagueRank firthlogit Dataprovided reftotalstaff reffourstar refthreestar firthlogit Dataprovided totalstaff all_under35 padmin acad_sal_k nonacad_sal_k income_staff_ratio LeagueRank reftotalstaff reffourstar refthreestar /******************************************************************************** ***Table B7. The effect of (alternative) university characteristics on response to the FOI request ********************************************************************************/ use Unis_FinalData, clear gen totalstaff=Academic_TotalStaff + NonAcademic_totalstaff gen all_under35= (Academic_Under35 + NonAcademic_Under35) / 2 gen padmin = NonAcademic_totalstaff / (NonAcademic_totalstaff + Academic_TotalStaff) gen income_staff_ratio = totalincome_1617 / (NonAcademic_totalstaff + Academic_TotalStaff) gen acad_sal_k=AllAcademic/1000 gen nonacad_sal_k=NonAcadAll/1000 gen rfemwage_academic=(FemaleAllAcademic/MaleAllAcademic)*100 gen rfemwage_nonacademic=(FemaleNonAcadAll/MaleNonAcadAll)*100 gen totalfemale = AcademicStaff_Female + NonAcademic_Female gen totalmale = AcademicStaff_Male + NonAcademic_Male gen pfemale = totalfemale / (totalfemale + totalmale) *Columns 1-3: Responded dprobit Responded rfemwage_academic rfemwage_nonacademic, r dprobit Responded pfemale padmin income_staff_ratio /// rfemwage_academic rfemwage_nonacademic NonAcademic_AverageAge Academic_AverageAge, r dprobit Responded pfemale padmin income_staff_ratio /// rfemwage_academic rfemwage_nonacademic NonAcademic_AverageAge Academic_AverageAge /// LeagueRank reftotalstaff reffourstar refthreestar, r *Columns 4-6: Data Provided dprobit Dataprovided rfemwage_academic rfemwage_nonacademic, r dprobit Dataprovided pfemale padmin income_staff_ratio /// rfemwage_academic rfemwage_nonacademic NonAcademic_AverageAge Academic_AverageAge, r dprobit Dataprovided pfemale padmin income_staff_ratio /// rfemwage_academic rfemwage_nonacademic NonAcademic_AverageAge Academic_AverageAge /// LeagueRank reftotalstaff reffourstar refthreestar, r log close