names

15 rows where case_id = 2402785

✎ 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
5155565 2402785 2402785 plaintiff Maryner William     Maryner, William 0
5155566 2402785 2402785 defendant Lee Roger laborer 792936 792936 Lee, Roger, of Bere Ferrers, laborer 0
5155567 2402785 2402785 defendant (not given) Walter rector of Kylmaote 615633 615633 Kylmaote, Walter, of Bere Ferrys, clerk & rector of the church 1
5155568 2402785 2402785 defendant Hoper Nicholas laborer 851137 851137 Hoper, Nicholas, of Berferrys, laborer 2
5155569 2402785 2402785 defendant Hope John laborer 851137 851137 Hope, John, of Berferrys, laborer 3
5155570 2402785 2402785 defendant Steven Richard laborer 851137 851137 Steven, Richard, of Berferrys, laborer 4
5155571 2402785 2402785 defendant Bodeng Ralph laborer 851137 851137 Bodeng, Ralph, of Berferrys, laborer 5
5155572 2402785 2402785 defendant Edele John laborer 812960 812960 Edele, John, of Leskerd, Cornwall, laborer 6
5155573 2402785 2402785 defendant Edele William laborer 619301 619301 Edele, William, of Lyskard, laborer 7
5155574 2402785 2402785 defendant Martyn John laborer 588833 588833 Martyn, John, of Stratton, laborer 8
5155575 2402785 2402785 defendant Phelyp Thomas laborer 590535 590535 Phelyp, Thomas, of Calstok, laborer 9
5155576 2402785 2402785 defendant Brygger John laborer 587351 587351 Brygger, John, of Calstok, Cornw, laborer 10
5155577 2402785 2402785 defendant Haryes John laborer 590535 590535 Haryes, John, of Calstok, laborer 11
5155578 2402785 2402785 defendant Treyveman John husbandman 854053 854053 Treyveman, John, of Pylyngton, husbandman 12
5155579 2402785 2402785 defendant Treyveman Thomas husbandman 854054 854054 Treyveman, Thomas, of Pylynton, husbandman 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);