names

15 rows where case_id = 2429761

✎ 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
5248758 2429761 2429761 plaintiff Talbot Elizabeth Countess of Shrewsbury   Talbot, Elizabeth, Countess of Shrewsbury 0
5248759 2429761 2429761 defendant Gancell Robert gent 864006 864006 Gancell, Robert, of Belburgh, Derbs, gent 0
5248760 2429761 2429761 defendant Newebolt Thomas gent 806649 806649 Newebolt, Thomas, of Newebolt, Derbs, gent 1
5248761 2429761 2429761 defendant Chaumber Robert husbandman 864007 864007 Chaumber, Robert, of Belburgh, husbandman 2
5248762 2429761 2429761 defendant Jakes Robert husbandman 864007 864007 Jakes, Robert, of Belburgh, husbandman 3
5248763 2429761 2429761 defendant Jakes William husbandman 864007 864007 Jakes, William, of Belburgh, husbandman 4
5248764 2429761 2429761 defendant Pynder Hugh husbandman 622845 622845 Pynder, Hugh, of Ekyngton, Derbs, husbandman 5
5248765 2429761 2429761 defendant Smyth Robert, senior husbandman 604163 604163 Smyth, Robert, senior, of Ekyngton, husbandman 6
5248766 2429761 2429761 defendant Smyth Robert, junior husbandman 604163 604163 Smyth, Robert, junior, of Ekyngton, husbandman 7
5248767 2429761 2429761 defendant Dodyngton John husbandman 604163 604163 Dodyngton, John, of Ekyngton, husbandman 8
5248768 2429761 2429761 defendant Stafforth Henry smith 604163 604163 Stafforth, Henry, of Ekyngton, smith 9
5248769 2429761 2429761 defendant Mychell John husbandman 596660 596660 Mychell, John, of Whitwell, Derbs, husbandman 10
5248770 2429761 2429761 defendant Mychell Robert husbandman 595471 595471 Mychell, Robert, of Whitwell, husbandman 11
5248771 2429761 2429761 defendant Turnor Thomas husbandman 863795 863795 Turnor, Thomas, of Langwayth, Derbs, husbandman 12
5248772 2429761 2429761 defendant Robert Thomas yeoman 601298 601298 Robert, Thomas, of Tykhyll, Yorks, yeoman 13

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