Data schema, Phase 1

a brown corkboard littered with random photos, notes, and clippings held in place with colorful plastic pins, with red yarn strung between the pins connecting different articles. In the middle, a clipping says "seek for the truth."
Image by Freepik

When I was at ASECS 2024, I got a question after my presentation about how I was organizing my data. I was thinking he meant how I was setting everything up overall, for example what schema I was going to use, and I sort of only half answered him because I don’t entirely know what I’m doing for the overall project. I have realized, however, that I complicated the question far more than it required. I also realized that wasn’t something I’d talked about here, and it likely should have been. I feel very strongly that transparency in what and how and why is important — a belief that was strengthened after a really strong presentation from the great scholars behind the Women’s Print History Project about the need for DH documentation that discusses the “why” as well as the “how.”

As I’ve mentioned before, this is a project with multiple phases. Phase One involved using OCLC Worldcat and the ESTC to locate individual copies and possibly previously missed or spurious publication information. I started with the excellent list of Lennox publications in Charlotte Lennox: An Independent Mind by Susan Carlile, which gave me a huge headstart. That’s where the maps on this site came from — an early effort to identify locations and see where clusters of copies might have been located. The limitations of Google Maps, though, specifically in the number of points per map, made this of limited usefulness. I may yet go back and try to dump all of it into something like Tableau and get a master map, but I haven’t yet. Probably not until I’ve finished cleaning up the data set.

