names

18 rows where case_id = 2245510

✎ 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
4648101 2245510 2245510 plaintiff Stanhop Richard knight   Stanhop, Richard, knight 0
4648102 2245510 2245510 defendant Thorp John   720213 720213 Thorp, John, of Morehouse 0
4648103 2245510 2245510 defendant Taillour Richard   601299 601299 Taillour, Richard, of Morehous 1
4648104 2245510 2245510 defendant (not given) Robert his son   Robert, his son 2
4648105 2245510 2245510 defendant John brother of the same Robert     John, brother of the same Robert 3
4648106 2245510 2245510 defendant Belle John     Belle, John 4
4648107 2245510 2245510 defendant Leek William   720213 720213 Leek, William, of Morehouse 5
4648108 2245510 2245510 defendant Lambe Henry   591977 591977 Lambe, Henry, of Laxton 6
4648109 2245510 2245510 defendant Freman Thomas     Freman, Thomas 7
4648110 2245510 2245510 defendant Chapell William     Chapell, William 8
4648111 2245510 2245510 defendant Gillyng Robert     Gillyng, Robert 9
4648112 2245510 2245510 defendant Hasarde William   591977 591977 Hasarde, William, of Laxton 10
4648113 2245510 2245510 defendant Samon Wiliam   591977 591977 Samon, Wiliam, of Laxton 11
4648114 2245510 2245510 defendant Batys John     Batys, John 12
4648115 2245510 2245510 defendant Farnesfeld William     Farnesfeld, William 13
4648116 2245510 2245510 defendant Burtonson Robert     Burtonson, Robert 14
4648117 2245510 2245510 defendant Carter John   591977 591977 Carter, John, of Laxton 15
4648118 2245510 2245510 defendant Gabber John     Gabber, John 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);