names

43 rows where place_id = 589979

✎ 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
3599455 1867468 1867468 defendant Toty Lawrence laborer 589979 589979 Toty, Lawrence, of Eweherst, laborer 2
3606622 1869744 1869744 defendant Oxenbregge Thomas gent 589979 589979 Oxenbregge, Thomas, of Eweherst, gent 0
3611959 1871401 1871401 defendant More Richard   589979 589979 More, Richard, of Eweherst, parish clerk 0
3686760 1922012 1922012 defendant Bourer John   589979 589979 Bourer, John, of Eweherst, wheelwright 4
3701828 1926822 1926822 defendant Bourer John   589979 589979 Bourer, John, of Eweherst, wheelwright 4
3701834 1926823 1926823 defendant Bourer John   589979 589979 Bourer, John, of Eweherst, wheelwright 4
4311102 2134032 2134032 defendant Stokes Richard butcher 589979 589979 Stokes, Richard, of Eweherst, butcher 0
4738403 2277106 2277106 defendant Tayllour William   589979 589979 Tayllour, William, of Eweherst, bailiff 1
4909035 2329367 2329367 defendant Long John collier 589979 589979 Long, John, of Eweherst, collier 2
4947534 2341223 2341223 defendant atte Rude John husbandman 589979 589979 atte Rude, John, of Eweherst, husbandman 0
4947535 2341223 2341223 defendant atte Rude Henry laborer 589979 589979 atte Rude, Henry, of Eweherst, laborer 1
5058360 2374046 2374046 defendant Drynker John carpenter 589979 589979 Drynker, John, of Eweherst, carpenter 0
5088243 2382935 2382935 defendant Snokeshill Henry gent 589979 589979 Snokeshill, Henry, of Eweherst, gent 0
5088244 2382935 2382935 defendant Gunter Giles gent 589979 589979 Gunter, Giles, of Eweherst, gent 1
5111467 2389748 2389748 defendant Gerveys John husbandman 589979 589979 Gerveys, John, of Eweherst, husbandman 0
5151394 2401557 2401557 defendant Bras Thomas yeoman 589979 589979 Bras, Thomas, of Eweherst, yeoman 0
5237681 2426604 2426604 plaintiff Gervays John   589979 589979 Gervays, John, of Eweherst 0
5237684 2426605 2426605 defendant Ladde Peter laborer 589979 589979 Ladde, Peter, of Eweherst, laborer 0
5265813 2435060 2435060 defendant Birle Henry gent 589979 589979 Birle, Henry, of Eweherst, gent 0
5277274 2438434 2438434 defendant Tanner Thomas carpenter 589979 589979 Tanner, Thomas, of Eweherst, carpenter 0
5277276 2438435 2438435 defendant Sponer Robert husbandman 589979 589979 Sponer, Robert, of Eweherst, husbandman 0
5340174 2457134 2457134 defendant Toty Lawrence laborer 589979 589979 Toty, Lawrence, of Eweherst, laborer 0
5340541 2457239 2457239 defendant Morfote John husbandman 589979 589979 Morfote, John, of Eweherst, husbandman 0
5362556 2463936 2463936 defendant Fysshe John husbandman 589979 589979 Fysshe, John, of Eweherst, husbandman 1
5376397 2468214 2468214 defendant Stace William coteller 589979 589979 Stace, William, of Eweherst, coteller 2
5383645 2470406 2470406 defendant Beket William cooper 589979 589979 Beket, William, of Eweherst, cooper 0
5383648 2470406 2470406 defendant Morfott John, senior husbandman 589979 589979 Morfott, John, senior, of Eweherst, husbandman 3
5384177 2470563 2470563 defendant Barnet Simon husbandman 589979 589979 Barnet, Simon, of Eweherst, husbandman 0
5384180 2470563 2470563 defendant Hebbynge Robert, junior carpenter 589979 589979 Hebbynge, Robert, junior, of Eweherst, carpenter 3
5391886 2472756 2472756 defendant Baron Robert husbandman 589979 589979 Baron, Robert, of Eweherst, husbandman 2
5395464 2473779 2473779 defendant Boket alias att Wode William cooper 589979 589979 Boket alias att Wode, William, of Eweherst, cooper 0
5395467 2473779 2473779 defendant Morfott John, senior husbandman 589979 589979 Morfott, John, senior, of Eweherst, husbandman 3
5396164 2473990 2473990 defendant Barnet Simon, senior husbandman 589979 589979 Barnet, Simon, senior, of Eweherst, husbandman 0
5396165 2473990 2473990 defendant Hebbynge Robert, senior carpenter 589979 589979 Hebbynge, Robert, senior, of Eweherst, carpenter 1
5396166 2473990 2473990 defendant Hebbynge Robert, junior carpenter 589979 589979 Hebbynge, Robert, junior, of Eweherst, carpenter 2
5408773 2477581 2477581 defendant Morfort John, sen husbandman 589979 589979 Morfort, John, sen, of Eweherst, husbandman 3
5409524 2477813 2477813 defendant Barnet Simon husbandman 589979 589979 Barnet, Simon, of Eweherst, husbandman 0
5454563 2491279 2491279 defendant Doket William cooper 589979 589979 Doket, William, of Eweherst, cooper 0
5454565 2491279 2491279 defendant Morsett John, sen husbandman 589979 589979 Morsett, John, sen, of Eweherst, husbandman 2
5526964 2513002 2513002 defendant Willyams John yeoman 589979 589979 Willyams, John, of Eweherst, yeoman 0
5526965 2513002 2513002 defendant Walshe Thomas yeoman 589979 589979 Walshe, Thomas, of Eweherst, yeoman 1
5529720 2513802 2513802 defendant Walsshe Thomas yeoman 589979 589979 Walsshe, Thomas, of Eweherst, yeoman 1
5530055 2513909 2513909 defendant Dedillysfeld George yeoman 589979 589979 Dedillysfeld, George, of Eweherst, yeoman 2

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