names

14 rows where case_id = 2460428

✎ 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
5351013 2460428 2460428 plaintiff Crouche William     Crouche, William 0
5351014 2460428 2460428 defendant Exnyng Henry   585869 585869 Exnyng, Henry, of London goldsmith 0
5351015 2460428 2460428 defendant Munnyng Elias   610081 610081 Munnyng, Elias, of Ratlisden, mason 1
5351016 2460428 2460428 defendant Shenebon Robert husbandman 590181 590181 Shenebon, Robert, of Denyngton, husbandman 2
5351017 2460428 2460428 defendant Loder Thomas husbandman 585947 585947 Loder, Thomas, of Hadley, husbandman 3
5351018 2460428 2460428 defendant Darle John tiler 598937 598937 Darle, John, of Leyham, tiler 4
5351019 2460428 2460428 defendant Orderych John husbandman 587716 587716 Orderych, John, of Hecham, husbandman 5
5351020 2460428 2460428 defendant Swalue John yeoman 591331 591331 Swalue, John, of Chellesworth, yeoman 6
5351021 2460428 2460428 defendant Humfrey Benedict husbandman 623870 623870 Humfrey, Benedict, of Wulpyt, husbandman 7
5351022 2460428 2460428 defendant Thorp John, senior husbandman 623870 623870 Thorp, John, senior, of Wulpyt, husbandman 8
5351023 2460428 2460428 defendant Rowyngton Robert fuller 585947 585947 Rowyngton, Robert, of Hadley, fuller 9
5351024 2460428 2460428 defendant Beltham Gregory fuller 585947 585947 Beltham, Gregory, of Hadley, fuller 10
5351025 2460428 2460428 defendant Baler William husbandman 598938 598938 Baler, William, of Neggyng, husbandman 11
5351026 2460428 2460428 defendant Powes William glover 595266 595266 Powes, William, of Neylond juxta Stoke, glover 12

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