names

14 rows where case_id = 2322161

✎ 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
4884843 2322161 2322161 plaintiff Chedder Richard     Chedder, Richard 0
4884844 2322161 2322161 defendant Redehede Richard husbandman 817201 817201 Redehede, Richard, of Alston Mareys juxta Highbrigge, husbandman 0
4884845 2322161 2322161 defendant More Thomas husbandman 817201 817201 More, Thomas, of Alston Mareys juxta Highbrigge, husbandman 1
4884846 2322161 2322161 defendant Phelpys John husbandman 817201 817201 Phelpys, John, of Alston Mareys juxta Highbrigge, husbandman 2
4884847 2322161 2322161 defendant Stile Robert husbandman 817201 817201 Stile, Robert, of Alston Mareys juxta Highbrigge, husbandman 3
4884848 2322161 2322161 defendant Gosse John, senior husbandman 817201 817201 Gosse, John, senior, of Alston Mareys juxta Highbrigge, husbandman 4
4884849 2322161 2322161 defendant Gosse William husbandman 817201 817201 Gosse, William, of Alston Mareys juxta Highbrigge, husbandman 5
4884850 2322161 2322161 defendant Brounyng John husbandman 817201 817201 Brounyng, John, of Alston Mareys juxta Highbrigge, husbandman 6
4884851 2322161 2322161 defendant Canyngton William husbandman 817201 817201 Canyngton, William, of Alston Mareys juxta Highbrigge, husbandman 7
4884852 2322161 2322161 defendant Gosse John, junior husbandman 817201 817201 Gosse, John, junior, of Alston Mareys juxta Highbrigge, husbandman 8
4884853 2322161 2322161 defendant Hongrove John husbandman 766955 766955 Hongrove, John, of North Pedirton, husbandman 9
4884854 2322161 2322161 defendant There David laborer 638361 638361 There, David, of Worle, laborer 10
4884855 2322161 2322161 defendant Blafurlond William weaver 586368 586368 Blafurlond, William, of Taunton, weaver 11
4884856 2322161 2322161 defendant Peret John fisher 669776 669776 Peret, John, of Langeport, fisher 12

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