names

15 rows where case_id = 2460171

✎ 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
5350143 2460171 2460171 plaintiff Cok Richard     Cok, Richard 0
5350144 2460171 2460171 defendant Broun William yeoman 588071 588071 Broun, William, of Multon, yeoman 0
5350145 2460171 2460171 defendant Sparogh Thomas yeoman 589412 589412 Sparogh, Thomas, of Pynchebek, yeoman 1
5350146 2460171 2460171 defendant Yongewyn Robert husbandman 610614 610614 Yongewyn, Robert, of Gosberkirk, husbandman 2
5350147 2460171 2460171 defendant Bocher William butcher 610614 610614 Bocher, William, of Gosberkirk, butcher 3
5350148 2460171 2460171 defendant Gannnok John yeoman 597124 597124 Gannnok, John, of Waynflete, yeoman 4
5350149 2460171 2460171 defendant Robynson William yeoman 592609 592609 Robynson, William, of Leverton, yeoman 5
5350150 2460171 2460171 defendant Andrewe William   772147 772147 Andrewe, William, of Qwaplod, flax man 6
5350151 2460171 2460171 defendant Wryght Henry gent 587058 587058 Wryght, Henry, of Sutton, gent 7
5350152 2460171 2460171 defendant Lee Nicholas gent 587074 587074 together with Lee, Nicholas, of DOnyngton, gent 8
5350153 2460171 2460171 defendant Austyn Henry yeoman 586750 586750 Austyn, Henry, of Surflete, yeoman 9
5350154 2460171 2460171 defendant Broun Thomas husbandman 588071 588071 Broun, Thomas, of Multon, husbandman 10
5350155 2460171 2460171 defendant Heweson Thomas husbandman 588071 588071 Heweson, Thomas, of Multon, husbandman 11
5350156 2460171 2460171 defendant Phelip Robert yeoman 587058 587058 Phelip, Robert, of Sutton, yeoman 12
5350157 2460171 2460171 defendant Walpole Robert yeoman 589412 589412 Walpole, Robert, of Pynchebek, yeoman 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);