names

21 rows where case_id = 2339992

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4943671 2339992 2339992 plaintiff Graystok Ralph knight   Graystok, Ralph, knight 0
4943672 2339992 2339992 defendant Wadeluf Henry, senior husbandman 767264 767264 Wadeluf, Henry, senior, of Burton Lenard, husbandman 0
4943673 2339992 2339992 defendant Sevyer Richard husbandman 767264 767264 Sevyer, Richard, of Burton Lenard, husbandman 1
4943674 2339992 2339992 defendant Thorte Katherine widow 767264 767264 Thorte, Katherine, of Burton Lenard, widow 2
4943675 2339992 2339992 defendant del Hill Richard husbandman 767264 767264 del Hill, Richard, of Burton Lenard, husbandman 3
4943676 2339992 2339992 defendant Henryson Robert husbandman 767264 767264 Henryson, Robert, of Burton Lenard, husbandman 4
4943677 2339992 2339992 defendant Wadeluf Henry, junior husbandman 767264 767264 Wadeluf, Henry, junior, of Burton Lenard, husbandman 5
4943678 2339992 2339992 defendant Burnet John husbandman 767264 767264 Burnet, John, of Burton Lenard, husbandman 6
4943679 2339992 2339992 defendant Warthe William husbandman 767264 767264 Warthe, William, of Burton Lenard, husbandman 7
4943680 2339992 2339992 defendant Esshton Robert husbandman 767264 767264 Esshton, Robert, of Burton Lenard, husbandman 8
4943681 2339992 2339992 defendant Ketilfo John husbandman 767264 767264 Ketilfo, John, of Burton Lenard, husbandman 9
4943682 2339992 2339992 defendant White John husbandman 767264 767264 White, John, of Burton Lenard, husbandman 10
4943683 2339992 2339992 defendant Robynson William husbandman 767264 767264 Robynson, William, of Burton Lenard, husbandman 11
4943684 2339992 2339992 defendant Smyth Thomas husbandman 767264 767264 Smyth, Thomas, of Burton Lenard, husbandman 12
4943685 2339992 2339992 defendant Milner Agnes widow 767264 767264 Milner, Agnes, of Burton Lenard, widow 13
4943686 2339992 2339992 defendant Newebald Richard husbandman 767264 767264 Newebald, Richard, of Burton Lenard, husbandman 14
4943687 2339992 2339992 defendant Junour William husbandman 767264 767264 Junour, William, of Burton Lenard, husbandman 15
4943688 2339992 2339992 defendant Forman William husbandman 593579 593579 Forman, William, of Staveley, husbandman 16
4943689 2339992 2339992 defendant Newet Robert husbandman 825503 825503 Newet, Robert, of Mefilfeld, husbandman 17
4943690 2339992 2339992 defendant Wilton John husbandman 767264 767264 Wilton, John, of Burton Lenard, husbandman 18
4943691 2339992 2339992 defendant Yonge Robert husbandman 825504 825504 Yonge, Robert, of Kyrkeby Hall juxta Usburn, husbandman 19

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