All Transactions

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.

51 rows where lemay_index = "E0051"

✎ View and edit SQL

This data as json, CSV (advanced)

Filter the results by: full_name, transaction_type, activity, controlled_description, narrow_description, pounds, shillings, pence, line_total, post_location, post_weight, gazette_no, notes, transaction_entered_by, source, page_number, url, transcriber_notes, date (date)

Link rowid ▼
transaction_id 
date 
lemay_index 
full_name 
place 
occupation 
transaction_type 
activity 
controlled_description 
narrow_description 
pounds 
shillings 
pence 
line_total 
post_location 
post_weight 
gazette_no 
notes 
gender 
transaction_entered_by 
source 
page_number 
url 
transcriber_notes 
3072 3072 TNinSB-1103 1737-05-02 Mr Robert Ellis E0051 Robert Ellis     Dr 1 Long Daybook Blanks and Print Jobs Day Book 1 6   1.6.0       M B Shop Book 51 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-54  
3073 3073 TNinSB-1104 1737-05-02 Mr Robert Ellis E0051 Robert Ellis     Dr 1 [Long Daybook] Blanks and Print Jobs Day Book   19 6 0.19.6     Do M B Shop Book 51 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-54  
3074 3074 TNinSB-1105 1737-05-02 Mr Robert Ellis E0051 Robert Ellis     Dr 1 Folio not rul'd Blanks and Print Jobs Folio 1 7 6 1.7.6       M B Shop Book 51 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-54  
3075 3075 TNinSB-1106 1737-05-02 Mr Robert Ellis E0051 Robert Ellis     Dr 1 large Ledger Blanks and Print Jobs Ledger 2     2.0.0       M B Shop Book 51 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-54  
3076 3076 TNinSB-1107 1737-05-02 Mr Robert Ellis E0051 Robert Ellis     Dr 1 [large Ledger] Blanks and Print Jobs Ledger 2     2.0.0     Do/7.13.0 M B Shop Book 51 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-54  
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  
3117 3117 TNinSB-1147 1737-05-09 Mr Robert Ellis E0051 Robert Ellis     Dr Books del'd this Day viz: 1 long Day book demi rul'd 4 qr Books and Pamphlets Unspecified 1 6   1.6.0       M B Shop Book 53 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-56  
3118 3118 TNinSB-1148 1737-05-09 Mr Robert Ellis E0051 Robert Ellis     Dr Books del'd this Day viz: 1 [long Day book demi rul'd 4 qr] Books and Pamphlets Unspecified 1 6   1.6.0     Do M B Shop Book 53 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-56  
3119 3119 TNinSB-1149 1737-05-09 Mr Robert Ellis E0051 Robert Ellis     Dr Books del'd this Day viz: 1 [long Day book demi rul'd 4 qr] Books and Pamphlets Unspecified 1 6   1.6.0     Ditto M B Shop Book 53 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-56  
3120 3120 TNinSB-1150 1737-05-09 Mr Robert Ellis E0051 Robert Ellis     Dr Books del'd this Day viz: 1 [long Day book demi rul'd 4 qr] Books and Pamphlets Unspecified 1 6   1.6.0     Ditto M B Shop Book 53 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-56  
3121 3121 TNinSB-1151 1737-05-09 Mr Robert Ellis E0051 Robert Ellis     Dr 5 Folio not rul'd 5 quire Blanks and Print Jobs Blank Book 1 7 6 1.7.6     £6.11.6 M B Shop Book 53 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-56  
3683 3683 TNinSB-1688 1737-09-01 Mr Robert Ellis E0051 Robt Ellis     Cr 2 Pistoles Currency Pistoles 2 16   2.16.0       M B Shop Book 77 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-80  
5904 5904 TNinSB-3787 1739-03-21 Mr Robert Ellis E0051 Robt Ellis     Cr Cash in full Cash   3 6   3.6.0       M B Shop Book 157 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A266513-160  
9640 9640 TNinLD-3031 1741-12-08 Mr Robert Ellis E0051 Mr Robert Ellis     Dr 2 lb Lampblack Ink Lampblack   10   0.10.0       M   Ledger D 155 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155  
9641 9641 TNinLD-3032 1743-07-18 Mr Robert Ellis E0051 Mr Robert Ellis     Dr Ship Letters Postal Transaction Letter     4 0.0.4       M   Ledger D 155 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155  
9642 9642 TNinLD-3033 1738-05-18 Mr Robert Ellis E0051 Mr Robert Ellis     Dr Advt of Negroes Gaz N 492 Advertisement Gazette   5   0.5.0   492 from Work Book M   Ledger D 155 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155  
9643 9643 TNinLD-3034 1738-10-12 Mr Robert Ellis E0051 Mr Robert Ellis     Dr Advt of Stray N 513 Advertisement Gazette   5   0.5.0   513 from Work Book M   Ledger D 155 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155  
9644 9644 TNinLD-3035 1740-09-04 Mr Robert Ellis E0051 Mr Robert Ellis     Dr Advt in Gaz of Negroes for Sale Advertisement Gazette   5   0.5.0     from Work Book M   Ledger D 155 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155  
9645 9645 TNinLD-3036 1743-07-04 Mr Robert Ellis E0051 Mr Robert Ellis     Dr Advt of Snow Cape Fear Advertisement     5   0.5.0     from Work Book M   Ledger D 155 https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155  
17245 17245 TNinPOB11b-1209 1742-10-21 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 7 0.1.7     brot ?? 8:1:11 M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17246 17246 TNinPOB11b-1210 1742-03-12 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 7 0.1.7       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17247 17247 TNinPOB11b-1211 1743-04-13 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 6 2 0.6.2       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17248 17248 TNinPOB11b-1212 1743-04-20 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 1 0.2.1       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17249 17249 TNinPOB11b-1213 1743-04-27 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 3 3 0.3.3       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17250 17250 TNinPOB11b-1214 1743-08-17 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 6 2 0.6.2       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17251 17251 TNinPOB11b-1215 1743-08-22 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 1 0.2.1       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17252 17252 TNinPOB11b-1216 1743-09-08 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 3 3 0.3.3       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17253 17253 TNinPOB11b-1217 1743-09-29 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 6 0.2.6       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17254 17254 TNinPOB11b-1218 1743-10-26 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 3 0.1.3       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17255 17255 TNinPOB11b-1219 1743-10-02 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 1 0.2.1     ?? 9:15:6 M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17256 17256 TNinPOB11b-1220 1744-04-18 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 7 0.1.7       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17257 17257 TNinPOB11b-1221 1744-04-18 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 10 0.2.10       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17258 17258 TNinPOB11b-1222 1745-04-24 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 3 0.1.3       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17259 17259 TNinPOB11b-1223 1745-05-01 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 5 0 0.5.0       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17260 17260 TNinPOB11b-1224 1745-06-05 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 3 3 0.3.3       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17261 17261 TNinPOB11b-1225 1745-06-05 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 3 3 0.3.3     Omitd. Apr. 11 45 M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17262 17262 TNinPOB11b-1226 1745-12-21 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 7 0.1.7       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17263 17263 TNinPOB11b-1227 1745-12-21 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 7 0.1.7       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17264 17264 TNinPOB11b-1228 1746-01-04 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 5 4 0.5.4       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17265 17265 TNinPOB11b-1229 1746-02-14 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 7 0.1.7       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17266 17266 TNinPOB11b-1230 1746-08-27 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 11 0.2.11       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17267 17267 TNinPOB11b-1231 1746-12-26 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 2 11 0.2.11       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17268 17268 TNinPOB11b-1232 1747-06-16 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 3 4 0.3.4       M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
17269 17269 TNinPOB11b-1233 1746-10-29 Mr Robert Ellis E0051 Robert Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 1 3 0.1.3     ?? 11.13.2 Carried to Ledger E M   Philadelphia [Post Office Ledger, No.2] 72 https://diglib-legacy.amphilsoc.org/islandora/object/postalbook1742072  
22985 22985 TNinPOB12-173 1748-05-18 Mr Robert Ellis E0051 Robt Ellis         Miscellaneous   11 13 2 11.13.2       M   Post Office Accounts, May 18, 1748 21 https://diglib-legacy.amphilsoc.org/islandora/object/bf-1748021  
26001 26001 TNinPOB08-2561 1748-11-23 Mr Robert Ellis E0051 Robt. Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 3 3 0.3.3 Boston 7:16     M   Post Office Book, 1748-1752 74 https://diglib-legacy.amphilsoc.org/islandora/object/franklin-postal-book-074  
27687 27687 TNinPOB08-4247 1749-06-14 Mr Robert Ellis E0051 Robt. Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 2 9 11 2.9.11 Boston 119.16     M   Post Office Book, 1748-1752 119 https://diglib-legacy.amphilsoc.org/islandora/object/franklin-postal-book-119  
29109 29109 TNinPOB08-5669 1749-10-26 Mr Robert Ellis E0051 Robt. Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 5 4 0.5.4 New York 12.16     M   Post Office Book, 1748-1752 153 https://diglib-legacy.amphilsoc.org/islandora/object/franklin-postal-book-153  
29393 29393 TNinPOB08-5953 1749-11-15 Mr Robert Ellis E0051 Robt. Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 4 1 0.4.1 New York 9:16     M   Post Office Book, 1748-1752 159 https://diglib-legacy.amphilsoc.org/islandora/object/franklin-postal-book-159  
29394 29394 TNinPOB08-5954 1749-11-15 Mr Robert Ellis E0051 Robt. Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 4 1 0.4.1 New York 9:16   Do. M   Post Office Book, 1748-1752 159 https://diglib-legacy.amphilsoc.org/islandora/object/franklin-postal-book-159  
29562 29562 TNinPOB08-6122   Mr Robert Ellis E0051 Robt. Ellis     Incoming Post Charge   Postal Transaction Incoming Post Charge 0 4 1 0.4.1 New York 9:16     M   Post Office Book, 1748-1752 163 https://diglib-legacy.amphilsoc.org/islandora/object/franklin-postal-book-163 Dated November 31 in ledger

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

About the American Philosophical Society

An eminent scholarly organization of international reputation, the American Philosophical Society promotes useful knowledge in the sciences and humanities through excellence in scholarly research, professional meetings, support of young scholars, publications, library resources, a museum, and community outreach.

American Philosophical Society | Site Version 1.0 | October 18, 2023.