names

137 rows where place_id = 593193

✎ 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
3610859 1871066 1871066 defendant Baker William yeoman 593193 593193 Baker, William, of Braunton, yeoman 0
3620074 1873854 1873854 defendant Pyke John husbandman 593193 593193 Pyke, John, of Braunton Abbot, husbandman 0
3620076 1873855 1873855 defendant Pyke John husbandman 593193 593193 Pyke, John, of Braunton Abbot, husbandman 0
3620081 1873855 1873855 defendant Wyott John, junior husbandman 593193 593193 Wyott, John, junior, of Braunton Abbot, husbandman 5
3746432 1940804 1940804 defendant Symon John husbandman 593193 593193 Symon, John, of Braunton, husbandman 0
3770703 1948519 1948519 defendant Langley Walter husbandman 593193 593193 Langley, Walter, of Braunton, husbandman 0
3770823 1948565 1948565 defendant Yeo Hugh gent 593193 593193 Yeo, Hugh, of Braunton, gent 0
3779985 1951464 1951464 defendant Incledon Robert gent 593193 593193 Incledon, Robert, of Braunton Abbot, gent 2
3797124 1956983 1956983 defendant Bery Anthony gent 593193 593193 Bery, Anthony, of Braunton, gent 0
3797125 1956983 1956983 defendant Bery Margaret widow 593193 593193 Bery, Margaret, of Braunton, widow 1
3806458 1959932 1959932 defendant More James barker 593193 593193 More, James, of Braunton, barker 0
3813081 1961998 1961998 defendant May Robert weaver 593193 593193 May, Robert, of Braunton, weaver 0
3817257 1963308 1963308 defendant Wyat Walter husbandman 593193 593193 Wyat, Walter, of Braunton, husbandman 0
3824688 1965596 1965596 defendant Broke William husbandman 593193 593193 Broke, William, of Braunton, husbandman 0
3824689 1965596 1965596 defendant Taylor Clement husbandman 593193 593193 Taylor, Clement, of Braunton, husbandman 1
3824690 1965596 1965596 defendant Dirward Richard husbandman 593193 593193 Dirward, Richard, of Braunton, husbandman 2
3824691 1965596 1965596 defendant Walkehey Thomas   593193 593193 Walkehey, Thomas, of Braunton, groom 3
3824692 1965596 1965596 defendant Northwoode Richard husbandman 593193 593193 Northwoode, Richard, of Braunton, husbandman 4
3824693 1965596 1965596 defendant Cokke Thomas husbandman 593193 593193 Cokke, Thomas, of Braunton, husbandman 5
3824974 1965684 1965684 defendant Drewe William husbandman 593193 593193 Drewe, William, of Braunton, husbandman 0
3842241 1971118 1971118 defendant Ingcledon Thomas gent 593193 593193 Ingcledon, Thomas, of Braunton Abbot, gent 1
3858118 1976195 1976195 plaintiff Bery Thomas gent 593193 593193 Bery, Thomas, of Braunton, gent 0
3884397 1985051 1985051 defendant Incleden Robert gent 593193 593193 Incleden, Robert, of Braunton, gent 0
3890295 1987002 1987002 defendant Marke John merchant 593193 593193 Marke, John, of Braunton, merchant 0
3891238 1987334 1987334 defendant Mesaven John smith 593193 593193 Mesaven, John, of Braunton, smith 0
3898017 1989543 1989543 defendant Incleden Robert gent 593193 593193 Incleden, Robert, of Braunton, gent 0
3898459 1989697 1989697 defendant Marke John merchant 593193 593193 Marke, John, of Braunton, merchant 0
3912293 1994441 1994441 defendant Durward John   593193 593193 Durward, John, of Braunton, groom 0
3912294 1994441 1994441 defendant Davye Margaret spinster 593193 593193 Davye, Margaret, of Braunton, spinster 1
3912296 1994442 1994442 defendant Incledene John gent 593193 593193 Incledene, John, of Braunton, gent 0
3912298 1994443 1994443 defendant Incledene Robert gent 593193 593193 Incledene, Robert, of Braunton, gent 0
3928799 1999968 1999968 defendant Yoe William gent 593193 593193 Yoe, William, of Braunton, gent 0
3930187 2000442 2000442 defendant Sheve John husbandman 593193 593193 Sheve, John, of Braunton, husbandman 0
3930231 2000461 2000461 defendant Humfrey Thomas   593193 593193 Humfrey, Thomas, of Braunton, mason 0
3930458 2000534 2000534 defendant Incledon Thomas husbandman 593193 593193 Incledon, Thomas, of Braunton, husbandman 0
3934704 2001903 2001903 defendant Symon Lawrnece husbandman 593193 593193 Symon, Lawrnece, of Braunton, husbandman 0
3935009 2002014 2002014 defendant Symon Lawrnece husbandman 593193 593193 Symon, Lawrnece, of Braunton, husbandman 0
3939455 2003501 2003501 defendant Inckedon Thomas gent 593193 593193 Inckedon, Thomas, of Braunton, gent 0
3939456 2003501 2003501 defendant Shaptor William yeoman 593193 593193 Shaptor, William, of Braunton, yeoman 1
3942729 2004572 2004572 defendant Dyer Philip husbandman 593193 593193 Dyer, Philip, of Braunton, husbandman 0
3943037 2004681 2004681 defendant Bery Anthony esq 593193 593193 Bery, Anthony, of Braunton, esq 0
3944932 2005323 2005323 plaintiff Bery Thomas gent 593193 593193 Bery, Thomas, of Braunton, gent 0
3981667 2018200 2018200 defendant Bellewe Fulk gent 593193 593193 Bellewe, Fulk, of Braunton, gent 0
4022780 2032871 2032871 defendant Knyll Mathew husbandman 593193 593193 Knyll, Mathew, of Braunton, husbandman 1
4022784 2032872 2032872 defendant Knyll Mathew husbandman 593193 593193 Knyll, Mathew, of Braunton, husbandman 1
4024134 2033336 2033336 plaintiff Berye Thomas (legal representative) 593193 593193 Berye, Thomas, of Braunton, executors of 0
4032329 2036234 2036234 defendant Bennett alias Wheke John husbandman 593193 593193 Bennett alias Wheke, John, of Braunton, husbandman 0
4131778 2071682 2071682 defendant Incledon James gent 593193 593193 Incledon, James, of Braunton, gent 0
4163180 2082653 2082653 defendant Ricard Henry smith 593193 593193 Ricard, Henry, of Braunton, smith 2
4172354 2085792 2085792 defendant Hough John tailor 593193 593193 Hough, John, of Braunton, tailor 0
4172355 2085792 2085792 defendant Hough Paul yeoman 593193 593193 Hough, Paul, of Braunton, yeoman 1
4284884 2124642 2124642 defendant Sheperd alias Hooper John yeoman 593193 593193 Sheperd alias Hooper, John, of Braunton, yeoman 0
4284886 2124643 2124643 defendant Sheperd alias Hooper John yeoman 593193 593193 Sheperd alias Hooper, John, of Braunton, yeoman 0
4307614 2132801 2132801 defendant Hordon Peter husbandman 593193 593193 Hordon, Peter, of Braunton, husbandman 0
4315732 2135612 2135612 defendant Shephurde Richard husbandman 593193 593193 Shephurde, Richard, of Braunton, husbandman 0
4353212 2148351 2148351 defendant Bery Humphrey gent 593193 593193 Bery, Humphrey, of Braunton, gent 0
4369707 2154224 2154224 defendant Allen Robert husbandman 593193 593193 Allen, Robert, of Braunton, husbandman 0
4395780 2163174 2163174 defendant Incledon James gent 593193 593193 Incledon, James, of Braunton, gent 0
4397375 2163700 2163700 defendant Allen Robert husbandman 593193 593193 Allen, Robert, of Braunton, husbandman 0
4408824 2167549 2167549 defendant Peter alias Burren George husbandman 593193 593193 Peter alias Burren, George, of Braunton, husbandman 0
4444568 2183277 2183277 defendant Chaunterel Adam   593193 593193 Chaunterel, Adam, of Braunton 0
4557937 2218412 2218412 defendant Worthyan William   593193 593193 Worthyan, William, of Braunton 0
4557938 2218412 2218412 defendant Begworthy John   593193 593193 Begworthy, John, of Braunton 1
4557939 2218412 2218412 defendant Pyke Thomas   593193 593193 Pyke, Thomas, of Braunton 2
4673886 2257448 2257448 defendant Loff William husbandman 593193 593193 Loff, William, of Braunton, husbandman 1
4695519 2264080 2264080 defendant Mareys Henry husbandman 593193 593193 Mareys, Henry, of Braunton, husbandman 2
4708011 2267877 2267877 defendant Fissher John husbandman 593193 593193 Fissher, John, of Braunton, husbandman 1
4743035 2278480 2278480 defendant Midilton Robert de   593193 593193 Midilton, Robert de, of Braunton, vicar 0
4792486 2293737 2293737 defendant Walter Thomas husbandman 593193 593193 Walter, Thomas, of Braunton, husbandman 1
4792488 2293737 2293737 defendant Tybbe Thomas husbandman 593193 593193 Tybbe, Thomas, of Braunton, husbandman 3
4812327 2299968 2299968 defendant Tybell John husbandman 593193 593193 Tybell, John, of Braunton, husbandman 0
4812328 2299968 2299968 defendant atte Wylle Richard yeoman 593193 593193 atte Wylle, Richard, of Braunton, yeoman 1
4817344 2301512 2301512 defendant Danyel John husbandman 593193 593193 Danyel, John, of Braunton, husbandman 0
4817345 2301512 2301512 defendant Fayrelynche Thomas husbandman 593193 593193 Fayrelynche, Thomas, of Braunton, husbandman 1
4827564 2304669 2304669 defendant Chaunterell Thomas, senior husbandman 593193 593193 Chaunterell, Thomas, senior, of Braunton, husbandman 3
4833637 2306527 2306527 defendant Matter Richard husbandman 593193 593193 Matter, Richard, of Braunton, husbandman 1
4833638 2306527 2306527 defendant Werell William husbandman 593193 593193 Werell, William, of Braunton, husbandman 2
4833639 2306527 2306527 defendant Philippe Thomas husbandman 593193 593193 Philippe, Thomas, of Braunton, husbandman 3
4865591 2316203 2316203 defendant Okevylle William husbandman 593193 593193 Okevylle, William, of Braunton, husbandman 0
4868660 2317171 2317171 defendant Matter Richard husbandman 593193 593193 Matter, Richard, of Braunton, husbandman 1
4868661 2317171 2317171 defendant Werell William husbandman 593193 593193 Werell, William, of Braunton, husbandman 2
4868662 2317171 2317171 defendant Philippe Thomas husbandman 593193 593193 Philippe, Thomas, of Braunton, husbandman 3
4890202 2323707 2323707 defendant Philip Thomas husbandman 593193 593193 Philip, Thomas, of Braunton, husbandman 0
4890203 2323707 2323707 defendant Werell William husbandman 593193 593193 Werell, William, of Braunton, husbandman 1
4900784 2326879 2326879 defendant Thomelony John husbandman 593193 593193 Thomelony, John, of Braunton, husbandman 1
4900785 2326879 2326879 defendant Wethir Philip husbandman 593193 593193 Wethir, Philip, of Braunton, husbandman 2
4913718 2330790 2330790 defendant Hare John   593193 593193 Hare, John, of Braunton, mason 0
4922191 2333355 2333355 defendant Colemore John husbandman 593193 593193 Colemore, John, of Braunton, husbandman 0
4922193 2333355 2333355 defendant Ayssh John husbandman 593193 593193 Ayssh, John, of Braunton, husbandman 2
4938876 2338551 2338551 defendant Matter Richard yeoman 593193 593193 Matter, Richard, of Braunton, yeoman 0
4938877 2338551 2338551 defendant Courtenay Thomas butcher 593193 593193 Courtenay, Thomas, of Braunton, butcher 1
4938878 2338551 2338551 defendant Gybbe Walter turner 593193 593193 Gybbe, Walter, of Braunton, turner 2
4939050 2338601 2338601 defendant Attewill Richard husbandman 593193 593193 Attewill, Richard, of Braunton, husbandman 2
4948571 2341533 2341533 defendant Taillouor William mercer 593193 593193 Taillouor, William, of Braunton, mercer 1
4951944 2342555 2342555 defendant Marys Henry husbandman 593193 593193 Marys, Henry, of Braunton, husbandman 3
4958315 2344454 2344454 defendant Felde Stephen   593193 593193 Felde, Stephen, of Braunton 3
4962995 2345845 2345845 defendant Broun William   593193 593193 Broun, William, of Braunton, bailiff 7
4964765 2346374 2346374 defendant atte Wille Richard husbandman 593193 593193 atte Wille, Richard, of Braunton, husbandman 2
4964772 2346375 2346375 defendant atte Wyll Richard husbandman 593193 593193 atte Wyll, Richard, of Braunton, husbandman 2
4970617 2348150 2348150 defendant More Robert yeoman 593193 593193 More, Robert, of Braunton, yeoman 8

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