names

69 rows where place_id = 591088

✎ 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
3603292 1868702 1868702 defendant Happer Henry husbandman 591088 591088 Happer, Henry, of Bosham, husbandman 0
3603294 1868703 1868703 defendant Harper Henry husbandman 591088 591088 Harper, Henry, of Bosham, husbandman 0
3603335 1868717 1868717 defendant Harper Henry husbandman 591088 591088 Harper, Henry, of Bosham, husbandman 0
3709673 1929336 1929336 defendant Martyn William clerk 591088 591088 Martyn, William, of Bosham, clerk 1
4174974 2086714 2086714 defendant Foster William yeoman 591088 591088 Foster, William, of Bosham, yeoman 0
4174978 2086715 2086715 defendant Foster William yeoman 591088 591088 Foster, William, of Bosham, yeoman 0
4219669 2102384 2102384 defendant Felder Thomas husbandman 591088 591088 Felder, Thomas, of Bosham, husbandman 0
4230400 2106125 2106125 defendant Foster William husbandman 591088 591088 Foster, William, of Bosham, husbandman 3
4257991 2115642 2115642 defendant Felder Thomas husbandman 591088 591088 Felder, Thomas, of Bosham, husbandman 0
4360948 2151088 2151088 defendant Hyldropp William yeoman 591088 591088 Hyldropp, William, of Bosham, yeoman 0
4512452 2204336 2204336 defendant Andrewe Roger   591088 591088 Andrewe, Roger, of Bosham 0
4513300 2204575 2204575 defendant Andrewe Roger   591088 591088 Andrewe, Roger, of Bosham 2
4526898 2208692 2208692 defendant Andrewe Roger   591088 591088 Andrewe, Roger, of Bosham 0
4546588 2214862 2214862 defendant Andrewe Robert   591088 591088 Andrewe, Robert, of Bosham 0
4549547 2215805 2215805 defendant Yettere William   591088 591088 Yettere, William, of Bosham 0
4579462 2225055 2225055 defendant Smyth alias Pope Nicholas   591088 591088 Smyth alias Pope, Nicholas, of Bosham 0
4579463 2225055 2225055 defendant Nonyngton William   591088 591088 Nonyngton, William, of Bosham 1
4585406 2226858 2226858 defendant Spencer Richard   591088 591088 Spencer, Richard, of Bosham 2
4601624 2231724 2231724 defendant Daunger John   591088 591088 Daunger, John, of Bosham 0
4606470 2233135 2233135 defendant Nonyngton William   591088 591088 Nonyngton, William, of Bosham 1
4606476 2233136 2233136 defendant Nonyngton William   591088 591088 Nonyngton, William, of Bosham 1
4606895 2233266 2233266 plaintiff Barton Thomas   591088 591088 Barton, Thomas, of Bosham, prebendary of the prebend 0
4606896 2233266 2233266 defendant Kippyng John (legal representative) 591088 591088 Kippyng, John, of Bosham, executors of 0
4618295 2236732 2236732 defendant Andrewe Roger   591088 591088 Andrewe, Roger, of Bosham 0
4618298 2236733 2236733 defendant Andrewe Roger   591088 591088 Andrewe, Roger, of Bosham 0
4671495 2256730 2256730 defendant Scutte John husbandman 591088 591088 Scutte, John, of Bosham, husbandman 0
4728156 2274054 2274054 defendant Paffey William husbandman 591088 591088 Paffey, William, of Bosham, husbandman 1
4728160 2274055 2274055 defendant Paffey William husbandman 591088 591088 Paffey, William, of Bosham, husbandman 1
4732293 2275278 2275278 defendant Syteler Henry weaver 591088 591088 Syteler, Henry, of Bosham, weaver 1
4732299 2275279 2275279 defendant Syteler Henry weaver 591088 591088 Syteler, Henry, of Bosham, weaver 1
4742822 2278407 2278407 defendant Pope John husbandman 591088 591088 Pope, John, of Bosham, husbandman 0
4766056 2285375 2285375 plaintiff Kynwolmerssh William (legal representative) 591088 591088 Kynwolmerssh, William, of Bosham, prebendary of the prebend of Walton, in the King's free chapel, executors of 0
4766064 2285376 2285376 plaintiff Kynwolmerssh William (legal representative) 591088 591088 Kynwolmerssh, William, of Bosham, prebendary of the prebend of Walton, in the King's free chapel, executors of 0
4787712 2292226 2292226 defendant Smyth John husbandman 591088 591088 Smyth, John, of Bosham, husbandman 0
4833069 2306361 2306361 defendant Feldere Richard husbandman 591088 591088 Feldere, Richard, of Bosham, husbandman 0
4833072 2306362 2306362 defendant Prymer Peter husbandman 591088 591088 Prymer, Peter, of Bosham, husbandman 1
4843333 2309432 2309432 defendant (not given) John vicar of Penycook 591088 591088 Penycook, John, of Bosham, chaplain alias vicar of Aldyngbourne 0
4845698 2310167 2310167 defendant Scutte William husbandman 591088 591088 Scutte, William, of Bosham, husbandman 2
4951580 2342453 2342453 plaintiff Pyrs Richard   591088 591088 Pyrs, Richard, of Bosham, husbandman, executors, of 0
4959009 2344660 2344660 defendant Markewyke William yeoman 591088 591088 Markewyke, William, of Bosham, yeoman 0
4978589 2350547 2350547 defendant Rose Thomas husbandman 591088 591088 Rose, Thomas, of Bosham, husbandman 0
5021296 2363132 2363132 defendant Clerk William mariner 591088 591088 Clerk, William, of Bosham, mariner 0
5024014 2363934 2363934 defendant Maddok Henry husbandman 591088 591088 Maddok, Henry, of Bosham, husbandman 0
5024612 2364111 2364111 defendant Melward Thomas   591088 591088 Melward, Thomas, of Bosham, millward 1
5031979 2366225 2366225 defendant Markewyke William yeoman 591088 591088 Markewyke, William, of Bosham, yeoman 1
5032144 2366275 2366275 defendant Maddok Henry husbandman 591088 591088 Maddok, Henry, of Bosham, husbandman 0
5044563 2370006 2370006 defendant Markwyke William husbandman 591088 591088 Markwyke, William, of Bosham, husbandman 0
5045592 2370312 2370312 defendant Yettere alias Maddok Henry husbandman 591088 591088 Yettere alias Maddok, Henry, of Bosham, husbandman 0
5092890 2384303 2384303 defendant Peek Robert clerk 591088 591088 Peek, Robert, of Bosham, clerk 0
5092891 2384303 2384303 defendant Forster Robert laborer 591088 591088 Forster, Robert, of Bosham, laborer 1
5105125 2387934 2387934 defendant Markwyk William husbandman 591088 591088 Markwyk, William, of Bosham, husbandman 0
5105126 2387934 2387934 defendant Maddok Henry husbandman 591088 591088 Maddok, Henry, of Bosham, husbandman 1
5111376 2389719 2389719 defendant Tele Richard husbandman 591088 591088 Tele, Richard, of Bosham, husbandman 1
5147656 2400452 2400452 plaintiff Coke William (legal representative) 591088 591088 Coke, William, of Bosham, executrix of 0
5167270 2406158 2406158 plaintiff Coke William (legal representative) 591088 591088 Coke, William, of Bosham, executrix of 0
5283848 2440308 2440308 defendant Rudby John clerk 591088 591088 Rudby, John, of Bosham, clerk 1
5298546 2444550 2444550 defendant Vantort Thomas husbandman 591088 591088 Vantort, Thomas, of Bosham, husbandman 0
5373168 2467206 2467206 defendant Peryng Richard husbandman 591088 591088 Peryng, Richard, of Bosham, husbandman 1
5373169 2467206 2467206 defendant Neweman John husbandman & parish clerk 591088 591088 Neweman, John, of Bosham, husbandman & parish clerk 2
5390235 2472270 2472270 defendant Peryng Richard husbandman 591088 591088 Peryng, Richard, of Bosham, husbandman 1
5390236 2472270 2472270 defendant Neuman John yeoman & parish clerk 591088 591088 Neuman, John, of Bosham, yeoman & parish clerk 2
5432731 2484754 2484754 defendant Peryng Richard husbandman 591088 591088 Peryng, Richard, of Bosham, husbandman 1
5432732 2484754 2484754 defendant Newman John yeoman & parish clerk 591088 591088 Newman, John, of Bosham, yeoman & parish clerk 2
5441122 2487255 2487255 defendant Peryng Richard   591088 591088 Peryng, Richard, of Bosham 1
5441123 2487255 2487255 defendant Neuman John   591088 591088 Neuman, John, of Bosham, parish clerk 2
5523872 2512291 2512291 defendant Legard John husbandman 591088 591088 Legard, John, of Bosham, husbandman 0
5591835 2532432 2532432 defendant Wodland William husbandman 591088 591088 Wodland, William, of Bosham, husbandman 0
5625626 2551957 2551957 defendant Cokyrke John yeoman 591088 591088 Cokyrke, John, of Bosham, yeoman 1
5625627 2551957 2551957 defendant Kyppyng John husbandman 591088 591088 Kyppyng, John, of Bosham, husbandman 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);