names

1,295 rows where place_id = 755389

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4427880 2173560 2173560 plaintiff Snoryng William de   755389 755389 Snoryng, William de, of Bishop's Lenn 0
4429474 2174017 2174017 defendant Paynol Thomas   755389 755389 Paynol, Thomas, of Bishop's Lenn, burgess 0
4435020 2175716 2175716 defendant Fote Stephen   755389 755389 Fote, Stephen, of Bishop's Lenn 0
4435023 2175717 2175717 defendant Note or Pote Stephen   755389 755389 Note or Pote, Stephen, of Bishop's Lenn 0
4436798 2176250 2176250 defendant Catfeld Thomas de   755389 755389 Catfeld, Thomas de, of Bishop's Lenn, son of Thomas 0
4436803 2176251 2176251 defendant Catfeld Thomas de   755389 755389 Catfeld, Thomas de, of Bishop's Lenn, son of Thomas 0
4437449 2176462 2176462 plaintiff Wesenham John de merchant 755389 755389 Wesenham, John de, of Bishop's Lenn, merchant 0
4437976 2181196 2181196 plaintiff Algerkirke Robert de   755389 755389 Algerkirke, Robert de, of Bishop's Lenn 0
4439571 2181640 2181640 defendant Drewe John   755389 755389 Drewe, John, of Bishop's Lenn, son of Thomas 0
4440050 2181814 2181814 defendant Selesden William   755389 755389 Selesden, William, of Bishop's Lenn 0
4440052 2181814 2181814 defendant Clerk Adam   755389 755389 Clerk, Adam, of Bishop's Lenn 2
4445007 2183414 2183414 plaintiff Cornyssh Henry glover 755389 755389 Cornyssh, Henry, of Bishop's Lenn, glover 0
4445324 2183486 2183486 defendant Sherman Philip   755389 755389 Sherman, Philip, of Bishop's Lenn 0
4446471 2183812 2183812 plaintiff (not given) John prior of Delgate or Belgate 755389 755389 Delgate or Belgate, John, of Bishop's Lenn, brother & prior of the fraternity of the order of St Augustine 0
4446475 2183813 2183813 plaintiff (not given) John prior of Delgate 755389 755389 Delgate, John, of Bishop's Lenn, prior of the order of St Augustine 0
4446858 2183934 2183934 defendant Sadeler John   755389 755389 Sadeler, John, of Bishop's Lenn 0
4448674 2184518 2184518 plaintiff Frythe John   755389 755389 Frythe, John, of Bishop's Lenn 0
4454905 2186547 2186547 defendant Horsse Robert   755389 755389 Horsse, Robert, of Bishop's Lenn 0
4454909 2186548 2186548 defendant Hors Robert   755389 755389 Hors, Robert, of Bishop's Lenn 0
4461095 2188547 2188547 defendant Sadler John   755389 755389 Sadler, John, of Bishop's Lenn 1
4462518 2188973 2188973 plaintiff Baillye William   755389 755389 Baillye, William, of Bishop's Lenn 2
4465395 2189850 2189850 plaintiff (not given) John prior of Delgate 755389 755389 (Delgate, John, of Bishop's Lenn, brother & prior of the brotherhood of the order of St Augustine 1
4477367 2193585 2193585 plaintiff Markeby John   755389 755389 Markeby, John, of Bishop's Lenn 1
4477798 2193721 2193721 defendant Botila Thomas de merchant 755389 755389 Botila, Thomas de, of Bishop's Lenn, merchant 1
4483518 2195532 2195532 defendant Erle William   755389 755389 Erle, William, of Bishop's Lenn 0
4483520 2195533 2195533 defendant Erle William   755389 755389 Erle, William, of Bishop's Lenn 0
4489891 2197545 2197545 plaintiff Berry William   755389 755389 Berry, William, of Bishop's Lenn 1
4490009 2197587 2197587 plaintiff Tylneye John   755389 755389 Tylneye, John, of Bishop's Lenn 0
4490324 2197674 2197674 plaintiff Wace John   755389 755389 Wace, John, of Bishop's Lenn 0
4490325 2197674 2197674 plaintiff Halyate William   755389 755389 Halyate, William, of Bishop's Lenn 1
4490716 2197798 2197798 plaintiff Waryn John   755389 755389 Waryn, John, of Bishop's Lenn, burgess 0
4490719 2197799 2197799 plaintiff Waryn John   755389 755389 Waryn, John, of Bishop's Lenn, burgess 0
4493098 2198541 2198541 plaintiff atte Hawe Thomas   755389 755389 atte Hawe, Thomas, of Bishop's Lenn 0
4494596 2199002 2199002 plaintiff Brandon John de   755389 755389 Brandon, John de, of Bishop's Lenn, burgess & merchant, on his own account 0
4495661 2199321 2199321 defendant Abnale Thomas   755389 755389 Abnale, Thomas, of Bishop's Lenn, burgess 0
4495662 2199321 2199321 defendant Drewe Thomas   755389 755389 Drewe, Thomas, of Bishop's Lenn, burgess 1
4495663 2199321 2199321 defendant Wate or Wace John   755389 755389 Wate or Wace, John, of Bishop's Lenn, burgess 2
4495665 2199322 2199322 defendant Abnale Thomas   755389 755389 Abnale, Thomas, of Bishop's Lenn 0
4495666 2199322 2199322 defendant Brew-- Thomas   755389 755389 Brew--, Thomas, of Bishop's Lenn 1
4495667 2199322 2199322 defendant Wace John   755389 755389 Wace, John, of Bishop's Lenn, burgess 2
4497520 2199868 2199868 plaintiff Draper John   755389 755389 Draper, John, of Bishop's Lenn 0
4497773 2199948 2199948 defendant Houton John de   755389 755389 Houton, John de, of Bishop's Lenn 0
4499067 2200351 2200351 defendant Maynard John   755389 755389 Maynard, John, of Bishop's Lenn, wax chandler 7
4499447 2200479 2200479 defendant Ferers Edmund   755389 755389 Ferers, Edmund, of Bishop's Lenn, son of Edmund 0
4503354 2201621 2201621 plaintiff Paynot Thomas   755389 755389 Paynot, Thomas, of Bishop's Lenn 0
4504580 2201986 2201986 defendant Brekerop Robert   755389 755389 Brekerop, Robert, of Bishop's Lenn 2
4504864 2202066 2202066 defendant Wyth John   755389 755389 Wyth, John, of Bishop's Lenn 0
4506628 2202552 2202552 defendant Which Philip   755389 755389 Which, Philip, of Bishop's Lenn, burgess 1
4506667 2202563 2202563 defendant Wych Philip   755389 755389 Wych, Philip, of Bishop's Lenn 0
4506669 2202564 2202564 defendant Wyth Philip   755389 755389 Wyth, Philip, of Bishop's Lenn 0
4512826 2204445 2204445 plaintiff Brandon John   755389 755389 Brandon, John, of Bishop's Lenn, burgess 0
4513458 2204631 2204631 defendant Maynard John   755389 755389 Maynard, John, of Bishop's Lenn, wax chandler 0
4513459 2204631 2204631 defendant Grene Andrew   755389 755389 Grene, Andrew, of Bishop's Lenn 1
4513467 2204634 2204634 defendant Stokkys Robert   755389 755389 Stokkys, Robert, of Bishop's Lenn 0
4513508 2204651 2204651 defendant Maynard John   755389 755389 Maynard, John, of Bishop's Lenn, wax chandler 0
4513509 2204651 2204651 defendant Grene Andrew   755389 755389 Grene, Andrew, of Bishop's Lenn 1
4513665 2204704 2204704 plaintiff Brunham John   755389 755389 Brunham, John, of Bishop's Lenn 0
4513678 2204706 2204706 plaintiff Brunham Robert   755389 755389 Brunham, Robert, of Bishop's Lenn, burgess 0
4513679 2204706 2204706 defendant Brystowe Edward   755389 755389 Brystowe, Edward, of Bishop's Lenn 0
4515066 2205121 2205121 defendant Caudeler William   755389 755389 Caudeler, William, of Bishop's Lenn 0
4515068 2205122 2205122 defendant Caudeler William   755389 755389 Caudeler, William, of Bishop's Lenn 0
4515433 2205242 2205242 defendant Nonton John   755389 755389 Nonton, John, of Bishop's Lenn, burgess 0
4521279 2207000 2207000 plaintiff Fyssher William   755389 755389 Fyssher, William, of Bishop's Lenn, burgess 0
4521346 2207021 2207021 plaintiff Galyon Roger   755389 755389 Galyon, Roger, of Bishop's Lenn 0
4521636 2207094 2207094 defendant London Thomas   755389 755389 London, Thomas, of Bishop's Lenn 0
4522288 2207315 2207315 defendant Stanley John dyer 755389 755389 Stanley, John, of Bishop's Lenn, dyer 1
4525892 2208398 2208398 plaintiff Kempe John (legal representative) 755389 755389 Kempe, John, of Bishop's Lenn, burgess, executors of 0
4525893 2208398 2208398 plaintiff Kempe John   755389 755389 (Kempe, John, of Bishop's Lenn, burgess 1
4525895 2208398 2208398 plaintiff Dytton John   755389 755389 Dytton, John, of Bishop's Lenn, burgess 3
4538109 2212203 2212203 plaintiff Thorp Richard   755389 755389 Thorp, Richard, of Bishop's Lenn 0
4538641 2212363 2212363 defendant Home John   755389 755389 Home, John, of Bishop's Lenn 0
4538644 2212364 2212364 defendant Gedeneye William   755389 755389 Gedeneye, William, of Bishop's Lenn 1
4539718 2212684 2212684 defendant Howeton Thomas de   755389 755389 Howeton, Thomas de, of Bishop's Lenn, burgess & mercer 0
4539723 2212685 2212685 defendant Bulke John mercer 755389 755389 Bulke, John, of Bishop's Lenn, mercer 2
4539728 2212686 2212686 defendant Bulle John mercer 755389 755389 Bulle, John, of Bishop's Lenn, mercer 2
4541556 2213254 2213254 defendant Baxtere Geoffrey   755389 755389 Baxtere, Geoffrey, of Bishop's Lenn 1
4543675 2213917 2213917 defendant Bedyngham Ralph   755389 755389 Bedyngham, Ralph, of Bishop's Lenn 1
4546041 2214702 2214702 defendant Brunham Robert   755389 755389 Brunham, Robert, of Bishop's Lenn 3
4546151 2214745 2214745 plaintiff Brandon John   755389 755389 Brandon, John, of Bishop's Lenn 0
4546161 2214747 2214747 plaintiff Brandone John   755389 755389 Brandone, John, of Bishop's Lenn, burgess 0
4546924 2214971 2214971 plaintiff Brycham William   755389 755389 Brycham, William, of Bishop's Lenn 0
4547274 2215081 2215081 plaintiff Bury Beatrice   755389 755389 Bury, Beatrice, of Bishop's Lenn 0
4554695 2217394 2217394 plaintiff Halleyate William merchant 755389 755389 Halleyate, William, of Bishop's Lenn, merchant 0
4554698 2217395 2217395 plaintiff Halleyate William merchant 755389 755389 Halleyate, William, of Bishop's Lenn, merchant 0
4554700 2217396 2217396 plaintiff Halleyate William merchant 755389 755389 Halleyate, William, of Bishop's Lenn, merchant 0
4559235 2218842 2218842 plaintiff Massyngham Thomas   755389 755389 Massyngham, Thomas, of Bishop's Lenn 0
4562581 2219856 2219856 plaintiff Prentes John   755389 755389 Prentes, John, of Bishop's Lenn, burgess 0
4566684 2221155 2221155 plaintiff Style John   755389 755389 Style, John, of Bishop's Lenn 0
4567039 2221247 2221247 plaintiff Sylesden William   755389 755389 Sylesden, William, of Bishop's Lenn 0
4568106 2221593 2221593 defendant Peyntour John   755389 755389 Peyntour, John, of Bishop's Lenn 3
4569352 2222005 2222005 plaintiff (not given) Alexander prior of Well 755389 755389 Well, Alexander, of Bishop's Lenn, prior of the order of the hermits of St Augustine 0
4570829 2222445 2222445 defendant Norman Alan butcher 755389 755389 Norman, Alan, of Bishop's Lenn, butcher 0
4570830 2222445 2222445 defendant Sweyn Henry butcher 755389 755389 Sweyn, Henry, of Bishop's Lenn, butcher 1
4573138 2223132 2223132 defendant Wyth William   755389 755389 Wyth, William, of Bishop's Lenn 0
4574073 2223415 2223415 defendant Prees John   755389 755389 Prees, John, of Bishop's Lenn 0
4574820 2223650 2223650 plaintiff Blakeney William   755389 755389 Blakeney, William, of Bishop's Lenn 0
4574821 2223650 2223650 defendant Sparham Thomas   755389 755389 Sparham, Thomas, of Bishop's Lenn 0
4575147 2223749 2223749 defendant Tylney John   755389 755389 Tylney, John, of Bishop's Lenn 0
4575304 2223788 2223788 defendant Peterburgh John   755389 755389 Peterburgh, John, of Bishop's Lenn 5
4575875 2223942 2223942 defendant Coupere John   755389 755389 Coupere, John, of Bishop's Lenn 5

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