names

117 rows where place_id = 598060

✎ 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
3630963 1904504 1904504 defendant Hollok John yeoman 598060 598060 Hollok, John, of Westfeld, yeoman 2
3630964 1904504 1904504 defendant Wyke John yeoman 598060 598060 Wyke, John, of Westfeld, yeoman 3
3661004 1913715 1913715 defendant Belle Thomas clerk 598060 598060 Belle, Thomas, of Westfeld, clerk 0
3676444 1918677 1918677 defendant Belle Thomas clerk 598060 598060 Belle, Thomas, of Westfeld, clerk 0
3689640 1922919 1922919 defendant Cooke Thomas husbandman 598060 598060 Cooke, Thomas, of Westfeld, husbandman 3
3840598 1970625 1970625 defendant Belys John shoemaker 598060 598060 Belys, John, of Westfeld, shoemaker 2
3850587 1973771 1973771 defendant Bele John shoemaker 598060 598060 Bele, John, of Westfeld, shoemaker 1
3872209 1980934 1980934 defendant Grene William husbandman 598060 598060 Grene, William, of Westfeld, husbandman 0
3872211 1980935 1980935 defendant Grene William husbandman 598060 598060 Grene, William, of Westfeld, husbandman 0
3919637 1996901 1996901 defendant Frend John, junior husbandman 598060 598060 Frend, John, junior, of Westfeld, husbandman 0
3992022 2021912 2021912 defendant Dey Nicholas husbandman 598060 598060 Dey, Nicholas, of Westfeld, husbandman 2
4019385 2031667 2031667 defendant Browne William yeoman 598060 598060 Browne, William, of Westfeld, yeoman 0
4085525 2055098 2055098 defendant Mortener Robert husbandman 598060 598060 Mortener, Robert, of Westfeld, husbandman 1
4085677 2055148 2055148 defendant Master John laborer 598060 598060 Master, John, of Westfeld, laborer 5
4189128 2091689 2091689 defendant Pedymont Thomas husbandman 598060 598060 Pedymont, Thomas, of Westfeld, husbandman 0
4450021 2184965 2184965 defendant Wiltyngg William   598060 598060 Wiltyngg, William, of Westfeld 1
4450024 2184966 2184966 defendant Wyltyng William   598060 598060 Wyltyng, William, of Westfeld 1
4572721 2223007 2223007 defendant Chapman John   598060 598060 Chapman, John, of Westfeld 0
4619658 2237134 2237134 defendant Smyth Richard   598060 598060 Smyth, Richard, of Westfeld 1
4625141 2238828 2238828 defendant atte Wode John, sen   598060 598060 atte Wode, John, sen, of Westfeld 0
4627354 2239495 2239495 defendant Knyght Richard   598060 598060 Knyght, Richard, of Westfeld 0
4667497 2255555 2255555 defendant Norman Simon clerk 598060 598060 Norman, Simon, of Westfeld, clerk 3
4693433 2263446 2263446 defendant Dyer Peter (legal representative) 598060 598060 Dyer, Peter, of Westfeld, vicar, executor of 3
4702500 2266195 2266195 defendant atte Stone Thomas husbandman 598060 598060 atte Stone, Thomas, of Westfeld, husbandman 1
4708888 2268146 2268146 defendant atte Grove John laborer 598060 598060 atte Grove, John, of Westfeld, laborer 0
4708889 2268146 2268146 defendant Bokherst Thomas laborer 598060 598060 Bokherst, Thomas, of Westfeld, laborer 1
4708890 2268146 2268146 defendant Cheseman Thomas laborer 598060 598060 Cheseman, Thomas, of Westfeld, laborer 2
4708891 2268146 2268146 defendant atte Grove Cicely spinster 598060 598060 atte Grove, Cicely, of Westfeld, spinster 3
4730641 2274785 2274785 plaintiff Martyn John   598060 598060 Martyn, John, of Westfeld 0
4730642 2274785 2274785 defendant Wiltyng Stephen laborer 598060 598060 Wiltyng, Stephen, of Westfeld, laborer 0
4733654 2275704 2275704 defendant Wodeman Thomas husbandman 598060 598060 Wodeman, Thomas, of Westfeld, husbandman 1
4733655 2275704 2275704 defendant Cheseman Thomas husbandman 598060 598060 Cheseman, Thomas, of Westfeld, husbandman 2
4733656 2275704 2275704 defendant Adam John husbandman 598060 598060 Adam, John, of Westfeld, husbandman 3
4739221 2277359 2277359 plaintiff Wyltyngghe William   598060 598060 Wyltyngghe, William, of Westfeld 0
4741871 2278120 2278120 defendant Long Laurence yeoman 598060 598060 Long, Laurence, of Westfeld, yeoman 0
4741873 2278121 2278121 defendant Longe Lawrence yeoman 598060 598060 Longe, Lawrence, of Westfeld, yeoman 0
4776923 2288770 2288770 defendant Longe Lawrence husbandman 598060 598060 Longe, Lawrence, of Westfeld, husbandman 0
4780006 2289748 2289748 defendant Seyere John husbandman 598060 598060 Seyere, John, of Westfeld, husbandman 0
4780007 2289748 2289748 defendant Seyere Richard laborer 598060 598060 Seyere, Richard, of Westfeld, laborer 1
4784595 2291189 2291189 defendant Wyltyng Stephen husbandman 598060 598060 Wyltyng, Stephen, of Westfeld, husbandman 0
4784596 2291189 2291189 defendant Wyltyng William husbandman 598060 598060 Wyltyng, William, of Westfeld, husbandman 1
4784597 2291189 2291189 defendant Randulf John husbandman 598060 598060 Randulf, John, of Westfeld, husbandman 2
4821091 2302676 2302676 defendant Sayer John husbandman 598060 598060 Sayer, John, of Westfeld, husbandman 0
4832954 2306326 2306326 plaintiff Chapman Henry   598060 598060 Chapman, Henry, of Westfeld 0
4832956 2306326 2306326 defendant Norman Simon   598060 598060 Norman, Simon, of Westfeld, parson 0
4865249 2316104 2316104 defendant Freman Thomas laborer 598060 598060 Freman, Thomas, of Westfeld, laborer 0
4934457 2337169 2337169 defendant Gaytford John husbandman 598060 598060 Gaytford, John, of Westfeld, husbandman 0
4936338 2337761 2337761 plaintiff Bothe William   598060 598060 Bothe, William, of Westfeld 0
4936339 2337761 2337761 defendant Makerell Peter yeoman 598060 598060 Makerell, Peter, of Westfeld, yeoman 0
4959168 2344710 2344710 defendant Large John laborer 598060 598060 Large, John, of Westfeld, laborer 0
4959658 2344849 2344849 defendant Mone Richard husbandman 598060 598060 Mone, Richard, of Westfeld, husbandman 3
4961994 2345545 2345545 defendant Smyth James husbandman 598060 598060 Smyth, James, of Westfeld, husbandman 0
4968578 2347567 2347567 defendant Coo Richard laborer 598060 598060 Coo, Richard, of Westfeld, laborer 2
4995271 2355432 2355432 defendant Coo Richard laborer 598060 598060 Coo, Richard, of Westfeld, laborer 2
5000942 2357156 2357156 defendant atte Wode Thomas husbandman 598060 598060 atte Wode, Thomas, of Westfeld, husbandman 0
5000943 2357156 2357156 defendant atte Wode John husbandman 598060 598060 atte Wode, John, of Westfeld, husbandman 1
5029714 2365561 2365561 defendant Martyn Richard husbandman 598060 598060 Martyn, Richard, of Westfeld, husbandman 0
5053606 2372680 2372680 defendant Harry Thomas tailor 598060 598060 Harry, Thomas, of Westfeld, tailor 0
5068750 2377150 2377150 defendant Bernet Alice widow 598060 598060 Bernet, Alice, of Westfeld, widow 0
5073459 2378546 2378546 defendant Whytyng John husbandman 598060 598060 Whytyng, John, of Westfeld, husbandman 0
5075934 2379295 2379295 defendant Ode Richard tailor 598060 598060 Ode, Richard, of Westfeld, tailor 0
5083089 2381450 2381450 defendant Vynehagh Thomas tanner 598060 598060 Vynehagh, Thomas, of Westfeld, tanner 0
5104853 2387855 2387855 plaintiff Chapman James   598060 598060 Chapman, James, of Westfeld 0
5126484 2394224 2394224 defendant Barnet Robert husbandman 598060 598060 Barnet, Robert, of Westfeld, husbandman 0
5126485 2394224 2394224 defendant Sayer William carpenter 598060 598060 Sayer, William, of Westfeld, carpenter 1
5126486 2394224 2394224 defendant Hollyngton Thomas husbandman 598060 598060 Hollyngton, Thomas, of Westfeld, husbandman 2
5145019 2399689 2399689 defendant Bernet Robert sawyer 598060 598060 Bernet, Robert, of Westfeld, sawyer 0
5145020 2399689 2399689 defendant Sayer William carpenter 598060 598060 Sayer, William, of Westfeld, carpenter 1
5145021 2399689 2399689 defendant Hollyngton Thomas husbandman 598060 598060 Hollyngton, Thomas, of Westfeld, husbandman 2
5217609 2420890 2420890 defendant Martyn Thomas husbandman 598060 598060 Martyn, Thomas, of Westfeld, husbandman 6
5217618 2420890 2420890 defendant Vynawe Thomas husbandman 598060 598060 Vynawe, Thomas, of Westfeld, husbandman 15
5217624 2420890 2420890 defendant Broun John husbandman 598060 598060 Broun, John, of Westfeld, husbandman 21
5242210 2427923 2427923 defendant Hamond John laborer 598060 598060 Hamond, John, of Westfeld, laborer 0
5250602 2430297 2430297 defendant Chapman John husbandman 598060 598060 Chapman, John, of Westfeld, husbandman 3
5282938 2440072 2440072 defendant Vawedry Henry husbandman 598060 598060 Vawedry, Henry, of Westfeld, husbandman 0
5297792 2444361 2444361 defendant Andrewe Robert husbandman 598060 598060 Andrewe, Robert, of Westfeld, husbandman 0
5298854 2444645 2444645 defendant Vynagh Thomas tanner 598060 598060 Vynagh, Thomas, of Westfeld, tanner 0
5298855 2444645 2444645 defendant Vynagh Stephen husbandman 598060 598060 Vynagh, Stephen, of Westfeld, husbandman 1
5299079 2444714 2444714 defendant Dunston John clerk 598060 598060 Dunston, John, of Westfeld, clerk 0
5299113 2444721 2444721 defendant Sayer Edward laborer 598060 598060 Sayer, Edward, of Westfeld, laborer 3
5299114 2444721 2444721 defendant Holewoke William laborer 598060 598060 Holewoke, William, of Westfeld, laborer 4
5321263 2451456 2451456 defendant Vynehawe Henry carpenter 598060 598060 Vynehawe, Henry, of Westfeld, carpenter 1
5321264 2451456 2451456 defendant Vynehawe Thomas carpenter 598060 598060 Vynehawe, Thomas, of Westfeld, carpenter 2
5321267 2451457 2451457 defendant Vynehawe Henry carpenter 598060 598060 Vynehawe, Henry, of Westfeld, carpenter 1
5321268 2451457 2451457 defendant Vynehawe Thomas husbandman 598060 598060 Vynehawe, Thomas, of Westfeld, husbandman 2
5323482 2452101 2452101 defendant Vynehawe Thomas yeoman 598060 598060 Vynehawe, Thomas, of Westfeld, yeoman 1
5331848 2454605 2454605 defendant Olmston John clerk 598060 598060 Olmston, John, of Westfeld, clerk 2
5333088 2454967 2454967 defendant Corker Nicholas husbandman 598060 598060 Corker, Nicholas, of Westfeld, husbandman 0
5349678 2460034 2460034 plaintiff Chapman James   598060 598060 Chapman, James, of Westfeld 0
5351533 2460577 2460577 defendant Chapman James yeoman 598060 598060 Chapman, James, of Westfeld, yeoman 4
5352179 2460782 2460782 defendant atte Wode John husbandman 598060 598060 atte Wode, John, of Westfeld, husbandman 3
5353150 2461063 2461063 defendant Wodeman John husbandman 598060 598060 Wodeman, John, of Westfeld, husbandman 0
5367655 2465526 2465526 defendant Whytyng John husbandman 598060 598060 Whytyng, John, of Westfeld, husbandman 0
5380871 2469584 2469584 defendant Neuman Robert husbandman 598060 598060 Neuman, Robert, of Westfeld, husbandman 3
5386721 2471268 2471268 defendant Neuman Robert husbandman 598060 598060 Neuman, Robert, of Westfeld, husbandman 3
5391884 2472756 2472756 defendant Norden Thomas husbandman 598060 598060 Norden, Thomas, of Westfeld, husbandman 0
5398749 2474707 2474707 defendant Whytyng John husbandman 598060 598060 Whytyng, John, of Westfeld, husbandman 2
5399041 2474797 2474797 defendant Neuman Robert husbandman 598060 598060 Neuman, Robert, of Westfeld, husbandman 3
5411859 2478499 2478499 defendant Whytyng John husbandman 598060 598060 Whytyng, John, of Westfeld, husbandman 2
5430169 2483961 2483961 defendant Fynawe John tailor 598060 598060 Fynawe, John, of Westfeld, tailor 1

Next page

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