names

87 rows where place_id = 594567

✎ 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
3616622 1872828 1872828 defendant Hemmyngburgh William chaplain 594567 594567 Hemmyngburgh, William, of Drax, chaplain 0
3628584 1903813 1903813 defendant Porter John husbandman 594567 594567 Porter, John, of Drax, husbandman 0
3628585 1903813 1903813 defendant Horsfall Richard husbandman 594567 594567 Horsfall, Richard, of Drax, husbandman 1
3636585 1906234 1906234 defendant Frankelyn Thomas yeoman 594567 594567 Frankelyn, Thomas, of Drax, yeoman 0
3678349 1919283 1919283 defendant Saunder Richard miller 594567 594567 Saunder, Richard, of Drax, miller 0
3678350 1919283 1919283 defendant Milner Sybil widow 594567 594567 Milner, Sybil, of Drax, widow 1
3693997 1924324 1924324 defendant Saunder Richard miller 594567 594567 Saunder, Richard, of Drax, miller 0
3693998 1924324 1924324 defendant Milner Sybil widow 594567 594567 Milner, Sybil, of Drax, widow 1
3750831 1942181 1942181 defendant Porter John husbandman 594567 594567 Porter, John, of Drax, husbandman 0
3750832 1942181 1942181 defendant Hervy Richard laborer 594567 594567 Hervy, Richard, of Drax, laborer 1
3750833 1942181 1942181 defendant Bell Margaret widow 594567 594567 Bell, Margaret, of Drax, widow 2
3804912 1959480 1959480 defendant Babthorp Ralph gent 594567 594567 Babthorp, Ralph, of Drax, gent 0
3804915 1959481 1959481 defendant Babthorp Ralph gent 594567 594567 Babthorp, Ralph, of Drax, gent 0
4001645 2025368 2025368 plaintiff Harpam Thomas husbandman 594567 594567 Harpam, Thomas, of Drax, husbandman 0
4001646 2025368 2025368 defendant Babthorpe Guy (legal representative) 594567 594567 Babthorpe, Guy, of Drax, gent, administratrix of 0
4001672 2025376 2025376 plaintiff Harpham Thomas husbandman 594567 594567 Harpham, Thomas, of Drax, husbandman 0
4001673 2025376 2025376 defendant Babthorpe Guy (legal representative) 594567 594567 Babthorpe, Guy, of Drax, gent, administratrix of 0
4041153 2039327 2039327 defendant Batman Edward carpenter 594567 594567 Batman, Edward, of Drax, carpenter 0
4236710 2108413 2108413 defendant Hole John clerk 594567 594567 Hole, John, of Drax, clerk 0
4257231 2115397 2115397 defendant Hole John clerk 594567 594567 Hole, John, of Drax, clerk 0
4270559 2119733 2119733 defendant Adams Edward husbandman 594567 594567 Adams, Edward, of Drax, husbandman 2
4272479 2120370 2120370 defendant Hutton Richard yeoman 594567 594567 Hutton, Richard, of Drax, yeoman 0
4310116 2133692 2133692 defendant Doughtie William yeoman 594567 594567 Doughtie, William, of Drax, yeoman 3
4322334 2137884 2137884 defendant Tunstead Francis gent 594567 594567 Tunstead, Francis, of Drax, gent 0
4395357 2163028 2163028 defendant Watkynsone Edwmund husbandman 594567 594567 Watkynsone, Edwmund, of Drax, husbandman 0
4395359 2163028 2163028 defendant Cumingworth John husbandman 594567 594567 Cumingworth, John, of Drax, husbandman 2
4420962 2171453 2171453 defendant Pacok Geoffrey   594567 594567 Pacok, Geoffrey, of Drax 0
4497250 2199789 2199789 defendant Lely Richard   594567 594567 Lely, Richard, of Drax 0
4518886 2206273 2206273 defendant Burton John   594567 594567 Burton, John, of Drax 0
4527006 2208731 2208731 plaintiff Lely Richard   594567 594567 Lely, Richard, of Drax 0
4530918 2209963 2209963 defendant Watson John smith 594567 594567 Watson, John, of Drax, smith 3
4547977 2215300 2215300 defendant Hemyngburgh Richard   594567 594567 Hemyngburgh, Richard, of Drax 0
4566976 2221233 2221233 defendant Burton Thomas de   594567 594567 Burton, Thomas de, of Drax 0
4577737 2224543 2224543 defendant Lely Richard   594567 594567 Lely, Richard, of Drax 0
4589214 2228009 2228009 defendant Usflete John de   594567 594567 Usflete, John de, of Drax, prior 0
4589215 2228010 2228010 plaintiff Lely Richard   594567 594567 Lely, Richard, of Drax 0
4632376 2241014 2241014 plaintiff Ufflete John   594567 594567 Ufflete, John, of Drax, prior 0
4632378 2241015 2241015 plaintiff Ufflete John   594567 594567 Ufflete, John, of Drax, prior 0
4632381 2241016 2241016 plaintiff (not given) John prior of Ufflete 594567 594567 Ufflete, John, of Drax, prior of St Nicholas 0
4632446 2241038 2241038 plaintiff Usflete John   594567 594567 Usflete, John, of Drax, prior 0
4664612 2250411 2250411 defendant Dene Robert husbandman 594567 594567 Dene, Robert, of Drax, husbandman 1
4664616 2250412 2250412 defendant Dene Robert husbandman 594567 594567 Dene, Robert, of Drax, husbandman 1
4690042 2262437 2262437 defendant Fawenell Robert husbandman 594567 594567 Fawenell, Robert, of Drax, husbandman 0
4690467 2262578 2262578 defendant Usflete John another canon in the priory 594567 594567 Usflete, John, of Drax, another canon in the priory 1
4694702 2263839 2263839 defendant Falas John   594567 594567 Falas, John, of Drax, servant or serjeant at arms for the King 0
4745665 2279245 2279245 plaintiff Denny Hugh   594567 594567 Denny, Hugh, of Drax, wright 1
4745666 2279245 2279245 defendant Folvyll Richard yeoman 594567 594567 Folvyll, Richard, of Drax, yeoman 0
4745667 2279245 2279245 defendant Folvyll John husbandman 594567 594567 Folvyll, John, of Drax, husbandman 1
4761332 2283886 2283886 defendant Wyghton Thomas laborer 594567 594567 Wyghton, Thomas, of Drax, laborer 1
4769989 2286584 2286584 defendant Fenkyll William husbandman 594567 594567 Fenkyll, William, of Drax, husbandman 5
4853607 2312544 2312544 defendant Torald John gent 594567 594567 Torald, John, of Drax, gent 0
4878728 2320284 2320284 defendant Catryk John   594567 594567 Catryk, John, of Drax, wright 7
4896738 2325639 2325639 defendant Marsshall Robert chaplain 594567 594567 Marsshall, Robert, of Drax, chaplain 8
4970348 2348080 2348080 defendant Torcliff John draper 594567 594567 Torcliff, John, of Drax, draper 2
4970350 2348080 2348080 defendant Croule William yeoman 594567 594567 Croule, William, of Drax, yeoman 4
5001569 2357351 2357351 defendant Hobson Thomas husbandman 594567 594567 Hobson, Thomas, of Drax, husbandman 0
5080068 2380521 2380521 defendant Arnold John husbandman 594567 594567 Arnold, John, of Drax, husbandman 1
5096908 2385526 2385526 defendant Freir John husbandman 594567 594567 Freir, John, of Drax, husbandman 0
5096909 2385526 2385526 defendant Pyper John laborer 594567 594567 Pyper, John, of Drax, laborer 1
5096911 2385526 2385526 defendant Olyver John laborer 594567 594567 Olyver, John, of Drax, laborer 3
5096912 2385526 2385526 defendant Hadilsay Richard weaver 594567 594567 Hadilsay, Richard, of Drax, weaver 4
5130823 2395498 2395498 defendant ap Thomas Thomas yeoman 594567 594567 ap Thomas, Thomas, of Drax, yeoman 0
5130825 2395498 2395498 defendant Cherryholm Richard husbandman 594567 594567 Cherryholm, Richard, of Drax, husbandman 2
5130826 2395498 2395498 defendant Blaunchard John husbandman 594567 594567 Blaunchard, John, of Drax, husbandman 3
5130827 2395498 2395498 defendant Arnold John yeoman 594567 594567 Arnold, John, of Drax, yeoman 4
5130834 2395500 2395500 defendant Hembrugh William husbandman 594567 594567 Hembrugh, William, of Drax, husbandman 0
5130838 2395500 2395500 defendant Ward John, junior husbandman 594567 594567 Ward, John, junior, of Drax, husbandman 4
5137557 2397499 2397499 defendant Arnald John butcher 594567 594567 Arnald, John, of Drax, butcher 0
5150245 2401205 2401205 defendant Arnold John yeoman 594567 594567 Arnold, John, of Drax, yeoman 0
5150247 2401206 2401206 defendant Arnold John yeoman 594567 594567 Arnold, John, of Drax, yeoman 0
5150254 2401208 2401208 defendant Hemburgh William husbandman 594567 594567 Hemburgh, William, of Drax, husbandman 0
5369179 2465961 2465961 defendant Hobson Thomas husbandman 594567 594567 Hobson, Thomas, of Drax, husbandman 1
5391493 2472639 2472639 defendant Arnad William   594567 594567 Arnad, William, of Drax, parish clerk 0
5397294 2474309 2474309 plaintiff Bukkyll William   594567 594567 Bukkyll, William, of Drax 0
5397295 2474309 2474309 plaintiff Miller (illegible)   594567 594567 Miller, -----, of Drax, parish clerk 1
5420715 2481119 2481119 defendant Bukkyll William   594567 594567 Bukkyll, William, of Drax, cook 0
5420716 2481119 2481119 defendant Milner John   594567 594567 Milner, John, of Drax, parish clerk 1
5439600 2486781 2486781 defendant Bukkyll William   594567 594567 Bukkyll, William, of Drax, cook 0
5439601 2486781 2486781 defendant Milner John   594567 594567 Milner, John, of Drax, parish clerk 1
5439603 2486782 2486782 defendant Bukkyll William   594567 594567 Bukkyll, William, of Drax, cook 0
5439604 2486782 2486782 defendant Mioner John   594567 594567 Mioner, John, of Drax, parish clerk 1
5484100 2500179 2500179 defendant Hoberd John yeoman 594567 594567 Hoberd, John, of Drax, yeoman 4
5515810 2509791 2509791 defendant Pereson John husbandman 594567 594567 Pereson, John, of Drax, husbandman 0
5536235 2515826 2515826 defendant Thex Thomas laborer 594567 594567 Thex, Thomas, of Drax, laborer 4
5568939 2525466 2525466 defendant Spence Geoffrey yeoman 594567 594567 Spence, Geoffrey, of Drax, yeoman 0
5600464 2535029 2535029 defendant Baxster John yeoman 594567 594567 (Baxster, John, of Drax, yeoman 1
5616013 2548803 2548803 defendant Laurence John   594567 594567 Laurence, John, of Drax 3

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