The data is mostly already there and publicly maintained. Ancestry/familysearch/etc should get us something interesting at least, data is a little bit light outside the us but someone would just need to go through it.
Comment on What is the longest discontinuous marriage?
neidu2@feddit.nl 7 months ago
That’s a really interesting question, but I’m having a hard time seeing how one can look this up without direct access to an SQL database of all married people. Can we pay off some government sysadmin?
BarbecueCowboy@kbin.social 7 months ago
neidu2@feddit.nl 7 months ago
This sounds like a job for a weird spaghetti code contraption consisting of selenium, perl, DBI, postgres, and shitloads of caffeine. I’ll give it a look tomorrow, hoping that the captcha I assume is there can be circumvented or automated one way or another.
I’m not really interested in the people, as I’m not from the US and am unlikely to be related to any of them. I’m just curious about the dataset itself, especially in relation to OPs question.
BarbecueCowboy@kbin.social 7 months ago
With ancestry, yeah, that's going to suck and it's the bigger database, but with familysearch, you've got an API:
https://www.familysearch.org/developers/docs/api/resources
Not sure what your limits are.
Blizzard@lemmy.zip 7 months ago
Now I’m even more interested to see the SQL query.
SkipWapPallyPap@lemmy.world 7 months ago
I’m in!