names

172 rows where place_id = 589961

✎ 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
3599385 1867450 1867450 defendant Howelegge Robert husbandman 589961 589961 Howelegge, Robert, of North Petherton, husbandman 1
3599387 1867450 1867450 defendant Howelegge John yeoman 589961 589961 Howelegge, John, of North Petherton, yeoman 3
3667493 1915774 1915774 defendant Willyams William yeoman 589961 589961 Willyams, William, of North Petherton, yeoman 0
3757781 1944414 1944414 defendant Byrfeld John husbandman 589961 589961 Byrfeld, John, of North Petherton, husbandman 0
3757782 1944414 1944414 defendant Pye Richard husbandman 589961 589961 Pye, Richard, of North Petherton, husbandman 1
3757783 1944414 1944414 defendant Quarell Richard husbandman 589961 589961 Quarell, Richard, of North Petherton, husbandman 2
3757784 1944414 1944414 defendant Vynycombe John husbandman 589961 589961 Vynycombe, John, of North Petherton, husbandman 3
3757785 1944414 1944414 defendant Colyns John, junior husbandman 589961 589961 Colyns, John, junior, of North Petherton, husbandman 4
3757786 1944414 1944414 defendant Harres John husbandman 589961 589961 Harres, John, of North Petherton, husbandman 5
3757787 1944414 1944414 defendant Chapman Thomas husbandman 589961 589961 Chapman, Thomas, of North Petherton, husbandman 6
3757788 1944414 1944414 defendant Herle William husbandman 589961 589961 Herle, William, of North Petherton, husbandman 7
3757789 1944414 1944414 defendant Toker John husbandman 589961 589961 Toker, John, of North Petherton, husbandman 8
3816103 1962936 1962936 defendant Speler Thomas mercer 589961 589961 Speler, Thomas, of North Petherton, mercer 1
3832496 1968083 1968083 defendant Smyth alias Jenkyn John smith 589961 589961 Smyth alias Jenkyn, John, of North Petherton, smith 0
3866415 1978999 1978999 defendant Andersey William husbandman 589961 589961 Andersey, William, of North Petherton, husbandman 0
3910383 1993792 1993792 defendant Wurth Peter gent 589961 589961 Wurth, Peter, of North Petherton, gent 0
3910384 1993792 1993792 defendant Batt John husbandman 589961 589961 Batt, John, of North Petherton, husbandman 1
3910385 1993792 1993792 defendant Conway Ralph husbandman 589961 589961 Conway, Ralph, of North Petherton, husbandman 2
3912580 1994539 1994539 defendant Coke Richard tucker 589961 589961 Coke, Richard, of North Petherton, tucker 0
3912581 1994539 1994539 defendant Hoper John tucker 589961 589961 Hoper, John, of North Petherton, tucker 1
3934530 2001842 2001842 defendant Aysshe John   589961 589961 Aysshe, John, of North Petherton, cloth maker 0
3942526 2004510 2004510 defendant Cosyn John husbandman 589961 589961 Cosyn, John, of North Petherton, husbandman 0
3948011 2006368 2006368 plaintiff Courte Simon, senior yeoman 589961 589961 Courte, Simon, senior, of North Petherton, yeoman 0
3966412 2012886 2012886 defendant Somer John husbandman 589961 589961 Somer, John, of North Petherton, husbandman 0
3966413 2012886 2012886 defendant Howell John husbandman 589961 589961 Howell, John, of North Petherton, husbandman 1
3966414 2012886 2012886 defendant Smythe John husbandman 589961 589961 Smythe, John, of North Petherton, husbandman 2
3973882 2015433 2015433 defendant Lynsey John yeoman or tanner 589961 589961 Lynsey, John, of North Petherton, yeoman or tanner 0
3973883 2015433 2015433 defendant Lynsey Robert   589961 589961 Lynsey, Robert, of North Petherton, yeoman, his son 1
3973884 2015433 2015433 defendant Harley John yeoman 589961 589961 Harley, John, of North Petherton, yeoman 2
3983251 2018782 2018782 defendant Bowe John husbandman 589961 589961 Bowe, John, of North Petherton, husbandman 0
3999575 2024614 2024614 defendant Norton William innholder 589961 589961 Norton, William, of North Petherton, innholder 0
4001435 2025290 2025290 defendant Porter Thomas husbandman 589961 589961 Porter, Thomas, of North Petherton, husbandman 0
4011757 2028943 2028943 defendant Yate John yeoman 589961 589961 Yate, John, of North Petherton, yeoman 0
4016874 2030734 2030734 plaintiff Sydenham Richard gent 589961 589961 Sydenham, Richard, of North Petherton, gent 0
4021381 2032370 2032370 defendant Alley Robert yeoman 589961 589961 Alley, Robert, of North Petherton, yeoman 1
4038089 2038264 2038264 defendant Jeffrie Alexander tanner 589961 589961 Jeffrie, Alexander, of North Petherton, tanner 1
4041377 2039408 2039408 defendant Howell William butcher 589961 589961 Howell, William, of North Petherton, butcher 0
4043472 2040126 2040126 defendant Swinger John innholder 589961 589961 Swinger, John, of North Petherton, innholder 0
4052246 2043226 2043226 defendant Dysshe Arthur yeoman 589961 589961 Dysshe, Arthur, of North Petherton, yeoman 0
4059793 2045896 2045896 plaintiff Courte John husbandman 589961 589961 Courte, John, of North Petherton, husbandman 0
4059867 2045925 2045925 defendant Hoyle William butcher 589961 589961 Hoyle, William, of North Petherton, butcher 1
4070568 2049767 2049767 defendant Starckey James yeoman 589961 589961 Starckey, James, of North Petherton, yeoman 0
4077751 2052335 2052335 defendant Rowsewell Robert husbandman 589961 589961 Rowsewell, Robert, of North Petherton, husbandman 1
4077752 2052335 2052335 defendant Blauncheflower Robert husbandman 589961 589961 Blauncheflower, Robert, of North Petherton, husbandman 2
4080062 2053174 2053174 defendant Englishe John husbandman 589961 589961 Englishe, John, of North Petherton, husbandman 0
4094631 2058418 2058418 defendant Norman Robert husbandman 589961 589961 Norman, Robert, of North Petherton, husbandman 0
4096156 2058954 2058954 defendant Sage John husbandman 589961 589961 Sage, John, of North Petherton, husbandman 0
4109546 2063676 2063676 defendant Culpayne Edward husbandman 589961 589961 Culpayne, Edward, of North Petherton, husbandman 0
4109709 2063729 2063729 defendant Bulpayne Edward husbandman 589961 589961 Bulpayne, Edward, of North Petherton, husbandman 0
4110676 2064075 2064075 defendant Hoyell William butcher 589961 589961 Hoyell, William, of North Petherton, butcher 1
4113025 2064926 2064926 defendant Starkye James yeoman 589961 589961 Starkye, James, of North Petherton, yeoman 0
4127436 2070103 2070103 defendant preiste Robert husbandman 589961 589961 preiste, Robert, of North Petherton, husbandman 1
4127437 2070103 2070103 defendant Durlen Thomas husbandman 589961 589961 Durlen, Thomas, of North Petherton, husbandman 2
4129433 2070831 2070831 defendant Foureacre Thomas husbandman 589961 589961 Foureacre, Thomas, of North Petherton, husbandman 0
4129434 2070831 2070831 defendant Codinge William husbandman 589961 589961 Codinge, William, of North Petherton, husbandman 1
4129719 2070938 2070938 defendant Dibbell or Deble John yeoman 589961 589961 Dibbell or Deble, John, of North Petherton, yeoman 0
4131845 2071702 2071702 defendant Pyne Roger husbandman 589961 589961 Pyne, Roger, of North Petherton, husbandman 2
4133087 2072163 2072163 defendant Came or Caine Henry yeoman 589961 589961 Came or Caine, Henry, of North Petherton, yeoman 1
4149113 2077814 2077814 defendant Inglishe Simon yeoman 589961 589961 Inglishe, Simon, of North Petherton, yeoman 0
4149114 2077814 2077814 defendant Inglyshe John husbandman 589961 589961 Inglyshe, John, of North Petherton, husbandman 1
4150684 2078378 2078378 defendant Preiste Robert husbandman 589961 589961 Preiste, Robert, of North Petherton, husbandman 1
4150685 2078378 2078378 defendant Durlen Thomas husbandman 589961 589961 Durlen, Thomas, of North Petherton, husbandman 2
4152159 2078865 2078865 defendant Berifielde John yeoman 589961 589961 Berifielde, John, of North Petherton, yeoman 0
4157925 2080842 2080842 defendant Redhill John husbandman 589961 589961 Redhill, John, of North Petherton, husbandman 2
4157927 2080842 2080842 defendant Dunston William yeoman 589961 589961 Dunston, William, of North Petherton, yeoman 4
4186227 2090668 2090668 defendant Englishe John yeoman 589961 589961 Englishe, John, of North Petherton, yeoman 0
4190349 2092148 2092148 defendant Beryfylde Simon yeoman 589961 589961 Beryfylde, Simon, of North Petherton, yeoman 0
4202594 2096451 2096451 defendant Browne Philip victualer 589961 589961 Browne, Philip, of North Petherton, husbandman, victualer 1
4203265 2096688 2096688 defendant Pyne Roger husbandman 589961 589961 Pyne, Roger, of North Petherton, husbandman 0
4219073 2102167 2102167 defendant Hayes John husbandman 589961 589961 Hayes, John, of North Petherton, husbandman 0
4219638 2102373 2102373 defendant Ellys John husbandman 589961 589961 Ellys, John, of North Petherton, husbandman 0
4222112 2103226 2103226 defendant Worth John gent 589961 589961 Worth, John, of North Petherton, gent 0
4244265 2111070 2111070 defendant Bulpan Thomas husbandman 589961 589961 Bulpan, Thomas, of North Petherton, or of Huntworth, Soms, husbandman 1
4244937 2111291 2111291 defendant Batt Richard yeoman 589961 589961 Batt, Richard, of North Petherton, yeoman 0
4255434 2114813 2114813 defendant Bulpan Thomas husbandman 589961 589961 Bulpan, Thomas, of North Petherton, or of Huntworth, Soms, husbandman 1
4260439 2116459 2116459 defendant Haies Thomas husbandman 589961 589961 Haies, Thomas, of North Petherton, husbandman 0
4262519 2117128 2117128 defendant Tyberd John husbandman 589961 589961 Tyberd, John, of North Petherton, husbandman 0
4276155 2121604 2121604 defendant Virgen William yeoman 589961 589961 Virgen, William, of North Petherton, yeoman 2
4285544 2124880 2124880 defendant Aishe Robert husbandman 589961 589961 Aishe, Robert, of North Petherton, husbandman 0
4285760 2124960 2124960 defendant Bulpan Thomas husbandman 589961 589961 Bulpan, Thomas, of North Petherton, husbandman 0
4285763 2124961 2124961 defendant Bulpan Thomas husbandman 589961 589961 Bulpan, Thomas, of North Petherton, husbandman 0
4286030 2125057 2125057 defendant Courte John gent 589961 589961 Courte, John, of North Petherton, gent 1
4288989 2126118 2126118 defendant Aishe Robert butcher 589961 589961 Aishe, Robert, of North Petherton, butcher 1
4290025 2126497 2126497 defendant Tayler John husbandman 589961 589961 Tayler, John, of North Petherton, husbandman 0
4290093 2126522 2126522 defendant Taylor John husbandman 589961 589961 Taylor, John, of North Petherton, husbandman 0
4291015 2126852 2126852 defendant Buttler Thomas yeoman 589961 589961 Buttler, Thomas, of North Petherton, yeoman 0
4291384 2126992 2126992 defendant Mark Mathew butcher 589961 589961 Mark, Mathew, of North Petherton, butcher 0
4292212 2127284 2127284 defendant Wyllys John yeoman 589961 589961 Wyllys, John, of North Petherton, yeoman 2
4292312 2127314 2127314 defendant Bulpayne Edward yeoman 589961 589961 Bulpayne, Edward, of North Petherton, yeoman 0
4292313 2127314 2127314 defendant Butler Thomas yeoman 589961 589961 Butler, Thomas, of North Petherton, yeoman 1
4292314 2127314 2127314 defendant Olyver Simon husbandman 589961 589961 Olyver, Simon, of North Petherton, husbandman 2
4301144 2130517 2130517 defendant Bailiff John husbandman 589961 589961 Bailiff, John, of North Petherton, husbandman 0
4301683 2130709 2130709 defendant Dyble John yeoman 589961 589961 Dyble, John, of North Petherton, yeoman 0
4301686 2130709 2130709 defendant Ayshe Robert butcher 589961 589961 Ayshe, Robert, of North Petherton, butcher 3
4301690 2130710 2130710 defendant Wyllys John   589961 589961 Wyllys, John, of North Petherton, surgeon 2
4302539 2131007 2131007 defendant Barrett John husbandman 589961 589961 Barrett, John, of North Petherton, husbandman 0
4302540 2131007 2131007 defendant Oliver Simon husbandman 589961 589961 Oliver, Simon, of North Petherton, husbandman 1
4302846 2131118 2131118 plaintiff Cort Thomas yeoman 589961 589961 Cort, Thomas, of North Petherton, yeoman 0
4303306 2131285 2131285 defendant Wylles Thomas yeoman 589961 589961 Wylles, Thomas, of North Petherton, yeoman 0
4303307 2131285 2131285 defendant Coxe Richard husbandman 589961 589961 Coxe, Richard, of North Petherton, husbandman 1

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