names

18 rows where case_id = 2299568

✎ 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
4811044 2299568 2299568 plaintiff (not given)   abbot of Fountains   Fountains, abbot, of 0
4811045 2299568 2299568 defendant Wryghton Thomas husbandman   Wryghton, Thomas, husbandman 0
4811046 2299568 2299568 defendant Halyday John husbandman   Halyday, John, husbandman 1
4811047 2299568 2299568 defendant Trygge John milner   Trygge, John, milner 2
4811048 2299568 2299568 defendant Maynerd Richard husbandman   Maynerd, Richard, husbandman 3
4811049 2299568 2299568 defendant Walburn John husbandman   Walburn, John, husbandman 4
4811050 2299568 2299568 defendant Bank William husbandman   Bank, William, husbandman 5
4811051 2299568 2299568 defendant Raskell William husbandman   Raskell, William, husbandman 6
4811052 2299568 2299568 defendant Brereton John husbandman   Brereton, John, husbandman 7
4811053 2299568 2299568 defendant Brereton William husbandman   Brereton, William, husbandman 8
4811054 2299568 2299568 defendant Smyth Richard husbandman   Smyth, Richard, husbandman 9
4811055 2299568 2299568 defendant Smyth Thomas husbandman   Smyth, Thomas, husbandman 10
4811056 2299568 2299568 defendant Lofthous Richard husbandman 690963 690963 Lofthous, Richard, of Wallerthwayt, husbandman 11
4811057 2299568 2299568 defendant Stones Thomas husbandman 690963 690963 Stones, Thomas, of Wallerthwayt, husbandman 12
4811058 2299568 2299568 defendant Everhird William husbandman 690963 690963 Everhird, William, of Wallerthwayt, husbandman 13
4811059 2299568 2299568 defendant Tayllour William husbandman 690963 690963 Tayllour, William, of Wallerthwayt, husbandman 14
4811060 2299568 2299568 defendant Tayllour Thomas husbandman 690963 690963 Tayllour, Thomas, of Wallerthwayt, husbandman 15
4811061 2299568 2299568 defendant all of Merkyngton unless denoted otherwise     all of Merkyngton, unless denoted otherwise 16

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