names

44 rows where case_id = 2231696

✎ 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
4601469 2231696 2231696 plaintiff Wakefeld William     Wakefeld, William 0
4601470 2231696 2231696 defendant Mallom William de   773522 773522 Mallom, William de, of Hamsthuayt 0
4601471 2231696 2231696 defendant Fletham Thomas     Fletham, Thomas 1
4601472 2231696 2231696 defendant Burdon John   773523 773523 Burdon, John, of Burton Lenarde 2
4601473 2231696 2231696 defendant Page Thomas   773524 773524 Page, Thomas, of Birkthwayte 3
4601474 2231696 2231696 defendant Hornessee John tailor   Hornessee, John, tailor 4
4601475 2231696 2231696 defendant Burnet Robert   586344 586344 Burnet, Robert, of Burton 5
4601476 2231696 2231696 defendant chapman Robert   773525 773525 chapman, Robert, of Hamsthwayt 6
4601477 2231696 2231696 defendant Redshawe William   773526 773526 Redshawe, William, of Bekwyth 7
4601478 2231696 2231696 defendant Webster Richard   762627 762627 Webster, Richard, of Hamstwayt 8
4601479 2231696 2231696 defendant Precious Thomas   586344 586344 Precious, Thomas, of Burton 9
4601480 2231696 2231696 defendant Colyer John   773527 773527 Colyer, John, of Pathlay Bridge 10
4601481 2231696 2231696 defendant Colier Robert   773527 773527 Colier, Robert, of Pathlay Bridge 11
4601482 2231696 2231696 defendant Bunche Hugh   773527 773527 Bunche, Hugh, of Pathlay Bridge 12
4601483 2231696 2231696 defendant Lun Thomas de     Lun, Thomas de 13
4601484 2231696 2231696 defendant Pulan Richard     Pulan, Richard 14
4601485 2231696 2231696 defendant Auburnwyk Thomas goldsmith 587266 587266 Auburnwyk, Thomas, of Rypon, goldsmith 15
4601486 2231696 2231696 defendant Walthewe John   587266 587266 Walthewe, John, of Rypon 16
4601487 2231696 2231696 defendant Walthewe William de     Walthewe, William de 17
4601488 2231696 2231696 defendant Cherry Thomas   773528 773528 Cherry, Thomas, of Rypon, horleche 18
4601489 2231696 2231696 defendant Leper John dyer 587266 587266 Leper, John, of Rypon, dyer 19
4601490 2231696 2231696 defendant Smyth John   587266 587266 Smyth, John, of Rypon 20
4601491 2231696 2231696 defendant Clyfford Robert     Clyfford, Robert 21
4601492 2231696 2231696 defendant Helay John     Helay, John 22
4601493 2231696 2231696 defendant Wauter John forester   Wauter, John, forester 23
4601494 2231696 2231696 defendant Wauter John son of John   Wauter, John, son of John 24
4601495 2231696 2231696 defendant Farnhill John de     Farnhill, John de 25
4601496 2231696 2231696 defendant Lenely Robert   586344 586344 Lenely, Robert, of Burton 26
4601497 2231696 2231696 defendant Soweter John son of Henry   Soweter, John, son of Henry 27
4601498 2231696 2231696 defendant Pulan Thomas     Pulan, Thomas 28
4601499 2231696 2231696 defendant Burlay William de     Burlay, William de 29
4601500 2231696 2231696 defendant Raskell John de     Raskell, John de 30
4601501 2231696 2231696 defendant Dicson John son of John, of Feryngesby   Dicson, John, son of John, of Feryngesby 31
4601502 2231696 2231696 defendant Hudson Robert son of Thomas, of Harowegate   Hudson, Robert, son of Thomas, of Harowegate 32
4601503 2231696 2231696 defendant Typerton John de     Typerton, John de 33
4601504 2231696 2231696 defendant Walker Robert arrow maker   Walker, Robert, arrow maker 34
4601505 2231696 2231696 defendant del Marche Stephen   773529 773529 del Marche, Stephen, of Bekwythshawe 35
4601506 2231696 2231696 defendant Rok William   601143 601143 Rok, William, of Rygton 36
4601507 2231696 2231696 defendant Crispyn Thomas   773522 773522 Crispyn, Thomas, of Hamsthuayt 37
4601508 2231696 2231696 defendant Stubbys William     Stubbys, William 38
4601509 2231696 2231696 defendant Stubbys John     Stubbys, John 39
4601510 2231696 2231696 defendant Wryght John   586344 586344 Wryght, John, of Burton 40
4601511 2231696 2231696 defendant Crayne John   587683 587683 Crayne, John, of Killynghall 41
4601512 2231696 2231696 defendant Mallom Robert de     Mallom, Robert de 42

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