names

79 rows where place_id = 586341

✎ 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
3588468 1864040 1864040 defendant Cooke William gent 586341 586341 Cooke, William, of Elyngham, gent 0
3606063 1869563 1869563 plaintiff Marchale John   586341 586341 Marchale, John, of Elyngham 0
3611576 1871287 1871287 defendant Coke William gent 586341 586341 Coke, William, of Elyngham, gent 0
3611577 1871287 1871287 defendant Okeden William gent 586341 586341 Okeden, William, of Elyngham, gent 1
3639116 1907056 1907056 defendant Okeden William gent 586341 586341 Okeden, William, of Elyngham, gent 1
3639119 1907056 1907056 defendant Collys Richard husbandman 586341 586341 Collys, Richard, of Elyngham, husbandman 4
3718714 1932130 1932130 defendant Newman Walter husbandman 586341 586341 Newman, Walter, of Elyngham, husbandman 3
3769845 1948224 1948224 defendant Goodbody John yeoman 586341 586341 Goodbody, John, of Elyngham, yeoman 2
3821831 1964717 1964717 defendant Wodeshyde Thomas husbandman 586341 586341 Wodeshyde, Thomas, of Elyngham, husbandman 2
3840743 1970671 1970671 defendant Chamberleyn Richard yeoman 586341 586341 Chamberleyn, Richard, of Elyngham, yeoman 0
3870151 1980262 1980262 defendant Gurney Anthony esq 586341 586341 Gurney, Anthony, of Elyngham, esq 0
3870833 1980495 1980495 defendant Leveriche Richard husbandman 586341 586341 Leveriche, Richard, of Elyngham, husbandman 2
3897555 1989394 1989394 defendant Fulmerston John yeoman 586341 586341 Fulmerston, John, of Elyngham, yeoman 4
3960003 2010597 2010597 defendant Browne William husbandman 586341 586341 Browne, William, of Elyngham, husbandman 0
3968198 2013502 2013502 defendant Totte Thomas tailor 586341 586341 Totte, Thomas, of Elyngham, tailor 1
3981984 2018319 2018319 defendant Grant William   586341 586341 Grant, William, of Elyngham, husbandman, administrators of 1
4019376 2031663 2031663 defendant Lyncoln Nicholas husbandman 586341 586341 Lyncoln, Nicholas, of Elyngham, husbandman 0
4176146 2087131 2087131 defendant Greneleaffe Walter husbandman 586341 586341 Greneleaffe, Walter, of Elyngham, husbandman 0
4437450 2176462 2176462 defendant atte Gateshende Roger   586341 586341 atte Gateshende, Roger, of Elyngham 0
4483423 2195503 2195503 defendant Howesson John   586341 586341 Howesson, John, of Elyngham 3
4560058 2219095 2219095 defendant Pirt Thomas   586341 586341 Pirt, Thomas, of Elyngham 0
4579214 2224980 2224980 defendant Pyrt Thomas   586341 586341 Pyrt, Thomas, of Elyngham 4
4605209 2232796 2232796 defendant atte Dyke William   586341 586341 atte Dyke, William, of Elyngham 0
4610577 2234375 2234375 defendant Pirs Thomas   586341 586341 Pirs, Thomas, of Elyngham 0
4611605 2234693 2234693 defendant Cole William   586341 586341 Cole, William, of Elyngham 5
4617594 2236511 2236511 defendant Deye Richard   586341 586341 Deye, Richard, of Elyngham 1
4651586 2246495 2246495 defendant Broune Thomas forester 586341 586341 Broune, Thomas, of Elyngham, forester 1
4657541 2248249 2248249 defendant Cokhowe Thomas yeoman 586341 586341 Cokhowe, Thomas, of Elyngham, yeoman 2
4660098 2249002 2249002 defendant Prest Patrick yeoman 586341 586341 Prest, Patrick, of Elyngham, yeoman 0
4667432 2255534 2255534 defendant Saunfaille or Saunsaille John butcher 586341 586341 Saunfaille or Saunsaille, John, of Elyngham, butcher 1
4716200 2270375 2270375 plaintiff Weston John (legal representative) 586341 586341 Weston, John, of Elyngham, executors of 0
4716204 2270375 2270375 defendant Turkeys John baker 586341 586341 Turkeys, John, of Elyngham, baker 0
4716205 2270375 2270375 defendant Cook John thatcher 586341 586341 Cook, John, of Elyngham, thatcher 1
4737679 2276890 2276890 defendant Colman John husbandman 586341 586341 Colman, John, of Elyngham, husbandman 5
4743057 2278489 2278489 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham 1
4743062 2278490 2278490 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham 1
4760719 2283694 2283694 defendant Deye Richard   586341 586341 Deye, Richard, of Elyngham, bailiff 2
4760725 2283695 2283695 defendant Deye Richard   586341 586341 Deye, Richard, of Elyngham, bailiff 2
4761810 2284038 2284038 defendant Newe Henry husbandman 586341 586341 Newe, Henry, of Elyngham, husbandman 1
4767517 2285818 2285818 defendant Yoman Thomas yeoman 586341 586341 Yoman, Thomas, of Elyngham, yeoman 2
4791708 2293504 2293504 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham 0
4812491 2300019 2300019 defendant Mayhewe John husbandman 586341 586341 Mayhewe, John, of Elyngham, husbandman 0
4825448 2304004 2304004 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham 1
4825451 2304005 2304005 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham 1
4825454 2304006 2304006 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham, 1
4825457 2304007 2304007 plaintiff Mannyng John   586341 586341 Mannyng, John, of Elyngham, 1
4873283 2318597 2318597 defendant Monter Robert husbandman 586341 586341 Monter, Robert, of Elyngham, husbandman 0
4900866 2326902 2326902 defendant Orton David   586341 586341 Orton, David, of Elyngham, "ponder" 1
4900879 2326904 2326904 defendant Leveday Thomas yeoman 586341 586341 Leveday, Thomas, of Elyngham, yeoman 2
4949804 2341929 2341929 defendant Punchardon Richard gent 586341 586341 Punchardon, Richard, of Elyngham, gent 0
4954821 2343398 2343398 defendant Elyngham William gent 586341 586341 Elyngham, William, of Elyngham, gent 0
4975771 2349717 2349717 defendant Punchardon Richard gent 586341 586341 Punchardon, Richard, of Elyngham, gent 0
5002411 2357614 2357614 defendant Punchardon Richard gent 586341 586341 Punchardon, Richard, of Elyngham, gent 0
5011272 2360155 2360155 defendant Trolhop Robert yeoman 586341 586341 Trolhop, Robert, of Elyngham, yeoman 2
5029136 2365398 2365398 defendant Punchardon Richard gent 586341 586341 Punchardon, Richard, of Elyngham, gent 0
5066765 2376588 2376588 defendant Bonfelawe Robert husbandman 586341 586341 Bonfelawe, Robert, of Elyngham, husbandman 2
5071856 2378077 2378077 defendant Elyngham William gent 586341 586341 Elyngham, William, of Elyngham, gent 0
5105771 2388135 2388135 defendant Forde John gent 586341 586341 Forde, John, of Elyngham, gent 2
5135001 2396735 2396735 defendant Howard Walter   586341 586341 Howard, Walter, of Elyngham, parson 3
5141360 2398594 2398594 defendant Forde John gent 586341 586341 Forde, John, of Elyngham, gent 0
5159053 2403763 2403763 defendant Mattes William   586341 586341 Mattes, William, of Elyngham, vicar & clerk 0
5162528 2404768 2404768 defendant Forde John gent 586341 586341 Forde, John, of Elyngham, gent 0
5176520 2408822 2408822 defendant Forde John gent 586341 586341 Forde, John, of Elyngham, gent 0
5198754 2415389 2415389 defendant Forde John gent 586341 586341 Forde, John, of Elyngham, gent 0
5238621 2426888 2426888 defendant Punchardon Richard gent 586341 586341 Punchardon, Richard, of Elyngham, gent 0
5351121 2460455 2460455 defendant Methwold Robert husbandman 586341 586341 Methwold, Robert, of Elyngham, husbandman 2
5364290 2464492 2464492 defendant Coke William gent 586341 586341 Coke, William, of Elyngham, gent 0
5371455 2466655 2466655 defendant Wattys Richard clerk 586341 586341 Wattys, Richard, of Elyngham, clerk 1
5390851 2472448 2472448 defendant Coke William gent 586341 586341 Coke, William, of Elyngham, gent 0
5541293 2517392 2517392 defendant Okeden William gent 586341 586341 Okeden, William, of Elyngham, gent 0
5543093 2517959 2517959 defendant Eweley Thomas chaplain 586341 586341 Eweley, Thomas, of Elyngham, chaplain 0
5552671 2520833 2520833 defendant Bryon John husbandman 586341 586341 Bryon, John, of Elyngham, husbandman 0
5555705 2521663 2521663 defendant Bryan John husbandman 586341 586341 Bryan, John, of Elyngham, husbandman 3
5572994 2526649 2526649 defendant Coke Edward yeoman 586341 586341 Coke, Edward, of Elyngham, yeoman 0
5593125 2532834 2532834 defendant Bryan John husbandman 586341 586341 Bryan, John, of Elyngham, husbandman 3
5598572 2534437 2534437 defendant Bryan John yeoman 586341 586341 Bryan, John, of Elyngham, yeoman 4
5623446 2551268 2551268 plaintiff Wysk Walter   586341 586341 Wysk, Walter, of Elyngham 0
5623447 2551268 2551268 defendant --sshare Ralph le   586341 586341 --sshare, Ralph le, of Elyngham 0
5631513 2553865 2553865 defendant Lyng Peter clerk 586341 586341 Lyng, Peter, of Elyngham, clerk 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);