names

16 rows where case_id = 2257433

✎ 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
4673812 2257433 2257433 plaintiff del See Henry     del See, Henry, on his own account 0
4673813 2257433 2257433 defendant Appeley John butcher 647970 647970 Appeley, John, of Glentham, butcher 0
4673814 2257433 2257433 defendant Morton John husbandman 770665 770665 Morton, John, of Kesby, husbandman 1
4673815 2257433 2257433 defendant Whassyngburgh Robert yeoman 781660 781660 Whassyngburgh, Robert, of Welyngour, yeoman 2
4673816 2257433 2257433 defendant Overton Peter   764499 764499 Overton, Peter, of Bleseby, vicar 3
4673817 2257433 2257433 defendant Hode Richard husbandman 781662 781662 Hode, Richard, of Cletham, husbandman 4
4673818 2257433 2257433 defendant Skidgate Helen de widow 596711 596711 Skidgate, Helen de, of Gaynesburgh, widow 5
4673819 2257433 2257433 defendant Bocher William husbandman 603357 603357 Bocher, William, of Careby, husbandman 6
4673820 2257433 2257433 defendant Brantyngham William husbandman 590187 590187 Brantyngham, William, of Glentworth, husbandman 7
4673821 2257433 2257433 defendant Taillour John courser or horse dealer 781663 781663 Taillour, John, of Bisshop Nnorton, courser or horse dealer 8
4673822 2257433 2257433 defendant Carleton John yeoman 586846 586846 Carleton, John, of Lincoln, yeoman 9
4673823 2257433 2257433 defendant Puddesey John yeoman 717341 717341 Puddesey, John, of Misterton, Notts, yeoman 10
4673824 2257433 2257433 defendant Lassy Robert   591490 591490 Lassy, Robert, of Wynterton, Lincs 11
4673825 2257433 2257433 defendant Fulforth alias Hosyer Walter husbandman 781664 781664 Fulforth alias Hosyer, Walter, of Wragby, Lincs, husbandman 12
4673826 2257433 2257433 defendant Chaummberlayn Robert husbandman 588486 588486 Chaummberlayn, Robert, of Wynterton, husbandman 13
4673827 2257433 2257433 defendant of the Stable alias Colson William husbandman 614399 614399 of the Stable alias Colson, William, of Belyngton, husbandman 14

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