all_transactions: 12646

The "all_transactions" table provides a complete record of the six ledgers included in the database. Most general queries should begin here.

Data license: CC BY 4.0 · Data source: American Philosophical Society · About: A database for the Franklins' ledgers.

This data as json

rowid transaction_id date lemay_index full_name place occupation transaction_type activity controlled_description narrow_description pounds shillings pence line_total post_location post_weight gazette_no notes gender transaction_entered_by source page_number url transcriber_notes
12646 TNinLD-5855   D0007 Mr Daniel Jam Printer Cr a Puncheon of Rum, sold to EM for Cash, 94 Galls at 4/9 Food Rum 19 19 6 19.19.6         M   Ledger D 279 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld279  

About the American Philosophical Society

An eminent scholarly organization of international reputation, the American Philosophical Society promotes useful knowledge in the sciences and humanities through excellence in scholarly research, professional meetings, support of young scholars, publications, library resources, a museum, and community outreach.

American Philosophical Society | Site Version 1.0 | October 18, 2023.