Introducing the LongSwims Database
LongSwimsDB aims to compile a structured, accurate, and comprehensive history of the sport of marathon swimming.
From Capt. Webb's pioneering crossing, to the mind-blowing endurance feats of Sarah Thomas, to the blazing speed of the professional circuits, to the numerous local Masters 10K's popping up around the world -- the goal is for everything to be available in a consistent, quality-controlled format.
I linked the project from the main MSF homepage just over a year ago, after I'd finished importing the O7 swims. It has since grown to over 35,000 individual swims and nearly 200 "events" (sanctioned solo swims and organized races), plus dozens of independent routes that meet minimal documentation standards.
I haven't promoted it much because I'm still working out some kinks in the technology and wanted to feel confident in the validity, accuracy, and presentation of the data.
There is still much to be done, but I think it's good enough for general consumption at this point. Some of you have discovered it on your own, and a few event organizers have started using it to vet swimmers' backgrounds. Steve M is probably the most avid user, and has been using it to update/correct openwaterpedia profiles.
There are two primary "views" into the database:
- Profiles - which swims has a given swimmer done? - http://db.marathonswimmers.org/p
- Events - which swimmers have done a given event? - http://db.marathonswimmers.org/events
Swimmers and events are also searchable from the homepage.
I also recently launched an "Insights" portal - where I will be adding various analyses and graphs to understand the sport at a deeper level, and explore questions that could only be answered by a formally designed relational database (as opposed to wikis, or books, or even spreadsheets). One of my favorites so far is a simple graph of women's participation in the sport over the past 40 years.
The project is currently sponsored by New York Open Water, and thanks to Rondi, David, and Alex for their support.
Anyway, I'm putting this thread here as a landing spot for any questions or discussion about the project.
Enjoy, and thanks for the interest.