names

21 rows where case_id = 2341941

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4949865 2341941 2341941 plaintiff Norwych William     Norwych, William 0
4949866 2341941 2341941 defendant Laurens Peter gent 585936 585936 Laurens, Peter, of Norwich, gent 0
4949867 2341941 2341941 defendant Andrewe John husbandman 590750 590750 Andrewe, John, of Wyveton, husbandman 1
4949868 2341941 2341941 defendant Lether Thomas yeoman 590750 590750 Lether, Thomas, of Wyveton, yeoman 2
4949869 2341941 2341941 defendant Barbour Thomas vicar of Kengyngale   Barbour, Thomas, vicar of Kengyngale 3
4949870 2341941 2341941 defendant Miles John husbandman 598184 598184 Miles, John, of Totyngton, husbandman 4
4949871 2341941 2341941 defendant Cobald Roger butcher 593964 593964 Cobald, Roger, of Hardewyk, butcher 5
4949872 2341941 2341941 defendant Wode John husbandman 644888 644888 Wode, John, of Netysherd, husbandman 6
4949873 2341941 2341941 defendant Palle Robert husbandman 605374 605374 Palle, Robert, of Brynton, husbandman 7
4949874 2341941 2341941 defendant Lombe Thomas husbandman 646541 646541 Lombe, Thomas, of Wymyndham, husbandman 8
4949875 2341941 2341941 defendant Fuller Geoffrey chaplain 588239 588239 Fuller, Geoffrey, of Yelverton, chaplain 9
4949876 2341941 2341941 defendant Basset Andrew chapman 585936 585936 Basset, Andrew, of Norwich, chapman 10
4949877 2341941 2341941 defendant Auty Thomas vicar of Gatle   Auty, Thomas, vicar of Gatle 11
4949878 2341941 2341941 defendant Mey John chaplain 585936 585936 Mey, John, of Norwich, chaplain 12
4949879 2341941 2341941 defendant Gravour Henry engraver 609766 609766 Gravour, Henry, of Ormysby, engraver 13
4949880 2341941 2341941 defendant Broune Robert parson of Ovyr Saxlyngham   Broune, Robert, parson of Ovyr Saxlyngham 14
4949881 2341941 2341941 defendant Assh Richard chaplain 756254 756254 Assh, Richard, of Morle, chaplain 15
4949882 2341941 2341941 defendant Neweton Thomas husbandman 763746 763746 Neweton, Thomas, of Thirnyng, husbandman 16
4949883 2341941 2341941 defendant Puttok Robert chapman 587820 587820 Puttok, Robert, of Leystoft, Suff, chapman 17
4949884 2341941 2341941 defendant Iryng Thomas smith 586516 586516 Iryng, Thomas, of Marsham, smith 18
4949885 2341941 2341941 defendant Sweyn William husbandman 589331 589331 Sweyn, William, of Dersyngham, 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);