Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Table structure for New York state Board of Elections data
CREATE TABLE `state_boe` (
`LASTNAME` varchar(255) DEFAULT NULL,
`FIRSTNAME` varchar(255) DEFAULT NULL,
`MIDDLENAME` varchar(255) DEFAULT NULL,
`NAMESUFFIX` varchar(255) DEFAULT NULL,
`RADDNUMBER` varchar(255) DEFAULT NULL,
`RHALFCODE` varchar(255) DEFAULT NULL,
`RAPARTMENT` varchar(255) DEFAULT NULL,
`RPREDIRECTION` varchar(255) DEFAULT NULL,
`RSTREETNAME` varchar(255) DEFAULT NULL,
`RPOSTDIRECTION` varchar(255) DEFAULT NULL,
`RCITY` varchar(255) DEFAULT NULL,
`RZIP5` varchar(255) DEFAULT NULL,
`RZIP4` varchar(255) DEFAULT NULL,
`MAILADD1` varchar(255) DEFAULT NULL,
`MAILADD2` varchar(255) DEFAULT NULL,
`MAILADD3` varchar(255) DEFAULT NULL,
`MAILADD4` varchar(255) DEFAULT NULL,
`DOB` varchar(255) DEFAULT NULL,
`GENDER` varchar(255) DEFAULT NULL,
`ENROLLMENT` varchar(255) DEFAULT NULL,
`OTHERPARTY` varchar(255) DEFAULT NULL,
`COUNTYCODE` int(11) DEFAULT NULL,
`ELECTION_DISTRICT` int(11) DEFAULT NULL,
`LEGISLATIVE_DISTRICT` int(11) DEFAULT NULL,
`TOWN` varchar(255) DEFAULT NULL,
`WARD` varchar(255) DEFAULT NULL,
`CONGRESS_DISTRICT` int(11) DEFAULT NULL,
`SENATE_DISTRICT` int(11) DEFAULT NULL,
`ASSEMBLY_DISTRICT` int(11) DEFAULT NULL,
`LASTVOTEDATE` varchar(255) DEFAULT NULL,
`PREVYEARVOTED` varchar(255) DEFAULT NULL,
`PREVCOUNTY` varchar(255) DEFAULT NULL,
`PREVADDRESS` varchar(255) DEFAULT NULL,
`PREVNAME` varchar(255) DEFAULT NULL,
`COUNTYVRNUMBER` varchar(255) DEFAULT NULL,
`REGDATE` varchar(255) DEFAULT NULL,
`VRSOURCE` varchar(255) DEFAULT NULL,
`IDREQUIRED` varchar(255) DEFAULT NULL,
`IDMET` varchar(255) DEFAULT NULL,
`STATUS` varchar(255) DEFAULT NULL,
`REASONCODE` varchar(255) DEFAULT NULL,
`INACT_DATE` varchar(255) DEFAULT NULL,
`PURGE_DATE` varchar(255) DEFAULT NULL,
`SBOEID` varchar(255) DEFAULT NULL,
`VOTER_HISTORY` varchar(32767) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment