names

40 rows where case_id = 2283081

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4758624 2283081 2283081 plaintiff (not given) Henry archbishop of Canterbury   Canterbury, Henry, archbishop of 0
4758625 2283081 2283081 plaintiff (not given) Henry bishop of Winchester   Winchester, Henry, bishop of 1
4758626 2283081 2283081 plaintiff (not given) Thomas bishop of Durham   Durham, Thomas, bishop of 2
4758627 2283081 2283081 plaintiff Exeter Thomas duke of   Exeter, Thomas, duke of 3
4758628 2283081 2283081 plaintiff Westmorland Ralph earl of   Westmorland, Ralph, earl of 4
4758629 2283081 2283081 plaintiff (illegible) Henry son of Hugh, knight   _, Henry, son of Hugh, knight 5
4758630 2283081 2283081 plaintiff Hungerford Walter knight   Hungerford, Walter, knight 6
4758631 2283081 2283081 plaintiff Wodehous John     Wodehous, John 7
4758632 2283081 2283081 plaintiff Leventhorp John     Leventhorp, John 8
4758633 2283081 2283081 defendant Mundeford Osbert esq   Mundeford, Osbert, esq 0
4758634 2283081 2283081 defendant Dumberell William clerk   Dumberell, William, clerk 1
4758635 2283081 2283081 defendant Eston John husbandman   Eston, John, husbandman 2
4758636 2283081 2283081 defendant Stalon Robert husbandman   Stalon, Robert, husbandman 3
4758637 2283081 2283081 defendant Stokes John laborer   Stokes, John, laborer 4
4758638 2283081 2283081 defendant Troys John son of Reginald, laborer   Troys, John, son of Reginald, laborer 5
4758639 2283081 2283081 defendant Troys Thomas laborer   Troys, Thomas, laborer 6
4758640 2283081 2283081 defendant Ward William weaver   Ward, William, weaver 7
4758641 2283081 2283081 defendant Sumpter John laborer   Sumpter, John, laborer 8
4758642 2283081 2283081 defendant Sumpter Reginald laborer   Sumpter, Reginald, laborer 9
4758643 2283081 2283081 defendant Thaxster Geoffrey fletcher 590357 590357 Thaxster, Geoffrey, of Wilton, fletcher 10
4758644 2283081 2283081 defendant Turnour William turner 590357 590357 Turnour, William, of Wilton, turner 11
4758645 2283081 2283081 defendant Dykeman John laborer 590357 590357 Dykeman, John, of Wilton, laborer 12
4758646 2283081 2283081 defendant Dykeman Richard laborer 590357 590357 Dykeman, Richard, of Wilton, laborer 13
4758647 2283081 2283081 defendant Wynch Richard husbandman 591456 591456 Wynch, Richard, of Feltwell, husbandman 14
4758648 2283081 2283081 defendant Fynch Richard baker 797880 797880 Fynch, Richard, of Hokwell, baker 15
4758649 2283081 2283081 defendant Turnour John turner 590357 590357 Turnour, John, of Wilton, turner 16
4758650 2283081 2283081 defendant Turnour Richard laborer 590357 590357 Turnour, Richard, of Wilton, laborer 17
4758651 2283081 2283081 defendant Cok Richard butcher 590357 590357 Cok, Richard, of Wilton, butcher 18
4758652 2283081 2283081 defendant Grene Thomas laborer 598468 598468 Grene, Thomas, of Hokewold, laborer 19
4758653 2283081 2283081 defendant Stokes John laborer 590357 590357 Stokes, John, of Wilton, laborer 20
4758654 2283081 2283081 defendant Quylter John   590357 590357 Quylter, John, of Wilton, shepherd 21
4758655 2283081 2283081 defendant Scarlet John   586675 586675 Scarlet, John, of Brandon Ferry, scrivenor 22
4758656 2283081 2283081 defendant Ciffe William tailor 598468 598468 together with Ciffe, William, of Hokewold, tailor 23
4758657 2283081 2283081 defendant Pye Geoffrey dyer 597739 597739 Pye, Geoffrey, of Northwold, dyer 24
4758658 2283081 2283081 defendant Barker Simon   590306 590306 Barker, Simon, of Wetyng 25
4758659 2283081 2283081 defendant Pye John son of Geoffrey, of Northwold, dyer   Pye, John, son of Geoffrey, of Northwold, dyer 26
4758660 2283081 2283081 defendant Barker Simon tanner 590306 590306 Barker, Simon, of Wetyng, tanner 27
4758661 2283081 2283081 defendant Yonge John   590306 590306 Yonge, John, of Wetyng, shepherd 28
4758662 2283081 2283081 defendant Yonge Robert ploughman 797882 797882 Yonge, Robert, of Cranehous, ploughman 29
4758663 2283081 2283081 defendant Noteman Richard   653177 653177 Noteman, Richard, of Brandon Ferry 30

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);