names

79 rows where place_id = 586933

✎ 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
3590023 1864518 1864518 defendant Andrewe John husbandman 586933 586933 Andrewe, John, of Barford, husbandman 2
3671230 1916975 1916975 defendant Manfeld John husbandman 586933 586933 Manfeld, John, of Barford, husbandman 0
3681400 1920270 1920270 plaintiff Skynner Thomas clerk 586933 586933 Skynner, Thomas, of Barford, clerk 0
3681402 1920271 1920271 plaintiff Skynner Thomas clerk 586933 586933 Skynner, Thomas, of Barford, clerk 0
3681406 1920272 1920272 plaintiff Skynner Thomas clerk 586933 586933 Skynner, Thomas, of Barford, clerk 0
3760766 1945369 1945369 plaintiff Dobbys Thomas   586933 586933 Dobbys, Thomas, of Barford 0
3762783 1945998 1945998 defendant Dobbys Thomas husbandman 586933 586933 Dobbys, Thomas, of Barford, husbandman 1
3766589 1947214 1947214 defendant Bysshop Henry husbandman 586933 586933 Bysshop, Henry, of Barford, husbandman 0
3766590 1947214 1947214 defendant Bysshop Richard husbandman 586933 586933 Bysshop, Richard, of Barford, husbandman 1
3766592 1947215 1947215 defendant White Thomas laborer 586933 586933 White, Thomas, of Barford, laborer 0
3778920 1951123 1951123 defendant Skynner Thomas clerk 586933 586933 Skynner, Thomas, of Barford, clerk 0
3778921 1951123 1951123 defendant Stone Richard husbandman 586933 586933 Stone, Richard, of Barford, husbandman 1
3778922 1951123 1951123 defendant Darby John husbandman 586933 586933 Darby, John, of Barford, husbandman 2
3778923 1951123 1951123 defendant Manfeld Nicholas husbandman 586933 586933 Manfeld, Nicholas, of Barford, husbandman 3
3795257 1956383 1956383 defendant Penbery Ralph tailor 586933 586933 Penbery, Ralph, of Barford, tailor 1
3864340 1978268 1978268 defendant Gryfton John chapman 586933 586933 Gryfton, John, of Barford, chapman 2
3895915 1988840 1988840 defendant Andrewe Robert husbandman 586933 586933 Andrewe, Robert, of Barford, husbandman 0
3932143 2001056 2001056 defendant Fayrefax John milner 586933 586933 Fayrefax, John, of Barford, milner 0
3937645 2002923 2002923 defendant Pulford John   586933 586933 Pulford, John, of Barford, black smith 1
3957888 2009820 2009820 defendant Sylverston Robert husbandman 586933 586933 Sylverston, Robert, of Barford, husbandman 0
3968277 2013534 2013534 defendant Manfeld Nicholas yeoman 586933 586933 Manfeld, Nicholas, of Barford, yeoman 0
3973373 2015260 2015260 plaintiff Griffyn Thomas yeoman 586933 586933 Griffyn, Thomas, of Barford, yeoman 0
3973435 2015281 2015281 plaintiff Gryffyn Thomas yeoman 586933 586933 Gryffyn, Thomas, of Barford, yeoman 0
3991070 2021570 2021570 defendant Sylvester Robert yeoman 586933 586933 Sylvester, Robert, of Barford, yeoman 0
4006093 2026949 2026949 defendant Maxe Guy carpenter 586933 586933 Maxe, Guy, of Barford, carpenter 2
4006094 2026949 2026949 defendant Cotten Robert laborer 586933 586933 Cotten, Robert, of Barford, laborer 3
4007997 2027623 2027623 plaintiff Maxe Guy   586933 586933 Maxe, Guy, of Barford 0
4032051 2036131 2036131 defendant Cotton Robert husbandman 586933 586933 Cotton, Robert, of Barford, husbandman 0
4032055 2036132 2036132 defendant Cotton Robert husbandman 586933 586933 Cotton, Robert, of Barford, husbandman 0
4064012 2047411 2047411 defendant Harvye John carpenter 586933 586933 Harvye, John, of Barford, carpenter 0
4121049 2067817 2067817 defendant Elvye Edmund yeoman 586933 586933 Elvye, Edmund, of Barford, or of Watton, Norf, yeoman 0
4128688 2070554 2070554 defendant Cowper John husbandman 586933 586933 Cowper, John, of Barford, husbandman 0
4128689 2070554 2070554 defendant Bowldynge John husbandman 586933 586933 Bowldynge, John, of Barford, husbandman 1
4152639 2079037 2079037 defendant Elvye Edmund husbandman 586933 586933 Elvye, Edmund, of Barford, or of Watton, husbandman 0
4152657 2079042 2079042 defendant Elvye Edmund yeoman 586933 586933 Elvye, Edmund, of Barford, or of Watton, yeoman 0
4180431 2088632 2088632 defendant Elvye Edmund husbandman 586933 586933 Elvye, Edmund, of Barford, husbandman 0
4180433 2088633 2088633 defendant Elvye Edmund husbandman 586933 586933 Elvye, Edmund, of Barford, husbandman 0
4213878 2100374 2100374 defendant Haynes Thomas butcher 586933 586933 Haynes, Thomas, of Barford, butcher 1
4220693 2102738 2102738 defendant Creede Mary widow 586933 586933 Creede, Mary, of Barford, widow 0
4222044 2103201 2103201 defendant Page John yeoman 586933 586933 Page, John, of Barford, yeoman 3
4227588 2105136 2105136 defendant Cotton Robert husbandman 586933 586933 Cotton, Robert, of Barford, husbandman 0
4268898 2119193 2119193 defendant Newton Henry   586933 586933 Newton, Henry, of Barford, yeoman, administrators of 0
4269278 2119319 2119319 defendant Chappell Thomas yeoman 586933 586933 Chappell, Thomas, of Barford, yeoman 1
4269279 2119319 2119319 defendant Page John yeoman 586933 586933 Page, John, of Barford, yeoman 2
4285722 2124945 2124945 defendant Davy John   586933 586933 Davy, John, of Barford, cook 0
4288523 2125946 2125946 defendant Page John yeoman 586933 586933 Page, John, of Barford, yeoman 0
4299582 2129939 2129939 defendant Baylyes Robert husbandman 586933 586933 Baylyes, Robert, of Barford, husbandman 0
4327959 2139674 2139674 defendant Fenton Henry   586933 586933 Fenton, Henry, of Barford, Warks gent 0
4332750 2141235 2141235 defendant Warde Thomas gent 586933 586933 Warde, Thomas, of Barford, gent 3
4336358 2142453 2142453 defendant Watt Richard husbandman 586933 586933 Watt, Richard, of Barford, husbandman 1
4336359 2142453 2142453 defendant Purt John, senior blacksmith 586933 586933 Purt, John, senior, of Barford, blacksmith 2
4341788 2144404 2144404 defendant Wiltsheire Stephen husbandman 586933 586933 Wiltsheire, Stephen, of Barford, husbandman 0
4341859 2144428 2144428 defendant Banne Roger clerk 586933 586933 Banne, Roger, of Barford, clerk 0
4364647 2152414 2152414 defendant Gervas Thomas yeoman 586933 586933 Gervas, Thomas, of Barford, yeoman 0
4368259 2153697 2153697 defendant Ettricke Anthony gent 586933 586933 Ettricke, Anthony, of Barford, Wymborne Mynster, gent 0
4399459 2164406 2164406 defendant White William husbandman 586933 586933 White, William, of Barford, husbandman 1
4644621 2244517 2244517 defendant Sweyft Richard   586933 586933 Sweyft, Richard, of Barford 1
4715741 2270246 2270246 defendant Pudsay John   586933 586933 Pudsay, John, of Barford, knight 0
4715761 2270249 2270249 defendant Pudsay John   586933 586933 Pudsay, John, of Barford, knight 0
5124223 2393540 2393540 defendant Avenaunt Robert laborer 586933 586933 Avenaunt, Robert, of Barford, laborer 6
5257300 2432407 2432407 defendant Stacheden John husbandman 586933 586933 Stacheden, John, of Barford, husbandman 0
5259697 2433157 2433157 defendant Bischop John husbandman 586933 586933 Bischop, John, of Barford, husbandman 1
5313732 2449134 2449134 defendant Grene John yeoman 586933 586933 Grene, John, of Barford, yeoman 2
5313733 2449134 2449134 defendant Dynne Robert husbandman 586933 586933 Dynne, Robert, of Barford, husbandman 3
5313734 2449134 2449134 defendant Stone Geoffrey husbandman 586933 586933 Stone, Geoffrey, of Barford, husbandman 4
5318054 2450486 2450486 defendant Stachedon Thomas husbandman 586933 586933 Stachedon, Thomas, of Barford, husbandman 0
5321021 2451380 2451380 defendant Selby William gent 586933 586933 Selby, William, of Barford, gent 0
5520504 2511234 2511234 defendant Warde Robert yeoman 586933 586933 Warde, Robert, of Barford, yeoman 0
5520506 2511235 2511235 defendant Warde Robert yeoman 586933 586933 Warde, Robert, of Barford, yeoman 0
5544805 2518486 2518486 defendant Fyssher William husbandman 586933 586933 (Fyssher, William, of Barford, husbandman 1
5544807 2518486 2518486 defendant Fyssher Thomas husbandman 586933 586933 Fyssher, Thomas, of Barford, husbandman 3
5555109 2521501 2521501 defendant Couper Thomas laborer 586933 586933 Couper, Thomas, of Barford, laborer 4
5555110 2521501 2521501 defendant Ebbys Richard laborer 586933 586933 Ebbys, Richard, of Barford, laborer 5
5572737 2526573 2526573 defendant Kyng Nicholas husbandman 586933 586933 Kyng, Nicholas, of Barford, husbandman 0
5572739 2526574 2526574 defendant Fyssher John (legal representative) 586933 586933 Fyssher, John, of Barford, husbandman, executors of 0
5572740 2526574 2526574 defendant Fyssher Ellen widow 586933 586933 (Fyssher, Ellen, of Barford, widow 1
5572741 2526574 2526574 defendant Fyssher John husbandman 586933 586933 Fyssher, John, of Barford, husbandman 2
5572743 2526575 2526575 defendant Kyng Nicholas husbandman 586933 586933 Kyng, Nicholas, of Barford, husbandman 0
5590210 2531909 2531909 defendant Barker Roger husbandman 586933 586933 Barker, Roger, of Barford, husbandman 5

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