names

16 rows where case_id = 2446477

✎ 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
5304919 2446477 2446477 plaintiff Kele Thomas     Kele, Thomas 0
5304920 2446477 2446477 defendant Palmer John husbandman 757805 757805 Palmer, John, of Foulestowe Marsh, husbandman 0
5304921 2446477 2446477 defendant Palmer Nicholas husbandman 757805 757805 Palmer, Nicholas, of Foulestowe Marsh, husbandman 1
5304922 2446477 2446477 defendant Palmer Stephen husbandman 757805 757805 Palmer, Stephen, of Foulestowe Marsh, husbandman 2
5304923 2446477 2446477 defendant Harryson William miller 757805 757805 Harryson, William, of Foulestowe Marsh, miller 3
5304924 2446477 2446477 defendant Johanna of the Here? of Foulestowe Marsh widow   Johanna of the Here?, of Foulestowe Marsh, widow 4
5304925 2446477 2446477 defendant Edward William husbandman 871073 871073 Edward, William, of Northoresby, husbandman 5
5304926 2446477 2446477 defendant Jakson Stephen tailor 768615 768615 Jakson, Stephen, of Authorp, tailor 6
5304927 2446477 2446477 defendant Smyth Robert smith 871074 871074 Smyth, Robert, of Stuxwold, smith 7
5304928 2446477 2446477 defendant Wastnese John shoemaker 757202 757202 Wastnese, John, of Sempyngham, shoemaker 8
5304929 2446477 2446477 defendant Lyson John husbandman 871073 871073 Lyson, John, of Northoresby, husbandman 9
5304930 2446477 2446477 defendant Thorald Thomas husbandman 871073 871073 Thorald, Thomas, of Northoresby, husbandman 10
5304931 2446477 2446477 defendant Paryssh John husbandman 631403 631403 Paryssh, John, of Fotherby, husbandman 11
5304932 2446477 2446477 defendant Howelot Thomas husbandman 629415 629415 Howelot, Thomas, of North Cotes, husbandman 12
5304933 2446477 2446477 defendant Deen John chaplain 629415 629415 Deen, John, of North Cotes, chaplain 13
5304934 2446477 2446477 defendant Duffeld Thomas chapman 604829 604829 Duffeld, Thomas, of Great Grymesby, chapman 14

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