names

49 rows where place_id = 593914

✎ 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
3613827 1871980 1871980 defendant Long Robert husbandman 593914 593914 Long, Robert, of Hygham, husbandman 3
3670963 1916889 1916889 defendant Page William tiler 593914 593914 Page, William, of Hygham, tiler 0
3672174 1917295 1917295 defendant Nycoll Thomas husbandman 593914 593914 Nycoll, Thomas, of Hygham, husbandman 4
3730507 1935775 1935775 defendant Gase Thomas husbandman 593914 593914 Gase, Thomas, of Hygham, husbandman 2
3731522 1936088 1936088 defendant Engeley Thomas husbandman 593914 593914 Engeley, Thomas, of Hygham, husbandman 0
3796514 1956783 1956783 defendant Yong Stephen husbandman 593914 593914 Yong, Stephen, of Hygham, husbandman 0
3828813 1966889 1966889 defendant Bennett John husbandman 593914 593914 Bennett, John, of Hygham, husbandman 2
3829667 1967170 1967170 defendant Strachy Edward mercer 593914 593914 Strachy, Edward, of Hygham, mercer 0
3860651 1977055 1977055 defendant Bennet Thomas, senior yeoman 593914 593914 Bennet, Thomas, senior, of Hygham, yeoman 0
3896448 1989017 1989017 defendant Barbour William husbandman 593914 593914 Barbour, William, of Hygham, husbandman 2
3904714 1991834 1991834 defendant Palmer John butcher 593914 593914 Palmer, John, of Hygham, butcher 0
3915313 1995488 1995488 defendant Potter Roger husbandman 593914 593914 Potter, Roger, of Hygham, husbandman 1
3973420 2015275 2015275 defendant Popell William husbandman 593914 593914 Popell, William, of Hygham, husbandman 0
4094626 2058416 2058416 defendant Welbecke William gent 593914 593914 Welbecke, William, of Hygham, gent 0
4312028 2134344 2134344 defendant Botham William yeoman 593914 593914 Botham, William, of Hygham, yeoman 1
4503622 2201709 2201709 defendant Douson John   593914 593914 Douson, John, of Hygham 1
4532001 2210273 2210273 defendant Fox John   593914 593914 Fox, John, of Hygham 2
4899795 2326574 2326574 defendant Faukener Mathew husbandman 593914 593914 Faukener, Mathew, of Hygham, husbandman 0
4912963 2330551 2330551 defendant ryvell Thomas yeoman 593914 593914 ryvell, Thomas, of Hygham, yeoman 1
4922146 2333339 2333339 defendant Leche Lawrence tanner 593914 593914 Leche, Lawrence, of Hygham, tanner 0
4922147 2333339 2333339 defendant Godfrey John baker 593914 593914 Godfrey, John, of Hygham, baker 1
4935492 2337499 2337499 plaintiff Beneyth John   593914 593914 Beneyth, John, of Hygham 0
4960882 2345217 2345217 plaintiff Beneyth or Beveyth John   593914 593914 Beneyth or Beveyth, John, of Hygham 0
4969820 2347919 2347919 defendant Peke William   593914 593914 Peke, William, of Hygham, franklin 0
4983200 2351877 2351877 defendant Webbe John yeoman 593914 593914 Webbe, John, of Hygham, yeoman 1
4983201 2351877 2351877 defendant Pette William yeoman 593914 593914 Pette, William, of Hygham, yeoman 2
5064322 2375876 2375876 defendant de Walley John husbandman 593914 593914 de Walley, John, of Hygham, husbandman 0
5064338 2375880 2375880 defendant Walley John husbandman 593914 593914 Walley, John, of Hygham, husbandman 0
5085095 2382045 2382045 defendant Hervy William weaver 593914 593914 Hervy, William, of Hygham, weaver 0
5266607 2435307 2435307 defendant Barrye William husbandman 593914 593914 Barrye, William, of Hygham, husbandman 0
5278783 2438902 2438902 defendant Coggeshale William yeoman 593914 593914 Coggeshale, William, of Hygham, yeoman 6
5278784 2438902 2438902 defendant Wrotteham Robert laborer 593914 593914 Wrotteham, Robert, of Hygham, laborer 7
5289970 2442071 2442071 defendant Melle Robert clothmaker 593914 593914 Melle, Robert, of Hygham, clothmaker 0
5397497 2474358 2474358 defendant Haton Thomas yeoman 593914 593914 Haton, Thomas, of Hygham, yeoman 16
5424670 2482337 2482337 defendant Hacon Thomas yeoman 593914 593914 Hacon, Thomas, of Hygham, yeoman 16
5443397 2487938 2487938 defendant Haton Thomas yeoman 593914 593914 Haton, Thomas, of Hygham, yeoman 14
5468303 2495463 2495463 defendant Bedull Thomas laborer 593914 593914 Bedull, Thomas, of Hygham, laborer 0
5481205 2499330 2499330 defendant Goodman Thomas husbandman 593914 593914 Goodman, Thomas, of Hygham, husbandman 0
5481208 2499331 2499331 defendant Goodman Thomas husbandman 593914 593914 Goodman, Thomas, of Hygham, husbandman 0
5495306 2503493 2503493 defendant Growe Thomas, senior husbandman 593914 593914 Growe, Thomas, senior, of Hygham, husbandman 0
5495307 2503493 2503493 defendant Growe Thomas, junior husbandman 593914 593914 Growe, Thomas, junior, of Hygham, husbandman 1
5540448 2517143 2517143 defendant Harrys Richard, senior husbandman 593914 593914 Harrys, Richard, senior, of Hygham, husbandman 0
5540449 2517143 2517143 defendant Caponhurst Thomas husbandman 593914 593914 Caponhurst, Thomas, of Hygham, husbandman 1
5540450 2517143 2517143 defendant Taillour John husbandman 593914 593914 Taillour, John, of Hygham, husbandman 2
5540451 2517143 2517143 defendant Jacum John husbandman 593914 593914 Jacum, John, of Hygham, husbandman 3
5543141 2517972 2517972 defendant Rington Gilbert gent 593914 593914 Rington, Gilbert, of Hygham, gent 0
5556096 2521778 2521778 defendant Langton Cuthbert gent 593914 593914 Langton, Cuthbert, of Hygham, gent 1
5561510 2523345 2523345 defendant Bocher John husbandman 593914 593914 Bocher, John, of Hygham, husbandman 4
5573106 2526689 2526689 defendant Kebold John husbandman 593914 593914 Kebold, John, of Hygham, husbandman 1

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