all_transactions: 3798

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
3798	TNinSB-1796	1737-09-22	P0205	Stephen Potts			Dr	Shuger	Food	Sugar		1	6	0.1.6					M	D	Shop Book	81	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-84