names

49 rows where case_id = 2219515

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
4561401 2219515 2219515 plaintiff Paulton William de     Paulton, William de 0
4561402 2219515 2219515 defendant Colvyll John knight   Colvyll, John, knight 0
4561403 2219515 2219515 defendant Colvyll Robert knight   Colvyll, Robert, knight 1
4561404 2219515 2219515 defendant Gower Thomas   761129 761129 Gower, Thomas, of Cleveland 2
4561405 2219515 2219515 defendant Gower Nicholas   591585 591585 Gower, Nicholas, of Pykton 3
4561406 2219515 2219515 defendant Storme John   761129 761129 Storme, John, of Cleveland 4
4561407 2219515 2219515 defendant del Bower Thomas   608894 608894 del Bower, Thomas, of Allerton 5
4561408 2219515 2219515 defendant del Clyff William   761129 761129 del Clyff, William, of Cleveland 6
4561409 2219515 2219515 defendant Gower John     Gower, John 7
4561410 2219515 2219515 defendant Forster Robert   608894 608894 Forster, Robert, of Allerton 8
4561411 2219515 2219515 defendant Sadeler Thomas   608894 608894 Sadeler, Thomas, of Allerton 9
4561412 2219515 2219515 defendant Swaynby John de   608894 608894 Swaynby, John de, of Allerton 10
4561413 2219515 2219515 defendant Emondson Thomas   769776 769776 Emondson, Thomas, of Laysenby 11
4561414 2219515 2219515 defendant Dynys John   761129 761129 Dynys, John, of Cleveland 12
4561415 2219515 2219515 defendant Hoton John   769777 769777 Hoton, John, of Wyrsale 13
4561416 2219515 2219515 defendant Mitton John de   608894 608894 together with Mitton, John de, of Allerton 14
4561417 2219515 2219515 defendant Plastere Thomas   608894 608894 Plastere, Thomas, of Allerton 15
4561418 2219515 2219515 defendant Wryght Robert   625076 625076 Wryght, Robert, of Siggeston 16
4561419 2219515 2219515 defendant Warton Simon de   769615 769615 Warton, Simon de, of Hawenby 17
4561420 2219515 2219515 defendant Gower William   769615 769615 Gower, William, of Hawenby 18
4561421 2219515 2219515 defendant Milner William   769615 769615 Milner, William, of Hawenby 19
4561422 2219515 2219515 defendant Sissotson John   769617 769617 Sissotson, John, of Ald Byland 20
4561423 2219515 2219515 defendant Sissotson Thomas   769616 769616 Sissotson, Thomas, of Aldbyland 21
4561424 2219515 2219515 defendant Sissotson Roger   769616 769616 Sissotson, Roger, of Aldbyland 22
4561425 2219515 2219515 defendant Tyndale William de   604555 604555 Tyndale, William de, of Grenehowe 23
4561426 2219515 2219515 defendant del Hall Peter   597179 597179 del Hall, Peter, of Silton 24
4561427 2219515 2219515 defendant Bulmer Walter   597179 597179 Bulmer, Walter, of Silton 25
4561428 2219515 2219515 defendant Bulmer John   597179 597179 Bulmer, John, of Silton 26
4561429 2219515 2219515 defendant Garbote William   769778 769778 Garbote, William, of Dildesdale 27
4561430 2219515 2219515 defendant Hudson Wiliam   769620 769620 Hudson, Wiliam, of Erneclyff 28
4561431 2219515 2219515 defendant del Stabill John   769620 769620 del Stabill, John, of Erneclyff 29
4561432 2219515 2219515 defendant Hoggeson Robert   629548 629548 Hoggeson, Robert, of Whorleton 30
4561433 2219515 2219515 defendant Cole William   629548 629548 Cole, William, of Whorleton 31
4561434 2219515 2219515 defendant Thomson John   629548 629548 Thomson, John, of Whorleton 32
4561435 2219515 2219515 defendant del Clay Robert   761129 761129 del Clay, Robert, of Cleveland 33
4561436 2219515 2219515 defendant Witton William de   769779 769779 Witton, William de, of Bildesdale 34
4561437 2219515 2219515 defendant Parcour Thomas   761129 761129 Parcour, Thomas, of Cleveland 35
4561438 2219515 2219515 defendant Wryghton Richard   769780 769780 Wryghton, Richard, of Allerton, chir 36
4561439 2219515 2219515 defendant Scathelok Roger   761129 761129 Scathelok, Roger, of Cleveland 37
4561440 2219515 2219515 defendant Bell John   769781 769781 Bell, John, of Thyrsk, Sandes, William, of Bildesdale 38
4561441 2219515 2219515 defendant Parmoule Thomas son of John   Parmoule, Thomas son of John 39
4561442 2219515 2219515 defendant Traynholme William     Traynholme, William 40
4561443 2219515 2219515 defendant Traynholme John de     Traynholme, John de 41
4561444 2219515 2219515 defendant Welbery John     Welbery, John 42
4561445 2219515 2219515 defendant Pethowe John     Pethowe, John 43
4561446 2219515 2219515 defendant Lokwod Thomas   586183 586183 Lokwod, Thomas, of Broghton 44
4561447 2219515 2219515 defendant Marton William   593153 593153 Marton, William, of Middelton 45
4561448 2219515 2219515 defendant Wilton William de   769779 769779 Wilton, William de, of Bildesdale 46
4561449 2219515 2219515 defendant Dynys Roger     Dynys, Roger 47

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