names

14 rows where case_id = 1866677

✎ 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
3596942 1866677 1866677 plaintiff Pynchebek Thomas esq, administrators of   Pynchebek, Thomas, esq, administrators of 0
3596943 1866677 1866677 plaintiff Pynchebek Anne widow   (Pynchebek, Anne, widow 1
3596944 1866677 1866677 plaintiff Pynchebek William clerk   Pynchebek, William, clerk 2
3596945 1866677 1866677 defendant Doweghty Thomas clerk 589221 589221 Doweghty, Thomas, of Kyrkby, clerk 0
3596946 1866677 1866677 defendant Robynson Nicholas weaver 589222 589222 Robynson, Nicholas, of Osilbe, weaver 1
3596947 1866677 1866677 defendant Burton Robert husbandman 589223 589223 Burton, Robert, of Leggysby, husbandman 2
3596948 1866677 1866677 defendant Dalby Richard husbandman 589224 589224 Dalby, Richard, of Dalby, husbandman 3
3596949 1866677 1866677 defendant Pell Thomas yeoman 589225 589225 Pell, Thomas, of Kelby, yeoman 4
3596950 1866677 1866677 defendant Barowe James husbandman 589226 589226 Barowe, James, of Aseby, husbandman 5
3596951 1866677 1866677 defendant Alforth William butcher 586981 586981 Alforth, William, of Louth, butcher 6
3596952 1866677 1866677 defendant Waltam William husbandman 589227 589227 Waltam, William, of Scalby, husbandman 7
3596953 1866677 1866677 defendant Willyot of Horncastre butcher   Willyot, of Horncastre, butcher 8
3596954 1866677 1866677 defendant West James mercer 589228 589228 West, James, of Horncastre, mercer 9
3596955 1866677 1866677 defendant Bakster Robert baker 589228 589228 Bakster, Robert, of Horncastre, baker 10

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