names

29 rows where case_id = 2203205

✎ 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
4508703 2203205 2203205 plaintiff Annesley Hugh de knight   Annesley, Hugh de, knight 0
4508704 2203205 2203205 defendant Barker John   764707 764707 Barker, John, of Hokenall 0
4508705 2203205 2203205 defendant Forster William     Forster, William 1
4508706 2203205 2203205 defendant Whitfot William   645477 645477 Whitfot, William, of Hukenall 2
4508707 2203205 2203205 defendant Wryght Richard   764707 764707 Wryght, Richard, of Hokenall 3
4508708 2203205 2203205 defendant Carter Richard   764707 764707 Carter, Richard, of Hokenall 4
4508709 2203205 2203205 defendant Drury Robert     Drury, Robert 5
4508710 2203205 2203205 defendant Dawe Robert     Dawe, Robert 6
4508711 2203205 2203205 defendant Hyerd John     Hyerd, John 7
4508712 2203205 2203205 defendant Barker Ralph     Barker, Ralph 8
4508713 2203205 2203205 defendant Taillour Nicholas   764707 764707 Taillour, Nicholas, of Hokenall 9
4508714 2203205 2203205 defendant Mason John   764707 764707 Mason, John, of Hokenall 10
4508715 2203205 2203205 defendant Walker John   764707 764707 Walker, John, of Hokenall 11
4508716 2203205 2203205 defendant Webster Lambert     Webster, Lambert 12
4508717 2203205 2203205 defendant Launder John     Launder, John 13
4508718 2203205 2203205 defendant Wyllughby Walter     Wyllughby, Walter 14
4508719 2203205 2203205 defendant Fleccher William     Fleccher, William 15
4508720 2203205 2203205 defendant Halum John de     Halum, John de 16
4508721 2203205 2203205 defendant Walley Thomas     Walley, Thomas 17
4508722 2203205 2203205 defendant Porter Thomas     Porter, Thomas 18
4508723 2203205 2203205 defendant Parker Robert     Parker, Robert 19
4508724 2203205 2203205 defendant Taillour John   764707 764707 Taillour, John, of Hokenall 20
4508725 2203205 2203205 defendant Smyth John   764707 764707 Smyth, John, of Hokenall 21
4508726 2203205 2203205 defendant Bate John     Bate, John 22
4508727 2203205 2203205 defendant Bailly Peter     Bailly, Peter 23
4508728 2203205 2203205 defendant Ingmay Richard     Ingmay, Richard 24
4508729 2203205 2203205 defendant Colle Robert     Colle, Robert 25
4508730 2203205 2203205 defendant Norman Robert     Norman, Robert 26
4508731 2203205 2203205 defendant Fauconberd Robert   764707 764707 Fauconberd, Robert, of Hokenall 27

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