campaigns

we collect and organize data on filed campaigns for specific offices this data is the primary unit of our electoral data graph note we consider the different stages in an election (e g , primary, run off, general) to be distinct elections with distinct campaigns for example, as of march 26, 2024, colin allred has a single candidate id but six distinct entries in this table with their own campaign id values – covering two congressional primaries, one congressional run off, two congressional general elections, and one (pending) u s senate primary schema column description campaign id unique id associated with a given campaign candidate id unique id associated with a candidate (i e , the person whose candidacy is represented by a given campaign) district id unique id associated with a specific political district election id unique id associated with a specific election (i e , an event in which a jurisdiction elects candidates into specific offices) election date the final day of voting for a given election in yyyy mm dd format office name the name of the office a given campaign is vying for in proper case district name the common name of the district a campaign associated with name first a candidate’s legal first name name first alt a candidate’s nickname, if applicable name middle a candidate’s middle name name last a candidate’s legal last name name last alt a candidate's alternate last name, if applicable (often a maiden name or a different presentation of a hyphenated name ) is incumbent a boolean indicating whether the candidate is also the current office holder in this district party affiliation the candidate’s primary party affiliation (secondary ballot lines, such as the working families party, do not create their own entries in our database )