names

18 rows where case_id = 2381462

✎ 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
5083124 2381462 2381462 plaintiff Est Robert esq   Est, Robert, esq 0
5083125 2381462 2381462 defendant Blake John cordwainer 597515 597515 Blake, John, of Maideston, Kent, cordwainer 0
5083126 2381462 2381462 defendant Degon James cordwainer 588508 588508 Degon, James, of Maideston, cordwainer 1
5083127 2381462 2381462 defendant Chaloner Richard crdwainer 588508 588508 Chaloner, Richard, of Maideston, crdwainer 2
5083128 2381462 2381462 defendant Dene Richard tailor 588508 588508 Dene, Richard, of Maideston, tailor 3
5083129 2381462 2381462 defendant Reve Robert baker 588508 588508 Reve, Robert, of Maideston, baker 4
5083130 2381462 2381462 defendant Wode Richard chapman 588508 588508 Wode, Richard, of Maideston, chapman 5
5083131 2381462 2381462 defendant Frende Nicholas laborer 588508 588508 Frende, Nicholas, of Maideston, laborer 6
5083132 2381462 2381462 defendant Maynerd Richard shoemaker 588508 588508 Maynerd, Richard, of Maideston, shoemaker 7
5083133 2381462 2381462 defendant atte Hyll John tailor 588508 588508 atte Hyll, John, of Maideston, tailor 8
5083134 2381462 2381462 defendant Whitehed Thomas laborer 595518 595518 Whitehed, Thomas, of Smerden, Kent, laborer 9
5083135 2381462 2381462 defendant Bayman Thomas laborer 844338 844338 Bayman, Thomas, of Hedrcon, Kent, laborer 10
5083136 2381462 2381462 defendant Turnoure John weaver 595775 595775 Turnoure, John,of Hedcron, weaver 11
5083137 2381462 2381462 defendant Baille Thomas fletcher 595775 595775 Baille, Thomas, of Hedcron, fletcher 12
5083138 2381462 2381462 defendant Roger Stephen husbandman 589076 589076 Roger, Stephen, of Smerden, husbandman 13
5083139 2381462 2381462 defendant Elys Thomas husbandman 589076 589076 Elys, Thomas, of Smerden, husbandman 14
5083140 2381462 2381462 defendant Brechelond Richard husbandman 603962 603962 Brechelond, Richard, of Horsmonden, Kent, husbandman 15
5083141 2381462 2381462 defendant Haweter William baker 844339 844339 Haweter, William, of Houghtfeld, Kent, baker 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);