names

305 rows where place_id = 594816

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617741 1873173 1873173 defendant Taillour John tailor 594816 594816 Taillour, John, of Monmouth, tailor 1
3721708 1933072 1933072 defendant Mathewe John merchant 594816 594816 Mathewe, John, of Monmouth, merchant 1
3729393 1935441 1935441 defendant Morgan Philip draper 594816 594816 Morgan, Philip, of Monmouth, draper 1
3729398 1935442 1935442 defendant Morgan Philip draper 594816 594816 Morgan, Philip, of Monmouth, draper 1
3842136 1971091 1971091 defendant Bully Lewis shoemaker 594816 594816 Bully, Lewis, of Monmouth, shoemaker 1
3891657 1987464 1987464 defendant Smythe James smith 594816 594816 Smythe, James, of Monmouth, smith 0
3891658 1987464 1987464 defendant Smythe John smith 594816 594816 Smythe, John, of Monmouth, smith 1
3892424 1987714 1987714 defendant Watte John fisher 594816 594816 Watte, John, of Monmouth, fisher 3
3892425 1987714 1987714 defendant Davys Richard fusher 594816 594816 Davys, Richard, of Monmouth, fusher 4
3897390 1989342 1989342 defendant Parcivall Thomas merchant 594816 594816 Parcivall, Thomas, of Monmouth, merchant 2
3897391 1989342 1989342 defendant Parcivall John merchant 594816 594816 Parcivall, John, of Monmouth, merchant 3
3898032 1989549 1989549 defendant ap Gwylliam Walter mercer 594816 594816 ap Gwylliam, Walter, of Monmouth, mercer 0
3899137 1989919 1989919 defendant ap Hoell Lewis cordwainer 594816 594816 ap Hoell, Lewis, of Monmouth, cordwainer 0
3900394 1990365 1990365 defendant Acombe William tanner 594816 594816 Acombe, William, of Monmouth, tanner 0
3906802 1992566 1992566 defendant Davys Richard yeoman 594816 594816 Davys, Richard, of Monmouth, yeoman 1
3917960 1996371 1996371 defendant Gwilliam William shoemaker 594816 594816 Gwilliam, William, of Monmouth, shoemaker 0
3917962 1996372 1996372 defendant Gwyllam William shoemaker 594816 594816 Gwyllam, William, of Monmouth, shoemaker 0
3944886 2005306 2005306 defendant Taylor Thomas capper 594816 594816 Taylor, Thomas, of Monmouth, capper 1
3948577 2006563 2006563 defendant Hooper John husbandman 594816 594816 Hooper, John, of Monmouth, husbandman 0
3950735 2007331 2007331 defendant Bocher Richard butcher 594816 594816 Bocher, Richard, of Monmouth, butcher 2
3950987 2007413 2007413 defendant Cotton John pewterer 594816 594816 Cotton, John, of Monmouth, pewterer 0
3953791 2008402 2008402 defendant Kynyllyn Philip gent 594816 594816 Kynyllyn, Philip, of Monmouth, gent 0
3953792 2008402 2008402 defendant Mason William, senior baker 594816 594816 Mason, William, senior, of Monmouth, baker 1
3953798 2008404 2008404 defendant ap John Thomas, senior gent 594816 594816 ap John, Thomas, senior, of Monmouth, gent 0
3953799 2008404 2008404 defendant Gillam David yeoman 594816 594816 Gillam, David, of Monmouth, yeoman 1
3953812 2008409 2008409 defendant ap Phillip David John yeoman 594816 594816 ap Phillip, David John, of Monmouth, yeoman 0
3953817 2008410 2008410 defendant Jones Hugh yeoman 594816 594816 Jones, Hugh, of Monmouth, yeoman 3
3953818 2008410 2008410 defendant Mason William yeoman 594816 594816 Mason, William, of Monmouth, yeoman 4
3960916 2010915 2010915 defendant ap Owen John yeoman 594816 594816 ap Owen, John, of Monmouth, yeoman 0
3961763 2011215 2011215 defendant Fryere Mathew mercer 594816 594816 Fryere, Mathew, of Monmouth, mercer 0
3964771 2012285 2012285 defendant a Gwyllym James yeoman 594816 594816 a Gwyllym, James, of Monmouth, yeoman 0
3966985 2013083 2013083 defendant Cotton John chapman or brasier 594816 594816 Cotton, John, of Monmouth, or of Carmarthen, chapman or brasier 0
3970845 2014382 2014382 defendant Baker Hugh chapman 594816 594816 Baker, Hugh, of Monmouth, chapman 1
3971597 2014626 2014626 defendant Jones Richard capper 594816 594816 Jones, Richard, of Monmouth, capper 0
3973979 2015469 2015469 defendant Beynham Walter husbandman 594816 594816 Beynham, Walter, of Monmouth, husbandman 0
3974586 2015677 2015677 defendant Gillam or William Thomas shoemaker 594816 594816 Gillam or William, Thomas, of Monmouth, shoemaker 1
3975573 2016022 2016022 defendant Cock Walter gent 594816 594816 Cock, Walter, of Monmouth, gent 0
3975574 2016022 2016022 defendant ap John Thomas gent 594816 594816 ap John, Thomas, of Monmouth, gent 1
3976000 2016173 2016173 defendant Sare James Owen husbandman 594816 594816 Sare, James Owen, of Monmouth, husbandman 0
3976001 2016173 2016173 defendant ap Hoell David ap David husbandman 594816 594816 ap Hoell, David ap David, of Monmouth, husbandman 1
3976002 2016173 2016173 defendant Glover Maurice David laborer 594816 594816 Glover, Maurice David, of Monmouth, laborer 2
3976003 2016173 2016173 defendant Antony alias Glover John husbandman 594816 594816 Antony alias Glover, John, of Monmouth, husbandman 3
3976004 2016173 2016173 defendant Watkyn Howell laborer 594816 594816 Watkyn, Howell, of Monmouth, laborer 4
3977755 2016789 2016789 defendant Whytney James gent 594816 594816 Whytney, James, of Monmouth, gent 3
3979038 2017255 2017255 defendant Walker Thomas husbandman 594816 594816 Walker, Thomas, of Monmouth, husbandman 1
3982313 2018447 2018447 defendant Mathew John husbandman 594816 594816 Mathew, John, of Monmouth, husbandman 0
3982502 2018519 2018519 defendant Cock William shoemaker 594816 594816 Cock, William, of Monmouth, shoemaker 0
3982503 2018519 2018519 defendant Rogers Richard yeoman 594816 594816 Rogers, Richard, of Monmouth, yeoman 1
3982538 2018531 2018531 defendant Tanner Thomas yeoman 594816 594816 Tanner, Thomas, of Monmouth, yeoman 0
3982539 2018531 2018531 defendant Tanner Richard laborer 594816 594816 Tanner, Richard, of Monmouth, laborer 1
3982540 2018531 2018531 defendant Philpot James laborer 594816 594816 Philpot, James, of Monmouth, laborer 2
3982541 2018531 2018531 defendant John Griffin laborer 594816 594816 John, Griffin, of Monmouth, laborer 3
3982542 2018531 2018531 defendant Worall Thomas butcher 594816 594816 Worall, Thomas, of Monmouth, butcher 4
3983434 2018851 2018851 defendant George William yeoman 594816 594816 George, William, of Monmouth, yeoman 0
3983657 2018923 2018923 defendant Harper Philip capper 594816 594816 Harper, Philip, of Monmouth, capper 3
3985320 2019506 2019506 defendant Leyghton James yeoman 594816 594816 Leyghton, James, of Monmouth, yeoman 0
3985931 2019734 2019734 defendant Hopkyns alias Sayer Hugh tanner 594816 594816 Hopkyns alias Sayer, Hugh, of Monmouth, tanner 0
3986780 2020014 2020014 defendant Wynter William yeoman 594816 594816 Wynter, William, of Monmouth, yeoman 0
3986781 2020014 2020014 defendant Owen William yeoman 594816 594816 Owen, William, of Monmouth, yeoman 1
3986782 2020014 2020014 defendant George William yeoman 594816 594816 George, William, of Monmouth, yeoman 2
3986783 2020014 2020014 defendant Powell Richard husbandman 594816 594816 Powell, Richard, of Monmouth, husbandman 3
3986784 2020014 2020014 defendant Grace David husbandman 594816 594816 Grace, David, of Monmouth, husbandman 4
3986793 2020018 2020018 defendant Williams Robert   594816 594816 Williams, Robert, of Monmouth, gent, castle bailiff in Monmouth 1
3986799 2020020 2020020 defendant Owen William yeoman 594816 594816 Owen, William, of Monmouth, yeoman 0
3988394 2020595 2020595 defendant Clerke Robert yeoman 594816 594816 Clerke, Robert, of Monmouth, yeoman 0
3988400 2020596 2020596 defendant Hughe William gent 594816 594816 Hughe, William, of Monmouth, gent 1
3988401 2020596 2020596 defendant Vaughan William gent 594816 594816 Vaughan, William, of Monmouth, gent 2
3995960 2023310 2023310 defendant Mason William, senior yeoman 594816 594816 Mason, William, senior, of Monmouth, yeoman 0
3995961 2023310 2023310 defendant Sayre Owen yeoman 594816 594816 Sayre, Owen, of Monmouth, yeoman 1
3995965 2023312 2023312 defendant Williams Richard gent 594816 594816 Williams, Richard, of Monmouth, gent 0
3997766 2023957 2023957 defendant ap Philyppe alias Diphom Howell husbandman 594816 594816 ap Philyppe alias Diphom, Howell, of Monmouth, husbandman 0
3999994 2024763 2024763 plaintiff Gillam or William William (legal representative) 594816 594816 Gillam or William, William, of Monmouth, gent, administratrix of 0
4000061 2024788 2024788 plaintiff Glin William (legal representative) 594816 594816 Glin, William, of Monmouth, gent, administratrix of 0
4000769 2025042 2025042 defendant Fryer Mathew yeoman 594816 594816 Fryer, Mathew, of Monmouth, yeoman 0
4001961 2025480 2025480 defendant Lawrence Humphrey clerk 594816 594816 Lawrence, Humphrey, of Monmouth, clerk 0
4002628 2025710 2025710 defendant Williams Thomas (legal representative) 594816 594816 Williams, Thomas, of Monmouth, gent, executor of 2
4002629 2025710 2025710 defendant Willyams Robert gent 594816 594816 Willyams, Robert, of Monmouth, gent 3
4003874 2026150 2026150 defendant Baker Hugh chapman 594816 594816 Baker, Hugh, of Monmouth, chapman 0
4003875 2026150 2026150 defendant Sherman Richard yeoman 594816 594816 Sherman, Richard, of Monmouth, yeoman 1
4003876 2026150 2026150 defendant Ryce Simon butcher 594816 594816 Ryce, Simon, of Monmouth, butcher 2
4004436 2026366 2026366 defendant Jones Thomas yeoman 594816 594816 Jones, Thomas, of Monmouth, yeoman 0
4004437 2026366 2026366 defendant Whytney James gent 594816 594816 Whytney, James, of Monmouth, gent 1
4004541 2026396 2026396 defendant John Edmund tailor 594816 594816 John, Edmund, of Monmouth, tailor 1
4004781 2026487 2026487 defendant Rychard Hopkin husbandman 594816 594816 Rychard, Hopkin, of Monmouth, husbandman 0
4005646 2026795 2026795 plaintiff Kynnyllyn John   594816 594816 Kynnyllyn, John, of Monmouth, gent, attorney of the bench 0
4005649 2026795 2026795 defendant John Thomas, senior yeoman 594816 594816 John, Thomas, senior, of Monmouth, yeoman 2
4005651 2026795 2026795 defendant Harper Philip capper 594816 594816 Harper, Philip, of Monmouth, capper 4
4005652 2026795 2026795 defendant Smyth John smith 594816 594816 Smyth, John, of Monmouth, smith 5
4006509 2027107 2027107 defendant Nycholas alias Bocher Richard butcher 594816 594816 Nycholas alias Bocher, Richard, of Monmouth, butcher 0
4008966 2027971 2027971 defendant Fortune Walter capper 594816 594816 Fortune, Walter, of Monmouth, capper 1
4008986 2027977 2027977 defendant Harper Philip capper 594816 594816 Harper, Philip, of Monmouth, capper 1
4008989 2027978 2027978 defendant Harper Philip capper 594816 594816 Harper, Philip, of Monmouth, capper 1
4011823 2028965 2028965 defendant Taylor William yeoman 594816 594816 Taylor, William, of Monmouth, yeoman 0
4011824 2028965 2028965 defendant Tanner Morgan glover 594816 594816 Tanner, Morgan, of Monmouth, glover 1
4011825 2028965 2028965 defendant A Gillam Richard tailor 594816 594816 A Gillam, Richard, of Monmouth, tailor 2
4011826 2028965 2028965 defendant Robert William glover 594816 594816 Robert, William, of Monmouth, glover 3
4011827 2028965 2028965 defendant Capper William yeoman 594816 594816 Capper, William, of Monmouth, yeoman 4
4011840 2028968 2028968 defendant Wever Hugh yeoman or butcher 594816 594816 Wever, Hugh, of Monmouth, yeoman or butcher 3
4013173 2029444 2029444 defendant Fortune Walter capper 594816 594816 Fortune, Walter, of Monmouth, capper 0
4013322 2029498 2029498 defendant Vaughan Reginald gent 594816 594816 Vaughan, Reginald, of Monmouth, gent 0

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