names

15 rows where case_id = 2394377

✎ 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
5127003 2394377 2394377 plaintiff Brounflete Henry knight   Brounflete, Henry, knight 0
5127004 2394377 2394377 defendant Hastynges Edmund esq 849682 849682 Hastynges, Edmund, of Rousteby in Pykeryng Lith, esq 0
5127005 2394377 2394377 defendant Hastynges Ralph gent 849683 849683 Hastynges, Ralph, of Rousteby, in Pykeryng Lith, gent 1
5127006 2394377 2394377 defendant West William forester 587727 587727 West, William, of Pykeryng, forester 2
5127007 2394377 2394377 defendant Kempe John forester 849684 849684 Kempe, John, of Kyngthorp, forester 3
5127008 2394377 2394377 defendant Body John laborer 849685 849685 Body, John, of Thornton, in Pykeryng, laborer 4
5127009 2394377 2394377 defendant Pays John   849686 849686 Pays, John, of Ronstedby, servant 5
5127010 2394377 2394377 defendant Heppell Richard laborer 849684 849684 Heppell, Richard, of Kyngthorp, laborer 6
5127011 2394377 2394377 defendant Archur William laboer 849687 849687 Archur, William, of Thornton, in Pykeryng ltih, laboer 7
5127012 2394377 2394377 defendant Hogesson George of Rousteby groome   Hogesson, George of Rousteby, groome 8
5127013 2394377 2394377 defendant Gylys John yeoman 849677 849677 Gylys, John, of Rousteby, yeoman 9
5127014 2394377 2394377 defendant Walker Henry walker 587259 587259 Walker, Henry, of Thornton, walker 10
5127015 2394377 2394377 defendant Broune George laborer 587259 587259 Broune, George, of Thornton, laborer 11
5127016 2394377 2394377 defendant Harleshay John milner 849681 849681 Harleshay, John, of Fermanby, milner 12
5127017 2394377 2394377 defendant Farmory William yeoman 849677 849677 Farmory, William, of Rousteby, yeoman 13

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