names

13 rows where case_id = 2521514

✎ 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
5555156 2521514 2521514 plaintiff Huntingdon John abbot of Ramsey Abbey   Huntingdon, John, abbot of Ramsey Abbey 0
5555157 2521514 2521514 defendant Benet William husbandman 604831 604831 Benet, William, of Somersham, husbandman 0
5555158 2521514 2521514 defendant Hye John husbandman 604831 604831 Hye, John, of Somersham, husbandman 1
5555159 2521514 2521514 defendant Clerk Thomas husbandman 604831 604831 Clerk, Thomas, of Somersham, husbandman 2
5555160 2521514 2521514 defendant Corbet John husbandman 604831 604831 Corbet, John, of Somersham, husbandman 3
5555161 2521514 2521514 defendant Harvy John husbandman 604831 604831 Harvy, John, of Somersham, husbandman 4
5555162 2521514 2521514 defendant Baven Thomas husbandman 604831 604831 Baven, Thomas, of Somersham, husbandman 5
5555163 2521514 2521514 defendant Day John, junior husbandman 604831 604831 Day, John, junior, of Somersham, husbandman 6
5555164 2521514 2521514 defendant Ford Robert husbandman 899594 899594 Ford, Robert, of Blountesham, husbandman 7
5555165 2521514 2521514 defendant Wryght John husbandman 644453 644453 Wryght, John, of Colne, husbandman 8
5555166 2521514 2521514 defendant Cokke John husbandman 644453 644453 Cokke, John, of Colne, husbandman 9
5555167 2521514 2521514 defendant Sampson Richard husbandman 644453 644453 Sampson, Richard, of Colne, husbandman 10
5555168 2521514 2521514 defendant Sygarson Thomas husbandman 586144 586144 Sygarson, Thomas, of Eryth, husbandman 11

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