names

34 rows where place_id = 792643

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4730808 2274836 2274836 defendant Smyth Richard husbandman 792643 792643 Smyth, Richard, of Sampford Courtenay, husbandman 0
4779880 2289706 2289706 defendant Dyklegge John husbandman 792643 792643 Dyklegge, John, of Sampford Courtenay, husbandman 0
4779881 2289706 2289706 defendant Dyklegge Richard husbandman 792643 792643 Dyklegge, Richard, of Sampford Courtenay, husbandman 1
4787640 2292204 2292204 defendant Radewey Henry husbandman 792643 792643 Radewey, Henry, of Sampford Courtenay, husbandman 0
4796310 2294994 2294994 defendant Stoyle John, senior husbandman 792643 792643 Stoyle, John, senior, of Sampford Courtenay, husbandman 0
4807130 2298428 2298428 defendant Talon William husbandman 792643 792643 Talon, William, of Sampford Courtenay, husbandman 4
4841510 2308875 2308875 defendant Westwaye John husbandman 792643 792643 Westwaye, John, of Sampford Courtenay, husbandman 0
4919876 2332725 2332725 defendant Parys Ricihard husbandman 792643 792643 Parys, Ricihard, of Sampford Courtenay, husbandman 0
4923474 2333773 2333773 defendant Holand John husbandman 792643 792643 Holand, John, of Sampford Courtenay, husbandman 1
5012072 2360378 2360378 defendant Berman John husbandman 792643 792643 Berman, John, of Sampford Courtenay, husbandman 5
5012073 2360378 2360378 defendant Olyver Richard laborer 792643 792643 Olyver Richard, of Sampford Courtenay, laborer 6
5037902 2367965 2367965 defendant Bearman John husbandman 792643 792643 Bearman, John, of Sampford Courtenay, husbandman 5
5037903 2367965 2367965 defendant Olyver Richard laborer 792643 792643 Olyver, Richard, of Sampford Courtenay, laborer 6
5069497 2377375 2377375 defendant Canne John   792643 792643 Canne, John, of Sampford Courtenay: smith 3
5106114 2388225 2388225 defendant Fulford John yeoman 792643 792643 Fulford, John, of Sampford Courtenay, yeoman 1
5106115 2388225 2388225 defendant Fulford Robert laborer 792643 792643 Fulford, Robert, of Sampford Courtenay, laborer 2
5106116 2388225 2388225 defendant Westway John husbandman 792643 792643 Westway, John, of Sampford Courtenay, husbandman 3
5113753 2390416 2390416 defendant Horneman William husbandman 792643 792643 Horneman, William, of Sampford Courtenay, husbandman 1
5182669 2410687 2410687 defendant Strepe John, sen husbandman 792643 792643 Strepe, John, sen, of Sampford Courtenay, husbandman 0
5182671 2410687 2410687 defendant Strepe Richard laborer 792643 792643 Strepe, Richard, of Sampford Courtenay, laborer 2
5188478 2412348 2412348 defendant Fouracres John yeoman 792643 792643 Fouracres, John, of Sampford Courtenay, yeoman 2
5203515 2416780 2416780 defendant Strepe John, sen husbandman 792643 792643 Strepe, John, sen, of Sampford Courtenay, husbandman 0
5203519 2416780 2416780 defendant Strepe Richard laborer 792643 792643 Strepe, Richard, of Sampford Courtenay, laborer 4
5269746 2436261 2436261 defendant Strepe Joan widow 792643 792643 Strepe, Joan, of Sampford Courtenay, widow 1
5281097 2439546 2439546 defendant Neucombe John   792643 792643 Neucombe, John, of Sampford Courtenay, mason 6
5304888 2446466 2446466 defendant Cornyssh William   792643 792643 Cornyssh, William, of Sampford Courtenay 0
5321329 2451472 2451472 defendant Skynner Joan widow 792643 792643 Skynner, Joan, of Sampford Courtenay, widow 1
5321334 2451473 2451473 defendant Skynner Joan widow 792643 792643 Skynner, Joan, of Sampford Courtenay, widow 1
5330153 2454095 2454095 defendant Mathy Philip tailor 792643 792643 Mathy, Philip, of Sampford Courtenay, tailor 0
5405715 2476709 2476709 defendant Howechyn Henry yeoman 792643 792643 Howechyn, Henry, of Sampford Courtenay, yeoman 1
5420926 2481188 2481188 defendant Howechyn Henry yeoman 792643 792643 Howechyn, Henry, of Sampford Courtenay, yeoman 1
5440463 2487050 2487050 defendant Herneman John husbandman 792643 792643 Herneman, John, of Sampford Courtenay, husbandman 0
5507433 2507219 2507219 defendant Sloman Henry yeoman 792643 792643 Sloman, Henry, of Sampford Courtenay, yeoman 5
5566943 2524927 2524927 defendant Franke John husbandman 792643 792643 Franke, John, of Sampford Courtenay, husbandman 1

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