names

295 rows where place_id = 590410

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601128 1868016 1868016 defendant Croke Richard husbandman 590410 590410 Croke, Richard, of Marleburgh, husbandman 0
3601129 1868016 1868016 defendant Dyer John dyer 590410 590410 Dyer, John, of Marleburgh, dyer 1
3606013 1869545 1869545 plaintiff Mailebroke Richard   590410 590410 Mailebroke, Richard, of Marleburgh 0
3613633 1871910 1871910 defendant Iden Thomas innholder 590410 590410 Iden, Thomas, of Marleburgh, innholder 1
3679533 1919668 1919668 defendant Andrewes alias Barbour John yeoman 590410 590410 Andrewes alias Barbour, John, of Marleburgh, yeoman 0
3680027 1919817 1919817 defendant Andrewes alias Barbour John yeoman 590410 590410 Andrewes alias Barbour, John, of Marleburgh, yeoman 0
3680028 1919817 1919817 defendant Elbyden alias Elmyden Robert mercer 590410 590410 Elbyden alias Elmyden, Robert, of Marleburgh, mercer 1
3684974 1921436 1921436 defendant Browne Robert butcher 590410 590410 Browne, Robert, of Marleburgh, butcher 0
3684975 1921436 1921436 defendant Tipper John butcher 590410 590410 Tipper, John, of Marleburgh, butcher 1
3696469 1925122 1925122 defendant Buryman Robert weaver 590410 590410 Buryman, Robert, of Marleburgh, weaver 0
3696530 1925142 1925142 defendant Buryman Robert weaver 590410 590410 Buryman, Robert, of Marleburgh, weaver 0
3716037 1931301 1931301 defendant Brownefyld Robert clerk 590410 590410 Brownefyld, Robert, of Marleburgh, clerk 3
3752238 1942622 1942622 defendant Lancaster Ralph mercer 590410 590410 Lancaster, Ralph, of Marleburgh, mercer 1
3786065 1953432 1953432 defendant Chomley Hugh yeoman 590410 590410 Chomley, Hugh, of Marleburgh, yeoman 3
3800418 1958052 1958052 defendant Yeven Thomas   590410 590410 Yeven, Thomas, of Marleburgh, tallow chandler 0
3800420 1958053 1958053 defendant Yeven Thomas   590410 590410 Yeven, Thomas, of Marleburgh, tallow chandler 0
3800422 1958054 1958054 defendant Yeven Thomas   590410 590410 Yeven, Thomas, of Marleburgh, tallow chandler 0
3834274 1968665 1968665 plaintiff More James glover 590410 590410 More, James, of Marleburgh, glover 0
3838686 1970026 1970026 plaintiff Underhyll John yeoman 590410 590410 Underhyll, John, of Marleburgh, yeoman 0
3838689 1970027 1970027 plaintiff Underhyll John yeoman 590410 590410 Underhyll, John, of Marleburgh, yeoman 0
3857946 1976128 1976128 defendant Fryes Henry innholder 590410 590410 Fryes, Henry, of Marleburgh, innholder 0
3859357 1976622 1976622 defendant Bagott Henry yeoman 590410 590410 Bagott, Henry, of Marleburgh, yeoman 1
3859841 1976791 1976791 defendant Cosyn alias Chapman John baker 590410 590410 Cosyn alias Chapman, John, of Marleburgh, baker 0
3859843 1976792 1976792 defendant Cosyn alias Chapman John baker 590410 590410 Cosyn alias Chapman, John, of Marleburgh, baker 0
3862281 1977572 1977572 defendant Androse William butcher 590410 590410 Androse, William, of Marleburgh, butcher 0
3911985 1994334 1994334 plaintiff Wrene Richard tanner 590410 590410 Wrene, Richard, of Marleburgh, tanner 0
3911987 1994334 1994334 defendant Evan alias Pygott Thomas draper 590410 590410 Evan alias Pygott, Thomas, of Marleburgh, draper 1
3929482 2000208 2000208 plaintiff Bytheway Robert tanner 590410 590410 Bytheway, Robert, of Marleburgh, tanner 0
3929486 2000209 2000209 plaintiff Bytheway Robert tanner 590410 590410 Bytheway, Robert, of Marleburgh, tanner 0
4486461 2196475 2196475 defendant Watre Richard atte   590410 590410 Watre, Richard atte, of Marleburgh 4
4487430 2196780 2196780 plaintiff Smyth Adam   590410 590410 Smyth, Adam, of Marleburgh 0
4487432 2196781 2196781 plaintiff Smyth Adam   590410 590410 Smyth, Adam, of Marleburgh 0
4527132 2208769 2208769 defendant Bowyere Thomas   590410 590410 Bowyere, Thomas, of Marleburgh 2
4534203 2210961 2210961 plaintiff Sadelere Richard   590410 590410 Sadelere, Richard, of Marleburgh 0
4536581 2211717 2211717 defendant Brombold Richard   590410 590410 Brombold, Richard, of Marleburgh 0
4536583 2211718 2211718 defendant Grombold Richard   590410 590410 Grombold, Richard, of Marleburgh 0
4571805 2222768 2222768 defendant Byde John tailor 590410 590410 Byde, John, of Marleburgh, tailor 0
4574295 2223490 2223490 plaintiff Benfeld William (legal representative) 590410 590410 Benfeld, William, of Marleburgh, executors of 0
4576756 2224238 2224238 defendant Spicer John   590410 590410 Spicer, John, of Marleburgh 2
4576761 2224239 2224239 defendant Spicer John   590410 590410 Spicer, John, of Marleburgh 2
4577039 2224326 2224326 plaintiff Bybury John   590410 590410 Bybury, John, of Marleburgh 0
4577040 2224326 2224326 defendant Castelton William   590410 590410 Castelton, William, of Marleburgh 0
4579164 2224966 2224966 defendant Frend John   590410 590410 Frend, John, of Marleburgh 0
4589833 2228186 2228186 defendant Brid John   590410 590410 Brid, John, of Marleburgh 4
4589834 2228186 2228186 defendant Perham Robert   590410 590410 Perham, Robert, of Marleburgh 5
4589980 2228225 2228225 plaintiff Ludyngton John   590410 590410 Ludyngton, John, of Marleburgh 0
4590603 2228420 2228420 defendant Baker Robert   590410 590410 Baker, Robert, of Marleburgh 0
4591883 2228814 2228814 defendant Coke William   590410 590410 (Coke, William, of Marleburgh 1
4591887 2228815 2228815 defendant Coke William   590410 590410 (Coke, William, of Marleburgh 1
4592794 2229085 2229085 defendant Man William   590410 590410 Man, William, of Marleburgh 0
4594411 2229512 2229512 defendant Smyth Henry   590410 590410 Smyth, Henry, of Marleburgh, son of John 0
4594412 2229512 2229512 defendant Lydyngton Gilbert   590410 590410 Lydyngton, Gilbert, of Marleburgh, servant of John Lydyngton 1
4594415 2229513 2229513 defendant Bocher John   590410 590410 Bocher, John, of Marleburgh 0
4599196 2230959 2230959 defendant Swan Nicholas   590410 590410 Swan, Nicholas, of Marleburgh 5
4600834 2231484 2231484 plaintiff Trewe John   590410 590410 Trewe, John, of Marleburgh 0
4605231 2232802 2232802 defendant Byde John tailor 590410 590410 Byde, John, of Marleburgh, tailor 0
4606661 2233193 2233193 defendant Smyth Robert   590410 590410 Smyth, Robert, of Marleburgh 0
4613737 2235310 2235310 defendant Oseberne William   590410 590410 Oseberne, William, of Marleburgh 2
4624916 2238764 2238764 defendant Belyeter John   590410 590410 Belyeter, John, of Marleburgh 0
4624989 2238783 2238783 plaintiff Osbern John   590410 590410 Osbern, John, of Marleburgh, warden of the King's free chapel, within the castle 0
4627277 2239478 2239478 defendant Toppere John   590410 590410 Toppere, John, of Marleburgh 1
4628686 2239896 2239896 defendant Tarant alias Taillour Richard   590410 590410 Tarant alias Taillour, Richard, of Marleburgh 0
4630981 2240584 2240584 plaintiff (not given) Walter de prior of Swyndon 590410 590410 Swyndon, Walter de, of Marleburgh, prior of the house of St Margaret, near 0
4635324 2241884 2241884 defendant Tarent William   590410 590410 Tarent, William, of Marleburgh 4
4636360 2242207 2242207 defendant atte Welle John   590410 590410 atte Welle, John, of Marleburgh 1
4640163 2243237 2243237 defendant Iremonger William   590410 590410 Iremonger, William, of Marleburgh 0
4640165 2243237 2243237 defendant Bienb_ John   590410 590410 Bienb_, John, of Marleburgh 2
4641615 2243647 2243647 defendant Flyke Henry   590410 590410 Flyke, Henry, of Marleburgh 0
4642281 2243860 2243860 defendant Clerk Robert   590410 590410 Clerk, Robert, of Marleburgh 3
4657911 2248359 2248359 defendant Silford John brasier 590410 590410 Silford, John, of Marleburgh, brasier 1
4667525 2255563 2255563 defendant Belleyetere John husbandman 590410 590410 Belleyetere, John, of Marleburgh, husbandman 0
4670033 2256327 2256327 defendant Hatchewey Thomas woolman 590410 590410 Hatchewey, Thomas, of Marleburgh, woolman 0
4670035 2256328 2256328 defendant Hathewey Thomas   590410 590410 Hathewey, Thomas, of Marleburgh, wool man 0
4670129 2256360 2256360 defendant Dounton John yeoman 590410 590410 Dounton, John, of Marleburgh, yeoman 0
4672949 2257180 2257180 defendant Drake Robert dyer 590410 590410 Drake, Robert, of Marleburgh, dyer 1
4673668 2257394 2257394 defendant Fluke Henry (legal representative) 590410 590410 Fluke, Henry, of Marleburgh, executrix of 4
4673878 2257446 2257446 defendant atte Wyke John husbandman 590410 590410 atte Wyke, John, of Marleburgh, husbandman 4
4681226 2259754 2259754 defendant Hathewey Thomas husbandman 590410 590410 Hathewey, Thomas, of Marleburgh, husbandman 0
4682415 2260121 2260121 plaintiff Hathewey Thomas   590410 590410 Hathewey, Thomas, of Marleburgh, wool monger, on their own account 1
4682418 2260122 2260122 plaintiff Neweman Thomas   590410 590410 Neweman, Thomas, of Marleburgh 0
4692456 2263159 2263159 plaintiff atte Ferme alias Hathewey Thomas   590410 590410 atte Ferme alias Hathewey, Thomas, of Marleburgh 0
4694693 2263836 2263836 defendant Langeford John barber 590410 590410 Langeford, John, of Marleburgh, barber 0
4699749 2265365 2265365 defendant Peyntour Robert fishmonger 590410 590410 Peyntour, Robert, of Marleburgh, fishmonger 0
4705572 2267112 2267112 defendant Smyth John husbandman 590410 590410 Smyth, John, of Marleburgh, formerly of Okebourn, husbandman 0
4708286 2267965 2267965 plaintiff Neweman Thomas   590410 590410 Neweman, Thomas, of Marleburgh 0
4713621 2269583 2269583 plaintiff Swan Nicholas   590410 590410 Swan, Nicholas, of Marleburgh 1
4713622 2269583 2269583 defendant Dounton John husbandman 590410 590410 Dounton, John, of Marleburgh, husbandman 0
4720180 2271655 2271655 defendant Smyth Robert husbandman 590410 590410 Smyth, Robert, of Marleburgh, husbandman 2
4722884 2272473 2272473 defendant Bryd John gent 590410 590410 Bryd, John, of Marleburgh, gent 0
4728126 2274045 2274045 defendant Benham John chapman 590410 590410 Benham, John, of Marleburgh, chapman 0
4728826 2274254 2274254 defendant Coumbe John   590410 590410 Coumbe, John, of Marleburgh, bell maker 0
4731749 2275119 2275119 plaintiff Neweman Thomas   590410 590410 Neweman, Thomas, of Marleburgh 0
4735149 2276141 2276141 plaintiff Smyth Thomas (legal representative) 590410 590410 Smyth, Thomas, of Marleburgh, administrator of 0
4742635 2278349 2278349 defendant Mathewe Thomas chapman 590410 590410 Mathewe, Thomas, of Marleburgh, chapman 0
4743734 2278697 2278697 defendant Smyth Robert yeoman 590410 590410 Smyth, Robert, of Marleburgh, yeoman 1
4743736 2278697 2278697 defendant Fourbour Richard husbandman 590410 590410 Fourbour, Richard, of Marleburgh, husbandman 3
4743737 2278697 2278697 defendant Selwode John husbandman 590410 590410 Selwode, John, of Marleburgh, husbandman 4
4752467 2281183 2281183 plaintiff Tarente William draper 590410 590410 Tarente, William, of Marleburgh, draper 0
4756719 2282466 2282466 plaintiff Berughdon William (legal representative) 590410 590410 Berughdon, William, of Marleburgh, executors of 0
4756721 2282466 2282466 plaintiff Pellican John   590410 590410 Pellican, John, of Marleburgh 2

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