names

22 rows where case_id = 2172834

✎ 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
4425615 2172834 2172834 plaintiff Menevill John de son of Adam   Menevill, John de, son of Adam 0
4425616 2172834 2172834 defendant Lausone John   755094 755094 Lausone, John, of Bywell 0
4425617 2172834 2172834 defendant Kempe Thomas forester   Kempe, Thomas, forester 1
4425618 2172834 2172834 defendant Pountfreit John   755094 755094 Pountfreit, John, of Bywell 2
4425619 2172834 2172834 defendant Neuton Ralph de     Neuton, Ralph de 3
4425620 2172834 2172834 defendant Neuton William de son of Richard   Neuton, William de, son of Richard 4
4425621 2172834 2172834 defendant Kingesone Hugh   755095 755095 Kingesone, Hugh, of Bromly 5
4425622 2172834 2172834 defendant Dove or Done Roger   755095 755095 Dove or Done, Roger, of Bromly 6
4425623 2172834 2172834 defendant Pieressone William   755096 755096 Pieressone, William, of Molesdon 7
4425624 2172834 2172834 defendant Proketour William   755097 755097 Proketour, William, of Mitteford 8
4425625 2172834 2172834 defendant Bolt Richard   755098 755098 Bolt, Richard, of Carpyngton 9
4425626 2172834 2172834 defendant Thorp Adam de   593728 593728 Thorp, Adam de, of Horsley 10
4425627 2172834 2172834 defendant Geffraysone John   755099 755099 Geffraysone, John, of Neuburgh 11
4425628 2172834 2172834 defendant Thornburgh Adam de     Thornburgh, Adam de 12
4425629 2172834 2172834 defendant Yonger John   755100 755100 Yonger, John, of Tyndall 13
4425630 2172834 2172834 defendant Picden Thomas de     Picden, Thomas de 14
4425631 2172834 2172834 defendant Lang William   755099 755099 Lang, William, of Neuburgh 15
4425632 2172834 2172834 defendant Lang John   755099 755099 Lang, John, of Neuburgh 16
4425633 2172834 2172834 defendant Collen Adam     Collen, Adam 17
4425634 2172834 2172834 defendant Hare Walter   755095 755095 Hare, Walter, of Bromly 18
4425635 2172834 2172834 defendant Archur William     Archur, William 19
4425636 2172834 2172834 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);