names

28 rows where place_id = 605782

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662841 1914293 1914293 defendant Carter John butcher 605782 605782 Carter, John, of Methwold, butcher 0
3684564 1921305 1921305 defendant Yong Agnes widow 605782 605782 Yong, Agnes, of Methwold, widow 1
3688486 1922554 1922554 defendant Baker William husbandman 605782 605782 Baker, William, of Methwold, husbandman 0
3688488 1922555 1922555 defendant Yong John, senior husbandman 605782 605782 Yong, John, senior, of Methwold, husbandman 0
3688490 1922556 1922556 defendant Yonge george, senior husbandman 605782 605782 Yonge, george, senior, of Methwold, husbandman 0
3702982 1927206 1927206 defendant Dyx Alan butcher 605782 605782 Dyx, Alan, of Methwold, butcher 0
3744268 1940104 1940104 defendant Nele John laborer 605782 605782 Nele, John, of Methwold, laborer 2
3761489 1945604 1945604 defendant Ketryngham John husbandman 605782 605782 Ketryngham, John, of Methwold, husbandman 2
3883251 1984662 1984662 defendant Fuller Ralph husbandman 605782 605782 Fuller, Ralph, of Methwold, husbandman 0
3951261 2007508 2007508 plaintiff Grey John (legal representative) 605782 605782 Grey, John, of Methwold, esq, executrix of 0
3957982 2009855 2009855 defendant Rose John yeoman 605782 605782 Rose, John, of Methwold, yeoman 1
3961746 2011208 2011208 defendant Fuller Robert husbandman 605782 605782 Fuller, Robert, of Methwold, husbandman 0
3962485 2011472 2011472 defendant Rose John yeoman 605782 605782 Rose, John, of Methwold, yeoman 0
3981626 2018187 2018187 plaintiff Remane Robert yeoman 605782 605782 Remane, Robert, of Methwold, yeoman 0
4029140 2035064 2035064 defendant Fuller Osbert husbandman 605782 605782 Fuller, Osbert, of Methwold, husbandman 0
4045004 2040668 2040668 defendant Baker Thomas, junior husbandman 605782 605782 Baker, Thomas, junior, of Methwold, husbandman 0
4220715 2102745 2102745 defendant Rumbold Richard husbandman 605782 605782 Rumbold, Richard, of Methwold, husbandman 0
4401294 2165029 2165029 defendant Roumbold John husbandman 605782 605782 Roumbold, John, of Methwold, husbandman 0
4401295 2165029 2165029 defendant Starlyng Robert husbandman 605782 605782 Starlyng, Robert, of Methwold, husbandman 1
4401296 2165029 2165029 defendant Baker Thomas husbandman 605782 605782 Baker, Thomas, of Methwold, husbandman 2
4401297 2165029 2165029 defendant Russell George husbandman 605782 605782 Russell, George, of Methwold, husbandman 3
4409048 2167631 2167631 defendant Bull Osborn husbandman 605782 605782 Bull, Osborn, of Methwold, husbandman 0
4842633 2309232 2309232 defendant Warde Andrew husbandman 605782 605782 Warde, Andrew, of Methwold, husbandman 0
5351105 2460452 2460452 defendant Baker Thomas husbandman 605782 605782 Baker, Thomas, of Methwold, husbandman 0
5438875 2486549 2486549 defendant Ditton Joan widow 605782 605782 Ditton, Joan, of Methwold, widow 0
5438878 2486550 2486550 defendant Ditton Joan widow 605782 605782 Ditton, Joan, of Methwold, widow 0
5487865 2501258 2501258 defendant Flegge Thomas yeoman 605782 605782 Flegge, Thomas, of Methwold, yeoman 2
5518221 2510526 2510526 plaintiff Wryght John   605782 605782 Wryght, John, of Methwold 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);