names

26 rows where place_id = 597779

✎ 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
3590222 1864583 1864583 defendant Wagge Nicholas   597779 597779 Wagge, Nicholas, of Henley, Oxon, wool buyer 0
3629820 1904179 1904179 defendant Weldon Simon clerk 597779 597779 Weldon, Simon, of Henley, Oxon, clerk 0
3661775 1913963 1913963 defendant Smyth Thomas smith 597779 597779 Smyth, Thomas, of Henley, Oxon, smith 9
3680750 1920060 1920060 defendant Stokley Nicholas yeoman 597779 597779 Stokley, Nicholas, of Henley, Oxon, yeoman 0
3801618 1958405 1958405 defendant Benyng Ambrose bargeman 597779 597779 Benyng, Ambrose, of Henley, Oxon, bargeman 0
3902295 1991001 1991001 defendant Smyth Richard bargeman 597779 597779 Smyth, Richard, of Henley, Oxon, bargeman 2
3998574 2024228 2024228 defendant Stone Reginald chapman 597779 597779 Stone, Reginald, of Henley, Oxon, chapman 0
4001849 2025434 2025434 defendant Carter John bargeman 597779 597779 Carter, John, of Henley, Oxon, yeoman, bargeman 1
4016004 2030418 2030418 plaintiff Stafferton Thomas gent 597779 597779 Stafferton, Thomas, of Henley, Oxon, gent 0
4046639 2041250 2041250 defendant Spensley Robert mercer 597779 597779 Spensley, Robert, of Henley, Oxon, mercer 2
4046780 2041303 2041303 defendant Spensley Robert mercer 597779 597779 Spensley, Robert, of Henley, Oxon, mercer 2
4119943 2067421 2067421 defendant Stockwey William chapman 597779 597779 Stockwey, William, of Henley, Oxon, chapman 2
4145255 2076499 2076499 defendant Pearman Thomas husbandman 597779 597779 Pearman, Thomas, of Henley, Oxon, husbandman 3
4460486 2188342 2188342 defendant Rat Richard   597779 597779 Rat, Richard, of Henley, Oxon 1
4839520 2308285 2308285 defendant Man Thomas carpenter 597779 597779 Man, Thomas, of Henley, Oxon, carpenter 0
4866877 2316603 2316603 defendant Tanner Edmund husbandman 597779 597779 Tanner, Edmund, of Henley, Oxon, husbandman 0
4980966 2351241 2351241 defendant Porter William husbandman 597779 597779 Porter, William, of Henley, Oxon, husbandman 1
5013720 2360856 2360856 defendant Taillour David draper 597779 597779 Taillour, David, of Henley, Oxon, draper 0
5030834 2365888 2365888 defendant Prat John, senior ostler 597779 597779 Prat, John, senior, of Henley, Oxon, ostler 0
5310989 2448324 2448324 defendant Davy John husbandman 597779 597779 Davy, John, of Henley, Oxon, husbandman 0
5364748 2464637 2464637 defendant Foster Richard chapman 597779 597779 Foster, Richard, of Henley, Oxon, chapman 0
5429827 2483863 2483863 defendant Braye Robert yeoman 597779 597779 Braye, Robert, of Henley, Oxon, yeoman 0
5446752 2488925 2488925 defendant Bray Robert yeoman 597779 597779 Bray, Robert, of Henley, Oxon, yeoman 0
5446755 2488926 2488926 defendant Braye Robert yeoman 597779 597779 Braye, Robert, of Henley, Oxon, yeoman 0
5552052 2520641 2520641 defendant Weldon Simon clerk 597779 597779 Weldon, Simon, of Henley, Oxon, clerk 0
5552056 2520642 2520642 defendant Welden Simon clerk 597779 597779 Welden, Simon, of Henley, Oxon, clerk 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);