names

13 rows where case_id = 2437307

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5273442 2437307 2437307 plaintiff Meton Henry     Meton, Henry 0
5273443 2437307 2437307 defendant Gregge John vintner 780959 780959 Gregge, John, of Hereford, Herefs, vintner 0
5273444 2437307 2437307 defendant Jakson Thomas baker 586208 586208 Jakson, Thomas, of Hereford, baker 1
5273445 2437307 2437307 defendant Trevays Thomas sheerman 586208 586208 Trevays, Thomas, of Hereford, sheerman 2
5273446 2437307 2437307 defendant Barbour John   586208 586208 Barbour, John, of Hereford, wax chandler 3
5273447 2437307 2437307 defendant Bowyer Nicholas   586208 586208 Bowyer, Nicholas, of Hereford, bow maker 4
5273448 2437307 2437307 defendant Sutton John chapman 586208 586208 Sutton, John, of Hereford, chapman 5
5273449 2437307 2437307 defendant Walker John fletcher 586208 586208 Walker, John, of Hereford, fletcher 6
5273450 2437307 2437307 defendant Brasyer John sheerman 586208 586208 Brasyer, John, of Hereford, sheerman 7
5273451 2437307 2437307 defendant at Thomas John tailor 586208 586208 at Thomas, John, of Hereford, tailor 8
5273452 2437307 2437307 defendant Gilbert John shoemaker 586208 586208 Gilbert, John, of Hereford, shoemaker 9
5273453 2437307 2437307 defendant Fletcher John, senior fletcher 586208 586208 Fletcher, John, senior, of Hereford, fletcher 10
5273454 2437307 2437307 defendant Peautrer Nicholas pewterer 586208 586208 Peautrer, Nicholas, of Hereford, pewterer 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);