names

25 rows where place_id = 650337

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3911589 1994196 1994196 plaintiff Westall Jerome mercer 650337 650337 Westall, Jerome, of Woodstock, mercer 0
3956304 2009268 2009268 plaintiff Nasshe Michael gent 650337 650337 Nasshe, Michael, of Woodstock, gent 0
3961731 2011204 2011204 defendant Ryly William yeoman 650337 650337 Ryly, William, of Woodstock, yeoman 1
4051142 2042847 2042847 defendant Ryley William yeoman 650337 650337 Ryley, William, of Woodstock, yeoman 1
4144787 2076339 2076339 defendant James Humphrey yeoman 650337 650337 James, Humphrey, of Woodstock, yeoman 1
4146560 2076948 2076948 defendant James Humphrey yeoman 650337 650337 James, Humphrey, of Woodstock, yeoman 1
4172779 2085938 2085938 defendant Rygbye Arthur yeoman 650337 650337 Rygbye, Arthur, of Woodstock, or of Llanihangell or St Michael Cardigan, yeoman 0
4172785 2085939 2085939 defendant Rygbye Arthur yeoman 650337 650337 Rygbye, Arthur, of Woodstock, or of Llanihangell or St Michael Cardigan, yeoman 0
4172788 2085939 2085939 defendant Lloyde Randolph   650337 650337 Lloyde, Randolph, of Woodstock, or of Oswester, Salop gent 3
4176533 2087269 2087269 defendant Turner William draper 650337 650337 Turner, William, of Woodstock, draper 11
4248440 2112465 2112465 defendant Courte Edward   650337 650337 Courte, Edward, of Woodstock 3
4262924 2117264 2117264 defendant Courte Edward yeoman 650337 650337 Courte, Edward, of Woodstock, yeoman 3
4298711 2129639 2129639 defendant Browne John chandler 650337 650337 Browne, John, of Woodstock, chandler 0
4380126 2157995 2157995 defendant Reyley or Regley John   650337 650337 Reyley or Regley, John, of Woodstock, yeoman, his son 2
4522620 2207413 2207413 defendant Spicere Robert   650337 650337 Spicere, Robert, of Woodstock 0
4692495 2263169 2263169 plaintiff Wellere William   650337 650337 Wellere, William, of Woodstock 3
4718013 2270974 2270974 plaintiff Wellere William   650337 650337 Wellere, William, of Woodstock 3
4756569 2282417 2282417 defendant Wykam Thomas gent 650337 650337 Wykam, Thomas, of Woodstock, gent 1
4766628 2285555 2285555 defendant Tewe John yeoman 650337 650337 Tewe, John, of Woodstock, yeoman 1
4767377 2285784 2285784 plaintiff Marchall Thomas   650337 650337 Marchall, Thomas, of Woodstock 0
4768755 2286205 2286205 defendant Skennesby John gent 650337 650337 Skennesby, John, of Woodstock, gent 0
4843675 2309544 2309544 defendant Tewe John chapman 650337 650337 Tewe, John, of Woodstock, chapman 0
4846753 2310492 2310492 defendant Cosyn John butcher 650337 650337 Cosyn, John, of Woodstock, butcher 4
5001188 2357227 2357227 plaintiff Maykyn Thomas   650337 650337 Maykyn, Thomas, of Woodstock 0
5396617 2474124 2474124 defendant Broke Nicholas husbandman 650337 650337 Broke, Nicholas, of Woodstock, husbandman 4

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