names

22 rows where case_id = 2175727

✎ 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
4435051 2175727 2175727 plaintiff Menevill William de     Menevill, William de 0
4435052 2175727 2175727 defendant Lausone John   755094 755094 Lausone, John, of Bywell 0
4435053 2175727 2175727 defendant Kempe Thomas forester   Kempe, Thomas, forester 1
4435054 2175727 2175727 defendant Pieressone William   755096 755096 Pieressone, William, of Molesdon 2
4435055 2175727 2175727 defendant Proketour William   755097 755097 Proketour, William, of Mitteford 3
4435056 2175727 2175727 defendant Pycden Thomas de     Pycden, Thomas de 4
4435057 2175727 2175727 defendant Pounfrett John   755094 755094 Pounfrett, John, of Bywell 5
4435058 2175727 2175727 defendant Neuton Ralph de     Neuton, Ralph de 6
4435059 2175727 2175727 defendant Neuton William son of Richard   Neuton, William, son of Richard 7
4435060 2175727 2175727 defendant Wyngesone Hugh   755095 755095 Wyngesone, Hugh, of Bromly 8
4435061 2175727 2175727 defendant Dove Roger   755095 755095 Dove, Roger, of Bromly 9
4435062 2175727 2175727 defendant Bole Richard   755098 755098 Bole, Richard, of Carpyngton 10
4435063 2175727 2175727 defendant Thorp Adam de   593728 593728 Thorp, Adam de, of Horsley 11
4435064 2175727 2175727 defendant Geffraysone John   755099 755099 Geffraysone, John, of Neuburgh 12
4435065 2175727 2175727 defendant Thornburgh Adam de     Thornburgh, Adam de 13
4435066 2175727 2175727 defendant Yonger John   755100 755100 Yonger, John, of Tyndall 14
4435067 2175727 2175727 defendant Lang William   755099 755099 Lang, William, of Neuburgh 15
4435068 2175727 2175727 defendant Lang John   755099 755099 Lang, John, of Neuburgh 16
4435069 2175727 2175727 defendant Collan Adam     Collan, Adam 17
4435070 2175727 2175727 defendant Hare Walter   756189 756189 Hare, Walter, of Bromlye 18
4435071 2175727 2175727 defendant Arthur William     Arthur, William 19
4435072 2175727 2175727 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);