names

11 rows where case_id = 2463249

✎ 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
5360262 2463249 2463249 plaintiff Selwood John abbot of Glastonbury Abbey   Selwood, John, abbot of Glastonbury Abbey 0
5360263 2463249 2463249 defendant Fulbroke John   877462 877462 Fulbroke, John, of Pylton, gebnt 0
5360264 2463249 2463249 defendant Brytte William gent 594166 594166 Brytte, William, of Charleton Makerell, gent 1
5360265 2463249 2463249 defendant Dore John carpenter 586813 586813 Dore, John, of Pylton, carpenter 2
5360266 2463249 2463249 defendant Robyns William husbandman 597393 597393 Robyns, William, of Est Pennard, husbandman 3
5360267 2463249 2463249 defendant Gatcote William, junior tailor 586813 586813 Gatcote, William, junior, of Pylton, tailor 4
5360268 2463249 2463249 defendant Druet John husbandman 597393 597393 Druet, John, of Est Pennard, husbandman 5
5360269 2463249 2463249 defendant Druet John   877463 877463 Druet, John, of Est Pennard, scholar 6
5360270 2463249 2463249 defendant Wareyn Richard yeoman 597393 597393 Wareyn, Richard, of Est Pennard, yeoman 7
5360271 2463249 2463249 defendant Forest Richard smith 586813 586813 Forest, Richard, of Pylton, smith 8
5360272 2463249 2463249 defendant Pury John   702289 702289 Pury, John, of Evercriche, "helyer" 9

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