names

260 rows where place_id = 593694

✎ 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
3594372 1865872 1865872 defendant Smyth John (legal representative) 593694 593694 Smyth, John, of Andever, mercer, executrix of 0
3612978 1871707 1871707 defendant Chapman William dyer 593694 593694 Chapman, William, of Andever, dyer 0
3627834 1903564 1903564 defendant Clement John tanner 593694 593694 Clement, John, of Andever, tanner 0
3629485 1904076 1904076 defendant Dregge John fuller 593694 593694 Dregge, John, of Andever, fuller 0
3634569 1905615 1905615 defendant Smyth John chapman 593694 593694 Smyth, John, of Andever, chapman 0
3645533 1909000 1909000 defendant Wilson alias Tailour Thomas tailor 593694 593694 Wilson alias Tailour, Thomas, of Andever, tailor 0
3650843 1910628 1910628 defendant Harman John husbandman 593694 593694 Harman, John, of Andever, husbandman 1
3681382 1920263 1920263 defendant Rawley John gent 593694 593694 Rawley, John, of Andever, gent 0
3681383 1920263 1920263 defendant Alred Thomas, junior yeoman 593694 593694 Alred, Thomas, junior, of Andever, yeoman 1
3681713 1920378 1920378 defendant Parram John husbandman 593694 593694 Parram, John, of Andever, husbandman 0
3700549 1926414 1926414 defendant Smyth John baker 593694 593694 Smyth, John, of Andever, baker 0
3701120 1926598 1926598 defendant Anford James shoemaker 593694 593694 Anford, James, of Andever, shoemaker 0
3701121 1926598 1926598 defendant Alred Thomas husbandman 593694 593694 Alred, Thomas, of Andever, husbandman 1
3723637 1933667 1933667 defendant Clement John tanner 593694 593694 Clement, John, of Andever, tanner 0
3738599 1938280 1938280 defendant Lekes Thomas   593694 593694 Lekes, Thomas, of Andever, tanner, son of Lekes, William 0
3764597 1946585 1946585 defendant Kenester Robert yeoman 593694 593694 Kenester, Robert, of Andever, yeoman 0
3782583 1952295 1952295 defendant Kenester Robert yeoman 593694 593694 Kenester, Robert, of Andever, yeoman 0
3786073 1953435 1953435 defendant Long Lawrence yeoman 593694 593694 Long, Lawrence, of Andever, yeoman 0
3797950 1957256 1957256 defendant Brekeston Richard butcher 593694 593694 Brekeston, Richard, of Andever, butcher 0
3829677 1967173 1967173 defendant Gunter Joan widow 593694 593694 Gunter, Joan, of Andever, widow 0
3829678 1967173 1967173 defendant Kyne Nicholas husbandman 593694 593694 Kyne, Nicholas, of Andever, husbandman 1
3829680 1967174 1967174 defendant Gunter Joan widow 593694 593694 Gunter, Joan, of Andever, widow 0
3829681 1967174 1967174 defendant Kyne Nicholas husbandman 593694 593694 Kyne, Nicholas, of Andever, husbandman 1
3834263 1968660 1968660 defendant Gylbard Richard mercer 593694 593694 Gylbard, Richard, of Andever, mercer 0
3834265 1968661 1968661 defendant Pynder William mercer 593694 593694 Pynder, William, of Andever, mercer 0
3834267 1968662 1968662 defendant Pynder William mercer 593694 593694 Pynder, William, of Andever, mercer 0
3834269 1968663 1968663 defendant Gilbard Richard mercer 593694 593694 Gilbard, Richard, of Andever, mercer 0
3836908 1969446 1969446 defendant Rythe Thomas mercer 593694 593694 Rythe, Thomas, of Andever, mercer 0
3852921 1974531 1974531 defendant Rythe Thomas mercer 593694 593694 Rythe, Thomas, of Andever, mercer 0
3852923 1974532 1974532 defendant Ryve Thomas mercer 593694 593694 Ryve, Thomas, of Andever, mercer 0
3853871 1974844 1974844 defendant Reve Thomas mercer 593694 593694 Reve, Thomas, of Andever, mercer 0
3868286 1979633 1979633 defendant Reve Thomas mercer 593694 593694 Reve, Thomas, of Andever, mercer 0
3868288 1979634 1979634 defendant Reve Thomas mercer 593694 593694 Reve, Thomas, of Andever, mercer 0
3878134 1982936 1982936 defendant Kegyll Robert fuller 593694 593694 Kegyll, Robert, of Andever, fuller 0
3880299 1983664 1983664 defendant Rowland Richard innholder 593694 593694 Rowland, Richard, of Andever, innholder 0
3882580 1984436 1984436 defendant Kegyll Robert fuller 593694 593694 Kegyll, Robert, of Andever, fuller 0
3883441 1984732 1984732 defendant Browne alias Bocher Thomas butcher 593694 593694 Browne alias Bocher, Thomas, of Andever, butcher 0
3883839 1984863 1984863 defendant Frankelyn alias Patryke Thomas tailor 593694 593694 Frankelyn alias Patryke, Thomas, of Andever, tailor 0
3894825 1988474 1988474 defendant Inwoode Peter husbandman 593694 593694 Inwoode, Peter, of Andever, husbandman 2
3895121 1988580 1988580 defendant Gilbert Richard miller 593694 593694 Gilbert, Richard, of Andever, miller 0
3912467 1994498 1994498 defendant Inwood William tanner 593694 593694 Inwood, William, of Andever, tanner 0
3925390 1998807 1998807 plaintiff Whyte William (legal representative) 593694 593694 Whyte, William, of Andever, butcher, executor of 0
3943926 2004987 2004987 plaintiff Backhowse Robert yeoman 593694 593694 Backhowse, Robert, of Andever, yeoman 0
3943928 2004988 2004988 plaintiff Backhowse Robert yeoman 593694 593694 Backhowse, Robert, of Andever, yeoman 0
3949988 2007076 2007076 plaintiff Fleytwoode Agnes widow 593694 593694 Fleytwoode, Agnes, of Andever, widow 0
3949989 2007076 2007076 defendant Mudle Alexander yeoman 593694 593694 Mudle, Alexander, of Andever, yeoman 0
3958603 2010081 2010081 defendant Franckelyn Thomas (legal representative) 593694 593694 Franckelyn, Thomas, of Andever, draper, administrator of 0
3960241 2010679 2010679 defendant Kyngesfelde Edmund yeoman 593694 593694 Kyngesfelde, Edmund, of Andever, yeoman 2
3972160 2014824 2014824 defendant Marten Edmund chapman 593694 593694 Marten, Edmund, of Andever, chapman 1
3973872 2015429 2015429 defendant Warder Nicholas chapman 593694 593694 Warder, Nicholas, of Andever, chapman 1
3978842 2017182 2017182 plaintiff Morell Richard innholder 593694 593694 Morell, Richard, of Andever, innholder 0
3979048 2017259 2017259 defendant Hopkyns William (legal representative) 593694 593694 Hopkyns, William, of Andever, glover, executrix of 0
3979049 2017259 2017259 defendant Hopkyns Alice widow 593694 593694 Hopkyns, Alice, of Andever, widow 1
3983849 2018994 2018994 defendant Browne Thomas butcher 593694 593694 Browne, Thomas, of Andever, butcher 0
3992662 2022125 2022125 plaintiff Butler Stephen tapster 593694 593694 Butler, Stephen, of Andever, tapster 0
4003586 2026045 2026045 defendant Longe Jasper chapman 593694 593694 Longe, Jasper, of Andever, chapman 2
4070383 2049705 2049705 plaintiff Martin William yeoman 593694 593694 Martin, William, of Andever, yeoman 0
4112824 2064852 2064852 defendant Knighte John gent 593694 593694 Knighte, John, of Andever, gent 0
4112825 2064852 2064852 defendant Childe Thomas yeoman 593694 593694 Childe, Thomas, of Andever, yeoman 1
4127879 2070260 2070260 defendant Bant William husbandman 593694 593694 Bant, William, of Andever, yeoman, or of Somerton, Highworth, Wilts, husbandman 0
4140739 2074928 2074928 defendant Abbatt John   593694 593694 Abbatt, John, of Andever, Hants draper 0
4142252 2075466 2075466 defendant Childe Thomas, junior chapman 593694 593694 Childe, Thomas, junior, of Andever, chapman 1
4234699 2107683 2107683 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4235024 2107801 2107801 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4236083 2108190 2108190 defendant Battyn John husbandman 593694 593694 Battyn, John, of Andever, or of Beminster Dorset, husbandman 0
4236084 2108190 2108190 defendant Child Henry gent 593694 593694 Child, Henry, of Andever, or of Mylton, Dorset, gent 1
4236085 2108190 2108190 defendant Mead John yeoman 593694 593694 Mead, John, of Andever, yeoman 2
4236191 2108227 2108227 defendant Knyghte John gent 593694 593694 Knyghte, John, of Andever, gent 0
4237268 2108622 2108622 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4238533 2109091 2109091 defendant Ashelye William saddler 593694 593694 Ashelye, William, of Andever, saddler 0
4266760 2118523 2118523 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4266991 2118601 2118601 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4268503 2119067 2119067 defendant Battyn John husbandman 593694 593694 Battyn, John, of Andever, or of Beaminster, Dorset, husbandman 0
4268504 2119067 2119067 defendant Child Henry gent 593694 593694 Child, Henry, of Andever, or of Milton, gent 1
4268505 2119067 2119067 defendant Meade John yeoman 593694 593694 Meade, John, of Andever, yeoman 2
4270250 2119634 2119634 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4274825 2121141 2121141 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4277622 2122095 2122095 defendant Jarvis Benjamin fellmonger 593694 593694 Jarvis, Benjamin, of Andever, fellmonger 0
4279260 2122676 2122676 defendant Knyght John gent 593694 593694 Knyght, John, of Andever, gent 0
4279360 2122706 2122706 defendant Jarvys Richard chapman 593694 593694 Jarvys, Richard, of Andever, chapman 0
4295417 2128448 2128448 defendant Abbatt Thomas barber surgeon 593694 593694 Abbatt, Thomas, of Andever, barber surgeon 1
4297860 2129340 2129340 defendant Knyght John yeoman 593694 593694 Knyght, John, of Andever, yeoman 0
4304743 2131793 2131793 defendant Knight John gent 593694 593694 Knight, John, of Andever, gent 0
4310671 2133877 2133877 defendant Uvedall William gent 593694 593694 Uvedall, William, of Andever, or of Chingford, Essex, gent 0
4310672 2133877 2133877 defendant Mate Ralph gent 593694 593694 Mate, Ralph, of Andever, or of Hatfeild Peverell, Essex, gent 1
4312282 2134431 2134431 defendant Cooke Robert gent 593694 593694 Cooke, Robert, of Andever, gent 0
4312548 2134523 2134523 defendant Knighte John gent 593694 593694 Knighte, John, of Andever, gent 0
4312549 2134523 2134523 defendant Childe Thomas, junior haberdasher 593694 593694 Childe, Thomas, junior, of Andever, haberdasher 1
4313223 2134736 2134736 defendant Hayne William husbandman 593694 593694 Hayne, William, of Andever, or of West Sheford, Berks, husbandman 0
4314870 2135315 2135315 defendant Knighte John gent 593694 593694 Knighte, John, of Andever, gent 0
4318532 2136595 2136595 defendant Ayres Richard clothier 593694 593694 Ayres, Richard, of Andever, clothier 0
4318533 2136595 2136595 defendant Ayres William clothier 593694 593694 Ayres, William, of Andever, clothier 1
4320643 2137311 2137311 defendant Hayes Edward gent 593694 593694 Hayes, Edward, of Andever, or of Retingden, Essex, gent 0
4322086 2137805 2137805 defendant Mortymore John husbandman 593694 593694 Mortymore, John, of Andever, or of River, Shalborne, Berks, husbandman 0
4327644 2139566 2139566 defendant Abbatt Thomas barber surgeon 593694 593694 Abbatt, Thomas, of Andever, barber surgeon 1
4333809 2141589 2141589 defendant Jarvys Richard, junior chapman 593694 593694 Jarvys, Richard, junior, of Andever, chapman 2
4353077 2148304 2148304 defendant Browne Richard yeoman 593694 593694 Browne, Richard, of Andever, yeoman 0
4359820 2150675 2150675 defendant Curteys Thomas shoemaker 593694 593694 Curteys, Thomas, of Andever, shoemaker 0
4367404 2153394 2153394 defendant Jarvis Richard, senior chapman 593694 593694 Jarvis, Richard, senior, of Andever, chapman 0
4367405 2153394 2153394 defendant Jarvis Richard, junior chapman 593694 593694 Jarvis, Richard, junior, of Andever, chapman 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);