names

17 rows where case_id = 1960079

✎ 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
3806937 1960079 1960079 plaintiff Weston Richard knight of the body   Weston, Richard, knight of the body 0
3806938 1960079 1960079 plaintiff Wyatt Henry knight, treasurer of the chamber   Wyatt, Henry, knight, treasurer of the chamber 1
3806939 1960079 1960079 defendant Carant William esq 632481 632481 Carant, William, of Thomer, Soms, esq 0
3806940 1960079 1960079 defendant Seward Henry esq 632482 632482 Seward, Henry, of Chelcompton, Soms, esq 1
3806941 1960079 1960079 defendant Carant Richard gent 632483 632483 Carant, Richard, of Thomer, gent 2
3806942 1960079 1960079 defendant Lyghe Nicholas gent 632484 632484 Lyghe, Nicholas, of Addyngton, Surrey, gent 3
3806943 1960079 1960079 defendant Atclyff Thomas gent 601617 601617 Atclyff, Thomas, of Lewesham, Kent, gent 4
3806944 1960079 1960079 defendant Wallys Richard gent 606286 606286 Wallys, Richard, of Lewesham, gent 5
3806945 1960079 1960079 defendant Davys William clerk 632485 632485 Davys, William, of Kemes, Cams, clerk 6
3806946 1960079 1960079 defendant Johns William mercer 585869 585869 Johns, William, of London, mercer 7
3806947 1960079 1960079 defendant Branne Richard merchant 585925 585925 Branne, Richard, of Bristol, merchant 8
3806948 1960079 1960079 defendant Underhyll William gent 586359 586359 Underhyll, William, of Warwyk, gent 9
3806949 1960079 1960079 defendant Knyght John gent 632099 632099 Knyght, John, of Whitechurche, Bucks, gent 10
3806950 1960079 1960079 defendant Langley Richard gent 587633 587633 Langley, Richard, of Stony Stratford, Bucks, gent 11
3806951 1960079 1960079 defendant More Christopher gent 632486 632486 More, Christopher, of Lowseley, Surrey, gent 12
3806952 1960079 1960079 defendant Sylick William gent 585869 585869 Sylick, William, of London, gent 13
3806953 1960079 1960079 defendant Cowper William gent 585869 585869 Cowper, William, of London, gent 14

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