names

13 rows where case_id = 2361559

✎ 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
5015971 2361559 2361559 plaintiff Brompton John abbot of Jorevall Abbey   Brompton, John, abbot of Jorevall Abbey 0
5015972 2361559 2361559 defendant Richardson John weaver 835483 835483 Richardson, John, of Over Elyngton juxta Masham, weaver 0
5015973 2361559 2361559 defendant Atkynson Richard slater 835484 835484 Atkynson, Richard, of Over Elyngton, slater 1
5015974 2361559 2361559 defendant Sturdy Robert husbandman 835484 835484 Sturdy, Robert, of Over Elyngton, husbandman 2
5015975 2361559 2361559 defendant Jakson Robert laborer 835484 835484 Jakson, Robert, of Over Elyngton, laborer 3
5015976 2361559 2361559 defendant Walker William husbandman 835484 835484 Walker, William, of Over Elyngton, husbandman 4
5015977 2361559 2361559 defendant Halpeny Roger laborer 835484 835484 Halpeny, Roger, of Over Elyngton, laborer 5
5015978 2361559 2361559 defendant Dykonson Geoffrey laborer 835484 835484 Dykonson, Geoffrey, of Over Elyngton, laborer 6
5015979 2361559 2361559 defendant de Bolton Ralph laborer 835485 835485 de Bolton, Ralph, of Pykyrgyll, Masham, laborer 7
5015980 2361559 2361559 defendant Sawer William miller 835482 835482 Sawer, William, of Helay juxta Masham, miller 8
5015981 2361559 2361559 defendant Smerthwayth John laborer 835486 835486 Smerthwayth, John, of Slaypewayth, Masham, laborer 9
5015982 2361559 2361559 defendant Thekeston John husbandman 835487 835487 Thekeston, John, of Feyrby juxta Masham, husbandman 10
5015983 2361559 2361559 defendant Dykonson Robert laborer 835488 835488 Dykonson, Robert, of Sutton juxta masham, laborer 11

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