Project Quincy is a Django application with a MySQL database that uses information about people, places, and organizations to trace how social networks and institutions develop over time and through space. It is named in honor of John Quincy Adams (1767-1848).
Along with the migrations to create the database, I will also be releasing loading scripts and methods for exporting data keyed to various data visualizations.
If you become curious about this strange historian/ programmer who loves John Quincy Adams (a.k.a. me) feel free to check out my website at www.jeanbauer.com.
Project Quincy is being created by a historian for historians (or at least those interested in the long ago and conceivably far, far away). The database exists to connect people with other people at a particular time, in a particular place, and for a particular reason, allowing the user to map networks of correspondence, the growth (or decay) of organizations, kinship, patronage, and early institutional development.
Project Quincy has six (more or less) interconnecting modules, each to track a different type of information/network: biography (profession, personal relationships, and residences), organizations (membership and organization history), correspondence (letters), assignments (connecting a person, a job, and a place for a specific period of time), locations, and citations.
Project Quincy comes out of three digital humanities projects I have worked on at the University of Virginia.
In the summer of 2007 I was hired by the Dolley Madison Digital Edition to do something with the over 100 extant invitations sent or received by Dolley Madison during her widowhood years in Washington, D.C. Individually the invitations weren't that exciting, but connected in a relational data structure they could reveal the social elite of Washington, D.C. in the 1830s and 1840s.
As I mapped out the relationships between people, places, and organizations I realized that a similar database could be very useful in my dissertation on the early history of the U.S. Foreign Service. While I was beginning to design the The Early American Foreign Service Database, I was hired to design another database for Documents Compass's People of the Founding Era: A Prosopographical Approach. Delving into all the ways a person can interact with their world deepened my designs for the Dolley Madison Social Events Database and the Early American Foreign Service Database.
At some point I realized that I wasn't designing three separate databases, but rather one generalizable and extensible database that could be modified to fit a wide range of subjects. Project Quincy was born.
Project Quincy began life as a Ruby on Rails project, but like all applications, the code base aged. Then I was hired by the Brown University Library, which is django shop. So I have ported Project Quincy to Django. The Rails code is still available, but is no longer being maintained.
I blogged part of the port from Rails to Django, which you can read about in my blog posts Tales from the Port.
Why, you might ask, is this project named in honor of John Quincy Adams?
The short answer is: I'm a diplomatic historian.
The somewhat longer answer is: As I began designing the Early American Foreign Service Database, John Quincy Adams kept popping up all over the place -- translator for Francis Dana's mission to Russia, Minister to the Netherlands, Minister to Prussia, Minister to Russia, Head Negotiator for the Treaty of Ghent (ended the War of 1812), Minister to Great Britain, Secretary of State, not to mention all the letters sent and received, plus his time in the Senate, as President, and in Congress. An extremely organized and methodical man, I think Adams would have loved databases . . . provided you could keep him from dissecting the computer to figure out why the screen glowed.
The really long answer is: my dissertation.
The Early American Foreign Service Database runs on Project Quincy.
I have not officially released any files for the project, but the code is on github:
If you want to download the project,
let me know.
Download the Annotated Diagrams.
To see my blog posts about database design click here.
Project Quincy began during my time as a Digital Humanities Fellow in the University of Virginia Library's Digital Scholars' Lab. I particularly want to thank
for their help and encouragement.
The port was written in the Brown University Library, and would not have been possible without the help of