Warwickshire Open Data

These are the Warwickshire County Council election results for 4th June 2009/

All data is extracted from the Lotus Notes-based WCC election systems - in this case the 2009 election system.

Here's an explanation of the column names used in the data.

election_id
(Internally database generated ID for that election)

election_type
Type of election - only full "council" elections are present in this data, "by-election" would be the other election type.

election_date
Date of the election, dd/mm/yyyy

district_name
Name of the district

division_name
Name of the electoral division

division_url
URL holding further information for that electoral division, held in the Committee Admin database. Includes parish, ward info, number of registered electors, and most recent results.

division_openlylocal_id
Openly Local id for the division. See http://openlylocal.com and http://openelectiondata.org/

result_vote
Number of votes cast in that election

result_url
Link to result page on Warwickshire Web site

candidates_person_id
(Internally generated person ID, unique for that person)

candidate_votes
Number of votes cast for that candidate

candidate_elected
0 = not elected, 1 = elected. Note that in some electoral divisions, two councillors are returned

party_name
Full party name

party_short_name
Abbreviated party name (eg. "Lab", "Con" etc.)

party_resource_uri
Link to Open Election Data url for the party.

person_id
(Internally generated person ID, unique for that person)

person_first_name
First name of person

person_middle_names
Middle names of person

person_last_name
Last name of person

person_all_names
Concatenated string of names

• elections

• councillors