names

249 rows where place_id = 597513

✎ 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
3628882 1903909 1903909 defendant Smyth John baker 597513 597513 Smyth, John, of Andover, baker 0
3640075 1907342 1907342 defendant Clement John baker 597513 597513 Clement, John, of Andover, baker 4
3649195 1910138 1910138 defendant Clement John tanner or baker 597513 597513 Clement, John, of Andover, tanner or baker 0
3656032 1912139 1912139 defendant Pynder William chapman 597513 597513 Pynder, William, of Andover, chapman 5
3660210 1913454 1913454 defendant Clement John yeoman 597513 597513 Clement, John, of Andover, yeoman 4
3663573 1914537 1914537 defendant Specott Richard yeoman 597513 597513 Specott, Richard, of Andover, yeoman 0
3671364 1917020 1917020 defendant Brown Edward mercer 597513 597513 Brown, Edward, of Andover, mercer 0
3674048 1917924 1917924 defendant Parram John husbandman 597513 597513 Parram, John, of Andover, husbandman 0
3677671 1919060 1919060 defendant Brownsmyth John clerk 597513 597513 Brownsmyth, John, of Andover, clerk 0
3690210 1923097 1923097 defendant Cle- John chapman 597513 597513 Cle-, John, of Andover, chapman 1
3718782 1932154 1932154 defendant Haston Thomas miller 597513 597513 Haston, Thomas, of Andover, miller 0
3718783 1932154 1932154 defendant Wygge Thomas husbandman 597513 597513 Wygge, Thomas, of Andover, husbandman 1
3719663 1932416 1932416 defendant Smyth John baker 597513 597513 Smyth, John, of Andover, baker 0
3726804 1934650 1934650 defendant Howton John husbandman 597513 597513 Howton, John, of Andover, husbandman 0
3739690 1938626 1938626 defendant Dollyng John husbandman 597513 597513 Dollyng, John, of Andover, husbandman 0
3739691 1938626 1938626 defendant Brekeston Richard butcher 597513 597513 Brekeston, Richard, of Andover, butcher 1
3789379 1954500 1954500 defendant Chamber Edward innholder 597513 597513 Chamber, Edward, of Andover, innholder 0
3799766 1957847 1957847 defendant Saunders Richard yeoman 597513 597513 Saunders, Richard, of Andover, yeoman 0
3837449 1969620 1969620 defendant Dene Robert chaplain 597513 597513 Dene, Robert, of Andover, chaplain 0
3849222 1973350 1973350 defendant Gylbard Richard chapman 597513 597513 Gylbard, Richard, of Andover, chapman 3
3864346 1978271 1978271 defendant Pynner Richard chapman 597513 597513 Pynner, Richard,of Andover, chapman 0
3864351 1978273 1978273 defendant Warton Adam chapman 597513 597513 Warton, Adam, of Andover, chapman 0
3864352 1978273 1978273 defendant Gylbard Richard chapman 597513 597513 Gylbard, Richard, of Andover, chapman 1
3878132 1982935 1982935 defendant Garlond Hugh butcher 597513 597513 Garlond, Hugh, of Andover, butcher 0
3878425 1983030 1983030 defendant Warton Adam chapman 597513 597513 Warton, Adam, of Andover, chapman 0
3878426 1983030 1983030 defendant Gyldbard Richard chapman 597513 597513 Gyldbard, Richard, of Andover, chapman 1
3903077 1991258 1991258 defendant Wygmore Thomas husbandman 597513 597513 Wygmore, Thomas, of Andover, husbandman 0
3905438 1992088 1992088 defendant Woodward William yeoman 597513 597513 Woodward, William, of Andover, yeoman 0
3908869 1993257 1993257 defendant Heywod William painter 597513 597513 Heywod, William, of Andover, painter 0
3909974 1993643 1993643 plaintiff Stollard Edmund   597513 597513 Stollard, Edmund, of Andover 0
3913836 1994973 1994973 defendant Heywood William painter 597513 597513 Heywood, William, of Andover, painter 0
3918490 1996515 1996515 defendant Brecston John butcher 597513 597513 Brecston, John, of Andover, butcher 0
3918491 1996515 1996515 defendant Brecston William butcher 597513 597513 Brecston, William, of Andover, butcher 1
3918492 1996515 1996515 defendant Baker William butcher 597513 597513 Baker, William, of Andover, butcher 2
3932784 2001269 2001269 defendant Edyes Richard yeoman 597513 597513 Edyes, Richard, of Andover, yeoman 0
3936992 2002703 2002703 plaintiff Muddyll Alexander yeoman 597513 597513 Muddyll, Alexander, of Andover, yeoman 0
3950002 2007082 2007082 defendant Payne Anthony mercer 597513 597513 Payne, Anthony, of Andover, mercer 1
3952978 2008109 2008109 defendant Pynder Robert tailor 597513 597513 Pynder, Robert, of Andover, tailor 1
4011200 2028778 2028778 plaintiff Peterson John mercer 597513 597513 Peterson, John, of Andover, mercer 0
4020260 2031966 2031966 defendant Morrell Richard yeoman 597513 597513 Morrell, Richard, of Andover, yeoman 1
4025732 2033856 2033856 plaintiff Browne William gent 597513 597513 Browne, William, of Andover, gent 0
4091578 2057278 2057278 defendant Blounte Edward gent 597513 597513 Blounte, Edward, of Andover, gent 1
4215544 2100934 2100934 defendant London Richard hatter 597513 597513 London, Richard, of Andover, hatter 0
4267023 2118612 2118612 defendant Blake Robert gent 597513 597513 Blake, Robert, of Andover, or of Lyttle Bedwyn, Wilts, gent 0
4279261 2122676 2122676 defendant Smythe John gent 597513 597513 Smythe, John, of Andover, gent 1
4289260 2126216 2126216 defendant Knyght John yeoman 597513 597513 Knyght, John, of Andover, yeoman 0
4352979 2148271 2148271 defendant Julians Christopher shoemaker 597513 597513 Julians, Christopher, of Andover, shoemaker 0
4427331 2173383 2173383 defendant Eode John merchant 597513 597513 Eode, John, of Andover, merchant 0
4430041 2174181 2174181 defendant Yve John merchant 597513 597513 Yve, John, of Andover, merchant 0
4436217 2176069 2176069 defendant Foul Robert merchant 597513 597513 Foul, Robert, of Andover, merchant 1
4436218 2176069 2176069 defendant Kyngeston William de   597513 597513 Kyngeston, William de, of Andover 2
4436219 2176069 2176069 defendant Hariel Bartholomew de   597513 597513 Hariel, Bartholomew de, of Andover 3
4459701 2188090 2188090 plaintiff Sand John   597513 597513 Sand, John, of Andover 0
4459710 2188092 2188092 plaintiff atte Mersshe John   597513 597513 atte Mersshe, John, of Andover 2
4466824 2190295 2190295 defendant Hurst John   597513 597513 (Hurst, John, of Andover 1
4472068 2191930 2191930 defendant Hyndene William   597513 597513 Hyndene, William, of Andover 0
4485290 2196103 2196103 plaintiff Pyke John   597513 597513 Pyke, John, of Andover 0
4486074 2196350 2196350 defendant Braye Nicholas   597513 597513 Braye, Nicholas, of Andover 0
4490134 2197634 2197634 plaintiff Veel Helen   597513 597513 Veel, Helen, of Andover, formerly wife of Peter Veel 0
4490135 2197634 2197634 defendant Lytelsmyth John   597513 597513 Lytelsmyth, John, of Andover 0
4495215 2199186 2199186 defendant Shorrorre William   597513 597513 Shorrorre, William, of Andover 2
4510595 2203775 2203775 defendant Huchon John   597513 597513 Huchon, John, of Andover 4
4510602 2203776 2203776 defendant Huthon John   597513 597513 Huthon, John, of Andover 4
4533377 2210705 2210705 defendant Hurst John   597513 597513 Hurst, John, of Andover 0
4543521 2213863 2213863 plaintiff atte Mersshe John   597513 597513 atte Mersshe, John, of Andover 0
4543522 2213863 2213863 defendant Pryketot Walter   597513 597513 Pryketot, Walter, of Andover, millward 0
4549424 2215766 2215766 defendant Wyse John tailor 597513 597513 Wyse, John, of Andover, tailor 0
4553588 2217051 2217051 defendant Hosteler Simon   597513 597513 Hosteler, Simon, of Andover 1
4553595 2217052 2217052 defendant Hosteler Simon   597513 597513 Hosteler, Simon, of Andover 1
4566511 2221094 2221094 defendant atte Watere Nicholas   597513 597513 atte Watere, Nicholas, of Andover 0
4566677 2221152 2221152 defendant Langeden John   597513 597513 Langeden, John, of Andover 0
4572624 2222974 2222974 defendant Bukerputte William   597513 597513 Bukerputte, William, of Andover 0
4579159 2224965 2224965 defendant Clerk John   597513 597513 Clerk, John, of Andover 2
4595001 2229693 2229693 defendant Bennebury Ralph   597513 597513 Bennebury, Ralph, of Andover 0
4597527 2230472 2230472 plaintiff Shopper Andrew   597513 597513 Shopper, Andrew, of Andover 0
4604877 2232695 2232695 defendant Bailly John   597513 597513 Bailly, John, of Andover 2
4610181 2234266 2234266 plaintiff Canon John   597513 597513 Canon, John, of Andover, vicar 0
4610182 2234266 2234266 defendant Pouchemaker Richard   597513 597513 Pouchemaker, Richard, of Andover 0
4622165 2237910 2237910 defendant Pleywell John   597513 597513 Pleywell, John, of Andover 0
4628721 2239908 2239908 defendant Tylie Thomas   597513 597513 Tylie, Thomas, of Andover 0
4634735 2241717 2241717 defendant Bruton Walter   597513 597513 Bruton, Walter, of Andover 0
4634736 2241717 2241717 defendant Seriaunt John   597513 597513 Seriaunt, John, of Andover 1
4634737 2241717 2241717 defendant Bailly Roger   597513 597513 Bailly, Roger, of Andover 2
4636776 2242319 2242319 defendant Hosyer Thomas   597513 597513 Hosyer, Thomas, of Andover 5
4680469 2259505 2259505 defendant Melbury John   597513 597513 Melbury, John, of Andover 0
4680867 2259637 2259637 defendant Breche William husbandman 597513 597513 Breche, William, of Andover, husbandman 0
4706371 2267375 2267375 defendant Stacy Joan widow 597513 597513 Stacy, Joan, of Andover, widow 1
4706373 2267376 2267376 defendant Smyrt James smith 597513 597513 Smyrt, James, of Andover, smith 0
4706476 2267405 2267405 defendant Bank Walter   597513 597513 Bank, Walter, of Andover, shoe maker 1
4711194 2268853 2268853 defendant Mower William butcher 597513 597513 Mower, William, of Andover, butcher 0
4711202 2268855 2268855 defendant Payn Thomas   597513 597513 Payn, Thomas, of Andover, franklin 4
4713971 2269698 2269698 defendant Robus John tailor 597513 597513 Robus, John, of Andover, tailor 1
4716582 2270505 2270505 defendant Rige Peter husbandman 597513 597513 Rige, Peter, of Andover, husbandman 0
4716585 2270505 2270505 defendant Lylye Robert husbandman 597513 597513 Lylye, Robert, of Andover, husbandman 3
4718071 2270993 2270993 defendant Lilye Robert   597513 597513 Lilye, Robert, of Andover 2
4725984 2273413 2273413 defendant Sondes Walter   597513 597513 Sondes, Walter, of Andover, knight 0
4730043 2274597 2274597 defendant Smyrt James smith 597513 597513 Smyrt, James, of Andover, smith 0
4731665 2275098 2275098 defendant Bodecote John husbandman 597513 597513 Bodecote, John, of Andover, husbandman 0
4732560 2275359 2275359 plaintiff Dolyn John   597513 597513 Dolyn, John, of Andover, bailiff 1
4732561 2275359 2275359 defendant Lylye Robert draper 597513 597513 Lylye, Robert, of Andover, draper 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);