names

15 rows where case_id = 2457209

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5340424 2457209 2457209 plaintiff Ony or Ovy Nicholas     Ony or Ovy, Nicholas 0
5340425 2457209 2457209 plaintiff Coket John     Coket, John 1
5340426 2457209 2457209 plaintiff Dykes Thomas     Dykes, Thomas 2
5340427 2457209 2457209 defendant Giffys John laborer 678410 678410 Giffys, John, of Foston, Leics, laborer 0
5340428 2457209 2457209 defendant Mosse John laborer 875306 875306 Mosse, John, of Arnesley, Leics, laborer 1
5340429 2457209 2457209 defendant Bache Thomas husbandman 875307 875307 Bache, Thomas, of Magna Petelyng, Leics, husbandman 2
5340430 2457209 2457209 defendant Taillour William husbandman 801099 801099 Taillour, William, of Magna Petelyng, husbandman 3
5340431 2457209 2457209 defendant Cleybrook William husbandman 801099 801099 Cleybrook, William, of Magna Petelyng, husbandman 4
5340432 2457209 2457209 defendant Lammesse Richard husbandman 801099 801099 Lammesse, Richard, of Magna Petelyng, husbandman 5
5340433 2457209 2457209 defendant Talens Voluntine husbandman 801099 801099 Talens, Voluntine, of Magna Petelyng, husbandman 6
5340434 2457209 2457209 defendant Yonge John husbandman 801099 801099 Yonge, John, of Magna Petelyng, husbandman 7
5340435 2457209 2457209 defendant Wysetowe John, junior yeoman 801099 801099 Wysetowe, John, junior, of Magna Petelyng, yeoman 8
5340436 2457209 2457209 defendant Sylcoke Nicholas husbandman 873224 873224 Sylcoke, Nicholas, of Magna Assheby, Leics, husbandman 9
5340437 2457209 2457209 defendant Stokwell Richard yeoman 875308 875308 Stokwell, Richard, of Dreiton, Warks, yeoman 10
5340438 2457209 2457209 defendant Beson James laborer 586117 586117 Beson, James, of Coventry, laborer 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);