---
name: uscg-psix-port-state-information-exchange-ingestion
description: "How to get USCG Port State Information Exchange (PSIX) data into a pandas DataFrame and Parquet: access, the request, the format, limits, quirks and terms."
---

# Probe USCG PSIX search, help and XLSX export pages

Source entry: https://signal-lab.qdt.ai/datasets/uscg-psix-port-state-information-exchange
Provider: https://cgmix.uscg.mil/PSIX/PSIXSearch.aspx
Checked against the provider's documentation: 2026-11-05

## Access
- No key for the public PSIX search, help and XLSX export pages.

## Request
```bash
curl -I 'https://cgmix.uscg.mil/PSIX/PSIXSearch.aspx'
```

## Format
HTML PSIX search tool; HTML help page; ASPX export endpoint that returns XLSX.

## Load into pandas and Parquet
Needs Python 3 with requests, pandas and pyarrow.
```python
"""Check PSIX search, help and XLSX export page reachability -> pandas -> Parquet."""
import pandas as pd
import requests

UA = {"User-Agent": "SignalLabCheck/1.0"}
rows = []
for url, note in [
    ("https://cgmix.uscg.mil/PSIX/PSIXSearch.aspx", "PSIX search tool"),
    ("https://cgmix.uscg.mil/PSIX/PSIXHelp.aspx", "PSIX help page"),
    ("https://cgmix.uscg.mil/XML/PSIXExportSearch.aspx", "PSIX XLSX export endpoint"),
]:
    r = requests.get(url, headers=UA, timeout=60, allow_redirects=True)
    rows.append({"url": url, "note": note, "status": r.status_code, "bytes": len(r.content)})
df = pd.DataFrame(rows)
df.to_parquet("uscg_psix_pages.parquet", index=False)
print(df)

```
Run by us on 2026-11-05 (python 3 | pandas | pyarrow | requests). Result: PSIX search, help and XLSX export pages all returned HTTP 200 on 2026-11-05.

## Limits
- Not stated numeric rate limit.
- This skill does not run a full vessel search or download the XLSX export; it only probes reachability.

## Quirks
- PSIX is a weekly FOIA-data snapshot, not a live feed.
- The export endpoint returns XLSX, not CSV or JSON.

## Terms and attribution
- No separate data licence is stated; US federal (USCG) public tool.
- Terms page: https://cgmix.uscg.mil/PSIX/PSIXHelp.aspx

## Sources
- https://cgmix.uscg.mil/PSIX/PSIXHelp.aspx: "PSIX represents a weekly snapshot of Freedom of Information Act (FOIA) data on U.S. flag vessels, foreign vessels operating in U.S. waters, and Coast Guard contacts with those vessels."
- https://cgmix.uscg.mil/XML/PSIXExportSearch.aspx: "search and download available Vessel Inspection, Vessel Operational Control and Vessel Deficiency data… Downloads will export in XLSX format."

## Help improve this skill
Missing a source, or see something to improve? Call the MCP tool suggest_source or feedback (or POST /api/suggest or /api/feedback). Reviewed ideas: https://signal-lab.qdt.ai/agent-suggestions

Information for educational purposes only. Free tiers, limits and licenses belong to the providers and may change; check the provider's own terms before using the data.