names

29 rows where case_id = 2408518

✎ 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
5175481 2408518 2408518 plaintiff St Albans John abbot of the monastery, in   St Albans, John, abbot of the monastery, in 0
5175482 2408518 2408518 defendant Samson John ostler   Samson, John, ostler 0
5175483 2408518 2408518 defendant Lumbard John ostler   Lumbard, John, ostler 1
5175484 2408518 2408518 defendant Thorne Thomas chapman   Thorne, Thomas, chapman 2
5175485 2408518 2408518 defendant Wellys John tanner   Wellys, John, tanner 3
5175486 2408518 2408518 defendant Dyer Richard yeoman   Dyer, Richard, yeoman 4
5175487 2408518 2408518 defendant Porter Roger butcher   Porter, Roger, butcher 5
5175488 2408518 2408518 defendant Pouderfote William shoemaker   Pouderfote, William, shoemaker 6
5175489 2408518 2408518 defendant Horewode James baker   Horewode, James, baker 7
5175490 2408518 2408518 defendant Marchuant John baker, Lyn, John, ostler   Marchuant, John, baker, Lyn, John, ostler 8
5175491 2408518 2408518 defendant Spycer Nicholas servant   Spycer, Nicholas, servant 9
5175492 2408518 2408518 defendant Steynour Hugh cooper   Steynour, Hugh, cooper 10
5175493 2408518 2408518 defendant Purs William smith   Purs, William, smith 11
5175494 2408518 2408518 defendant Tylbery John tiler   Tylbery, John, tiler 12
5175495 2408518 2408518 defendant Coo William butcher   Coo, William, butcher 13
5175496 2408518 2408518 defendant Taverner John tanner   Taverner, John, tanner 14
5175497 2408518 2408518 defendant Aylebode   tailor   Aylebode, tailor 15
5175498 2408518 2408518 defendant Laborer Lewis laborer   Laborer, Lewis, laborer 16
5175499 2408518 2408518 defendant Felte Thomas fuller   Felte, Thomas, fuller 17
5175500 2408518 2408518 defendant Rys Richard husbandman 768005 768005 Rys, Richard, of Park, husbandman 18
5175501 2408518 2408518 defendant Dryver Richard husbandman 768005 768005 Dryver, Richard, of Park, husbandman 19
5175502 2408518 2408518 defendant Fox John chapman 587015 587015 Fox, John, of St Albans, chapman 20
5175503 2408518 2408518 defendant Turnour John husbandman 594912 594912 Turnour, John, of Aldenham, husbandman 21
5175504 2408518 2408518 defendant Colyn William husbandman 601514 601514 Colyn, William, of Caysho, husbandman 22
5175505 2408518 2408518 defendant Notkyn Henry miller 768005 768005 Notkyn, Henry, of Park, miller 23
5175506 2408518 2408518 defendant Neel Thomas laborer 594912 594912 Neel, Thomas, of Aldenham, laborer 24
5175507 2408518 2408518 defendant atte Hoo Thomas husbandman 768005 768005 atte Hoo, Thomas, of Park, husbandman 25
5175508 2408518 2408518 defendant Felyp William laborer 768005 768005 Felyp, William, of Park, laborer 26
5175509 2408518 2408518 defendant Moncaster Edward husbandman 591891 591891 Moncaster, Edward, of Colney, husbandman 27

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