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.

8 rows where lemay_index = "B0348"

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.	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.
90	90	TNinLAB-84	1730-09-18	George Brownell B0348	Geo Broitnell		Dr	200 Rides of Civility	Blanks and Print Jobs			16	8	0.16.8	M	B	Ledger A	12	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-13
177	177	TNinLAB-167	1730-12-09	George Brownell B0348	Geo Brownell		Cr	by Cash in Full	Cash		1	16	8	1.16.8	M	B	Ledger A	15	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-16
530	530	TNinLAB-496	1731-10-28	George Brownell B0348	Brownell		Dr	2 Doz Watts	Books and Pamphlets	Watts	3			3.0.0	M	B	Ledger A	28	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-29
2104	2104	TNinSB-210	1736-02-11	George Brownell B0348	Gorge Brownel		Dr	a psalm Book and the Binding a Book	Books and Pamphlets	Psalm Book		3	3	0.3.3	M	D	Shop Book	19	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-20
2105	2105	TNinSB-210	1736-02-11	George Brownell B0348	Gorge Brownel		Dr		Job	Binding					M	D	Shop Book	19	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-20
2203	2203	TNinSB-296	1736-04-09	George Brownell B0348	Buluck	the taner	Dr	a pound and half of Lamblack	Ink	Lampblack		7	6	0.7.6	M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2738	2738	TNinSB-798	1736-11-27	George Brownell B0348	Gorge Browning		Dr	a spelling Book	Books and Pamphlets	Spelling Book		1		0.1.0	M	D	Shop Book	41	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-44
3716	3716	TNinSB-1716	1737-09-06	George Brownell B0348	Gorge Brownell		Dr	a serment	Books and Pamphlets	Sermons		1		0.1.0	M	D	Shop Book	78	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-81

Advanced export

JSON shape: default, array, newline-delimited