names

13 rows where case_id = 2096029

✎ 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
4201359 2096029 2096029 plaintiff Hyde Thomas gent   Hyde, Thomas, gent 0
4201360 2096029 2096029 defendant Dalabere Thomas gent 594989 594989 Dalabere, Thomas, of Tyberton, gent 0
4201361 2096029 2096029 defendant Dalabere Kenard, junior gent 594989 594989 Dalabere, Kenard, junior, of Tyberton, gent 1
4201362 2096029 2096029 defendant Dalabere Jane spinster 594989 594989 Dalabere, Jane, of Tyberton, spinster 2
4201363 2096029 2096029 defendant Flecher Richard yeoman 586208 586208 Flecher, Richard, of Hereford, yeoman 3
4201364 2096029 2096029 defendant Wynhall John yeoman 666271 666271 Wynhall, John, of Allensmore, yeoman 4
4201365 2096029 2096029 defendant Dalabere George gent 593413 593413 Dalabere, George, of Alensmore, gent 5
4201366 2096029 2096029 defendant Heake Nicholas gent 653251 653251 Heake, Nicholas, of Clehunger, gent 6
4201367 2096029 2096029 defendant Brempton John yeoman 593413 593413 Brempton, John, of Alensmore, yeoman 7
4201368 2096029 2096029 defendant Gwynne Meredith laborer 600182 600182 Gwynne, Meredith, of Dorston, laborer 8
4201369 2096029 2096029 defendant Baggote Thomas husbandman 611525 611525 Baggote, Thomas, of Yarkehill, husbandman 9
4201370 2096029 2096029 defendant Baggotte James husbandman 617252 617252 Baggotte, James, of Breynton, husbandman 10
4201371 2096029 2096029 defendant Albey James husbandman 653251 653251 Albey, James, of Clehunger, husbandman 11

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