names

64 rows where place_id = 596392

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624548 1875215 1875215 defendant Borlace Nicholas gent 596392 596392 Borlace, Nicholas, of St Nyott, gent 0
3670865 1916853 1916853 defendant Berd Walter laborer 596392 596392 Berd, Walter, of St Nyott, laborer 0
3732704 1936460 1936460 defendant Grygge John yeoman 596392 596392 Grygge, John, of St Nyott, yeoman 0
3885466 1985395 1985395 defendant Harry John husbandman 596392 596392 Harry, John, of St Nyott, husbandman 0
3895663 1988753 1988753 defendant Lampen Stephen husbandman 596392 596392 Lampen, Stephen, of St Nyott, husbandman 0
3895664 1988753 1988753 defendant Lampen Vincent laborer 596392 596392 Lampen, Vincent, of St Nyott, laborer 1
3895665 1988753 1988753 defendant Nyell Robert laborer 596392 596392 Nyell, Robert, of St Nyott, laborer 2
3905650 1992162 1992162 defendant Otteram Stephen, senior husbandman 596392 596392 Otteram, Stephen, senior, of St Nyott, husbandman 0
3905651 1992162 1992162 defendant Otteram Stephen, junior   596392 596392 Otteram, Stephen, junior, of St Nyott, husbandman, "Pentea" his wife 1
3907705 1992866 1992866 defendant Bennett Nicholas husbandman 596392 596392 Bennett, Nicholas, of St Nyott, husbandman 0
3907706 1992866 1992866 defendant Woodwall Robert husbandman 596392 596392 Woodwall, Robert, of St Nyott, husbandman 1
3920639 1997251 1997251 defendant Cowlyng William yeoman 596392 596392 Cowlyng, William, of St Nyott, yeoman 1
3928805 1999971 1999971 defendant Mychell Robert husbandman 596392 596392 Mychell, Robert, of St Nyott, husbandman 0
3954202 2008543 2008543 defendant Tubbe George esq 596392 596392 Tubbe, George, of St Nyott, esq 0
4021329 2032351 2032351 defendant Parkyng alias Parkyngson Thomas yeoman 596392 596392 Parkyng alias Parkyngson, Thomas, of St Nyott, yeoman 0
4046977 2041368 2041368 defendant Greston Robert weaver 596392 596392 Greston, Robert, of St Nyott, weaver 7
4055074 2044214 2044214 defendant Taperell Robert husbandman 596392 596392 Taperell, Robert, of St Nyott, husbandman 0
4055075 2044214 2044214 defendant Taperell George laborer 596392 596392 Taperell, George, of St Nyott, laborer 1
4055076 2044214 2044214 defendant Croppe Thomas husbandman 596392 596392 Croppe, Thomas, of St Nyott, husbandman 2
4055077 2044214 2044214 defendant Skynnerd John husbandman 596392 596392 Skynnerd, John, of St Nyott, husbandman 3
4055078 2044214 2044214 defendant Shales William laborer 596392 596392 Shales, William, of St Nyott, laborer 4
4055079 2044214 2044214 defendant Lavers Thomas laborer 596392 596392 Lavers, Thomas, of St Nyott, laborer 5
4055080 2044214 2044214 defendant Skynnard Nicholas laborer 596392 596392 Skynnard, Nicholas, of St Nyott, laborer 6
4055081 2044214 2044214 defendant Swete Stephen, junior laborer 596392 596392 Swete, Stephen, junior, of St Nyott, laborer 7
4067604 2048731 2048731 defendant Lampen Vincent husbandman 596392 596392 Lampen, Vincent, of St Nyott, husbandman 0
4067605 2048731 2048731 defendant Lampen Mark miller 596392 596392 Lampen, Mark, of St Nyott, miller 1
4067606 2048731 2048731 defendant Baylys Thomas husbandman 596392 596392 Baylys, Thomas, of St Nyott, husbandman 2
4067607 2048731 2048731 defendant Mathyck Peter laborer 596392 596392 Mathyck, Peter, of St Nyott, laborer 3
4067608 2048731 2048731 defendant Gyll Robert husbandman 596392 596392 Gyll, Robert, of St Nyott, husbandman 4
4067609 2048731 2048731 defendant Woodwarde Stephen husbandman 596392 596392 Woodwarde, Stephen, of St Nyott, husbandman 5
4067610 2048731 2048731 defendant Robyns alias Lampen John husbandman 596392 596392 Robyns alias Lampen, John, of St Nyott, husbandman 6
4071470 2050093 2050093 defendant Taperell Robert husbandman 596392 596392 Taperell, Robert, of St Nyott, husbandman 0
4071471 2050093 2050093 defendant Taperell George laborer 596392 596392 Taperell, George, of St Nyott, laborer 1
4071472 2050093 2050093 defendant Croppe Thomas husbandman 596392 596392 Croppe, Thomas, of St Nyott, husbandman 2
4071473 2050093 2050093 defendant Skynnerd John husbandman 596392 596392 Skynnerd, John, of St Nyott, husbandman 3
4071474 2050093 2050093 defendant Shales William laborer 596392 596392 Shales, William, of St Nyott, laborer 4
4071475 2050093 2050093 defendant Lavers Thomas laborer 596392 596392 Lavers, Thomas, of St Nyott, laborer 5
4071476 2050093 2050093 defendant Skynnard Nicholas laborer 596392 596392 Skynnard, Nicholas, of St Nyott, laborer 6
4071477 2050093 2050093 defendant Swete Stephen, junior laborer 596392 596392 Swete, Stephen, junior, of St Nyott, laborer 7
4078455 2052593 2052593 defendant Antery Thomas yeoman 596392 596392 Antery, Thomas, of St Nyott, or of Fylly, yeoman 1
4079443 2052948 2052948 defendant Humfery William husbandman 596392 596392 Humfery, William, of St Nyott, husbandman 0
4079444 2052948 2052948 defendant Hatche Edmund husbandman 596392 596392 Hatche, Edmund, of St Nyott, husbandman 1
4079455 2052953 2052953 defendant Taperell Robert husbandman 596392 596392 Taperell, Robert, of St Nyott, husbandman 0
4079456 2052953 2052953 defendant Taperell George laborer 596392 596392 Taperell, George, of St Nyott, laborer 1
4079457 2052953 2052953 defendant Croppe Thomas laborer 596392 596392 Croppe, Thomas, of St Nyott, laborer 2
4079458 2052953 2052953 defendant Skynnerd John husbandman 596392 596392 Skynnerd, John, of St Nyott, husbandman 3
4079459 2052953 2052953 defendant Shales William laborer 596392 596392 Shales, William, of St Nyott, laborer 4
4079460 2052953 2052953 defendant Lavers Thomas laborer 596392 596392 Lavers, Thomas, of St Nyott, laborer 5
4079461 2052953 2052953 defendant Skynnard Nicholas laborer 596392 596392 Skynnard, Nicholas, of St Nyott, laborer 6
4079462 2052953 2052953 defendant Swete Stephen, junior laborer 596392 596392 Swete, Stephen, junior, of St Nyott, laborer 7
4182793 2089460 2089460 defendant Phillipp John husbandman 596392 596392 Phillipp, John, of St Nyott, husbandman 0
4182794 2089460 2089460 defendant Bunt John husbandman 596392 596392 Bunt, John, of St Nyott, husbandman 1
4182795 2089460 2089460 defendant Taprell Peter husbandman 596392 596392 Taprell, Peter, of St Nyott, husbandman 2
4222627 2103406 2103406 defendant Michell John yeoman 596392 596392 Michell, John, of St Nyott, yeoman 0
4226696 2104809 2104809 defendant Blusshe John husbandman 596392 596392 Blusshe, John, of St Nyott, husbandman 2
4245746 2111554 2111554 defendant Crappe Vincent husbandman 596392 596392 Crappe, Vincent, of St Nyott, husbandman 0
4245747 2111554 2111554 defendant Martyn Roger husbandman 596392 596392 Martyn, Roger, of St Nyott, husbandman 1
4251698 2113556 2113556 defendant Michell John yeoman 596392 596392 Michell, John, of St Nyott, yeoman 0
4262100 2116998 2116998 defendant Michell John yeoman 596392 596392 Michell, John, of St Nyott, yeoman 0
4310752 2133904 2133904 defendant Taprell George husbandman 596392 596392 Taprell, George, of St Nyott, husbandman 1
4371015 2154690 2154690 defendant Humfrye George husbandman 596392 596392 Humfrye, George, of St Nyott, husbandman 0
4393155 2162317 2162317 defendant Skynnard John husbandman 596392 596392 Skynnard, John, of St Nyott, husbandman 0
4393156 2162317 2162317 defendant Skynnard Michael husbandman 596392 596392 Skynnard, Michael, of St Nyott, husbandman 1
4397120 2163606 2163606 defendant Tappell or Taprell George yeoman 596392 596392 Tappell or Taprell, George, of St Nyott, yeoman 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);