names

79 rows where place_id = 601398

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645200 1908908 1908908 defendant Elwyll John clerk 601398 601398 Elwyll, John, of Bryxham, clerk 1
3692739 1923918 1923918 defendant Brayne John yeoman 601398 601398 Brayne, John, of Bryxham, yeoman 0
3709192 1929171 1929171 defendant Lake Richard gent 601398 601398 Lake, Richard, of Bryxham, gent 1
3721935 1933123 1933123 defendant Turpyn Vincent merchant 601398 601398 Turpyn, Vincent, of Bryxham, merchant 1
3729121 1935356 1935356 defendant Hody William gent 601398 601398 Hody, William, of Bryxham, gent 0
3733957 1936869 1936869 defendant Veteryge Thomas husbandman 601398 601398 Veteryge, Thomas, of Bryxham, husbandman 0
3733958 1936869 1936869 defendant Gawden William husbandman 601398 601398 Gawden, William, of Bryxham, husbandman 1
3733959 1936869 1936869 defendant Hobbe John husbandman 601398 601398 Hobbe, John, of Bryxham, husbandman 2
3733961 1936869 1936869 defendant Lake John butcher 601398 601398 Lake, John, of Bryxham, butcher 4
3747875 1941258 1941258 defendant Lake Richard yeoman 601398 601398 Lake, Richard, of Bryxham, yeoman 0
3758943 1944789 1944789 defendant Gyldon William laborer 601398 601398 Gyldon, William, of Bryxham, laborer 0
3758944 1944789 1944789 defendant Sparke William yeoman 601398 601398 Sparke, William, of Bryxham, yeoman 1
3758945 1944789 1944789 defendant Pers John husbandman 601398 601398 Pers, John, of Bryxham, husbandman 2
3761759 1945689 1945689 defendant Hody William gent 601398 601398 Hody, William, of Bryxham, gent 0
3776985 1950548 1950548 defendant Sparke Walter yeoman 601398 601398 Sparke, Walter, of Bryxham, yeoman 2
3776987 1950549 1950549 defendant Gyldon William laborer 601398 601398 Gyldon, William, of Bryxham, laborer 0
3776988 1950549 1950549 defendant Sparke William yeoman 601398 601398 Sparke, William, of Bryxham, yeoman 1
3776989 1950549 1950549 defendant Pers John husbandman 601398 601398 Pers, John, of Bryxham, husbandman 2
3786510 1953573 1953573 defendant Bowdon Joan widow 601398 601398 Bowdon, Joan, of Bryxham, widow 1
3796922 1956916 1956916 defendant Upton William gent 601398 601398 Upton, William, of Bryxham, gent 2
3796925 1956917 1956917 defendant Upton William gent 601398 601398 Upton, William, of Bryxham, gent 0
3796926 1956917 1956917 defendant Upton Thomas gent 601398 601398 Upton, Thomas, of Bryxham, gent 1
3797419 1957081 1957081 defendant Hody William gent 601398 601398 Hody, William, of Bryxham, gent 0
3797420 1957081 1957081 defendant Speart Walter yeoman 601398 601398 Speart, Walter, of Bryxham, yeoman 1
3797421 1957081 1957081 defendant pomerey Ralph barber 601398 601398 pomerey, Ralph, of Bryxham, barber 2
3797422 1957081 1957081 defendant Gildryn William yeoman 601398 601398 Gildryn, William, of Bryxham, yeoman 3
3804981 1959502 1959502 defendant Fenye Tegan mariner 601398 601398 Fenye, Tegan, of Bryxham, mariner 0
3806133 1959846 1959846 defendant Cotemore Thomas smith 601398 601398 Cotemore, Thomas, of Bryxham, smith 0
3815259 1962688 1962688 defendant Hody William gent 601398 601398 Hody, William, of Bryxham, gent 0
3815260 1962688 1962688 defendant Speart Walter yeoman 601398 601398 Speart, Walter, of Bryxham, yeoman 1
3815261 1962688 1962688 defendant Pomerey Ralph barber 601398 601398 Pomerey, Ralph, of Bryxham, barber 2
3815262 1962688 1962688 defendant Gyldryn William yeoman 601398 601398 Gyldryn, William, of Bryxham, yeoman 3
3830687 1967481 1967481 defendant Trogell William butcher 601398 601398 Trogell, William, of Bryxham, butcher 1
3866736 1979110 1979110 defendant Farwell John butcher 601398 601398 Farwell, John, of Bryxham, butcher 0
3889317 1986664 1986664 defendant Hody William esq 601398 601398 Hody, William, of Bryxham, esq 0
3889318 1986664 1986664 defendant Hawle William husbandman 601398 601398 Hawle, William, of Bryxham, husbandman 1
3889319 1986664 1986664 defendant Coke William husbandman 601398 601398 Coke, William, of Bryxham, husbandman 2
3889320 1986664 1986664 defendant Coke alias Long Thomas yeoman 601398 601398 Coke alias Long, Thomas, of Bryxham, yeoman 3
3889321 1986664 1986664 defendant Glanfeld Christopher laborer 601398 601398 Glanfeld, Christopher, of Bryxham, laborer 4
3889323 1986664 1986664 defendant Bryten Oliver miller 601398 601398 Bryten, Oliver, of Bryxham, miller 6
3932611 2001200 2001200 defendant Smyth Gilbert mariner 601398 601398 Smyth, Gilbert, of Bryxham, mariner 0
3941755 2004256 2004256 defendant Hody William esq 601398 601398 Hody, William, of Bryxham, esq 0
3941756 2004256 2004256 defendant Davy William yeoman 601398 601398 Davy, William, of Bryxham, yeoman 1
3941757 2004256 2004256 defendant Lokeram Richard husbandman 601398 601398 Lokeram, Richard, of Bryxham, husbandman 2
3948274 2006455 2006455 defendant Edward William husbandman 601398 601398 Edward, William, of Bryxham, husbandman 2
3952181 2007837 2007837 defendant Prouse John, senior yeoman 601398 601398 Prouse, John, senior, of Bryxham, yeoman 0
3952182 2007837 2007837 defendant Bulley John husbandman 601398 601398 Bulley, John, of Bryxham, husbandman 1
3962314 2011402 2011402 defendant Argentyne Richard   601398 601398 Argentyne, Richard, of Bryxham, clerk, doctor of physic 0
4137269 2073678 2073678 defendant Cole Benedict husbandman 601398 601398 Cole, Benedict, of Bryxham, husbandman 0
4137270 2073678 2073678 defendant Cole Simon husbandman 601398 601398 Cole, Simon, of Bryxham, husbandman 1
4149005 2077769 2077769 defendant Cole Benedict husbandman 601398 601398 Cole, Benedict, of Bryxham, husbandman 0
4658120 2248420 2248420 defendant Snell or Suell John laborer 601398 601398 Snell or Suell, John, of Bryxham, laborer 0
4758864 2283122 2283122 defendant Elys John mariner 601398 601398 Elys, John, of Bryxham, mariner 0
4782473 2290527 2290527 defendant Torryng alias Dyrby John laborer 601398 601398 Torryng alias Dyrby, John, of Bryxham, laborer 0
4782566 2290559 2290559 defendant Batyn John mariner 601398 601398 Batyn, John, of Bryxham, mariner 0
4864888 2315995 2315995 defendant Elys John mariner 601398 601398 Elys, John, of Bryxham, mariner 0
4909324 2329459 2329459 defendant Denstyple Mathew haulier 601398 601398 Denstyple, Mathew, of Bryxham, haulier 0
5061021 2374871 2374871 defendant Elyot John shoemaker 601398 601398 Elyot, John, of Bryxham, shoemaker 2
5079820 2380444 2380444 defendant Dolbeare Richard smith 601398 601398 Dolbeare, Richard, of Bryxham, smith 0
5104824 2387848 2387848 defendant Batyn John, senior husbandman 601398 601398 Batyn, John, senior, of Bryxham, husbandman 0
5104825 2387848 2387848 defendant Batyn John, junior husbandman 601398 601398 Batyn, John, junior, of Bryxham, husbandman 1
5104826 2387848 2387848 defendant Cosby John fisher 601398 601398 Cosby, John, of Bryxham, fisher 2
5124638 2393678 2393678 defendant Mason John yeoman 601398 601398 Mason, John, of Bryxham, yeoman 0
5177813 2409214 2409214 defendant Mason John yeoman 601398 601398 Mason, John, of Bryxham, yeoman 0
5229513 2424245 2424245 defendant Elyet John (legal representative) 601398 601398 Elyet, John, of Bryxham, executors of 0
5285792 2440869 2440869 defendant Harryes Joan widow 601398 601398 Harryes, Joan, of Bryxham, widow 3
5309316 2447827 2447827 defendant Hevene John husbandman 601398 601398 Hevene, John, of Bryxham, husbandman 1
5309317 2447827 2447827 defendant Greneway Thomas husbandman 601398 601398 Greneway, Thomas, of Bryxham, husbandman 2
5309318 2447827 2447827 defendant Northern Henry husbandman 601398 601398 Northern, Henry, of Bryxham, husbandman 3
5309319 2447827 2447827 defendant Stallak William husbandman 601398 601398 Stallak, William, of Bryxham, husbandman 4
5317773 2450402 2450402 defendant William William husbandman 601398 601398 William, William, of Bryxham, husbandman 0
5317799 2450410 2450410 defendant Erysshe Robert husbandman 601398 601398 together with Erysshe, Robert, of Bryxham, husbandman 2
5323751 2452190 2452190 defendant Stanley alias Berdde Nicholas yeoman 601398 601398 Stanley alias Berdde, Nicholas, of Bryxham, yeoman 0
5323752 2452190 2452190 defendant Skynner John yeoman 601398 601398 Skynner, John, of Bryxham, yeoman 1
5323754 2452191 2452191 defendant Stanley Nicholas yeoman 601398 601398 Stanley, Nicholas, of Bryxham, yeoman 0
5323755 2452191 2452191 defendant Skynner John yeoman 601398 601398 Skynner, John, of Bryxham, yeoman 1
5334812 2455479 2455479 defendant Belamy Robert yeoman 601398 601398 Belamy, Robert, of Bryxham, yeoman 0
5335150 2455582 2455582 defendant Wyllyam William yeoman 601398 601398 Wyllyam, William, of Bryxham, yeoman 1
5508345 2507483 2507483 defendant Rawe Richard husbandman 601398 601398 Rawe, Richard, of Bryxham, husbandman 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);