names

29 rows where case_id = 1948881

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3771805 1948881 1948881 plaintiff Thymolby John knight   Thymolby, John, knight 0
3771806 1948881 1948881 defendant Kaye Ellen prior of Styxwold Priory   Kaye, Ellen, prior of Styxwold Priory 0
3771807 1948881 1948881 defendant Robynson John clerk 618809 618809 Robynson, John, of Styxwold, clerk 1
3771808 1948881 1948881 defendant Lesyng Robert husbandman 626720 626720 Lesyng, Robert, of West Toryngton, husbandman 2
3771809 1948881 1948881 defendant Swyne William husbandman 618809 618809 Swyne, William, of Styxwold, husbandman 3
3771810 1948881 1948881 defendant Cramlynton Anthony husbandman 618809 618809 Cramlynton, Anthony, of Styxwold, husbandman 4
3771811 1948881 1948881 defendant Sage John husbandman 618809 618809 Sage, John, of Styxwold, husbandman 5
3771812 1948881 1948881 defendant Robynson Thomas husbandman 618809 618809 Robynson, Thomas, of Styxwold, husbandman 6
3771813 1948881 1948881 defendant Wylson George husbandman 618809 618809 Wylson, George, of Styxwold, husbandman 7
3771814 1948881 1948881 defendant Bawdewyn Thomas husbandman 618809 618809 Bawdewyn, Thomas, of Styxwold, husbandman 8
3771815 1948881 1948881 defendant Anson William     Anson, William 9
3771816 1948881 1948881 defendant Shalys Thomas     Shalys, Thomas 10
3771817 1948881 1948881 defendant Dawson Thomas     Dawson, Thomas 11
3771818 1948881 1948881 defendant Dawson Alexander     Dawson, Alexander 12
3771819 1948881 1948881 defendant Johnson William     Johnson, William 13
3771820 1948881 1948881 defendant Yorke Thomas     Yorke, Thomas 14
3771821 1948881 1948881 defendant Gybson John     Gybson, John 15
3771822 1948881 1948881 defendant Bell William     Bell, William 16
3771823 1948881 1948881 defendant Pereson William     Pereson, William 17
3771824 1948881 1948881 defendant Borell William     Borell, William 18
3771825 1948881 1948881 defendant Sellers William     Sellers, William 19
3771826 1948881 1948881 defendant Wode Thomas     Wode, Thomas 20
3771827 1948881 1948881 defendant Atkyn John     Atkyn, John 21
3771828 1948881 1948881 defendant Sellers John     Sellers, John 22
3771829 1948881 1948881 defendant Madeson Richard     Madeson, Richard 23
3771830 1948881 1948881 defendant Roger Thomas     Roger, Thomas 24
3771831 1948881 1948881 defendant Colyngwood William     Colyngwood, William 25
3771832 1948881 1948881 defendant Tayllour John     Tayllour, John 26
3771833 1948881 1948881 defendant Pye John     Pye, John 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);