names

16 rows where case_id = 2347896

✎ 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
4969729 2347896 2347896 plaintiff Gyffard Thomas     Gyffard, Thomas 0
4969730 2347896 2347896 defendant Oxenham Richard husbandman 592653 592653 Oxenham, Richard, of South Tauton, husbandman 0
4969731 2347896 2347896 defendant Wylman   John, of South Tauton, husbandman   Wylman, ,John, of South Tauton, husbandman 1
4969732 2347896 2347896 defendant Adescote Thomas husbandman 592653 592653 Adescote, Thomas, of South Tauton, husbandman 2
4969733 2347896 2347896 defendant Hole Richard husbandman 592653 592653 Hole, Richard, of South Tauton, husbandman 3
4969734 2347896 2347896 defendant Swaynston John husbandman 592653 592653 Swaynston, John, of South Tauton, husbandman 4
4969735 2347896 2347896 defendant Smyth William shoemaker 592653 592653 Smyth, William, of South Tauton, shoemaker 5
4969736 2347896 2347896 defendant Adam Robert husbandman 592653 592653 Adam, Robert, of South Tauton, husbandman 6
4969737 2347896 2347896 defendant Batteshill Richard husbandman 592653 592653 Batteshill, Richard, of South Tauton, husbandman 7
4969738 2347896 2347896 defendant Dyscombe Robert if Dyscombe, husbandman   Dyscombe, Robert, if Dyscombe, husbandman 8
4969739 2347896 2347896 defendant Batteshill John husbandman 601977 601977 Batteshill, John, of Westwyke, husbandman 9
4969740 2347896 2347896 defendant Blakemore John   592653 592653 Blakemore, John, of South Tauton, groom 10
4969741 2347896 2347896 defendant Taverner Robert husbandman 588673 588673 together with Taverner, Robert, of Sele, husbandman 11
4969742 2347896 2347896 defendant Taverner Hugh butcher 588673 588673 Taverner, Hugh, of Sele, butcher 12
4969743 2347896 2347896 defendant Taverner John soaper 588673 588673 Taverner, John, of Sele, soaper 13
4969744 2347896 2347896 defendant Taverner Richard yeoman 588673 588673 Taverner, Richard, of Sele, yeoman 14

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