names

41 rows where case_id = 2493399

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5461529 2493399 2493399 plaintiff Musgrave Nicholas     Musgrave, Nicholas 0
5461530 2493399 2493399 defendant Garnet John   585995 585995 Garnet, John, of Neweton 0
5461531 2493399 2493399 defendant Elyson John   890041 890041 Elyson, John, of Newetton 1
5461532 2493399 2493399 defendant Redhed John   890041 890041 Redhed, John, of Newetton 2
5461533 2493399 2493399 defendant Morthyng John   890041 890041 Morthyng, John, of Newetton 3
5461534 2493399 2493399 defendant Martyndayl Christopher of Langrigge gent   Martyndayl, Christopher of Langrigge, gent 4
5461535 2493399 2493399 defendant Mechell John husbandman 890042 890042 Mechell, John, of Bowestaill, husbandman 5
5461536 2493399 2493399 defendant Jamys John husbandman 890043 890043 Jamys, John, of Crokherst, husbandman 6
5461537 2493399 2493399 defendant Willyamson John   890044 890044 Willyamson, John, of Alenby 7
5461538 2493399 2493399 defendant Martyndale Thomas   890044 890044 Martyndale, Thomas, of Alenby 8
5461539 2493399 2493399 defendant Martyndale Robert   890044 890044 Martyndale, Robert, of Alenby 9
5461540 2493399 2493399 defendant Fakon William   890044 890044 Fakon, William, of Alenby 10
5461541 2493399 2493399 defendant Henrison John   890044 890044 Henrison, John, of Alenby 11
5461542 2493399 2493399 defendant Henrison Thomas   890044 890044 Henrison, Thomas, of Alenby 12
5461543 2493399 2493399 defendant Hechunson Thomas   890044 890044 Hechunson, Thomas, of Alenby 13
5461544 2493399 2493399 defendant Hechunson Henry   890044 890044 Hechunson, Henry, of Alenby 14
5461545 2493399 2493399 defendant Hudson William   890044 890044 Hudson, William, of Alenby 15
5461546 2493399 2493399 defendant Hudson John   890045 890045 Hudson, John, of Poweryng 16
5461547 2493399 2493399 defendant Sibson John, sen   890044 890044 Sibson, John, sen, of Alenby 17
5461548 2493399 2493399 defendant Sibson John jun, of Alenby   Sibson, John, jun, of Alenby 18
5461549 2493399 2493399 defendant Huddilston Richard gent 890046 890046 Huddilston, Richard, of Gilcrosse, gent 19
5461550 2493399 2493399 defendant Poye Richard   890046 890046 Poye, Richard, of Gilcrosse 20
5461551 2493399 2493399 defendant Hatter Robert   605988 605988 Hatter, Robert, of Aspatria 21
5461552 2493399 2493399 defendant Elisson John   605988 605988 Elisson, John, of Aspatria 22
5461553 2493399 2493399 defendant Belle Wiliam   605988 605988 Belle, Wiliam, of Aspatria 23
5461554 2493399 2493399 defendant Yonghusbond William   605988 605988 Yonghusbond, William, of Aspatria 24
5461555 2493399 2493399 defendant Morthyng William   605988 605988 Morthyng, William, of Aspatria 25
5461556 2493399 2493399 defendant Camerton William   605988 605988 Camerton, William, of Aspatria 26
5461557 2493399 2493399 defendant Martyndale Robert gent 605988 605988 Martyndale, Robert, of Aspatria, gent 27
5461558 2493399 2493399 defendant Festayn William   605988 605988 Festayn, William, of Aspatria 28
5461559 2493399 2493399 defendant Deyson Thomas   605988 605988 Deyson, Thomas, of Aspatria 29
5461560 2493399 2493399 defendant Kyrssey John   605988 605988 Kyrssey, John, of Aspatria 30
5461561 2493399 2493399 defendant Bratton John, sen   890047 890047 Bratton, John, sen, of Aspartia 31
5461562 2493399 2493399 defendant Bratton Robert jun, of Aspatria   Bratton, Robert, jun, of Aspatria 32
5461563 2493399 2493399 defendant Bratton John jun, of Aspatria   Bratton, John, jun, of Aspatria 33
5461564 2493399 2493399 defendant Sympyll Thomas   605988 605988 Sympyll, Thomas, of Aspatria 34
5461565 2493399 2493399 defendant Murray John   890047 890047 Murray, John, of Aspartia 35
5461566 2493399 2493399 defendant Martyndale John   605988 605988 Martyndale, John, of Aspatria 36
5461567 2493399 2493399 defendant Yonghusband Robert   890048 890048 Yonghusband, Robert, of Aspatri 37
5461568 2493399 2493399 defendant Inglisse William   890049 890049 Inglisse, William, of Ultirsid 38
5461569 2493399 2493399 defendant Cok Alexander miller 890049 890049 Cok, Alexander, of Ultirsid, miller 39

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