Tab-delimited file g00_voter.txt

        rgprec    varchar(9),
        type      varchar(1),
        totreg    int       ,
        dem       int       ,
        rep       int       ,
        aip       int       ,
        paf       int       ,
        msc       int       ,
        lib       int       ,
        nlp       int       ,
        grn       int       ,
        ref       int       ,
        dcl       int       ,
        mr        int       ,
        mrs       int       ,
        miss      int       ,
        ms        int       ,
        male      int       ,
        female    int       ,
        hispdem   int       ,
        hisprep   int       ,
        hispdcl   int       ,
        hispoth   int       ,
        jewdem    int       ,
        jewrep    int       ,
        jewdcl    int       ,
        jewoth    int       ,
        kordem    int       ,
        korrep    int       ,
        kordcl    int       ,
        koroth    int       ,
        japdem    int       ,
        japrep    int       ,
        japdcl    int       ,
        japoth    int       ,
        chidem    int       ,
        chirep    int       ,
        chidcl    int       ,
        chioth    int       ,
        inddem    int       ,
        indrep    int       ,
        inddcl    int       ,
        indoth    int       ,
        vietdem   int       ,
        vietrep   int       ,
        vietdcl   int       ,
        vietoth   int       ,
        fildem    int       ,
        filrep    int       ,
        fildcl    int       ,
        filoth    int       ,
        demm1824  int       ,
        demm2534  int       ,
        demm3544  int       ,
        demm4554  int       ,
        demm5564  int       ,
        demm65pl  int       ,
        demmunk   int       ,
        demf1824  int       ,
        demf2534  int       ,
        demf3544  int       ,
        demf4554  int       ,
        demf5564  int       ,
        demf65pl  int       ,
        demfunk   int       ,
        repm1824  int       ,
        repm2534  int       ,
        repm3544  int       ,
        repm4554  int       ,
        repm5564  int       ,
        repm65pl  int       ,
        repmunk   int       ,
        repf1824  int       ,
        repf2534  int       ,
        repf3544  int       ,
        repf4554  int       ,
        repf5564  int       ,
        repf65pl  int       ,
        repfunk   int       ,
        dclm1824  int       ,
        dclm2534  int       ,
        dclm3544  int       ,
        dclm4554  int       ,
        dclm5564  int       ,
        dclm65pl  int       ,
        dclmunk   int       ,
        dclf1824  int       ,
        dclf2534  int       ,
        dclf3544  int       ,
        dclf4554  int       ,
        dclf5564  int       ,
        dclf65pl  int       ,
        dclfunk   int       ,
        othm1824  int       ,
        othm2534  int       ,
        othm3544  int       ,
        othm4554  int       ,
        othm5564  int       ,
        othm65pl  int       ,
        othmunk   int       ,
        othf1824  int       ,
        othf2534  int       ,
        othf3544  int       ,
        othf4554  int       ,
        othf5564  int       ,
        othf65pl  int       ,
        othfunk   int       ,
        dreg1g    int       ,
        dreg2g    int       ,
        dreg3g    int       ,
        dreg4g    int       ,
        dreg5g    int       ,
        dreg6g    int       ,
        dreg7g    int       ,
        dreg8g    int       ,
        dreg9g    int       ,
        rreg1g    int       ,
        rreg2g    int       ,
        rreg3g    int       ,
        rreg4g    int       ,
        rreg5g    int       ,
        rreg6g    int       ,
        rreg7g    int       ,
        rreg8g    int       ,
        rreg9g    int       ,
        ireg1g    int       ,
        ireg2g    int       ,
        ireg3g    int       ,
        ireg4g    int       ,
        ireg5g    int       ,
        ireg6g    int       ,
        ireg7g    int       ,
        ireg8g    int       ,
        ireg9g    int       ,
        oreg1g    int       ,
        oreg2g    int       ,
        oreg3g    int       ,
        oreg4g    int       ,
        oreg5g    int       ,
        oreg6g    int       ,
        oreg7g    int       ,
        oreg8g    int       ,
        oreg9g    int
        )

Use precincts with type A, N and V

  +------+----------+-------------------+
  | type | count(*) | sum(totreg      ) |
  +------+----------+-------------------+
  |      |    38503 |              NULL |
  | 2    |        2 |                 0 |
  | A    |    34666 |           2752274 |
  | N    |    36733 |           4790712 |
  | V    |    34385 |           8105081 |
  +------+----------+-------------------+
