names

17 rows where case_id = 1986176

✎ 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
3887790 1986176 1986176 plaintiff Curtys Richard     Curtys, Richard 0
3887791 1986176 1986176 defendant Helyer William potter 599869 599869 Helyer, William, of Lostwythyell, potter 0
3887792 1986176 1986176 defendant Tonkyn Ralph mercer 599869 599869 Tonkyn, Ralph, of Lostwythyell, mercer 1
3887793 1986176 1986176 defendant Cripps Thomas tailor 599869 599869 Cripps, Thomas, of Lostwythyell, tailor 2
3887794 1986176 1986176 defendant Genys Thomas laborer 645848 645848 Genys, Thomas, of Lostwythyell, shoemakerGylbert, John, of Lostwythyell, laborer 3
3887795 1986176 1986176 defendant Gevyn William glover 599869 599869 Gevyn, William, of Lostwythyell, glover 4
3887796 1986176 1986176 defendant Taleck Nicholas clerk 599869 599869 Taleck, Nicholas, of Lostwythyell, clerk 5
3887797 1986176 1986176 defendant Jago John tinner 599869 599869 Jago, John, of Lostwythyell, tinner 6
3887798 1986176 1986176 defendant Hobbe William potter 599869 599869 Hobbe, William, of Lostwythyell, potter 7
3887799 1986176 1986176 defendant Rawlyn Henry tanner 599869 599869 Rawlyn, Henry, of Lostwythyell, tanner 8
3887800 1986176 1986176 defendant Nans Thomas smith 599869 599869 Nans, Thomas, of Lostwythyell, smith 9
3887801 1986176 1986176 defendant Peryn William laborer 599869 599869 Peryn, William, of Lostwythyell, laborer 10
3887802 1986176 1986176 defendant La John smith 599869 599869 La, John, of Lostwythyell, smith 11
3887803 1986176 1986176 defendant Goodman John laborer 599869 599869 Goodman, John, of Lostwythyell, laborer 12
3887804 1986176 1986176 defendant Dyer Henry yeoman 599869 599869 Dyer, Henry, of Lostwythyell, yeoman 13
3887805 1986176 1986176 defendant Brytten Nicholas smith 599869 599869 Brytten, Nicholas, of Lostwythyell, smith 14
3887806 1986176 1986176 defendant Alan Henry weaver 599869 599869 Alan, Henry, of Lostwythyell, weaver 15

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