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

# Data Export Tab

> Excel-style filtering of telemetry records with CSV and PDF download.

<Frame caption="Data Export — column selector and Excel-style filters">
  <img src="https://mintcdn.com/metaweaveconsultant/Yh8TWLsifrpzxzbC/images/export/column-filters.png?fit=max&auto=format&n=Yh8TWLsifrpzxzbC&q=85&s=dd0ae25f1f029f6c526f40e6bb7933f5" alt="Data Export tab showing column toggle buttons and active filter chips above the data table" width="1440" height="900" data-path="images/export/column-filters.png" />
</Frame>

## What this tab does

The Data Export tab loads the full telemetry dataset and provides a spreadsheet-like interface to filter, preview, and export records as CSV or PDF. It is the primary tool for extracting compliance evidence and operational reports.

## How data loads

This tab always loads the maximum dataset:

1. **Stage 1** — Fetches one year of daily aggregated data for an instant initial table view
2. **Stage 2** — Streams raw 500-record chunks until all records are loaded

All filtering, sorting, and export operations run client-side on the fully-loaded dataset, so no additional API calls are needed after streaming completes.

## Column selector

Toggle buttons at the top of the tab control which columns appear in the table and are included in exports. Default selection:

`timestamp`, `operation_type`, `location`, `UVR_INTENSITY`, `UVR_POWER_OUTPUT`, `SYS_FLOW_RATE`, `SYS_PRESSURE`, `AVG_LAMP_EFFICIENCY`, `FAILED_LAMP_COUNT`

### All 26 exportable columns

| Column                     | Type     | Description                                |
| -------------------------- | -------- | ------------------------------------------ |
| `timestamp`                | datetime | Record timestamp                           |
| `system_id`                | text     | System identifier                          |
| `operation_type`           | text     | BALLAST or DEBALLAST                       |
| `location`                 | text     | Port name                                  |
| `month`                    | integer  | Month number                               |
| `UVR_INTENSITY`            | number   | UV intensity W/m²                          |
| `UVR_INTENSITY_NORMALIZED` | number   | Temperature-corrected intensity W/m²       |
| `UVR_POWER_OUTPUT`         | number   | Power output % of rated                    |
| `UVR_WATER_TEMP`           | number   | Water temperature °C                       |
| `UVR_LEVEL`                | text     | UV level descriptor                        |
| `LDC_AIR_TEMP`             | number   | LDC air temperature °C                     |
| `LDC_FAN_SPEED`            | number   | LDC fan speed RPM                          |
| `LDC_FAN_STATUS`           | text     | Fan operational state                      |
| `FLT_DIFF_PRESSURE`        | number   | Filter differential pressure bar           |
| `FLT_MOTOR_STATUS`         | text     | Filter motor state                         |
| `FLT_BACKFLUSH_ACTIVE`     | boolean  | Backflush in progress                      |
| `FLT_BACKFLUSH_COUNT`      | integer  | Cumulative backflush cycles                |
| `SYS_FLOW_RATE`            | number   | Flow rate m³/h                             |
| `SYS_PRESSURE`             | number   | System pressure bar                        |
| `SYS_VALVE_POSITION`       | number   | Valve opening %                            |
| `SYS_TOTAL_BALLAST_VOL`    | number   | Cumulative ballast volume m³               |
| `SYS_TOTAL_DEBALLAST_VOL`  | number   | Cumulative deballast volume m³             |
| `AVG_LAMP_EFFICIENCY`      | number   | Mean efficiency of all 16 lamps %          |
| `FAILED_LAMP_COUNT`        | integer  | Count of FAILED-status lamps               |
| `DEGRADATION_IMPACT_PCT`   | number   | UV output reduction due to aging %         |
| `POWER_COMPENSATION_PCT`   | number   | Extra power for degradation compensation % |

## Column filters (Excel-style)

Hover any column header to reveal a filter funnel icon. Click it to open a filter panel:

<Frame caption="Export options — CSV and PDF download buttons">
  <img src="https://mintcdn.com/metaweaveconsultant/Yh8TWLsifrpzxzbC/images/export/export-buttons.png?fit=max&auto=format&n=Yh8TWLsifrpzxzbC&q=85&s=8c8945126a4e0ee96ffb8f001ed6aad4" alt="CSV and PDF export buttons with record count indicator" width="1440" height="900" data-path="images/export/export-buttons.png" />
</Frame>

| Column type                         | Filter options                                                                   |
| ----------------------------------- | -------------------------------------------------------------------------------- |
| Text (`operation_type`, `location`) | Substring match (case-insensitive)                                               |
| Numeric                             | Two-condition filter with operators: `>`, `>=`, `<`, `<=`, `=`, connected by AND |
| Date (`timestamp`)                  | Date range — start date and end date                                             |

Active filters appear as removable chips above the table. Multiple filters combine with AND logic.

## Data table

Paginated preview with configurable rows per page (25, 50, or 100). The table shows only selected columns with active filters applied. The record count above the table updates to reflect the filtered row count.

## Exporting data

| Format | Library           | Scope                                     | File name                       |
| ------ | ----------------- | ----------------------------------------- | ------------------------------- |
| CSV    | PapaParse         | All filtered rows (not just current page) | `bwts_telemetry_YYYY-MM-DD.csv` |
| PDF    | jsPDF + AutoTable | First 100 rows of filtered data           | `bwts_telemetry_YYYY-MM-DD.pdf` |

The PDF includes a header with: report title, generation timestamp, selected date range, and total record count.

<Tip>
  For compliance submissions, export CSV with columns `timestamp`, `operation_type`, `location`, and `UVR_INTENSITY`. Filter by date range to cover the voyage in question. This provides a timestamped intensity record for every ballasting event — suitable for supplementary Ballast Water Record Book documentation.
</Tip>

## Source

| Stage   | Endpoint                                                                |
| ------- | ----------------------------------------------------------------------- |
| Stage 1 | `/api/telemetry/aggregated?interval=day&hours=8760`                     |
| Stage 2 | `/api/telemetry/chunked?startDate=...&endDate=...&offset=...&limit=500` |