names

21 rows where case_id = 2392718

✎ 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
5121478 2392718 2392718 plaintiff Thomas William, junior     Thomas, William, junior 0
5121479 2392718 2392718 defendant Hamlet William gent 586318 586318 Hamlet, William, of Worcester, gent 0
5121480 2392718 2392718 defendant Crabbe William gent 586318 586318 Crabbe, William, of Worcester, gent 1
5121481 2392718 2392718 defendant Brook John gent 586318 586318 Brook, John, of Worcester, gent 2
5121482 2392718 2392718 defendant Ketelby John gent 586318 586318 Ketelby, John, of Worcester, gent 3
5121483 2392718 2392718 defendant Smyth William smith 848831 848831 Smyth, William, of Hertylbury, Worcs, smith 4
5121484 2392718 2392718 defendant Smyth Philip smith 848832 848832 Smyth, Philip, of Wrobenhale, Worcs, smith 5
5121485 2392718 2392718 defendant Smyth Richard gent 598810 598810 Smyth, Richard, of Hertylbury, gent 6
5121486 2392718 2392718 defendant Crowele John yeoman 586318 586318 Crowele, John, of Worcester, yeoman 7
5121487 2392718 2392718 defendant Kendale John yeoman 586318 586318 Kendale, John, of Worcester, yeoman 8
5121488 2392718 2392718 defendant Bacon Roger   848833 848833 Bacon, Roger, of Bohe, Herts, husbandan 9
5121489 2392718 2392718 defendant Wythe Richard   625493 625493 Wythe, Richard, of Wyche, Worcs 10
5121490 2392718 2392718 defendant Sebryght William husbandman 672798 672798 Sebryght, William, of Wolverley, Worcs, husbandman 11
5121491 2392718 2392718 defendant Jokys John husbandman 848834 848834 Jokys, John, of Kyngford, Worcs, husbandman 12
5121492 2392718 2392718 defendant Thomson Richrd gent 586843 586843 Thomson, Richrd, of Wyche, gent 13
5121493 2392718 2392718 defendant Hertylbury John prior of Worcester Priory   Hertylbury, John, prior of Worcester Priory 14
5121494 2392718 2392718 defendant Sudbury John monk   Sudbury, John, monk 15
5121495 2392718 2392718 defendant Isak William monk   Isak, William, monk 16
5121496 2392718 2392718 defendant Hiklyngton William monk   Hiklyngton, William, monk 17
5121497 2392718 2392718 defendant Molton Robert monk   Molton, Robert, monk 18
5121498 2392718 2392718 defendant Tyberton Richard monk   Tyberton, Richard, monk 19

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