names

93 rows where place_id = 641175

✎ 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
3859971 1976837 1976837 defendant Edwardys Robert husbandman 641175 641175 Edwardys, Robert, of Knyghton, husbandman 0
3859972 1976837 1976837 defendant Edwardys John husbandman 641175 641175 Edwardys, John, of Knyghton, husbandman 1
3879467 1983385 1983385 defendant Mawry William baker 641175 641175 Mawry, William, of Knyghton, baker 0
3933831 2001611 2001611 defendant ap Hoell ap Gillm Meredith yeoman 641175 641175 ap Hoell ap Gillm, Meredith, of Knyghton, yeoman 1
3934920 2001984 2001984 plaintiff Hyde Thomas husbandman 641175 641175 Hyde, Thomas, of Knyghton, husbandman 0
3936933 2002685 2002685 defendant ap David Owen yeoman 641175 641175 ap David, Owen, of Knyghton, yeoman 3
3936934 2002685 2002685 defendant ap David Lewis yeoman 641175 641175 ap David, Lewis, of Knyghton, yeoman 4
3947309 2006130 2006130 defendant Remedy or Rennedy John husbandman 641175 641175 Remedy or Rennedy, John, of Knyghton, husbandman 0
3950693 2007316 2007316 defendant Sayer Roger husbandman 641175 641175 Sayer, Roger, of Knyghton, husbandman 0
3950694 2007316 2007316 defendant Sayer George husbandman 641175 641175 Sayer, George, of Knyghton, husbandman 1
3950695 2007316 2007316 defendant Sayer John husbandman 641175 641175 Sayer, John, of Knyghton, husbandman 2
3967223 2013165 2013165 defendant Myllarde John yeoman 641175 641175 Myllarde, John, of Knyghton, yeoman 1
3967224 2013165 2013165 defendant Lane Richard yeoman 641175 641175 Lane, Richard, of Knyghton, yeoman 2
3973236 2015212 2015212 defendant Sayer John yeoman 641175 641175 Sayer, John, of Knyghton, yeoman 0
3991810 2021823 2021823 defendant Gethin Maurice ap Jevan yeoman 641175 641175 Gethin, Maurice ap Jevan, of Knyghton, yeoman 1
3992409 2022051 2022051 defendant Park Richard husbandman 641175 641175 Park, Richard, of Knyghton, husbandman 1
4002508 2025663 2025663 defendant ap Jenkyn Meredith gent 641175 641175 ap Jenkyn, Meredith, of Knyghton, gent 0
4003213 2025910 2025910 defendant Meredyth Howell yeoman 641175 641175 Meredyth, Howell, of Knyghton, yeoman 1
4022327 2032707 2032707 defendant ap Jenkyn Meredith gent 641175 641175 ap Jenkyn, Meredith, of Knyghton, of Radnor, gent 0
4022328 2032707 2032707 defendant Powell John gent 641175 641175 Powell, John, of Knyghton, gent 1
4037752 2038154 2038154 defendant ap Lewys Rice yeoman 641175 641175 ap Lewys, Rice, of Knyghton, yeoman 1
4040310 2039040 2039040 defendant ap Meredyth David gent 641175 641175 ap Meredyth, David, of Knyghton, gent 1
4040319 2039043 2039043 defendant ap Jenkyn Meredith gent 641175 641175 ap Jenkyn, Meredith, of Knyghton, of Radnor, gent 0
4040320 2039043 2039043 defendant ap Meredyth David gent 641175 641175 ap Meredyth, David, of Knyghton, gent 1
4042366 2039751 2039751 defendant ap Meredith David yeoman 641175 641175 ap Meredith, David, of Knyghton, yeoman 1
4043845 2040249 2040249 defendant ap Jenkyn Meredith yeoman 641175 641175 ap Jenkyn, Meredith, of Knyghton, of Radnor, yeoman 0
4063143 2047116 2047116 defendant Powell John gent 641175 641175 Powell, John, of Knyghton, gent 0
4065974 2048119 2048119 defendant Reynoldes David yeoman 641175 641175 Reynoldes, David, of Knyghton, yeoman 4
4087781 2055923 2055923 defendant Johnson John husbandman 641175 641175 Johnson, John, of Knyghton, husbandman 0
4087783 2055924 2055924 defendant Johnson John husbandman 641175 641175 Johnson, John, of Knyghton, husbandman 0
4098196 2059682 2059682 defendant Holme Lawrence carpenter 641175 641175 Holme, Lawrence, of Knyghton, carpenter 2
4098197 2059682 2059682 defendant Holme William weaver 641175 641175 Holme, William, of Knyghton, weaver 3
4100819 2060608 2060608 defendant Holme Lawrence yeoman 641175 641175 Holme, Lawrence, of Knyghton, yeoman 1
4164252 2083021 2083021 defendant Tymberlacke Thomas husbandman 641175 641175 Tymberlacke, Thomas, of Knyghton, husbandman 0
4219095 2102175 2102175 defendant Woldrich John husbandman 641175 641175 Woldrich, John, of Knyghton, husbandman 0
4422814 2171993 2171993 defendant Semer John   641175 641175 Semer, John, of Knyghton, son of Jordan 0
4446341 2183774 2183774 plaintiff del Croft Thomas   641175 641175 del Croft, Thomas, of Knyghton 0
4474327 2192624 2192624 defendant Beneyt Thomas   641175 641175 Beneyt, Thomas, of Knyghton 0
4495554 2199291 2199291 defendant Ricardes John   641175 641175 Ricardes, John, of Knyghton 0
4656889 2248052 2248052 defendant Carter Walter   641175 641175 Carter, Walter, of Knyghton 3
4663057 2249910 2249910 defendant Galye- Richard carter 641175 641175 Galye-, Richard, of Knyghton, carter 1
4663058 2249910 2249910 defendant Everard John weaver 641175 641175 Everard, John, of Knyghton, weaver 2
4663060 2249910 2249910 defendant Gurmund John laborer 641175 641175 Gurmund, John, of Knyghton, laborer 4
4663061 2249910 2249910 defendant Gerveys or Gerneys John laborer 641175 641175 Gerveys or Gerneys, John, of Knyghton, laborer 5
4675680 2258004 2258004 plaintiff Foxe Thomas husbandman 641175 641175 Foxe, Thomas, of Knyghton, husbandman 0
4675681 2258004 2258004 plaintiff Foxe William husbandman 641175 641175 Foxe, William, of Knyghton, husbandman 1
4675682 2258004 2258004 defendant Wyloughby William husbandman 641175 641175 Wyloughby, William, of Knyghton, husbandman 0
4681148 2259732 2259732 defendant Boltyng Thomas laborer 641175 641175 Boltyng, Thomas, of Knyghton, laborer 3
4716950 2270635 2270635 plaintiff Wyloughby William husbandman 641175 641175 Wyloughby, William, of Knyghton, husbandman 0
4716951 2270635 2270635 plaintiff Aleyn John   641175 641175 Aleyn, John, of Knyghton 1
4730000 2274586 2274586 defendant Boltyng John laborer 641175 641175 Boltyng, John, of Knyghton, laborer 3
4731829 2275142 2275142 defendant Bette William   641175 641175 Bette, William, of Knyghton, servant of William 0
4815256 2300883 2300883 defendant Bette William husbandman 641175 641175 Bette, William, of Knyghton, husbandman 0
4844427 2309769 2309769 defendant Brunstop William husbandman 641175 641175 Brunstop, William, of Knyghton, husbandman 0
4851534 2311914 2311914 defendant Byke Edward husbandman 641175 641175 Byke, Edward, of Knyghton, husbandman 1
4855162 2312965 2312965 defendant Bokeston John   641175 641175 Bokeston, John, of Knyghton, millward 5
4856634 2313455 2313455 defendant Byke Edward husbandman 641175 641175 Byke, Edward, of Knyghton, husbandman 0
4856635 2313455 2313455 defendant Benet William husbandman 641175 641175 Benet, William, of Knyghton, husbandman 1
4856636 2313455 2313455 defendant Benet Thomas husbandman 641175 641175 Benet, Thomas, of Knyghton, husbandman 2
4856637 2313455 2313455 defendant Byke John husbandman 641175 641175 Byke, John, of Knyghton, husbandman 3
4879745 2320585 2320585 defendant Balle Walter tailor 641175 641175 Balle, Walter, of Knyghton, tailor 0
4879747 2320586 2320586 defendant Balle Walter tailor 641175 641175 Balle, Walter, of Knyghton, tailor 0
4920143 2332810 2332810 defendant Brokenham John husbandman 641175 641175 Brokenham, John, of Knyghton, husbandman 3
4920162 2332817 2332817 defendant Brekenham John husbandman 641175 641175 Brekenham, John, of Knyghton, husbandman 4
4929996 2335790 2335790 defendant Guage John husbandman 641175 641175 Guage, John, of Knyghton, husbandman 0
4958024 2344368 2344368 defendant Broun William husbandman 641175 641175 Broun, William, of Knyghton, husbandman 1
4958622 2344546 2344546 defendant Broun William husbandman 641175 641175 Broun, William, of Knyghton, husbandman 4
4964560 2346309 2346309 defendant Tourney Walter gent 641175 641175 Tourney, Walter, of Knyghton juxta Dorchester, gent 0
4981123 2351284 2351284 defendant Sclatford William yeoman 641175 641175 Sclatford, William, of Knyghton, yeoman 0
4981124 2351284 2351284 defendant Chyche Nicholas husbandman 641175 641175 Chyche, Nicholas, of Knyghton, husbandman 1
4983403 2351943 2351943 defendant Forster Robert husbandman 641175 641175 Forster, Robert, of Knyghton, husbandman 0
5002386 2357609 2357609 defendant Skaryngton Thomas husbandman 641175 641175 Skaryngton, Thomas, of Knyghton, husbandman 0
5013605 2360822 2360822 defendant Garlond Thomas husbandman 641175 641175 Garlond, Thomas, of Knyghton, husbandman 4
5033577 2366705 2366705 defendant Skaryngton Thomas husbandman 641175 641175 Skaryngton, Thomas, of Knyghton, husbandman 0
5033578 2366705 2366705 defendant Bate Maud widow 641175 641175 Bate, Maud, of Knyghton, widow 1
5038142 2368042 2368042 defendant Penson John husbandman 641175 641175 Penson, John, of Knyghton, husbandman 0
5038144 2368043 2368043 defendant Penson John husbandman 641175 641175 Penson, John, of Knyghton, husbandman 0
5042607 2369390 2369390 defendant Sewale Ricihard yeoman 641175 641175 Sewale, Ricihard, of Knyghton, yeoman 1
5050116 2371659 2371659 defendant Doke John husbandman 641175 641175 Doke, John, of Knyghton, husbandman 0
5064258 2375855 2375855 defendant Wyke Roger husbandman 641175 641175 Wyke, Roger, of Knyghton, husbandman 0
5071315 2377916 2377916 defendant Forster Robert husbandman 641175 641175 Forster, Robert, of Knyghton, husbandman 0
5071317 2377916 2377916 defendant Skaryngton Thomas husbandman 641175 641175 Skaryngton, Thomas, of Knyghton, husbandman 2
5073067 2378430 2378430 defendant Byke Edward husbandman 641175 641175 Byke, Edward, of Knyghton, husbandman 0
5112402 2390012 2390012 defendant Bryke Edward husbandman 641175 641175 Bryke, Edward, of Knyghton, husbandman 2
5154566 2402489 2402489 defendant Blyke Edward husbandman 641175 641175 Blyke, Edward, of Knyghton, husbandman 1
5171608 2407416 2407416 defendant Blyke Edward husbandman 641175 641175 Blyke, Edward, of Knyghton, husbandman 1
5190145 2412862 2412862 defendant Blyke Edward husbandman 641175 641175 Blyke, Edward, of Knyghton, husbandman 1
5191351 2413208 2413208 defendant Skeryngton Thomas husbandman 641175 641175 Skeryngton, Thomas, of Knyghton, husbandman 1
5272013 2436896 2436896 defendant Milward William husbandman 641175 641175 Milward, William, of Knyghton, husbandman 3
5272765 2437110 2437110 defendant Beke John husbandman 641175 641175 Beke, John, of Knyghton, husbandman 4
5279696 2439143 2439143 defendant Camppeyn John laborer 641175 641175 Camppeyn, John, of Knyghton, laborer 2
5287886 2441474 2441474 defendant Byke John husbandman 641175 641175 Byke, John, of Knyghton, husbandman 2
5320885 2451332 2451332 defendant Byke John husbandman 641175 641175 Byke, John, of Knyghton, husbandman 3

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