names

59 rows where place_id = 591091

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603310 1868708 1868708 defendant Martyn Robert husbandman 591091 591091 Martyn, Robert, of Leuesham, husbandman 1
4542630 2213580 2213580 plaintiff Absolon Agnes   591091 591091 Absolon, Agnes, of Leuesham 0
4629320 2240103 2240103 defendant Willes Peter   591091 591091 Willes, Peter, of Leuesham 3
4630317 2240393 2240393 plaintiff Steward Julia   591091 591091 Steward, Julia, of Leuesham 0
4776409 2288616 2288616 plaintiff Albon John   591091 591091 Albon, John, of Leuesham 0
4889496 2323511 2323511 defendant Sanguynell Philip husbandman 591091 591091 Sanguynell, Philip, of Leuesham, husbandman 0
4889497 2323511 2323511 defendant Mason Nicholas husbandman 591091 591091 Mason, Nicholas, of Leuesham, husbandman 1
4889498 2323511 2323511 defendant Gilberd John husbandman 591091 591091 Gilberd, John, of Leuesham, husbandman 2
4942706 2339690 2339690 defendant Godysway John husbandman 591091 591091 Godysway, John, of Leuesham, husbandman 2
4942707 2339690 2339690 defendant Toly John husbandman 591091 591091 Toly, John, of Leuesham, husbandman 3
4942708 2339690 2339690 defendant Person Nicholas husbandman 591091 591091 Person, Nicholas, of Leuesham, husbandman 4
4942709 2339690 2339690 defendant Trotte William husbandman 591091 591091 Trotte, William, of Leuesham, husbandman 5
5015019 2361274 2361274 defendant Sangnell Philip husbandman 591091 591091 Sangnell, Philip, of Leuesham Lemman, husbandman 0
5053222 2372565 2372565 defendant Tanner Robert husbandman 591091 591091 Tanner, Robert, of Leuesham, husbandman 1
5110363 2389434 2389434 defendant Furneys Walter husbandman 591091 591091 Furneys, Walter, of Leuesham, husbandman 4
5110368 2389435 2389435 defendant Gossip John smith 591091 591091 Gossip, John, of Leuesham, smith 3
5159789 2403966 2403966 defendant Segard John laborer 591091 591091 Segard, John, of Leuesham, laborer 0
5182155 2410534 2410534 defendant Assheley William husbandman 591091 591091 Assheley, William, of Leuesham, husbandman 1
5182156 2410534 2410534 defendant Sprigge William husbandman 591091 591091 Sprigge, William, of Leuesham, husbandman 2
5182157 2410534 2410534 defendant Stotte William husbandman 591091 591091 Stotte, William, of Leuesham, husbandman 3
5182158 2410534 2410534 defendant Combe Richard husbandman 591091 591091 Combe, Richard, of Leuesham, husbandman 4
5186177 2411708 2411708 defendant Purser John tailor 591091 591091 Purser, John, of Leuesham, tailor 1
5197176 2414912 2414912 defendant Segarde Nicholas yeoman 591091 591091 Segarde, Nicholas, of Leuesham, yeoman 4
5267896 2435723 2435723 defendant Levyndale John husbandman 591091 591091 Levyndale, John, of Leuesham, husbandman 0
5277246 2438423 2438423 defendant Short John yeoman 591091 591091 Short, John, of Leuesham, yeoman 0
5298974 2444681 2444681 defendant Gossyp John smith 591091 591091 Gossyp, John, of Leuesham, smith 0
5311740 2448533 2448533 defendant Stotte or Scotte Walter husbandman 591091 591091 Stotte or Scotte, Walter, of Leuesham, husbandman 0
5314117 2449238 2449238 defendant Scotte Walter husbandman 591091 591091 Scotte, Walter, of Leuesham, husbandman 0
5332329 2454735 2454735 defendant Huchynson Richard brewer 591091 591091 Huchynson, Richard, of Leuesham, brewer 0
5346023 2458892 2458892 defendant Shepard John husbandman 591091 591091 Shepard, John, of Leuesham, husbandman 1
5389239 2471967 2471967 defendant Toller John laborer 591091 591091 Toller, John, of Leuesham, laborer 3
5390519 2472350 2472350 defendant Combe Elizabeth widow 591091 591091 Combe, Elizabeth, of Leuesham, widow 5
5410303 2478033 2478033 defendant Combe Richard (legal representative) 591091 591091 Combe, Richard, of Leuesham, executors of 4
5416535 2479862 2479862 defendant Combe Elizabeth widow 591091 591091 Combe, Elizabeth, of Leuesham, widow 5
5418718 2480522 2480522 defendant Canell Bernard laborer 591091 591091 Canell, Bernard, of Leuesham, laborer 1
5424136 2482180 2482180 defendant Combe Richard (legal representative) 591091 591091 Combe, Richard, of Leuesham, executors of 4
5424138 2482180 2482180 defendant Combe Isabel   591091 591091 Combe, Isabel, of Leuesham, widow, formerly wife of Richard 6
5435195 2485454 2485454 defendant Boys John laborer 591091 591091 Boys, John, of Leuesham, laborer 1
5440488 2487057 2487057 defendant Cornyssh John brewer 591091 591091 Cornyssh, John, of Leuesham, brewer 0
5450280 2489966 2489966 defendant Boys John laborer 591091 591091 Boys, John, of Leuesham, laborer 1
5472103 2496618 2496618 defendant Combe Robert husbandman 591091 591091 Combe, Robert, of Leuesham, husbandman 1
5476808 2498066 2498066 defendant Cornyssh John brewer 591091 591091 Cornyssh, John, of Leuesham, brewer 0
5478877 2498701 2498701 defendant Crokker John husbandman 591091 591091 Crokker, John, of Leuesham, husbandman 0
5492729 2502742 2502742 defendant Mill Edward gent 591091 591091 Mill, Edward, of Leuesham, gent 0
5492730 2502742 2502742 defendant Broke Edward yeoman 591091 591091 Broke, Edward, of Leuesham, yeoman 1
5492732 2502742 2502742 defendant Mill Edmund gent 591091 591091 Mill, Edmund, of Leuesham, gent 3
5493942 2503094 2503094 defendant Heland Robert yeoman 591091 591091 Heland, Robert, of Leuesham, yeoman 0
5493943 2503094 2503094 defendant Shepherd John husbandman 591091 591091 Shepherd, John, of Leuesham, husbandman 1
5499661 2504841 2504841 defendant Holand Robert yeoman 591091 591091 Holand, Robert, of Leuesham, yeoman 0
5536643 2515944 2515944 defendant Wheteley William tanner 591091 591091 Wheteley, William, of Leuesham, tanner 1
5536644 2515944 2515944 defendant Crofte Martin butcher 591091 591091 Crofte, Martin, of Leuesham, butcher 2
5536645 2515944 2515944 defendant Thomson William butcher 591091 591091 Thomson, William, of Leuesham, butcher 3
5633510 2554475 2554475 defendant Aspelyn Simon miller 591091 591091 Aspelyn, Simon, of Leuesham, miller 3
5633511 2554475 2554475 defendant Alfryth Robert   591091 591091 Alfryth, Robert, of Leuesham, millwright 4
5633512 2554475 2554475 defendant Daly John dyer 591091 591091 Daly, John, of Leuesham, dyer 5
5633517 2554477 2554477 defendant Samford Joan widow of Thomas Samford 591091 591091 Samford, Joan, of Leuesham, widow of Thomas Samford 2
5633519 2554477 2554477 defendant Aspelyn Simon miller 591091 591091 Aspelyn, Simon, of Leuesham, miller 4
5633520 2554477 2554477 defendant Alfryth Robert   591091 591091 Alfryth, Robert, of Leuesham, millwright 5
5633521 2554477 2554477 defendant Davy John dyer 591091 591091 Davy, John, of Leuesham, dyer 6

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