all_transactions: 14762

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
14762	TNinLD-7868	1747-06-02	P0039	William Parks			Memo	Cash paid for Cask, cooperage, & Packing	Cash		2	13		2.13.0					M		Ledger D	385	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld385	Assumed to be Parks based on chronological entries of the pages this insert is between plus the purchases align with Parks' job/Entries seem to be a duplicate of other entries in the ledger. Chosen to be noted as a memo as they should not be used as they will warp debits and credits in Parks account