names

25 rows where case_id = 2471662

✎ 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
5388120 2471662 2471662 plaintiff Godeman Richard     Godeman, Richard 0
5388121 2471662 2471662 defendant Bolde Robert   881680 881680 Bolde, Robert, of Dokdyke, in Byllyngay 0
5388122 2471662 2471662 defendant Drory John laborer 610967 610967 Drory, John, of Byllyngay, laborer 1
5388123 2471662 2471662 defendant Pope Thomas laborer 601614 601614 Pope, Thomas, of Tymberland, laborer 2
5388124 2471662 2471662 defendant _reny John laborer 680318 680318 _reny, John, of Timberland, laborer 3
5388125 2471662 2471662 defendant Hall William laborer 601614 601614 Hall, William, of Tymberland, laborer 4
5388126 2471662 2471662 defendant Andrewe John laborer 590373 590373 Andrewe, John, of Wodehall, laborer 5
5388127 2471662 2471662 defendant Fyssher (illegible) laborer 590003 590003 Fyssher, _, of Tateshale, laborer 6
5388128 2471662 2471662 defendant Davy John laborer 587435 587435 Davy, John, of Conyngesby, laborer 7
5388129 2471662 2471662 defendant Whelewright William laborer 881681 881681 Whelewright, William, of Dok_ in Byllyngay, laborer 8
5388130 2471662 2471662 defendant S__ Robert laborer 881682 881682 S__, Robert, of in Byllyngay, laborer 9
5388131 2471662 2471662 defendant Chaterton Thomas husbandman 604585 604585 Chaterton, Thomas, of Eveden, husbandman 10
5388132 2471662 2471662 defendant Be__ Alexander husbandman 701238 701238 Be__, Alexander, of Byllingay, husbandman 11
5388133 2471662 2471662 defendant Collyn John husbandman 624949 624949 Collyn, John, of Asgarby, husbandman 12
5388134 2471662 2471662 defendant Chamberleyn William husbandman 881683 881683 Chamberleyn, William, of Amwyke, husbandman 13
5388135 2471662 2471662 defendant Chamberleyn Thomas husbandman 881683 881683 Chamberleyn, Thomas, of Amwyke, husbandman 14
5388136 2471662 2471662 defendant Faukoner Robert husbandman 881683 881683 Faukoner, Robert, of Amwyke, husbandman 15
5388137 2471662 2471662 defendant Drury Andrew laborer 596436 596436 Drury, Andrew, of Swyneshede, laborer 16
5388138 2471662 2471662 defendant Fyssher John laborer 596436 596436 Fyssher, John, of Swyneshede, laborer 17
5388139 2471662 2471662 defendant Hardylsey John dyer 612744 612744 Hardylsey, John, of Cunsby, dyer 18
5388140 2471662 2471662 defendant Deny John husbandman 612744 612744 Deny, John, of Cunsby, husbandman 19
5388141 2471662 2471662 defendant Pyarson John   612744 612744 Pyarson, John, of Cunsby 20
5388142 2471662 2471662 defendant Mason William laborer 601614 601614 Mason, William, of Tymberland, laborer 21
5388143 2471662 2471662 defendant Baweme William laborer 612744 612744 Baweme, William, of Cunsby, laborer 22
5388144 2471662 2471662 defendant another of Timberland laborer   another, of Timberland, laborer 23

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