names

97 rows where place_id = 591188

✎ 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
3603648 1868809 1868809 defendant Hunger John chaplain 591188 591188 Hunger, John, of Magna Massyngham, chaplain 1
3617106 1872974 1872974 defendant Halman William husbandman 591188 591188 Halman, William, of Magna Massyngham, husbandman 1
3640731 1907546 1907546 defendant Warcop Alice widow 591188 591188 Warcop, Alice, of Magna Massyngham, widow 1
3647737 1909682 1909682 defendant Warcop Alice widow 591188 591188 Warcop, Alice, of Magna Massyngham, widow 0
3647739 1909683 1909683 defendant Warcop Alice widow 591188 591188 Warcop, Alice, of Magna Massyngham, widow 0
3689130 1922762 1922762 defendant Dale John husbandman 591188 591188 Dale, John, of Magna Massyngham, husbandman 0
3697901 1925566 1925566 defendant Mone John warrener 591188 591188 Mone, John, of Magna Massyngham, warrener 0
3697902 1925566 1925566 defendant Manne Robert yeoman 591188 591188 Manne, Robert, of Magna Massyngham, yeoman 1
3697904 1925566 1925566 defendant Tolle Robert husbandman 591188 591188 Tolle, Robert, of Magna Massyngham, husbandman 3
3705339 1927960 1927960 defendant Buntyng Thomas husbandman 591188 591188 Buntyng, Thomas, of Magna Massyngham, husbandman 0
3706741 1928393 1928393 defendant Hooke Henry husbandman 591188 591188 Hooke, Henry, of Magna Massyngham, husbandman 0
3710479 1929597 1929597 defendant Jekeler Thomas husbandman 591188 591188 Jekeler, Thomas, of Magna Massyngham, husbandman 0
3710581 1929632 1929632 defendant Hoke Henry pedder 591188 591188 Hoke, Henry, of Magna Massyngham, pedder 0
3713206 1930433 1930433 defendant Hooke Henry husbandman 591188 591188 Hooke, Henry, of Magna Massyngham, husbandman 0
3713255 1930454 1930454 defendant Couper William laborer 591188 591188 Couper, William, of Magna Massyngham, laborer 0
3722271 1933224 1933224 defendant Mone John warrener 591188 591188 Mone, John, of Magna Massyngham, warrener 0
3724208 1933857 1933857 defendant Ormeshed Peter husbandman 591188 591188 Ormeshed, Peter, of Magna Massyngham, husbandman 1
3724213 1933858 1933858 defendant Ormeshed Peter husbandman 591188 591188 Ormeshed, Peter, of Magna Massyngham, husbandman 3
3728672 1935206 1935206 defendant Wryght William husbandman 591188 591188 Wryght, William, of Magna Massyngham, husbandman 0
3737863 1938062 1938062 plaintiff Man Robert   591188 591188 Man, Robert, of Magna Massyngham, yeoman, administrators of 0
3737864 1938062 1938062 plaintiff Man Katherine   591188 591188 (Man, Katherine, of Magna Massyngham 1
3737866 1938062 1938062 defendant Hooke Thomas yeoman 591188 591188 Hooke, Thomas, of Magna Massyngham, yeoman 0
3739905 1938699 1938699 defendant Bateman William warrener 591188 591188 Bateman, William, of Magna Massyngham, warrener 0
3747665 1941189 1941189 defendant Mone John warrener 591188 591188 Mone, John, of Magna Massyngham, warrener 1
3757215 1944239 1944239 defendant Hoke Thomas yeoman 591188 591188 Hoke, Thomas, of Magna Massyngham, yeoman 0
3764346 1946511 1946511 defendant ormeshed Peter husbandman 591188 591188 ormeshed, Peter, of Magna Massyngham, husbandman 3
3775200 1949978 1949978 defendant Hoke alias Hookys Thomas yeoman 591188 591188 Hoke alias Hookys, Thomas, of Magna Massyngham, yeoman 0
3779755 1951402 1951402 defendant Armeshed Peter husbandman 591188 591188 Armeshed, Peter, of Magna Massyngham, husbandman 0
3779756 1951402 1951402 defendant Bateman William husbandman 591188 591188 Bateman, William, of Magna Massyngham, husbandman 1
3779757 1951402 1951402 defendant Colte Robert husbandman 591188 591188 Colte, Robert, of Magna Massyngham, husbandman 2
3782361 1952237 1952237 defendant Barteram John   591188 591188 Barteram, John, of Magna Massyngham, shepherd 0
3783522 1952600 1952600 defendant Dalyon Thomas whoemaker 591188 591188 Dalyon, Thomas, of Magna Massyngham, whoemaker 0
3788275 1954128 1954128 defendant Hoke Henry husbandman 591188 591188 Hoke, Henry, of Magna Massyngham, husbandman 0
3798971 1957590 1957590 defendant Hoke Henry husbandman 591188 591188 Hoke, Henry, of Magna Massyngham, husbandman 2
3802501 1958678 1958678 defendant Lawrans Roger butcher 591188 591188 Lawrans, Roger, of Magna Massyngham, butcher 5
3823036 1965114 1965114 defendant Jeklove Thomas husbandman 591188 591188 Jeklove, Thomas, of Magna Massyngham, husbandman 0
3843627 1971540 1971540 defendant Hooke Thomas husbandman 591188 591188 Hooke, Thomas, of Magna Massyngham, husbandman 0
3851219 1973977 1973977 defendant Miller Thomas husbandman 591188 591188 Miller, Thomas, of Magna Massyngham, husbandman 0
3851375 1974030 1974030 defendant Hoke Thomas husbandman 591188 591188 Hoke, Thomas, of Magna Massyngham, husbandman 0
3853236 1974630 1974630 defendant Mone John warrener 591188 591188 Mone, John, of Magna Massyngham, warrener 1
3853237 1974630 1974630 defendant Tolle Robert husbandman 591188 591188 Tolle, Robert, of Magna Massyngham, husbandman 2
3860831 1977115 1977115 defendant Bateman William husbandman 591188 591188 Bateman, William, of Magna Massyngham, husbandman 1
3865917 1978831 1978831 defendant Rychardson Thomas shoemaker 591188 591188 Rychardson, Thomas, of Magna Massyngham, shoemaker 0
3866949 1979184 1979184 defendant Bateman William yeoman 591188 591188 Bateman, William, of Magna Massyngham, yeoman 0
3872037 1980879 1980879 plaintiff Bateman William yeoman 591188 591188 Bateman, William, of Magna Massyngham, yeoman 0
3872039 1980879 1980879 defendant Tolle Robert husbandman 591188 591188 Tolle, Robert, of Magna Massyngham, husbandman 1
3877391 1982684 1982684 defendant Hooke Thomas husbandman 591188 591188 Hooke, Thomas, of Magna Massyngham, husbandman 0
3881914 1984207 1984207 defendant Hoke Thomas innholder 591188 591188 Hoke, Thomas, of Magna Massyngham, innholder 0
3903672 1991459 1991459 defendant Jeclove alias Jeckeler John husbandman 591188 591188 Jeclove alias Jeckeler, John, of Magna Massyngham, husbandman 0
3904705 1991832 1991832 defendant Jekelove Thomas yeoman 591188 591188 Jekelove, Thomas, of Magna Massyngham, yeoman 0
3918255 1996439 1996439 defendant Hoke Thomas yeoman 591188 591188 Hoke, Thomas, of Magna Massyngham, yeoman 0
3918442 1996496 1996496 defendant Jekelove Thomas yeoman 591188 591188 Jekelove, Thomas, of Magna Massyngham, yeoman 0
3919764 1996949 1996949 defendant Jecler Thomas yeoman 591188 591188 Jecler, Thomas, of Magna Massyngham, yeoman 2
3922217 1997740 1997740 defendant Jekeler Thomas yeoman 591188 591188 Jekeler, Thomas, of Magna Massyngham, yeoman 0
3922219 1997740 1997740 defendant Rychardson Thomas husbandman 591188 591188 Rychardson, Thomas, of Magna Massyngham, husbandman 2
3922220 1997740 1997740 defendant Baclar John husbandman 591188 591188 Baclar, John, of Magna Massyngham, husbandman 3
3922221 1997740 1997740 defendant Redwyn John husbandman 591188 591188 Redwyn, John, of Magna Massyngham, husbandman 4
3924854 1998630 1998630 defendant Jekeler Thomas yeoman 591188 591188 Jekeler, Thomas, of Magna Massyngham, yeoman 4
3960310 2010700 2010700 defendant Nuwell John clerk 591188 591188 Nuwell, John, of Magna Massyngham, clerk 0
3975279 2015923 2015923 defendant Coppock John schoolmaster 591188 591188 Coppock, John, of Magna Massyngham, schoolmaster 0
3982894 2018659 2018659 defendant Coppocke John schoolmaster 591188 591188 Coppocke, John, of Magna Massyngham, schoolmaster 0
3982895 2018659 2018659 defendant Nowell John clerk 591188 591188 Nowell, John, of Magna Massyngham, clerk 1
4013281 2029483 2029483 defendant Gyles William husbandman 591188 591188 Gyles, William, of Magna Massyngham, husbandman 1
4014651 2029961 2029961 defendant Hollys William gent 591188 591188 Hollys, William, of Magna Massyngham, gent 2
4206281 2097744 2097744 defendant Clarke William husbandman 591188 591188 Clarke, William, of Magna Massyngham, husbandman 0
4335500 2142147 2142147 defendant Styles Henry   591188 591188 Styles, Henry, of Magna Massyngham, ploughwright 1
4400599 2164791 2164791 defendant Dale William husbandman 591188 591188 Dale, William, of Magna Massyngham, husbandman 0
4889760 2323592 2323592 plaintiff Dale John   591188 591188 Dale, John, of Magna Massyngham 0
4889761 2323592 2323592 defendant Warde William husbandman 591188 591188 Warde, William, of Magna Massyngham, husbandman 0
4889762 2323592 2323592 defendant Elwyn Robert   591188 591188 Elwyn, Robert, of Magna Massyngham, wright 1
4889763 2323592 2323592 defendant Feltham John husbandman 591188 591188 Feltham, John, of Magna Massyngham, husbandman 2
4889764 2323592 2323592 defendant Willys John husbandman 591188 591188 Willys, John, of Magna Massyngham, husbandman 3
4951308 2342371 2342371 defendant Dytnot Thomas husbandman 591188 591188 Dytnot, Thomas, of Magna Massyngham, husbandman 0
4951313 2342373 2342373 defendant Cays Hugh (legal representative) 591188 591188 Cays, Hugh, of Magna Massyngham, clerk, executor of 0
4951314 2342373 2342373 defendant Patryk Edmund gent 591188 591188 Patryk, Edmund, of Magna Massyngham, gent 1
4962845 2345802 2345802 defendant Olyver John husbandman 591188 591188 Olyver, John, of Magna Massyngham, husbandman 0
4982698 2351738 2351738 defendant Olyver John husbandman 591188 591188 Olyver, John, of Magna Massyngham, husbandman 0
5062314 2375288 2375288 defendant Tolle Henry yeoman 591188 591188 Tolle, Henry, of Magna Massyngham, yeoman 7
5105343 2388007 2388007 plaintiff Tolle Henry   591188 591188 Tolle, Henry, of Magna Massyngham 1
5223985 2422698 2422698 defendant Burdon John husbandman 591188 591188 Burdon, John, of Magna Massyngham, husbandman 0
5223986 2422698 2422698 defendant Patryk William yeoman 591188 591188 Patryk, William, of Magna Massyngham, yeoman 1
5258493 2432770 2432770 defendant atte Water Lawrence (legal representative) 591188 591188 atte Water, Lawrence, of Magna Massyngham, husbandman, executors of 2
5258495 2432770 2432770 defendant att Water Thomas clerk 591188 591188 att Water, Thomas, of Magna Massyngham, clerk 4
5280233 2439294 2439294 defendant Brygge John tailor 591188 591188 Brygge, John, of Magna Massyngham, tailor 2
5286702 2441120 2441120 defendant Skeythe Geoffrey husbandman 591188 591188 Skeythe, Geoffrey, of Magna Massyngham, husbandman 4
5290786 2442310 2442310 defendant Dale John yeoman 591188 591188 Dale, John, of Magna Massyngham, yeoman 0
5293668 2443112 2443112 defendant Grene John carpenter 591188 591188 Grene, John, of Magna Massyngham, carpenter 1
5313110 2448955 2448955 defendant Grome Thomas husbandman 591188 591188 Grome, Thomas, of Magna Massyngham, husbandman 0
5337298 2456226 2456226 defendant Burgeys alias Busshop John, junior husbandman 591188 591188 Burgeys alias Busshop, John, junior, of Magna Massyngham, yeoman, or of wWarham, husbandman 1
5491526 2502348 2502348 defendant Burges John, junior laborer 591188 591188 Burges, John, junior, of Magna Massyngham, laborer 4
5533633 2515065 2515065 defendant Moome Robert husbandman 591188 591188 Moome, Robert, of Magna Massyngham, husbandman 0
5536817 2516001 2516001 defendant Feltham John   591188 591188 Feltham, John, of Magna Massyngham, woollen weaver 1
5540443 2517141 2517141 defendant Tolle John yeoman 591188 591188 Tolle, John, of Magna Massyngham, yeoman 0
5552557 2520805 2520805 plaintiff Feltham John   591188 591188 (Feltham, John, of Magna Massyngham 1
5552562 2520806 2520806 plaintiff Feltham John   591188 591188 (Feltham, John, of Magna Massyngham 1
5561152 2523239 2523239 plaintiff Toke John gent 591188 591188 Toke, John, of Magna Massyngham, gent 0
5606086 2536793 2536793 defendant Couper William   591188 591188 Couper, William, of Magna Massyngham, shepherd 0

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