names

57 rows where place_id = 604686

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3658905 1913045 1913045 defendant Meare Robert husbandman 604686 604686 Meare, Robert, of Holbroke, husbandman 0
3671481 1917063 1917063 defendant Miller William laborer 604686 604686 Miller, William, of Holbroke, laborer 0
3689296 1922816 1922816 defendant Everard William clothmaker 604686 604686 Everard, William, of Holbroke, clothmaker 0
3690567 1923216 1923216 defendant Parcyvall Thomas clothmaker 604686 604686 Parcyvall, Thomas, of Holbroke, clothmaker 1
3690572 1923218 1923218 defendant Parcyvall Thomas clothmaker 604686 604686 Parcyvall, Thomas, of Holbroke, clothmaker 1
3712670 1930277 1930277 defendant FitzJames Nicholas gent 604686 604686 FitzJames, Nicholas, of Holbroke, gent 0
3713846 1930632 1930632 defendant Sargeant John waterman 604686 604686 Sargeant, John, of Holbroke, waterman 0
3734664 1937089 1937089 defendant Rolff William husbandman 604686 604686 Rolff, William, of Holbroke, husbandman 1
3734665 1937089 1937089 defendant Parsyvale Thomas husbandman 604686 604686 Parsyvale, Thomas, of Holbroke, husbandman 2
3734666 1937089 1937089 defendant Wryght William husbandman 604686 604686 Wryght, William, of Holbroke, husbandman 3
3734667 1937089 1937089 defendant Bolle William husbandman 604686 604686 Bolle, William, of Holbroke, husbandman 4
3751741 1942460 1942460 defendant Sargaunt Thomas husbandman 604686 604686 Sargaunt, Thomas, of Holbroke, husbandman 0
3756584 1944040 1944040 defendant Audeley Margaret widow 604686 604686 Audeley, Margaret, of Holbroke, widow 0
3814935 1962588 1962588 defendant Tevell Isabel widow 604686 604686 Tevell, Isabel, of Holbroke, widow 0
3814936 1962588 1962588 defendant Syms alias Percyvall Thomas yeoman 604686 604686 Syms alias Percyvall, Thomas, of Holbroke, yeoman 1
3833469 1968398 1968398 defendant Mannyng William husbandman 604686 604686 Mannyng, William, of Holbroke, husbandman 4
3833471 1968399 1968399 defendant Smyth Thomas yeoman 604686 604686 Smyth, Thomas, of Holbroke, yeoman 0
3833483 1968403 1968403 defendant Symmys alias Percivall Thomas yeoman 604686 604686 Symmys alias Percivall, Thomas, of Holbroke, yeoman 0
3867989 1979527 1979527 defendant Percyvall alias Syms Thomas yeoman 604686 604686 Percyvall alias Syms, Thomas, of Holbroke, yeoman 2
3879539 1983410 1983410 defendant Frances John husbandman 604686 604686 Frances, John, of Holbroke, husbandman 1
4114223 2065369 2065369 defendant Philippes Peter yeoman 604686 604686 Philippes, Peter, of Holbroke, yeoman 0
4193120 2093161 2093161 defendant Turnor John miller 604686 604686 Turnor, John, of Holbroke, miller 0
4327240 2139437 2139437 defendant Hadnam Richard singleman 604686 604686 Hadnam, Richard, of Holbroke, tailor, singleman 0
4458734 2187777 2187777 defendant Laund William de   604686 604686 Laund, William de, of Holbroke 0
4667481 2255552 2255552 defendant Hunte Walter husbandman 604686 604686 with Hunte, Walter, of Holbroke, husbandman 1
4750564 2280650 2280650 defendant Newecombe Robert husbandman 604686 604686 (Newecombe, Robert, of Holbroke, husbandman 4
4878162 2320122 2320122 defendant Newecombe Robert husbandman 604686 604686 Newecombe, Robert, of Holbroke, husbandman 0
4919643 2332648 2332648 defendant Ekyngton John belzetter or bell-founder 604686 604686 Ekyngton, John, of Holbroke, belzetter or bell-founder 1
4955920 2343737 2343737 defendant Stacy John husbandman 604686 604686 Stacy, John, of Holbroke, husbandman 1
5022457 2363469 2363469 defendant Cole John husbandman 604686 604686 Cole, John, of Holbroke, husbandman 2
5033156 2366580 2366580 defendant Neucombe Robert yeoman 604686 604686 Neucombe, Robert, of Holbroke, yeoman 4
5038465 2368142 2368142 defendant Markwale John husbandman 604686 604686 Markwale, John, of Holbroke, husbandman 1
5061270 2374955 2374955 defendant Lyne John husbandman 604686 604686 Lyne, John, of Holbroke, husbandman 0
5104611 2387784 2387784 defendant Turneboll William weaver 604686 604686 Turneboll, William, of Holbroke, weaver 2
5146416 2400084 2400084 defendant Valentyne John laborer 604686 604686 Valentyne, John, of Holbroke, laborer 2
5150348 2401232 2401232 defendant Mors Roger husbandman 604686 604686 Mors, Roger, of Holbroke, husbandman 0
5166592 2405948 2405948 defendant Valentyne John laborer 604686 604686 Valentyne, John, of Holbroke, laborer 2
5168914 2406637 2406637 defendant Mors Roger husbandman 604686 604686 Mors, Roger, of Holbroke, husbandman 0
5181457 2410316 2410316 defendant Valentyne John laborer 604686 604686 Valentyne, John, of Holbroke, laborer 2
5204668 2417110 2417110 defendant Mors Roger husbandman 604686 604686 Mors, Roger, of Holbroke, husbandman 0
5334986 2455533 2455533 defendant Wodehous Andrew husbandman 604686 604686 Wodehous, Andrew, of Holbroke, husbandman 0
5347987 2459512 2459512 defendant Martyn Thomas husbandman 604686 604686 Martyn, Thomas, of Holbroke, husbandman 0
5486216 2500765 2500765 defendant Fraunceys Ralph husbandman 604686 604686 Fraunceys, Ralph, of Holbroke, husbandman 1
5486217 2500765 2500765 defendant Fraunceys William laborer 604686 604686 Fraunceys, William, of Holbroke, laborer 2
5535241 2515551 2515551 defendant Egenton John husbandman 604686 604686 Egenton, John, of Holbroke, husbandman 0
5535244 2515552 2515552 defendant Egenton John husbandman 604686 604686 Egenton, John, of Holbroke, husbandman 0
5540632 2517195 2517195 defendant Pette Agnes widow 604686 604686 Pette, Agnes, of Holbroke, widow 0
5540634 2517196 2517196 defendant Pette Agnes widow 604686 604686 Pette, Agnes, of Holbroke, widow 0
5542460 2517766 2517766 defendant Johnson Thomas husbandman 604686 604686 Johnson, Thomas, of Holbroke, husbandman 1
5578625 2528386 2528386 defendant Egynton John husbandman 604686 604686 Egynton, John, of Holbroke, husbandman 4
5578626 2528386 2528386 defendant Egynton Thomas husbandman 604686 604686 Egynton, Thomas, of Holbroke, husbandman 5
5578627 2528386 2528386 defendant Egynton William husbandman 604686 604686 Egynton, William, of Holbroke, husbandman 6
5578628 2528386 2528386 defendant Flecher Oliver husbandman 604686 604686 Flecher, Oliver, of Holbroke, husbandman 7
5586966 2530950 2530950 defendant Halle John   604686 604686 Halle, John, of Holbroke, scythe grinder 2
5600001 2534881 2534881 defendant Calton Robert husbandman 604686 604686 Calton, Robert, of Holbroke, husbandman 2
5600063 2534904 2534904 defendant Calton Robert husbandman 604686 604686 Calton, Robert, of Holbroke, husbandman 0
5603677 2536018 2536018 defendant Tevell Thomas gent 604686 604686 Tevell, Thomas, of Holbroke, gent 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);