names

17 rows where case_id = 2532570

✎ 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
5592259 2532570 2532570 plaintiff Warcop Robert esq   Warcop, Robert, esq 0
5592260 2532570 2532570 defendant Berton William gent 903687 903687 Berton, William, of Hormside, gent 0
5592261 2532570 2532570 defendant Cobden John yeoman 903687 903687 Cobden, John, of Hormside, yeoman 1
5592262 2532570 2532570 defendant Walker Thomas husbandman 903687 903687 Walker, Thomas, of Hormside, husbandman 2
5592263 2532570 2532570 defendant Lamberd William husbandman 903687 903687 Lamberd, William, of Hormside, husbandman 3
5592264 2532570 2532570 defendant Robynson John husbandman 665160 665160 Robynson, John, of Sandfurth, husbandman 4
5592265 2532570 2532570 defendant Bolland Robert husbandman 665160 665160 Bolland, Robert, of Sandfurth, husbandman 5
5592266 2532570 2532570 defendant Scaiff Roland yeoman 903684 903684 Scaiff, Roland, of Assby Graunge, yeoman 6
5592267 2532570 2532570 defendant Colleyn John husbandman 815701 815701 Colleyn, John, of Parva Musgrave, husbandman 7
5592268 2532570 2532570 defendant Bete Thomas husbandman 815701 815701 Bete, Thomas, of Parva Musgrave, husbandman 8
5592269 2532570 2532570 defendant Baily William husbandman 815701 815701 Baily, William, of Parva Musgrave, husbandman 9
5592270 2532570 2532570 defendant Robynson Richard husbandman 612970 612970 Robynson, Richard, of Blatern, husbandman 10
5592271 2532570 2532570 defendant Hugill Joan widow 903686 903686 Hugill, Joan, of Plulan, widow 11
5592272 2532570 2532570 defendant Martyndale William laborer 903686 903686 Martyndale, William, of Plulan, laborer 12
5592273 2532570 2532570 defendant Flek John husbandman 589876 589876 Flek, John, of branton, husbandman 13
5592274 2532570 2532570 defendant Robynson Alexander husbandman 589876 589876 Robynson, Alexander, of Branton, husbandman 14
5592275 2532570 2532570 defendant Berton Robert gent 903687 903687 Berton, Robert, of Hormside, gent 15

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