names

167 rows where place_id = 591698

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605284 1869318 1869318 defendant Stephens William tanner 591698 591698 Stephens, William, of Wymborne Mynster, tanner 0
3617471 1873085 1873085 defendant Houper William hooper 591698 591698 Houper, William, of Wymborne Mynster, hooper 0
3617473 1873085 1873085 defendant Rogyn John weaver 591698 591698 Rogyn, John, of Wymborne Mynster, weaver 2
3644183 1908613 1908613 defendant Kynge Richard mercer 591698 591698 Kynge, Richard, of Wymborne Mynster, mercer 1
3674975 1918204 1918204 defendant Parys Stephen yeoman 591698 591698 Parys, Stephen, of Wymborne Mysnter, yeoman 0
3736821 1937769 1937769 defendant Goodluck William glover 591698 591698 Goodluck, William, of Wymborne Mynster, glover 0
3736822 1937769 1937769 defendant Lovet Richard chapman 591698 591698 Lovet, Richard, of Wymborne Mynster, chapman 1
3773142 1949305 1949305 defendant Gellett Clement dyer 591698 591698 Gellett, Clement, of Wymborne Mynster, dyer 0
3803896 1959131 1959131 defendant Towneley Robert tailor 591698 591698 Towneley, Robert, of Wymborne Mynster, tailor 1
3842953 1971332 1971332 defendant Goste Thomas butcher 591698 591698 Goste, Thomas, of Wymborne Mynster, butcher 0
3855084 1975220 1975220 defendant Goste Thomas butcher 591698 591698 Goste, Thomas, of Wymborne Mynster, butcher 0
3863858 1978088 1978088 defendant Dewey Richard yeoman 591698 591698 Dewey, Richard, of Wymborne Mynster, yeoman 0
3929435 2000188 2000188 defendant Wyllyams Robert tailor 591698 591698 Wyllyams, Robert, of Wymborne Mynster, tailor 0
3957778 2009778 2009778 defendant Foster John butcher 591698 591698 Foster, John, of Wymborne Mynster, butcher 1
3974454 2015640 2015640 defendant Noceter Mathew husbandman 591698 591698 Noceter, Mathew, of Wymborne Mynster, husbandman 1
3999875 2024723 2024723 plaintiff Gaye James mercer 591698 591698 Gaye, James, of Wymborne Mynster, mercer 0
4005263 2026664 2026664 defendant Myles Bartholomew tanner 591698 591698 Myles, Bartholomew, of Wymborne Mynster, tanner 0
4005264 2026664 2026664 defendant Myles Robert tanner 591698 591698 Myles, Robert, of Wymborne Mynster, tanner 1
4008821 2027916 2027916 defendant Haywarde Thomas yeoman 591698 591698 Haywarde, Thomas, of Wymborne Minster, yeoman 0
4008822 2027916 2027916 defendant Foster John yeoman 591698 591698 Foster, John, of Wymborne Minster, yeoman 1
4017921 2031124 2031124 defendant Eterycke William yeoman 591698 591698 Eterycke, William, of Wymborne Mynster, yeoman 0
4017922 2031124 2031124 defendant Eterycke Anthony yeoman 591698 591698 Eterycke, Anthony, of Wymborne Mynster, yeoman 1
4022086 2032629 2032629 defendant Babbe Richard yeoman 591698 591698 Babbe, Richard, of Wymborne Mynser, yeoman 0
4022089 2032630 2032630 defendant Babbe Richard yeoman 591698 591698 Babbe, Richard, of Wymborne Mynster, yeoman 0
4023363 2033065 2033065 defendant Carter John yeoman 591698 591698 Carter, John, of Wymborne Mynster, yeoman, yeoman 1
4023366 2033066 2033066 defendant Carter John   591698 591698 Carter, John, of Wymborne Mynster yeoman 1
4028070 2034689 2034689 defendant Bennett Alecander   591698 591698 Bennett, Alecander, of Wymborne Mynster, yeoman, surgeon 0
4028621 2034882 2034882 defendant Bucke Ralph husbandman 591698 591698 Bucke, Ralph, of Wymborne Mynster, husbandman 0
4029728 2035272 2035272 defendant Barne Philip husbandman or yeoman 591698 591698 Barne, Philip, of Wymborne Mynster, husbandman or yeoman 0
4053014 2043508 2043508 defendant Smythe Robert gent 591698 591698 Smythe, Robert, of Wymborne Mynster, gent 0
4053016 2043509 2043509 defendant Welstede Simon yeoman 591698 591698 Welstede, Simon, of Wymborne Mynster, yeoman 0
4053018 2043510 2043510 defendant Welstede Simon yeoman 591698 591698 Welstede, Simon, of Wymborne Mynster, yeoman 0
4062557 2046901 2046901 defendant Russell Thomas husbandman 591698 591698 (Russell, Thomas, of Wymborne Mynster, husbandman 1
4067660 2048747 2048747 defendant Buddell John husbandman 591698 591698 Buddell, John, of Wymborne Mynster, husbandman 0
4067661 2048747 2048747 defendant Kynge William husbandman 591698 591698 Kynge, William, of Wymborne Mynster, husbandman 1
4067662 2048747 2048747 defendant Savage John husbandman 591698 591698 Savage, John, of Wymborne Mynster, husbandman 2
4067663 2048747 2048747 defendant Clapcote Thomas husbandman 591698 591698 Clapcote, Thomas, of Wymborne Mynster, husbandman 3
4083731 2054453 2054453 defendant Watkins Humphrey gent 591698 591698 Watkins, Humphrey, of Wymborne Mynster, gent 0
4086620 2055502 2055502 defendant Watkyns Humphrey gent 591698 591698 Watkyns, Humphrey, of Wymborne Mynster, gent 1
4095250 2058623 2058623 defendant Colle John innholder 591698 591698 Colle, John, of Wymborne Mynsyer, innholder 0
4096168 2058958 2058958 defendant Fossey Robert clerk 591698 591698 Fossey, Robert, of Wymborne Mynster, clerk 2
4111119 2064232 2064232 defendant Bawrnes Philip or of Bawrishe, yeoman 591698 591698 Bawrnes Philip, of Wymborne Mynster, or of Bawrishe, yeoman 0
4112988 2064914 2064914 defendant Roull Thomas yeoman 591698 591698 Roull, Thomas, of Wymborne Mynster, yeoman 1
4127228 2070031 2070031 defendant Garicke Anthony yeoman 591698 591698 Garicke, Anthony, of Wymborne Minster, yeoman 0
4128577 2070511 2070511 defendant Ettrycke Anthony yeoman 591698 591698 Ettrycke, Anthony, of Wymborne Mynster, yeoman 0
4133077 2072159 2072159 defendant Dallacourte Richard butcher 591698 591698 Dallacourte, Richard, of Wymborne Mynster, butcher 0
4134957 2072822 2072822 defendant Foster John yeoman 591698 591698 Foster, John, of Wymborne Mynster, yeoman 0
4140540 2074858 2074858 defendant Bryne Morgan joiner 591698 591698 Bryne, Morgan, of Wymborne Mynster, joiner 0
4151949 2078791 2078791 defendant Gobye Thomas husbandman 591698 591698 Gobye, Thomas, of Wymborne Mynster, or of Cowgrove, husbandman 0
4151950 2078791 2078791 defendant Russell John husbandman 591698 591698 Russell, John, of Wymborne Mynster, husbandman 1
4154094 2079525 2079525 defendant Gobye Thomas husbandman 591698 591698 Gobye, Thomas, of Wymborne Mynster, husbandman 0
4154096 2079525 2079525 defendant Bryan Morgan joiner 591698 591698 Bryan, Morgan, of Wymborne Mynster, joiner 2
4160252 2081654 2081654 defendant Thorne Robert husbandman 591698 591698 Thorne, Robert, of Wymborne Mynster, husbandman 0
4170157 2085057 2085057 defendant Sampson Richard husbandman 591698 591698 Sampson, Richard, of Wymborne Mynster, husbandman 0
4174098 2086395 2086395 defendant Bugge Thomas yeoman 591698 591698 Bugge, Thomas, of Wymborne Mynster, yeoman 0
4174099 2086395 2086395 defendant Dallacote Richard yeoman 591698 591698 Dallacote, Richard, of Wymborne Mynster, yeoman 1
4175524 2086911 2086911 defendant Macham James tanner 591698 591698 Macham, James, of Wymborne Mynster, tanner 0
4183556 2089732 2089732 defendant Coffyn Henry chapman 591698 591698 Coffyn, Henry, of Wymborne Mynster, chapman 0
4186100 2090625 2090625 defendant Noble John husbandman 591698 591698 Noble, John, of Wymborne Mynster, husbandman 1
4188822 2091569 2091569 defendant Jennynges John, junior yeoman 591698 591698 Jennynges, John, junior, of Wymborne Mynster, yeoman 0
4188823 2091569 2091569 defendant Barnes Philip yeoman 591698 591698 Barnes, Philip, of Wymborne Mynster, yeoman 1
4189390 2091789 2091789 defendant Makerell William husbandman 591698 591698 Makerell, William, of Wymborne Mynster, husbandman 3
4193549 2093311 2093311 defendant Goby Thomas husbandman 591698 591698 Goby, Thomas, of Wymborne Mynster, or of Kingston Lacye, husbandman 0
4199371 2095332 2095332 defendant Dallacote Richard yeoman 591698 591698 Dallacote, Richard, of Wymborne Mynster, yeoman 1
4199744 2095457 2095457 defendant Forreste John yeoman 591698 591698 Forreste, John, of Wymborne Mynster, yeoman 0
4212286 2099843 2099843 defendant Jennyng John, junior yeoman 591698 591698 Jennyng, John, junior, of Wymborne Mynster, yeoman 0
4212287 2099843 2099843 defendant Barnes Philip yeoman 591698 591698 Barnes, Philip, of Wymborne Mynster, yeoman 1
4212536 2099925 2099925 defendant Foster John yeoman 591698 591698 Foster, John, of Wymborne Mynster, yeoman 3
4218455 2101954 2101954 defendant Browne William yeoman 591698 591698 Browne, William, of Wymborne Mynster, yeoman 0
4225569 2104407 2104407 defendant Nicholas John shoemaker 591698 591698 Nicholas, John, of Wymborne Mynster, shoemaker 2
4226438 2104717 2104717 defendant Barns John husbandman 591698 591698 Barns, John, of Wymborne Mynster, husbandman 1
4231205 2106419 2106419 defendant Keate Mary widow 591698 591698 Keate, Mary, of Wymborne Mynster, or of Chesilborne, widow 0
4231206 2106419 2106419 defendant Grove Walter gent 591698 591698 Grove, Walter, of Wymborne Mynster, or of East Coker, gent 1
4231207 2106419 2106419 defendant Keate William gent 591698 591698 Keate, William, of Wymborne Mynster, or of Burgate, Hants, gent 2
4231208 2106419 2106419 defendant Standlye Roger yeoman 591698 591698 Standlye, Roger, of Wymborne Mynster, or of Longe Chessilborne, yeoman 3
4255280 2114756 2114756 defendant Beane William yeoman 591698 591698 Beane, William, of Wymborne Mynster, or of Cricke, Nhants, yeoman 0
4255281 2114756 2114756 defendant Fearbrothers Henry husbandman 591698 591698 Fearbrothers, Henry, of Wymborne Mynster, or of Hilmorton, Warks, husbandman 1
4255283 2114757 2114757 defendant Flamell Henry yeoman 591698 591698 Flamell, Henry, of Wymborne Mynster, or of Willoughby, Warks, yeoman 0
4255284 2114757 2114757 defendant Fawkes John yeoman 591698 591698 Fawkes, John, of Wymborne Mynster, or of Bilton, yeoman 1
4255287 2114758 2114758 defendant Lucas William husbandman 591698 591698 Lucas, William, of Wymborne Mynster, or of Shawell, Leics, husbandman 0
4255288 2114758 2114758 defendant Symons Richard husbandman 591698 591698 Symons, Richard, of Wymborne Mynster, or of Swyneford, husbandman 1
4287395 2125544 2125544 defendant Dashwood William husbandman 591698 591698 Dashwood, William, of Wymborne Mynster, husbandman 1
4289614 2126353 2126353 defendant Wardland Nicholas husbandman 591698 591698 Wardland, Nicholas, of Wymborne, husbandman 0
4291837 2127155 2127155 defendant Laurence Giles schoolmaster 591698 591698 Laurence, Giles, of Wymborne Mynster, schoolmaster 0
4291838 2127155 2127155 defendant Gobbye Thomas husbandman 591698 591698 Gobbye, Thomas, of Wymborne Mynster, or of Kingston Lacye, husbandman 1
4291839 2127155 2127155 defendant Jaye William merchant 591698 591698 Jaye, William, of Wymborne Mynster, chapman, merchant 2
4301726 2130725 2130725 defendant Ellyott John husbandman 591698 591698 Ellyott, John, of Wymborne Mynster, husbandman 0
4302065 2130843 2130843 defendant Wyllyams Morgan gent 591698 591698 Wyllyams, Morgan, of Wymborne Mynster, gent 0
4303051 2131195 2131195 defendant Reves Robert yeoman 591698 591698 Reves, Robert, of Wymborne Mynster, yeoman 0
4305046 2131906 2131906 defendant Dackham Henry gent 591698 591698 Dackham, Henry, of Wymborne Mynster, gent 1
4305049 2131907 2131907 defendant Jennynges John yeoman 591698 591698 Jennynges, John, of Wymborne Mynster, yeoman 1
4305051 2131907 2131907 defendant Cave John yeoman 591698 591698 Cave, John, of Wymborne Mynster, yeoman 3
4305701 2132131 2132131 defendant Sampson Richard plumber 591698 591698 Sampson, Richard, of Wymborne Mynster, plumber 0
4305702 2132131 2132131 defendant Maye John plumpmaker or lead maker 591698 591698 Maye, John, of Wymborne Mynster, plumpmaker or lead maker 1
4306973 2132581 2132581 defendant Wyllyams Morgan innholder 591698 591698 Wyllyams, Morgan, of Wymborne Mynster, innholder 0
4307370 2132713 2132713 defendant Crosse Thomas butcher 591698 591698 Crosse, Thomas, of Wymborne Minster, butcher 0
4307371 2132713 2132713 defendant Crosse Peter glover 591698 591698 Crosse, Peter, of Wymborne Minster, glover 1
4307382 2132718 2132718 defendant Dashewood William yeoman 591698 591698 Dashewood, William, of Wymborne Mynster, yeoman 0
4318910 2136727 2136727 defendant Ryves Robert innholder 591698 591698 Ryves, Robert, of Wymborne Mynster, innholder 0
4331870 2140951 2140951 defendant Wyllyams Morgan vintner 591698 591698 Wyllyams, Morgan, of Wymborne Mynster, vintner 0

Next page

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