names

31 rows where place_id = 596878

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626488 1903139 1903139 defendant Hyggys Thomas laborer 596878 596878 Hyggys, Thomas, of Wylnall, laborer 5
3626489 1903139 1903139 defendant Chesshyre Richard laborer 596878 596878 Chesshyre, Richard, of Wylnall, laborer 6
3626494 1903139 1903139 defendant Smyth Humphrey laborer 596878 596878 Smyth, Humphrey, of Wylnall, laborer 11
3626495 1903139 1903139 defendant Philyppys Robert laborer 596878 596878 Philyppys, Robert, of Wylnall, laborer 12
3626511 1903143 1903143 defendant Beamound James gent 596878 596878 Beamound, James, of Wylnall, gent 0
3637737 1906617 1906617 defendant Bayly Nicholas gent 596878 596878 Bayly, Nicholas, of Wylnall, gent 0
3637742 1906619 1906619 defendant Baylly Nicholas gent 596878 596878 Baylly, Nicholas, of Wylnall, gent 0
3637744 1906620 1906620 defendant Bayly Nicholas gent 596878 596878 Bayly, Nicholas, of Wylnall, gent 0
3692961 1923999 1923999 defendant Baylly Nicholas gent 596878 596878 Baylly, Nicholas, of Wylnall, gent 0
3704226 1927620 1927620 defendant Baker Benedict husbandman 596878 596878 Baker, Benedict, of Wylnall, husbandman 2
3737333 1937912 1937912 defendant Fleccher William husbandman 596878 596878 Fleccher, William, of Wylnall, husbandman 4
3737437 1937948 1937948 defendant Hethe Richard laborer 596878 596878 Hethe, Richard, of Wylnall, laborer 3
3753979 1943195 1943195 defendant Bradeley Richard chaplain 596878 596878 Bradeley, Richard, of Wylnall, chaplain 0
3753980 1943195 1943195 defendant Prestwode John husbandman 596878 596878 Prestwode, John, of Wylnall, husbandman 1
3771177 1948674 1948674 defendant Bradeley Richard chaplain 596878 596878 Bradeley, Richard, of Wylnall, chaplain 0
3771178 1948674 1948674 defendant Prestwode John husbandman 596878 596878 Prestwode, John, of Wylnall, husbandman 1
3794726 1956225 1956225 defendant Heylyn Nicholas merchant of the staple 596878 596878 Heylyn, Nicholas, of Wylnall, merchant of the staple 1
3821140 1964507 1964507 defendant Heylyn Nicholas merchant of the staple 596878 596878 Heylyn, Nicholas, of Wylnall, merchant of the staple 0
3852789 1974478 1974478 defendant Heylyn Nicholas merchant of the staple 596878 596878 Heylyn, Nicholas, of Wylnall, merchant of the staple 0
3855248 1975275 1975275 defendant Fletcher William husbandman 596878 596878 Fletcher, William, of Wylnall, husbandman 0
3889536 1986732 1986732 defendant Heylyn Nicholas merchant of the staple 596878 596878 Heylyn, Nicholas, of Wylnall, gent, merchant of the staple 0
3986697 2019983 2019983 defendant Grene Richard, senior husbandman 596878 596878 Grene, Richard, senior, of Wylnall, husbandman 0
3986698 2019983 2019983 defendant Grene Richard, junior husbandman 596878 596878 Grene, Richard, junior, of Wylnall, husbandman 1
4051171 2042857 2042857 defendant Wylk Anne widow 596878 596878 Wylk, Anne, of Wylnall, widow 0
4051172 2042857 2042857 defendant Wylk John, senior gent 596878 596878 Wylk, John, senior, of Wylnall, gent 1
4051173 2042857 2042857 defendant Wylk John, junior gent 596878 596878 Wylk, John, junior, of Wylnall, gent 2
4189579 2091856 2091856 defendant Hanson William laborer 596878 596878 Hanson, William, of Wylnall, laborer 0
4189580 2091856 2091856 defendant Davye Thomas husbandman 596878 596878 Davye, Thomas, of Wylnall, husbandman 1
4189581 2091856 2091856 defendant Jones Richard laborer 596878 596878 Jones, Richard, of Wylnall, laborer 2
4331200 2140734 2140734 defendant Jevon Henry laborer 596878 596878 Jevon, Henry, of Wylnall, laborer 0
5607217 2537145 2537145 defendant Bayly Nicholas gent 596878 596878 Bayly, Nicholas, of Wylnall, gent 1

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