names

17 rows where case_id = 2441233

✎ 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
5287079 2441233 2441233 plaintiff Ingelby Joan widow of Ingelby, William, knight   Ingelby, Joan, widow of Ingelby, William, knight 0
5287080 2441233 2441233 defendant Thwattes Thomas gent 592497 592497 Thwattes, Thomas, of Marston, gent 0
5287081 2441233 2441233 defendant Chase Thomas gent 608901 608901 Chase, Thomas, of Esyngwold, gent 1
5287082 2441233 2441233 defendant Ruddyng Thomas yeoman 592497 592497 Ruddyng, Thomas, of Marston, yeoman 2
5287083 2441233 2441233 defendant Hill Henry husbandman 592497 592497 Hill, Henry, of Marston, husbandman 3
5287084 2441233 2441233 defendant Ase William tailor 592497 592497 Ase, William, of Marston, tailor 4
5287085 2441233 2441233 defendant Elleson William husbandman 592497 592497 Elleson, William, of Marston, husbandman 5
5287086 2441233 2441233 defendant Watson William laborer 592497 592497 Watson, William, of Marston, laborer 6
5287087 2441233 2441233 defendant Thomon William laborer 592497 592497 Thomon, William, of Marston, laborer 7
5287088 2441233 2441233 defendant Broune Thomas laborer 592497 592497 Broune, Thomas, of Marston, laborer 8
5287089 2441233 2441233 defendant Graver or Graner Robert   868841 868841 Graver or Graner, Robert, of Cattaö 9
5287090 2441233 2441233 defendant Rassh Edmund   593852 593852 Rassh, Edmund, of Wysbech, Cams, mason 10
5287091 2441233 2441233 defendant Deye Richard husbandman 586231 586231 Deye, Richard, of Wygenhale, husbandman 11
5287092 2441233 2441233 defendant Martyn William husbandman 818405 818405 Martyn, William, of Dounhamhithe, husbandman 12
5287093 2441233 2441233 defendant Broke Thomas husbandman 588580 588580 Broke, Thomas, of West Walton, husbandman 13
5287094 2441233 2441233 defendant Barton John yeoman 868740 868740 Barton, John, of Ceranehous, yeoman 14
5287095 2441233 2441233 defendant Barker William yeoman 587414 587414 Barker, William, of Thetford, yeoman 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);