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, February 2024

Surly groundhog staring out from his/her burrow.
Photo by Niklas Jeromin on Pexels.com

Welcome back, Readers! I have returned from my research “vacation,” for certain values of “returned” anyway. I am still teaching the overload situation this semester, but it’s going well and I feel like I’m mostly not drowning at this point. I am only now resuming work on the project, though. It’s been a good time to take a break and I feel much more able to bring my attention back to it in a positive and constructive way.

One of the things this break brought home to me is how I’ve basically worked on this non-stop for two years at least, prior to the beginning of this past holiday season. It’s so easy to get caught up in the work, particularly when it’s something that we’re interested in and want to see happen, that we can fall victim to our academic training of “never stop working” and forget that sometimes it’s good to let the fields like fallow for a bit.

I’m not saying that everyone is always in a situation where that’s feasible, or necessarily even desirable — we all have our own relationships to our work and research. One of the things I’m discovering on my own career journey, though, is the inexorability of erosion. Time, familiarity, training, and anxiety all wear away at our boundaries, our self-images, our work-life balance, and our storehouses of resolve and empathy. It takes active work to shore up those borders and keep ourselves whole and healthy. Much like the mansions on the hilltops in California now being undermined by landslides and erosion, with the ground beneath them slipping away into the ocean, we’re similarly at risk of being washed out and ground down to nothing. The world, your institution, your research, your students — none of them will tell you to stop when you’re already spread thin.

I know I’m not saying anything really new here. The thing that really hit me, though, is that although I do want to push forward and I’m excited about where this project is going to go, I don’t have a clock on this or a deadline I have to make. I don’t have to push for some external timeline that’s only in my head and sacrifice myself and my enthusiasm for this project in the process. Pacing myself — taking breaks — is a good thing. So for those following along in the background, I appreciate your patience and hope you bear with me during quieter times. I should have more progress to relate soon.