Marbling from the end papers of a fantastic book at the Library Company of Philadelphia
Greetings, gentle readers. I am thrilled to share the news that I’ve finished Phase 2.1! I’ve finally completed* aggregating all the map location data into one huge Excel workbook. Now I can pull it all together into a single worksheet and create some pivot tables to help me cross reference locations. I have also added all the rest of the maps into the Maps page here on the site, for anyone who’s interested in seeing them. Just as a note, the maps are cleared of duplicates, but do not yet represent verified holdings.
The next step is Phase 2.2, wherein I put all the data in a single sheet, create a massive pivot table, and break out the results by library/institution so I can see which institutions have what books and start planning the in-person gathering of bibliographic data, as well as the applications to fund the travel required to visit those collections. I’m not sure how long that portion of the project will take, but I think it should be considerably less than the previous phase if only due to the relative lack of data entry.
I also need, while this process continues, to start finalizing some decisions about the Heurist database I’m using. I’ve started working on importing some data and creating the structure and relations based on the data I have. I’m still very much in the mess-around stage of making the database — there are no permanent decisions in place yet. I’m happy with how things are shaping up, though.
Finally, as a few data points:
- The last title I put into the workbook was The History of Eliza.
- Since June’s update, i’ve entered 472 entries across four titles, including the most famous of Lennox’s works, The Female Quixote (which had 309 entries).
- 2612 records total at the end of Phase 2.1.
*I fully expect to find material that I’ve accidentally left out or overlooked. No process is perfect, after all.
Lennox Bibliography Project 