names

37 rows where place_id = 608486

✎ 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
3673884 1917865 1917865 defendant Button Robert chaplain 608486 608486 Button, Robert, of Bodyham, chaplain 0
3780736 1951709 1951709 defendant Rede John tailor 608486 608486 Rede, John, of Bodyham, tailor 2
3826964 1966284 1966284 defendant Sadlyngton Henry merchant 608486 608486 Sadlyngton, Henry, of Bodyham, merchant 0
3827580 1966486 1966486 defendant Standen Simon waterman 608486 608486 Standen, Simon, of Bodyham, waterman 1
3834670 1968778 1968778 defendant Pyper Robert laborer 608486 608486 Pyper, Robert, of Bodyham, laborer 0
3838806 1970064 1970064 defendant Atfeld alias Onsty John husbandman 608486 608486 Atfeld alias Onsty, John, of Bodyham, husbandman 2
3854307 1974984 1974984 defendant Turner William miller 608486 608486 Turner, William, of Bodyham, miller 0
3858183 1976216 1976216 defendant Sharpe Thomas laborer 608486 608486 Sharpe, Thomas, of Bodyham, laborer 0
3865344 1978622 1978622 plaintiff Mores John   608486 608486 Mores, John, of Bodyham 0
3865687 1978743 1978743 defendant Pyper Robert laborer 608486 608486 Pyper, Robert, of Bodyham, laborer 0
3916823 1995991 1995991 defendant Colbroke Thomas fletcher 608486 608486 Colbroke, Thomas, of Bodyham, fletcher 1
3991401 2021678 2021678 defendant Sawyer alias Morris John innholder 608486 608486 Sawyer alias Morris, John, of Bodyham, innholder 0
3991402 2021678 2021678 defendant Martyn Richard husbandman 608486 608486 Martyn, Richard, of Bodyham, husbandman 1
3991403 2021678 2021678 defendant Sevyer Thomas husbandman 608486 608486 Sevyer, Thomas, of Bodyham, husbandman 2
4037745 2038151 2038151 plaintiff Knolles John   608486 608486 Knolles, John, of Bodyham 0
4037747 2038152 2038152 plaintiff Knolles John   608486 608486 Knolles, John, of Bodyham 0
4064053 2047424 2047424 defendant Morris William husbandman 608486 608486 Morris, William, of Bodyham, husbandman 2
4064054 2047424 2047424 defendant Morris John husbandman 608486 608486 Morris, John, of Bodyham, husbandman 3
4077625 2052285 2052285 plaintiff Stertop Nicholas (legal representative) 608486 608486 Stertop, Nicholas, of Bodyham, yeoman, executrix of 0
4077627 2052285 2052285 defendant Gent William clerk 608486 608486 Gent, William, of Bodyham, clerk 0
4104957 2062048 2062048 defendant Symons Robert yeoman 608486 608486 Symons, Robert, of Bodyham, yeoman 2
4104961 2062049 2062049 defendant Symons Robert yeoman 608486 608486 Symons, Robert, of Bodyham, yeoman 2
4121658 2068042 2068042 defendant Symond Robert yeoman 608486 608486 Symond, Robert, of Bodyham, yeoman 0
4129919 2071011 2071011 defendant Weston Gabriel yeoman 608486 608486 Weston, Gabriel, of Bodyham, or of Wylmyngton, yeoman 0
4239913 2109594 2109594 defendant Adarall or Aderfeld Robert husbandman 608486 608486 Adarall or Aderfeld, Robert, of Bodyham, husbandman 0
4289679 2126373 2126373 defendant Cheesman Richard yeoman 608486 608486 Cheesman, Richard, of Bodyham, yeoman 0
4581763 2225738 2225738 defendant Hobelyn John   608486 608486 Hobelyn, John, of Bodyham, park man 0
4581764 2225738 2225738 defendant atte Broke Richard   608486 608486 atte Broke, Richard, of Bodyham 1
4866600 2316513 2316513 defendant Agrove Michael laborer 608486 608486 Agrove, Michael, of Bodyham, laborer 0
4934395 2337149 2337149 defendant Bysshoppysden John wooder 608486 608486 Bysshoppysden, John, of Bodyham, wooder 3
5376396 2468214 2468214 defendant Holman Edward yeoman 608486 608486 Holman, Edward, of Bodyham, yeoman 1
5383647 2470406 2470406 defendant A Grene Robert yeoman 608486 608486 A Grene, Robert, of Bodyham, yeoman 2
5395466 2473779 2473779 defendant a Grove Robert yeoman 608486 608486 a Grove, Robert, of Bodyham, yeoman 2
5404946 2476492 2476492 defendant Holman Edward yeoman 608486 608486 Holman, Edward, of Bodyham, yeoman 0
5408772 2477581 2477581 defendant Brove Robert yeoman 608486 608486 Brove, Robert, of Bodyham, yeoman 2
5418023 2480317 2480317 defendant Holman Edward yeoman 608486 608486 Holman, Edward, of Bodyham, yeoman 0
5422213 2481592 2481592 defendant Curlyng Stephen   608486 608486 Curlyng, Stephen, of Bodyham 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);