names

18 rows where case_id = 2423301

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5226100 2423301 2423301 plaintiff Sotehill John     Sotehill, John 0
5226101 2423301 2423301 defendant Pudsey John   861428 861428 Pudsey, John, of Bolton Hall, knight 0
5226102 2423301 2423301 defendant Middope Christopher gent 861429 861429 Middope, Christopher, of Est Marton, gent 1
5226103 2423301 2423301 defendant Bulcok John yeoman 861429 861429 together with Bulcok, John, of Est Marton, yeoman 2
5226104 2423301 2423301 defendant Middope Margaret widow 861429 861429 Middope, Margaret, of Est Marton, widow 3
5226105 2423301 2423301 defendant Styrk Thomas husbandman 861429 861429 Styrk, Thomas, of Est Marton, husbandman 4
5226106 2423301 2423301 defendant Grene William, senior husbandman 797037 797037 Grene, William, senior, of West Marton, husbandman 5
5226107 2423301 2423301 defendant Grene Richard, junior husbandman 797037 797037 Grene, Richard, junior, of West Marton, husbandman 6
5226108 2423301 2423301 defendant Dudyll Henry husbandman 797037 797037 Dudyll, Henry, of West Marton, husbandman 7
5226109 2423301 2423301 defendant Michell Peter, junior yeoman 861430 861430 Michell, Peter, junior, of Coln, Lancs, yeoman 8
5226110 2423301 2423301 defendant Michell Richard, senior yeoman 759964 759964 Michell, Richard, senior, of Coln, yeoman 9
5226111 2423301 2423301 defendant Dikonson John yeoman 759964 759964 Dikonson, John, of Coln, yeoman 10
5226112 2423301 2423301 defendant Wilson John husbandman 759964 759964 Wilson, John, of Coln, husbandman 11
5226113 2423301 2423301 defendant Holgate Richard laborer 759964 759964 Holgate, Richard, of Coln, laborer 12
5226114 2423301 2423301 defendant Herteley James laborer 759964 759964 Herteley, James, of Coln, laborer 13
5226115 2423301 2423301 defendant Wilson John husbandman 861431 861431 Wilson, John, of Felryg, Lancs, husbandman 14
5226116 2423301 2423301 defendant Bulcok Richard shoemaker 759964 759964 Bulcok, Richard, of Coln, shoemaker 15
5226117 2423301 2423301 defendant Haughton Thomas gent 861432 861432 Haughton, Thomas, of Lathergram, Lancs, gent 16

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