names

38 rows where case_id = 2229394

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4593987 2229394 2229394 plaintiff Petipas Bartholomew     Petipas, Bartholomew 0
4593988 2229394 2229394 plaintiff Philippe John     Philippe, John 1
4593989 2229394 2229394 plaintiff Langton Thomas     Langton, Thomas 2
4593990 2229394 2229394 defendant Maryot John   671123 671123 Maryot, John, of Suttone 0
4593991 2229394 2229394 defendant Mariot Fulk     Mariot, Fulk 1
4593992 2229394 2229394 defendant Robert son of Thomas     Robert, son of Thomas 2
4593993 2229394 2229394 defendant Derelef John     Derelef, John 3
4593994 2229394 2229394 defendant Mey Nicholas     Mey, Nicholas 4
4593995 2229394 2229394 defendant Warner John   587058 587058 Warner, John, of Sutton 5
4593996 2229394 2229394 defendant Nichol John   689060 689060 Nichol, John, of Lincolnshire 6
4593997 2229394 2229394 defendant Kirketon Thomas de     Kirketon, Thomas de 7
4593998 2229394 2229394 defendant Mariot William   689060 689060 Mariot, William, of Lincolnshire 8
4593999 2229394 2229394 defendant Clerk William   689060 689060 Clerk, William, of Lincolnshire 9
4594000 2229394 2229394 defendant Haukyn John     Haukyn, John 10
4594001 2229394 2229394 defendant John son of Robert     John, son of Robert 11
4594002 2229394 2229394 defendant Russell John   689060 689060 Russell, John, of Lincolnshire 12
4594003 2229394 2229394 defendant Thomasson Robert     Thomasson, Robert 13
4594004 2229394 2229394 defendant Derelef Geoffrey     Derelef, Geoffrey 14
4594005 2229394 2229394 defendant Burwyn Beatrice     Burwyn, Beatrice 15
4594006 2229394 2229394 defendant Abraham Thomas     Abraham, Thomas 16
4594007 2229394 2229394 defendant Nichol Roger     Nichol, Roger 17
4594008 2229394 2229394 defendant Abraham Roger     Abraham, Roger 18
4594009 2229394 2229394 defendant Hanegeday Agnes     Hanegeday, Agnes 19
4594010 2229394 2229394 defendant Laxham John de     Laxham, John de 20
4594011 2229394 2229394 defendant Symson Nicholas     Symson, Nicholas 21
4594012 2229394 2229394 defendant Bacon John   689060 689060 Bacon, John, of Lincolnshire 22
4594013 2229394 2229394 defendant Mochet Richard     Mochet, Richard 23
4594014 2229394 2229394 defendant Kade William chaplain   Kade, William, chaplain 24
4594015 2229394 2229394 defendant Gaunt Richard     Gaunt, Richard 25
4594016 2229394 2229394 defendant Kyrden Thomas     Kyrden, Thomas 26
4594017 2229394 2229394 defendant Thomas son of Nicholas     Thomas, son of Nicholas 27
4594018 2229394 2229394 defendant Cade Alan     Cade, Alan 28
4594019 2229394 2229394 defendant Hunston Robert     Hunston, Robert 29
4594020 2229394 2229394 defendant Bevereche John     Bevereche, John 30
4594021 2229394 2229394 defendant Symson John     Symson, John 31
4594022 2229394 2229394 defendant James son of Roger     James, son of Roger 32
4594023 2229394 2229394 defendant Stok William     Stok, William 33
4594024 2229394 2229394 defendant Bekyr John     Bekyr, John 34

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