names

15 rows where case_id = 2222122

✎ 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
4569745 2222122 2222122 plaintiff White Richard     White, Richard 0
4569746 2222122 2222122 defendant Bleseby William   764499 764499 Bleseby, William, of Bleseby 0
4569747 2222122 2222122 defendant Asfordby William   624811 624811 Asfordby, William, of Asfordby 1
4569748 2222122 2222122 defendant Walker (illegible)   770635 770635 Walker, _, of Little Cotes 2
4569749 2222122 2222122 defendant Grene Thomas   593113 593113 Grene, Thomas, of Grymesby 3
4569750 2222122 2222122 defendant Graynesby William   593113 593113 Graynesby, William, of Grymesby 4
4569751 2222122 2222122 defendant Kepyng (illegible) chaplain   Kepyng, _, chaplain 5
4569752 2222122 2222122 defendant Stokes Geoffrey   588802 588802 Stokes, Geoffrey, of Wotton 6
4569753 2222122 2222122 defendant Wuerby John   586846 586846 Wuerby, John, of Lincoln 7
4569754 2222122 2222122 defendant Pygot Thomas   770636 770636 Pygot, Thomas, of L_ W_ 8
4569755 2222122 2222122 defendant (illegible) of Grymesby chaplain   _, of Grymesby, chaplain 9
4569756 2222122 2222122 defendant Riby John   593375 593375 Riby, John, of Tenelby 10
4569757 2222122 2222122 defendant Doket John mercer   Doket, John, mercer 11
4569758 2222122 2222122 defendant Warde Thomas   766084 766084 Warde, Thomas, of Otteby 12
4569759 2222122 2222122 defendant Hosier Wiliam   703032 703032 Hosier, Wiliam, of East Rason 13

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