names

18 rows where case_id = 2429509

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5247823 2429509 2429509 plaintiff Stanhop John esq   Stanhop, John, esq 0
5247824 2429509 2429509 defendant Roos Isabel widow 591977 591977 Roos, Isabel, of Laxton, widow 0
5247825 2429509 2429509 defendant Roos Richard gent 591977 591977 Roos, Richard, of Laxton, gent 1
5247826 2429509 2429509 defendant Leverton John, junior husbandman 591977 591977 Leverton, John, junior, of Laxton, husbandman 2
5247827 2429509 2429509 defendant Goland Robert laborer 591977 591977 Goland, Robert, of Laxton, laborer 3
5247828 2429509 2429509 defendant Heyward Roger laborer 591977 591977 Heyward, Roger, of Laxton, laborer 4
5247829 2429509 2429509 defendant Rygdon Robert husbandman 591977 591977 Rygdon, Robert, of Laxton, husbandman 5
5247830 2429509 2429509 defendant Gartsyde Henry laborer 591977 591977 Gartsyde, Henry, of Laxton, laborer 6
5247831 2429509 2429509 defendant Phelypp Thomas laborer 591977 591977 Phelypp, Thomas, of Laxton, laborer 7
5247832 2429509 2429509 defendant Tode John laborer 591977 591977 Tode, John, of Laxton, laborer 8
5247833 2429509 2429509 defendant Doghson Christopher laborer 591977 591977 Doghson, Christopher, of Laxton,laborer 9
5247834 2429509 2429509 defendant Thorneton William yeoman 591977 591977 Thorneton, William, of Laxton, yeoman 10
5247835 2429509 2429509 defendant Bayldon Richard laborer 591977 591977 Bayldon, Richard, of Laxton, laborer 11
5247836 2429509 2429509 defendant Legeard Richard yeoman 591977 591977 Legeard, Richard, of Laxton, yeoman 12
5247837 2429509 2429509 defendant Wryght Robert     Wryght, Robert 13
5247838 2429509 2429509 defendant Leverton William     Leverton, William 14
5247839 2429509 2429509 defendant Santon John     Santon, John 15
5247840 2429509 2429509 defendant Warde Robert     Warde, Robert 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);