This is an extract of the data from Shadow Fleet section of the Ukrainian Government's War Sanctions website, served up as a Portolan / STAC catalog.
# GUR Shadow Fleet — Masters
One row per ship master (captain) GUR names in connection with a shadow-fleet vessel (534 individuals), with name, date of birth, tax id (TIN), citizenship and the vessel they command (name, GUR id, IMO). This is personal data published by GUR — handle it accordingly. Non-spatial plain Parquet; join to **vessels** on `vessel_imo` / `vessel_gur_id`.
Format: Parquet · Rows: 534
Data: https://data.source.coop/cholmes/gur-shadow-fleet/masters/masters.parquet
Collection: https://data.source.coop/cholmes/gur-shadow-fleet/masters/collection.json
Browser: https://browser.portolan-sdi.org/#/external/data.source.coop/cholmes/gur-shadow-fleet/masters/collection.json
## Columns
- `name` (varchar) — Ship master's full name
- `dob` (varchar) — Date of birth of the ship master
- `tin` (varchar) — Tax identification number
- `citizenship` (varchar) — Citizenship of the ship master
- `vessel_name` (varchar) — Name of the vessel
- `vessel_gur_id` (varchar) — GUR ID of the vessel
- `source_url` (varchar) — URL of the GUR source page for this master
- `vessel_imo` (varchar) — IMO number of the vessel the master commands
## Query (DuckDB)
```sql
INSTALL spatial; LOAD spatial;
-- Masters grouped by citizenship
SELECT citizenship, count(*) AS masters
FROM read_parquet('https://data.source.coop/cholmes/gur-shadow-fleet/masters/masters.parquet')
GROUP BY citizenship
ORDER BY masters DESC;
```
Rights: © GUR, War & Sanctions portal — no open license asserted (see ../RIGHTS.md).