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 narrow_description contains "rice"

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.
2164	2164	TNinSB-262	1736-03-17	Stephen Potts P0205	Stephen Potts		Dr		Food	Rice					M	D	Shop Book	21	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-24
2165	2165	TNinSB-263	1736-03-17	Mrs Bennet (Parchment woman) B0143	Ms Benet		Dr	4 pound of Rise 9 pens	Food	Rice		1	9	0.1.9	F	D	Shop Book	21	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-24
2180	2180	TNinSB-277	1736-03-30	Mr Swen Warner W0051	Swan Wornor		Dr	a Doz pound of Rise	Food	Rice		3		0.3.0	M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2204	2204	TNinSB-297	1736-04-09	Mr John Crocker C0342	John Crocker		Dr	2 pound of rise	Food	Rice			6	0.0.6	M	D	Shop Book	22	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-25
2218	2218	TNinSB-309	1736-04-10	Mr Farrell F0018	Mr Farral		Dr	1 Doz of Rise	Food	Rice		3		0.3.0	M	D	Shop Book	23	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-26
2228	2228	TNinSB-319	1736-04-18	Mr John Crocker C0342	John Crocker		Dr	2 poun of rise	Food	Rice			6	0.0.6	M	D	Shop Book	23	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-26
2249	2249	TNinSB-340	1736-05-03	Mr Swen Warner W0051	Swan Wornor		Dr	1 Doz of Rise	Food	Rice		3		0.3.0	M	D	Shop Book	24	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-27
2252	2252	TNinSB-343	1736-05-03	William Davis D0032	Willam Davis	bookbinder	Dr	rise	Food	Rice			6	0.0.6	M	D	Shop Book	24	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-27
2277	2277	TNinSB-367	1736-05-17	William Davis D0032	Willam Davis		Dr	2 pound of rise	Food	Rice			6	0.0.6	M	D	Shop Book	24	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-27
2279	2279	TNinSB-369	1736-05-19	Ms Bennet B0127	Ms Benet		Dr	2 pound of rise	Food	Rice			9	0.0.9	F	D	Shop Book	24	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-27
2285	2285	TNinSB-375	1736-05-19	Mr John Crocker C0342	John Crocker		Dr	2 pound of rise	Food	Rice			6	0.0.6	M	D	Shop Book	25	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-28
3077	3077	TNinSB-1108	1737-05-02	Mr Robert Ellis E0051	Robert Ellis		Cr	1 Cask R[ice] wt 4.1.26 at 18 [shillings] per lb	Food	Rice	4		7.5	4.0.7 1/2	M	B	Shop Book	51	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-54
3110	3110	TNinSB-1141	1737-05-04	Stephen Potts P0205	Stephen Potts		Dr	7 pound and holef of Rise	Food	Rice					M	D	Shop Book	52	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-55
3111	3111	TNinSB-1142	1737-05-04	Mr John Crocker C0342	John Crocker		Dr	12 pound Rise	Food	Rice		2	6	0.2.6	M	D	Shop Book	52	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-55
3291	3291	TNinSB-1320	1737-06-02	Mr John Crocker C0342	John Crocker		Dr	6 pond Rise	Food	Rice		1	3	0.1.3	M	D	Shop Book	60	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-63
3376	3376	TNinSB-1400	1737-06-14	Mrs Ann Chandler C0099	Ann Chandler		Dr	1/2 [L] Rice	Food	Rice		8	9	0.8.9	F	B	Shop Book	64	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-67
3382	3382	TNinSB-1405	1737-06-15	Stephen Potts P0205	Stephen Potts		Dr	Rice	Food	Rice		9		0.9.0	M	B	Shop Book	64	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-67
3418	3418	TNinSB-1440	1737-06-23	Mr Wilcox W0156	Wilcox		Dr	56 lb Rice	Food	Rice		10		0.10.0	M	D	Shop Book	66	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-69
3433	3433	TNinSB-1452	1737-06-23	Mr Anthony Wilkinson W0163	Antony Willkisin		Dr		Food	Rice					M	D	Shop Book	66	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-69
3492	3492	TNinSB-1507	1737-07-08	Mrs Ann Chandler C0099	Ann Chand		Dr	Rise	Food	Rice		4	6	0.4.6	F	D	Shop Book	69	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-72
3505	3505	TNinSB-1520	1737-07-12	Mr Swen Warner W0051	Swan Worner		Dr	Rise	Food	Rice		1	3	0.1.3	M	D	Shop Book	69	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-72
3524	3524	TNinSB-1537	1737-07-15	Stephen Potts P0205	Stephen Potts		Dr	Rise	Food	Rice		1	3	0.1.3	M	D	Shop Book	70	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-73
3538	3538	TNinSB-1551	1737-07-21	Anthony Newhouse N0027	Antony New House		Memo	in Rise	Food	Rice		3		0.3.0	M	D	Shop Book	71	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-74
3562	3562	TNinSB-1573	1737-07-29	Honour Harman H0076	Honour Harman		Dr		Food	Rice					M	D	Shop Book	72	https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-75
8386	8386	TNinLD-1848	1740-01-29	Mr Joseph Scull S0048	Mr Joseph Scull		Cr	per 6 lb of Rice	Food	Rice		1	6	0.1.6	M		Ledger D	107	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld107
10454	10454	TNinLD-3807	1740-06-29	Thomas Wilcox W0155	Mr Thos Wilcox		Dr	Cask of Rice	Food	Rice	2	15	7	2.15.7	M		Ledger D	192	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld192
12404	12404	TNinLD-5627	1742-06-08	Brother John Read R0040	Brother Jno Read		Dr	1/2 lb Rice	Food	Rice		7		0.12.0	M		Ledger D	272	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld272
13780	13780	TNinLD-6931	1742-05-26	Mr Bennet B0128	Mr Bennet		Dr	Rice	Food	Rice		4	6		M		Ledger D	335	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld335

Advanced export

JSON shape: default, array, newline-delimited