names

81 rows where place_id = 588531

✎ 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
3594833 1866013 1866013 defendant Dirrant William clerk 588531 588531 Dirrant, William, of Boseham, clerk 1
3594836 1866014 1866014 defendant Dyrrant William clerk 588531 588531 Dyrrant, William, of Boseham, clerk 1
3594843 1866016 1866016 defendant Dyrrant William clerk 588531 588531 Dyrrant, William, of Boseham, clerk 1
3611702 1871322 1871322 defendant Markewyke William husbandman 588531 588531 Markewyke, William, of Boseham, husbandman 1
3689752 1922952 1922952 defendant Fuller Thomas yeoman 588531 588531 Fuller, Thomas, of Boseham, yeoman 0
3714483 1930826 1930826 defendant Fuller Thomas husbandman 588531 588531 Fuller, Thomas, of Boseham, husbandman 0
3714484 1930826 1930826 defendant Furnes William husbandman 588531 588531 Furnes, William, of Boseham, husbandman 1
3729177 1935375 1935375 defendant Wakford Thomas yeoman 588531 588531 Wakford, Thomas, of Boseham, yeoman 1
3729178 1935375 1935375 defendant Coterey Peter yeoman 588531 588531 Coterey, Peter, of Boseham, yeoman 2
3747819 1941239 1941239 defendant Fuller Thomas yeoman 588531 588531 Fuller, Thomas, of Boseham, yeoman 0
4225243 2104296 2104296 defendant Bryan William husbandman 588531 588531 Bryan, William, of Boseham, husbandman 0
4374458 2155935 2155935 defendant Napper Thomas yeoman 588531 588531 Napper, Thomas, of Boseham, yeoman 0
4374460 2155935 2155935 defendant Trymlett William husbandman 588531 588531 Trymlett, William, of Boseham, husbandman 2
4546597 2214864 2214864 defendant Cokwell John   588531 588531 Cokwell, John, of Boseham 1
4546603 2214864 2214864 defendant Pope Nicholas   588531 588531 Pope, Nicholas, of Boseham 7
4546604 2214864 2214864 defendant Bampton William   588531 588531 Bampton, William, of Boseham 8
4568976 2221882 2221882 defendant Milleward Simon   588531 588531 Milleward, Simon, of Boseham 2
4606902 2233267 2233267 defendant (not given) John vicar of Yonge 588531 588531 Yonge, John, of Boseham, vicar of the King's free chapel 0
4661861 2249557 2249557 defendant Stokke Walter husbandman 588531 588531 Stokke, Walter, of Boseham, husbandman 0
4664764 2250459 2250459 defendant Tremylet Robert clerk 588531 588531 Tremylet, Robert, of Boseham, clerk 1
4664769 2250460 2250460 defendant Tremylet Robert clerk 588531 588531 Tremylet, Robert, of Boseham, clerk 1
4664773 2250461 2250461 defendant Skardevile John esq 588531 588531 Skardevile, John, of Boseham, esq 0
4664774 2250461 2250461 defendant Nonyngton William husbandman 588531 588531 Nonyngton, William, of Boseham, husbandman 1
4664775 2250461 2250461 defendant Primer John husbandman 588531 588531 Primer, John, of Boseham, husbandman 2
4664776 2250461 2250461 defendant Milward Gilbert husbandman 588531 588531 Milward, Gilbert, of Boseham, husbandman 3
4664777 2250461 2250461 defendant Romyn John husbandman 588531 588531 Romyn, John, of Boseham, husbandman 4
4664778 2250461 2250461 defendant Brigger Robert husbandman 588531 588531 Brigger, Robert, of Boseham, husbandman 5
4664779 2250461 2250461 defendant Daunger John husbandman 588531 588531 Daunger, John, of Boseham, husbandman 6
4664781 2250462 2250462 defendant Skardevile John esq 588531 588531 Skardevile, John, of Boseham, esq 0
4664782 2250462 2250462 defendant Nonyngton William husbandman 588531 588531 Nonyngton, William, of Boseham, husbandman 1
4664783 2250462 2250462 defendant Primer John husbandman 588531 588531 Primer, John, of Boseham, husbandman 2
4664784 2250462 2250462 defendant Milward Gilbert husbandman 588531 588531 Milward, Gilbert, of Boseham, husbandman 3
4664785 2250462 2250462 defendant Romyn John husbandman 588531 588531 Romyn, John, of Boseham, husbandman 4
4664786 2250462 2250462 defendant Brygger Robert husbandman 588531 588531 Brygger, Robert, of Boseham, husbandman 5
4664787 2250462 2250462 defendant Daunger John husbandman 588531 588531 Daunger, John, of Boseham, husbandman 6
4680190 2259413 2259413 defendant Whytston John husbandman 588531 588531 Whytston, John, of Boseham, husbandman 0
4732304 2275280 2275280 defendant Nonyngton William husbandman 588531 588531 Nonyngton, William, of Boseham, husbandman 0
4734227 2275883 2275883 defendant Nonyngton John   588531 588531 Nonyngton, John, of Boseham, laborer, son of William 0
4734228 2275883 2275883 defendant Nonyngton William   588531 588531 Nonyngton, William, of Boseham, laborer, son of William 1
4734234 2275884 2275884 defendant Nonyngton William husbandman 588531 588531 Nonyngton, William, of Boseham, husbandman 0
4734235 2275884 2275884 defendant Prymer alias Hamme Peter yeoman 588531 588531 Prymer alias Hamme, Peter, of Boseham, yeoman 1
4734241 2275885 2275885 defendant Nonyngton William husbandman & pinner 588531 588531 Nonyngton, William, of Boseham, husbandman & pinner 0
4754485 2281783 2281783 defendant Tremelet Alexander husbandman 588531 588531 Tremelet, Alexander, of Boseham, husbandman 0
4754486 2281783 2281783 defendant Kyppyng John husbandman 588531 588531 Kyppyng, John, of Boseham, husbandman 1
4796238 2294972 2294972 defendant Nonyngton William husbandman 588531 588531 Nonyngton, William, of Boseham, husbandman 0
4796239 2294972 2294972 defendant Prymer alias Hamme Peter husbandman 588531 588531 Prymer alias Hamme, Peter, of Boseham, husbandman 1
4829466 2305257 2305257 defendant Nonyngton John husbandman 588531 588531 Nonyngton, John, of Boseham, husbandman 1
4829468 2305257 2305257 defendant Mafay Alice widow 588531 588531 Mafay, Alice, of Boseham, widow 3
4910162 2329702 2329702 plaintiff Bette Bartholomew husbandman 588531 588531 Bette, Bartholomew, of Boseham, husbandman 0
4922189 2333354 2333354 defendant Merkwys William husbandman 588531 588531 Merkwys, William, of Boseham, husbandman 0
4964197 2346195 2346195 defendant Markewyk William husbandman 588531 588531 Markewyk, William, of Boseham, husbandman 0
4964198 2346195 2346195 defendant Alysaundre Thomas husbandman 588531 588531 Alysaundre, Thomas, of Boseham, husbandman 1
5029549 2365511 2365511 defendant Markwyk William yeoman 588531 588531 Markwyk, William, of Boseham, yeoman 0
5066327 2376456 2376456 defendant Mekisborgh Richard yeoman 588531 588531 Mekisborgh, Richard, of Boseham, yeoman 1
5085916 2382273 2382273 defendant Bere Richard weaver 588531 588531 Bere, Richard, of Boseham, weaver 0
5094947 2384933 2384933 defendant Croftevyle Richard seaman 588531 588531 Croftevyle, Richard, of Boseham, seaman 0
5094948 2384933 2384933 defendant Sly William, senior husbandman 588531 588531 Sly, William, senior, of Boseham, husbandman 1
5094949 2384933 2384933 defendant Sly William, junior husbandman 588531 588531 Sly, William, junior, of Boseham, husbandman 2
5094950 2384933 2384933 defendant Ferrour orSmith Richard laborer 588531 588531 Ferrour orSmith, Richard, of Boseham, laborer 3
5094951 2384933 2384933 defendant Bette Thomas butcher 588531 588531 Bette, Thomas, of Boseham, butcher 4
5122090 2392879 2392879 defendant Didlyng William laborer 588531 588531 Didlyng, William, of Boseham, laborer 0
5122091 2392879 2392879 defendant Forster John husbandman 588531 588531 Forster, John, of Boseham, husbandman 1
5122093 2392880 2392880 defendant Fylder Thomas husbandman 588531 588531 Fylder, Thomas, of Boseham, husbandman 0
5135130 2396773 2396773 plaintiff Maddok Henry   588531 588531 Maddok, Henry, of Boseham 0
5135131 2396773 2396773 defendant Tremelet Robert husbandman 588531 588531 Tremelet, Robert, of Boseham, husbandman 0
5135133 2396773 2396773 defendant (illegible)   mariner 588531 588531 ----, of Boseham, mariner 2
5155224 2402676 2402676 plaintiff Maddok Henry   588531 588531 Maddok, Henry, of Boseham 0
5155226 2402676 2402676 defendant Feldare Thomas mariner 588531 588531 Feldare, Thomas, of Boseham, mariner 1
5172771 2407766 2407766 defendant Nonnyngton William yeoman 588531 588531 Nonnyngton, William, of Boseham, yeoman 1
5220339 2421646 2421646 defendant Nonyngton William husbandman 588531 588531 Nonyngton, William, of Boseham, husbandman 0
5276063 2438072 2438072 defendant Markwyk William yeoman 588531 588531 Markwyk, William, of Boseham, yeoman 0
5322000 2451648 2451648 defendant Markwyk William yeoman 588531 588531 Markwyk, William, of Boseham, yeoman 0
5322003 2451649 2451649 defendant Markwyk William yeoman 588531 588531 Markwyk, William, of Boseham, yeoman 0
5326830 2453098 2453098 defendant Markewyke William yeoman 588531 588531 Markewyke, William, of Boseham, yeoman 0
5465494 2494587 2494587 defendant Brainston Thomas yeoman 588531 588531 Brainston, Thomas, of Boseham, yeoman 0
5465495 2494587 2494587 defendant Harper Henry husbandman 588531 588531 Harper, Henry, of Boseham, husbandman 1
5539575 2516857 2516857 defendant Markewyk Richard laborer 588531 588531 Markewyk, Richard, of Boseham, laborer 0
5624201 2551515 2551515 defendant Scardeville John esq 588531 588531 Scardeville, John, of Boseham, esq 1
5624980 2551745 2551745 defendant Skardeville John esq 588531 588531 Skardeville, John, of Boseham, esq 1
5628067 2552748 2552748 defendant Gybbes John husbandman 588531 588531 Gybbes, John, of Boseham, husbandman 1
5636561 2555380 2555380 defendant Prymer John husbandman 588531 588531 Prymer, John, of Boseham, husbandman 0

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