names

15 rows where case_id = 2295482

✎ 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
4797768 2295482 2295482 plaintiff (not given)   abbot of St Mary Abbey, York   St Mary Abbey, York, abbot of 0
4797769 2295482 2295482 defendant Hochonson John walker 803636 803636 Hochonson, John, of Teneleshed, walker 0
4797770 2295482 2295482 defendant Wilkynson Thomas husbandman 803636 803636 Wilkynson, Thomas, of Teneleshed, husbandman 1
4797771 2295482 2295482 defendant Russell William husbandman 803636 803636 Russell, William, of Teneleshed, husbandman 2
4797772 2295482 2295482 defendant Russell William walker 803636 803636 Russell, William, of Teneleshed, walker 3
4797773 2295482 2295482 defendant Atkynson John walker 803637 803637 Atkynson, John, of Kesthayte, walker 4
4797774 2295482 2295482 defendant Payntour John husbandman 803637 803637 Payntour, John, of Kesthayte, husbandman 5
4797775 2295482 2295482 defendant Stokdale William yeoman 803637 803637 Stokdale, William, of Kesthayte, yeoman 6
4797776 2295482 2295482 defendant Appulgarth William yeoman 803637 803637 Appulgarth, William, of Kesthayte, yeoman 7
4797777 2295482 2295482 defendant Turnour John   803638 803638 Turnour, John, of Kirkeby in Lonesdale, marshal 8
4797778 2295482 2295482 defendant Turnour William   803638 803638 Turnour, William, of Kirkeby in Lonesdale, marshal 9
4797779 2295482 2295482 defendant Wright Robert   755684 755684 Wright, Robert, of Kirkeby in Lonesdale, wright 10
4797780 2295482 2295482 defendant Pyper Thomas tailor 755684 755684 Pyper, Thomas, of Kirkeby in Lonesdale, tailor 11
4797781 2295482 2295482 defendant Riddyng Adam husbandman 755684 755684 Riddyng, Adam, of Kirkeby in Lonesdale, husbandman 12
4797782 2295482 2295482 defendant Condour John yeoman 755684 755684 Condour, John, of Kirkeby in Lonesdale, yeoman 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);