names

36 rows where place_id = 606649

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666039 1915315 1915315 defendant Walleker Thomas potter 606649 606649 Walleker, Thomas, of Wethersfeld, potter 1
3678755 1919424 1919424 plaintiff Northey Petronilla (legal representative) 606649 606649 Northey, Petronilla, of Wethersfeld, widow, executor of 0
3682544 1920645 1920645 defendant Smyth Thomas yeoman 606649 606649 Smyth, Thomas, of Wethersfeld, yeoman 0
3682545 1920645 1920645 defendant Wallaker Thomas potter 606649 606649 Wallaker, Thomas, of Wethersfeld, potter 1
3684302 1921225 1921225 defendant Sare John husbandman 606649 606649 Sare, John, of Wethersfeld, husbandman 0
3697655 1925491 1925491 defendant Smyth Thomas yeoman 606649 606649 Smyth, Thomas, of Wethersfeld, yeoman 0
3697656 1925491 1925491 defendant Wallaker Thomas yeoman or potter 606649 606649 Wallaker, Thomas, of Wethersfeld, yeoman or potter 1
3806852 1960050 1960050 plaintiff Wentworth Roger   606649 606649 Wentworth, Roger, of Wethersfeld, knight 0
3806856 1960051 1960051 plaintiff Wentworth Roger   606649 606649 Wentworth, Roger, of Wethersfeld, knight 0
3827899 1966589 1966589 defendant Purcas William husbandman 606649 606649 Purcas, William, of Wethersfeld, husbandman 0
3886131 1985612 1985612 defendant Pett Clement butcher 606649 606649 Pett, Clement, of Wethersfeld, butcher 0
3957994 2009860 2009860 defendant Spryng Robert husbandman 606649 606649 Spryng, Robert, of Wethersfeld, husbandman 0
4122211 2068248 2068248 defendant Walford John husbandman 606649 606649 Walford, John, of Wethersfeld, husbandman 0
4248623 2112526 2112526 defendant Whitbye John yeoman 606649 606649 Whitbye, John, of Wethersfeld, yeoman 1
4248625 2112526 2112526 defendant Glinner alias Wrighte Edmund laborer 606649 606649 Glinner alias Wrighte, Edmund, of Wethersfeld, laborer 3
4275668 2121435 2121435 defendant Walford Thomas yeoman 606649 606649 Walford, Thomas, of Wethersfeld, yeoman 1
4280171 2122973 2122973 defendant Walford Richard gent 606649 606649 Walford, Richard, of Wethersfeld, gent 0
4282923 2123928 2123928 defendant Leaper John yeoman 606649 606649 Leaper, John, of Wethersfeld, yeoman 0
4282980 2123951 2123951 defendant More Henry husbandman 606649 606649 More, Henry, of Wethersfeld, husbandman 0
4293925 2127899 2127899 defendant Walford Thomas yeoman 606649 606649 Walford, Thomas, of Wethersfeld , yeoman 0
4351922 2147911 2147911 defendant Mann William tailor 606649 606649 Mann, William, of Wethersfeld, or of Berdfeld Magna, Essex, tailor 0
4432264 2174872 2174872 defendant Reynold William   606649 606649 Reynold, William, of Wethersfeld 0
4460037 2188197 2188197 plaintiff Seman William   606649 606649 Seman, William, of Wethersfeld, son of William 0
4665237 2250617 2250617 defendant Warde John yeoman 606649 606649 Warde, John, of Wethersfeld, yeoman 0
4674141 2257518 2257518 defendant Joye William yeoman 606649 606649 Joye, William, of Wethersfeld, yeoman 0
4779156 2289455 2289455 defendant Sharp John, junior potter 606649 606649 Sharp, John, junior, of Wethersfeld, potter 1
4779157 2289455 2289455 defendant Boch or Bocher William butcher 606649 606649 Boch or Bocher, William, of Wethersfeld, butcher 2
4954144 2343208 2343208 defendant Grenehill Richard laborer 606649 606649 Grenehill, Richard, of Wethersfeld, laborer 1
5179337 2409695 2409695 defendant Seburgh William laborer 606649 606649 Seburgh, William, of Wethersfeld, laborer 0
5233649 2425429 2425429 defendant Cosyn Robert yeoman 606649 606649 Cosyn, Robert, of Wethersfeld, yeoman 0
5233650 2425429 2425429 defendant Loveland Thomas husbandman 606649 606649 Loveland, Thomas, of Wethersfeld, husbandman 1
5412396 2478653 2478653 defendant Northey John butcher 606649 606649 Northey, John, of Wethersfeld, butcher 0
5544548 2518405 2518405 defendant Stubbyng William husbandman 606649 606649 Stubbyng, William, of Wethersfeld, husbandman 0
5564179 2524135 2524135 defendant Yongman alias Clerk John yeoman 606649 606649 Yongman alias Clerk, John, of Wethersfeld, yeoman 0
5564180 2524135 2524135 defendant Rede William husbandman 606649 606649 Rede, William, of Wethersfeld, husbandman 1
5564181 2524135 2524135 defendant Passhefeld John, senior tanner 606649 606649 Passhefeld, John, senior, of Wethersfeld, tanner 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);