names

46 rows where place_id = 589410

✎ 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
3597572 1866865 1866865 defendant Dydelysfold George yeoman 589410 589410 Dydelysfold, George, of Ewherst, yeoman 0
3715450 1931119 1931119 defendant Hole Richard yeoman 589410 589410 Hole, Richard, of Ewherst, yeoman 3
3769340 1948068 1948068 defendant Sawyer Thomas husdbandman 589410 589410 Sawyer, Thomas, of Ewherst, husdbandman 0
3769344 1948068 1948068 defendant Butler Walter laborer 589410 589410 Butler, Walter, of Ewherst, laborer 4
3787185 1953783 1953783 defendant Sawyer Thomas husbandman 589410 589410 Sawyer, Thomas, of Ewherst, husbandman 0
3787189 1953783 1953783 defendant Butler Walter laborer 589410 589410 Butler, Walter, of Ewherst, laborer 4
3796392 1956738 1956738 defendant Edsawe Robert husbandman 589410 589410 Edsawe, Robert, of Ewherst, husbandman 0
3827579 1966486 1966486 defendant Patenden William waterman 589410 589410 Patenden, William, of Ewherst, waterman 0
3851147 1973949 1973949 defendant Edsawe Richard laborer 589410 589410 Edsawe, Richard, of Ewherst, laborer 0
3854713 1975121 1975121 defendant Patynden William laborer 589410 589410 Patynden, William, of Ewherst, laborer 0
3865830 1978801 1978801 defendant Baron John husbandman 589410 589410 Baron, John, of Ewherst, husbandman 0
3877740 1982795 1982795 defendant Overyngton Robert husbandman 589410 589410 Overyngton, Robert, of Ewherst, husbandman 1
3879150 1983280 1983280 defendant Raynold John tailor 589410 589410 Raynold, John, of Ewherst, tailor 0
3894795 1988465 1988465 plaintiff Sayer William (legal representative) 589410 589410 Sayer, William, of Ewherst, executors of 0
3894797 1988465 1988465 defendant Ewyn Richard butcher 589410 589410 Ewyn, Richard, of Ewherst, butcher 0
4037760 2038157 2038157 defendant Patenden Thomas yeoman 589410 589410 Patenden, Thomas, of Ewherst, yeoman 0
4037762 2038158 2038158 defendant Patenden Thomas yeoman 589410 589410 Patenden, Thomas, of Ewherst, yeoman 0
4066462 2048298 2048298 defendant Owen Thomas gent 589410 589410 Owen, Thomas, of Ewherst, gent 4
4171573 2085524 2085524 defendant Clarke Thomas yeoman 589410 589410 Clarke, Thomas, of Ewherst, yeoman 0
4177949 2087761 2087761 defendant Tuttye Robert butcher 589410 589410 Tuttye, Robert, of Ewherst, butcher 0
4194729 2093714 2093714 defendant Clarke Thomas yeoman 589410 589410 Clarke, Thomas, of Ewherst, yeoman 0
4201225 2095982 2095982 defendant Tyttye Robert butcher 589410 589410 Tyttye, Robert, of Ewherst, butcher 0
4213566 2100263 2100263 defendant Austen Henry (legal representative) 589410 589410 Austen, Henry, of Ewherst, yeoman, executrix of 0
4282208 2123677 2123677 defendant Cowycke Henry husbandman 589410 589410 Cowycke, Henry, of Ewherst, husbandman 0
4282209 2123677 2123677 defendant Wryghte William husbandman 589410 589410 Wryghte, William, of Ewherst, husbandman 1
4309858 2133604 2133604 defendant Sitterne Henry clerk 589410 589410 Sitterne, Henry, of Ewherst, clerk 0
4309859 2133604 2133604 defendant Nye Thomas husbandman 589410 589410 Nye, Thomas, of Ewherst, husbandman 1
4311105 2134033 2134033 defendant Stokes Richard butcher 589410 589410 Stokes, Richard, of Ewherst, butcher 1
4318095 2136438 2136438 defendant Pont Thomas yeoman 589410 589410 Pont, Thomas, of Ewherst, yeoman 0
4318176 2136465 2136465 defendant Tydye Edmund husbandman 589410 589410 Tydye, Edmund, of Ewherst, husbandman 0
4379142 2157622 2157622 defendant Iden John yeoman 589410 589410 Iden, John, of Ewherst, yeoman 0
4379144 2157623 2157623 defendant Iden John yeoman 589410 589410 Iden, John, of Ewherst, yeoman 0
4469174 2191026 2191026 plaintiff Blak Ralph (legal representative) 589410 589410 Blak, Ralph, of Ewherst, parson, executor of 0
4731243 2274972 2274972 plaintiff Moorfoot Alan draper 589410 589410 Moorfoot, Alan, of Ewherst, draper 0
5016784 2361802 2361802 defendant atte Wode John husbandman 589410 589410 atte Wode, John, of Ewherst, husbandman 0
5081640 2381016 2381016 defendant Prall Robert husbandman 589410 589410 Prall, Robert, of Ewherst, husbandman 0
5081642 2381017 2381017 defendant Prall Robert husbandman 589410 589410 Prall, Robert, of Ewherst, husbandman 0
5137635 2397521 2397521 defendant Burgoyn Thomas gent 589410 589410 Burgoyn, Thomas, of Ewherst, gent 2
5137636 2397521 2397521 defendant (illegible) Thomas yeoman 589410 589410 --, Thomas, of Ewherst, yeoman 3
5137637 2397521 2397521 defendant Crafford Alan husbandman 589410 589410 Crafford, Alan, of Ewherst, husbandman 4
5224337 2422793 2422793 defendant Burgoyn Thomas gent 589410 589410 Burgoyn, Thomas, of Ewherst, gent 2
5224338 2422793 2422793 defendant Brace Thomas yeoman 589410 589410 Brace, Thomas, of Ewherst, yeoman 3
5224339 2422793 2422793 defendant Crafford Alan husbandman 589410 589410 Crafford, Alan, of Ewherst, husbandman 4
5384178 2470563 2470563 defendant Parrok Richard husbandman 589410 589410 Parrok, Richard, of Ewherst, husbandman 1
5384179 2470563 2470563 defendant Hebbynge Robert carpenter 589410 589410 Hebbynge, Robert, of Ewherst, carpenter 2
5573733 2526883 2526883 defendant Consedewe John chapman 589410 589410 Consedewe, John, of Ewherst, chapman 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);