names

17 rows where case_id = 2428002

✎ 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
5242443 2428002 2428002 plaintiff Metham Thomas, junior knight   Metham, Thomas, junior, knight 0
5242444 2428002 2428002 defendant Lightfote Thomas husbandman 789177 789177 Lightfote, Thomas, of Roclyf, husbandman 0
5242445 2428002 2428002 defendant Herrad Richard husbandman 789177 789177 Herrad, Richard, of Roclyf, husbandman 1
5242446 2428002 2428002 defendant Herrad Robert husbandman 789177 789177 Herrad, Robert, of Roclyf, husbandman 2
5242447 2428002 2428002 defendant Belton Robert husbandman 789177 789177 Belton, Robert, of Roclyf, husbandman 3
5242448 2428002 2428002 defendant Belton Richard husbandman 789177 789177 Belton, Richard, of Roclyf, husbandman 4
5242449 2428002 2428002 defendant Hemsam John husbandman 789177 789177 Hemsam, John, of Roclyf, husbandman 5
5242450 2428002 2428002 defendant Whitside John husbandman 789177 789177 Whitside, John, of Roclyf, husbandman 6
5242451 2428002 2428002 defendant Mangall Richard husbandman 789177 789177 Mangall, Richard, of Roclyf, husbandman 7
5242452 2428002 2428002 defendant Kyng William husbandman 789177 789177 Kyng, William, of Roclyf, husbandman 8
5242453 2428002 2428002 defendant Ancas Robert husbandman 789177 789177 Ancas, Robert, of Roclyf, husbandman 9
5242454 2428002 2428002 defendant Toyde Robert husbandman 789177 789177 Toyde, Robert, of Roclyf, husbandman 10
5242455 2428002 2428002 defendant Been John husbandman 586121 586121 Been, John, of Carleton, husbandman 11
5242456 2428002 2428002 defendant Sherd William     Sherd, William 12
5242457 2428002 2428002 defendant Nelson William     Nelson, William 13
5242458 2428002 2428002 defendant Nicholas John     Nicholas, John 14
5242459 2428002 2428002 defendant Jakson Richard     Jakson, Richard 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);