names

83 rows where place_id = 624561

✎ 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
3641829 1907894 1907894 plaintiff Bronde Richard (legal representative) 624561 624561 Bronde, Richard, of Newporte, executor of 0
3710676 1929659 1929659 defendant Marschall William mercer 624561 624561 Marschall, William, of Newporte, or of Stortford, Herts, mercer 0
3758888 1944770 1944770 defendant Benet John yeoman 624561 624561 Benet, John, of Newporte, yeoman 0
3899064 1989897 1989897 plaintiff Barnfeld Robert tanner 624561 624561 Barnfeld, Robert, of Newporte, tanner 0
3906702 1992534 1992534 defendant ap Jenn Martin yeoman 624561 624561 ap Jenn, Martin, of Newporte, yeoman 0
3912954 1994664 1994664 plaintiff Baker Maurice   624561 624561 Baker, Maurice, of Newporte 0
3913150 1994733 1994733 plaintiff Barnefeld Robert tanner 624561 624561 Barnefeld, Robert, of Newporte, tanner 0
3913153 1994734 1994734 plaintiff Barnefeld Robert tanner 624561 624561 Barnefeld, Robert, of Newporte, tanner 0
3921408 1997501 1997501 defendant Wodcocke Thurstan yeoman 624561 624561 Wodcocke, Thurstan, of Newporte, yeoman 0
3921409 1997501 1997501 defendant Barnefyld Robert tanner 624561 624561 Barnefyld, Robert, of Newporte, tanner 1
3927882 1999664 1999664 defendant Sotherne John   624561 624561 Sotherne, John, of Newporte, shoe maker 0
3927885 1999665 1999665 defendant Sotherne John   624561 624561 Sotherne, John, of Newporte, shoe maker 0
3927886 1999665 1999665 defendant Reve Christopher   624561 624561 Reve, Christopher, of Newporte, fish monger 1
3927898 1999669 1999669 plaintiff Betenson William yeoman 624561 624561 Betenson, William, of Newporte, yeoman 1
3930673 2000606 2000606 defendant Colys John husbandman 624561 624561 Colys, John, of Newporte, husbandman 1
3931977 2000996 2000996 defendant John Morgan Philip yeoman 624561 624561 John, Morgan Philip, of Newporte, yeoman 0
3948881 2006673 2006673 defendant Hunte John   624561 624561 Hunte, John, of Newporte, Salop mercer 1
3953564 2008319 2008319 defendant ap Jevan William chapman 624561 624561 ap Jevan, William, of Newporte, chapman 0
3966448 2012900 2012900 defendant Hakyn William mercer 624561 624561 Hakyn, William, of Newporte, mercer 0
3966449 2012900 2012900 defendant Barnefyld Robert gent 624561 624561 Barnefyld, Robert, of Newporte, gent 1
3966453 2012901 2012901 defendant Barnefylde Robert gent 624561 624561 Barnefylde, Robert, of Newporte, gent 1
3975175 2015883 2015883 defendant Woodcocke Thurstan gent 624561 624561 Woodcocke, Thurstan, of Newporte, gent 0
3977039 2016537 2016537 defendant Morrys William baker 624561 624561 Morrys, William, of Newporte, baker 1
3977040 2016537 2016537 defendant Apphe Thomas Jones merchant 624561 624561 Apphe, Thomas Jones, of Newporte, merchant 2
3984704 2019287 2019287 defendant Thomas John ap Res yeoman 624561 624561 Thomas, John ap Res, of Newporte, yeoman 2
4018464 2031337 2031337 defendant Staunton William yeoman 624561 624561 Staunton, William, of Newporte, yeoman 0
4023730 2033189 2033189 defendant Tylston Thomas gent 624561 624561 Tylston, Thomas, of Newporte, gent 0
4031174 2035818 2035818 defendant Addams William saddler 624561 624561 Addams, William, of Newporte, saddler 3
4036944 2037888 2037888 defendant Jones David yeoman 624561 624561 Jones, David, of Newporte, yeoman 0
4038911 2038537 2038537 defendant Hopley Richard yeoman 624561 624561 Hopley, Richard, of Newporte, yeoman 1
4048190 2041791 2041791 defendant Lee alias Lancashire John tanner 624561 624561 Lee alias Lancashire, John, of Newporte, tanner 0
4048193 2041791 2041791 defendant Chandler John glover 624561 624561 Chandler, John, of Newporte, glover 3
4049534 2042277 2042277 defendant Staunton William yeoman 624561 624561 Staunton, William, of Newporte, yeoman 0
4050777 2042716 2042716 defendant ap John David ap John yeoman 624561 624561 ap John, David ap John, of Newporte, yeoman 0
4054663 2044057 2044057 defendant Cope Thomas shoemaker 624561 624561 Cope, Thomas, of Newporte, shoemaker 1
4054664 2044057 2044057 defendant Challoner or Chawner John yeoman 624561 624561 Challoner or Chawner, John, of Newporte, yeoman 2
4055229 2044265 2044265 plaintiff Bendbowe Thomas   624561 624561 Bendbowe, Thomas, of Newporte 0
4066629 2048359 2048359 defendant Mathewe John vintner 624561 624561 Mathewe, John, of Newporte, vintner 1
4069476 2049364 2049364 plaintiff Lloyd Thomas   624561 624561 Lloyd, Thomas, of Newporte 0
4069477 2049364 2049364 defendant Powell John merchant 624561 624561 Powell, John, of Newporte, merchant 0
4074145 2051050 2051050 defendant Chaundler or Chaundlesse John glover 624561 624561 Chaundler or Chaundlesse, John, of Newporte, glover 0
4076891 2052023 2052023 defendant Tylston Thomas gent 624561 624561 Tylston, Thomas, of Newporte, gent 0
4079920 2053119 2053119 defendant Wylson Robert butcher 624561 624561 Wylson, Robert, of Newporte, butcher 0
4108754 2063382 2063382 defendant Kynaston William gent 624561 624561 Kynaston, William, of Newporte, gent 3
4118280 2066825 2066825 defendant Cardiff Thomas gent 624561 624561 Cardiff, Thomas, of Newporte, gent 0
4118281 2066825 2066825 defendant Strynger Thomas laborer 624561 624561 Strynger, Thomas, of Newporte, laborer 1
4118282 2066825 2066825 defendant Swayne John laborer 624561 624561 Swayne, John, of Newporte, laborer 2
4124461 2069044 2069044 defendant Nutley Michael glover 624561 624561 Nutley, Michael, of Newporte, glover 1
4133126 2072176 2072176 defendant Morgane John butcher 624561 624561 Morgane, John, of Newporte, butcher 2
4146624 2076972 2076972 defendant Kynnaston David gent 624561 624561 Kynnaston, David, of Newporte, or of Crickett, gent 1
4146625 2076972 2076972 defendant Fynche Richard yeoman 624561 624561 Fynche, Richard, of Newporte, or of Bageley, yeoman 2
4146626 2076972 2076972 defendant Dawll John husbandman 624561 624561 Dawll, John, of Newporte, or of Whitchurche, husbandman 3
4154373 2079620 2079620 defendant Watkyn William yeoman 624561 624561 Watkyn, William, of Newporte, yeoman 2
4161806 2082198 2082198 defendant ap David Lewis yeoman 624561 624561 ap David, Lewis, of Newporte, or of Llanowthelen, Montgomery, yeoman 0
4163533 2082769 2082769 defendant Bickerton John yeoman 624561 624561 Bickerton, John, of Newporte, or of Marberye, Cheshire, yeoman 0
4163534 2082769 2082769 defendant ap Edward Roger ap John gent 624561 624561 ap Edward, Roger ap John, of Newporte, or of Althe, Flint, gent 1
4179391 2088267 2088267 defendant Cole Thomas, junior yeoman 624561 624561 Cole, Thomas, junior, of Newporte, yeoman 0
4182507 2089360 2089360 defendant ap Lluwellen John ap David glover 624561 624561 ap Lluwellen, John ap David, of Newporte, yeoman, or of Newetowne, Montgomery, glover 0
4187093 2090977 2090977 defendant Lynyall John yeoman 624561 624561 Lynyall, John, of Newporte, or of Elsmeyr, yeoman 1
4202225 2096320 2096320 defendant Boocher John ap John yeoman 624561 624561 Boocher, John ap John, of Newporte, yeoman 1
4219540 2102336 2102336 defendant Robert William yeoman 624561 624561 Robert, William, of Newporte, yeoman 0
4220485 2102667 2102667 defendant Jones John yeoman 624561 624561 Jones, John, of Newporte, yeoman 0
4221182 2102908 2102908 defendant William Edmund husbandman 624561 624561 William, Edmund, of Newporte, husbandman 0
4221463 2102998 2102998 defendant Johnston Thomas yeoman 624561 624561 Johnston, Thomas, of Newporte, yeoman 2
4221511 2103014 2103014 defendant Johnson Thomas yeoman 624561 624561 Johnson, Thomas, of Newporte, yeoman 2
4229342 2105744 2105744 defendant Felton William husbandman 624561 624561 Felton, William, of Newporte, husbandman 0
4232596 2106904 2106904 defendant Kemmys Giles gent 624561 624561 Kemmys, Giles, of Newporte, gent 1
4298567 2129593 2129593 defendant Cowley Roger butcher 624561 624561 Cowley, Roger, of Newporte, butcher 0
4306919 2132561 2132561 defendant Cowley Roger butcher 624561 624561 Cowley, Roger, of Newporte, butcher 0
4311087 2134028 2134028 defendant Caston John   624561 624561 Caston, John, of Newporte, Glos, clothier, horse carrier 0
4320189 2137163 2137163 defendant Mylner William alderman 624561 624561 Mylner, William, of Newporte, alderman 0
4320191 2137164 2137164 defendant Parke Robert husbandman 624561 624561 Parke, Robert, of Newporte, husbandman 0
4364855 2152482 2152482 defendant Worrall Hugh gent 624561 624561 Worrall, Hugh, of Newporte, gent 0
4373020 2155420 2155420 defendant William Lewis yeoman 624561 624561 William, Lewis, of Newporte, yeoman 0
4373026 2155421 2155421 defendant Martin Thomas yeoman 624561 624561 Martin, Thomas, of Newporte, yeoman 1
4373028 2155422 2155422 defendant Weste John tailor 624561 624561 Weste, John, of Newporte, tailor 0
4373029 2155422 2155422 defendant Morgan Jenkin yeoman 624561 624561 Morgan, Jenkin, of Newporte, yeoman 1
4373030 2155422 2155422 defendant Robert Henry yeoman 624561 624561 Robert, Henry, of Newporte, yeoman 2
4375345 2156235 2156235 defendant Robert William gent 624561 624561 Robert, William, of Newporte, gent 1
4376604 2156703 2156703 defendant William Philip yeoman 624561 624561 William, Philip, of Newporte, yeoman 1
4376605 2156703 2156703 defendant Martyn Thomas gent 624561 624561 Martyn, Thomas, of Newporte, gent 2
4376900 2156811 2156811 defendant Robert William gent 624561 624561 Robert, William, of Newporte, gent 0
4412595 2168802 2168802 defendant Eyton Thomas tanner 624561 624561 Eyton, Thomas, of Newporte, tanner 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);