names

30 rows where case_id = 2465769

✎ 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
5368550 2465769 2465769 plaintiff Darneton John   878619 878619 Darneton, John, of the Monastery of St Mary, Fountains Abbey, abbot 0
5368551 2465769 2465769 defendant Deen Thomas yeoman 605100 605100 Deen, Thomas, of Fuston, yeoman 0
5368552 2465769 2465769 defendant Slyngesby Robert yeoman 605100 605100 Slyngesby, Robert, of Fuston, yeoman 1
5368553 2465769 2465769 defendant Bekwyth John yeoman 631968 631968 Bekwyth, John, of Northwode, yeoman 2
5368554 2465769 2465769 defendant Shawe William yeoman 601711 601711 Shawe, William, of Thorneton, yeoman 3
5368555 2465769 2465769 defendant Hardestrye Richard yeoman 638356 638356 Hardestrye, Richard, of Moston, yeoman 4
5368556 2465769 2465769 defendant Farebarn Robert yeoman 611336 611336 Farebarn, Robert, of Clynt, yeoman 5
5368557 2465769 2465769 defendant Farebarn William yeoman 632263 632263 Farebarn, William, of Farnell, yeoman 6
5368558 2465769 2465769 defendant Farebarn Thomas yeoman 878620 878620 Farebarn, Thomas, of Birthsted, yeoman 7
5368559 2465769 2465769 defendant Mylners Thomas yeoman 588477 588477 Mylners, Thomas, of Foston, yeoman 8
5368560 2465769 2465769 defendant Lyghtfote John yeoman 588477 588477 Lyghtfote, John, of Foston, yeoman 9
5368561 2465769 2465769 defendant Lyghtfote Robert yeoman 878621 878621 Lyghtfote, Robert, of Padsyde, yeoman 10
5368562 2465769 2465769 defendant Daweson Miles   878622 878622 Daweson, Miles, of Menwythyl, yeomen 11
5368563 2465769 2465769 defendant Constantyne William yeoman 848728 848728 Constantyne, William, of Thornthwayt, yeoman 12
5368564 2465769 2465769 defendant Morehouse Henry yeoman 878623 878623 Morehouse, Henry, of Harparyate, yeoman 13
5368565 2465769 2465769 defendant Puland Richard yeoman 878621 878621 Puland, Richard, of Padsyde, yeoman 14
5368566 2465769 2465769 defendant Mallom John yeoman 807896 807896 Mallom, John, of Hampsthwayte, yeoman 15
5368567 2465769 2465769 defendant Malham Thomas yeoman 878624 878624 Malham, Thomas, of Hamswhayte, yeoman 16
5368568 2465769 2465769 defendant More John yeoman 878624 878624 More, John, of Hamswhayte, yeoman 17
5368569 2465769 2465769 defendant Metcalf William yeoman 588688 588688 Metcalf, William, of Darley, yeoman 18
5368570 2465769 2465769 defendant Shepard William yeoman 588688 588688 Shepard, William, of Darley, yeoman 19
5368571 2465769 2465769 defendant Lonyng Robert yeoman 807896 807896 Lonyng, Robert, of Hampsthwayte, yeoman 20
5368572 2465769 2465769 defendant Parker Richard yeoman 878625 878625 Parker, Richard, of Kaylsyng, yeoman 21
5368573 2465769 2465769 defendant Shepard Henry yeoman 588688 588688 Shepard, Henry, of Darley, yeoman 22
5368574 2465769 2465769 defendant Ollerhed Robert yeoman 588688 588688 Ollerhed, Robert, of Darley, yeoman 23
5368575 2465769 2465769 defendant Arthyngton James yeoman 878626 878626 Arthyngton, James, of Menwhythyll, yeoman 24
5368576 2465769 2465769 defendant Robynson Thomas yeoman 878627 878627 Robynson, Thomas, of Whypley, yeoman 25
5368577 2465769 2465769 defendant Hardestie Stephen yeoman 588477 588477 Hardestie, Stephen, of Foston, yeoman 26
5368578 2465769 2465769 defendant Bolton William of Hardestie yeoman   Bolton, William of Hardestie, yeoman 27
5368579 2465769 2465769 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);