names

18 rows where case_id = 2473541

✎ 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
5394672 2473541 2473541 plaintiff Wolman Thomas gent 585936 585936 Wolman, Thomas, of Norwich, gent, on his own account 0
5394673 2473541 2473541 defendant Dukworth Eliis yeoman   Dukworth, Eliis, yeoman 0
5394674 2473541 2473541 defendant Purk Thomas yeoman 822047 822047 Purk, Thomas, of Wodebastewyk, yeoman 1
5394675 2473541 2473541 defendant Parswyk   yeoman   _, Parswyk, yeoman 2
5394676 2473541 2473541 defendant Yermouth (illegible) beerbrewer 593814 593814 Yermouth, _, of Sporle, beerbrewer 3
5394677 2473541 2473541 defendant Sporle Robert husbandman 586714 586714 Sporle, Robert, of Hempnale, husbandman 4
5394678 2473541 2473541 defendant (illegible) of Baldeswell baker   _, of Baldeswell, baker 5
5394679 2473541 2473541 defendant Sprotte Adam husbandman 882598 882598 Sprotte, Adam, of Great Plu_, husbandman 6
5394680 2473541 2473541 defendant Caster Robert engraver 585936 585936 Caster, Robert, of Norwich, engraver 7
5394681 2473541 2473541 defendant Cokkys John smith 587166 587166 Cokkys, John, of Salle, smith 8
5394682 2473541 2473541 defendant Carter John husbandman 591070 591070 Carter, John, of Refham, husbandman 9
5394683 2473541 2473541 defendant Reed Robert husbandman 594582 594582 Reed, Robert, of Whitewell, husbandman 10
5394684 2473541 2473541 defendant Plumbe Thomas husbandman 587836 587836 Plumbe, Thomas, of Folsham, husbandman 11
5394685 2473541 2473541 defendant Forwell William yeoman 588849 588849 Forwell, William, of North Tudenham, yeoman 12
5394686 2473541 2473541 defendant Erle Robert husbandman 870217 870217 Erle, Robert, of Carleton Forowe, husbandman 13
5394687 2473541 2473541 defendant Pedder John woolman 615449 615449 Pedder, John, of Waterden, woolman 14
5394688 2473541 2473541 defendant Asshman Richard grocer 585936 585936 Asshman, Richard, of Norwich, grocer 15
5394689 2473541 2473541 defendant Est Peter yeoman 871395 871395 Est, Peter, of Wythyngham St Mary, yeoman 16

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