There was then an interim stage I consider Phase 1.5, in which I took the data out of Google Maps and put it into an Excel spreadsheet. The data as it stood was in the following categories:

  • ID #: this helped differentiate records so I could move them into a relational database eventually
  • Longitude: location info courtesy Google Maps
  • Latitude: location info courtesy Google Maps
  • Library Name: the name of the library with the holdings (preferably not just the special collections dept)
  • Description: intended to describe something about the book, such as edition # or suspected piracy, not the library
  • Affiliation: what institution is the library affiliated with, if any
  • Designation:(what sort of library/institution is it — this is the muddiest category because sometimes it refers to the library (unaffiliated) and sometimes to the institution (affiliated)
  • Pub Year: publication year
  • Location: where was the book published
  • Bookseller: who was the bookseller/publisher
  • Title: Title of the book/periodical

Now, as to why I chose to keep track of all this stuff, particularly about the institutions, part of it was because I thought it would be interesting to track this and see how the spread went. Part of it was because I thought it would help me track down funding to visit collections. And the last part of it, I think, is because I didn’t want to go back and add it in later in case I regretted not having it to begin with. It’s easier to cut info than to go back and add it in across all the records.

I’ve held to that philosophy as I’ve gone — I’d rather get all the information plus some and end up with something unnecessary than I would want to record less than I’d end up wanting. There is absolutely a point of diminishing returns, here, naturally, but it’s balanced by the realization that, for most of these copies, I will get only one bite at the apple. If I miss something or realize later what I needed, I may be able to get it by asking the librarians, but I likely won’t get a second visit to see it for myself. This is one reason that my local copies are my test cases, to ensure what information I’m recording and why before I start trying to build my photo album of all the special collections rooms I get to visit.

I hope this proves helpful to someone — I’m happy to provide more information or answer questions as needed. I’ll move toward describing Phase Two in an upcoming post.

State of the Project, March 2024

two puppies with party hats on in front of a tiny stuffed toy birthday cake
Photo by Sam Lion on Pexels.com

Greetings, Gentle Readers! Welcome to the Lennox Bibliography Project website’s second birthday! *blows noisemaker* I’m thrilled and amazed that I’m still working on this and that I’ve actually made progress, albeit more slowly than I would have liked. Still moving forward, though.

Again, this month has seen a ton of grading and not much in the way of progress. What it has also seen, however, is me prepping my presentation for the upcoming ASECS 2024 conference! Starting later next week (eep) I will be in Toronto, ON with a bunch of other 18th-century scholars and doing my part to further the (small-d) discourse in our field. For those in attendance who might be interested, I’ll be presenting on some of my findings thus far from the LBP.

Specifically, I’m on panel #112, Friday April 5th, from 4:30-6:00pm in the Elgin room. It’s the second of two panels from the Bibliographical Society of America, titled “Bibliography by the Numbers: Meta-Bibliography and the Study of Eighteenth-Century Book Culture.” My paper is titled (not terribly creatively) “The Travels of the Memoirs of the Duke of Sully.” Belatedly I realized I should have named it “So Many Copies: Charlotte Lennox and the Duke of Sully” but alas, inspiration came far too late. Feel free to stop by!

State of the Project, May 2023

red tulips next to a stone against a field of brown mulch

Tulips from my garden before the deer ate them.

Here it is, the middle of May already. Where is the April post, you may ask? Well, the April post sadly went the way of the rest of my month of April, swallowed whole by the end of the semester and grading. I got nothing done on the project to speak of in April, though I did find my way into some interesting discoveries.

At the beginning of April/end of March, I attended the ASECS (American Society for Eighteenth Century Studies) annual conference, this year held in St. Louis. While I was there I went to a fantastic panel (okay, many fantastic panels) but this one in particular discussed a very interesting potential path forward for the Lennox project. This panel included a paper by Norbert Schürer (CSULB), who was discussing a digital humanities project being created using the Heurist platform — a customizable relational database system that was designed for Humanities research. The platform is free to use, hosted by the University of Sydney. It is based in MySQL, which means that it’s easy to export to somewhere else for hosting or other purposes, and it’s going to be simple to transfer to new homes and interfaces down the line. It can also generate a website interface and has mapping and network visualization capabilities.

No one else has, up to date, used the platform for a descriptive bibliography, so a lot of the relationships and information types I need for my project do not yet exist. Before I start putting in extensive book data, however, I want to take the information I do have and create a locational database that takes the map data sets I’ve created and pulls it together for more effective research planning. To that end, I’ve created a test database and been futzing around with it in my spare time, which has not been terribly plentiful over the past month but should ease up considerably over the summer.

I was torn for a time on how to proceed, as it might be less time consuming simply to switch over to inputting data into the database directly. I think I’ve decided, though, to continue putting entries into the spreadsheets for now while I try to figure out the structures I need in Heurist and build something useful. To that end, I’ve started inputting data again and am nearly done with the Marquis de Sully, which is a relief. I’ll keep you posted on how it all goes.

Current Data Category: Memoirs of the Duke de Sully translation
# of entries in this category to date: 953
# of entries in the worksheet so far: 1505 and counting

State of the Project, March 2023

My dog Noodle, basking in a sunbeam with his blanket.

Welcome back! It’s a bit past the middle of March, Spring has officially sprung for what it’s worth, and Noodle is back to enjoying his sunbeams and blanket in the mornings in our household library.

March saw me attending the annual American Society of Eighteenth Century Studies (ASCES) meeting, held this year in St. Louis, Missouri. The conference went really well, all things considered, and I was glad to have the chance to present a bit of my own work and hear about the awesome things others are doing. I attended a fantastic play reading by the Theater and Performance Caucus, went to a lot of great panels, and in particularly the Bibliographical Society of America panel left me with a LOT to think about.

Specifically, I’m reaching the point in my spreadsheet work that I’m thinking about where the work goes from here and what format is next. At that panel, at a talk by Norbert Schürer, I learned about Heurist, an open access relational database setup designed for humanities research, hosted and overseen at the University of Sydney. I’ve started poking at it since ASECS, and I’m both overwhelmed by and excited about the possibilities. I decided to keep bringing info into my spreadsheets for now as I can manipulate it and export it to the database, which will be faster than putting it all in by hand later (I’ll likely have to do a lot of editing of records and making links, but that’s still less work than inputting everything by hand again).

Progress proceeds apace on record data entry. I’m still working on the Marquis de Sully records, but I’m now onto Map 2 (!) and halfway done with it. Onward!

Current Data Category: Memoirs of the Duke de Sully translation
# of entries in this category to date: 720
# of entries in the worksheet so far: 1272 and counting

ASECS 2022 follow-up

As previously mentioned, I had the opportunity to talk about the project in a session at the American Society for Eighteenth Century Studies (ASECS) annual conference this past week. The panel was hosted by the Digital Humanities caucus, one of two back-to-back sessions titled “Centering Marginalized Voices in Digital Humanities Projects.” There were so many amazing projects discussed, and I was honored to be a part of it. The image to the right is the poster I presented, which I’m sharing here as well. You can also download this poster at the link below if you’re interested in getting a better look at it.

Among the many great projects discussed in that session, I’d like to give a shout out in particular to The Lady’s Museum Project, which is a digital version of Lennox’s periodical The Lady’s Museum. The editors behind this collaborative project to create the first ever critical edition of TLM are Karenza Sutton-Bennet and Kelly Plante, both of whom are brilliant, passionate scholars. I urge you to go take a look at their fantastic work.

Poster presented at ASECS 2022
giving a project overview

ASECS 2022!

I’ll be attending the American Society for Eighteenth-Century Studies annual conference, March 31-April 2 in Baltimore, MD. I’m very happy to be presenting on Saturday, April 2 at 2:00 pm. I’ll be talking about the project in the session, “Centering Marginalized Voices in DH Projects — Workshop.” I will be talking about my goals with this research as well as some of the grey areas and potential challenges involved, with the goal of perhaps getting a bit more clarity and direction on those points. I’ll also have a poster that I’ll be presenting as well for reference, which I’ll make available on this site following the conference. I hope to see you there!