names

47 rows where case_id = 2212498

✎ 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
4539092 2212498 2212498 plaintiff Vaux Roland     Vaux, Roland 0
4539093 2212498 2212498 defendant Richardson Thomas tailor   Richardson, Thomas, tailor 0
4539094 2212498 2212498 defendant Bateman John   593579 593579 Bateman, John, of Staveley 1
4539095 2212498 2212498 defendant Bateman William   593579 593579 Bateman, William, of Staveley 2
4539096 2212498 2212498 defendant Thomson John   767408 767408 Thomson, John, of Fairebank 3
4539097 2212498 2212498 defendant del Bek Richard     del Bek, Richard 4
4539098 2212498 2212498 defendant del Bek Robert   767409 767409 del Bek, Robert, of Greneryg 5
4539099 2212498 2212498 defendant del Sill Thomas     del Sill, Thomas 6
4539100 2212498 2212498 defendant Pierson John   767410 767410 Pierson, John, of Hugill 7
4539101 2212498 2212498 defendant Coke William   746988 746988 Coke, William, of Helsyngton 8
4539102 2212498 2212498 defendant del Chirs John   746988 746988 del Chirs, John, of Helsyngton 9
4539103 2212498 2212498 defendant Wilson John   735152 735152 Wilson, John, of Levens, son of John 10
4539104 2212498 2212498 defendant Fyssher John   767412 767412 Fyssher, John, of Sleddale 11
4539105 2212498 2212498 defendant Donethwayt William de   767412 767412 Donethwayt, William de, of Sleddale 12
4539106 2212498 2212498 defendant Benetson William   767412 767412 Benetson, William, of Sleddale 13
4539107 2212498 2212498 defendant Lokay John de     Lokay, John de 14
4539108 2212498 2212498 defendant Lokay William de     Lokay, William de 15
4539109 2212498 2212498 defendant Atkynson del Hay Robert     Atkynson del Hay, Robert 16
4539110 2212498 2212498 defendant Wilson del Kechyn William   Wilson, del Kechyn, William 17
4539111 2212498 2212498 defendant Frothebank John de     Frothebank, John de 18
4539112 2212498 2212498 defendant Thomson Makerell John   767413 767413 Thomson Makerell, John, of Amelset 19
4539113 2212498 2212498 defendant Sharp John     Sharp, John 20
4539114 2212498 2212498 defendant Jakson Marshall William     Jakson Marshall, William 21
4539115 2212498 2212498 defendant del Lek Robert     del Lek, Robert 22
4539116 2212498 2212498 defendant del Thwayt William   767414 767414 del Thwayt, William, of Sloddale 23
4539117 2212498 2212498 defendant Tod Thomas   767409 767409 Tod, Thomas, of Greneryg 24
4539118 2212498 2212498 defendant Jonson Colynson William   746988 746988 Jonson Colynson, William, of Helsyngton 25
4539119 2212498 2212498 defendant Tod John   767414 767414 Tod, John, of Sloddale 26
4539120 2212498 2212498 defendant Coke Roger   619824 619824 Coke, Roger, of Kendale 27
4539121 2212498 2212498 defendant Jonson William fishmonger   Jonson, William, fishmonger 28
4539122 2212498 2212498 defendant del Bek John   586549 586549 del Bek, John, of Hoton 29
4539123 2212498 2212498 defendant Thomlynson Wilkynson John, of Staneley   Thomlynson, Wilkynson, John, of Staneley 30
4539124 2212498 2212498 defendant Thomlynson John   767415 767415 Thomlynson, John, of Braunthwayt 31
4539125 2212498 2212498 defendant Wryght William   753729 753729 Wryght, William, of Kirkeby in Kendale 32
4539126 2212498 2212498 defendant Coke John   767416 767416 Coke, John, of Wenandermer or Windermere 33
4539127 2212498 2212498 defendant Couneswyk John de     Couneswyk, John de 34
4539128 2212498 2212498 defendant del Halbank Thomas     del Halbank, Thomas 35
4539129 2212498 2212498 defendant del Halbank John     del Halbank, John 36
4539130 2212498 2212498 defendant del Shawe John     del Shawe, John 37
4539131 2212498 2212498 defendant del Shawe William     del Shawe, William 38
4539132 2212498 2212498 defendant Cokesen John   767417 767417 Cokesen, John, of Kirkeby Lonesdale 39
4539133 2212498 2212498 defendant del Halbank Henry     del Halbank, Henry 40
4539134 2212498 2212498 defendant Roke John   767410 767410 Roke, John, of Hugill 41
4539135 2212498 2212498 defendant Henryson Dawson Robert     Henryson Dawson, Robert 42
4539136 2212498 2212498 defendant Coke William   619824 619824 Coke, William, of Kendale 43
4539137 2212498 2212498 defendant Dykson Taillour Thomas     Dykson Taillour, Thomas 44
4539138 2212498 2212498 defendant Godmond William   767418 767418 Godmond, William, of Staneley 45

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