names

18 rows where case_id = 2530663

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5585969 2530663 2530663 plaintiff Knyghtley William     Knyghtley, William 0
5585970 2530663 2530663 defendant Mulbery of Holborn St Andrew Middx, brewer   Mulbery, of Holborn St Andrew, Middx, brewer 0
5585971 2530663 2530663 defendant Pratyman William yeoman 602732 602732 Pratyman, William, of Bakton, Suff, yeoman 1
5585972 2530663 2530663 defendant Alman Robert goldsmith 585936 585936 Alman, Robert, of Norwich, goldsmith 2
5585973 2530663 2530663 defendant Best Robert grocer 585936 585936 Best, Robert, of Norwich, grocer 3
5585974 2530663 2530663 defendant roun John husbandman 903030 903030 roun, John, of Lyrlyngforth, husbandman 4
5585975 2530663 2530663 defendant Bacon Thomas summoner 589042 589042 Bacon, Thomas, of Heydon, summoner 5
5585976 2530663 2530663 defendant Davy Edward husbandman 588931 588931 Davy, Edward, of Horsham St Faith, husbandman 6
5585977 2530663 2530663 defendant Elwyn Thomas gent 588847 588847 Elwyn, Thomas, of Congham, gent 7
5585978 2530663 2530663 defendant Hornyngtoft Richard husbandman 589927 589927 Hornyngtoft, Richard, of Paston, husbandman 8
5585979 2530663 2530663 defendant Hoberd William husbandman 594108 594108 Hoberd, William, of Egefeld, husbandman 9
5585980 2530663 2530663 defendant Marteyn Alexander husbandman 597243 597243 Marteyn, Alexander, of Matsale, husbandman 10
5585981 2530663 2530663 defendant Micher Leonard beer brewer 585936 585936 Micher, Leonard, of Norwich, beer brewer 11
5585982 2530663 2530663 defendant Perpoynt George gent 585907 585907 Perpoynt, George, of Bishops Lenn, gent 12
5585983 2530663 2530663 defendant Stone Margaret Parva Walsyngham, widow   Stone, Margaret, Parva Walsyngham, widow 13
5585984 2530663 2530663 defendant Sket John cherman 585936 585936 Sket, John, of Norwich, cherman 14
5585985 2530663 2530663 defendant Bryggys Everard gent 602893 602893 Bryggys, Everard, of Sall, gent 15
5585986 2530663 2530663 defendant Snellyng John butcher 587172 587172 Snellyng, John, of Est Derham, butcher 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);