names

13 rows where case_id = 2007332

✎ 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
3950736 2007332 2007332 plaintiff George William     George, William 0
3950737 2007332 2007332 defendant Richard Henry John husbandman 659017 659017 Richard, Henry John, of Llanyhangell Apontemoy, Monmouth, husbandman 0
3950738 2007332 2007332 defendant Syr Roger laborer 659018 659018 Syr, Roger, of Nunupton, Herefs, laborer 1
3950739 2007332 2007332 defendant Price Richard laborer 659019 659019 Price, Richard, of Clehunger, Herefs, laborer 2
3950740 2007332 2007332 defendant Ranell or Ravell William, senior husbandman 659020 659020 Ranell or Ravell, William, senior, of Wolhope, Herefs, husbandman 3
3950741 2007332 2007332 defendant Farmer John husbandman 639372 639372 Farmer, John, of Elsfeld, Worcs, husbandman 4
3950742 2007332 2007332 defendant Apowell John husbandman 659021 659021 Apowell, John, of Glynetvoye, Brecon, husbandman 5
3950743 2007332 2007332 defendant Apowell Owen husbandman 659022 659022 Apowell, Owen, of Glynetvoye, husbandman 6
3950744 2007332 2007332 defendant ap Rees Henry gent 659022 659022 ap Rees, Henry, of Glynetvoye, gent 7
3950745 2007332 2007332 defendant ap Jevan David gent 659022 659022 ap Jevan, David, of Glynetvoye, gent 8
3950746 2007332 2007332 defendant Reynold Thomas sawyer 659023 659023 Reynold, Thomas, of Pembrydge, Herefs, sawyer 9
3950747 2007332 2007332 defendant Cooke William yeoman 659024 659024 Cooke, William, of Stannege, Herefs, yeoman 10
3950748 2007332 2007332 defendant Howes Richard tailor 644564 644564 Howes, Richard, of Leominster, Herefs, tailor 11

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