names

39 rows where case_id = 2283083

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4758681 2283083 2283083 plaintiff (not given) Henry archbishop of Canterbury   Canterbury, Henry, archbishop of 0
4758682 2283083 2283083 plaintiff (not given) Henry bishop of Winchester   Winchester, Henry, bishop of 1
4758683 2283083 2283083 plaintiff (not given) Thomas bishop of Durham   Durham, Thomas, bishop of 2
4758684 2283083 2283083 plaintiff Exeter Thomas duke of   Exeter, Thomas, duke of 3
4758685 2283083 2283083 plaintiff Westmorland Ralph earl of   Westmorland, Ralph, earl of 4
4758686 2283083 2283083 plaintiff Miles Henry son of Hugh, knight   Miles, Henry, son of Hugh, knight 5
4758687 2283083 2283083 plaintiff Hungreford Walter knight   Hungreford, Walter, knight 6
4758688 2283083 2283083 plaintiff Wodehouse John     Wodehouse, John 7
4758689 2283083 2283083 plaintiff Leventhorp John     Leventhorp, John 8
4758690 2283083 2283083 defendant Mundeford Osbert esq   Mundeford, Osbert, esq 0
4758691 2283083 2283083 defendant Dunberell William clerk   Dunberell, William, clerk 1
4758692 2283083 2283083 defendant Eston John husbandman   Eston, John, husbandman 2
4758693 2283083 2283083 defendant Stalon John or Robert husbandman   Stalon, John or Robert, husbandman 3
4758694 2283083 2283083 defendant Stokes John laborer   Stokes, John, laborer 4
4758695 2283083 2283083 defendant Cuffe William tailor   Cuffe, William, tailor 5
4758696 2283083 2283083 defendant Troys John son of Reginald, laborer   Troys, John, son of Reginald, laborer 6
4758697 2283083 2283083 defendant Troys Thomas laborer   Troys, Thomas, laborer 7
4758698 2283083 2283083 defendant Warde William weaver 590357 590357 Warde, William, of Wilton, weaver 8
4758699 2283083 2283083 defendant Sumpter John laborer 598468 598468 Sumpter, John, of Hokewold, laborer 9
4758700 2283083 2283083 defendant Sumpter Reginald laborer 598468 598468 Sumpter, Reginald, of Hokewold, laborer 10
4758701 2283083 2283083 defendant Thaxster Geoffrey   590357 590357 Thaxster, Geoffrey, of Wilton, arrow maker 11
4758702 2283083 2283083 defendant Tur_ William turner 590357 590357 Tur_, William, of Wilton, turner 12
4758703 2283083 2283083 defendant Dokeman John laborer 590357 590357 Dokeman, John, of Wilton, laborer 13
4758704 2283083 2283083 defendant Dykeman Richard laborer 590357 590357 Dykeman, Richard, of Wilton, laborer 14
4758705 2283083 2283083 defendant Wynch Richard husbandman 591456 591456 Wynch, Richard, of Feltwell, husbandman 15
4758706 2283083 2283083 defendant Pye Geoffrey dyer 797528 797528 Pye, Geoffrey, of North Wold, dyer 16
4758707 2283083 2283083 defendant Fyncen Richard baker 598468 598468 Fyncen, Richard, of Hokewold, baker 17
4758708 2283083 2283083 defendant Turnour John turner 590357 590357 Turnour, John, of Wilton, turner 18
4758709 2283083 2283083 defendant Turnour Richard laborer 590357 590357 Turnour, Richard, of Wilton, laborer 19
4758710 2283083 2283083 defendant Cok Richard butcher 590357 590357 Cok, Richard, of Wilton, butcher 20
4758711 2283083 2283083 defendant Grene Thomas laborer 598468 598468 Grene, Thomas, of Hokewold, laborer 21
4758712 2283083 2283083 defendant Stokes John laborer 590357 590357 Stokes, John, of Wilton, laborer 22
4758713 2283083 2283083 defendant Pye John son of Geoffrey, of North Wold, dyer   Pye, John, son of Geoffrey, of North Wold, dyer 23
4758714 2283083 2283083 defendant Barker Simon tanner 590306 590306 Barker, Simon, of Wetyng, tanner 24
4758715 2283083 2283083 defendant Quylter John   590357 590357 Quylter, John, of Wilton, shepherd 25
4758716 2283083 2283083 defendant Yong John   590306 590306 Yong, John, of Wetyng, shepherd 26
4758717 2283083 2283083 defendant Yonge Robert   797882 797882 Yonge, Robert, of Cranehous, plough man 27
4758718 2283083 2283083 defendant Scarlet Ivan   586675 586675 Scarlet, Ivan, of Brandon Ferry, scrivenor 28
4758719 2283083 2283083 defendant Noteman Richard yeoman 653177 653177 Noteman, Richard, of Brandon Ferry, yeoman 29

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