names

14 rows where case_id = 2387326

✎ 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
5103077 2387326 2387326 plaintiff Bourgchier William     Bourgchier, William 0
5103078 2387326 2387326 defendant Wyke Richard, senior gent 597003 597003 Wyke, Richard, senior, of South Tawton, gent 0
5103079 2387326 2387326 defendant Wyke Richard, junior gent 592268 592268 Wyke, Richard, junior, of Brodewodekelly, gent 1
5103080 2387326 2387326 defendant Bysshop Oto husbandman 779712 779712 Bysshop, Oto, of Bonelegh, husbandman 2
5103081 2387326 2387326 defendant Walvyn Richard husbandman 846689 846689 Walvyn, Richard, of Colbrokeford, husbandman 3
5103082 2387326 2387326 defendant Gascoigne Peter husbandman 599055 599055 Gascoigne, Peter, of Okehampton,husbandman 4
5103083 2387326 2387326 defendant Syneger William husbandman 599055 599055 Syneger, William, of Okehampton, husbandman 5
5103084 2387326 2387326 defendant Hall Oto husbandman 834970 834970 Hall, Oto, of South Taweton, husbandman 6
5103085 2387326 2387326 defendant Wonston John husbandman 834970 834970 Wonston, John, of South Taweton, husbandman 7
5103086 2387326 2387326 defendant Devyll Walter husbandman 846690 846690 Devyll, Walter, of Gadelegh, husbandman 8
5103087 2387326 2387326 defendant Langeston John husbandman 846691 846691 Langeston, John, of Therewelegh, husbandman 9
5103088 2387326 2387326 defendant Lyne or Lyve John laborer 846692 846692 Lyne or Lyve, John, of Gydelegh, laborer 10
5103089 2387326 2387326 defendant Bevyll William husbandman 595360 595360 Bevyll, William, of Chageford, husbandman 11
5103090 2387326 2387326 defendant Wyger John laborer 834002 834002 Wyger, John, of Threwelegh, laborer 12

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