names

16 rows where case_id = 2318099

✎ 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
4871647 2318099 2318099 plaintiff Morley Nicholas     Morley, Nicholas 0
4871648 2318099 2318099 defendant Forster William yeoman 815462 815462 Forster, William, of Foulwode, Lancs, yeoman 0
4871649 2318099 2318099 defendant Grayfeson Thomas yeoman 815463 815463 Grayfeson, Thomas, of Preston in Aundernesse, Lancs, yeoman 1
4871650 2318099 2318099 defendant Blundell Edward yeoman 773075 773075 Blundell, Edward, of Preston in Aundernesse, yeoman 2
4871651 2318099 2318099 defendant Cardemaker William, junior   773075 773075 Cardemaker, William, junior, of Preston in Aundernesse, card maker 3
4871652 2318099 2318099 defendant de Croke Roger laborer 773075 773075 de Croke, Roger, of Preston in Aundernesse, laborer 4
4871653 2318099 2318099 defendant de Croke William laborer 773075 773075 de Croke, William, of Preston in Aundernesse, laborer 5
4871654 2318099 2318099 defendant de Croke John laborer 773075 773075 de Croke, John, of Preston in Aundernesse, laborer 6
4871655 2318099 2318099 defendant de Horneby Robert yeoman 773075 773075 de Horneby, Robert, of Preston in Aundernesse, yeoman 7
4871656 2318099 2318099 defendant Wynhard John husbandman 815465 815465 Wynhard, John, of Foulewode, Lancs, husbandman 8
4871657 2318099 2318099 defendant de Carlton Hugh husbandman 815466 815466 de Carlton, Hugh, of Genakyr, Lancs, husbandman 9
4871658 2318099 2318099 defendant Spycer Edmund laborer 815467 815467 Spycer, Edmund, of Foulwode, laborer 10
4871659 2318099 2318099 defendant Holme Edmund laborer 815468 815468 Holme, Edmund, of Grogynsgyll, Lancs, laborer 11
4871660 2318099 2318099 defendant Taillour John husbandman 773075 773075 Taillour, John, of Preston in Aundernesse, husbandman 12
4871661 2318099 2318099 defendant Taillour Henry laborer 773075 773075 Taillour, Henry, of Preston in Aundernesse, laborer 13
4871662 2318099 2318099 defendant Woderofe John clerk 773075 773075 Woderofe, John, of Preston in Aundernesse, clerk 14

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