Notes on 12/19/2005 Michigan APIS Feed

1. michigan.apis.2129: bad dates (remove the "(?)")
   
   

   dd046 | 1 | 500 (?)
   dd046 | 2 | 599 (?)
   

2. michigan.apis.3535: bad dates (removes space after "-")
   
   

   dd046 | 1 | - 223
   dd046 | 2 | - 181
   

   
   
3. records 1314, 1315, 3197, 3198, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3212:
   These records contain dd653 tags that are too long. The individual subject terms appear to be concatenated
   together forming values longer than the 750 characters currently supported by the database. Ideally each term should be
   in a separate dd653 tag. If this is not possible then breaking out into smaller chunks is a viable alternative.
   
   Example: michigan.apis.1314

   cu653 | 2 | Debtor and creditor--Egypt--Bacchias (Extinct city); Home ownership--Egypt--Bacchias (Extinct city);
   Literacy--Egypt--Bacchias (Extinct city); Interest--Egypt--Bacchias (Extinct city); Husband and wife--Egypt--Bac
   chias (Extinct city); Rent--Egypt--Karanis (Extinct city); Housing--Egypt--Bacchias (Extinct city); Bacchias (Ex
   tinct city); Guardian and ward--Egypt--Bacchias (Extinct city); 650: Drachma.; Scars--Egypt--Bacchias (Extinct c
   ity); Family--Egypt--Bacchais (Extinct city); Suretyship and guaranty--Egypt--Bacchias (Extinct city); Receipts 
   (Acknowledgments)--Egypt--Bacchias (Extinct city); Contracts--Egypt--Bacchias (Extinct city); Building--Egypt--B
   acchias (Extinct city); Dwellings--Egypt--Bacchias (Extinct city); Notaries--Egypt--Bacchias (Extinct city)
   
   should be broken up into individual terms:
   
   dd653 | 2 | Debtor and creditor--Egypt--Bacchias (Extinct city)
   dd653 | 3 | Home ownership--Egypt--Bacchias (Extinct city)
   dd653 | 4 | Literacy--Egypt--Bacchias (Extinct city)
   ...
   
   or at least into two tags each less than 750 characters in length:
   
   dd653 | 2 | Debtor and creditor--Egypt--Bacchias (Extinct city); Home ownership--Egypt--Bacchias (Extinct city); 
   Literacy--Egypt--Bacchias (Extinct city); Interest--Egypt--Bacchias (Extinct city); Husband and wife--Egypt--Bac
   chias (Extinct city); Rent--Egypt--Karanis (Extinct city); Housing--Egypt--Bacchias (Extinct city); Bacchias (Ex
   tinct city); Guardian and ward--Egypt--Bacchias (Extinct city); 
   dd653 | 3 | 650: Drachma.; Scars--Egypt--Bacchias (Extinct city); Family--Egypt--Bacchais (Extinct city); Surety
   ship and guaranty--Egypt--Bacchias (Extinct city); Receipts (Acknowledgments)--Egypt--Bacchias (Extinct city); C
   ontracts--Egypt--Bacchias (Extinct city); Building--Egypt--Bacchias (Extinct city); Dwellings--Egypt--Bacchias (
   Extinct city); Notaries--Egypt--Bacchias (Extinct city)