names

397 rows where place_id = 589461

✎ 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
3597700 1866905 1866905 defendant Neuton John gent 589461 589461 Neuton, John, of Louthe, gent 4
3597710 1866906 1866906 defendant Neuton John gent 589461 589461 Neuton, John, of Louthe, gent 4
3600182 1867707 1867707 defendant Leke John cooper 589461 589461 Leke, John, of Louthe, cooper 3
3622947 1874705 1874705 defendant Bonyffe Roger yeoman 589461 589461 Bonyffe, Roger, of Louthe, yeoman 0
3628066 1903633 1903633 defendant Wake William husbandman 589461 589461 Wake, William, of Louthe, husbandman 1
3628067 1903633 1903633 defendant Thomas William tanner 589461 589461 Thomas, William, of Louthe, tanner 2
3628168 1903666 1903666 defendant Wake William husbandman 589461 589461 Wake, William, of Louthe, husbandman 0
3638189 1906761 1906761 plaintiff Allerton Thomas yeoman 589461 589461 Allerton, Thomas, of Louthe, yeoman 2
3647595 1909636 1909636 defendant Burton Richard butcher 589461 589461 Burton, Richard, of Louthe, butcher 0
3647596 1909636 1909636 defendant Smyth Robert tanner 589461 589461 Smyth, Robert, of Louthe, tanner 1
3653221 1911344 1911344 defendant Lorde Robert tailor 589461 589461 Lorde, Robert, of Louthe, tailor 0
3656799 1912382 1912382 defendant Walton Alexander cordwainer 589461 589461 Walton, Alexander, of Louthe, cordwainer 0
3661842 1913989 1913989 defendant Stint Lawrence dyer 589461 589461 Stint, Lawrence, of Louthe, dyer 0
3661844 1913989 1913989 defendant Watson John   589461 589461 Watson, John, of Louthe, cord wainer 2
3667512 1915780 1915780 defendant West John butcher 589461 589461 West, John, of Louthe, butcher 1
3669345 1916350 1916350 defendant Wise Richard cordwainer 589461 589461 Wise, Richard, of Louthe, cordwainer 0
3669495 1916397 1916397 defendant Giles Thomas brickman 589461 589461 Giles, Thomas, of Louthe, brickman 2
3671743 1917149 1917149 defendant Colynwood Robert yeoman 589461 589461 Colynwood, Robert, of Louthe, yeoman 1
3677360 1918968 1918968 defendant Tomson John saddler 589461 589461 Tomson, John, of Louthe, saddler 0
3677361 1918968 1918968 defendant Otter Robert   589461 589461 Otter, Robert, of Louthe, wheelwright 1
3677485 1919007 1919007 defendant Jacson William glover 589461 589461 Jacson, William, of Louthe, glover 2
3681790 1920405 1920405 plaintiff Spencer John   589461 589461 Spencer, John, of Louthe 0
3682277 1920554 1920554 defendant Allerton Isabel widow 589461 589461 Allerton, Isabel, of Louthe, widow 3
3709323 1929212 1929212 defendant Horne Robert (legal representative) 589461 589461 Horne, Robert, of Louthe, smith, executors of 3
3711651 1929955 1929955 defendant Kyrke Thomas chaplain 589461 589461 Kyrke, Thomas, of Louthe, chaplain 0
3711653 1929956 1929956 defendant Kyrke Thomas chaplain 589461 589461 Kyrke, Thomas, of Louthe, chaplain 0
3711655 1929957 1929957 defendant Maltby Simon chaplain 589461 589461 Maltby, Simon, of Louthe, chaplain 0
3726597 1934577 1934577 defendant Maltby Simon chaplain 589461 589461 Maltby, Simon, of Louthe, chaplain 0
3729140 1935363 1935363 defendant Lyncoln William merchant 589461 589461 Lyncoln, William, of Louthe, merchant 0
3729856 1935596 1935596 plaintiff Beverley Robert (legal representative) 589461 589461 Beverley, Robert, of Louthe, mercer, executor of 0
3751791 1942481 1942481 plaintiff Parranell John yeoman 589461 589461 Parranell, John, of Louthe, yeoman 0
3757055 1944188 1944188 defendant Browne Robert yeoman 589461 589461 Browne, Robert, of Louthe, yeoman 0
3773429 1949401 1949401 defendant Tymson Henry laborer 589461 589461 Tymson, Henry, of Louthe, laborer 2
3773457 1949411 1949411 defendant Hert William butcher 589461 589461 Hert, William, of Louthe, butcher 0
3776234 1950313 1950313 defendant Newcom Richard tanner 589461 589461 Newcom, Richard, of Louthe, tanner 0
3776236 1950314 1950314 defendant Newton Richard tanner 589461 589461 Newton, Richard, of Louthe, tanner 0
3796481 1956770 1956770 defendant Otter Robert   589461 589461 Otter, Robert, of Louthe, cartwright 1
3803621 1959046 1959046 defendant Dighton Robert tailor 589461 589461 Dighton, Robert, of Louthe, tailor 0
3806301 1959887 1959887 defendant Dyttesley John miller 589461 589461 Dyttesley, John, of Louthe, miller 0
3808938 1960675 1960675 defendant Browne Robert yeoman 589461 589461 Browne, Robert, of Louthe, yeoman 0
3826220 1966048 1966048 defendant Holdernes John butcher 589461 589461 Holdernes, John, of Louthe, butcher 0
3826631 1966177 1966177 plaintiff Barnard William (legal representative) 589461 589461 Barnard, William, of Louthe, butcher, executors of 0
3827717 1966535 1966535 plaintiff Broune William miller 589461 589461 Broune, William, of Louthe, miller 0
3828233 1966700 1966700 defendant Burton Richard butcher 589461 589461 Burton, Richard, of Louthe, butcher 0
3831632 1967789 1967789 defendant Larmeth John glover 589461 589461 Larmeth, John, of Louthe, glover 0
3832267 1968007 1968007 defendant Burton Richard butcher 589461 589461 Burton, Richard, of Louthe, butcher 0
3834479 1968729 1968729 defendant Thomson William laborer 589461 589461 Thomson, William, of Louthe, laborer 0
3844903 1971949 1971949 plaintiff Doughty Robert   589461 589461 Doughty, Robert, of Louthe 0
3864761 1978409 1978409 defendant Beverley Richard mercer 589461 589461 Beverley, Richard, of Louthe, mercer 0
3872223 1980938 1980938 defendant Clatercotys Richard butcher 589461 589461 Clatercotys, Richard, of Louthe, butcher 2
3879789 1983494 1983494 defendant Neuton William glover 589461 589461 Neuton, William, of Louthe, glover 0
3879791 1983495 1983495 defendant Nuton Thomas laborer 589461 589461 Nuton, Thomas, of Louthe, laborer 0
3883056 1984598 1984598 defendant Newcombe Joan widow 589461 589461 Newcombe, Joan, of Louthe, widow 1
3883057 1984598 1984598 defendant Hebulwhate Christopher tanner 589461 589461 Hebulwhate, Christopher, of Louthe, tanner 2
3883058 1984598 1984598 defendant Paige Ralph husbandman 589461 589461 Paige, Ralph, of Louthe, husbandman 3
3890408 1987048 1987048 defendant Michelson Alexander tanner 589461 589461 Michelson, Alexander, of Louthe, tanner 0
3890409 1987048 1987048 defendant Bowman Roger tailor 589461 589461 Bowman, Roger, of Louthe, tailor 1
3890410 1987048 1987048 defendant Broune William barber 589461 589461 Broune, William, of Louthe, barber 2
3899191 1989935 1989935 defendant Etton John esq 589461 589461 Etton, John, of Louthe, esq 0
3901609 1990764 1990764 defendant Polson Thomas yeoman 589461 589461 Polson, Thomas, of Louthe, yeoman 0
3902619 1991108 1991108 defendant Etton John esq 589461 589461 Etton, John, of Louthe, esq 0
3903814 1991508 1991508 defendant Bell William butcher 589461 589461 Bell, William, of Louthe, butcher 0
3916847 1996000 1996000 defendant Kytchyn Thomas yeoman 589461 589461 Kytchyn, Thomas, of Louthe, yeoman 1
3922309 1997775 1997775 defendant Sutton George currier 589461 589461 Sutton, George, of Louthe, currier 0
3922310 1997775 1997775 defendant Ferron William dyer 589461 589461 Ferron, William, of Louthe, dyer 1
3922961 1997987 1997987 defendant Draper Thomas draper 589461 589461 Draper, Thomas, of Louthe, draper 0
3923579 1998194 1998194 defendant Hall John butcher 589461 589461 Hall, John, of Louthe, butcher 0
3923580 1998194 1998194 defendant Martyndale Thomas butcher 589461 589461 Martyndale, Thomas, of Louthe, butcher 1
3923583 1998195 1998195 defendant Fulwood George weaver 589461 589461 Fulwood, George, of Louthe, weaver 1
3928442 1999851 1999851 defendant Lyell William tinker 589461 589461 Lyell, William, of Louthe, tinker 0
3938623 2003261 2003261 defendant Spencer Robert draper 589461 589461 Spencer, Robert, of Louthe, draper 0
3942675 2004557 2004557 plaintiff Wright Richard yeoman 589461 589461 Wright, Richard, of Louthe, yeoman 0
3950911 2007384 2007384 plaintiff Goodall John   589461 589461 Goodall, John, of Louthe 0
3960455 2010755 2010755 defendant Crathorne John gent 589461 589461 Crathorne, John, of Louthe, gent 0
3965918 2012698 2012698 defendant Barnard William butcher or drover 589461 589461 Barnard, William, of Louthe, butcher or drover 0
3966800 2013024 2013024 defendant Stampe Thomas husbandman 589461 589461 Stampe, Thomas, of Louthe, husbandman 1
3966801 2013024 2013024 defendant Martyndale Thomas husbandman 589461 589461 Martyndale, Thomas, of Louthe, husbandman 2
3969327 2013875 2013875 defendant Jones John gent 589461 589461 Jones, John, of Louthe, or of Bowmarys, Anglesey, gent 0
3972591 2014991 2014991 plaintiff Gascoigne John esq 589461 589461 Gascoigne, John, of Louthe, esq 0
3990629 2021401 2021401 plaintiff Blancharde Gilbert mercer 589461 589461 Blancharde, Gilbert, of Louthe, mercer 0
3991241 2021630 2021630 plaintiff Bradley John merchant 589461 589461 Bradley, John, of Louthe, gent, merchant 0
3993559 2022441 2022441 plaintiff Chapman Robert gent 589461 589461 Chapman, Robert, of Louthe, or of Lincoln, gent 0
3994064 2022626 2022626 defendant Vallance Henry glover 589461 589461 Vallance, Henry, of Louthe, glover 0
3994087 2022635 2022635 defendant Vallance Henry glover 589461 589461 Vallance, Henry, of Louthe, glover 0
4003051 2025856 2025856 plaintiff Holdernes Thomas yeoman 589461 589461 Holdernes, Thomas, of Louthe, yeoman 0
4003052 2025856 2025856 plaintiff Bucke Stephen yeoman 589461 589461 Bucke, Stephen, of Louthe, yeoman 1
4003053 2025856 2025856 plaintiff Wryght Richard yeoman 589461 589461 Wryght, Richard, of Louthe, yeoman 2
4007216 2027360 2027360 plaintiff Mackareth Margaret widow 589461 589461 Mackareth, Margaret, of Louthe, widow 0
4010405 2028492 2028492 defendant Joyes Thomas currier 589461 589461 Joyes, Thomas, of Louthe, or of Lincoln, currier 0
4016443 2030586 2030586 plaintiff Story Richard glasier 589461 589461 Story, Richard, of Louthe, glasier 0
4016964 2030768 2030768 defendant Evans William yeoman 589461 589461 Evans, William, of Louthe, yeoman 0
4036541 2037753 2037753 plaintiff Northe Thomas mercer 589461 589461 Northe, Thomas, of Louthe, mercer 1
4037414 2038041 2038041 defendant Craythorn Robert gent 589461 589461 Craythorn, Robert, of Louthe, gent 0
4046646 2041253 2041253 plaintiff Smyth Thomas butcher 589461 589461 Smyth, Thomas, of Louthe, butcher 0
4057170 2044949 2044949 defendant Wake Thomas chandler 589461 589461 Wake, Thomas, of Louthe, chandler 0
4058199 2045315 2045315 defendant Raythby William tailor 589461 589461 Raythby, William, of Louthe, tailor 0
4058399 2045389 2045389 defendant Whyte William gent 589461 589461 Whyte, William, of Louthe, gent 3
4059553 2045809 2045809 defendant Caystrop Thomas yeoman 589461 589461 Caystrop, Thomas, of Louthe, yeoman 0
4060242 2046063 2046063 defendant Hyll John yeoman 589461 589461 Hyll, John, of Louthe, yeoman 6
4060250 2046064 2046064 defendant Hyll John yeoman 589461 589461 Hyll, John, of Louthe, yeoman 6

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