names

83 rows where place_id = 595802

✎ 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
3621971 1874414 1874414 defendant Byrde Robert, senior husbandman 595802 595802 Byrde, Robert, senior, of Ovyng, husbandman 0
3662689 1914249 1914249 defendant Reyner Robert husbandman 595802 595802 Reyner, Robert, of Ovyng, husbandman 2
3730310 1935711 1935711 defendant Redman Thomas gent 595802 595802 Redman, Thomas, of Ovyng, gent 0
3757703 1944390 1944390 defendant Redmayne Thomas gent 595802 595802 Redmayne, Thomas, of Ovyng, gent 0
3771408 1948749 1948749 defendant Hyllesdon John husbandman 595802 595802 Hyllesdon, John, of Ovyng, husbandman 0
3775651 1950132 1950132 defendant Rodmayn Thomas gent 595802 595802 Rodmayn, Thomas, of Ovyng, gent 0
3842091 1971079 1971079 defendant Rayner John husbandman 595802 595802 Rayner, John, of Ovyng, husbandman 2
3849296 1973373 1973373 defendant Ivyottes John   595802 595802 Ivyottes, John, of Ovyng, yeoman, bailiff of Cotteslowe 1
3859902 1976817 1976817 defendant Ivattys John husbandman 595802 595802 Ivattys, John, of Ovyng, husbandman 0
3874228 1981602 1981602 defendant Evatte John   595802 595802 Evatte, John, of Ovyng, yeoman, bailiff of Asshendon Hundred 3
3894490 1988364 1988364 defendant Evattys John yeoman 595802 595802 Evattys, John, of Ovyng, yeoman 0
3901360 1990676 1990676 defendant Evyat John husbandman 595802 595802 Evyat, John, of Ovyng, husbandman 1
3915154 1995426 1995426 defendant Evatt John   595802 595802 Evatt, John, of Ovyng, yeoman, bailiff of Ashenden 0
4009657 2028223 2028223 plaintiff Nicols Edmund yeoman 595802 595802 Nicols, Edmund, of Ovyng, yeoman 0
4417041 2170204 2170204 plaintiff Purtel Adam   595802 595802 Purtel, Adam, of Ovyng 0
4483557 2195545 2195545 defendant Midelton Thomas   595802 595802 Midelton, Thomas, of Ovyng, parson 0
4492201 2198242 2198242 defendant Middilton Thomas de   595802 595802 Middilton, Thomas de, of Ovyng, parson 0
4505519 2202258 2202258 defendant Doubyng William   595802 595802 Doubyng, William, of Ovyng 0
4513201 2204553 2204553 defendant Walssh John   595802 595802 Walssh, John, of Ovyng 0
4610250 2234290 2234290 defendant atte Grove Lawrence   595802 595802 atte Grove, Lawrence, of Ovyng 0
4612310 2234917 2234917 defendant atte Lane Nicholas   595802 595802 atte Lane, Nicholas, of Ovyng 2
4638300 2242747 2242747 defendant atte Grove Lawrence   595802 595802 atte Grove, Lawrence, of Ovyng 0
4638303 2242748 2242748 defendant atte Grove Lawrence   595802 595802 atte Grove, Lawrence, of Ovyng 0
4659116 2248723 2248723 defendant Yonge William husbandman 595802 595802 Yonge, William, of Ovyng, husbandman 0
4669735 2256236 2256236 defendant Corvyser William laborer 595802 595802 Corvyser, William, of Ovyng, laborer 2
4722762 2272435 2272435 defendant Bedyng William husbandman 595802 595802 Bedyng, William, of Ovyng, husbandman 2
4722763 2272435 2272435 defendant Dubbyng John husbandman 595802 595802 Dubbyng, John, of Ovyng, husbandman 3
4731415 2275025 2275025 defendant Hogges John husbandman 595802 595802 Hogges, John, of Ovyng, husbandman 1
4761778 2284026 2284026 defendant Lane Nicholas in the husbandman 595802 595802 Lane, Nicholas in the, of Ovyng, husbandman 0
4761779 2284026 2284026 defendant Didyng William husbandman 595802 595802 Didyng, William, of Ovyng, husbandman 1
4768027 2285967 2285967 defendant Wychere Robert husbandman 595802 595802 Wychere, Robert, of Ovyng, husbandman 0
4792468 2293731 2293731 defendant Wychere Robert husbandman 595802 595802 Wychere, Robert, of Ovyng, husbandman 0
4795767 2294828 2294828 defendant Wilby Richard husbandman 595802 595802 Wilby, Richard, of Ovyng, husbandman 0
4795768 2294828 2294828 defendant Wilby William laborer 595802 595802 Wilby, William, of Ovyng, laborer 1
4795769 2294828 2294828 defendant Lane Nicholas husbandman 595802 595802 Lane, Nicholas, of Ovyng, husbandman 2
4795770 2294828 2294828 defendant Wilby Joan singlewoman 595802 595802 Wilby, Joan, of Ovyng, singlewoman 3
4800277 2296265 2296265 defendant Lane Nicholas husbandman 595802 595802 Lane, Nicholas, of Ovyng, husbandman 0
4800278 2296265 2296265 defendant Smyth Robert laborer 595802 595802 Smyth, Robert, of Ovyng, laborer 1
4800279 2296265 2296265 defendant Wychere Robert husbandman 595802 595802 Wychere, Robert, of Ovyng, husbandman 2
4815606 2300987 2300987 defendant Lane Nicholas husbandman 595802 595802 Lane, Nicholas, of Ovyng, husbandman 1
4852006 2312061 2312061 plaintiff Walshe John   595802 595802 Walshe, John, of Ovyng 0
4852009 2312061 2312061 defendant Totegose Henry husbandman 595802 595802 Totegose, Henry, of Ovyng, husbandman 2
4852656 2312250 2312250 defendant Lane Nicholas husbandman 595802 595802 Lane, Nicholas, of Ovyng, husbandman 0
4876585 2319643 2319643 defendant Symeon William husbandman 595802 595802 Symeon, William, of Ovyng, husbandman 0
4880013 2320662 2320662 plaintiff Walsshe John   595802 595802 Walsshe, John, of Ovyng 0
4918500 2332306 2332306 defendant Wodelond John husbandman 595802 595802 Wodelond, John, of Ovyng, husbandman 0
4918502 2332307 2332307 defendant Wodelond John husbandman 595802 595802 Wodelond, John, of Ovyng, husbandman 0
4920725 2332997 2332997 defendant Leede John husbandman 595802 595802 Leede, John, of Ovyng, husbandman 0
4922810 2333547 2333547 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 2
4927193 2334939 2334939 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 0
4927976 2335181 2335181 defendant Brewer Thomas husbandman 595802 595802 Brewer, Thomas, of Ovyng, husbandman 0
4929236 2335561 2335561 defendant Bedyng William husbandman 595802 595802 Bedyng, William, of Ovyng, husbandman 0
4952451 2342691 2342691 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 0
4952452 2342691 2342691 defendant Kyng Thomas husbandman 595802 595802 Kyng, Thomas, of Ovyng, husbandman 1
4952453 2342691 2342691 defendant Dubbyng John husbandman 595802 595802 Dubbyng, John, of Ovyng, husbandman 2
4952454 2342691 2342691 defendant Wilby William husbandman 595802 595802 Wilby, William, of Ovyng, husbandman 3
4978578 2350544 2350544 defendant Kyng Thomas laborer 595802 595802 Kyng, Thomas, of Ovyng, laborer 0
4978579 2350544 2350544 defendant Garlond William laborer 595802 595802 Garlond, William, of Ovyng, laborer 1
4978580 2350544 2350544 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 2
4982786 2351765 2351765 defendant Eggele Philip husbandman 595802 595802 Eggele, Philip, of Ovyng, husbandman 0
4995778 2355580 2355580 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 0
5031948 2366215 2366215 defendant Balle William laborer 595802 595802 Balle, William, of Ovyng, laborer 0
5031949 2366215 2366215 defendant Mory John husbandman 595802 595802 together with Mory, John, of Ovyng, husbandman 1
5031950 2366215 2366215 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 2
5031954 2366217 2366217 defendant Mory John husbandman 595802 595802 Mory, John, of Ovyng, husbandman 0
5031955 2366217 2366217 defendant Lucas William husbandman 595802 595802 Lucas, William, of Ovyng, husbandman 1
5031975 2366224 2366224 plaintiff Ropere Richard husbandman 595802 595802 Ropere, Richard, of Ovyng, husbandman 0
5031977 2366225 2366225 plaintiff Ropere Richard husbandman 595802 595802 Ropere, Richard, of Ovyng, husbandman 0
5049738 2371547 2371547 defendant Bedyng William husbandman 595802 595802 Bedyng, William, of Ovyng, husbandman 0
5066937 2376636 2376636 plaintiff Nicholas Roger   595802 595802 Nicholas, Roger, of Ovyng, Bucksm husbandman 0
5074242 2378784 2378784 defendant Croucher John husbandman 595802 595802 Croucher, John, of Ovyng, husbandman 0
5098004 2385846 2385846 defendant Symeon William husbandman 595802 595802 Symeon, William, of Ovyng, husbandman 3
5098005 2385846 2385846 defendant Hyllysdon John husbandman 595802 595802 Hyllysdon, John, of Ovyng, husbandman 4
5111372 2389718 2389718 defendant Whityng John clerk 595802 595802 Whityng, John, of Ovyng, clerk 1
5111373 2389718 2389718 defendant Wallere Thomas husbandman 595802 595802 Wallere, Thomas, of Ovyng, husbandman 2
5283804 2440301 2440301 defendant Ryman William gent 595802 595802 Ryman, William, of Ovyng, gent 14
5286343 2441007 2441007 defendant Ryman William gent 595802 595802 Ryman, William, of Ovyng, gent 0
5286641 2441104 2441104 defendant Gryce William husbandman 595802 595802 Gryce, William, of Ovyng, husbandman 0
5286645 2441105 2441105 defendant Gryce William husbandman 595802 595802 Gryce, William, of Ovyng, husbandman 0
5368048 2465628 2465628 defendant Leget William husbandman 595802 595802 Leget, William, of Ovyng by Chichester, husbandman 0
5523873 2512291 2512291 defendant Legard James husbandman 595802 595802 Legard, James, of Ovyng, husbandman 1
5620303 2550206 2550206 defendant Louthe Robert de clerk 595802 595802 Louthe, Robert de, of Ovyng, clerk 0
5620306 2550207 2550207 defendant Louthe Robert de clerk 595802 595802 Louthe, Robert de, of Ovyng, clerk 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);