|Story from Tracker|
Campaign finance goes local
By David Raynor, Raleigh News & Observer
Since 1988, The N&O has maintained some sort of campaign finance
database, tracking contributions to Congressional candidates from NC,
statewide candidates such as Governor and Lt. Gov. and, since 1997,
General Assembly candidates. It's a Visual Foxpro database.
We hire temps to key the data.
In 1999, we began discussing ways to incorporate local campaign races
into the "Money Machine", our campaign finance database. The reason was that developers were
beginning to spend a lot more money locally because of efforts to slow growth. We wanted to find
out just how much they were spending and why.
Our goals were:
Five reporters collected the reports and we spent about 4-6 weeks keying the reports, checking the totals
and doing general clean-up work. The reports then wrote themselves. The development community gave near
$550,000 or 44% of the money that candidates for municipal and county commission races in 4 counties
received from IDENTIFIABLE donors from 1/1/98 through 6/30/00. We started with 1/1/98 because that's
when local candidates were first required to list the occupations of their contributors. In one small
town of about 12,000 people, developers contributed half of all the money raised for three winners in a
- Say authoritatively that the development community
(home builders, contractors, realtors, architects, landscapists) was the single biggest source of
money going to local candidates
- Identify the candidates getting the most money
- Link the money to policy - tracing votes on rezonings and developments to contributions
- Identify elected officials and candidates who are developers themselves.
Problems we had:
Other problems. Local candidates did not have any type of ID, so I just assigned a 7-digit candidate
ID for each race in each county. I added a general occupation field, in addition to the occupation field
listed on the report, and just ran some basic search and replace commands to fill in the gaps.
(For example, "replace newtitle with "Development" for oldtitle="develop" or oldtitle="builder" or
oldtitle="realtor", etc.). Other general occupations we included were: Accountant, Attorney,
Banking/Finance, Retired, Insurance, Homemaker, Health Care, Education and Not Identified).
- Could not identify every contributor, despite the
requirement of candidates to identify their contributors. For instance,
those who give under $100 don't have to be itemized
- Candidates who spend less than $3,000 don't have to file reports at all
- A few reports were simply illegible. Some reports' summary pages did not match the details provided,
which made it difficult to check totals.
We then took those that were not electronically identified, printed a
list and the reporters went through and filled in the gaps where they
could, just from knowing the contributor or using other sources to
We incorporated the local campaign reports into our main campaign
database, which covers statewide and General Assembly races. In other
words, we did not keep it separate.
We've produced several big stories from the database and many more smaller ones including routine
checks against contributors who might be mentioned in any story.
David Raynor is the database manager at The News & Observer in Raleigh, N.C.