names

95 rows where place_id = 586634

✎ 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
3589272 1864285 1864285 defendant Pye Thomas husbandman 586634 586634 Pye, Thomas, of Hallesworth, husbandman 0
3593950 1865744 1865744 defendant Fleccher John husbandman 586634 586634 Fleccher, John, of Hallesworth, husbandman 0
3593960 1865749 1865749 defendant Daweson Robert clerk 586634 586634 Daweson, Robert, of Hallesworth, clerk 0
3593962 1865750 1865750 defendant Daweson Robert clerk 586634 586634 Daweson, Robert, of Hallesworth, clerk 0
3707830 1928746 1928746 defendant Barret Robert dyer 586634 586634 Barret, Robert, of Hallesworth, dyer 0
3750091 1941943 1941943 defendant Barrett Robert sherman 586634 586634 Barrett, Robert, of Hallesworth, sherman 0
3761470 1945599 1945599 defendant Neve John butcher 586634 586634 Neve, John, of Hallesworth, butcher 2
3769143 1948003 1948003 defendant Pecke Richard butcher 586634 586634 Pecke, Richard, of Hallesworth, butcher 0
3770609 1948491 1948491 plaintiff Smyth Roger   586634 586634 Smyth, Roger, of Hallesworth 0
3775823 1950188 1950188 plaintiff Bradley Christopher tanner 586634 586634 Bradley, Christopher, of Hallesworth, tanner 0
3775826 1950188 1950188 defendant Flyke Henry shoemaker 586634 586634 Flyke, Henry, of Hallesworth, shoemaker 2
3783632 1952640 1952640 defendant Edmondys William   586634 586634 Edmondys, William, of Hallesworth, mason 0
3786157 1953463 1953463 defendant Bradley Christopher tanner 586634 586634 Bradley, Christopher, of Hallesworth, tanner 0
3811624 1961533 1961533 defendant Jones Hugh draper 586634 586634 Jones, Hugh, of Hallesworth, draper 0
3814379 1962411 1962411 defendant Davy John husbandman 586634 586634 Davy, John, of Hallesworth, husbandman 1
3833051 1968260 1968260 defendant Flykke John tanner 586634 586634 Flykke, John, of Hallesworth, tanner 1
3837356 1969594 1969594 defendant Appylby Thomas yeoman 586634 586634 Appylby, Thomas, of Hallesworth, yeoman 0
3848574 1973138 1973138 plaintiff John Hugh (legal representative) 586634 586634 John, Hugh, of Hallesworth, yeoman, executors of 0
3865726 1978761 1978761 plaintiff Norton Walter yeoman 586634 586634 Norton, Walter, of Hallesworth, yeoman 0
3880701 1983808 1983808 defendant Hopton Edward butcher 586634 586634 Hopton, Edward, of Hallesworth, butcher 1
3881815 1984171 1984171 plaintiff Smyth Nicholas mercer 586634 586634 Smyth, Nicholas, of Hallesworth, mercer 0
3884519 1985095 1985095 defendant Felcham Thomas husbandman 586634 586634 Felcham, Thomas, of Hallesworth, husbandman 1
3888576 1986440 1986440 defendant Launce John yeoman 586634 586634 Launce, John, of Hallesworth, yeoman 0
3888577 1986440 1986440 defendant Smith Nicholas mercer 586634 586634 Smith, Nicholas, of Hallesworth, mercer 1
3888578 1986440 1986440 defendant Saunderson Peter yeoman 586634 586634 Saunderson, Peter, of Hallesworth, yeoman 2
3888579 1986440 1986440 defendant Bonette Thomas husbandman 586634 586634 Bonette, Thomas,of Hallesworth, husbandman 3
3888587 1986442 1986442 defendant Saunderson Peter yeoman 586634 586634 Saunderson, Peter, of Hallesworth, yeoman 0
3892779 1987837 1987837 plaintiff Norton Robert gent 586634 586634 Norton, Robert, of Hallesworth, gent 0
3892789 1987839 1987839 plaintiff Norton Walter (legal representative) 586634 586634 Norton, Walter, of Hallesworth, executor of 0
3892791 1987839 1987839 defendant Appylby Thomas yeoman 586634 586634 Appylby, Thomas, of Hallesworth, yeoman 0
3892792 1987839 1987839 defendant Worlyche John husbandman 586634 586634 Worlyche, John, of Hallesworth, husbandman 1
3895278 1988629 1988629 plaintiff Smyth Nicholas   586634 586634 Smyth, Nicholas, of Hallesworth 0
3899366 1990000 1990000 defendant Skarlett Robert yeoman 586634 586634 Skarlett, Robert, of Hallesworth, yeoman 0
3904999 1991936 1991936 plaintiff Hylton Richard (legal representative) 586634 586634 Hylton, Richard, of Hallesworth, executors of 0
3905002 1991936 1991936 defendant Daldy John tanner 586634 586634 Daldy, John, of Hallesworth, tanner 0
3907116 1992670 1992670 defendant Busshe Ralph sherman 586634 586634 Busshe, Ralph, of Hallesworth, sherman 0
3907117 1992671 1992671 plaintiff Norton Robert gent 586634 586634 Norton, Robert, of Hallesworth, gent 0
3907119 1992672 1992672 plaintiff Norton Robert gent 586634 586634 Norton, Robert, of Hallesworth, gent 0
3907125 1992675 1992675 plaintiff Norton Walter (legal representative) 586634 586634 Norton, Walter, of Hallesworth, executor of Robert Fokelyn, clerk, executor of 0
3916241 1995815 1995815 defendant Norton Robert yeoman 586634 586634 Norton, Robert, of Hallesworth, yeoman 0
3916244 1995816 1995816 defendant Saunderson Peter yeoman 586634 586634 Saunderson, Peter, of Hallesworth, yeoman 0
3920905 1997336 1997336 plaintiff Norton Robert   586634 586634 Norton, Robert, of Hallesworth 0
3932176 2001066 2001066 defendant Goodryke Walter glover 586634 586634 Goodryke, Walter, of Hallesworth, glover 0
3937347 2002827 2002827 plaintiff Norton Robert gent 586634 586634 Norton, Robert, of Hallesworth, gent 0
3944333 2005116 2005116 defendant Harman James   586634 586634 Harman, James, of Hallesworth, husbandman, son of Robert Harman, of Shamfelde 0
3948654 2006590 2006590 defendant Bonnett Roger tanner 586634 586634 Bonnett, Roger, of Hallesworth, tanner 1
3951884 2007720 2007720 defendant Payne Robert husbandman 586634 586634 Payne, Robert, of Hallesworth, husbandman 1
3958198 2009940 2009940 defendant Smythe Henry yeoman 586634 586634 Smythe, Henry, of Hallesworth, yeoman 0
4006019 2026928 2026928 plaintiff Launce George singleman 586634 586634 Launce, George, of Hallesworth, singleman 0
4077047 2052076 2052076 defendant Pryme Thomas, senior yeoman or butcher 586634 586634 Pryme, Thomas, senior, of Hallesworth, yeoman or butcher 0
4160428 2081724 2081724 defendant Browne William draper 586634 586634 Browne, William, of Hallesworth, or of Bongaye, Suff, draper 0
4179371 2088259 2088259 defendant Odyerne John merchant 586634 586634 Odyerne, John, of Hallesworth, merchant 0
4181802 2089117 2089117 defendant Pryme John, junior butcher 586634 586634 Pryme, John, junior, of Hallesworth, butcher 0
4203315 2096706 2096706 defendant Gyett John husbandman 586634 586634 Gyett, John, of Hallesworth, husbandman 0
4216087 2101120 2101120 defendant Browne Robert sherman 586634 586634 Browne, Robert, of Hallesworth, sherman 0
4216095 2101121 2101121 defendant Pryme John yeoman 586634 586634 Pryme, John, of Hallesworth, yeoman 3
4242232 2110396 2110396 defendant Nollothe Alexander tanner 586634 586634 Nollothe, Alexander, of Hallesworth, tanner 0
4242233 2110396 2110396 defendant Sparke Francis carpenter 586634 586634 Sparke, Francis, of Hallesworth, carpenter 1
4242234 2110396 2110396 defendant Howe Peter husbandman 586634 586634 Howe, Peter, of Hallesworth, husbandman 2
4258932 2115958 2115958 defendant Smyth Richard shoemaker 586634 586634 Smyth, Richard, of Hallesworth, shoemaker 3
4261534 2116821 2116821 defendant Pryme John butcher 586634 586634 Pryme, John, of Hallesworth, butcher 0
4302187 2130881 2130881 defendant Sadler Richard tailor 586634 586634 Sadler, Richard, of Hallesworth, tailor 0
4337197 2142737 2142737 defendant Crispe Nicholas glover 586634 586634 Crispe, Nicholas, of Hallesworth, glover 0
4947422 2341189 2341189 defendant Edon Thomas skinner 586634 586634 Edon, Thomas, of Hallesworth, skinner 0
4947862 2341312 2341312 defendant Edon Thomas skinner 586634 586634 Edon, Thomas, of Hallesworth, skinner 0
4981920 2351512 2351512 defendant Edon Thomas yeoman 586634 586634 Edon, Thomas, of Hallesworth, yeoman 1
4989599 2353817 2353817 defendant Hang_ (illegible) yeoman 586634 586634 Hang_, _, of Hallesworth, yeoman 4
5002584 2357667 2357667 defendant Roberd William chapman 586634 586634 Roberd, William, of Hallesworth, chapman 4
5002589 2357668 2357668 defendant Roberd William chapman 586634 586634 Roberd, William, of Hallesworth, chapman 3
5151157 2401479 2401479 defendant Dunmowe Henry barber 586634 586634 Dunmowe, Henry, of Hallesworth, barber 0
5169422 2406791 2406791 defendant Dunmowe Henry barber 586634 586634 Dunmowe, Henry, of Hallesworth, barber 0
5293767 2443139 2443139 defendant Roo Walter (legal representative) 586634 586634 Roo, Walter, of Hallesworth, administrator of 1
5383295 2470298 2470298 defendant Goderyth William   586634 586634 Goderyth, William, of Hallesworth 0
5400308 2475163 2475163 defendant Fox Peter turner 586634 586634 Fox, Peter, of Hallesworth, turner 1
5402731 2475857 2475857 defendant Goderyche William butcher 586634 586634 Goderyche, William, of Hallesworth, butcher 0
5413307 2478909 2478909 defendant Fox Peter turner 586634 586634 Fox, Peter, of Hallesworth, turner 1
5415658 2479626 2479626 defendant Goderyche William butcher 586634 586634 Goderyche, William, of Hallesworth, butcher 0
5428488 2483446 2483446 defendant Fox Peter turner 586634 586634 Fox, Peter, of Hallesworth, turner 1
5428491 2483447 2483447 defendant Fox Peter turner 586634 586634 Fox, Peter, of Hallesworth, turner 1
5432069 2484558 2484558 defendant Goderyche William butcher 586634 586634 Goderyche, William, of Hallesworth, butcher 0
5502013 2505552 2505552 plaintiff Sudborn Robert merchant 586634 586634 Sudborn, Robert, of Hallesworth, merchant 0
5505811 2506738 2506738 defendant Hunte John glasier 586634 586634 (Hunte, John, of Hallesworth, glasier 2
5529385 2513704 2513704 defendant Fraunceys Robert yeoman 586634 586634 Fraunceys, Robert, of Hallesworth, yeoman 4
5539132 2516723 2516723 defendant Saunderson John butcher 586634 586634 Saunderson, John, of Hallesworth, butcher 1
5543686 2518133 2518133 defendant Goodale John butcher 586634 586634 Goodale, John, of Hallesworth, butcher 0
5567854 2525177 2525177 plaintiff Fraunceys Robert, senior   586634 586634 Fraunceys, Robert, senior, of Hallesworth 1
5568307 2525275 2525275 defendant Saunderson John butcher 586634 586634 Saunderson, John, of Hallesworth, butcher 0
5570026 2525810 2525810 defendant Coke John yeoman 586634 586634 Coke, John, of Hallesworth, yeoman 1
5570872 2526037 2526037 defendant Norman William tailor 586634 586634 Norman, William, of Hallesworth, tailor 0
5575323 2527371 2527371 defendant Fleccher John yeoman 586634 586634 Fleccher, John, of Hallesworth, yeoman 0
5584604 2530255 2530255 defendant Fleccher John yeoman 586634 586634 Fleccher, John, of Hallesworth, yeoman 0
5599535 2534748 2534748 defendant Palle John tailor 586634 586634 Palle, John, of Hallesworth, tailor 0
5603142 2535869 2535869 plaintiff Norton Walter   586634 586634 Norton, Walter, of Hallesworth 0
5605350 2536552 2536552 plaintiff Fyske William   586634 586634 Fyske, William, of Hallesworth 2
5605355 2536553 2536553 plaintiff Fyske William   586634 586634 Fyske, William, of Hallesworth 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);