How we did this project on legislative gifts

This package was a group effort during the Spring 2001 semester by students in MASC 375, the Legislative Reporting course at Virginia Commonwealth University's School of Mass Communications.

We began working on the project in January. We decided to examine gifts to legislators for several reasons:

At the start of the session, we ordered copies of the Statements of Economic Interests for members of the House of Delegates (from the House Clerk's Office) and for members of the Virginia Senate (from the Senate Clerk's Office). These statements also are called conflict-of-interest forms: They can reveal whether a lawmaker has a financial interest in an issue pending before the General Assembly.

On their statements, legislators must list:

For some lawmakers, the form may run only a few pages; others may file a statement of 100 or more pages, including background material.

Because our focus was gifts, we zeroed in on Schedule E, on which legislators must list all gifts of $50 or more received the previous year. We had 140 legislators to contend with (100 House members and 40 senators); the class was made up of 13 students and an instructor. So we each took the Statements of Economic Interests for 10 legislators and entered the Schedule E information into a spreadsheet.

We did the data entry in Microsoft Excel. For each gift, students entered the recipient's name, the giver's name, the giver's city and state, the description of the gift, the value of the gift and any notes made on the legislator's form.

We then combined each student's data into a single spreadsheet - with all gifts on all legislators. We fixed typos and inconsistencies, especially in the spelling of donors' names. Then we analyzed the data with Excel's PivotTable Report feature. This allowed us to see how much each donor had given in gifts and how much each lawmaker had received.

After doing the analysis, the class discussed possible stories: about the top givers and recipients, about expensive or unusual gifts, about why donors give gifts to legislators. Each student was assigned a story.

One student, Jessica Brown, decided to write about gifts given to Virginia's top three statewide elected officials: Gov. Jim Gilmore, Lt. Gov. John Hager (who presides over the Senate) and Attorney General Mark Earley. These officials file their Statements of Economic Interests with the Secretary of the Commonwealth.

After Jessica obtained the filings for Gilmore, Hager and Earley, the students entered the gifts data into Excel so we could total and analyze it. (It would have been hard to do this by hand or with a simple calculator: Gilmore reported 337 gifts worth almost $55,500.)

To guide us in this project, we read numerous stories about legislative gifts and campaign donations in The Washington Post, The Virginian-Pilot and the Richmond Times-Dispatch. We also used such resources as:

If you would like more information about our project, please contact Jeff South, who teaches Legislative Reporting at VCU, or use our feedback form.