names

30 rows where place_id = 593592

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612485 1871538 1871538 defendant Watson William yeoman 593592 593592 Watson, William, of Thorney, yeoman 0
3882755 1984496 1984496 defendant Grubbe Thomas husbandman 593592 593592 Grubbe, Thomas, of Thorney, husbandman 0
3966732 2012998 2012998 defendant Grove Thomas husbandman 593592 593592 Grove, Thomas, of Thorney, husbandman 0
4061567 2046535 2046535 defendant Mekeley William yeoman 593592 593592 Mekeley, William, of Thorney, yeoman 0
4656103 2247787 2247787 defendant Lokke John drover 593592 593592 Lokke, John, of Thorney, drover 5
4663454 2250047 2250047 plaintiff Godfrey Simon   593592 593592 Godfrey, Simon, of Thorney 0
4663458 2250048 2250048 plaintiff Godfrey Simon   593592 593592 Godfrey, Simon, of Thorney 0
4689515 2262278 2262278 defendant Pulney John husbandman 593592 593592 Pulney, John, of Thorney, husbandman 0
4698324 2264954 2264954 defendant Thorney Thomas   593592 593592 Thorney, Thomas, of Thorney 0
4752994 2281326 2281326 defendant Cordale John husbandman 593592 593592 Cordale, John, of Thorney, husbandman 1
4765617 2285236 2285236 defendant Hotot John, sen gent 593592 593592 Hotot, John, sen, of Thorney, gent 0
4771487 2287063 2287063 plaintiff Schyrwynd John   593592 593592 Schyrwynd, John, of Thorney 0
4790286 2293047 2293047 defendant Hotot John, senior gent 593592 593592 Hotot, John, senior, of Thorney, gent 0
4852008 2312061 2312061 defendant atte Holme Henry husbandman 593592 593592 atte Holme, Henry, of Thorney, husbandman 1
4863387 2315517 2315517 defendant Holm Henry husbandman 593592 593592 Holm, Henry, of Thorney, husbandman 0
4873715 2318722 2318722 defendant Dego John husbandman 593592 593592 Dego, John, of Thorney, husbandman 1
4888924 2323319 2323319 defendant Counch Geoffrey husbandman 593592 593592 Counch, Geoffrey, of Thorney, husbandman 3
4920335 2332875 2332875 defendant Brycete John   593592 593592 Brycete, John, of Thorney by Stowemarker 0
4921019 2333086 2333086 plaintiff Kirketon John or Alan   593592 593592 Kirketon, John or Alan, of Thorney, abbot 0
4921023 2333087 2333087 plaintiff Kirketon John or Alan   593592 593592 Kirketon, John or Alan, of Thorney, abbot 0
4977147 2350119 2350119 defendant Brysett John butcher 593592 593592 Brysett, John, of Thorney, butcher 0
5250742 2430341 2430341 defendant Morgon Gilbert laborer 593592 593592 Morgon, Gilbert, of Thorney, laborer 1
5260171 2433307 2433307 defendant Wode Thomas husbandman 593592 593592 Wode, Thomas, of Thorney, husbandman 0
5361281 2463552 2463552 defendant Fox Robert yeoman 593592 593592 Fox, Robert, of Thorney, yeoman 11
5374192 2467527 2467527 defendant Penyngton Henry yeoman 593592 593592 Penyngton, Henry, of Thorney, yeoman 0
5374195 2467528 2467528 defendant Penyngton Henry yeoman 593592 593592 Penyngton, Henry, of Thorney, yeoman 0
5379291 2469115 2469115 plaintiff Wisbech Thomas   593592 593592 Wisbech, Thomas, of Thorney, abbot of the Monastery of Blessed Mary & St Botolph 0
5390873 2472456 2472456 defendant Penyngton Henry yeoman 593592 593592 Penyngton, Henry, of Thorney, yeoman 0
5403814 2476165 2476165 defendant Penyngton Henry yeoman 593592 593592 Penyngton, Henry, of Thorney, yeoman 0
5403820 2476167 2476167 defendant Revyngton Henry yeoman 593592 593592 Revyngton, Henry, of Thorney, yeoman 0

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