names

13 rows where case_id = 2457596

✎ 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
5341692 2457596 2457596 plaintiff Ramsey William abbot of Peterborough Abbey   Ramsey, William, abbot of Peterborough Abbey 0
5341693 2457596 2457596 defendant Sothell Robert gent 590134 590134 Sothell, Robert, of Redburn, gent 0
5341694 2457596 2457596 defendant Graunger John husbandman 589558 589558 Graunger, John, of Messyngham, husbandman 1
5341695 2457596 2457596 defendant Whitefote John husbandman 589558 589558 Whitefote, John, of Messyngham, husbandman 2
5341696 2457596 2457596 defendant Whitefote Thomas husbandman 589558 589558 Whitefote, Thomas, of Messyngham, husbandman 3
5341697 2457596 2457596 defendant Barkworth John husbandman 589558 589558 Barkworth, John, of Messyngham, husbandman 4
5341698 2457596 2457596 defendant Barkworth William husbandman 589558 589558 Barkworth, William, of Messyngham, husbandman 5
5341699 2457596 2457596 defendant Hobard William husbandman 781662 781662 Hobard, William, of Cletham, husbandman 6
5341700 2457596 2457596 defendant Magotson Robert husbandman 589558 589558 Magotson, Robert, of Messyngham, husbandman 7
5341701 2457596 2457596 defendant Brownlas Richard husbandman 604247 604247 Brownlas, Richard, of Redburne, husbandman 8
5341702 2457596 2457596 defendant Knyght William husbandman 615326 615326 Knyght, William, of Maunton, husbandman 9
5341703 2457596 2457596 defendant Burnby Richard husbandman 615326 615326 Burnby, Richard, of Maunton, husbandman 10
5341704 2457596 2457596 defendant Goldesburgh John laborer 615326 615326 Goldesburgh, John, of Maunton, 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);