CSV File Download

Contact Customer Service About Any Questions

If you have any questions or would like the CSV File Download enabled for your account, please call (888) 411-9661 between 9:00 AM and 6:00 PM EST Monday through Friday. Access to this feature is disabled by default. It is only available to Carrier411 customers with an active account, and it is not available for trial accounts. This optional add-on feature can be enabled for an additional $49.00 per month. Carrier411 reserves the right to allow access to the CSV File Download feature.

Welcome to the developer documentation for our CSV File Download feature.

If you monitor thousands of carriers, then you know how time-consuming it can be to update records in your transportation software. Consider the consequences if you overlook updating certain carriers. Integration with Carrier411 using our CSV File Download feature can automate the update process, save you valuable time, improve efficiency, and help protect your business from using the wrong carriers.

As an alternative to our more robust Web Services Interface, we can provide access to a comma-separated values (CSV) file that gets created on demand.

Compared to accessing data with our Web Services Interface, our CSV File Download feature provides an easier (but more limited) way to access critical information about all the companies monitored by your Carrier411 account. Carrier411 CSV file data provides the current authority status, insurance, carrier safety ratings and Safety Measurement System (SMS) information for you to integrate with your transportation software. Again, it does this for all the companies being monitored by your Carrier411 account. SafeStat scores are no longer available and have been replaced with SMS BASIC scores.

In simple terms, your server communicates with our server. By scheduling one daily request to our CSV File Download feature, your software system can keep its database up-to-date automatically within a matter of seconds.

How to Initiate CSV File Download

First, you must have an active Carrier411 account, and the CSV File Download feature must be enabled for your account. When your server invokes the following URL string, a CSV file will be created at that moment. It will begin downloading automatically. CSV file creation may take between 5 seconds and 30 seconds, depending on the number of companies monitored by your Carrier411 account.

URL String	http://www.carrier411.com/createcsvfile.cfm?username=xxx&password=yyy Substitute xxx with your Carrier411 username and yyy with your password. Unless &header=0 (optional parameter) is specified in the above URL string, a file header row will be included in the CSV file by default.
Schedule	Schedule your server to invoke the above URL string one time only in the morning, between 7:45 AM and 9:00 AM EST. Schedule this event every Monday through Friday morning. Do not download in the evening or night, because data is updated in the early morning.
Purpose	Creates comma-separated values (CSV) file upon request. Includes data (detailed below) for all the companies monitored by your Carrier411 account.
Errors	Any errors will produce a FaultCode when the URL string is invoked. FaultCode 1: Username and password not provided. FaultCode 2: Username not provided. FaultCode 3: Password not provided. FaultCode 4: Invalid username or password. FaultCode 5: Account inactive. FaultCode 6: Account suspended. FaultCode 7: Trial accounts cannot download CSV files. FaultCode 8: CSV file download not activated for account.
Parameters	username -- Carrier411 username (Required). password -- Carrier411 password (Required). header -- 1 or 0 (Optional). Include &header=0 for no header row.

CSV File Fields and Possible Values

The following 56 fields and possible values are contained in the CSV file. View sample CSV file with header row.

