Franklin Ledgers Database

Franklins' Philadelphia Ledgers Project

All Transactions

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

Detailed description of the database's data structure.

6 rows where narrow_description = "Rum"

Keyword Search:

Advanced Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid ▼	transaction_id Filter by this column Hide this column Unique identifier assigned to each transaction.	date Filter by this column Hide this column Transcription of the date of the transaction.	lemay_index Filter by this column Hide this column Unique identifier assigned to each person.	full_name Filter by this column Hide this column Transcription of the name as it appears in the transaction.	place Filter by this column Hide this column Transcription of any location that appears in the transaction.	occupation Filter by this column Hide this column Transcription of the occupational information that appears in the transaction.	transaction_type Filter by this column Hide this column A broad categorization of the transaction.	activity Filter by this column Hide this column Transcription of the ledger's record of the transaction.	controlled_description Filter by this column Hide this column Controlled vocabulary categorizing the type of transaction or goods exchanged.	narrow_description Filter by this column Hide this column Controlled vocabulary categorizing the specific goods and/or services exchanged.	pounds Filter by this column Hide this column Transcription of the pounds due.	shillings Filter by this column Hide this column Transcription of the shillings due.	pence Filter by this column Hide this column Transcription of the pence due.	line_total Filter by this column Hide this column The total number of pounds, shillings and pence due.	gender Filter by this column Hide this column Gender of the person appearing in the transaction, extrapolated from the person's name.	transaction_entered_by Filter by this column Hide this column Person who entered the transaction into the ledger: B for Benjamin Franklin, D for Deborah Franklin.	source Filter by this column Hide this column Manuscript volume in which the transaction appears	page_number Filter by this column Hide this column Digital page number on which the transaction appears.	url Filter by this column Hide this column Link to a digitization of the page on which the transaction appears.
3441	3441	TNinSB-1460	1737-06-25	Willam Dearing D0061	Willam Dearing			Cr	2 galons of Ruem	Food	Rum		10		0.10.0	M	D	Shop Book	67	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-70
10409	10409	TNinLD-3765	1742-07-29	Peter Baynton Esqr B0079	Peter Baynton Esqr			Dr	N Engld Rum etc	Food	Rum		5		0.5.0	M		Ledger D	187	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-lD0100
12646	12646	TNinLD-5855		Mr Daniel 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
15878	15878	TNinLD-8908	1745-05-02	Robert Grace G0105	Mr Robert Grace			Dr	a Tearie of Rum suppos'ed worth	Food	Rum	9	7	6	9.7.6	M		Ledger D	413	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld413
15947	15947	TNinLD-8975		Robert Grace G0105	R Grace			Dr	Tierce of Rum	Food	Rum	12			12.0.0	M		Ledger D	416	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld416
15960	15960	TNinLD-8987		Robert Grace G0105	R Grace			Memo	the Value of a Tierce of Rum, of a Barrell of Loaf Sugar & 3 Loaves, some Cambric, Charges in Richard's Action & Ground rents to be enquired with Also Journey to Boston Ex[] & Money borrow'd of RG also Paving Alley & Kitchn	Food	Rum					M		Ledger D	416	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld416

Advanced export

JSON shape: default, array, newline-delimited