all_transactions: 8620

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
8620	TNinLD-2071	1740-??-??	C0342	Jno Croker			Dr		Food	Sugar									M		Ledger D	117	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld117