2005 - 2006 REGISTRATION DATA
 
 
File Format:        Microsoft Office Excel
 
Number of records:  43323 RECORDS
 
File Structure:
CERTIFICATE ID			TEXT 12 
CERTIFICATE #            	TEXT 14
COMPANY                  	TEXT 80
ADDRESS                  	TEXT 30   PRINCIPAL PLACE OF BUSINESS
CITY                     	TEXT 30   PRINCIPAL PLACE OF BUSINESS
STATE                    	TEXT  2   PRINCIPAL PLACE OF BUSINESS
ZIPCODE                  	TEXT 20
COUNTRY                  	TEXT 30
CONTACT NAME             	TEXT 30
CONTACT PHONE            	TEXT 20
TRANSPORT MODE           	TEXT  4   ** SEE KEY BELOW
NAICS CODE               	TEXT  6
SMALL BUSINESS           	TEXT  1   (T=True, F=False)
RAILROAD ALPHABETIC CODE 	TEXT  4
US DOT ID NUMBER         	TEXT  7
MC/MX (FORMERLY ICC) NUMBER     TEXT  8
 
SHIPPER OF "A"           	TEXT  1
SHIPPER OF "B"           	TEXT  1
SHIPPER OF "C"           	TEXT  1
SHIPPER OF "D"           	TEXT  1
SHIPPER OF "E"           	TEXT  1
SHIPPER OF "F"           	TEXT  1
 
CARRIER OF "A"           	TEXT  1
CARRIER OF "B"           	TEXT  1
CARRIER OF "C"           	TEXT  1
CARRIER OF "D"           	TEXT  1
CARRIER OF "E"           	TEXT  1
CARRIER OF "F"           	TEXT  1
 
OTHER OF "A"             	TEXT  1
OTHER OF "B"             	TEXT  1
OTHER OF "C"             	TEXT  1
OTHER OF "D"             	TEXT  1
OTHER OF "E"            	TEXT  1
OTHER OF "F"             	TEXT  1
 
 
MODE OF TRANSPORT
 
     Four character code of 1's and 0's.
 
        First char          Highway   (Yes if 1)
        Second char         Rail      (Yes if 1)
        Third char          Water     (Yes if 1)
        Fourth char         Air       (Yes if 1)
 
Example:  A code of "1001" would be highway and air modes.