names

13 rows where case_id = 2288425

✎ 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
4775780 2288425 2288425 plaintiff Wyke Launcelus     Wyke, Launcelus 0
4775781 2288425 2288425 defendant Colewyll John mariner 601694 601694 Colewyll, John, of Northam, mariner 0
4775782 2288425 2288425 defendant atte Yeo John mariner 601694 601694 atte Yeo, John, of Northam, mariner 1
4775783 2288425 2288425 defendant Westecote John mariner 800842 800842 Westecote, John, of Apyldore, mariner 2
4775784 2288425 2288425 defendant Hancokkes Robert mariner 601694 601694 Hancokkes, Robert, of Northam, mariner 3
4775785 2288425 2288425 defendant Lubbowe Walter mariner 635746 635746 Lubbowe, Walter, of Barnstable, mariner 4
4775786 2288425 2288425 defendant Lange John dyer 586274 586274 Lange, John, of Barnestaple, dyer 5
4775787 2288425 2288425 defendant Michell William mariner 604649 604649 Michell, William, of Ilfracombe, mariner 6
4775788 2288425 2288425 defendant Bowerede Robert mariner 604649 604649 Bowerede, Robert, of Ilfracombe, mariner 7
4775789 2288425 2288425 defendant Lytell John mariner 604649 604649 Lytell, John, of Ilfracombe, mariner 8
4775790 2288425 2288425 defendant Bond Henry mariner 604649 604649 Bond, Henry, of Ilfracombe, mariner 9
4775791 2288425 2288425 defendant Bussh William tailor 601694 601694 Bussh, William, of Northam, tailor 10
4775792 2288425 2288425 defendant Hadcote John mariner 586791 586791 Hadcote, John, of Bydeford, mariner 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);