names

17 rows where case_id = 2306275

✎ 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
4832776 2306275 2306275 plaintiff Caunsfeld Thomas clerk   Caunsfeld, Thomas, clerk 0
4832777 2306275 2306275 defendant Howell John yeoman 586070 586070 Howell, John, of Beverley, yeoman 0
4832778 2306275 2306275 defendant Dey William   586070 586070 Dey, William, of Beverley, coverlet weaver 1
4832779 2306275 2306275 defendant Gylmyn Richard carter 809609 809609 Gylmyn, Richard, of Beverlry, carter 2
4832780 2306275 2306275 defendant Stirton John husbandman 688233 688233 Stirton, John, of Chery Burton, husbandman 3
4832781 2306275 2306275 defendant Richardson Richard husbandman 651194 651194 Richardson, Richard, of Wetwange, husbandman 4
4832782 2306275 2306275 defendant Huton John   809610 809610 together with Huton, John, of Holyn, vicar 5
4832783 2306275 2306275 defendant Saunderson William husbandman 603528 603528 Saunderson, William, of Kyngeston upon Hull, husbandman 6
4832784 2306275 2306275 defendant Frank Richard   765786 765786 Frank, Richard, of Skypse, wright 7
4832785 2306275 2306275 defendant Heryng John   809611 809611 together with Heryng, John, of Frereby, cosour 8
4832786 2306275 2306275 defendant Goldyng Thomas husbandman 589626 589626 Goldyng, Thomas, of Walkyngton, husbandman 9
4832787 2306275 2306275 defendant Ruland Richard husbandman 589626 589626 Ruland, Richard, of Walkyngton, husbandman 10
4832788 2306275 2306275 defendant Barbour Thomas barber 589274 589274 together with Barbour, Thomas, of Cotyngham, barber 11
4832789 2306275 2306275 defendant Goddysbroke Thomas gent 595178 595178 Goddysbroke, Thomas, of Weton, gent 12
4832790 2306275 2306275 defendant Olyver William husbandman 763187 763187 Olyver William, of Skydby, husbandman 13
4832791 2306275 2306275 defendant Padley William tailor 586070 586070 Padley, William, of Beverley, tailor 14
4832792 2306275 2306275 defendant Toke William merchant 603528 603528 Toke, William, of Kyngeston upon Hull, merchant 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);