names

21 rows where case_id = 2242294

✎ 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
4636663 2242294 2242294 plaintiff Beaulieu William de     Beaulieu, William de 0
4636664 2242294 2242294 defendant Huton William de   597715 597715 Huton, William de, of Wygton 0
4636665 2242294 2242294 defendant Brounrigge Peter     Brounrigge, Peter 1
4636666 2242294 2242294 defendant Perkynson Thomas     Perkynson, Thomas 2
4636667 2242294 2242294 defendant Holgill John   776706 776706 Holgill, John, of Aspaterik 3
4636668 2242294 2242294 defendant Cuthertson William   597288 597288 Cuthertson, William, of Dundrawe 4
4636669 2242294 2242294 defendant Youghonsbaud William     Youghonsbaud, William 5
4636670 2242294 2242294 defendant Kyn_ Thomas   776707 776707 Kyn_, Thomas, of Threpland 6
4636671 2242294 2242294 defendant del Shawe del Holme William     del Shawe del Holme, William 7
4636672 2242294 2242294 defendant del Halle John   776708 776708 del Halle, John, of Saltcotes 8
4636673 2242294 2242294 defendant Thomson Reynaldson John     Thomson Reynaldson, John 9
4636674 2242294 2242294 defendant Sandanhowe John     Sandanhowe, John 10
4636675 2242294 2242294 defendant Thomson Robert     Thomson, Robert 11
4636676 2242294 2242294 defendant Thomson Wilson Thomas     Thomson Wilson, Thomas 12
4636677 2242294 2242294 defendant Jonson William     Jonson, William 13
4636678 2242294 2242294 defendant Thomson Wilson John     Thomson Wilson, John 14
4636679 2242294 2242294 defendant Vicarman John     Vicarman, John 15
4636680 2242294 2242294 defendant Wamppull John     Wamppull, John 16
4636681 2242294 2242294 defendant Robynson Richard   761568 761568 Robynson, Richard, of Scaleby 17
4636682 2242294 2242294 defendant Sourby Thomas de   761568 761568 Sourby, Thomas de, of Scaleby 18
4636683 2242294 2242294 defendant Saunderson John   761568 761568 Saunderson, John, of Scaleby 19

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