names

13 rows where case_id = 2246487

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4651541 2246487 2246487 plaintiff Arundell John knight   Arundell, John, knight 0
4651542 2246487 2246487 defendant Byddegoud Alexander   756828 756828 Byddegoud, Alexander, of Langlee, bailiff 0
4651543 2246487 2246487 defendant Shyld Adam   588557 588557 Shyld, Adam, of Tyverton, bailiff 1
4651544 2246487 2246487 defendant Husy Robert   587577 587577 Husy, Robert, of Wolston, bailiff 2
4651545 2246487 2246487 defendant Willesdon Henry   587224 587224 Willesdon, Henry, of Otery St Mary, bailiff 3
4651546 2246487 2246487 defendant Vele Geoffrey   592653 592653 Vele, Geoffrey, of South Tauton, bailiff 4
4651547 2246487 2246487 defendant Wynkelegh John   599723 599723 Wynkelegh, John, of Plympton, bailiff 5
4651548 2246487 2246487 defendant Webber John   639423 639423 Webber, John, of Dertemouth, bailiff 6
4651549 2246487 2246487 defendant Cryse John   778029 778029 Cryse, John, of Mokkeworthy, bailiff 7
4651550 2246487 2246487 defendant Goudchyld John   778030 778030 Goudchyld, John, of Scherewyll, bailiff 8
4651551 2246487 2246487 defendant Hondaller John   587577 587577 Hondaller, John, of Wolston, bailiff 9
4651552 2246487 2246487 defendant Strete John   586443 586443 Strete, John, of Colyton, bailiff 10
4651553 2246487 2246487 defendant Vernecombe John   588808 588808 Vernecombe, John, of Brodeclyst, bailiff 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);