names

17 rows where case_id = 2223617

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4574703 2223617 2223617 plaintiff Beverle Richard     Beverle, Richard 0
4574704 2223617 2223617 defendant Barker Roger   590586 590586 Barker, Roger, of Scarburgh 0
4574705 2223617 2223617 defendant Webster William   590586 590586 Webster, William, of Scarburgh 1
4574706 2223617 2223617 defendant Endwyne Thomas   590586 590586 Endwyne, Thomas, of Scarburgh 2
4574707 2223617 2223617 defendant Forster John     Forster, John 3
4574708 2223617 2223617 defendant Newark Robert clerk   Newark, Robert, clerk 4
4574709 2223617 2223617 defendant Flex Roger clerk   Flex, Roger, clerk 5
4574710 2223617 2223617 defendant Fenton John     Fenton, John 6
4574711 2223617 2223617 defendant Karyner John     Karyner, John 7
4574712 2223617 2223617 defendant Baker Roger     Baker, Roger 8
4574713 2223617 2223617 defendant Cragger Robert   587028 587028 Cragger, Robert, of Whitby 9
4574714 2223617 2223617 defendant Goldsmith John   766003 766003 Goldsmith, John, of Hertilpole 10
4574715 2223617 2223617 defendant Elmedene Stephen     Elmedene, Stephen 11
4574716 2223617 2223617 defendant Elmedene Thomas   766003 766003 Elmedene, Thomas, of Hertilpole 12
4574717 2223617 2223617 defendant Humbilton Cecily   589153 589153 Humbilton, Cecily, of Ruston 13
4574718 2223617 2223617 defendant Forster Henry     Forster, Henry 14
4574719 2223617 2223617 defendant Pricofeld John   606673 606673 Pricofeld, John, of Hull 15

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