names

13 rows where case_id = 2248123

✎ 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
4657146 2248123 2248123 plaintiff Clarell Thomas esq   Clarell, Thomas, esq 0
4657147 2248123 2248123 defendant Stretton John   606682 606682 Stretton, John, of Waynflet 0
4657148 2248123 2248123 defendant Odam William   626523 626523 Odam, William, of Saleby 1
4657149 2248123 2248123 defendant Elred Nicholas   586981 586981 Elred, Nicholas, of Louth 2
4657150 2248123 2248123 defendant Marton William juxta Horncastre   Marton, William, juxta Horncastre 3
4657151 2248123 2248123 defendant Roger John   603083 603083 Roger, John, of Wragby 4
4657152 2248123 2248123 defendant Amy Richard     Amy, Richard 5
4657153 2248123 2248123 defendant Weston John   588489 588489 Weston, John, of Melton 6
4657154 2248123 2248123 defendant Walker William   589416 589416 Walker, William, of Oselby 7
4657155 2248123 2248123 defendant Lamkyn William     Lamkyn, William 8
4657156 2248123 2248123 defendant Rachedale Richard   596711 596711 Rachedale, Richard, of Gaynesburgh 9
4657157 2248123 2248123 defendant Burley Richard   586846 586846 Burley, Richard, of Lincoln 10
4657158 2248123 2248123 defendant Feryby Thomas   586344 586344 Feryby, Thomas, of Burton Stather 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);