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 — Companies
One row per company (~1,500) that appears as a ship owner, commercial manager or safety manager of a shadow-fleet vessel — typically the single-vessel shell structures in jurisdictions like Hong Kong and the Seychelles that obscure beneficial ownership. Carries the company IMO id, name, country, the role(s) it plays and the vessels it is tied to. Non-spatial plain Parquet.
Format: Parquet · Rows: 1,518
Data: https://data.source.coop/cholmes/gur-shadow-fleet/companies/companies.parquet
Collection: https://data.source.coop/cholmes/gur-shadow-fleet/companies/collection.json
Browser: https://browser.portolan-sdi.org/#/external/data.source.coop/cholmes/gur-shadow-fleet/companies/collection.json
## Columns
- `company_imo` (varchar) — IMO company identifier
- `name` (varchar) — Company name
- `country` (varchar) — Country where the port / company is located
- `roles` (varchar) — Company roles: owner, manager, etc. (JSON array)
- `vessel_count` (bigint) — Number of vessels this company is linked to
- `vessel_imos` (varchar) — IMO numbers of the linked vessels (JSON array)
## Query (DuckDB)
```sql
INSTALL spatial; LOAD spatial;
-- Companies tied to the most vessels
SELECT name, country, roles, vessel_count
FROM read_parquet('https://data.source.coop/cholmes/gur-shadow-fleet/companies/companies.parquet')
ORDER BY vessel_count DESC
LIMIT 10;
```
Rights: © GUR, War & Sanctions portal — no open license asserted (see ../RIGHTS.md).