names

166 rows where place_id = 596535

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595501 1866228 1866228 plaintiff Merell Edmund (legal representative) 596535 596535 Merell, Edmund, of Lutterworth, executor of 0
3625154 1875402 1875402 plaintiff Wegyn Richard   596535 596535 Wegyn, Richard, of Lutterworth 0
3645293 1908937 1908937 defendant Pakeman Richard yeoman 596535 596535 Pakeman, Richard, of Lutterworth, yeoman 0
3658982 1913074 1913074 defendant Knottysford Humphrey clerk of the Hospice of St John the Baptist 596535 596535 Knottysford, Humphrey, of Lutterworth, clerk of the Hospice of St John the Baptist 0
3659404 1913201 1913201 defendant Knottesford Humphrey clerk & guardian of the Hospice of St John 596535 596535 Knottesford, Humphrey, of Lutterworth, clerk & guardian of the Hospice of St John 0
3680118 1919850 1919850 defendant Hodson George innholder 596535 596535 Hodson, George, of Lutterworth, innholder 1
3758398 1944620 1944620 defendant Stokes John butcher 596535 596535 Stokes, John, of Lutterworth, butcher 0
3758399 1944620 1944620 defendant Tayler John butcher 596535 596535 Tayler, John, of Lutterworth, butcher 1
3772541 1949101 1949101 defendant Broderton John butcher 596535 596535 Broderton, John, of Lutterworth, butcher 1
3773601 1949456 1949456 defendant Preste Alexander husbandman 596535 596535 Preste, Alexander, of Lutterworth, husbandman 0
3803041 1958853 1958853 defendant Knottesford William yeoman 596535 596535 Knottesford, William, of Lutterworth, yeoman 0
3803042 1958853 1958853 defendant Kabull Thomas husbandman 596535 596535 Kabull, Thomas, of Lutterworth, husbandman 1
3807769 1960314 1960314 defendant Cotton Nicholas smith 596535 596535 Cotton, Nicholas, of Lutterworth, smith 0
3868282 1979631 1979631 defendant Hynd George yeoman 596535 596535 Hynd, George, of Lutterworth, yeoman 0
3868284 1979632 1979632 defendant Mason Robert chaplain 596535 596535 Mason, Robert, of Lutterworth, chaplain 0
3883522 1984761 1984761 defendant Carman Henry cordwainer 596535 596535 Carman, Henry, of Lutterworth, cordwainer 0
3927059 1999389 1999389 defendant Johnson Richard yeoman 596535 596535 Johnson, Richard, of Lutterworth, yeoman 0
3927060 1999389 1999389 defendant Weke Thomas   596535 596535 Weke, Thomas, of Lutterworth, iron monger 1
3927061 1999389 1999389 defendant Johnson John yeoman 596535 596535 Johnson, John, of Lutterworth, yeoman 2
3950476 2007244 2007244 plaintiff Gaddon Hugh (legal representative) 596535 596535 Gaddon, Hugh, of Lutterworth, woolen draper, executrix of 0
3951588 2007612 2007612 plaintiff Haddon Hugh (legal representative) 596535 596535 Haddon, Hugh, of Lutterworth, woollen draper, executrix of 0
3976144 2016224 2016224 plaintiff Johnson John (legal representative) 596535 596535 Johnson, John, of Lutterworth, innholder, executrix of 0
3983343 2018815 2018815 defendant Edlington Hugh chapman 596535 596535 Edlington, Hugh, of Lutterworth, chapman 1
4073842 2050935 2050935 defendant Worlaughton Thomas yeoman 596535 596535 Worlaughton, Thomas, of Lutterworth, yeoman 0
4074459 2051169 2051169 defendant Bruce Thomas cordwainer 596535 596535 Bruce, Thomas, of Lutterworth, or of Middelton, Nhants, cordwainer 0
4246304 2111740 2111740 defendant Insley Richard yeoman 596535 596535 Insley, Richard, of Lutterworth, yeoman 0
4252082 2113686 2113686 defendant Insley Richard yeoman 596535 596535 Insley, Richard, of Lutterworth, yeoman 0
4258894 2115947 2115947 defendant Insley Richard yeoman 596535 596535 Insley, Richard, of Lutterworth, yeoman 0
4279881 2122875 2122875 defendant Gote Alice widow 596535 596535 Gote, Alice, of Lutterworth, widow 2
4281292 2123364 2123364 defendant Hayward William, senior (legal representative) 596535 596535 Hayward, William, senior, of Lutterworth, yeoman, administratrix of 3
4281293 2123364 2123364 defendant Hayward Alice widow 596535 596535 Hayward, Alice, of Lutterworth, widow 4
4299569 2129935 2129935 defendant Wyatt Nicholas innholder 596535 596535 Wyatt, Nicholas, of Lutterworth, innholder 0
4300936 2130435 2130435 defendant Grene William glover 596535 596535 Grene, William, of Lutterworth, glover 0
4311467 2134155 2134155 defendant Glover Richard, junior yeoman 596535 596535 Glover, Richard, junior, of Lutterworth, yeoman 0
4315324 2135470 2135470 defendant Clement Edward clerk 596535 596535 Clement, Edward, of Lutterworth, clerk 1
4315325 2135470 2135470 defendant Insley Richard yeoman 596535 596535 Insley, Richard, of Lutterworth, yeoman 2
4321984 2137773 2137773 defendant Clement Edward clerk 596535 596535 Clement, Edward, of Lutterworth, or of Little Dalby, Leics, clerk 0
4357183 2149741 2149741 defendant Insley Richard yeoman 596535 596535 Insley, Richard, of Lutterworth, yeoman 1
4358875 2150339 2150339 defendant Lowe Edmund yeoman 596535 596535 Lowe, Edmund, of Lutterworth, yeoman 0
4362379 2151597 2151597 defendant Danford Thomas mercer 596535 596535 Danford, Thomas, of Lutterworth, mercer 0
4364252 2152275 2152275 defendant Waight Nicholas innholder 596535 596535 Waight, Nicholas, of Lutterworth, innholder 0
4364254 2152276 2152276 defendant Waight Nicholas innholder 596535 596535 Waight, Nicholas, of Lutterworth, innholder 0
4366619 2153109 2153109 defendant Kynne Arthur husbandman 596535 596535 Kynne, Arthur, of Lutterworth, husbandman 0
4380426 2158109 2158109 defendant Kynney William yeoman 596535 596535 Kynney, William, of Lutterworth, yeoman 1
4418651 2170707 2170707 defendant Knyvet Adam   596535 596535 Knyvet, Adam, of Lutterworth 1
4427940 2173577 2173577 defendant Knyvet Adam   596535 596535 Knyvet, Adam, of Lutterworth 1
4434450 2175531 2175531 defendant Walcote Agnes de   596535 596535 Walcote, Agnes de, of Lutterworth, formerly wife of Geoffrey 0
4434948 2175692 2175692 defendant Walcote Nicholas de   596535 596535 Walcote, Nicholas de, of Lutterworth, son of Agnes 0
4435841 2175958 2175958 plaintiff Poyntel John (legal representative) 596535 596535 Poyntel, John, of Lutterworth, executor of 0
4456354 2187011 2187011 defendant Overton William   596535 596535 Overton, William, of Lutterworth 0
4456356 2187012 2187012 defendant Overton William   596535 596535 Overton, William, of Lutterworth 0
4457032 2187212 2187212 defendant Overton William   596535 596535 Overton, William, of Lutterworth 0
4458420 2187675 2187675 defendant Overton William de   596535 596535 Overton, William de, of Lutterworth 0
4476465 2193305 2193305 plaintiff Fyldynges William   596535 596535 Fyldynges, William, of Lutterworth 0
4484577 2195871 2195871 defendant Lilleburn Simon   596535 596535 Lilleburn, Simon, of Lutterworth 0
4484579 2195872 2195872 defendant Lillebarne Simon   596535 596535 Lillebarne, Simon, of Lutterworth 0
4485202 2196075 2196075 defendant Freman John   596535 596535 Freman, John, of Lutterworth 0
4490649 2197774 2197774 defendant Freman John   596535 596535 Freman, John, of Lutterworth 0
4498162 2200081 2200081 defendant Morehous John   596535 596535 Morehous, John, of Lutterworth, parson 1
4500020 2200648 2200648 defendant Norys William   596535 596535 Norys, William, of Lutterworth 0
4558030 2218447 2218447 defendant Freman John   596535 596535 Freman, John, of Lutterworth 0
4558530 2218618 2218618 defendant Barban Giles   596535 596535 Barban, Giles, of Lutterworth 2
4570971 2222487 2222487 defendant Freman John   596535 596535 Freman, John, of Lutterworth 0
4570972 2222487 2222487 defendant Freman Henry   596535 596535 Freman, Henry, of Lutterworth 1
4570975 2222488 2222488 defendant Freman John   596535 596535 Freman, John, of Lutterworth 0
4570976 2222488 2222488 defendant Freman Henry   596535 596535 Freman, Henry, of Lutterworth 1
4582769 2226047 2226047 plaintiff Felldyng John, sen   596535 596535 Felldyng, John, sen, of Lutterworth 0
4582845 2226067 2226067 defendant Overton Agnes   596535 596535 Overton, Agnes, of Lutterworth, formerly wife of William 0
4582847 2226068 2226068 defendant Shephird Margaret   596535 596535 Shephird, Margaret, of Lutterworth, formerly wife of Simon 0
4597990 2230627 2230627 defendant Fyldyng William   596535 596535 Fyldyng, William, of Lutterworth 0
4638812 2242876 2242876 defendant Garton William   596535 596535 Garton, William, of Lutterworth 0
4642064 2243787 2243787 defendant Tryppe John   596535 596535 Tryppe, John, of Lutterworth 0
4645074 2244629 2244629 defendant Swynford John   596535 596535 Swynford, John, of Lutterworth 0
4664929 2250511 2250511 defendant Helwys John husbandman 596535 596535 Helwys, John, of Lutterworth, husbandman 0
4682003 2259988 2259988 defendant Fouke Thomas butcher 596535 596535 Fouke, Thomas, of Lutterworth, butcher 0
4682005 2259988 2259988 defendant Smyth John chaplain 596535 596535 Smyth, John, of Lutterworth, chaplain 2
4686289 2261315 2261315 defendant Chapman Thomas chapman 596535 596535 Chapman, Thomas, of Lutterworth, chapman 0
4717037 2270657 2270657 defendant Trip John husbandman 596535 596535 Trip, John, of Lutterworth, husbandman 0
4720323 2271697 2271697 defendant Stone William   596535 596535 Stone, William, of Lutterworth 2
4729862 2274545 2274545 defendant Maynard John smith 596535 596535 Maynard, John, of Lutterworth, smith 0
4740189 2277644 2277644 defendant Goman Roger husbandman 596535 596535 Goman, Roger, of Lutterworth, husbandman 0
4777795 2289046 2289046 defendant Milner John miller 596535 596535 Milner, John, of Lutterworth, miller 2
4788306 2292415 2292415 defendant Bykirstaf Henry husbandman 596535 596535 Bykirstaf, Henry, of Lutterworth, husbandman 0
4788307 2292415 2292415 defendant Pakker John husbandman 596535 596535 Pakker, John, of Lutterworth, husbandman 1
4788308 2292415 2292415 defendant Whorne John chaplain 596535 596535 Whorne, John, of Lutterworth, chaplain 2
4802937 2297102 2297102 defendant Milner John milner 596535 596535 Milner, John, of Lutterworth, milner 1
4811347 2299660 2299660 plaintiff Fyldyng John merchant 596535 596535 Fyldyng, John, of Lutterworth, merchant 0
4811352 2299661 2299661 plaintiff Fyldyng John merchant 596535 596535 Fyldyng, John, of Lutterworth, merchant 0
4868061 2316982 2316982 defendant Fode John brasier 596535 596535 Fode, John, of Lutterworth, brasier 1
4879734 2320580 2320580 defendant Overton Joan widow 596535 596535 Overton, Joan, of Lutterworth, widow 1
4882236 2321352 2321352 defendant Faysy William clerk 596535 596535 Faysy, William, of Lutterworth, clerk 0
4928266 2335267 2335267 defendant Tryppe John yeoman 596535 596535 Tryppe, John, of Lutterworth, yeoman 0
4994840 2355310 2355310 defendant Carter Richard cooper 596535 596535 Carter, Richard, of Lutterworth, cooper 1
4994841 2355310 2355310 defendant Cok William   596535 596535 Cok, William, of Lutterworth, servant 2
4994842 2355310 2355310 defendant Smyth Henry   596535 596535 Smyth, Henry, of Lutterworth, servant 3
5011236 2360144 2360144 defendant Almay William husbandman 596535 596535 Almay, William, of Lutterworth, husbandman 1
5028079 2365090 2365090 defendant Swage Thomas chapman 596535 596535 Swage, Thomas, of Lutterworth, chapman 2
5045569 2370305 2370305 defendant Horne John butcher 596535 596535 Horne, John, of Lutterworth, butcher 1
5070216 2377583 2377583 defendant Hall John carpenter 596535 596535 Hall, John, of Lutterworth, carpenter 0
5070222 2377584 2377584 defendant Hall John carpenter 596535 596535 Hall, John, of Lutterworth, carpenter 0

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