names

16 rows where case_id = 2280067

✎ 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
4748504 2280067 2280067 plaintiff Master of the hospital of St Leonards York     Master of the hospital of St Leonards, York 0
4748505 2280067 2280067 defendant Hyll John butcher 588864 588864 Hyll, John, of Bedale, butcher 0
4748506 2280067 2280067 defendant Thyrn John, senior husbandman 588864 588864 Thyrn, John, senior, of Bedale, husbandman 1
4748507 2280067 2280067 defendant Threpland Henry tailor 588864 588864 Threpland, Henry, of Bedale, tailor 2
4748508 2280067 2280067 defendant Burrell William tailor 588864 588864 Burrell, William, of Bedale, tailor 3
4748509 2280067 2280067 defendant Beste William tailor 588864 588864 Beste, William, of Bedale, tailor 4
4748510 2280067 2280067 defendant Burrell Richard weaver 588864 588864 Burrell, Richard, of Bedale, weaver 5
4748511 2280067 2280067 defendant Langton William milner 588864 588864 Langton, William, of Bedale, milner 6
4748512 2280067 2280067 defendant Thomson John ofBedale, tailor   Thomson, John, ofBedale, tailor 7
4748513 2280067 2280067 defendant Wade Simon   588864 588864 Wade, Simon, of Bedale, wright 8
4748514 2280067 2280067 defendant Raper William raper 588864 588864 Raper, William, of Bedale, raper 9
4748515 2280067 2280067 defendant Vale Thomas draper 588864 588864 Vale, Thomas, of Bedale, draper 10
4748516 2280067 2280067 defendant Rande Simon clerk 588864 588864 Rande, Simon, of Bedale, clerk 11
4748517 2280067 2280067 defendant Frythby Thomas husbandman 795943 795943 Frythby, Thomas, of Frithby, husbandman 12
4748518 2280067 2280067 defendant Nicolson John husbandman 795943 795943 Nicolson, John, of Frithby, husbandman 13
4748519 2280067 2280067 defendant Dees Thomas husbandman 761815 761815 Dees, Thomas, of Frythby, husbandman 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);