names

22 rows where case_id = 2241434

✎ 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
4633827 2241434 2241434 plaintiff Westmorland Ralph earl of   Westmorland, Ralph, earl of 0
4633828 2241434 2241434 defendant Metcalf Hugh     Metcalf, Hugh 0
4633829 2241434 2241434 defendant Metcalf Henry     Metcalf, Henry 1
4633830 2241434 2241434 defendant Metcalf Richard son of John   Metcalf, Richard, son of John 2
4633831 2241434 2241434 defendant Knyghtson Richard     Knyghtson, Richard 3
4633832 2241434 2241434 defendant del Hall John son of Nicholas   del Hall, John, son of Nicholas 4
4633833 2241434 2241434 defendant Robynson Henry   776440 776440 Robynson, Henry, of Moureset 5
4633834 2241434 2241434 defendant Robynson Adam   776440 776440 Robynson, Adam, of Moureset 6
4633835 2241434 2241434 defendant Hoton John de     Hoton, John de 7
4633836 2241434 2241434 defendant Been William   776441 776441 Been, William, of Aykescarth 8
4633837 2241434 2241434 defendant Wacedale John   776441 776441 Wacedale, John, of Aykescarth 9
4633838 2241434 2241434 defendant Ketylwell Robert jun   Ketylwell, Robert, jun 10
4633839 2241434 2241434 defendant Selyman Thomas     Selyman, Thomas 11
4633840 2241434 2241434 defendant Robynson Henry   773166 773166 Robynson, Henry, of Wenslawedale 12
4633841 2241434 2241434 defendant Tomson John     Tomson, John 13
4633842 2241434 2241434 defendant Askeryg John de     Askeryg, John de 14
4633843 2241434 2241434 defendant Pykeryng Thomas jun   Pykeryng, Thomas, jun 15
4633844 2241434 2241434 defendant NIcolson John   776442 776442 NIcolson, John, of Askeryg 16
4633845 2241434 2241434 defendant Knyghtson Richard   776443 776443 Knyghtson, Richard, of Nappay 17
4633846 2241434 2241434 defendant Tesedall William   776443 776443 Tesedall, William, of Nappay 18
4633847 2241434 2241434 defendant Mallome William carter 615749 615749 Mallome, William, of Helay, carter 19
4633848 2241434 2241434 defendant Frere Ralph   776442 776442 Frere, Ralph, of Askeryg 20

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