names

18 rows where case_id = 2402782

✎ 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
5155541 2402782 2402782 plaintiff Maryner William     Maryner, William 0
5155542 2402782 2402782 defendant Hay John gent 854062 854062 Hay, John, of St Yve, gent 0
5155543 2402782 2402782 defendant Walche Thomas husbandman 854063 854063 Walche, Thomas, of Onethyk, husbandman 1
5155544 2402782 2402782 defendant Battun John laborer 854063 854063 Battun, John, of Onethyk, laborer 2
5155545 2402782 2402782 defendant Hochun John husbandman 854063 854063 Hochun, John, of Onethyk, husbandman 3
5155546 2402782 2402782 defendant Parkyn John     Parkyn, John 4
5155547 2402782 2402782 defendant Paprkyn Nicholas laborer 854064 854064 Paprkyn, Nicholas, of St Mylyyn, laborer 5
5155548 2402782 2402782 defendant Parkyn Walter husbandman 854065 854065 Parkyn, Walter, of St Myleyn, husbandman 6
5155549 2402782 2402782 defendant Robyn Reginald miller 854066 854066 Robyn, Reginald, of Loudlyp, miller 7
5155550 2402782 2402782 defendant Randyll Thomas smith 854067 854067 Randyll, Thomas, of Lan Rake, smith 8
5155551 2402782 2402782 defendant Polglasse John husbandman 854067 854067 Polglasse, John, of Lan Rake, husbandman 9
5155552 2402782 2402782 defendant Aleyn Thomas husbandman 854067 854067 Aleyn, Thomas, of Lan Rake, husbandman 10
5155553 2402782 2402782 defendant Waleys Stephen husbandman 854063 854063 Waleys, Stephen, of Onethyk, husbandman 11
5155554 2402782 2402782 defendant Rawlyn John husbandman 854063 854063 Rawlyn, John, of Onethyk, husbandman 12
5155555 2402782 2402782 defendant Adam John husbandman 854063 854063 Adam, John, of Onethyk, husbandman 13
5155556 2402782 2402782 defendant Parkyn John husbandman 854068 854068 Parkyn, John, of St Mylyn, husbandman 14
5155557 2402782 2402782 defendant Glubbe Roger husbandman 680573 680573 Glubbe, Roger, of Tamerton, Devon, husbandman 15
5155558 2402782 2402782 defendant Soper Simon miller or smelter 685285 685285 Soper, Simon, of Tavestoke, Devon, miller or smelter 16

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