names

42 rows where case_id = 2225599

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4581198 2225599 2225599 plaintiff Drayton John knight   Drayton, John, knight 0
4581199 2225599 2225599 defendant Chalmele Thomas     Chalmele, Thomas 0
4581200 2225599 2225599 defendant Chalmele Oliver servant of Thomas   Chalmele, Oliver, servant of Thomas 1
4581201 2225599 2225599 defendant Radele Roger     Radele, Roger 2
4581202 2225599 2225599 defendant Spryngold Thomas, sen     Spryngold, Thomas, sen 3
4581203 2225599 2225599 defendant Spryngold John, sen     Spryngold, John, sen 4
4581204 2225599 2225599 defendant Harper Roger   756155 756155 Harper, Roger, of Garsyndon 5
4581205 2225599 2225599 defendant Cokes Thomas     Cokes, Thomas 6
4581206 2225599 2225599 defendant Jop Robert     Jop, Robert 7
4581207 2225599 2225599 defendant Mayster Jones William     Mayster Jones, William 8
4581208 2225599 2225599 defendant Brounrobyn John     Brounrobyn, John 9
4581209 2225599 2225599 defendant Somerer John     Somerer, John 10
4581210 2225599 2225599 defendant Everard John     Everard, John 11
4581211 2225599 2225599 defendant Cokes John     Cokes, John 12
4581212 2225599 2225599 defendant Michell John     Michell, John 13
4581213 2225599 2225599 defendant Wodeward William     Wodeward, William 14
4581214 2225599 2225599 defendant Smyth John   756155 756155 Smyth, John, of Garsyndon 15
4581215 2225599 2225599 defendant Frankelayn John     Frankelayn, John 16
4581216 2225599 2225599 defendant Lefonlynde John     Lefonlynde, John 17
4581217 2225599 2225599 defendant Hopkyns Nicholas Spryngold, John, jun   Hopkyns, Nicholas, Spryngold, John, jun 18
4581218 2225599 2225599 defendant Savage Richard     Savage, Richard 19
4581219 2225599 2225599 defendant Warwyk John     Warwyk, John 20
4581220 2225599 2225599 defendant Barbour William   756155 756155 Barbour, William, of Garsyndon 21
4581221 2225599 2225599 defendant Coteborwe John     Coteborwe, John 22
4581222 2225599 2225599 defendant Clerk Nicholas   756155 756155 Clerk, Nicholas, of Garsyndon 23
4581223 2225599 2225599 defendant Hayward Hugh   756155 756155 Hayward, Hugh, of Garsyndon 24
4581224 2225599 2225599 defendant Morys Thomas     Morys, Thomas 25
4581225 2225599 2225599 defendant Rose Thomas     Rose, Thomas 26
4581226 2225599 2225599 defendant Bocher Richard   756155 756155 Bocher, Richard, of Garsyndon 27
4581227 2225599 2225599 defendant Hirissh Richard     Hirissh, Richard 28
4581228 2225599 2225599 defendant Preste William     Preste, William 29
4581229 2225599 2225599 defendant Berdewe Thomas     Berdewe, Thomas 30
4581230 2225599 2225599 defendant Pondy John     Pondy, John 31
4581231 2225599 2225599 defendant Axpuy or Axpny John     Axpuy or Axpny, John 32
4581232 2225599 2225599 defendant Midlyngton Adam     Midlyngton, Adam 33
4581233 2225599 2225599 defendant Carter John     Carter, John 34
4581234 2225599 2225599 defendant Short Thomas     Short, Thomas 35
4581235 2225599 2225599 defendant Smyth William   756155 756155 Smyth, William, of Garsyndon 36
4581236 2225599 2225599 defendant Neyre Thomas     Neyre, Thomas 37
4581237 2225599 2225599 defendant Everard Thomas servant of Walter Everard   Everard, Thomas, servant of Walter Everard 38
4581238 2225599 2225599 defendant Everard Walter     Everard, Walter 39
4581239 2225599 2225599 defendant Clerk John   756155 756155 Clerk, John, of Garsyndon 40

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