names

30 rows where case_id = 2465768

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5368520 2465768 2465768 plaintiff Darneton John   878619 878619 Darneton, John, of the Monastery of St Mary, Fountains Abbey, abbot 0
5368521 2465768 2465768 defendant Been Thomas yeoman 605100 605100 Been, Thomas, of Fuston, yeoman 0
5368522 2465768 2465768 defendant Slyngesby Robert yeoman 605100 605100 Slyngesby, Robert, of Fuston, yeoman 1
5368523 2465768 2465768 defendant Bekwyth John yeoman 631968 631968 Bekwyth, John, of Northwode, yeoman 2
5368524 2465768 2465768 defendant Shawe William yeoman 601711 601711 Shawe, William, of Thorneton, yeoman 3
5368525 2465768 2465768 defendant Hardestrye Richard yeoman 638356 638356 Hardestrye, Richard, of Moston, yeoman 4
5368526 2465768 2465768 defendant Farebarn Robert yeoman 611336 611336 Farebarn, Robert, of Clynt, yeoman 5
5368527 2465768 2465768 defendant Farebarn William yeoman 632263 632263 Farebarn, William, of Farnell, yeoman 6
5368528 2465768 2465768 defendant Farebarn Thomas yeoman 878620 878620 Farebarn, Thomas, of Birthsted, yeoman 7
5368529 2465768 2465768 defendant Mylners Thomas yeoman 588477 588477 Mylners, Thomas, of Foston, yeoman 8
5368530 2465768 2465768 defendant Lyghtfote John yeoman 588477 588477 Lyghtfote, John, of Foston, yeoman 9
5368531 2465768 2465768 defendant Lyghtfote Robert yeoman 878621 878621 Lyghtfote, Robert, of Padsyde, yeoman 10
5368532 2465768 2465768 defendant Daweson Miles   878622 878622 Daweson, Miles, of Menwythyl, yeomen 11
5368533 2465768 2465768 defendant Constantyne William yeoman 848728 848728 Constantyne, William, of Thornthwayt, yeoman 12
5368534 2465768 2465768 defendant Morehouse Henry yeoman 878623 878623 Morehouse, Henry, of Harparyate, yeoman 13
5368535 2465768 2465768 defendant Puland Richard yeoman 878621 878621 Puland, Richard, of Padsyde, yeoman 14
5368536 2465768 2465768 defendant Mallom John yeoman 807896 807896 Mallom, John, of Hampsthwayte, yeoman 15
5368537 2465768 2465768 defendant Malham Thomas yeoman 878624 878624 Malham, Thomas, of Hamswhayte, yeoman 16
5368538 2465768 2465768 defendant More John yeoman 878624 878624 More, John, of Hamswhayte, yeoman 17
5368539 2465768 2465768 defendant Metcalf William yeoman 588688 588688 Metcalf, William, of Darley, yeoman 18
5368540 2465768 2465768 defendant Shepard William yeoman 588688 588688 Shepard, William, of Darley, yeoman 19
5368541 2465768 2465768 defendant Lonyng Robert yeoman 807896 807896 Lonyng, Robert, of Hampsthwayte, yeoman 20
5368542 2465768 2465768 defendant Parker Richard yeoman 878625 878625 Parker, Richard, of Kaylsyng, yeoman 21
5368543 2465768 2465768 defendant Shepard Henry yeoman 588688 588688 Shepard, Henry, of Darley, yeoman 22
5368544 2465768 2465768 defendant Ollerhed Robert yeoman 588688 588688 Ollerhed, Robert, of Darley, yeoman 23
5368545 2465768 2465768 defendant Arthyngton James yeoman 878626 878626 Arthyngton, James, of Menwhythyll, yeoman 24
5368546 2465768 2465768 defendant Robynson Thomas yeoman 878627 878627 Robynson, Thomas, of Whypley, yeoman 25
5368547 2465768 2465768 defendant Hardestie Stephen yeoman 588477 588477 Hardestie, Stephen, of Foston, yeoman 26
5368548 2465768 2465768 defendant Bolton William of Hardestie yeoman   Bolton, William of Hardestie, yeoman 27
5368549 2465768 2465768 defendant Coupers Richard yeoman 807896 807896 Coupers, Richard, of Hampsthwayte, yeoman 28

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