I haven't mentioned my portfolio site here before, but I did manage to fix page view tracking on it today, so that's kind of nice. It was the final project for a class I took at City College San Francisco and highly recommend.
The Hedy Lamarr Mystery
I'm starting work on the mystery of Hedy Lamarr aboard the Normandy today. I've researched all the passengers aboard the ship, and Hedy Lamarr, whose name at birth was Hedwig Eva Maria Kiesler, is not listed as a passenger. There's a ham radio bent to this as well. Hedy invented and patented frequency hopping spread spectrum radio.
We know that she was a passenger based on several first hand accounts, including her own, that it was while on ship that she negotiated her hollywood deal with Louis B. Mayer. The lore has it that she was posing as the governess of Grisha Goluboff, a 14 year-old violin virtuoso from San Francisco at the suggestion of Goluboff's manager Isadore Nobel. Although, according to this article, we may not be able to find her because she didn't have a ticket at all.
The first step was to pull all the travel manifest data into a database. There were 1690 passengers on the ship, not counting the remaining crew pages I haven't analyzed yet. I didn't want to spend token assembling analysis results into a database, so I was careful to ask the agent I was working with in Gas Town to
- first create a schema for the database that we agreed on
- then read the column headings for every table on every manifest analysis page for this particular ship passage. The agents doing OCR and passenger investigations didn't have to stick to column names, so I asked for a json structure mapping varied column names to their corresponding solumn names in the db schema
- armed with this information, I asked the agent to write a pythong script to scan all 51 pages of findings and assemble the database.
I installed the llm agent plugin for datasette. I had a bit of a time figuring out the command line to pass in the model I wanted to use. What finally worked was
datasette --root normandie_1937_1688.db --plugins-dir=plugins -s plugins.datasette-llm.default_model gpt-5.5
I then, went to the address http://127.0.0.1:8001/-/agent/ to use the agent plugin with my newly created data.
Usage
Results
| Possible Hedy Lamarr aliases: single women age 16 - 31 |
Removing the single filter expands the pool of possible passengers and crew a little bit.
Comments
Post a Comment
Please leave your comments on this topic: