names

19 rows where case_id = 2402864

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5155809 2402864 2402864 plaintiff (not given)   prior of Michelham   Michelham, prior of 0
5155810 2402864 2402864 defendant Strode William, sen butcher   Strode, William, sen, butcher 0
5155811 2402864 2402864 defendant Mall Richard husbandman   Mall, Richard, husbandman 1
5155812 2402864 2402864 defendant atte Lye John husbandman   atte Lye, John, husbandman 2
5155813 2402864 2402864 defendant atte Downe Richard husbandman   atte Downe, Richard, husbandman 3
5155814 2402864 2402864 defendant Stidolf John, sen husbandman   Stidolf, John, sen, husbandman 4
5155815 2402864 2402864 defendant Stidolff Richard husbandman   Stidolff, Richard, husbandman 5
5155816 2402864 2402864 defendant Holford Richard husbandman   Holford, Richard, husbandman 6
5155817 2402864 2402864 defendant Avecok Thomas     Avecok, Thomas 7
5155818 2402864 2402864 defendant Cowestok Alexander     Cowestok, Alexander 8
5155819 2402864 2402864 defendant Strode William jun, holy water clerk   Strode, William, jun, holy water clerk 9
5155820 2402864 2402864 defendant Atherwold William, sen butcher   Atherwold, William, sen, butcher 10
5155821 2402864 2402864 defendant Alshorne Richard husbandman   Alshorne, Richard, husbandman 11
5155822 2402864 2402864 defendant Avecok John husbandman   Avecok, John, husbandman 12
5155823 2402864 2402864 defendant Parys Thomas miller   Parys, Thomas, miller 13
5155824 2402864 2402864 defendant Avecok Robert husbandman   Avecok, Robert, husbandman 14
5155825 2402864 2402864 defendant Curkyn Richard carpenter   Curkyn, Richard, carpenter 15
5155826 2402864 2402864 defendant Skynner Richard husbandman   Skynner, Richard, husbandman 16
5155827 2402864 2402864 defendant White Thomas husbandman 588259 588259 together with White, Thomas, of Flecchyng, husbandman 17

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