names

20 rows where case_id = 2314400

✎ 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
4859678 2314400 2314400 plaintiff Caunsfeld Thomas clerk   Caunsfeld, Thomas, clerk 0
4859679 2314400 2314400 defendant Goldyng Thomas husbandman 590725 590725 Goldyng, Thomas, of Ellerker, husbandman 0
4859680 2314400 2314400 defendant Bee Nicholas husbandman 600457 600457 Bee, Nicholas, of Malton, husbandman 1
4859681 2314400 2314400 defendant Mapleton Agnes brewster 589274 589274 Mapleton, Agnes, of Cotyngham, brewster 2
4859682 2314400 2314400 defendant Barbour Thomas barber 813905 813905 Barbour, Thomas, of Coytyngham, barber 3
4859683 2314400 2314400 defendant Waldeby Thomas gent 796926 796926 Waldeby, Thomas, of Waldeby, gent 4
4859684 2314400 2314400 defendant Boythorp Richard husbandman 589626 589626 Boythorp, Richard, of Walkyngton, husbandman 5
4859685 2314400 2314400 defendant Ruland Richard husbandman 589626 589626 Ruland, Richard, of Walkyngton, husbandman 6
4859686 2314400 2314400 defendant Frank Richard husbandman 779195 779195 Frank, Richard, of Skipse, husbandman 7
4859687 2314400 2314400 defendant Saunderson William yeoman 585932 585932 Saunderson, William, of Kingston on Hull, yeoman 8
4859688 2314400 2314400 defendant Holym John vicar of Hoton   Holym, John, vicar of Hoton 9
4859689 2314400 2314400 defendant Deye William   586070 586070 Deye, William, of Beverley, coverlet weaver 10
4859690 2314400 2314400 defendant Dete Cecily widow 586070 586070 Dete, Cecily, of Beverley, widow 11
4859691 2314400 2314400 defendant Geffreyson William yeoman 779195 779195 Geffreyson, William, of Skipse, yeoman 12
4859692 2314400 2314400 defendant Houell John yeoman 586070 586070 Houell, John, of Beverley, yeoman 13
4859693 2314400 2314400 defendant Gylmyn Richard carter 586070 586070 Gylmyn, Richard, of Beverley, carter 14
4859694 2314400 2314400 defendant Stirton John husbandman 688233 688233 Stirton, John, of Chery Burton, husbandman 15
4859695 2314400 2314400 defendant Yong Robert shipman 585932 585932 Yong, Robert, of Kingston on Hull, shipman 16
4859696 2314400 2314400 defendant Goddesbroke Thomas gent 595178 595178 Goddesbroke, Thomas, of Weton, gent 17
4859697 2314400 2314400 defendant Cokerell William gent 586070 586070 Cokerell, William, of Beverley, gent 18

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