names

7 rows where case_id = 2421414

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5219443 2421414 2421414 plaintiff Hekenns William (legal representative) 635172 635172 Hekenns, William, of Ilmyndon, executors of 0
5219444 2421414 2421414 plaintiff Archer William     (Archer, William 1
5219445 2421414 2421414 plaintiff Okeley William     Okeley, William 2
5219446 2421414 2421414 defendant Edeyn John husbandman 860662 860662 Edeyn, John, of Donyngton, Glos, husbandman 0
5219447 2421414 2421414 defendant Gawege Robert husbandman 635172 635172 Gawege, Robert, of Ilmyndon, husbandman 1
5219448 2421414 2421414 defendant Barbour John ostler 591343 591343 Barbour, John, of Chepyng Norton, Oxon, ostler 2
5219449 2421414 2421414 defendant Kenkeham John husbandman 635172 635172 Kenkeham, John, of Ilmyndon, husbandman 3

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