> ## Documentation Index
> Fetch the complete documentation index at: https://dhanurgo.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# NTTA Toll CSV

> North Texas Tollway Authority CSV format

# NTTA Toll CSV

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

<Note>
  Download a sample file: [ntta-toll-sample.csv](/samples/ntta-toll-sample.csv)
</Note>

## 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

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

  ```typescript theme={null}
  // 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];
  ```
</Warning>

## Deduplication

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