names

17 rows where case_id = 2407703

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5172559 2407703 2407703 plaintiff Musgrave Joan     Musgrave, Joan 0
5172560 2407703 2407703 defendant Wybergh Thomas gent   Wybergh, Thomas, gent 0
5172561 2407703 2407703 defendant Hogeson John     Hogeson, John 1
5172562 2407703 2407703 defendant Jakson John     Jakson, John 2
5172563 2407703 2407703 defendant Richardson John     Richardson, John 3
5172564 2407703 2407703 defendant Dauson John     Dauson, John 4
5172565 2407703 2407703 defendant Fergus Gilbert     Fergus, Gilbert 5
5172566 2407703 2407703 defendant Sclater John     Sclater, John 6
5172567 2407703 2407703 defendant Ledall Thomas     Ledall, Thomas 7
5172568 2407703 2407703 defendant Ledall Richard     Ledall, Richard 8
5172569 2407703 2407703 defendant all husbandman of Clifton     all husbandman, of Clifton 9
5172570 2407703 2407703 defendant Baudewyn William   725344 725344 Baudewyn, William, of Louther 10
5172571 2407703 2407703 defendant Boweman Robert   632016 632016 Boweman, Robert, of Hakthorp 11
5172572 2407703 2407703 defendant Michell Robert   632016 632016 Michell, Robert, of Hakthorp 12
5172573 2407703 2407703 defendant Jenkynson Robert   632016 632016 Jenkynson, Robert, of Hakthorp 13
5172574 2407703 2407703 defendant Alcok John   725344 725344 Alcok, John, of Louther 14
5172575 2407703 2407703 defendant Clerk John   725344 725344 Clerk, John, of Louther 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);