names

20 rows where case_id = 2528386

✎ 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
5578620 2528386 2528386 plaintiff Babyngton Thomas     Babyngton, Thomas 0
5578621 2528386 2528386 defendant Ball Henry   639179 639179 Ball, Henry, of Makeney, scythe smith 0
5578622 2528386 2528386 defendant Stavesby Thomas   601413 601413 Stavesby, Thomas, of Bealper, scythe smith 1
5578623 2528386 2528386 defendant Sowter Thomas husbandman 601413 601413 Sowter, Thomas, of Bealper, husbandman 2
5578624 2528386 2528386 defendant Parker James husbandman 601413 601413 Parker, James, of Bealper, husbandman 3
5578625 2528386 2528386 defendant Egynton John husbandman 604686 604686 Egynton, John, of Holbroke, husbandman 4
5578626 2528386 2528386 defendant Egynton Thomas husbandman 604686 604686 Egynton, Thomas, of Holbroke, husbandman 5
5578627 2528386 2528386 defendant Egynton William husbandman 604686 604686 Egynton, William, of Holbroke, husbandman 6
5578628 2528386 2528386 defendant Flecher Oliver husbandman 604686 604686 Flecher, Oliver, of Holbroke, husbandman 7
5578629 2528386 2528386 defendant Johnson Robert husbandman 639179 639179 Johnson, Robert, of Makeney, husbandman 8
5578630 2528386 2528386 defendant Jakson John barker 587136 587136 Jakson, John, of Derby, barker 9
5578631 2528386 2528386 defendant Walley John laborer 817732 817732 Walley, John, of Brakenthwayte, laborer 10
5578632 2528386 2528386 defendant Ive Robert husbandman 605404 605404 Ive, Robert, of Asshover, husbandman 11
5578633 2528386 2528386 defendant Astebery Richard miner 641475 641475 Astebery, Richard, of Crumford, miner 12
5578634 2528386 2528386 defendant Pydcoke William laborer 609334 609334 Pydcoke, William, of Marlege, laborer 13
5578635 2528386 2528386 defendant Adam James miner 591263 591263 Adam, James, of Cromford, miner 14
5578636 2528386 2528386 defendant Meltham Giles miner 593361 593361 Meltham, Giles, of Derley, miner 15
5578637 2528386 2528386 defendant Typpyng John miner 593361 593361 Typpyng, John, of Derley, miner 16
5578638 2528386 2528386 defendant Adam Thomas miner 597093 597093 Adam, Thomas, of Wyrkesworth, miner 17
5578639 2528386 2528386 defendant Flynt Henry miner 902202 902202 Flynt, Henry, of Mateloke, miner 18

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