I was heading down the same path as well, mostly because I'm super interested in understanding all the RVA deeds
recording dates are pretty easy for optical character recognition to handle because they are always in the same format (mm/dd/yyyy) in one of two styles
electronic (DocuSign)
View attachment 499295
physically stamped (usually physically signed)
View attachment 499307
but the effective dates are all over the place!
m/d/yyyy (electronic)
View attachment 499300
month d, yyyy (electronic)
View attachment 499299
mm/dd/yyyy (hand-written)
View attachment 499301
m/d/yyyy (hand-written)
View attachment 499302
m/d/yy (hand-written)
View attachment 499304
mmm d, yyyy (hand-written)
View attachment 499303
month d, yyyy (hand-written)
View attachment 499306
I'm struggling a bit to capturing the effective dates (especially the hand-written ones) programmatically; it is still interesting so I'm going to work on a way to capture them but as all side projects do, it may take me a while
while not good for
DVC, it has been nice having two months with a low number of deeds recorded so that I can manually go through them for tidbits of info! I appreciate all the questions and analysis ideas folks pose, it's helps me think of other creative ways to look at the data; so merci!