The week

So after last week’s hard work sanitizing the list of 3954 harvested ascidian publications they are now in the database. Our database has changed as follows:

	Before	After	Change
Authors	3378	7655	4277
Publications	981	1907	926
References	3732	7265	3533
Referenced Authors	6849	18844	11995

So a rather productive week. Now to find and remove the duplicates!

Luckily I rediscovered the Soundex function in TSQL, its helping tremendously to highlight names and titles that sound the same but are spelt differently, i.e. a good candidate for a duplicate.