names

24 rows where case_id = 2499167

✎ 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
5480603 2499167 2499167 plaintiff Denne William     Denne, William 0
5480604 2499167 2499167 defendant Mundes Thomas yeoman 607912 607912 Mundes, Thomas, of Brandon juxta Barnhambrome, yeoman 0
5480605 2499167 2499167 defendant Southed Thomas baker 586940 586940 Southed, Thomas, of Baldeswell, baker 1
5480606 2499167 2499167 defendant Cely John brasier 585936 585936 Cely, John, of Norwich, brasier 2
5480607 2499167 2499167 defendant Recok John, senior husbandman 586471 586471 Recok, John, senior, of Aylesham, husbandman 3
5480608 2499167 2499167 defendant Colles Barholomew chapman 587167 587167 Colles, Barholomew, of Parva Walsyngham, chapman 4
5480609 2499167 2499167 defendant Swenyn Nicholas smith 586471 586471 Swenyn, Nicholas, of Aylesham, smith 5
5480610 2499167 2499167 defendant Celers Thomas husbandman 590844 590844 Celers, Thomas, of Lyng, husbandman 6
5480611 2499167 2499167 defendant Lynne John husbandman 630844 630844 Lynne, John, of Tyteleshale, husbandman 7
5480612 2499167 2499167 defendant Verdon Nicholas shoemaker 589042 589042 Verdon, Nicholas, of Heydon, shoemaker 8
5480613 2499167 2499167 defendant Crome John yeoman 590504 590504 Crome, John, of Billyngford, yeoman 9
5480614 2499167 2499167 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 10
5480615 2499167 2499167 defendant Boteld Thomas husbandman 592833 592833 Boteld, Thomas, of Wakton, husbandman 11
5480616 2499167 2499167 defendant Harryson John   586396 586396 Harryson, John, of Yaxham, mason 12
5480617 2499167 2499167 defendant Phyppys Richard yeoman 588926 588926 Phyppys, Richard, of North Elmham, yeoman 13
5480618 2499167 2499167 defendant Styward John tailor 589042 589042 Styward, John, of Heydon, tailor 14
5480619 2499167 2499167 defendant Chynchebald William yeoman 591456 591456 Chynchebald, William, of Feltwell, yeoman 15
5480620 2499167 2499167 defendant Myles Thomas   586102 586102 Myles, Thomas, of Hengham, mason 16
5480621 2499167 2499167 defendant Hervy John husbandman 593987 593987 Hervy, John, of Gunthorp, husbandman 17
5480622 2499167 2499167 defendant Fuller Robert husbandman 590965 590965 Fuller, Robert, of Hyndolneston, husbandman 18
5480623 2499167 2499167 defendant Style Robert clerk   Style, Robert, clerk, executor of 19
5480624 2499167 2499167 defendant Hyrne or Hyrve Robert chaplain 605275 605275 Hyrne or Hyrve, Robert, of Thuxton, chaplain 20
5480625 2499167 2499167 defendant Grene Thomas (legal representative) 588926 588926 Grene, Thomas, of North Elmham, yeoman, administratrix of 21
5480626 2499167 2499167 defendant Grene Agnes widow 588926 588926 Grene, Agnes, of North Elmham, widow 22

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