names

181 rows where place_id = 591977

✎ 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
3606180 1869603 1869603 defendant Cokeshote Christopher yeoman 591977 591977 Cokeshote, Christopher, of Laxton, yeoman 1
3606183 1869604 1869604 defendant Cokshole Christopher yeoman 591977 591977 Cokshole, Christopher, of Laxton, yeoman 1
3613945 1872016 1872016 defendant Hokshote Christopher husbandman 591977 591977 Hokshote, Christopher, of Laxton, husbandman 0
3613947 1872017 1872017 defendant Kokshote Christopher husbandman 591977 591977 Kokshote, Christopher, of Laxton, husbandman 0
3620437 1873972 1873972 defendant Loweson John yeoman 591977 591977 Loweson, John, of Laxton, yeoman 5
3628731 1903863 1903863 defendant Sprotte John chaplain 591977 591977 Sprotte, John, of Laxton, chaplain 0
3628732 1903863 1903863 defendant Johnson Richard tailor 591977 591977 Johnson, Richard, of Laxton, tailor 1
3630727 1904435 1904435 defendant Rose Humphrey esq 591977 591977 Rose, Humphrey, of Laxton, esq 0
3631752 1904739 1904739 defendant Rose Humphrey esq 591977 591977 Rose, Humphrey, of Laxton, esq 0
3641367 1907753 1907753 defendant Roos Humphrey esq 591977 591977 Roos, Humphrey, of Laxton, esq 2
3642849 1908212 1908212 defendant Lowson William husbandman 591977 591977 Lowson, William, of Laxton, husbandman 0
3653886 1911480 1911480 defendant Lawson William yeoman 591977 591977 Lawson, William, of Laxton, yeoman 0
3697615 1925478 1925478 defendant Chapell William husbandman 591977 591977 Chapell, William, of Laxton, husbandman 0
3697616 1925478 1925478 defendant Fenton William butcher 591977 591977 Fenton, William, of Laxton, butcher 1
3697617 1925478 1925478 defendant Ferley John yeoman 591977 591977 Ferley, John, of Laxton, yeoman 2
3699421 1926042 1926042 defendant Coupe Elias cooper 591977 591977 Coupe, Elias, of Laxton, cooper 3
3755191 1943574 1943574 defendant Lee Robert husbandman 591977 591977 Lee, Robert, of Laxton, husbandman 2
3771530 1948789 1948789 defendant Cokshop Thomas laborer 591977 591977 Cokshop, Thomas, of Laxton, laborer 0
3806685 1959989 1959989 defendant Lee Robert husbandman 591977 591977 Lee, Robert, of Laxton, husbandman 1
3822306 1964881 1964881 defendant Howden William husbandman 591977 591977 Howden, William, of Laxton, husbandman 2
3822310 1964882 1964882 defendant Howden William husbandman 591977 591977 Howden, William, of Laxton, husbandman 0
3900865 1990519 1990519 defendant Arthure William laborer 591977 591977 Arthure, William, of Laxton, laborer 1
3900866 1990519 1990519 defendant Brokenbanke Hugh laborer 591977 591977 Brokenbanke, Hugh, of Laxton, laborer 2
3917457 1996198 1996198 defendant Rosse Edward gent 591977 591977 Rosse, Edward, of Laxton, gent 0
3938380 2003178 2003178 plaintiff Pullyn Hugh   591977 591977 Pullyn, Hugh, of Laxton, vicar 0
3958539 2010056 2010056 plaintiff Roos Edward gent 591977 591977 Roos, Edward, of Laxton, gent 0
3958540 2010056 2010056 defendant Bevyll George   591977 591977 Bevyll, George, of Laxton, or of Mattersey, gent, son of Anthony Nevyll, knight 0
3958542 2010057 2010057 plaintiff Roos Edward gent 591977 591977 Roos, Edward, of Laxton, gent 0
3958543 2010057 2010057 defendant Nevyll George   591977 591977 Nevyll, George, of Laxton, or of Mattersey, gent, son of Anthony Nevyll, knight 0
3958545 2010058 2010058 plaintiff Roos Edward gent 591977 591977 Roos, Edward, of Laxton, gent 0
4060543 2046172 2046172 defendant Lowson William gent 591977 591977 Lowson, William, of Laxton, gent 0
4060545 2046173 2046173 defendant Rabye John husbandman 591977 591977 Rabye, John, of Laxton, husbandman 0
4157544 2080712 2080712 defendant Roos Peter esq 591977 591977 Roos, Peter, of Laxton, esq 1
4169068 2084678 2084678 defendant Roos Peter esq 591977 591977 Roos, Peter, of Laxton, esq 0
4205013 2097297 2097297 defendant Roos Peter esq 591977 591977 Roos, Peter, of Laxton, esq 0
4344976 2145520 2145520 defendant Fryth John sherman 591977 591977 Fryth, John, of Laxton, sherman 3
4349902 2147228 2147228 defendant Hygden John gent 591977 591977 Hygden, John, of Laxton, gent 0
4407333 2167015 2167015 defendant Freman Michael gent 591977 591977 Freman, Michael, of Laxton, gent 0
4422655 2171940 2171940 plaintiff Everyngham Adam   591977 591977 Everyngham, Adam, of Laxton 0
4425013 2172663 2172663 defendant Elyngton Henry de   591977 591977 Elyngton, Henry de, of Laxton 0
4433084 2175101 2175101 plaintiff Everyngham Adam de   591977 591977 Everyngham, Adam de, of Laxton, knight 0
4444455 2183245 2183245 plaintiff Coke William   591977 591977 Coke, William, of Laxton 0
4445944 2183677 2183677 plaintiff Danyell John (legal representative) 591977 591977 Danyell, John, of Laxton, executors of 0
4445947 2183677 2183677 plaintiff Everard William   591977 591977 Everard, William, of Laxton 3
4464443 2189548 2189548 defendant Danvill John (legal representative) 591977 591977 Danvill, John, of Laxton, executors of 0
4487652 2196853 2196853 defendant Rowedon Hugh de   591977 591977 Rowedon, Hugh de, of Laxton 0
4495174 2199175 2199175 plaintiff Burton William de   591977 591977 Burton, William de, of Laxton 0
4523227 2207589 2207589 defendant Clerk Thomas   591977 591977 Clerk, Thomas, of Laxton 6
4574130 2223431 2223431 defendant atte Welle Richard   591977 591977 atte Welle, Richard, of Laxton 0
4589753 2228161 2228161 defendant Smythson William   591977 591977 Smythson, William, of Laxton 5
4589754 2228161 2228161 defendant Hobson John   591977 591977 Hobson, John, of Laxton 6
4624082 2238508 2238508 defendant Takyll John   591977 591977 Takyll, John, of Laxton 5
4627727 2239600 2239600 defendant Pensax John   591977 591977 Pensax, John, of Laxton 2
4629789 2240237 2240237 defendant Bekyngham Robert   591977 591977 Bekyngham, Robert, of Laxton 2
4645261 2244684 2244684 defendant Takyll John   591977 591977 Takyll, John, of Laxton 5
4648085 2245509 2245509 defendant Smyth Roger   591977 591977 Smyth, Roger, of Laxton 0
4648090 2245509 2245509 defendant Clerk William   591977 591977 Clerk, William, of Laxton 5
4648108 2245510 2245510 defendant Lambe Henry   591977 591977 Lambe, Henry, of Laxton 6
4648112 2245510 2245510 defendant Hasarde William   591977 591977 Hasarde, William, of Laxton 10
4648113 2245510 2245510 defendant Samon Wiliam   591977 591977 Samon, Wiliam, of Laxton 11
4648117 2245510 2245510 defendant Carter John   591977 591977 Carter, John, of Laxton 15
4650601 2246195 2246195 defendant White William   591977 591977 White, William, of Laxton 5
4666847 2255357 2255357 plaintiff Alchon Richard   591977 591977 Alchon, Richard, of Laxton 0
4676725 2258340 2258340 defendant Hopkynson John husbandman 591977 591977 Hopkynson, John, of Laxton, husbandman 0
4793409 2294045 2294045 plaintiff of Clay William   591977 591977 of Clay, William, of Laxton 0
4793410 2294045 2294045 defendant de Cawedewell Simon   591977 591977 de Cawedewell, Simon, of Laxton 0
4793411 2294045 2294045 defendant Gillynge Robert   591977 591977 Gillynge, Robert, of Laxton 1
4836603 2307420 2307420 defendant Gabber Roger husbandman 591977 591977 Gabber, Roger, of Laxton, husbandman 0
4848480 2311000 2311000 defendant Hylton John   591977 591977 Hylton, John, of Laxton, servant 2
4869376 2317391 2317391 defendant Gabbere John husbandman 591977 591977 Gabbere, John, of Laxton, husbandman 0
4905316 2328256 2328256 defendant Eton Alexander clerk 591977 591977 Eton, Alexander, of Laxton, clerk 0
4923591 2333813 2333813 defendant Etton Alexander   591977 591977 Etton, Alexander, of Laxton, parson 0
4929089 2335518 2335518 defendant Gabber Roger   591977 591977 Gabber, Roger, of Laxton 0
4974686 2349396 2349396 defendant Walker Thomas weaver 591977 591977 Walker, Thomas, of Laxton, weaver 0
5017844 2362100 2362100 defendant Roos John esq 591977 591977 Roos, John, of Laxton, esq 0
5030257 2365718 2365718 defendant Stapilton Robert gent 591977 591977 Stapilton, Robert, of Laxton, or of Cadnay, Lincs, gent 0
5030259 2365719 2365719 defendant Stapilton Robert gent 591977 591977 Stapilton, Robert, of Laxton, or of Gadnay, Lincs, gent 0
5054294 2372864 2372864 defendant Portyngton John merchant 591977 591977 Portyngton, John, of Laxton, or of Barton on Humber, Lincs, merchant 3
5069382 2377336 2377336 defendant Hulton Thomas husbandman 591977 591977 Hulton, Thomas, of Laxton, husbandman 2
5079951 2380481 2380481 defendant Roos Richard gent 591977 591977 Roos, Richard, of Laxton, gent 0
5079952 2380481 2380481 defendant Roos Robert gent 591977 591977 Roos, Robert, of Laxton, gent 1
5101467 2386839 2386839 defendant Roos Robert gent 591977 591977 Roos, Robert, of Laxton, gent 1
5101468 2386839 2386839 defendant Roos John, junior gent 591977 591977 Roos, John, junior, of Laxton, gent 2
5101469 2386839 2386839 defendant Roos William gent 591977 591977 Roos, William, of Laxton, gent 3
5101470 2386839 2386839 defendant Roos Richard gent 591977 591977 Roos, Richard, of Laxton, gent 4
5215163 2420159 2420159 defendant Cromwell Thomas husbandman 591977 591977 Cromwell, Thomas, of Laxton, husbandman 0
5243909 2428410 2428410 defendant Coke Thomas husbandman 591977 591977 Coke, Thomas, of Laxton, husbandman 0
5247824 2429509 2429509 defendant Roos Isabel widow 591977 591977 Roos, Isabel, of Laxton, widow 0
5247825 2429509 2429509 defendant Roos Richard gent 591977 591977 Roos, Richard, of Laxton, gent 1
5247826 2429509 2429509 defendant Leverton John, junior husbandman 591977 591977 Leverton, John, junior, of Laxton, husbandman 2
5247827 2429509 2429509 defendant Goland Robert laborer 591977 591977 Goland, Robert, of Laxton, laborer 3
5247828 2429509 2429509 defendant Heyward Roger laborer 591977 591977 Heyward, Roger, of Laxton, laborer 4
5247829 2429509 2429509 defendant Rygdon Robert husbandman 591977 591977 Rygdon, Robert, of Laxton, husbandman 5
5247830 2429509 2429509 defendant Gartsyde Henry laborer 591977 591977 Gartsyde, Henry, of Laxton, laborer 6
5247831 2429509 2429509 defendant Phelypp Thomas laborer 591977 591977 Phelypp, Thomas, of Laxton, laborer 7
5247832 2429509 2429509 defendant Tode John laborer 591977 591977 Tode, John, of Laxton, laborer 8
5247833 2429509 2429509 defendant Doghson Christopher laborer 591977 591977 Doghson, Christopher, of Laxton,laborer 9
5247834 2429509 2429509 defendant Thorneton William yeoman 591977 591977 Thorneton, William, of Laxton, yeoman 10
5247835 2429509 2429509 defendant Bayldon Richard laborer 591977 591977 Bayldon, Richard, of Laxton, laborer 11
5247836 2429509 2429509 defendant Legeard Richard yeoman 591977 591977 Legeard, Richard, of Laxton, yeoman 12

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