names

36 rows where case_id = 2470725

✎ 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
5384754 2470725 2470725 plaintiff Brampton Thomas     Brampton, Thomas, on his own account 0
5384755 2470725 2470725 defendant Neuman William husbandman 595014 595014 Neuman, William, of South Reppys, husbandman 0
5384756 2470725 2470725 defendant Heyward Thomas husbandman 781771 781771 Heyward, Thomas, of Beston by Milham, husbandman 1
5384757 2470725 2470725 defendant Stacy Robert husbandman 764913 764913 Stacy, Robert, of Fakynham, husbandman 2
5384758 2470725 2470725 defendant Toly Robert laborer 611520 611520 Toly, Robert, of Bryston, laborer 3
5384759 2470725 2470725 defendant Pepyr William yeoman 587172 587172 Pepyr, William, of East Derham, yeoman 4
5384760 2470725 2470725 defendant Glover Thomas butcher 596744 596744 Glover, Thomas, of Crowmer, butcher 5
5384761 2470725 2470725 defendant Fraunceys Adam husbandman 881211 881211 Fraunceys, Adam, of Crostwheyte, husbandman 6
5384762 2470725 2470725 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 7
5384763 2470725 2470725 defendant Batche William husbandman 589625 589625 Batche, William, of Betelee, husbandman 8
5384764 2470725 2470725 defendant Tircok John husbandman 587935 587935 Tircok, John, of Colby, husbandman 9
5384765 2470725 2470725 defendant Salman William husbandman 589927 589927 Salman, William, of Paston, husbandman 10
5384766 2470725 2470725 defendant Kede Thomas husbandman 586471 586471 Kede, Thomas, of Aylesham, husbandman 11
5384767 2470725 2470725 defendant Godfrey John husbandman 641532 641532 Godfrey, John, of Potter Heigham, husbandman 12
5384768 2470725 2470725 defendant Whyte William husbandman 590409 590409 Whyte, William, of Costessey, husbandman 13
5384769 2470725 2470725 defendant Trendyll Thomas husbandman 611830 611830 Trendyll, Thomas, of Bylney, husbandman 14
5384770 2470725 2470725 defendant Wattys Thomas laborer 587166 587166 Wattys, Thomas, of Salle, laborer 15
5384771 2470725 2470725 defendant Kelyngham William husbandman 589689 589689 Kelyngham, William, of Hornyng, husbandman 16
5384772 2470725 2470725 defendant Plumbe Thomas husbandman 587836 587836 Plumbe, Thomas, of Folsham, husbandman 17
5384773 2470725 2470725 defendant Platfote Walter husbandman 605070 605070 Platfote, Walter, of Shipdham, husbandman 18
5384774 2470725 2470725 defendant Phipys Richard husbandman 588926 588926 Phipys, Richard, of North Elmham, husbandman 19
5384775 2470725 2470725 defendant Gowty Thomas husbandman 598083 598083 Gowty, Thomas, of Ketylston, husbandman 20
5384776 2470725 2470725 defendant Rede Robert miller 591070 591070 Rede, Robert, of Refham, miller 21
5384777 2470725 2470725 defendant Emondys William yeoman 586471 586471 Emondys, William, of Aylesham, yeoman 22
5384778 2470725 2470725 defendant Jekkys Clement husbandman 586471 586471 Jekkys, Clement, of Aylesham, husbandman 23
5384779 2470725 2470725 defendant Tylly Henry husbandman 586471 586471 Tylly, Henry, of Aylesham, husbandman 24
5384780 2470725 2470725 defendant Kerre William husbandman 647985 647985 Kerre, William, of Hyndyngham, husbandman 25
5384781 2470725 2470725 defendant Okys Alexander husbandman 621099 621099 Okys, Alexander, of Hevyngham, husbandman 26
5384782 2470725 2470725 defendant Taverham Thomas gent 587166 587166 Taverham, Thomas, of Salle, gent 27
5384783 2470725 2470725 defendant Elvered John husbandman 586471 586471 Elvered, John, of Aylesham, husbandman 28
5384784 2470725 2470725 defendant Clerk Adam   595014 595014 Clerk, Adam, of South Reppys, yeoman, administrators 29
5384785 2470725 2470725 defendant Clerk John husbandman 595014 595014 (Clerk, John, of South Reppys, husbandman 30
5384786 2470725 2470725 defendant Clerk Joan     Joan, his wife 31
5384787 2470725 2470725 defendant Langwade Thomas (legal representative) 611520 611520 Langwade, Thomas, of Bryston, yeoman, administrator of John Bryston, of Bryston, senior, esq, executors of 32
5384788 2470725 2470725 defendant Langewade John yeoman 611520 611520 (Langewade, John, of Bryston, yeoman 33
5384789 2470725 2470725 defendant Lanwade Marion widow 611520 611520 Lanwade, Marion, of Bryston, widow 34

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