names

67 rows where place_id = 615682

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3710190 1929502 1929502 defendant Newman Benedict yeoman 615682 615682 Newman, Benedict, of West Derham, yeoman 0
3861458 1977292 1977292 defendant Wade Robert yeoman 615682 615682 Wade, Robert, of West Derham, yeoman 0
4033786 2036733 2036733 defendant Nycholl Lewis gent 615682 615682 Nycholl, Lewis, of West Derham, gent 0
4033789 2036734 2036734 defendant Nycholl Lewis gent 615682 615682 Nycholl, Lewis, of West Derham, gent 0
4033790 2036734 2036734 defendant Barton Peter gent 615682 615682 Barton, Peter, of West Derham, gent 1
4054763 2044091 2044091 defendant Lane William husbandman 615682 615682 Lane, William, of West Derham, husbandman 0
4054764 2044091 2044091 defendant Sowthos John husbandman 615682 615682 Sowthos, John, of West Derham, husbandman 1
4054765 2044092 2044092 plaintiff Barton Peter gent 615682 615682 Barton, Peter, of West Derham, gent 0
4054767 2044092 2044092 defendant Waller Geoffrey butcher 615682 615682 Waller, Geoffrey, of West Derham, butcher 1
4057416 2045033 2045033 defendant Brytyff John husbandman 615682 615682 Brytyff, John, of West Derham, husbandman 0
4070688 2049814 2049814 defendant Thorowgood Thomas yeoman 615682 615682 Thorowgood, Thomas, of West Derham, yeoman 0
4070690 2049815 2049815 defendant Thurowgood Thomas yeoman 615682 615682 Thurowgood, Thomas, of West Derham, yeoman 0
4076417 2051861 2051861 defendant Forman John husbandman 615682 615682 Forman, John, of West Derham, husbandman 0
4079864 2053099 2053099 defendant Nicholl Lewis gent 615682 615682 Nicholl, Lewis, of West Derham, gent 4
4096247 2058985 2058985 defendant Nicoll Lewis gent 615682 615682 Nicoll, Lewis, of West Derham, gent 0
4184163 2089957 2089957 defendant Barton Peter gent 615682 615682 Barton, Peter, of West Derham, gent 0
4188225 2091384 2091384 defendant Sherbrooke Martin laborer 615682 615682 Sherbrooke, Martin, of West Derham, laborer 1
4188226 2091384 2091384 defendant Carter Thomas laborer 615682 615682 Carter, Thomas, of West Derham, laborer 2
4454592 2186455 2186455 defendant Muryell Geoffrey   615682 615682 Muryell, Geoffrey, of West Derham 0
4499780 2200563 2200563 defendant Bakere John   615682 615682 Bakere, John, of West Derham 1
4510475 2203738 2203738 plaintiff Barkere Thomas   615682 615682 Barkere, Thomas, of West Derham 0
4569500 2222046 2222046 defendant Wesynham Thomas   615682 615682 Wesynham, Thomas, of West Derham 1
4575395 2223818 2223818 defendant Plomer Roger   615682 615682 Plomer, Roger, of West Derham 0
4575396 2223818 2223818 defendant Smyth John   615682 615682 Smyth, John, of West Derham 1
4575397 2223818 2223818 defendant Baly John   615682 615682 Baly, John, of West Derham 2
4580107 2225267 2225267 defendant Webster Simon   615682 615682 Webster, Simon, of West Derham 0
4606756 2233228 2233228 plaintiff Barker Thomas   615682 615682 Barker, Thomas, of West Derham 0
4647184 2245228 2245228 defendant Bacon John   615682 615682 Bacon, John, of West Derham 1
4650131 2246057 2246057 defendant Clubbe Adam   615682 615682 Clubbe, Adam, of West Derham 0
4671800 2256826 2256826 defendant Seman William laborer 615682 615682 Seman, William, of West Derham, laborer 2
4701740 2265942 2265942 defendant Stank or Stauk John fishmonger 615682 615682 Stank or Stauk, John, of West Derham, fishmonger 0
4724957 2273099 2273099 defendant Bacon John yeoman 615682 615682 Bacon, John, of West Derham, yeoman 0
4733382 2275617 2275617 defendant atte Yate John husbandman 615682 615682 atte Yate, John, of West Derham, husbandman 1
4760177 2283532 2283532 defendant Lumbard James yeoman 615682 615682 Lumbard, James, of West Derham, yeoman 0
4761918 2284072 2284072 defendant Bakon John yeoman 615682 615682 Bakon, John, of West Derham, yeoman 0
4761919 2284072 2284072 defendant Bocher Nicholas yeoman 615682 615682 Bocher, Nicholas, of West Derham, yeoman 1
4827295 2304584 2304584 plaintiff Wygenhall alias Saresson John   615682 615682 Wygenhall alias Saresson, John, of West Derham, abbot 0
4827296 2304584 2304584 defendant Soukey or Sonkey Richard husbandman 615682 615682 Soukey or Sonkey, Richard, of West Derham, husbandman 0
4879196 2320430 2320430 defendant Massyngham John thatcher 615682 615682 Massyngham, John, of West Derham, thatcher 7
4889678 2323565 2323565 plaintiff Iweyn William   615682 615682 Iweyn, William, of West Derham 0
4981948 2351519 2351519 defendant Narburgh Richard husbandman 615682 615682 Narburgh, Richard, of West Derham, husbandman 0
5023750 2363851 2363851 plaintiff Hecham John   615682 615682 Hecham, John, of West Derham 0
5037874 2367956 2367956 defendant Maryet William   615682 615682 Maryet, William, of West Derham, servant 0
5074143 2378753 2378753 defendant Mathewe John husbandman 615682 615682 Mathewe, John, of West Derham, husbandman 2
5080452 2380642 2380642 defendant Denyell John husbandman 615682 615682 Denyell, John, of West Derham, husbandman 3
5137285 2397417 2397417 plaintiff Lynne John   615682 615682 (Lynne, John, of West Derham, abbot 1
5171889 2407493 2407493 plaintiff Lynn John   615682 615682 Lynn, John, of West Derham, abbot 0
5173685 2407998 2407998 plaintiff Lynne John   615682 615682 (Lynne, John, of West Derham, abbot 1
5180244 2409961 2409961 plaintiff Bowre Edward   615682 615682 Bowre, Edward, of West Derham 0
5194886 2414252 2414252 defendant Sparke Robert tanner 615682 615682 Sparke, Robert, of West Derham, tanner 0
5208992 2418361 2418361 defendant Sparke Robert tanner 615682 615682 Sparke, Robert, of West Derham, tanner 0
5246768 2429217 2429217 defendant Teryngton Roger husbandman 615682 615682 Teryngton, Roger, of West Derham, husbandman 0
5246769 2429217 2429217 defendant Cumplyn John husbandman 615682 615682 Cumplyn, John, of West Derham, husbandman 1
5325588 2452730 2452730 defendant Martyn John husbandman 615682 615682 Martyn, John, of West Derham, husbandman 1
5325768 2452786 2452786 defendant Martyn John husbandman 615682 615682 Martyn, John, of West Derham, husbandman 1
5326949 2453133 2453133 defendant Kyng John husbandman 615682 615682 Kyng, John, of West Derham, husbandman 2
5327792 2453383 2453383 defendant Wadylove William husbandman 615682 615682 Wadylove, William, of West Derham, husbandman 0
5328142 2453488 2453488 defendant Compleyn Simon yeoman 615682 615682 Compleyn, Simon, of West Derham, yeoman 0
5328144 2453489 2453489 defendant Cumpelyn Simon yeoman 615682 615682 Cumpelyn, Simon, of West Derham, yeoman 0
5373469 2467297 2467297 plaintiff Maxey William   615682 615682 Maxey, William, of West Derham, abbot of the Monastery of Blessed Mary 0
5373473 2467298 2467298 plaintiff Maxey William   615682 615682 Maxey, William, of West Derham, abbot of the Monastery of Blessed Mary 0
5403330 2476027 2476027 plaintiff Maxey William   615682 615682 Maxey, William, of West Derham, abbot of St Mary's 0
5465841 2494701 2494701 plaintiff Wysbeche John   615682 615682 Wysbeche, John, of West Derham, abbot of the monastery of the BM 0
5477069 2498146 2498146 defendant Shawe William yeoman 615682 615682 Shawe, William, of West Derham, yeoman 0
5555811 2521689 2521689 defendant Sherfurth Richard husbandman 615682 615682 Sherfurth, Richard, of West Derham, husbandman 0
5566342 2524749 2524749 defendant Mallam Richard gent 615682 615682 Mallam, Richard, of West Derham, gent 0
5572115 2526393 2526393 plaintiff Maylame Richard   615682 615682 Maylame, Richard, of West Derham 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);