names

17 rows where case_id = 2330019

✎ 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
4911220 2330019 2330019 plaintiff Brigge John     Brigge, John 0
4911221 2330019 2330019 defendant Mayre Richard shipman 586070 586070 Mayre, Richard, of Beverley, shipman 0
4911222 2330019 2330019 defendant Rust Peter husbandman 820714 820714 Rust, Peter, of Stonfery, husbandman 1
4911223 2330019 2330019 defendant Comyn John husbandman 590488 590488 Comyn, John, of Northcave, husbandman 2
4911224 2330019 2330019 defendant Fouler Richard yeoman 796926 796926 Fouler, Richard, of Waldeby, yeoman 3
4911225 2330019 2330019 defendant Burgeys John weaver 586070 586070 Burgeys, John, of Beverley, weaver 4
4911226 2330019 2330019 defendant Serieant John cooper 586070 586070 Serieant, John, of Beverley, cooper 5
4911227 2330019 2330019 defendant Colynson Thomas husbandman 610443 610443 Colynson, Thomas, of Pokelyngton, husbandman 6
4911228 2330019 2330019 defendant del Forge Thomas husbandman 622943 622943 del Forge, Thomas, of Hayton, husbandman 7
4911229 2330019 2330019 defendant atte Marre William husbandman 610116 610116 atte Marre, William, of Baynton, husbandman 8
4911230 2330019 2330019 defendant Betenson William husbandman 610116 610116 Betenson, William, of Baynton, husbandman 9
4911231 2330019 2330019 defendant Gargrave John walker 586070 586070 Gargrave, John, of Beverley, walker 10
4911232 2330019 2330019 defendant Garthom John   589626 589626 Garthom, John, of Walkyngton, plough wright 11
4911233 2330019 2330019 defendant Boythorp Alice widow 589626 589626 Boythorp, Alice, of Walkyngton, widow 12
4911234 2330019 2330019 defendant HIlton John   608901 608901 HIlton, John, of Esyngwold, vicar 13
4911235 2330019 2330019 defendant Boles Richard chapman 635741 635741 Boles, Richard, of Beverely, chapman 14
4911236 2330019 2330019 defendant Lovell John dyer 586070 586070 Lovell, John, of Beverley, dyer 15

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