names

80 rows where place_id = 629144

✎ 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
3658494 1912908 1912908 plaintiff (not given) Ralph prior of Fairfax 629144 629144 Fairfax, Ralph, of Kyme, prior of the monastery of St Mary 0
3786526 1953578 1953578 defendant Nyx Edward carpenter 629144 629144 Nyx, Edward, of Kyme, carpenter 0
3805855 1959770 1959770 plaintiff Tupholme William clerk 629144 629144 Tupholme, William, of Kyme, clerk 0
3846352 1972413 1972413 defendant Cooket Robert yeoman 629144 629144 Cooket, Robert, of Kyme, yeoman 0
3870748 1980462 1980462 defendant Arnold Edmund brewer 629144 629144 Arnold, Edmund, of Kyme, brewer 0
3958278 2009970 2009970 defendant Arnold Edmund yeoman 629144 629144 Arnold, Edmund, of Kyme, yeoman 3
3961842 2011241 2011241 defendant Dyckynson George husbandman 629144 629144 Dyckynson, George, of Kyme, husbandman 1
3961849 2011242 2011242 defendant Arnold Edmund husbandman 629144 629144 Arnold, Edmund, of Kyme, husbandman 3
4005407 2026715 2026715 defendant Mallett William gent 629144 629144 Mallett, William, of Kyme, gent 0
4173693 2086253 2086253 defendant Cooke Thomas yeoman 629144 629144 Cooke, Thomas, of Kyme, yeoman 0
4204249 2097035 2097035 defendant Blackehed Robert yeoman 629144 629144 Blackehed, Robert, of Kyme, yeoman 0
4342269 2144576 2144576 defendant Knowles Robert clerk 629144 629144 Knowles, Robert, of Kyme, clerk 1
4444141 2183145 2183145 plaintiff Clerk Alan   629144 629144 Clerk, Alan, of Kyme 0
4444144 2183146 2183146 plaintiff Clerk Alan   629144 629144 Clerk, Alan, of Kyme 0
4470672 2191477 2191477 defendant Prykeys John   629144 629144 Prykeys, John, of Kyme 1
4475722 2193084 2193084 plaintiff Ferrour William   629144 629144 Ferrour, William, of Kyme 0
4475726 2193085 2193085 defendant Falywell John   629144 629144 Falywell, John, of Kyme 1
4511114 2203927 2203927 defendant Elyngham William   629144 629144 Elyngham, William, of Kyme 2
4514342 2204903 2204903 defendant Peny Thomas   629144 629144 Peny, Thomas, of Kyme 3
4516734 2205644 2205644 defendant Calceby William   629144 629144 Calceby, William, of Kyme 5
4523671 2207732 2207732 plaintiff Hedenstawe William   629144 629144 Hedenstawe, William, of Kyme 0
4523677 2207735 2207735 plaintiff Hedynstowe William   629144 629144 Hedynstowe, William, of Kyme 0
4648758 2245696 2245696 defendant Tylney John   629144 629144 Tylney, John, of Kyme 5
4648766 2245697 2245697 defendant Tylney John   629144 629144 Tylney, John, of Kyme 5
4650459 2246151 2246151 defendant Perche John   629144 629144 Perche, John, of Kyme 0
4650460 2246151 2246151 defendant Perche William   629144 629144 Perche, William, of Kyme 1
4654120 2247171 2247171 plaintiff Swaby William   629144 629144 Swaby, William, of Kyme 1
4657223 2248143 2248143 defendant Knaresburgh John gent 629144 629144 Knaresburgh, John, of Kyme, gent 5
4671045 2256613 2256613 defendant Heylay John yeoman 629144 629144 Heylay, John, of Kyme, yeoman 1
4675800 2258039 2258039 defendant Barner William husbandman 629144 629144 Barner, William, of Kyme, husbandman 2
4680918 2259657 2259657 plaintiff Madeson William forester 629144 629144 Madeson, William, of Kyme, forester 0
4680919 2259657 2259657 plaintiff Dale William   629144 629144 Dale, William, of Kyme 1
4685962 2261196 2261196 defendant Trewelove William laborer 629144 629144 Trewelove, William, of Kyme, laborer 1
4701376 2265832 2265832 defendant Knaresburgh John gent 629144 629144 Knaresburgh, John, of Kyme, gent 0
4705192 2266993 2266993 plaintiff Knaresburgh John de   629144 629144 Knaresburgh, John de, of Kyme 0
4705195 2266994 2266994 plaintiff Knaresburgh John   629144 629144 Knaresburgh, John, of Kyme 0
4705785 2267181 2267181 defendant Bardenay Hugh husbandman 629144 629144 Bardenay, Hugh, of Kyme, husbandman 0
4710128 2268521 2268521 plaintiff Precas John (legal representative) 629144 629144 Precas, John, of Kyme, executors of 0
4710131 2268521 2268521 plaintiff Porter Richard   629144 629144 Porter, Richard, of Kyme 3
4729441 2274420 2274420 defendant Bardeney Hugh husbandman 629144 629144 Bardeney, Hugh, of Kyme, husbandman 3
4734845 2276055 2276055 defendant Bardeney Hugh de   629144 629144 Bardeney, Hugh de, of Kyme, fen man 1
4747956 2279910 2279910 defendant Barthenay Hugh   629144 629144 Barthenay, Hugh, of Kyme, fenne man 3
4753898 2281598 2281598 defendant Medowecroft Robert gent 629144 629144 Medowecroft, Robert, of Kyme, gent 2
4764381 2284852 2284852 plaintiff Helay John   629144 629144 Helay, John, of Kyme 0
4764921 2285006 2285006 defendant Helay John   629144 629144 Helay, John, of Kyme, franklin 0
4766406 2285485 2285485 defendant Cote John carter 629144 629144 Cote, John, of Kyme, carter 0
4767968 2285952 2285952 defendant Abbot Alan laborer 629144 629144 Abbot, Alan, of Kyme, laborer 1
4774361 2287961 2287961 plaintiff Hardyng John   629144 629144 Hardyng, John, of Kyme 1
4792396 2293709 2293709 defendant Abbot Alan laborer 629144 629144 Abbot, Alan, of Kyme, laborer 1
4795013 2294582 2294582 plaintiff Heley John   629144 629144 Heley, John, of Kyme 1
4804537 2297609 2297609 defendant Humfrevyle Gilbert (legal representative) 629144 629144 Humfrevyle, Gilbert, of Kyme, knight, executor of 0
4852463 2312189 2312189 plaintiff Wayte Thomas   629144 629144 Wayte, Thomas, of Kyme 0
4873374 2318628 2318628 plaintiff Perche John   629144 629144 Perche, John, of Kyme 0
4873376 2318629 2318629 plaintiff Perche John   629144 629144 Perche, John, of Kyme 0
4902415 2327371 2327371 defendant Boteler Isabel widow 629144 629144 Boteler, Isabel, of Kyme, widow 1
4964597 2346316 2346316 defendant Kirketon Robert husbandman 629144 629144 Kirketon, Robert, of Kyme, husbandman 6
4964598 2346316 2346316 defendant Marham Robert husbandman 629144 629144 Marham, Robert, of Kyme, husbandman 7
5095604 2385138 2385138 defendant Lytylbery John laborer 629144 629144 Lytylbery, John, of Kyme, laborer 1
5274279 2437558 2437558 defendant Fryssheney Walter gent 629144 629144 Fryssheney, Walter, of Kyme, gent 0
5274283 2437559 2437559 defendant Lee Nicholas yeoman 629144 629144 Lee, Nicholas, of Kyme, yeoman 1
5274285 2437559 2437559 defendant Fyssher Thomas husbandman 629144 629144 Fyssher, Thomas, of Kyme, husbandman 3
5274286 2437559 2437559 defendant Payntour Simon husbandman 629144 629144 Payntour, Simon, of Kyme, husbandman 4
5352259 2460805 2460805 defendant Croft William yeoman 629144 629144 Croft, William, of Kyme, yeoman 0
5388056 2471644 2471644 defendant Radclyff Christopher gent 629144 629144 Radclyff, Christopher, of Kyme, gent 0
5400686 2475259 2475259 defendant Ratclyff Christopher gent 629144 629144 Ratclyff, Christopher, of Kyme, gent 0
5406701 2476982 2476982 defendant Martyn Robert yeoman 629144 629144 Martyn, Robert, of Kyme, yeoman 4
5414090 2479151 2479151 defendant Radclyff Christopher gent 629144 629144 Radclyff, Christopher, of Kyme, gent 0
5419855 2480853 2480853 defendant (illegible) Robert yeoman 629144 629144 _, Robert, of Kyme, yeoman 4
5427775 2483266 2483266 defendant Ratclyff Christopher gent 629144 629144 Ratclyff, Christopher, of Kyme, gent 0
5430458 2484042 2484042 plaintiff Hewerby William   629144 629144 Hewerby, William, of Kyme, prior 0
5438388 2486413 2486413 defendant Martyn Robert yeoman 629144 629144 Martyn, Robert, of Kyme, yeoman 4
5438478 2486443 2486443 defendant Martyn Robert yeoman 629144 629144 Martyn, Robert, of Kyme, yeoman 4
5446632 2488884 2488884 defendant Ratlyff Christopher gent 629144 629144 Ratlyff, Christopher, of Kyme, gent 0
5459251 2492671 2492671 defendant Radclyff Christofer gent 629144 629144 Radclyff, Christofer, of Kyme, gent 0
5459650 2492802 2492802 plaintiff Hewerby William   629144 629144 Hewerby, William, of Kyme, prior 0
5470901 2496227 2496227 defendant Ratclyff Christopher gent 629144 629144 Ratclyff, Christopher, of Kyme, gent 0
5486275 2500783 2500783 defendant Fryskeney Walter gent 629144 629144 Fryskeney, Walter, of Kyme, gent 0
5570283 2525874 2525874 defendant Taylboys Robert (legal representative) 629144 629144 Taylboys, Robert, of Kyme, knight, executor of 0
5571352 2526182 2526182 plaintiff Tupholme William   629144 629144 (Tupholme, William, of Kyme 1
5629641 2553259 2553259 defendant Knaresburgh John gent 629144 629144 Knaresburgh, John, of Kyme, gent 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);