names

22 rows where case_id = 2172835

✎ 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
4425637 2172835 2172835 plaintiff Menevill William de     Menevill, William de 0
4425638 2172835 2172835 defendant Lausone John   755094 755094 Lausone, John, of Bywell 0
4425639 2172835 2172835 defendant Kempe Thomas forester   Kempe, Thomas, forester 1
4425640 2172835 2172835 defendant Pountfreit John   755094 755094 Pountfreit, John, of Bywell 2
4425641 2172835 2172835 defendant Neuton Ralph de     Neuton, Ralph de 3
4425642 2172835 2172835 defendant Neuton William de son of Richard   Neuton, William de, son of Richard 4
4425643 2172835 2172835 defendant Kingesone Hugh   755095 755095 Kingesone, Hugh, of Bromly 5
4425644 2172835 2172835 defendant Dove or Done Roger   755095 755095 Dove or Done, Roger, of Bromly 6
4425645 2172835 2172835 defendant Pieressone William   755096 755096 Pieressone, William, of Molesdon 7
4425646 2172835 2172835 defendant Proketour William   755097 755097 Proketour, William, of Mitteford 8
4425647 2172835 2172835 defendant Bolt Richard   755098 755098 Bolt, Richard, of Carpyngton 9
4425648 2172835 2172835 defendant Thorp Adam de   593728 593728 Thorp, Adam de, of Horsley 10
4425649 2172835 2172835 defendant Geffraysone John   755099 755099 Geffraysone, John, of Neuburgh 11
4425650 2172835 2172835 defendant Thornburgh Adam de     Thornburgh, Adam de 12
4425651 2172835 2172835 defendant Yonger John   755100 755100 Yonger, John, of Tyndall 13
4425652 2172835 2172835 defendant Picden Thomas de     Picden, Thomas de 14
4425653 2172835 2172835 defendant Lang William   755099 755099 Lang, William, of Neuburgh 15
4425654 2172835 2172835 defendant Lang John   755099 755099 Lang, John, of Neuburgh 16
4425655 2172835 2172835 defendant Collen Adam     Collen, Adam 17
4425656 2172835 2172835 defendant Hare Walter   755095 755095 Hare, Walter, of Bromly 18
4425657 2172835 2172835 defendant Archur William     Archur, William 19
4425658 2172835 2172835 defendant (not given) John his brother   John, his brother 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);