names

27 rows where case_id = 2361443

✎ 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
5015573 2361443 2361443 plaintiff Boynton Christopher     Boynton, Christopher 0
5015574 2361443 2361443 defendant Walker John yeoman 835411 835411 Walker, John, of Aclome, yeoman 0
5015575 2361443 2361443 defendant Hunter John husbandman 835411 835411 Hunter, John, of Aclome, husbandman 1
5015576 2361443 2361443 defendant Bownyng William husbandman 835411 835411 Bownyng, William, of Aclome, husbandman 2
5015577 2361443 2361443 defendant Aton John husbandman 835411 835411 Aton, John, of Aclome, husbandman 3
5015578 2361443 2361443 defendant Riche John husbandman 835411 835411 Riche, John, of Aclome, husbandman 4
5015579 2361443 2361443 defendant Wilson John husbandman 835411 835411 Wilson, John, of Aclome, husbandman 5
5015580 2361443 2361443 defendant Henryson Robert husbandman 835411 835411 Henryson, Robert, of Aclome, husbandman 6
5015581 2361443 2361443 defendant Lyndsey William husbandman 835411 835411 Lyndsey, William, of Aclome, husbandman 7
5015582 2361443 2361443 defendant Midlam Robert husbandman 835412 835412 Midlam, Robert, of Tolesby, husbandman 8
5015583 2361443 2361443 defendant Atkynson William husbandman 835412 835412 Atkynson, William, of Tolesby, husbandman 9
5015584 2361443 2361443 defendant Ingelby John husbandman 835412 835412 Ingelby, John, of Tolesby, husbandman 10
5015585 2361443 2361443 defendant Bulloke John husbandman 835412 835412 Bulloke, John, of Tolesby, husbandman 11
5015586 2361443 2361443 defendant Browne William husbandman 589133 589133 Browne, William, of Marton, husbandman 12
5015587 2361443 2361443 defendant Riche William husbandman 589133 589133 Riche, William, of Marton, husbandman 13
5015588 2361443 2361443 defendant Hewet John husbandman 835413 835413 Hewet, John, of Leventhorpe, husbandman 14
5015589 2361443 2361443 defendant Lege Robert husbandman 835414 835414 Lege, Robert, of Harsom, husbandman 15
5015590 2361443 2361443 defendant Horneld John husbandman 835415 835415 Horneld, John, of Mideleburgh, husbandman 16
5015591 2361443 2361443 defendant Cogney William husbandman 835413 835413 Cogney, William, of Leventhorpe, husbandman 17
5015592 2361443 2361443 defendant Hewet Robert husbandman 835414 835414 Hewet, Robert, of Harsom, husbandman 18
5015593 2361443 2361443 defendant Colyn Thomas husbandman 835414 835414 Colyn, Thomas, of Harsom, husbandman 19
5015594 2361443 2361443 defendant Wilson Robert husbandman 787691 787691 Wilson, Robert, of Stanesby, husbandman 20
5015595 2361443 2361443 defendant Barett Robert husbandman 589744 589744 Barett, Robert, of Thormondby, husbandman 21
5015596 2361443 2361443 defendant Esshedal Thomas husbandman 589744 589744 Esshedal, Thomas, of Thormondby, husbandman 22
5015597 2361443 2361443 defendant Wode John yeoman 835416 835416 Wode, John, of Gyseborn, yeoman 23
5015598 2361443 2361443 defendant Horneld William husbandman 595315 595315 Horneld, William, of Ormesby, husbandman 24
5015599 2361443 2361443 defendant Megotson William husbandman 595315 595315 Megotson, William, of Ormesby, husbandman 25

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