names

16 rows where case_id = 2396110

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5132875 2396110 2396110 plaintiff Hochom John knight   Hochom, John, knight 0
5132876 2396110 2396110 defendant Wady Richard yeoman 757540 757540 Wady, Richard, of Ottelay, yeoman 0
5132877 2396110 2396110 defendant Wady Thomas yeoman 757540 757540 Wady, Thomas, of Ottelay, yeoman 1
5132878 2396110 2396110 defendant White William   796289 796289 White, William, of Ilkelay, vicar 2
5132879 2396110 2396110 defendant Aylmer John, senior yeoman 622834 622834 Aylmer, John, senior, of Westhall, yeoman 3
5132880 2396110 2396110 defendant Aylmer John, junior yeoman 622834 622834 Aylmer, John,junior, of Westhall, yeoman 4
5132881 2396110 2396110 defendant Wolhous William yeoman 850721 850721 Wolhous, William, of Keghlay, yeoman 5
5132882 2396110 2396110 defendant Rodes William yeoman 591805 591805 Rodes, William, of Otley, yeoman 6
5132883 2396110 2396110 defendant Cranyn Thomas yeoman 591805 591805 Cranyn, Thomas, of Otley, yeoman 7
5132884 2396110 2396110 defendant Firthbank John yeoman 595215 595215 Firthbank, John, of Tokwyth, yeoman 8
5132885 2396110 2396110 defendant Aish William chapman 764906 764906 Aish, William, of Repon, chapman 9
5132886 2396110 2396110 defendant Keton Jacob yeoman 589310 589310 Keton, Jacob, of Ripon, yeoman 10
5132887 2396110 2396110 defendant Keton James gent 589310 589310 Keton, James, of Ripon, gent 11
5132888 2396110 2396110 defendant Todde William chapman 764906 764906 Todde, William, of Repon, chapman 12
5132889 2396110 2396110 defendant Todde Thomas chapman 764906 764906 Todde, Thomas, of Repon, chapman 13
5132890 2396110 2396110 defendant Taillour Thomas Salley, yeoman   Taillour, Thomas, Salley, yeoman 14

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