names

13 rows where case_id = 2326125

✎ 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
4898282 2326125 2326125 plaintiff Fulthorp Thomas     Fulthorp, Thomas 0
4898283 2326125 2326125 defendant Andrewe William gent 600405 600405 Andrewe, William, of Stoke juxta Ipswich, gent 0
4898284 2326125 2326125 defendant Andrewe Thomas gent 600405 600405 Andrewe, Thomas, of Stoke juxta Ipswich, gent 1
4898285 2326125 2326125 defendant Margery John yeoman 600405 600405 Margery, John, of Stoke juxta Ipswich, yeoman 2
4898286 2326125 2326125 defendant Castell Reginald   600405 600405 together with Castell, Reginald, of Stoke juxta Ipswich, wheelwright 3
4898287 2326125 2326125 defendant Abbrede Robert fuller 600405 600405 Abbrede, Robert, of Stoke juxta Ipswich, fuller 4
4898288 2326125 2326125 defendant Fennyng John, junior   600405 600405 Fennyng, John, junior, of Stoke juxta Ipswich, servant 5
4898289 2326125 2326125 defendant Hamonde Robert laborer 586134 586134 Hamonde, Robert, of Ipswich, fuller, Pepir, John, of Ipswich, laborer 6
4898290 2326125 2326125 defendant Morkyn Robert fuller 586134 586134 Morkyn, Robert, of Ipswich, fuller 7
4898291 2326125 2326125 defendant Kemp John sherman 586134 586134 Kemp, John, of Ipswich, sherman 8
4898292 2326125 2326125 defendant Gerraste Henry cutler 586134 586134 Gerraste, Henry, of Ipswich, cutler 9
4898293 2326125 2326125 defendant Fox Nicholas fuller 586134 586134 Fox, Nicholas, of Ipswich, fuller 10
4898294 2326125 2326125 defendant Byrde John fuller 586134 586134 Byrde, John, of Ipswich, fuller 11

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