names

31 rows where place_id = 650748

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3913747 1994941 1994941 defendant Cavendyshe Edward gent 650748 650748 Cavendyshe, Edward, of Ereth, gent 0
4601188 2231605 2231605 defendant Gryme John   650748 650748 Gryme, John, of Ereth 0
4673227 2257264 2257264 plaintiff Cristyn John   650748 650748 Cristyn, John, of Ereth 0
4757025 2282568 2282568 defendant Wilteshire William husbandman 650748 650748 Wilteshire, William, of Ereth, husbandman 0
4757026 2282568 2282568 defendant Wylteshire Ralph laborer 650748 650748 Wylteshire, Ralph, of Ereth, laborer 1
4783018 2290707 2290707 defendant Chauntour William yeoman 650748 650748 Chauntour, William, of Ereth, yeoman 1
4794911 2294555 2294555 defendant Trussebut Richard husbandman 650748 650748 Trussebut, Richard, of Ereth, husbandman 0
4916813 2331763 2331763 defendant Dorceter John husbandman 650748 650748 Dorceter, John, of Ereth, husbandman 0
4942412 2339612 2339612 plaintiff Foughler Thomas   650748 650748 Foughler, Thomas, of Ereth 0
4948345 2341463 2341463 defendant Lewen John husbandman 650748 650748 Lewen, John, of Ereth, husbandman 1
4950849 2342236 2342236 defendant Couper William yeoman 650748 650748 Couper, William, of Ereth, yeoman 0
4951919 2342550 2342550 defendant Foughler Thomas husbandman 650748 650748 Foughler, Thomas, of Ereth, husbandman 0
4967212 2347126 2347126 defendant Webster Thomas yeoman 650748 650748 Webster, Thomas, of Ereth, yeoman 0
4967213 2347126 2347126 defendant Webster Richard yeoman 650748 650748 Webster, Richard, of Ereth, yeoman 1
5044465 2369975 2369975 defendant Whyte John carpenter 650748 650748 Whyte, John, of Ereth, carpenter 1
5105462 2388039 2388039 defendant Hare Thomas husbandman 650748 650748 Hare, Thomas, of Ereth, husbandman 1
5105463 2388039 2388039 defendant Forth Thomas husbandman 650748 650748 Forth, Thomas, of Ereth, husbandman 2
5109641 2389249 2389249 defendant Trewe John husbandman 650748 650748 Trewe, John, of Ereth, husbandman 1
5116740 2391330 2391330 defendant Bocher Thomas butcher 650748 650748 Bocher, Thomas, of Ereth, butcher 2
5254550 2431545 2431545 defendant Cok Thomas barker 650748 650748 Cok, Thomas, of Ereth, barker 0
5254552 2431545 2431545 defendant Glover John glover 650748 650748 Glover, John, of Ereth, glover 2
5290493 2442223 2442223 defendant Reynold Robert yeoman 650748 650748 Reynold, Robert, of Ereth, yeoman 3
5290498 2442224 2442224 defendant Reynold Robert yeoman 650748 650748 Reynold, Robert, of Ereth, yeoman 3
5298839 2444642 2444642 plaintiff Bocher John   650748 650748 Bocher, John, of Ereth 0
5309764 2447955 2447955 defendant Gamell William clerk 650748 650748 Gamell, William, of Ereth, clerk 0
5391772 2472721 2472721 defendant Graunger John   650748 650748 Graunger, John, of Ereth, shipwright 0
5432934 2484819 2484819 defendant Clerke Richard   650748 650748 Clerke, Richard, of Ereth 0
5448868 2489554 2489554 defendant Clerke Robert yeoman 650748 650748 Clerke, Robert, of Ereth, yeoman 0
5448869 2489554 2489554 defendant Forthe John butcher 650748 650748 Forthe, John, of Ereth, butcher 1
5485627 2500605 2500605 defendant Mustoke John   650748 650748 Mustoke, John, of Ereth, shipwright 3
5623552 2551298 2551298 plaintiff Yotesson Nicholas   650748 650748 Yotesson, Nicholas, of Ereth 0

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