Codebook
Every variable in the database, its type, category, and value labels.
| Variable | Type | Category | Description | Value labels |
|---|---|---|---|---|
| Age | Calculated | Personal | Calculated from assembly year and dob year | — |
| AsmbNo | Numeric | Political | Assembly Number. | — |
| AsmbYr | Text | Political | Assembly Year | — |
| CampExp | Numeric | Candidates | Campaign Expenditure | — |
| CampExp per vote | Calculated | Elections | Campaign Expenditure per vote. Calculated by dividing Total Campaign Expenditure by Total Votes | — |
| DistNo | Text | Political/Elections | District Number--See also Jurisdictions | — |
| DistType | Text | Political/Elections | District Type | AL — At Large: statewide electionMM — Multi-member districtSM — Single member district |
| DobDay | Numeric | Personal | Day of birth (1-31) | — |
| DobMonth | Numeric | Personal | Month of birth (1-12) | — |
| DobYear | Numeric | Personal | Year of birth | — |
| EID | Text | Elections/Candidates | Election ID | — |
| ElectOutcome | Numeric | Candidates | Election Outcome | 0 — Lost1 — Won |
| ElectType | Text | Elections | Election Type | RVAG — Regular Virginia GubernatorialRVAH — Regular Virginia House ElectionRVAS — Regular Virginia Senate ElectionSVAG — Special Virginia GubernatorialSVAH — Special Virginia House ElectionSVAS — Special Virginia Senate Election |
| ElectYr | Text | Election | Election Year | — |
| Ethn1 | Text | Personal | Ethnicity--primary | AAm — African AmericanAPI — Asian Pacific IslanderCHI — ChineseDAN — DanishENG — EnglishFRE — FrenchGER — GermanGRK — GreekHIS — Hispanic/LatinoIRN — IranianISH — IrishNAm — Native AmericanPAL — Palestinian ArabSCT — ScottishSIR — Scotch-IrishSWS — SwissU — UnknownWEL — Welsh |
| Ethn2 | Text | Personal | Ethnicity--secondary | See Ethn1 — Same as Ethn1 |
| Ethn3 | Text | Personal | Ethnicity--tertiary | See Ethn1 — Same as Ethn1 |
| FirstName | Text | Personal | First Name | — |
| Gender | Text | Personal | Gender (M for Male, F for Female) | F — FemaleM — Male |
| InOffice | Numeric | Political | Year of Service for Tenure Statistics (used to calculate Tenure to Date and Career Tenure) | — |
| IncStatus | Text | Candidates | Incumbency Status | 0 — Not an Incumbent1 — Incumbent |
| Juris | Text | Elections | Jurisdictions | — |
| Juris1 | Text | Political | Jurisdiction 1 | — |
| Juris10 | Text | Political | Jurisdiction 10 | — |
| Juris11 | Text | Political | Jurisdiction 11 | — |
| Juris12 | Text | Political | Jurisdiction 12 | — |
| Juris13 | Text | Political | Jurisdiction 13 | — |
| Juris14 | Text | Political | Jurisdiction 14 | — |
| Juris15 | Text | Political | Jurisdiction 15 | — |
| Juris16 | Text | Political | Jurisdiction 16 | — |
| Juris2 | Text | Political | Jurisdiction 2 | — |
| Juris3 | Text | Political | Jurisdiction 3 | — |
| Juris4 | Text | Political | Jurisdiction 4 | — |
| Juris5 | Text | Political | Jurisdiction 5 | — |
| Juris6 | Text | Political | Jurisdiction 6 | — |
| Juris7 | Text | Political | Jurisdiction 7 | — |
| Juris8 | Text | Political | Jurisdiction 8 | — |
| Juris9 | Text | Political | Jurisdiction 9 | — |
| LastName | Text | Personal | Last Name | — |
| Leadership | Text | Political | Leadership | 0 — Not a legislative leader1 — House of Delegates Speaker10 — Governor11 — House of Delegates Assistant Minority Leader12 — Virginia Senate Democratic Floor Leader13 — Virginia Senate Republican Floor Leader14 — House Minority Whip15 — Virginia Senate Democratic Caucus Chair2 — House of Delegates Majority Leader3 — House of Delegates Majority Floor Leader4 — House of Delegates Minority Leader5 — House of Delegates Minority Floor Leader6 — Virginia Senate Speaker Pro Tempore7 — Virginia Senate Majority Leader8 — Virginia Senate Speaker9 — Virginia Senate Minority Leader |
| MidName | Text | Personal | Middle Name | — |
| Name | Numeric | Personal | Name number (when there is more than one of a Unique Name) | — |
| NoCandidates | Text | Elections | Number of Candidates | — |
| NoSeats | Text | Elections | Number of Seats in a race | — |
| Notes | Text | All | Notes | — |
| Number of Incumbents | Calculated | Elections | Number of Incumbents Running (calculated by summing IncStatus for all candidates in a race) | — |
| Office | Text | Political/Elections | Office | VAG — Governor of VirginiaVAH — Virginia House of DelegatesVAS — Virginia Senate |
| OtherVotes | Text | Elections | Other Votes | — |
| PartyAff | Text | Political/Candidates | Party Affiliation | AIN — American IndependentAMr — AmericanCNS — ConservativeCOM — CommunistCnD — Conservative DemocratDEM — DemocratDRp — Democrat-RepublicanFED — FederalistFUN — FunderFUS — FusionistGrP — Green PartyIND — IndependentKNN — Know NothingLBR — Lily Black RepublicanLIB — LibertarianNAZ — NaziPOP — PopulistPRO — ProhibitionREA — ReadjusterREP — RepublicanSLA — Socialist LaborSOC — SocialistSoD — Social DemocratU — UnknownUNN — UnionVCN — Virginia ConservativeVRP — Virginia Reform PartyWHG — Whig |
| Percent Camp Exp | Calculated | Candidates | Percent Campaign Expenditure (Calculated by dividing CampExp by Total Campaign Expenditure and multiplying by 100) | — |
| PercentVotes | Text/Calc | Candidates | Percent Votes. This is a stored value that is not displayed. The value that is displayed by the queries is calculated by totaling the votes for each candidate in a race plus the OtherVotes amount, then divide each candidates votes by the total found above and then multiply by 100. | — |
| Pid | Numeric | Personal/Pol/Cand | Personal Identification Number | — |
| Ref | Text | All | References | — |
| RepTot | Text | Elections | Reported Total Votes | — |
| Suffix | Text | Personal | Suffix | — |
| Tally | Boolean | — | Completeness of vote tally or lack thereof. | — |
| Tenure | Calculated | Political | Tenure to Date or Career Tenure | — |
| Total Camp Exp | Calculated | Elections | Total Campaign Expenditure (calculated from CampExp for candidates in a given race) | — |
| Total Votes | Calculated | Elections | Total Votes (calculated from Votes for candidates in a given race plus OtherVotes) | — |
| Turn | Text | Political | Turnover of seat | 1 — Gained Seat2 — Retained seat |
| UniqueName | Text | Personal | Unique Name (Full Name) | — |
| Votes | Text | Candidates | Votes cast for a candidate | — |