crosswalk__*

we maintain 8 different crosswalk tables linking data from ballotready with data from indigo these tables include crosswalk election election links ballotready's election id to indigo's election id indigo considers an election to be a unique combination of an election date, an administrative jurisdiction, and (in the case of partisan primaries) the party of candidates eligible for the ballot ballotready considers an election to be a unique combination of an election date and an administrative jurisdiction – with no party level differentiation in primaries because of this difference, we include some additional fields for reference, including eligible candidate party crosswalk position office links ballotready's position id to indigo's office id indigo considers an office to be a legal construct created by a parent jurisdiction ballotready considers a position to be a specific elected office associated with a specific district in the indigo data graph, all state senate seats in nebrasa have the same office id in the ballotready data graph, there would be 49 distinct active position id values associated with that body because of that difference, this crosswalk contains "many to one" connections crosswalk position district links ballotready's position id to indigo's district id indigo considers a district to be a unit of electoral geography associated with a specific elected office when a district is redrawn via redistricting, it is deprecated and replaced with a new district – with a new district id ballotready considers a position to be a specific office associated with a specific conceptual (rather than spatial) district so in the ballotready data graph, florida state house district 1 would maintain the same position id over time but in the indigo data graph, florida state house district 1 would have a unique district id for each of its spatial variations crosswalk race contest links ballotready's race id to indigo's contest id both ballotready and indigo consider a race/contest to be a specific election for a specific elected office associated with a specific district crosswalk candidate candidate links ballotready's candidate id to indigo's candidate id both ballotready and indigo consider a candidate to be an individual person who has run for office – independent of their individual runs for office crosswalk candidacy campaign links ballotready's candidacy id to indigo's campaign id both ballotready and indigo consider a candidacy/campaign to be a specific instance of an individual candidate running for office in both data graphs, primary and general election candidacies/campaigns – as well as run offs of any kind – are distinct crosswalk candidate voter links ballotready's candidate id to indigo's voter id crosswalk office holder voter links ballotready's office holder id to indigo's voter id