names

13 rows where case_id = 2507367

✎ 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
5507879 2507367 2507367 plaintiff Davy Nicholas mercer 585936 585936 Davy, Nicholas, of Norwich, mercer 0
5507880 2507367 2507367 defendant Hug William husbandman 596907 596907 Hug, William, of Ludham, husbandman 0
5507881 2507367 2507367 defendant Baker William clerk 698653 698653 Baker, William, of Hoveton St Peter, clerk 1
5507882 2507367 2507367 defendant Mayn William baker 586471 586471 Mayn, William, of Aylesham, baker 2
5507883 2507367 2507367 defendant Barnard Thomas husbandman 588126 588126 Barnard, Thomas, of North Walsham, husbandman 3
5507884 2507367 2507367 defendant Base John, junior husbandman 586471 586471 Base, John, junior, of Aylesham, husbandman 4
5507885 2507367 2507367 defendant Bradle Thomas yeoman 586102 586102 Bradle, Thomas, of Hengham, yeoman 5
5507886 2507367 2507367 defendant Petyston Geoffrey clerk 587786 587786 Petyston, Geoffrey, of Rynglond, clerk 6
5507887 2507367 2507367 defendant Thymbyll Robert yeoman 587172 587172 Thymbyll, Robert, of Est Derham, yeoman 7
5507888 2507367 2507367 defendant Plattyng John yeoman 586041 586041 Plattyng, John, of Old Bokenham, yeoman 8
5507889 2507367 2507367 defendant Pekke Ralph tailor 586471 586471 Pekke, Ralph, of Aylesham, tailor 9
5507890 2507367 2507367 defendant Matsale Thomas husbandman 587167 587167 Matsale, Thomas, of Parva Walsyngham, husbandman 10
5507891 2507367 2507367 defendant Ketylston William husbandman 587167 587167 Ketylston, William, of Parva Walsyngham, husbandman 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);