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.

23 rows where lemay_index = "S0295"

✎ View and edit SQL

This data as json, CSV (advanced)

Filter the results by: transaction_id, date, full_name, activity, controlled_description, narrow_description, pounds, shillings, pence, line_total, notes, page_number, url, 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 
844 844 TNinLAB-794 1732-08-16 Mrs Staples S0295 Mrs Staples     Dr Lent to Mrs Staples Cash   1     1.0.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
845 845 TNinLAB-795 1732-09-28 Mrs Staples S0295 Mrs Staples     Dr At another time Cash   1     1.0.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
846 846 TNinLAB-796 1732-11-19 Mrs Staples S0295 Mrs Staples     Dr At another time Cash     10   0.10.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
847 847 TNinLAB-797 1732-12-01 Mrs Staples S0295 Mrs Staples     Dr At another time Cash     10   0.10.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
848 848 TNinLAB-798 1732-12-01 Mrs Staples S0295 Mrs Staples     Dr for postage Postal Transaction Postage   3 1 0.3.1       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
849 849 TNinLAB-799 1732-12-01 Mrs Staples S0295 Mrs Staples     Dr 3/4 of a Cord of Hickery Tools and Raw Materials Hickory   15   0.15.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
850 850 TNinLAB-800 1732-12-23 Mrs Staples S0295 Mrs Staples     Dr At another Time carried by D Cash     5   0.5.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
851 851 TNinLAB-801 1733-01-01 Mrs Staples S0295 Mrs Staples     Dr At another time Cash     10   0.10.0       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
852 852 TNinLAB-802 1733-01-19 Mrs Staples S0295 Mrs Staples     Dr 1/2 Cord Hickery Tools and Raw Materials Hickory   9 6 0.9.6       F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
853 853 TNinLAB-803 1733-01-23 Mrs Staples S0295 Mrs Staples     Dr At another Time Cash     10   0.10.0     Total: 5.12.7 F B Ledger A 39 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-40  
910 910 TNinLAB-853 1733-02-15 Mrs Staples S0295 Mr[] Staples     Dr 3/4 Cord Oak Wood Tools and Raw Materials Oak               F B Ledger A 41 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-42  
911 911 TNinLAB-854 1733-02-15 Mrs Staples S0295 Mrs Staples     Dr Cash Cash     10   0.10.0       F B Ledger A 41 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-42  
959 959 TNinLAB-901 1733-03-21 Mrs Staples S0295 Mrs Staples     Dr Cash to pay [K]eith Cash   1     1.0.0       F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
960 960 TNinLAB-902 1733-03-21 Mrs Staples S0295 Mrs Staples     Dr Cash pd Porters for her Cash     7   0.7.0       F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
961 961 TNinLAB-903 1733-03-21 Mrs Staples S0295 Mrs Staples     Dr 1 Cord Wood Ash with Halling etc Tools and Raw Materials Ash   8 11 0.8.11       F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
962 962 TNinLAB-903 1733-03-21 Mrs Staples S0295 Mrs Staples     Dr   Services Porterage               F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
967 967 TNinLAB-908 1733-03-21 Mrs Staples S0295 Staples     Dr Cash pd Marshall Cash     10   0.10.0       F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
968 968 TNinLAB-909 1733-03-21 Mrs Staples S0295 Staples     Dr Cash pd Oliver Cash   2 12 9 2.12.9       F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
970 970 TNinLAB-911 1733-03-21 Mrs Staples S0295 Mrs Staples     Dr Lent … Cash by Debby Cash     10   0.10.0       F B Ledger A 43 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-44  
976 976 TNinLAB-916 1733-03-21 Mrs Staples S0295 Mrs Staples     Dr Wood Tools and Raw Materials Wood               F B Ledger A 44 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-45  
1135 1135 TNinLAB-1057 1733-11-20 Mrs Staples S0295 Mrs Staples     Dr Cash Cash     10   0.10.0       F B Ledger A 49 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-50  
1155 1155 TNinLAB-1076 1733-12-01 Mrs Staples S0295 Mrs Staples     Dr Cash Cash     15   0.15.0       F B Ledger A 50 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-51  
1208 1208 TNinLAB-1127 1734-02-06 Mrs Staples S0295 Mrs Staples     Dr Cash paid for Postage Cash     2 2 0.2.2       F B Ledger A 53 https://diglib-legacy.amphilsoc.org/islandora/object/text%3A252294-54  

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.