1. DOCKET	CHAR 8
This is the motor carrier (MC) number for the company. It may also be an FF or MX number for freight forwarders or Mexican carriers.
2. USDOT	NUMERIC 9
This is the USDOT number for the carrier. Values may include 0 or NULL.
3. LEGALNAME	VARCHAR 120
This is the legal name of the company.
4. DBANAME	VARCHAR 60
This is the doing-business-as (dba) name for the company.
5. ADDRESS	VARCHAR 50
This is the business address for the company.
6. CITY	VARCHAR 30
This value is the city for the business address specified in ADDRESS.
7. STATE	CHAR 2
This value is the 2-character state for the business address specified in ADDRESS.
8. ZIP	VARCHAR 10
This value is the zip code for the business address specified in ADDRESS. Most zip codes are 5 digits. Some are zip plus 4. Others are international postal codes.
9. PHONE	VARCHAR 14
This value is the 10-digit business phone number if provided. The value may be NULL.
10. FAX	VARCHAR 14
This value is the 10-digit business fax number if provided. The value may be NULL.
11. EMAIL	VARCHAR 80
Possible Values: NULL or text. This is the company's email address.
12. TRUCKS	VARCHAR 6
Possible Values: NULL or numeric value. This value indicates the total number of "Power Units" operated by the carrier.
13. COMMON	CHAR 1
This value describes the company's common carrier authority status. There are three possible values: "A" for active common authority, "I" for inactive common authority or "N" for no common authority.
14. CONTRACT	CHAR 1
This value describes the company's contract carrier authority status. There are three possible values: "A" for active contract authority, "I" for inactive contract authority or "N" for no contract authority.
15. BROKER	CHAR 1
This value describes the company's broker authority status. There are three possible values: "A" for active broker authority, "I" for inactive broker authority or "N" for no broker authority.
16. PENDCOMMON	CHAR 1
Possible Values: Y or N. This value describes whether the company has applied for common carrier authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no.
17. PENDCONTRACT	CHAR 1
Possible Values: Y or N. This value describes whether the company has applied for contract carrier authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no.
18. PENDBROKER	CHAR 1
Possible Values: Y or N. This value describes whether the company has applied for broker authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no.
19. REVCOMMON	CHAR 1
Possible Values: Y or N. This value describes whether the company is pending revocation of its common carrier authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes does not mean they have lost their common carrier authority. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised.
20. REVCONTRACT	CHAR 1
Possible Values: Y or N. This value describes whether the company is pending revocation of its contract carrier authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised.
21. REVBROKER	CHAR 1
Possible Values: Y or N. This value describes whether the company is pending revocation of its broker authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes usually indicates the company is within 30 days of the premium being due for its broker bond, and it remains unpaid. However, there are other reasons this warning flag may get raised.
22. BIPDREQ	VARCHAR 10
BIPD is bodily injury property damage, more commonly known as liability insurance. If BIPD is required by the FMCSA, the minimum dollar amount of required coverage will be specified. If required, the minimum amount is usually 750000 ($750,000.00), but it could be higher. It could also be 0 (zero), if BIPD is not required. FMCSA requires companies with contract authority to have BIPD insurance.
23. BIPDFILED	VARCHAR 10
This value indicates the dollar amount of liability insurance on file for the company, as reported to the FMCSA by insurance underwriters. Even though BIPD insurance may not be required, some companies will maintain a BIPD insurance policy.
24. CARGOREQ	CHAR 1
This value indicates whether the FMCSA requires the company to have cargo insurance. There are two possible values: "Y" for yes or "N" for no.
25. CARGOFILED	CHAR 1
This value indicates whether cargo insurance is on file for the company, as reported to the FMCSA by insurance underwriters. There are two possible values: "Y" for yes or "N" for no. Even though cargo insurance may not be required, some companies will maintain a cargo insurance policy.
26. BONDREQ	CHAR 1
Possible Values: Y or N. This value indicates whether the FMCSA requires the company to have a bond. There are two possible values: "Y" for yes or "N" for no. FMCSA requires companies with broker authority to maintain a bond.
27. BONDFILED	CHAR 1
Possible Values: Y or N. This value indicates whether a broker bond is on file for the company, as reported to the FMCSA by insurance underwriters. There are two possible values: "Y" for yes or "N" for no.
28. INSAUTHUPDATED	DATETIME
This the mm/dd/yyyy date that insurance and authority information about the company was last updated in our database.
29. RATING	CHAR 1
Possible Values: NULL or single letter. This is the carrier safety rating. There are three possible safety ratings: U = Unsatisfactory, C = Conditional, S = Satisfactory. The safety rating was issued on the date specified in RATEDATE.
30. RATEDATE	DATETIME
Possible Values: NULL or date. If the carrier has a carrier safety rating value specified in RATING, this is the date the safety rating was issued formatted as mm/dd/yyyy. If the carrier has no safety rating, the value will be NULL.
31. INSPTOTAL	NUMERIC 9
Possible Values: NULL or number. Total number of inspections for the 24-month measurement period.
32. DRIVINSPTOTAL	NUMERIC 9
Possible Values: NULL or number. Number of driver inspections.
33. DRIVOOSINSPTOTAL	NUMERIC 9
Possible Values: NULL or number. Number of driver inspections with at least one driver out-of-service violation.
34. VEHINSPTOTAL	NUMERIC 9
Possible Values: NULL or number. Number of vehicle inspections.
35. VEHOOSINSPTOTAL	NUMERIC 9
Possible Values: NULL or number. Number of vehicle inspections with at least one vehicle out-of-service violation.
36. UNSAFEDRIVPCT	REAL 4
Possible Values: NULL or number. This value is the unsafe driving BASIC roadside performance percentile (SMS BASIC score for unsafe driving). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
37. UNSAFEDRIVRDALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the UNSAFEDRIVPCT score is over the threshold.
38. UNSAFEDRIVSV	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for unsafe driving within the past 12 months.
39. UNSAFEDRIVBASICALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the UNSAFEDRIVPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
40. FATIGUEDRIVPCT	REAL 4
Possible Values: NULL or number. This value is the fatigued driving (hours of service) BASIC roadside performance percentile (SMS BASIC score for fatigued driving). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
41. FATIGUEDRIVRDALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the FATIGUEDRIVPCT score is over the threshold.
42. FATIGUEDRIVSV	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for fatigued driving within the past 12 months.
43. FATIGUEDRIVBASICALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the FATIGUEDRIVPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
44. DRIVFITPCT	REAL 4
Possible Values: NULL or number. This value is the driver fitness BASIC roadside performance percentile (SMS BASIC score for driver fitness). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
45. DRIVFITRDALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the DRIVFITPCT score is over the threshold.
46. DRIVFITSV	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for driver fitness within the past 12 months.
47. DRIVFITBASICALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the DRIVFITPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
48. CONTRSUBSTPCT	REAL 4
Possible Values: NULL or number. This value is the controlled substances and alcohol BASIC roadside performance percentile (SMS BASIC score for controlled substances). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
49. CONTRSUBSTRDALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the CONTRSUBSTPCT score is over the threshold.
50. CONTRSUBSTSV	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for controlled substances within the past 12 months.
51. CONTRSUBSTBASICALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the CONTRSUBSTPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
52. VEHMAINTPCT	REAL 4
Possible Values: NULL or number. This value is the vehicle maintenance BASIC roadside performance percentile (SMS BASIC score for vehicle maintenance). Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4.
53. VEHMAINTRDALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the VEHMAINTPCT score is over the threshold.
54. VEHMAINTSV	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the carrier has serious violations from investigation for vehicle maintenance within the past 12 months.
55. VEHMAINTBASICALERT	CHAR 1
There are two possible values: "Y" for yes or "N" for no. This value indicates whether the VEHMAINTPCT score is over the threshold and/or if there are serious violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category.
56. CREATED	DATETIME
This the mm/dd/yyyy date that CSV file was created.