names

80 rows where place_id = 586882

✎ 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
3589889 1864479 1864479 defendant Smyth John butcher 586882 586882 Smyth, John, of Betele, butcher 0
3603220 1868676 1868676 defendant Some John yeoman 586882 586882 Some, John, of Betele, yeoman 0
3606083 1869570 1869570 defendant Fyssher Adam berker 586882 586882 Fyssher, Adam, of betele, berker 0
3707722 1928711 1928711 defendant Neve William (legal representative) 586882 586882 Neve, William, of Betele, yeoman, executors of 0
4441448 2182266 2182266 defendant Mayes John   586882 586882 Mayes, John, of Betele, parson 0
4455958 2186881 2186881 defendant Heye Henry   586882 586882 Heye, Henry, of Betele 0
4459037 2187871 2187871 plaintiff Roldeston John de   586882 586882 Roldeston, John de, of Betele, formerly parson 0
4484296 2195790 2195790 defendant Curson Robert   586882 586882 Curson, Robert, of Betele 0
4555874 2217778 2217778 defendant Vessy Ralph   586882 586882 Vessy, Ralph, of Betele 0
4559236 2218842 2218842 defendant Betele Thomas   586882 586882 Betele, Thomas, of Betele 0
4566685 2221155 2221155 defendant Wynkhill Thomas   586882 586882 Wynkhill, Thomas, of Betele 0
4568739 2221805 2221805 defendant Heythe Richard draper 586882 586882 Heythe, Richard, of Betele, draper 1
4571636 2222706 2222706 defendant Gardener Simon   586882 586882 Gardener, Simon, of Betele 2
4592631 2229046 2229046 defendant Benale William   586882 586882 Benale, William, of Betele 3
4592632 2229046 2229046 defendant Malyard Seamus   586882 586882 Malyard, Seamus, of Betele 4
4592633 2229046 2229046 defendant Leseyate John   586882 586882 Leseyate, John, of Betele 5
4592634 2229046 2229046 defendant Gardener Simon   586882 586882 Gardener, Simon, of Betele 6
4595449 2229832 2229832 defendant Gillyng Thomas   586882 586882 Gillyng, Thomas, of Betele 1
4601785 2231779 2231779 plaintiff Walsyngham Robert de   586882 586882 Walsyngham, Robert de, of Betele, parson 0
4601788 2231780 2231780 plaintiff Walsyngham Robert   586882 586882 Walsyngham, Robert, of Betele, parson 0
4630685 2240500 2240500 defendant Wyncle Thomas   586882 586882 Wyncle, Thomas, of Betele 7
4630695 2240501 2240501 defendant Wyncle Thomas   586882 586882 Wyncle, Thomas, of Betele 2
4633065 2241211 2241211 plaintiff Walsyngham Robert   586882 586882 Walsyngham, Robert, of Betele, parson 0
4633068 2241211 2241211 defendant Heye Richard   586882 586882 Heye, Richard, of Betele 0
4637322 2242468 2242468 defendant Webster William   586882 586882 Webster, William, of Betele 4
4648335 2245569 2245569 defendant Wynkel Thomas   586882 586882 Wynkel, Thomas, of Betele 6
4648337 2245569 2245569 defendant Rust Adam   586882 586882 Rust, Adam, of Betele 8
4659201 2248750 2248750 defendant Gardyner Simon husbandman 586882 586882 Gardyner, Simon, of Betele, husbandman 0
4676086 2258133 2258133 defendant Gardener Simon yeoman 586882 586882 Gardener, Simon, of Betele, yeoman 0
4685446 2261045 2261045 plaintiff Rust Adam   586882 586882 Rust, Adam, of Betele, on his own account 0
4691352 2262818 2262818 defendant Egate John   586882 586882 Egate, John, of Betele, qwystere or bleacher 0
4699413 2265276 2265276 defendant Large John yeoman 586882 586882 Large, John, of Betele, yeoman 1
4703878 2266590 2266590 defendant Large John yeoman 586882 586882 Large, John, of Betele, formerly staying in Bilney, yeoman 3
4715171 2270073 2270073 defendant Rust Adam husbandman 586882 586882 Rust, Adam, of Betele, husbandman 0
4719769 2271529 2271529 defendant Martyn Richard qwyster or bleacher of cloth 586882 586882 Martyn, Richard, of Betele, qwyster or bleacher of cloth 4
4739722 2277500 2277500 defendant Martyn Adam yeoman 586882 586882 Martyn, Adam, of Betele, yeoman 2
4740814 2277829 2277829 defendant Egate John yeoman 586882 586882 Egate, John, of Betele, yeoman 5
4748205 2279982 2279982 defendant Malyard Seamus tailor 586882 586882 Malyard, Seamus, of Betele, tailor 3
4751343 2280870 2280870 defendant Rust Adam yeoman 586882 586882 Rust, Adam, of Betele, yeoman 0
4807107 2298421 2298421 defendant Hull Robert de   586882 586882 Hull, Robert de, of Betele, parson 0
4848637 2311047 2311047 defendant Gyllyng Thomas thatcher 586882 586882 Gyllyng, Thomas, of Betele, thatcher 2
4848641 2311047 2311047 defendant Hopton John yeoman 586882 586882 Hopton, John, of Betele, yeoman 6
4848647 2311047 2311047 defendant Egate John husbandman 586882 586882 Egate, John, of Betele, husbandman 12
4848648 2311047 2311047 defendant Large John yeoman 586882 586882 Large, John, of Betele, yeoman 13
4848649 2311047 2311047 defendant Fulthehous Maud widow 586882 586882 Fulthehous, Maud, of Betele, widow 14
4879369 2320477 2320477 defendant Gardyner William husbandman 586882 586882 Gardyner, William, of Betele, husbandman 0
4906651 2328668 2328668 defendant Hawes John husbandman 586882 586882 Hawes, John, of Betele, husbandman 0
4948303 2341449 2341449 plaintiff Maliard Seman (legal representative) 586882 586882 Maliard, Seman, of Betele, executors of 0
4950010 2341972 2341972 defendant Dancastre Beatrice widow 586882 586882 Dancastre, Beatrice, of Betele, widow 7
4955033 2343457 2343457 defendant de Soham Simon yeoman 586882 586882 de Soham, Simon, of Betele, yeoman 0
4980429 2351087 2351087 defendant Aggys John husbandman 586882 586882 Aggys, John, of Betele, husbandman 0
4996258 2355736 2355736 defendant Wolvy Thomas husbandman 586882 586882 Wolvy, Thomas, of Betele, husbandman 3
4999642 2356769 2356769 defendant Batche William husbandman 586882 586882 Batche, William, of Betele, husbandman 0
5075184 2379074 2379074 defendant Pedder William yeoman 586882 586882 Pedder, William, of Betele, yeoman 2
5075196 2379075 2379075 defendant Pedder William yeoman 586882 586882 Pedder, William, of Betele, yeoman 3
5118864 2391949 2391949 defendant Rust Simon husbandman 586882 586882 Rust, Simon, of Betele, husbandman 0
5125136 2393827 2393827 defendant Hertyng Richard   586882 586882 Hertyng, Richard, of Betele 0
5143759 2399307 2399307 defendant Hertyn Richard husbandman 586882 586882 Hertyn, Richard, of Betele, husbandman 0
5233228 2425306 2425306 defendant Hertyng Richard yeoman 586882 586882 Hertyng, Richard, of Betele, yeoman 0
5301898 2445520 2445520 defendant Ruste Simon husbandman 586882 586882 Ruste, Simon, of Betele, husbandman 2
5301902 2445521 2445521 defendant Rust Simon husbandman 586882 586882 Rust, Simon, of Betele, husbandman 0
5332316 2454730 2454730 defendant Chitteryng Geoffrey clerk 586882 586882 Chitteryng, Geoffrey, of Betele, clerk 2
5352297 2460819 2460819 defendant Soham Edmund yeoman 586882 586882 Soham, Edmund, of Betele, yeoman 0
5352298 2460819 2460819 defendant Soham Philip husbandman 586882 586882 Soham, Philip, of Betele, husbandman 1
5444706 2488316 2488316 defendant Bache Simon husbandman 586882 586882 Bache, Simon, of Betele, husbandman 1
5457414 2492119 2492119 defendant Bache Simon husbandman 586882 586882 Bache, Simon, of Betele, husbandman 1
5490733 2502121 2502121 defendant Bache William husbandman 586882 586882 Bache, William, of Betele, husbandman 2
5490734 2502121 2502121 defendant Batche Simon husbandman 586882 586882 Batche, Simon, of Betele, husbandman 3
5490741 2502122 2502122 defendant Bache William husbandman 586882 586882 Bache, William, of Betele, husbandman 2
5490742 2502122 2502122 defendant Batche Simon husbandman 586882 586882 Batche, Simon, of Betele, husbandman 3
5499704 2504854 2504854 defendant Deye Edmund tanner 586882 586882 Deye, Edmund, of Betele, tanner 0
5531675 2514441 2514441 defendant Sohame John, junior yeoman 586882 586882 Sohame, John, junior, of Betele, yeoman 0
5531677 2514442 2514442 defendant Sohame John, junior yeoman and court holder 586882 586882 Sohame, John, junior, of Betele, yeoman and court holder 0
5535171 2515527 2515527 defendant Bysshope alias Clement John chaplain 586882 586882 Bysshope alias Clement, John, of Betele, chaplain 1
5556031 2521760 2521760 defendant Shoham John yeoman 586882 586882 Shoham, John, of Betele, yeoman 0
5556033 2521761 2521761 defendant Soham John yeoman 586882 586882 Soham, John, of Betele, yeoman 0
5561312 2523288 2523288 defendant Toke Simon (legal representative) 586882 586882 Toke, Simon, of Betele, executors of 2
5561313 2523288 2523288 defendant Busshop John clerk 586882 586882 (Busshop, John, of Betele, clerk 3
5561314 2523288 2523288 defendant Toke Agnes widow 586882 586882 Toke, Agnes, of Betele, widow 4
5589113 2531603 2531603 defendant Bysshopp John clerk 586882 586882 Bysshopp, John, of Betele, clerk 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);