names

13 rows where case_id = 2106026

✎ 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
4230124 2106026 2106026 plaintiff Smythe James     Smythe, James 0
4230125 2106026 2106026 defendant Scudamore John esq 659033 659033 Scudamore, John, of Kenchurche, esq 0
4230126 2106026 2106026 defendant Scudamor Thomas gent 659033 659033 Scudamor, Thomas, of Kenchurche, gent 1
4230127 2106026 2106026 defendant Millward John yeoman 659033 659033 Millward, John, of Kenchurche, yeoman 2
4230128 2106026 2106026 defendant Harry William husbandman 659033 659033 Harry, William, of Kenchurche, husbandman 3
4230129 2106026 2106026 defendant Thomas John   659033 659033 Thomas, John, of Kenchurche, mason 4
4230130 2106026 2106026 defendant ap Morgan Morgan husbandman 659033 659033 ap Morgan, Morgan, of Kenchurche, husbandman 5
4230131 2106026 2106026 defendant John William husbandman 647425 647425 John, William, of Kylpecke, husbandman 6
4230132 2106026 2106026 defendant ap John Charles huabandman 667317 667317 ap John, Charles, of Kilpecke, huabandman 7
4230133 2106026 2106026 defendant Lewis Rice yeoman 659033 659033 Lewis, Rice, of Kenchurche, yeoman 8
4230134 2106026 2106026 defendant Hughe Henry yeoman 659033 659033 Hughe, Henry, of Kenchurche, yeoman 9
4230135 2106026 2106026 defendant Phelip Roger yeoman 659033 659033 Phelip, Roger, of Kenchurche, yeoman 10
4230136 2106026 2106026 defendant Hughe Henry ap Harry laborer 659033 659033 Hughe, Henry ap Harry, of Kenchurche, laborer 11

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