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.

36 rows where narrow_description contains "Sugar"

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.	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.
2275	2275	TNinSB-365	1736-05-17	Stephen Potts P0205	Stephen Potts			Dr	a pound of [Loues] Shuger	Food	Sugar		[2]		0.[2].0		M	D	Shop Book	24	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-27
2324	2324	TNinSB-412	1736-06-11	Mrs Biggins B0169	Mrs Biggins			Dr	1 £ Sugar	Food	Sugar		1	6	0.1.6		M	B	Shop Book	26	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-29
2325	2325	TNinSB-413	1736-06-11	Stephen Potts P0205	St Potts			Dr	1 lb Sugar	Food	Sugar		1	6	0.1.6		M	B	Shop Book	26	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-29
3320	3320	TNinSB-1348	1737-06-09	Mother Sarah Read R0046	Mother Read			Dr	6 lb Sugar	Food	Sugar		3				F	B	Shop Book	61	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-64
3349	3349	TNinSB-1375	1737-06-11	George Mifflin M0092	Gorge Mifflin			Memo	shuger	Food	Sugar	1	1		1.1.0		M	D	Shop Book	62	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-65
3659	3659	TNinSB-1666	1737-08-25	Stephen Potts P0205	Stephen Potts			Dr	[] pound of shuger att 6 pens a pound	Food	Sugar		6		0.6.0		M	D	Shop Book	76	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-79
3660	3660	TNinSB-1667	1737-08-26	Willam Dearing D0061	Willam Dearing			Cr	shuger	Food	Sugar	1	4		1.4.0		M	D	Shop Book	76	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-79
3676	3676	TNinSB-1681	1737-09-01	Honour Harman H0076	Hounour Harmon			Dr	shuger	Food	Sugar		3		0.3.0	Settled	M	D	Shop Book	76	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-79
3755	3755	TNinSB-1754	1737-09-14	Stephen Potts P0205	Stephen Potts			Dr	Shuger Louef and Corse	Food	Sugar		3	4	0.3.4		M	D	Shop Book	79	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-82
3767	3767	TNinSB-1766	1737-09-16	Stephen Potts P0205	Stephen Potts			Dr	6 pound of Shuger at 6 pense a pound	Food	Sugar		3		0.3.0		M	D	Shop Book	80	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-83
3798	3798	TNinSB-1796	1737-09-22	Stephen Potts 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
3818	3818	TNinSB-1816	1737-09-29	Stephen Potts P0205	Stephen Potts			Dr	Shuger	Food	Sugar			6	0.0.6		M	D	Shop Book	82	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-85
4688	4688	TNinSB-2639	1738-05-08	Stephen Potts P0205	Stephen Potts			Dr	Shuger and Holland	Food	Sugar		10		0.10.0		M	D	Shop Book	110	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-113
5397	5397	TNinSB-3306	1738-12-01	Mr Wilcox W0156	Wilcox			Dr	a Loaf of Sugar	Food	Sugar		7	2	0.7.2		M	B	Shop Book	136	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-139
5878	5878	TNinSB-3761	1739-03-17	James Hubard H0335	James Hubard			Cr	a Lofe of shuger 6 pound	Food	Sugar		7		0.7.0		M	D	Shop Book	156	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-159
6587	6587	TNinLD-150	1747-08-05	Sarah Read (Neighbor) R0052	Mrs Sarah Read			Dr	1 Barrel Sugar 2.1.1 tare 20 at 55 [Shillings] Part of another Barrel	Food	Sugar						F		Ledger D	48	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld048
7258	7258	TNinLD-787	1751-10-12	Cousin James Franklin F0157	Cousin James Franklin	Newport		Cr	2 Barrels Loaf Sugar	Food	Sugar	6	18	9	6.18.9		M		Ledger D	65	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld065
8620	8620	TNinLD-2071	1740-??-??	Mr John Crocker C0342	Jno Croker			Dr		Food	Sugar						M		Ledger D	117	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld117
9453	9453	TNinLD-2857	1747-11-28	Elliot Benger Esqr B0140	Eliot Benger			Dr	Barrel Loaf Sugar 87 lb & Cask 1/6	Food	Sugar	5	10	3	5.10.3		M		Ledger D	147	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld147
10922	10922	TNinLD-4230	1747-07-27	Capt. Thomas Lloyd L0178	Capt Thos Lloyd			Cr		Food	Sugar						M		Ledger D	210	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld210
11372	11372	TNinLD-4641	1742-10-05	Mr Beby B0097	Mr Beby	Barbadoes	Printer	Dr	a Barrel of Sugar	Food	Sugar						M		Ledger D	234	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld234
11529	11529	TNinLD-4793	1741-08-01	Mr Bennet B0128	Mr Bennet			Dr	6 lb of Sugar	Food	Sugar		2	6	0.2.6		M		Ledger D	239	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld239
11823	11823	TNinLD-5077	1756-07-??	Mr Jonathan Williams W0184	Mr Jonathan Williams			Cr		Food	Sugar						M		Ledger D	249	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld249
13237	13237	TNinLD-6413	1744-09-10	Joseph Grover G0194	Mr Jo Grover	Jntown Jamaica		Cr	his Acct of Sugars	Food	Sugar	5	3	9	5.3.9		M		Ledger D	310	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld310
13676	13676	TNinLD-6832	1751-05-??	Brother John Read R0040	John Read			Dr	Sugar to [Patty]	Food	Sugar	1	15	2.5	1.15.2 1/2	Do	M		Ledger D	327	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld327
13813	13813	TNinLD-6963	1743-01-29	Mr Bennet B0128	Mr Bennet			Dr	Sugar 6 lb	Food	Sugar		2	6	0.3.6		M		Ledger D	335	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld335
13817	13817	TNinLD-6967	1743-02-15	Mr Bennet B0128	Mr Bennet			Dr	Sugar	Food	Sugar		2	6	0.7.0		M		Ledger D	335	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld335
14814	14814	TNinLD-7916	1743-08-13	Capt Joseph Arthur A0120	Capt Joseph Arthur			Cr	Sugar	Food	Sugar	1	5		1.5.0		M		Ledger D	388	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld388
15157	15157	TNinLD-8247	1740-03-01	Robert Grace G0105	Mr Robert Grace			Dr	Loaf of D Refin'd Sugar	Food	Sugar		12	9	0.12.9		M		Ledger D	399	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld399
15418	15418	TNinLD-8486	1744-11-07	Robert Grace G0105	Mr Robt Grace			Dr	Hhd Sugr 1200 net at 7 [pence]	Food	Sugar	39	8	8	39.8.8		M		Ledger D	402	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld402
15544	15544	TNinLD-8594	1746-07-31	Robert Grace G0105	Mr Robert Grace			Dr	Sugar	Food	Sugar		15				M		Ledger D	403	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld403
15555	15555	TNinLD-8605	1746-12-15	Robert Grace G0105	Mr Robert Grace			Cr	Barrel Loaf Sugar	Food	Sugar						M		Ledger D	403	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld403
15891	15891	TNinLD-8920		Capt. John Phillips P0169	John Phillips	Barbadoes		Cr	Sugar per Capt Loyd	Food	Sugar						M		Ledger D	414	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld414
15894	15894	TNinLD-8923		Robert Grace G0105	Mr Robert Grace			Cr	a Barrel & 3 loaves of Sugar	Food	Sugar	7	11	8	7.11.8		M		Ledger D	414	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld414
15903	15903	TNinLD-8932	1748-04-16	Robert Grace G0105	Robt Grace			Cr	by Sugar	Food	Sugar						M		Ledger D	415	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld415
15961	15961	TNinLD-8987		Robert Grace G0105	R Grace			Memo		Food	Sugar						M		Ledger D	416	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld416

Advanced export

JSON shape: default, array, newline-delimited