names

30 rows where case_id = 1924997

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3696043 1924997 1924997 plaintiff Roper John     Roper, John 0
3696044 1924997 1924997 defendant Markenfeld Numan   613002 613002 Markenfeld, Numan, of Markkenfeld, knight 0
3696045 1924997 1924997 defendant Markenfeld John gent 613003 613003 Markenfeld, John, of Middilsmore, gent 1
3696046 1924997 1924997 defendant Lister Richard gent 613004 613004 Lister, Richard, of Massam, gent 2
3696047 1924997 1924997 defendant Rowthwaite Rowland     Rowthwaite, Rowland 3
3696048 1924997 1924997 defendant Horner John     Horner, John 4
3696049 1924997 1924997 defendant Leyng Mathew     Leyng, Mathew 5
3696050 1924997 1924997 defendant Horman James     Horman, James 6
3696051 1924997 1924997 defendant Dernbrok Numan     Dernbrok, Numan 7
3696052 1924997 1924997 defendant Wyle John     Wyle, John 8
3696053 1924997 1924997 defendant Man John     Man, John 9
3696054 1924997 1924997 defendant Horsman Giles     Horsman, Giles 10
3696055 1924997 1924997 defendant Horsman William     Horsman, William 11
3696056 1924997 1924997 defendant Exilby Thomas     Exilby, Thomas 12
3696057 1924997 1924997 defendant Radclyff Robert     Radclyff, Robert 13
3696058 1924997 1924997 defendant Johnson John     Johnson, John 14
3696059 1924997 1924997 defendant Horseman Leonard     Horseman, Leonard 15
3696060 1924997 1924997 defendant Horseman lawrence     Horseman, lawrence 16
3696061 1924997 1924997 defendant Hawson James     Hawson, James 17
3696062 1924997 1924997 defendant Key Thomas     Key, Thomas 18
3696063 1924997 1924997 defendant Reyner Robert     Reyner, Robert 19
3696064 1924997 1924997 defendant Swetyng William     Swetyng, William 20
3696065 1924997 1924997 defendant Colier William     Colier, William 21
3696066 1924997 1924997 defendant Bernbroke John     Bernbroke, John 22
3696067 1924997 1924997 defendant Morehouse John     Morehouse, John 23
3696068 1924997 1924997 defendant Gowthwaite Thomas     Gowthwaite, Thomas 24
3696069 1924997 1924997 defendant Bekwith Robert     Bekwith, Robert 25
3696070 1924997 1924997 defendant reyner Leanord     reyner, Leanord 26
3696071 1924997 1924997 defendant Servant William     Servant, William 27
3696072 1924997 1924997 defendant Herdcastell Miles     Herdcastell, Miles 28

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