names

45 rows where place_id = 602411

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650020 1910374 1910374 defendant Pygot John yeoman 602411 602411 Pygot, John, of Bawdesey, yeoman 0
3679957 1919796 1919796 defendant Wall John husbandman 602411 602411 Wall, John, of Bawdesey, husbandman 3
3685732 1921695 1921695 defendant Rycher Roger husbandman 602411 602411 Rycher, Roger, of Bawdesey, husbandman 0
3704994 1927855 1927855 defendant Waller John husbandman 602411 602411 Waller, John, of Bawdesey, husbandman 0
3719040 1932231 1932231 defendant Wall John husbandman 602411 602411 Wall, John, of Bawdesey, husbandman 0
3724060 1933810 1933810 defendant Stragy John husbandman 602411 602411 Stragy, John, of Bawdesey, husbandman 0
3732261 1936330 1936330 defendant Gylmyn John husbandman 602411 602411 Gylmyn, John, of Bawdesey, husbandman 2
3748430 1941443 1941443 defendant recher Roger husbandman 602411 602411 recher, Roger, of Bawdesey, husbandman 0
3762727 1945984 1945984 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3763584 1946244 1946244 defendant Renge William husbandman 602411 602411 Renge, William, of Bawdesey, husbandman 1
3770518 1948462 1948462 defendant Rechar Roger husbandman 602411 602411 Rechar, Roger, of Bawdesey, husbandman 1
3776910 1950518 1950518 defendant Browne John yeoman 602411 602411 Browne, John, of Bawdesey, yeoman 1
3783550 1952612 1952612 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3791509 1955184 1955184 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3800012 1957927 1957927 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3803370 1958954 1958954 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3804553 1959364 1959364 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3817441 1963369 1963369 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3818302 1963631 1963631 defendant Smyth Thomas husbandman 602411 602411 Smyth, Thomas, of Bawdesey, husbandman 0
3818303 1963631 1963631 defendant Smyth Robert laborer 602411 602411 Smyth, Robert, of Bawdesey, laborer 1
3820763 1964384 1964384 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3831469 1967728 1967728 defendant Forest James husbandman 602411 602411 Forest, James, of Bawdesey, husbandman 0
3880604 1983776 1983776 defendant Harvy John yeoman 602411 602411 Harvy, John, of Bawdesey, yeoman 1
3881776 1984158 1984158 defendant Recher Roger husbandman 602411 602411 Recher, Roger, of Bawdesey, husbandman 0
3894571 1988394 1988394 defendant Mores John husbandman 602411 602411 Mores, John, of Bawdesey, husbandman 0
3894572 1988394 1988394 defendant Thompson Robert laborer 602411 602411 Thompson, Robert, of Bawdesey, laborer 1
3906812 1992568 1992568 defendant Oldman William husbandman 602411 602411 Oldman, William, of Bawdesey, husbandman 0
3909581 1993509 1993509 defendant Richar Roger husbandman 602411 602411 Richar, Roger, of Bawdesey, husbandman 0
3909582 1993509 1993509 defendant Margett John husbandman 602411 602411 Margett, John, of Bawdesey, husbandman 1
3912005 1994339 1994339 defendant Tompson Robert husbandman 602411 602411 Tompson, Robert, of Bawdesey, husbandman 1
4110271 2063936 2063936 defendant Best John husbandman 602411 602411 Best, John, of Bawdesey, husbandman 0
4110272 2063936 2063936 defendant Best Robert husbandman 602411 602411 Best, Robert, of Bawdesey, husbandman 1
4302116 2130865 2130865 defendant Borrett Henry yeoman 602411 602411 Borrett, Henry, of Bawdesey, yeoman 0
4302119 2130865 2130865 defendant Everest Robert yeoman 602411 602411 Everest, Robert, of Bawdesey, yeoman 3
4336620 2142534 2142534 defendant Stannard William   602411 602411 Stannard, William, of Bawdesey, or of Melton, twill weaver 2
5066120 2376390 2376390 defendant Cumpanowe Walter mercer 602411 602411 Cumpanowe, Walter, of Bawdesey, mercer 0
5262758 2434093 2434093 plaintiff Pegot John   602411 602411 Pegot, John, of Bawdesey 0
5324281 2452354 2452354 plaintiff Pygot John   602411 602411 Pygot, John, of Bawdesey 0
5440219 2486974 2486974 defendant Pygot Thomas husbandman 602411 602411 Pygot, Thomas, of Bawdesey, husbandman 0
5440220 2486974 2486974 defendant Skynner John   602411 602411 Skynner, John, of Bawdesey, sailor 1
5440221 2486974 2486974 defendant Hoberd Richard   602411 602411 Hoberd, Richard, of Bawdesey, sailor 2
5440223 2486975 2486975 defendant Pygot Thomas husbandman 602411 602411 Pygot, Thomas, of Bawdesey, husbandman 0
5440224 2486975 2486975 defendant Skynner John   602411 602411 Skynner, John, of Bawdesey, sailor 1
5440225 2486975 2486975 defendant Hoberd Richard   602411 602411 Hoberd, Richard, of Bawdesey, sailor 2
5607171 2537132 2537132 defendant Walle John yeoman 602411 602411 Walle, John, of Bawdesey, 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);