names

16 rows where case_id = 2497872

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5476141 2497872 2497872 plaintiff Titley Humphre     Titley, Humphre 0
5476142 2497872 2497872 defendant Cholmeley John husbandman   Cholmeley, John, husbandman 0
5476143 2497872 2497872 defendant Harley Richard yeoman   Harley, Richard, yeoman 1
5476144 2497872 2497872 defendant Harley Humphrey yeoman   Harley, Humphrey, yeoman 2
5476145 2497872 2497872 defendant Herley William yeoman   Herley, William, yeoman 3
5476146 2497872 2497872 defendant Trewelove Hugh husbandman   Trewelove, Hugh, husbandman 4
5476147 2497872 2497872 defendant Trewelove Richard     Trewelove, Richard 5
5476148 2497872 2497872 defendant Honderson Richard husbandman   Honderson, Richard, husbandman 6
5476149 2497872 2497872 defendant Gregore Richard husbandman   Gregore, Richard, husbandman 7
5476150 2497872 2497872 defendant Tewe John husbandman   Tewe, John, husbandman 8
5476151 2497872 2497872 defendant Fraunces James husbandman   Fraunces, James, husbandman 9
5476152 2497872 2497872 defendant Hondson William husbandman   Hondson, William, husbandman 10
5476153 2497872 2497872 defendant Avyse Thomas husbandman   Avyse, Thomas, husbandman 11
5476154 2497872 2497872 defendant Pereson John husbandman   Pereson, John, husbandman 12
5476155 2497872 2497872 defendant Cholmeley William yeoman   Cholmeley, William, yeoman 13
5476156 2497872 2497872 defendant Chidlowe John   710293 710293 Chidlowe, John, of husbandman 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);