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.

28 rows where lemay_index = "B0131"

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.	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.
947	947	TNinLAB-890	1733-03-20	Mr Anthony Benezet B0131	Anthony Benizet		Dr	1 Ream Paper	Paper	Unspecified		15		0.15.0		M	B	Ledger A	43	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44
4169	4169	TNinSB-2154	1737-12-19	Mr Anthony Benezet B0131	A Benezett		Dr	Wafers	Printing and Writing Equipment	Wafer			6	0.0.6		M	B	Shop Book	94	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-97
4696	4696	TNinSB-2646	1738-05-11	Mr Anthony Benezet B0131	Antony Benneset		Dr	a Bibel	Bible		1	4		1.4.0		M	D	Shop Book	111	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-114
5048	5048	TNinSB-2982	1738-08-26	Mr Anthony Benezet B0131	Antony Beneset		Dr	a Bond	Blanks and Print Jobs	Bonds			4	0.0.4		M	D	Shop Book	123	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-126
5067	5067	TNinSB-3001	1738-09-01	Mr Anthony Benezet B0131	Antoney Beneset		Dr	for the votes	Books and Pamphlets	Votes			4	0.0.4		M	D	Shop Book	124	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-127
5089	5089	TNinSB-3023	1738-09-08	Mr Anthony Benezet B0131	Antony Beneset		Dr	a Reem of paper	Paper	Unspecified		18		0.18.0		M	D	Shop Book	125	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-128
5118	5118	TNinSB-3049	1738-09-13	Mr Anthony Benezet B0131	Antony Beneset		Dr	the votes of the House and for the Life of Mr ped[]n	Books and Pamphlets	Votes		1	6	0.1.6		M	D	Shop Book	126	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-129
5380	5380	TNinSB-3291	1738-11-25	Mr Anthony Benezet B0131	Antony Penesett		Dr	almanack	Almanack				5	0.0.5		M	D	Shop Book	136	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-139
5570	5570	TNinSB-3467	1739-01-08	Mr Anthony Benezet B0131	Antony Beneset		Dr	a testament	Bible	Testament		3	6	0.3.6		M	D	Shop Book	143	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-146
5847	5847	TNinSB-3730	1739-03-09	Mr Anthony Benezet B0131	Antony Benneset		Dr	a Reem of writing paper	Paper	Writing		16		0.16.0		M	D	Shop Book	154	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-157
6168	6168	TNinSB-4034	1739-05-22	Mr Anthony Benezet B0131	The Schuelmaster	at the free schuel	Dr	2 Clark intreyduckshon	Books and Pamphlets	Clark's Introduction to Latin		10		0.10.0		M	D	Shop Book	167	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-170
7348	7348	TNinLD-874	1739-08-89	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Ream of brown Paper	Paper	Brown		6		0.6.0		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7349	7349	TNinLD-875	1742-12-16	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	a Book & Dividers Almanack	Books and Pamphlets	Unspecified		10	6	0.10.6		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7350	7350	TNinLD-875	1742-12-16	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr		Almanack							M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7351	7351	TNinLD-876	1742-12-16	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	a French Dictionary	Books and Pamphlets	French Dictionary		2	11	0.2.11		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7352	7352	TNinLD-877	1743-01-10	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Advertisement	Advertisement			19		0.19.0		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7353	7353	TNinLD-878	1743-07-04	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	The above Acct settled & paid	Account Management	Account Settlement						M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7354	7354	TNinLD-879	1744-01-19	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Dilworth's Arithmetick & Spelling Book	Books and Pamphlets	Dilworth's Arithmetic		6		0.6.0		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7355	7355	TNinLD-879	1744-01-19	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr		Books and Pamphlets	Dilworth's Spelling Book						M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7356	7356	TNinLD-880	1744-04-30	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Ream Paper	Paper	Unspecified	1	8		1.8.0		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7357	7357	TNinLD-881	1744-05-01	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Ream Paper	Paper	Unspecified	1	4		1.4.0		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7358	7358	TNinLD-882	1744-09-11	Mr Anthony Benezet B0131	Mr Anthony Benezet		Cr	By Cash and half the Paper retd in full	Cash		1	16	6			M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7359	7359	TNinLD-882	1744-09-11	Mr Anthony Benezet B0131	Mr Anthony Benezet		Cr		Paper	Unspecified						M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7360	7360	TNinLD-883	1745-09-20	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Books	Books and Pamphlets	Unspecified		106				M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7361	7361	TNinLD-884	1745-10-05	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Cyr Travl	Books and Pamphlets	Cyrus's Travels		10		5.16.0		M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7362	7362	TNinLD-885	1745-10-06	Mr Anthony Benezet B0131	Mr Anthony Benezet		Cr	Cash	Cash		5	16				M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
7363	7363	TNinLD-886	1743-01-13	Mr Anthony Benezet B0131	Mr Anthony Benezet		Dr	Advt of Tanyard Germantown	Advertisement				5	0.0.5	Omitted	M		Ledger D	68	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld068
16577	16577	TNinPOB11b-541	1748-04-13	Mr Anthony Benezet B0131	Anty. Benezet		Incoming Post Charge		Postal Transaction	Incoming Post Charge	0	1	7	0.1.7	See Stevn. Ant.	M		Philadelphia [Post Office Ledger, No.2]	27	https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742027

Advanced export

JSON shape: default, array, newline-delimited