names

33 rows where case_id = 2420890

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5217602 2420890 2420890 plaintiff Flynche John     Flynche, John 0
5217603 2420890 2420890 defendant Burgoyn Thomas gent 668173 668173 Burgoyn, Thomas, of Uherst, gent 0
5217604 2420890 2420890 defendant Scrase John gent 860450 860450 Scrase, John, of Burgarsshe, gent 1
5217605 2420890 2420890 defendant Pyppesden Robert husbandman 586921 586921 Pyppesden, Robert, of Saleherst, husbandman 2
5217606 2420890 2420890 defendant Rede William husbandman 586921 586921 Rede, William, of Saleherst, husbandman 3
5217607 2420890 2420890 defendant Mevefyn or Meuefyn Henry gent 585988 585988 Mevefyn or Meuefyn, Henry, of Hethfeld, gent 4
5217608 2420890 2420890 defendant Border John husbandman 592116 592116 Border, John, of Echyngham, husbandman 5
5217609 2420890 2420890 defendant Martyn Thomas husbandman 598060 598060 Martyn, Thomas, of Westfeld, husbandman 6
5217610 2420890 2420890 defendant Lucas John husbandman 611766 611766 Lucas, John, of Battle, husbandman 7
5217611 2420890 2420890 defendant Wychard John husbandman 788645 788645 Wychard, John, of Bekle, husbandman 8
5217612 2420890 2420890 defendant Brabon Robert husbandman 586921 586921 Brabon, Robert, of Saleherst, husbandman 9
5217613 2420890 2420890 defendant Waterman Richard husbandman 588739 588739 Waterman, Richard, of Tyseherst, husbandman 10
5217614 2420890 2420890 defendant Tomset Robert husbandman 586921 586921 Tomset, Robert, of Saleherst, husbandman 11
5217615 2420890 2420890 defendant Colebronde Thomas gent 589163 589163 Colebronde, Thomas, of Boreham, gent 12
5217616 2420890 2420890 defendant Tomset William husbandman 586921 586921 Tomset, William, of Saleherst, husbandman 13
5217617 2420890 2420890 defendant Brasse Thomas husbandman 668173 668173 Brasse, Thomas, of Uherst, husbandman 14
5217618 2420890 2420890 defendant Vynawe Thomas husbandman 598060 598060 Vynawe, Thomas, of Westfeld, husbandman 15
5217619 2420890 2420890 defendant Alard Robert husbandman 594983 594983 Alard, Robert, of Gestlyng, husbandman 16
5217620 2420890 2420890 defendant Oxenbrygge George gent 668173 668173 Oxenbrygge, George, of Uherst, gent 17
5217621 2420890 2420890 defendant Ponteys John husbandman 594983 594983 Ponteys, John, of Gestlyng, husbandman 18
5217622 2420890 2420890 defendant Anneston William husbandman 762542 762542 Anneston, William, of Nenefeld, husbandman 19
5217623 2420890 2420890 defendant Lyvet Richard husbandman 646479 646479 Lyvet, Richard, of Holynton, husbandman 20
5217624 2420890 2420890 defendant Broun John husbandman 598060 598060 Broun, John, of Westfeld, husbandman 21
5217625 2420890 2420890 defendant Penherst Richard gent 686458 686458 together with Penherst, Richard, of Penherst, gent 22
5217626 2420890 2420890 defendant Norton John husbandman 860450 860450 Norton, John, of Burgarsshe, husbandman 23
5217627 2420890 2420890 defendant Burhham Richard husbandman 586921 586921 Burhham, Richard, of Saleherst, husbandman 24
5217628 2420890 2420890 defendant Sherman John husbandman 860450 860450 Sherman, John, of Burgarsshe, husbandman 25
5217629 2420890 2420890 defendant at Mille Robert husbandman 589163 589163 at Mille, Robert, of Boreham, husbandman 26
5217630 2420890 2420890 defendant at Wode Robert husbandman 589577 589577 at Wode, Robert, of Warbelton, husbandman 27
5217631 2420890 2420890 defendant Hamond William husbandman 588739 588739 Hamond, William, of Tyseherst, husbandman 28
5217632 2420890 2420890 defendant Bysshop Alexander husbandman 758081 758081 Bysshop, Alexander, of Sedelescombe, husbandman 29
5217633 2420890 2420890 defendant Beche Richard husbandman 636342 636342 Beche, Richard, of Sedelyscombe, husbandman 30
5217634 2420890 2420890 defendant Pertryche John husbandman 621614 621614 Pertryche, John, of Northyham, husbandman 31

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