names

56 rows where place_id = 598591

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633241 1905212 1905212 defendant Hardyng John butcher 598591 598591 Hardyng, John, of Magna Missenden, butcher 0
3639406 1907134 1907134 defendant Shrympton John husbandman 598591 598591 Shrympton, John, of Magna Missenden, husbandman 2
3712694 1930286 1930286 defendant Penley Richard weaver 598591 598591 Penley, Richard, of Magna Missenden, weaver 2
3717695 1931830 1931830 defendant Hykeman Henry husbandman 598591 598591 Hykeman, Henry, of Magna Missenden, husbandman 0
3746117 1940695 1940695 defendant Gardener John gent 598591 598591 Gardener, John, of Magna Missenden, gent 0
3775022 1949921 1949921 defendant Lerimer William tailor 598591 598591 Lerimer, William, of Magna Missenden, tailor 2
3792361 1955471 1955471 defendant Bennyng Henry yeoman 598591 598591 Bennyng, Henry, of Magna Missenden, yeoman 0
3792362 1955471 1955471 defendant Wodward Robert yeoman 598591 598591 Wodward, Robert, of Magna Missenden, yeoman 1
3792363 1955471 1955471 defendant Gardener Drew gent 598591 598591 Gardener, Drew, of Magna Missenden, gent 2
3792690 1955567 1955567 defendant Lorymer William tailor 598591 598591 Lorymer, William, of Magna Missenden, tailor 2
3797252 1957026 1957026 defendant Baldwyn Hugh husbandman 598591 598591 Baldwyn, Hugh, of Magna Missenden, husbandman 0
3797254 1957027 1957027 defendant Baldwyn Hugh husbandman 598591 598591 Baldwyn, Hugh, of Magna Missenden, husbandman 0
3809238 1960769 1960769 defendant Lorymer William tailor 598591 598591 Lorymer, William, of Magna Missenden, tailor 2
3814266 1962369 1962369 defendant Hewes William butcher 598591 598591 Hewes, William, of Magna Missenden, butcher 2
3825377 1965787 1965787 defendant Felowe Andrew tailor 598591 598591 Felowe, Andrew, of Magna Missenden, tailor 0
3825475 1965816 1965816 defendant Baldwyn Hugh husbandman 598591 598591 Baldwyn, Hugh, of Magna Missenden, husbandman 1
3827667 1966514 1966514 defendant Tayllour Thomas wheeler 598591 598591 Tayllour, Thomas, of Magna Missenden, wheeler 0
3855257 1975279 1975279 defendant Petyfer Giles weaver 598591 598591 Petyfer, Giles, of Magna Missenden, weaver 1
3855258 1975279 1975279 defendant Ventrys Robert husbandman 598591 598591 Ventrys, Robert, of Magna Missenden, husbandman 2
3856585 1975685 1975685 defendant Knyght alias Hore William carpenter 598591 598591 Knyght alias Hore, William, of Magna Missenden, carpenter 2
3859904 1976817 1976817 defendant North Robert, junior husbandman 598591 598591 North, Robert, junior, of Magna Missenden, husbandman 2
3874122 1981568 1981568 defendant Brampston Giles yeoman 598591 598591 Brampston, Giles, of Magna Missenden, yeoman 2
3898686 1989767 1989767 defendant Lantte Robert laborer 598591 598591 Lantte, Robert, of Magna Missenden, laborer 0
3918938 1996655 1996655 defendant North Robert husbandman 598591 598591 North, Robert, of Magna Missenden, husbandman 0
3918939 1996655 1996655 defendant Cock John husbandman 598591 598591 Cock, John, of Magna Missenden, husbandman 1
3918940 1996655 1996655 defendant Broke William mercer 598591 598591 Broke, William, of Magna Missenden, mercer 2
4118022 2066729 2066729 defendant Hygg Nicholas yeoman 598591 598591 Hygg, Nicholas, of Magna Missenden, yeoman 0
4118023 2066729 2066729 defendant Ryce Henry laborer 598591 598591 Ryce, Henry, of Magna Missenden, laborer 1
4166299 2083706 2083706 defendant Hitchcock Thomas laborer 598591 598591 Hitchcock, Thomas, of Magna Missenden, laborer 1
4218858 2102090 2102090 defendant Metcalfe Christopher   598591 598591 Metcalfe, Christopher, of Magna Missenden clerk 0
4219418 2102292 2102292 defendant Lane Richard mercer 598591 598591 Lane, Richard, of Magna Missenden, mercer 0
4266035 2118279 2118279 defendant Hollas William   598591 598591 Hollas, William, of Magna Missenden, wheelwright 2
4905732 2328394 2328394 defendant Longe John, senior wheeler 598591 598591 Longe, John, senior, of Magna Missenden, wheeler 0
4905733 2328394 2328394 defendant Chyld Thomas husbandman 598591 598591 Chyld, Thomas, of Magna Missenden, husbandman 1
4905735 2328394 2328394 defendant Attefeld Thomas wheeler 598591 598591 Attefeld, Thomas, of Magna Missenden, wheeler 3
5232235 2425006 2425006 defendant Gery Henry butcher 598591 598591 Gery, Henry, of Magna Missenden, butcher 0
5232236 2425006 2425006 defendant Smyth John husbandman 598591 598591 Smyth, John, of Magna Missenden, husbandman 1
5232237 2425006 2425006 defendant Pleytoure John husbandman 598591 598591 Pleytoure, John, of Magna Missenden, husbandman 2
5232238 2425006 2425006 defendant Widmare William ironmonger 598591 598591 Widmare, William, of Magna Missenden, ironmonger 3
5232239 2425006 2425006 defendant Hoberd William yeoman 598591 598591 Hoberd, William, of Magna Missenden, yeoman 4
5236941 2426387 2426387 defendant Pranke Simon carpenter 598591 598591 Pranke, Simon, of Magna Missenden, carpenter 1
5240256 2427357 2427357 defendant Wydmer John husbandman 598591 598591 Wydmer, John, of Magna Missenden, husbandman 0
5251572 2430598 2430598 defendant Playter John btcher 598591 598591 Playter, John, of Magna Missenden, btcher 0
5290871 2442337 2442337 defendant Bysshop John laborer 598591 598591 Bysshop, John, of Magna Missenden, laborer 0
5292603 2442833 2442833 defendant Dalton John yeoman 598591 598591 Dalton, John, of Magna Missenden, yeoman 0
5313355 2449033 2449033 defendant Honer Simon maltman 598591 598591 Honer, Simon, of Magna Missenden, maltman 0
5354843 2461593 2461593 defendant Smyth Isabel widow 598591 598591 Smyth, Isabel, of Magna Missenden, widow 0
5354844 2461593 2461593 defendant Smyth John chapman 598591 598591 Smyth, John, of Magna Missenden, chapman 1
5480744 2499203 2499203 defendant Gery William yeoman 598591 598591 Gery, William, of Magna Missenden, yeoman 0
5480745 2499203 2499203 defendant arnold Thomas husbandman 598591 598591 arnold, Thomas, of Magna Missenden, husbandman 1
5564292 2524169 2524169 defendant Hardyng John butcher 598591 598591 Hardyng, John, of Magna Missenden, butcher 2
5569557 2525661 2525661 defendant Pratt William husbandman 598591 598591 Pratt, William, of Magna Missenden, husbandman 0
5569558 2525661 2525661 defendant Munke John yeoman 598591 598591 Munke, John, of Magna Missenden, yeoman 1
5589239 2531640 2531640 defendant Houcy or Honcy Henry yeoman 598591 598591 Houcy or Honcy, Henry, of Magna Missenden, yeoman 0
5599077 2534593 2534593 defendant Sely Giles shoemaker 598591 598591 Sely, Giles, of Magna Missenden, shoemaker 0
5605659 2536652 2536652 defendant Ingylsan Thomas barber 598591 598591 Ingylsan, Thomas, of Magna Missenden, barber 2

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