names

10 rows where case_id = 2413290

✎ 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
5191616 2413290 2413290 plaintiff Middelton John knight   Middelton, John, knight 0
5191617 2413290 2413290 defendant Shiplo John     Shiplo, John 0
5191618 2413290 2413290 defendant Bell William     Bell, William 1
5191619 2413290 2413290 defendant Yonger Nicholas Bell, John   Yonger, Nicholas, Bell, John 2
5191620 2413290 2413290 defendant Paysshe John     Paysshe, John 3
5191621 2413290 2413290 defendant all of Thokeryngton   husbandman   all of Thokeryngton, husbandman 4
5191622 2413290 2413290 defendant Whetston John husbandman 857823 857823 Whetston, John, of Cayley, husbandman 5
5191623 2413290 2413290 defendant Elwald Joan widow 776210 776210 Elwald, Joan, of Thokeryngton, widow 6
5191624 2413290 2413290 defendant Twedall Richard chaplain 776210 776210 Twedall, Richard, of Thokeryngton, chaplain 7
5191625 2413290 2413290 defendant Whetstanes John   857824 857824 Whetstanes, John, of Thoke 8

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