names

15 rows where case_id = 2288780

✎ 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
4776958 2288780 2288780 plaintiff Arundell John son of Arundell, John, knight   Arundell, John, son of Arundell, John, knight 0
4776959 2288780 2288780 defendant Dudlesfold Richard husbandman 613106 613106 Dudlesfold, Richard, of Petteworth, husbandman 0
4776960 2288780 2288780 defendant atte Mulle Edmund son of atte Mulle, John, of Petteworth, husbandman   atte Mulle, Edmund, son of atte Mulle, John, of Petteworth, husbandman 1
4776961 2288780 2288780 defendant Kynge Robert gent 800989 800989 Kynge, Robert, of Burkyton, gent 2
4776962 2288780 2288780 defendant Porter Thomas, junior husbandman 617182 617182 Porter, Thomas, junior, of Ludgersale, husbandman 3
4776963 2288780 2288780 defendant atte Fylde John husbandman 800990 800990 atte Fylde, John, of Chyddyngfeld, Surrey, husbandman 4
4776964 2288780 2288780 defendant Skynner John skinner 800991 800991 Skynner, John, of Chyddyngfeld, skinner 5
4776965 2288780 2288780 defendant Dudlesfold Thomas husbandman 617182 617182 Dudlesfold, Thomas, of Ludgersale, husbandman 6
4776966 2288780 2288780 defendant Renkhurst Richard husbandman 617182 617182 Renkhurst, Richard, of Ludgersale, husbandman 7
4776967 2288780 2288780 defendant Porter John husbandman 617182 617182 Porter, John, of Ludgersale, husbandman 8
4776968 2288780 2288780 defendant Porter Thomas, senior husbandman 646815 646815 Porter, Thomas, senior, of Loddesworth, husbandman 9
4776969 2288780 2288780 defendant Pyke Henry husbandman 646815 646815 Pyke, Henry, of Loddesworth, husbandman 10
4776970 2288780 2288780 defendant Howyk Robert husbandman 800992 800992 Howyk, Robert, of Farewhist, husbandman 11
4776971 2288780 2288780 defendant Weller John, junior husbandman 613106 613106 Weller, John, junior, of Petteworth, husbandman 12
4776972 2288780 2288780 defendant Dyer John husbandman 757405 757405 together with Dyer, John, of Chyddyngfold, husbandman 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);