names

18 rows where case_id = 2517270

✎ 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
5540843 2517270 2517270 plaintiff Howard Thomas Earl of Surrey   Howard, Thomas, Earl of Surrey 0
5540844 2517270 2517270 defendant Lane Richard, senior husbandman 595192 595192 Lane, Richard, senior, of Lee, husbandman 0
5540845 2517270 2517270 defendant Bromehed John yeoman 595192 595192 Bromehed, John, of Lee, yeoman 1
5540846 2517270 2517270 defendant Fuloflene John yeoman 595192 595192 Fuloflene, John, of Lee, yeoman 2
5540847 2517270 2517270 defendant Lane John, senior yeoman 595192 595192 Lane, John, senior, of Lee, yeoman 3
5540848 2517270 2517270 defendant Lane Richard, junior yeoman 595192 595192 Lane, Richard, junior, of Lee, yeoman 4
5540849 2517270 2517270 defendant Colman Richard yeoman 595192 595192 Colman, Richard, of Lee, yeoman 5
5540850 2517270 2517270 defendant Hadlyssey William yeoman 595192 595192 Hadlyssey, William, of Lee, yeoman 6
5540851 2517270 2517270 defendant Calvard Miles husbandman 595192 595192 Calvard, Miles, of Lee, husbandman 7
5540852 2517270 2517270 defendant Turgus Robert husbandman 586005 586005 Turgus, Robert, of Upton, husbandman 8
5540853 2517270 2517270 defendant Sawer Robert ofUpton, husbandman   Sawer, Robert, ofUpton, husbandman 9
5540854 2517270 2517270 defendant Jakson Thomas tailor 586005 586005 Jakson, Thomas, of Upton, tailor 10
5540855 2517270 2517270 defendant Bell Michael laborer 770665 770665 Bell, Michael, of Kesby, laborer 11
5540856 2517270 2517270 defendant Turnour John turner 770665 770665 Turnour, John, of Kesby, turner 12
5540857 2517270 2517270 defendant Mychell Thomas yeoman 770665 770665 Mychell, Thomas, of Kesby, yeoman 13
5540858 2517270 2517270 defendant Gawdyn John yeoman 697323 697323 Gawdyn, John, of Gateburton, yeoman 14
5540859 2517270 2517270 defendant Twyesday John yeoman 756487 756487 Twyesday, John, of Geynesburgh, yeoman 15
5540860 2517270 2517270 defendant Cleyton Robert yeoman 772884 772884 Cleyton, Robert, of Hepeham, yeoman 16

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