names

359 rows where place_id = 588489

✎ 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
3594671 1865963 1865963 defendant Aleyn Robert husbandman 588489 588489 Aleyn, Robert, of Melton, husbandman 1
3594763 1865986 1865986 defendant Davy Thomas yeoman 588489 588489 Davy, Thomas, of Melton, yeoman 0
3598654 1867202 1867202 defendant Alyn Robert shipman 588489 588489 Alyn, Robert, of Melton, shipman 1
3603070 1868626 1868626 defendant Balhed Richard husbandman 588489 588489 Balhed, Richard, of Melton, husbandman 3
3639236 1907083 1907083 defendant Gylden Richard husbandman 588489 588489 Gylden, Richard, of Melton, husbandman 2
3646868 1909419 1909419 defendant Fynley alias Hynle John roper 588489 588489 Fynley alias Hynle, John, of Melton, roper 0
3663921 1914657 1914657 defendant Porter Robert glover 588489 588489 Porter, Robert, of Melton, glover 0
3696550 1925152 1925152 plaintiff Sharpe Richard   588489 588489 Sharpe, Richard, of Melton 0
3698832 1925853 1925853 defendant Gylberd John fisher 588489 588489 Gylberd, John, of Melton, fisher 1
3762118 1945793 1945793 defendant Palmer William husbandman 588489 588489 Palmer, William, of Melton, husbandman 0
3763994 1946380 1946380 defendant Downes Thomas gent 588489 588489 Downes, Thomas, of Melton, gent 0
3774576 1949773 1949773 defendant Seyle Thomas butcher 588489 588489 Seyle, Thomas, of Melton, butcher 1
3775886 1950210 1950210 defendant Pynchard John laborer 588489 588489 Pynchard, John, of Melton, laborer 0
3777521 1950721 1950721 defendant Stephens William husbandman 588489 588489 Stephens, William, of Melton, husbandman 0
3781729 1952032 1952032 plaintiff Haynoll alias Hayne Henry merchant 588489 588489 Haynoll alias Hayne, Henry, of Melton, merchant 0
3785167 1953150 1953150 defendant Topper William laborer 588489 588489 Topper, William, of Melton, laborer 0
3796104 1956646 1956646 defendant Heyward Philip   588489 588489 Heyward, Philip, of Melton, wheel wright 0
3802089 1958549 1958549 defendant Tetford Henry gent 588489 588489 Tetford, Henry, of Melton, gent 1
3802090 1958549 1958549 defendant Ketmay Thomas husbandman 588489 588489 Ketmay, Thomas, of Melton, husbandman 2
3802091 1958549 1958549 defendant Ketmay Robert husbandman 588489 588489 Ketmay, Robert, of Melton, husbandman 3
3802092 1958549 1958549 defendant Bloke Robert husbandman 588489 588489 Bloke, Robert, of Melton, husbandman 4
3810407 1961145 1961145 defendant Man John tailor 588489 588489 Man, John, of Melton, tailor 0
3819858 1964092 1964092 defendant Payken Robert laborer 588489 588489 Payken, Robert, of Melton, laborer 2
3835076 1968910 1968910 defendant Spencer William husbandman 588489 588489 Spencer, William, of Melton, husbandman 4
3856997 1975822 1975822 defendant Canne Nicholas husbandman 588489 588489 Canne, Nicholas, of Melton, husbandman 0
3857988 1976146 1976146 plaintiff Fowle Robert yeoman 588489 588489 Fowle, Robert, of Melton, yeoman 2
3882742 1984491 1984491 defendant Godwyn Philip husbandman 588489 588489 Godwyn, Philip, of Melton, husbandman 0
3888919 1986537 1986537 defendant Clarke John brickmaker 588489 588489 Clarke, John, of Melton, brickmaker 2
3895247 1988618 1988618 defendant Clerke Robert husbandman 588489 588489 Clerke, Robert, of Melton, husbandman 2
3897990 1989534 1989534 defendant Hodson John clerk 588489 588489 Hodson, John, of Melton, clerk 0
3897995 1989535 1989535 defendant Hodson John clerk 588489 588489 Hodson, John, of Melton, clerk 0
3903656 1991455 1991455 defendant Raven Thomas   588489 588489 Raven, Thomas, of Melton, wheelwright 0
3903658 1991455 1991455 defendant Lusse Henry husbandman 588489 588489 Lusse, Henry, of Melton, husbandman 2
3903659 1991455 1991455 defendant Iklyngham James husbandman 588489 588489 Iklyngham, James, of Melton, husbandman 3
3909487 1993474 1993474 defendant Lusse Henry husbandman 588489 588489 Lusse, Henry, of Melton, husbandman 2
3911738 1994252 1994252 defendant Hoys Bartholomew glover 588489 588489 Hoys, Bartholomew, of Melton, glover 1
3911739 1994252 1994252 defendant Grene William barber 588489 588489 Grene, William, of Melton, barber 2
3913027 1994688 1994688 defendant Clarke Robert brickmaker 588489 588489 Clarke, Robert, of Melton, brickmaker 0
3913028 1994688 1994688 defendant Clarke John brickmaker 588489 588489 Clarke, John, of Melton, brickmaker 1
3923309 1998106 1998106 defendant Havens Thomas   588489 588489 Havens, Thomas, of Melton, wheel wright 1
3923437 1998143 1998143 defendant Havyns Thomas   588489 588489 Havyns, Thomas, of Melton, wheelwright 4
3924934 1998657 1998657 defendant Norman Elizabeth widow 588489 588489 Norman, Elizabeth, of Melton, widow 2
3928969 2000026 2000026 defendant Aleyn Henry husbandman 588489 588489 Aleyn, Henry, of Melton, husbandman 1
3934272 2001758 2001758 defendant Austen John husbandman 588489 588489 Austen, John, of Melton, husbandman 0
3954214 2008548 2008548 defendant Hayle William husbandman 588489 588489 Hayle, William, of Melton, husbandman 0
3954669 2008699 2008699 defendant Smythe alias Marshall John husbandman 588489 588489 Smythe alias Marshall, John, of Melton, husbandman 0
3954670 2008699 2008699 defendant Orome alias Mawger George husbandman 588489 588489 Orome alias Mawger, George, of Melton, husbandman 1
3954881 2008775 2008775 plaintiff Lovett William   588489 588489 Lovett, William, of Melton 0
3957455 2009670 2009670 defendant Truston Roger husbandman 588489 588489 Truston, Roger, of Melton, husbandman 1
3957456 2009670 2009670 defendant Ellys Thomas husbandman 588489 588489 Ellys, Thomas, of Melton, husbandman 2
3961170 2011001 2011001 plaintiff Thyrmwood Thomas   588489 588489 Thyrmwood, Thomas, of Melton 0
3975702 2016061 2016061 plaintiff Hyldersham Richard gent 588489 588489 Hyldersham, Richard, of Melton, gent 0
3976489 2016353 2016353 defendant Kynd William husbandman 588489 588489 Kynd, William, of Melton, husbandman 1
4005238 2026653 2026653 defendant Roulde William laborer 588489 588489 Roulde, William, of Melton, laborer 1
4024694 2033512 2033512 plaintiff Bonnar Thomas   588489 588489 Bonnar, Thomas, of Melton 0
4024696 2033513 2033513 plaintiff Bonnar Thomas   588489 588489 Bonnar, Thomas, of Melton 0
4029283 2035117 2035117 defendant Marrytt Geoffrey yeoman 588489 588489 Marrytt, Geoffrey, of Melton, yeoman 0
4030026 2035384 2035384 defendant Baylye Henry husbandman 588489 588489 Baylye, Henry, of Melton, husbandman 0
4046847 2041325 2041325 defendant Skorer Nicholas husbandman 588489 588489 Skorer, Nicholas, of Melton, husbandman 1
4062233 2046783 2046783 defendant Lewes Richard yeoman 588489 588489 Lewes, Richard, of Melton, yeoman 1
4062234 2046783 2046783 defendant Huntar William yeoman 588489 588489 Huntar, William, of Melton, yeoman 2
4077062 2052082 2052082 defendant Fyney Robert tailor 588489 588489 Fyney, Robert, of Melton, tailor 1
4077736 2052330 2052330 defendant Steyward Simeon gent 588489 588489 Steyward, Simeon, of Melton, gent 2
4093731 2058082 2058082 defendant Lewes Richard yeoman 588489 588489 Lewes, Richard, of Melton, yeoman 2
4093732 2058082 2058082 defendant Hunter William yeoman 588489 588489 Hunter, William, of Melton, yeoman 3
4103073 2061389 2061389 defendant Downes Christian widow 588489 588489 Downes, Christian, of Melton, widow 0
4129255 2070762 2070762 defendant Browne Thomas clerk 588489 588489 Browne, Thomas, of Melton, clerk 3
4134889 2072799 2072799 defendant Truston William yeoman 588489 588489 Truston, William, of Melton, yeoman 1
4141567 2075214 2075214 defendant Kynge John husbandman 588489 588489 Kynge, John, of Melton, husbandman 1
4151196 2078542 2078542 defendant Spendlove John husbandman 588489 588489 Spendlove, John, of Melton, husbandman 0
4151197 2078542 2078542 defendant Baylye Henry husbandman 588489 588489 Baylye, Henry, of Melton, husbandman 1
4151198 2078542 2078542 defendant Perry Hugh   588489 588489 Perry, Hugh, of Melton, shepherd 2
4158518 2081048 2081048 defendant Barnes William yeoman 588489 588489 Barnes, William, of Melton, yeoman 0
4165298 2083369 2083369 defendant Downyng William   588489 588489 Downyng, William, of Melton, worsted weaver 0
4167316 2084068 2084068 defendant Turnor William clothier 588489 588489 Turnor, William, of Melton, clothier 0
4186255 2090677 2090677 defendant Dicconson John badger 588489 588489 Dicconson, John, of Melton, badger 0
4186989 2090942 2090942 defendant Brigges William tailor 588489 588489 Brigges, William, of Melton, tailor 0
4190789 2092342 2092342 defendant Turnor William clothier 588489 588489 Turnor, William, of Melton, clothier 0
4206085 2097677 2097677 defendant Wolsey John yeoman 588489 588489 Wolsey, John, of Melton, yeoman 0
4218384 2101930 2101930 defendant Palmer John   588489 588489 Palmer, John, of Melton, yeoman, sailor 0
4218385 2101930 2101930 defendant Gooche John yeoman 588489 588489 Gooche, John, of Melton, yeoman 1
4222892 2103495 2103495 defendant Moriell Stephen blacksmith 588489 588489 Moriell, Stephen, of Melton, blacksmith 2
4224724 2104118 2104118 defendant Gooche John yeoman 588489 588489 Gooche, John, of Melton, yeoman 0
4233982 2107410 2107410 defendant Hayle William tailor 588489 588489 Hayle, William, of Melton, tailor 0
4240629 2109847 2109847 defendant Morrell Stephen blacksmith 588489 588489 Morrell, Stephen, of Melton, blacksmith 0
4262345 2117076 2117076 defendant Hayle William husbandman 588489 588489 Hayle, William, of Melton, husbandman 0
4276683 2121778 2121778 defendant Fynche John yeoman 588489 588489 Fynche, John, of Melton, yeoman 0
4288524 2125946 2125946 defendant Baxter Robert yeoman 588489 588489 Baxter, Robert, of Melton, yeoman 1
4309915 2133624 2133624 defendant Applebie Thomas yeoman 588489 588489 Applebie, Thomas, of Melton, yeoman 0
4324495 2138583 2138583 defendant Sotherton Henry gent 588489 588489 Sotherton, Henry, of Melton, gent 2
4325993 2139067 2139067 defendant Everard Nicholas gent 588489 588489 Everard, Nicholas, of Melton, gent 0
4331859 2140948 2140948 defendant Alldaye Robert husbandman 588489 588489 Alldaye, Robert, of Melton, husbandman 2
4331865 2140949 2140949 defendant Pallant Thomas blacksmith 588489 588489 Pallant, Thomas, of Melton, blacksmith 3
4345380 2145658 2145658 defendant Browne James yeoman 588489 588489 Browne, James, of Melton, yeoman 2
4346191 2145920 2145920 defendant Palmer John   588489 588489 Palmer, John, of Melton, sailor 0
4346193 2145921 2145921 defendant Gooche John yeoman 588489 588489 Gooche, John, of Melton, yeoman 0
4369591 2154181 2154181 defendant Melton David (legal representative) 588489 588489 Melton, David, of Melton, executrix of 3
4369592 2154181 2154181 defendant Musgrave Jenetta widow 588489 588489 Musgrave, Jenetta, of Melton, widow 4
4383213 2159104 2159104 defendant Carlill Roger yeoman 588489 588489 Carlill, Roger, of Melton, yeoman 0
4383214 2159104 2159104 defendant Fewell John yeoman 588489 588489 Fewell, John, of Melton, yeoman 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);