names

15 rows where case_id = 2436382

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5270185 2436382 2436382 plaintiff Damme Simon     Damme, Simon, on his own account 0
5270186 2436382 2436382 defendant Goddyng Godfrey yeoman 654182 654182 Goddyng, Godfrey, of Little Snoryng, yeoman 0
5270187 2436382 2436382 defendant Magnus Nicholas   608771 608771 Magnus, Nicholas, of Felbrygge, shepherd 1
5270188 2436382 2436382 defendant Yoxhale Robert yeoman 596907 596907 Yoxhale, Robert, of Ludham, yeoman 2
5270189 2436382 2436382 defendant Moors John tiler 589928 589928 Moors, John, of Mendham, tiler 3
5270190 2436382 2436382 defendant Kempe Hugh husbandman 586940 586940 Kempe, Hugh, of Baldeswell, husbandman 4
5270191 2436382 2436382 defendant Peye Robert   586471 586471 Peye, Robert, of Aylesham, mason 5
5270192 2436382 2436382 defendant Elyce Simon husbandman 602141 602141 Elyce, Simon, of Banyngham, husbandman 6
5270193 2436382 2436382 defendant Reede John merchant 599856 599856 Reede, John, of Beccles, Suff, merchant 7
5270194 2436382 2436382 defendant Bradle Thomas   590844 590844 Bradle, Thomas, of Lyng, bell hanger 8
5270195 2436382 2436382 defendant Skepp William fishman   Skepp, William, fishman 9
5270196 2436382 2436382 defendant Pykto Alan husbandman 754916 754916 Pykto, Alan, of Great Walsyngham, husbandman 10
5270197 2436382 2436382 defendant Wryght William husbandman 703520 703520 Wryght, William, of Wharham, husbandman 11
5270198 2436382 2436382 defendant Gedney (illegible) husbandman 586516 586516 Gedney, ----, of Marsham, husbandman 12
5270199 2436382 2436382 defendant Barly John chaplain 586157 586157 Barly, John, of Mateshale, chaplain 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);