Daily Index Extract Files


Below are examples of the index files

Files will be present for each day. On days that there is no activity, the file size will be 0 (zero). Each file will be available on the download site for 7 days. The data is in pipe (|) delimited format. Trailing spaces are trimmed from character data. Leading zeros are trimmed from numeric data. Blank fields are null (||-two sequential pipes).

CFN Files

MM-DD-YYcfn.txt and MM-DD-YYcfn-rec.txt are the CFN files and will contain one record per CFN (Clerk's File Number).

Example of a CFN record:

103523019|11/26/2003|091651|WD|206000.00|36494|876|O|PINEHURST 5-13 B LOT 1 LESS W 60,4 LESS W 60 BLK 2|8236010130|C|

This file contains the following:

Field Name  Description/Comments
Clerk's File Number  Up to 9 positions. Always present
Record Date  MM/DD/YYYY Always present
Record Time  HHMMSS Always present
Document Type Code Up to 10 positions. Always present.
Consideration Amount Monetary value (ex. 999.99) up to 19 positions.  Records with no Consideration Amount will contain 0.00
Book Number  Book Number, up to six positions. Always present.
Page Number  Page Number within a book, up to four positions. Always present.
Book Type  Type of Book, (ex. O = Official Records Book, P = Plat Book, M = Map Book) one position. Always present.
Legal Description Up to 255 positions. May be present.
Parcel ID 12 positions.  May be present.
Re-record Flag  C=Corrected Document, R=Re-recorded Document, one position. May be present.

Name files

MM-DD-YYnme.txt and MM-DD-YYnme-rec.txt are the Name files and will contain one record per name indexed to a document. There can be multiple name records per new recording.

Examples of a Name record:

103524378|PALM VACATION GROUP|D|1|
103524378|SMITH,DONALD L|R|1|
103524378|SMITH,MICHELINA|R|2|

This file contains the following:

Field Name Description/Comments
Clerk's File Number Up to 9 positions. Always present
Party Name Up to 60 positions. Always present.
Party Type "D" indicates direct (from) party "R" indicates reverse (to) party. One position. Always present
Name Sequence Numeric, designates order in which name was indexed within a party type classification of a document. Always present</TD< TR>

Link File

MM-DD-YYlnk.txt is the Link file and will contain one record per link indexed to a document. It is used to link new recordings to prior related records (e.g., Satisfaction of Mortgage to the original Mortgage). There can be multiple link records per new recording.

Example of a Link record:

100000002|26000|102|O|SM|96416592|25304|988|O|M|

This file contains the following:

Field Name Description/Comments
Clerk's File Number Up to 9 positions. Always present
Book Number  Book Number, up to six positions. Always present.
Page Number  Page Number within a book, up to four positions. Always present.
Book Type  Type of Book, (ex. O = Official Records Book, P = Plat Book, M = Map Book) one position. Always present.
Document Type Code Up to 10 positions. Always present.
Prior Clerk's File Number Up to 9 positions. Always present
Prior Book Number  Book Number, up to six positions. Always present.
Prior Page Number  Page Number within a book, up to four positions. Always present.
Prior Book Type  Type of Book, (ex. O = Official Records Book, P = Plat Book, M = Map Book) one position. Always present.
Prior Document Type Code Up to 10 positions. Always present.