names

33 rows where place_id = 636546

✎ 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
3653862 1911472 1911472 plaintiff (not given) Augustus prior of -- 636546 636546 --, Augustus, of Butley, prior of the monastery of St Mary 0
3831383 1967705 1967705 defendant Pyper John husbandman 636546 636546 Pyper, John, of Butley, husbandman 0
3860527 1977014 1977014 plaintiff Dawson Alexander   636546 636546 Dawson, Alexander, of Butley, cook 0
3888912 1986536 1986536 defendant Manse Robert husbandman 636546 636546 Manse, Robert, of Butley, husbandman 2
3907800 1992895 1992895 defendant Pope alias Trenchard Philip husbandman 636546 636546 Pope alias Trenchard, Philip, of Butley, husbandman 0
3933553 2001509 2001509 defendant Burnard John husbandman 636546 636546 Burnard, John, of Butley, husbandman 0
4061815 2046622 2046622 defendant Pymlotte Henry husbandman 636546 636546 Pymlotte, Henry, of Butley, husbandman 1
4061816 2046622 2046622 defendant Mottershedde Reginald husbandman 636546 636546 Mottershedde, Reginald, of Butley, husbandman 2
4179405 2088272 2088272 defendant Guppie William yeoman 636546 636546 Guppie, William, of Butley, yeoman 0
4198088 2094878 2094878 defendant Smyth Roger mariner 636546 636546 Smyth, Roger, of Butley, mariner 1
4274827 2121142 2121142 defendant Cobham Elizabeth widow 636546 636546 Cobham, Elizabeth, of Butley, widow 0
4285890 2125005 2125005 defendant Coward William yeoman 636546 636546 Coward, William, of Butley, yeoman 0
4290272 2126571 2126571 defendant Atwell alias Woole William tanner 636546 636546 Atwell alias Woole, William, of Butley, tanner 3
4290936 2126819 2126819 defendant Colmer William, junior gent 636546 636546 Colmer, William, junior, of Butley, gent 0
4290938 2126820 2126820 defendant Guppy John yeoman 636546 636546 Guppy, John, of Butley, yeoman 0
4290944 2126823 2126823 defendant Simcoxe Alexander gent 636546 636546 Simcoxe, Alexander, of Butley, gent 0
4305184 2131951 2131951 defendant Peryam John yeoman 636546 636546 Peryam, John, of Butley, yeoman 0
4305851 2132184 2132184 defendant Pytman Richard husbandman 636546 636546 Pytman, Richard, of Butley, husbandman 1
4306727 2132491 2132491 defendant Symcocke Alexander gent 636546 636546 Symcocke, Alexander, of Butley, gent 2
4306728 2132491 2132491 defendant Guppye John husbandman 636546 636546 Guppye, John, of Butley, husbandman 3
4317568 2136259 2136259 defendant Guppie William yeoman 636546 636546 Guppie, William, of Butley, yeoman 1
4331860 2140948 2140948 defendant Norman Cornelius husbandman 636546 636546 Norman, Cornelius, of Butley, husbandman 3
4373503 2155591 2155591 defendant Guppy William yeoman 636546 636546 Guppy, William, of Butley, yeoman 2
4382166 2158730 2158730 defendant Guppy William yeoman 636546 636546 Guppy, William, of Butley, yeoman 0
5259514 2433097 2433097 defendant Talbot John yeoman 636546 636546 (Talbot, John, of Butley, yeoman 1
5263037 2434182 2434182 defendant Brydon Richard tailor 636546 636546 Brydon, Richard, of Butley, tailor 0
5283328 2440182 2440182 plaintiff Elys Richard mariner 636546 636546 Elys, Richard, of Butley, mariner 0
5283331 2440183 2440183 plaintiff Elys Richard mariner 636546 636546 Elys, Richard, of Butley, mariner 0
5375132 2467808 2467808 plaintiff Poley William   636546 636546 Poley, William, of Butley, prior 0
5379654 2469221 2469221 defendant (not given) William prior of Poley 636546 636546 Poley, William, of Butley, prior of the Monastery of the Blessed Mary 0
5467057 2495095 2495095 plaintiff (not given) Thomas prior of Bettys 636546 636546 Bettys, Thomas, of Butley, prior of the church of the BM, & successor to William 0
5509297 2507760 2507760 defendant Langley William husbandman 636546 636546 Langley, William, of Butley, husbandman 1
5520266 2511157 2511157 plaintiff Brokeys John gent 636546 636546 Brokeys, John, of Butley, gent 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);