names

13 rows where case_id = 2345845

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4962987 2345845 2345845 plaintiff Burton Robert sheriff   Burton, Robert, sheriff 0
4962988 2345845 2345845 defendant Hunte John   603134 603134 Hunte, John, of Membury, bailiff 0
4962989 2345845 2345845 defendant Hille Richard   586443 586443 Hille, Richard, of Colyton, bailiff 1
4962990 2345845 2345845 defendant Caselegh Simon   595360 595360 Caselegh, Simon, of Chageford, bailiff 2
4962991 2345845 2345845 defendant Kion Deswill Nicholas   827967 827967 Kion Deswill, Nicholas, of Flenyngton, bailiff 3
4962992 2345845 2345845 defendant Pylman Nicholas   699076 699076 Pylman, Nicholas, of Shirwill, bailiff 4
4962993 2345845 2345845 defendant Horton Gregory   615639 615639 Horton, Gregory, of Mollond, bailiff 5
4962994 2345845 2345845 defendant Hoigge Thomas   866546 866546 Hoigge, Thomas, of Wytherigge, bailiff 6
4962995 2345845 2345845 defendant Broun William   593193 593193 Broun, William, of Braunton, bailiff 7
4962996 2345845 2345845 defendant Webber Thomas   602687 602687 Webber, Thomas, of Blake Toryton, bailiff 8
4962997 2345845 2345845 defendant Avery Walter   827971 827971 Avery, Walter, of Hertelond, bailiff 9
4962998 2345845 2345845 defendant Kyngedon Nicholas   606557 606557 Kyngedon, Nicholas, of Wynkelegh Keynes, bailiff 10
4962999 2345845 2345845 defendant Neucombe Robert   814333 814333 Neucombe, Robert, of Clyst Sachevyle, 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);