names

171 rows where place_id = 606788

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666544 1915476 1915476 defendant Wright Robert yeoman 606788 606788 Wright, Robert, of Horncastle, yeoman 0
4064719 2047671 2047671 defendant Tesshe Lancelot   606788 606788 Tesshe, Lancelot, of Horncastle gent 0
4181792 2089113 2089113 defendant Cristofer Ralph carpenter 606788 606788 Cristofer, Ralph, of Horncastle, carpenter 0
4187235 2091028 2091028 defendant Elvyn Thomas yeoman 606788 606788 Elvyn, Thomas, of Horncastle, yeoman 0
4197549 2094702 2094702 defendant Wells Thomas glover 606788 606788 Wells, Thomas, of Horncastle, glover 0
4216992 2101438 2101438 defendant Jackson Richard tailor 606788 606788 Jackson, Richard, of Horncastle, tailor 1
4232058 2106713 2106713 defendant Lighthead George cordwainer 606788 606788 Lighthead, George, of Horncastle, cordwainer 0
4233391 2107193 2107193 defendant Sugden Henry tailor 606788 606788 Sugden, Henry, of Horncastle, tailor 0
4236927 2108492 2108492 defendant Barton Richard butcher 606788 606788 Barton, Richard, of Horncastle, butcher 0
4241249 2110058 2110058 defendant Elsaye George yeoman 606788 606788 Elsaye, George, of Horncastle, yeoman 0
4249760 2112901 2112901 defendant Middlewood Nicholas butcher 606788 606788 Middlewood, Nicholas, of Horncastle, butcher 0
4259629 2116196 2116196 defendant Darbe Robert (legal representative) 606788 606788 Darbe, Robert, of Horncastle, mercer, administratrix of 3
4259630 2116196 2116196 defendant Darbe Mary widow 606788 606788 Darbe, Mary, of Horncastle, widow 4
4261262 2116732 2116732 defendant Wade Thomas husbandman 606788 606788 Wade, Thomas, of Horncastle, husbandman 0
4261263 2116732 2116732 defendant Jackson Robert tailor 606788 606788 Jackson, Robert, of Horncastle, tailor 1
4269810 2119492 2119492 defendant Barton Richard butcher 606788 606788 Barton, Richard, of Horncastle, butcher 0
4275616 2121416 2121416 defendant Nayler Christopher mercer 606788 606788 Nayler, Christopher, of Horncastle, mercer 0
4277285 2121986 2121986 defendant Nailer Christopher (legal representative) 606788 606788 Nailer, Christopher, of Horncastle, mercer, administratrix of 2
4279824 2122859 2122859 defendant Boothe Clement gent 606788 606788 Boothe, Clement, of Horncastle, gent 2
4283432 2124110 2124110 defendant Stevenson Robert husbandman 606788 606788 Stevenson, Robert, of Horncastle, or of Stixwould, husbandman 2
4289121 2126166 2126166 defendant Sugden Henry tailor 606788 606788 Sugden, Henry, of Horncastle, tailor 1
4296092 2128699 2128699 defendant Flemynge Henry husbandman 606788 606788 Flemynge, Henry, of Horncastle, husbandman 1
4306037 2132250 2132250 defendant Jenney John gent 606788 606788 Jenney, John, of Horncastle, gent 0
4306844 2132534 2132534 defendant Sparke Gregory chandler 606788 606788 Sparke, Gregory, of Horncastle, chandler 0
4339462 2143568 2143568 defendant Lightheade George husbandman 606788 606788 Lightheade, George, of Horncastle, husbandman 0
4339466 2143570 2143570 defendant Lighthead George husbandman 606788 606788 Lighthead, George, of Horncastle, husbandman 0
4339468 2143571 2143571 defendant Fulshawe Roger yeoman 606788 606788 Fulshawe, Roger, of Horncastle, yeoman 0
4339731 2143669 2143669 defendant Bromby Christopher chapman 606788 606788 Bromby, Christopher, of Horncastle, chapman 0
4340814 2144061 2144061 defendant Prettye John yeoman 606788 606788 Prettye, John, of Horncastle, yeoman 0
4340815 2144061 2144061 defendant Chappell George yeoman 606788 606788 Chappell, George, of Horncastle, yeoman 1
4346088 2145886 2145886 defendant Kirbe Roger yeoman 606788 606788 Kirbe, Roger, of Horncastle, yeoman 0
4352071 2147960 2147960 defendant Jaxon John clerk 606788 606788 Jaxon, John, of Horncastle, clerk 0
4356915 2149651 2149651 defendant Temple George glover 606788 606788 Temple, George, of Horncastle, glover 0
4360105 2150777 2150777 defendant Wright John yeoman 606788 606788 Wright, John, of Horncastle, yeoman 1
4360178 2150803 2150803 defendant Brome William yeoman 606788 606788 Brome, William, of Horncastle, yeoman 1
4360666 2150986 2150986 defendant Balie Hugh carpenter 606788 606788 Balie, Hugh, of Horncastle, carpenter 2
4360675 2150988 2150988 defendant Fulshawe Roger yeoman 606788 606788 Fulshawe, Roger, of Horncastle, yeoman 2
4360678 2150989 2150989 defendant Lightheade George shoemaker 606788 606788 Lightheade, George, of Horncastle, shoemaker 1
4360679 2150989 2150989 defendant Brocke William shoemaker 606788 606788 Brocke, William, of Horncastle, shoemaker 2
4361017 2151114 2151114 defendant Toynton George haberdasher 606788 606788 Toynton, George, of Horncastle, haberdasher 0
4361020 2151114 2151114 defendant Chamberlayne Robert shoemaker 606788 606788 Chamberlayne, Robert, of Horncastle, shoemaker 3
4363479 2152012 2152012 defendant Harrison William gent 606788 606788 Harrison, William, of Horncastle, gent 0
4364447 2152343 2152343 defendant Ward John laborer 606788 606788 Ward, John, of Horncastle, laborer 3
4365144 2152590 2152590 defendant Fulshawe Roger yeoman 606788 606788 Fulshawe, Roger, of Horncastle, yeoman 3
4365285 2152647 2152647 defendant Hunton Robert shoemaker 606788 606788 Hunton, Robert, of Horncastle, shoemaker 0
4374814 2156047 2156047 defendant Middlewood Nicholas butcher 606788 606788 Middlewood, Nicholas, of Horncastle, butcher 0
4374981 2156112 2156112 defendant Walker Oswald yeoman 606788 606788 Walker, Oswald, of Horncastle, yeoman 0
4375293 2156219 2156219 defendant Dickenson George laborer 606788 606788 Dickenson, George, of Horncastle, laborer 0
4379245 2157657 2157657 defendant Neale William gent 606788 606788 Neale, William, of Horncastle, gent 0
4448760 2184551 2184551 defendant Sadeler William   606788 606788 Sadeler, William, of Horncastle 0
4495513 2199278 2199278 plaintiff Stirkeland William de   606788 606788 Stirkeland, William de, of Horncastle, parson 1
4500118 2200677 2200677 defendant Sla-- William   606788 606788 Sla--, William, of Horncastle 2
4510801 2203836 2203836 defendant Sadeler John   606788 606788 Sadeler, John, of Horncastle 0
4510802 2203836 2203836 defendant Austyn William   606788 606788 Austyn, William, of Horncastle 1
4510803 2203836 2203836 defendant Smyth Peter   606788 606788 Smyth, Peter, of Horncastle 2
4511830 2204148 2204148 defendant Corder Roger   606788 606788 Corder, Roger, of Horncastle 0
4514325 2204897 2204897 defendant Rous John   606788 606788 Rous, John, of Horncastle, wright 4
4528036 2209050 2209050 defendant Blanhorn William   606788 606788 Blanhorn, William, of Horncastle 0
4529068 2209363 2209363 defendant Tapiter Thomas   606788 606788 Tapiter, Thomas, of Horncastle 0
4529852 2209622 2209622 defendant Rane John   606788 606788 Rane, John, of Horncastle 0
4534663 2211113 2211113 defendant Akell John   606788 606788 Akell, John, of Horncastle 0
4540616 2212963 2212963 defendant Skynner William   606788 606788 Skynner, William, of Horncastle 0
4541283 2213170 2213170 defendant Bukeland Thomas   606788 606788 Bukeland, Thomas, of Horncastle 1
4549417 2215764 2215764 plaintiff Cordor Roger   606788 606788 Cordor, Roger, of Horncastle 0
4552876 2216842 2216842 defendant Ledbeter Edmund   606788 606788 Ledbeter, Edmund, of Horncastle 0
4553543 2217038 2217038 defendant Hotoft Robert   606788 606788 Hotoft, Robert, of Horncastle 0
4561844 2219639 2219639 defendant Hotoft Robert chapman 606788 606788 Hotoft, Robert, of Horncastle, chapman 2
4565356 2220732 2220732 defendant Haryngton Robert   606788 606788 Haryngton, Robert, of Horncastle 0
4565467 2220770 2220770 plaintiff Smyth Robert   606788 606788 Smyth, Robert, of Horncastle 0
4568506 2221723 2221723 plaintiff Volantyne John   606788 606788 Volantyne, John, of Horncastle 0
4568508 2221723 2221723 defendant Austyn William   606788 606788 Austyn, William, of Horncastle 0
4587074 2227365 2227365 defendant Sadeler William   606788 606788 Sadeler, William, of Horncastle 4
4587075 2227365 2227365 defendant Donyngton Richard shoemaker 606788 606788 Donyngton, Richard, of Horncastle, shoemaker 5
4587076 2227365 2227365 defendant Strenger William   606788 606788 Strenger, William, of Horncastle 6
4587077 2227365 2227365 defendant Wadster Richard   606788 606788 Wadster, Richard, of Horncastle 7
4587078 2227365 2227365 defendant Lorymer Gregory   606788 606788 Lorymer, Gregory, of Horncastle 8
4587080 2227365 2227365 defendant Whith John shoemaker 606788 606788 Whith, John, of Horncastle, shoemaker 10
4587081 2227365 2227365 defendant Warde Robert shoemaker 606788 606788 Warde, Robert, of Horncastle, shoemaker 11
4595686 2229912 2229912 defendant Bokeland Thomas   606788 606788 Bokeland, Thomas, of Horncastle 0
4597367 2230418 2230418 defendant Glover John   606788 606788 Glover, John, of Horncastle 0
4597368 2230418 2230418 defendant Glover Richard   606788 606788 Glover, Richard, of Horncastle 1
4597369 2230418 2230418 defendant Barbour Thomas   606788 606788 Barbour, Thomas, of Horncastle 2
4597844 2230580 2230580 defendant Barbour Thomas   606788 606788 Barbour, Thomas, of Horncastle 0
4598289 2230704 2230704 defendant Dalderby William de   606788 606788 Dalderby, William de, of Horncastle 0
4621092 2237580 2237580 defendant Bosoton Thomas de   606788 606788 Bosoton, Thomas de, of Horncastle 1
4626419 2239215 2239215 plaintiff Erny Thomas   606788 606788 Erny, Thomas, of Horncastle 1
4629329 2240105 2240105 defendant Amory Richard   606788 606788 Amory, Richard, of Horncastle 0
4646026 2244909 2244909 defendant Lambele Thomas dyer 606788 606788 Lambele, Thomas, of Horncastle, dyer 1
4647807 2245421 2245421 defendant Amory Richard   606788 606788 Amory, Richard, of Horncastle 0
4658631 2248574 2248574 defendant Bokeland Thomas shoemaker 606788 606788 Bokeland, Thomas, of Horncastle, shoemaker 3
4667737 2255622 2255622 defendant Milner John milner 606788 606788 Milner, John, of Horncastle, milner 0
4671117 2256632 2256632 defendant Western John yeoman 606788 606788 Western, John, of Horncastle, yeoman 0
4671118 2256632 2256632 defendant Flesshewer John yeoman 606788 606788 Flesshewer, John, of Horncastle, yeoman 1
4671119 2256632 2256632 defendant Milner John yeoman 606788 606788 Milner, John, of Horncastle, yeoman 2
4671120 2256632 2256632 defendant Warde Robert yeoman 606788 606788 Warde, Robert, of Horncastle, yeoman 3
4671383 2256698 2256698 defendant Warton William de yeoman 606788 606788 Warton, William de, of Horncastle, yeoman 0
4672107 2256924 2256924 defendant Glover John yeoman 606788 606788 Glover, John, of Horncastle, yeoman 0
4693285 2263401 2263401 defendant Meborne Geoffrey tanner 606788 606788 Meborne, Geoffrey, of Horncastle, tanner 0
4694447 2263756 2263756 defendant Milner John miller 606788 606788 Milner, John, of Horncastle, miller 0
4697198 2264604 2264604 defendant Amory Richard husbandman 606788 606788 Amory, Richard, of Horncastle, husbandman 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);