names

26 rows where case_id = 2330494

✎ 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
4912763 2330494 2330494 plaintiff Chamberleyn John yeoman 637598 637598 Chamberleyn, John, of Quemerford, yeoman 0
4912764 2330494 2330494 plaintiff Andrewe Thomas yeoman 593968 593968 Andrewe, Thomas, of Calne, yeoman 1
4912765 2330494 2330494 plaintiff Corvyser Thomas shoemaker 619381 619381 Corvyser, Thomas, of Lacok, shoemaker 2
4912766 2330494 2330494 plaintiff Corvyser Peter-servant-of-Thomas   619381 619381 Corvyser, Peter-servant-of-Thomas, of Lacok, servant 3
4912767 2330494 2330494 plaintiff Okeburn John yeoman 821003 821003 Okeburn, John, of Baweld, yeoman 4
4912768 2330494 2330494 plaintiff Palfrayman Thomas   589669 589669 Palfrayman, Thomas, of Bathe, Soms, servant 5
4912769 2330494 2330494 plaintiff Godewyn Robert yeoman 594261 594261 Godewyn, Robert, of Bathe, yeoman 6
4912770 2330494 2330494 plaintiff Yonge John baker 594261 594261 Yonge, John, of Bathe, baker 7
4912771 2330494 2330494 plaintiff Erlestoke Roger chaplain 593796 593796 Erlestoke, Roger, of Salisbury, Wilts, chaplain 8
4912772 2330494 2330494 plaintiff Barbour Robert tailor 593968 593968 Barbour, Robert, of Calne, tailor 9
4912773 2330494 2330494 plaintiff Chubbe Thomas laborer 693677 693677 Chubbe, Thomas, of Corsham, laborer 10
4912774 2330494 2330494 plaintiff Fenne John husbandman 598486 598486 Fenne, John, of Chippenham, husbandman 11
4912775 2330494 2330494 plaintiff Harryes John woolmonger 598486 598486 Harryes, John, of Chippenham, woolmonger 12
4912776 2330494 2330494 plaintiff Morys John yeoman 637598 637598 Morys, John, of Quemerford, yeoman 13
4912777 2330494 2330494 plaintiff Sever Geoffrey weaver 596561 596561 Sever, Geoffrey, of Bath, Soms, weaver 14
4912778 2330494 2330494 plaintiff Fabell John husbandman 648683 648683 Fabell, John, of Sandrygge, husbandman 15
4912779 2330494 2330494 plaintiff Russell Richard weaver 821005 821005 Russell, Richard, of Boveden, weaver 16
4912780 2330494 2330494 plaintiff Warneden Henry husbandman 754430 754430 Warneden, Henry, of Bovenden, husbandman 17
4912781 2330494 2330494 plaintiff Touker William burcher 633918 633918 Touker, William, of Poterne, burcher 18
4912782 2330494 2330494 plaintiff Sexteyn William yeoman 619381 619381 Sexteyn, William, of Lacok, yeoman 19
4912783 2330494 2330494 plaintiff Forthay Henry husbandman 821007 821007 Forthay, Henry, of Stanle, husbandman 20
4912784 2330494 2330494 plaintiff Wymbalde John husbandman 777495 777495 Wymbalde, John, of Natton, husbandman 21
4912785 2330494 2330494 plaintiff Godgray John yeoman 592967 592967 Godgray, John, of Chitterne, yeoman 22
4912786 2330494 2330494 plaintiff Scotte Walter husbandman 619381 619381 Scotte, Walter, of Lacok, husbandman 23
4912787 2330494 2330494 plaintiff Fetche John husbandman 821008 821008 Fetche, John, of Woderowe, husbandman 24
4912788 2330494 2330494 defendant Plantagenet or Lancaster Humphrey   806571 806571 Plantagenet or Lancaster, Humphrey, of Gloucester, Duke 0

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