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.

26 rows where lemay_index = "L0054"

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.	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.	notes Filter by this column Hide this column Transcription of any other information in the transaction.	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.
894	894	TNinLAB-839	1733-02-06	Benjamin Lay L0054	Benjamin Lay	Dr	Paraphase on Sermons 500	Books and Pamphlets	Paraphase on Sermons	1			1.0.0		M	B	Ledger A	41	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-42
923	923	TNinLAB-866	1733-03-02	Benjamin Lay L0054	Benja Lay	Cr	Cash	Cash		1			1.0.0		M	B	Ledger A	42	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-43
1994	1994	TNinSB-114	1735-12-20	Benjamin Lay L0054	Bena Lay	Dr	a Bibell and 1 almanack	Bible				5	0.0.5		M	D	Shop Book	16	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-17
1995	1995	TNinSB-114	1735-12-20	Benjamin Lay L0054	Bena Lay	Dr		Almanack							M	D	Shop Book	16	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-17
2055	2055	TNinSB-165	1736-01-17	Benjamin Lay L0054	Benja Lay	Dr	a Barckley	Books and Pamphlets	Barclay's Apology		7		0.7.0		M	D	Shop Book	18	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-19
2143	2143	TNinSB-243	1736-03-07	Benjamin Lay L0054	Benja Lay	Dr	sum of [B]ivens Books but I don’t now hough many	Books and Pamphlets	Bevan						M	D	Shop Book	21	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-24
2197	2197	TNinSB-293	1736-04-08	Benjamin Lay L0054	Beja Lay	Dr	5 Barkleys Doz and half of Thomas Bevens 6 of Dickesons and one of RB	Books and Pamphlets	Barclay's Apology						M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2198	2198	TNinSB-293	1736-04-08	Benjamin Lay L0054	Beja Lay	Dr		Books and Pamphlets	Bevan						M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2199	2199	TNinSB-293	1736-04-08	Benjamin Lay L0054	Beja Lay	Dr		Books and Pamphlets	Dickinson's Vindication						M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2200	2200	TNinSB-293	1736-04-08	Benjamin Lay L0054	Beja Lay	Dr		Books and Pamphlets	RB						M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2969	2969	TNinSB-1010	1737-03-17	Benjamin Lay L0054	Benjamin Lay	Dr	2 Doz L[]ons	Miscellaneous			2		0.2.0	Lementashons	M	D	Shop Book	48	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-51
2973	2973	TNinSB-1013	1737-03-17	Benjamin Lay L0054	Benja Lay	Dr	8 Doz balits	Blanks and Print Jobs	Ballots		8		0.8.0		M	D	Shop Book	48	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-51
3778	3778	TNinSB-1777	1737-09-19	Benjamin Lay L0054	Benj Lay	Dr	for a Doz [Scins]	Materials for Book Binding	Skin			1	0.0.1		M	D	Shop Book	80	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-83
3784	3784	TNinSB-1782	1737-09-21	Benjamin Lay L0054	Benj Lay	Dr	a Charge	Blanks and Print Jobs	Charges			8	0.0.8		M	D	Shop Book	80	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-83
3792	3792	TNinSB-1790	1737-09-22	Benjamin Lay L0054	Benja Lay	Dr	Lementashons	Books and Pamphlets	Lamentations		1		0.1.0		M	D	Shop Book	81	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-84
4905	4905	TNinSB-2845	1738-07-15	Benjamin Lay L0054	Benja Lay	Dr	1 doz Prophacies	Books and Pamphlets	Prophecies		1		0.1.0		M	B	Shop Book	118	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-121
5294	5294	TNinSB-3211	1738-11-07	Benjamin Lay L0054	Benjamin Lay	Dr	a Barkleys Apolegy	Books and Pamphlets	Barclay's Apology		8	6	0.8.6		M	D	Shop Book	132	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-135
5646	5646	TNinSB-3541	1739-01-25	Benjamin Lay L0054	Benj Lay	Dr	5 Barkleys Apolegy	Books and Pamphlets	Barclay's Apology	2			2.0.0		M	D	Shop Book	146	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-149
8229	8229	TNinLD-1706	1739-09-29	Benjamin Lay L0054	Benja Lay	Dr	Bond	Blanks and Print Jobs	Bonds			4	0.0.4	Settled	M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8230	8230	TNinLD-1707	1743-03-29	Benjamin Lay L0054	Benja Lay	Dr	A Years News	Subscription	Gazette		10		0.10.0	Settled	M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8231	8231	TNinLD-1708	1739-08-06	Benjamin Lay L0054	Benja Lay	Dr	Art of Preaching, Joseph, & a Cheese	Books and Pamphlets	Art of Preaching					Settled	M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8232	8232	TNinLD-1708	1739-08-06	Benjamin Lay L0054	Benja Lay	Dr		Books and Pamphlets	Joseph						M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8233	8233	TNinLD-1708	1739-08-06	Benjamin Lay L0054	Benja Lay	Dr		Food	Cheese						M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8234	8234	TNinLD-1709	1740-08-06	Benjamin Lay L0054	Benja Lay	Dr	2 Doz Duseburys Sermons	Books and Pamphlets	Dewsbury's Sermons		6		0.6.0	Settled	M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8235	8235	TNinLD-1710	1740-10-11	Benjamin Lay L0054	Benja Lay	Dr	2 Doz Duseburys Sermons	Books and Pamphlets	Dewsbury's Sermons		6		0.6.0	Settled	M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100
8236	8236	TNinLD-1711	1743-03-29	Benjamin Lay L0054	Benja Lay	Dr	Gazette	Newspapers	Gazette		10		0.10.0	Settled	M		Ledger D	100	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld100

Advanced export

JSON shape: default, array, newline-delimited