NTTA Toll CSV

North Texas Tollway Authority CSV format

NTTA Toll CSV

CSV format exported from the NTTA (North Texas Tollway Authority) account portal.

Download a sample file: ntta-toll-sample.csv

Field Reference

CSV Column	DB Column	Type	Description
Transaction Date	transaction_date	date	Date of toll transaction
Transaction Time	transaction_time	text	Time (stored as-is, CST)
Plaza/Gantry Name	plaza_name	text	Toll plaza or gantry location
Roadway	roadway	text	Road name (PGBT, DNT, etc.)
Amount	amount	numeric	Toll amount (USD)
Tag Number	tag_number	text	TollTag transponder ID
Vehicle	plate	text	Vehicle description or plate

Common Roadways

Abbreviation	Full Name
PGBT	President George Bush Turnpike
DNT	Dallas North Tollway
SRT	Sam Rayburn Tollway
LBJ	LBJ Express
CTTL	Chisholm Trail Tollway
MCLP	Mountain Creek Lake Parkway

Date Handling

NTTA reports in Central Time (CST/CDT). Dates are stored as-is in the database — do NOT convert to UTC.

// CORRECT
const parsed = new Date(dateStr);
txDate = `${parsed.getFullYear()}-${String(parsed.getMonth()+1).padStart(2,"0")}-${String(parsed.getDate()).padStart(2,"0")}`;

// WRONG - shifts to UTC, may change the date
txDate = new Date(dateStr).toISOString().split("T")[0];

Deduplication

Toll transactions are deduplicated by: provider + transaction_date + amount + plaza_name