names

126 rows where place_id = 589545

✎ 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
3590231 1864587 1864587 defendant Harres John   589545 589545 Harres, John, of Banwell, court holder 0
3597928 1866975 1866975 defendant Aldyn Robert laborer 589545 589545 Aldyn, Robert, of Banwell, laborer 1
3609572 1870659 1870659 defendant Gough John clerk 589545 589545 Gough, John, of Banwell, clerk 1
3609575 1870660 1870660 defendant Gough John clerk 589545 589545 Gough, John, of Banwell, clerk 1
3623334 1874829 1874829 plaintiff Selwode John   589545 589545 Selwode, John, of Banwell 0
3623337 1874829 1874829 defendant Laueraunce Nicholas husbandman 589545 589545 Laueraunce, Nicholas, of Banwell, husbandman 2
3698306 1925688 1925688 defendant ap Roger Ewen gent 589545 589545 ap Roger, Ewen, of Banwell, gent 0
3725675 1934316 1934316 defendant Sawer John husbandman 589545 589545 Sawer, John, of Banwell, husbandman 0
3741567 1939232 1939232 defendant Sawyer John husbandman 589545 589545 Sawyer, John, of Banwell, husbandman 0
3745762 1940575 1940575 defendant Sawyer John husbandman 589545 589545 Sawyer, John, of Banwell, husbandman 0
3745763 1940575 1940575 defendant Redhed John husbandman 589545 589545 Redhed, John, of Banwell, husbandman 1
3758698 1944714 1944714 defendant Savyer or Sauyer alias Redhed John husbandman 589545 589545 Savyer or Sauyer alias Redhed, John, of Banwell, husbandman 0
3764971 1946708 1946708 defendant Wyght Nicholas tailor 589545 589545 Wyght, Nicholas, of Banwell, tailor 0
3765076 1946741 1946741 defendant Gervys William husbandman 589545 589545 Gervys, William, of Banwell, husbandman 0
3772876 1949213 1949213 defendant Blaklake alias Parker Henry yeoman 589545 589545 Blaklake alias Parker, Henry, of Banwell, yeoman 0
3772877 1949213 1949213 defendant Comer James husbandman 589545 589545 Comer, James, of Banwell, husbandman 1
3772878 1949213 1949213 defendant Berd Nicholas husbandman 589545 589545 Berd, Nicholas, of Banwell, husbandman 2
3783043 1952449 1952449 defendant Bakewell William husbandman 589545 589545 Bakewell, William, of Banwell, husbandman 0
3783044 1952449 1952449 defendant Shepard Richard husbandman 589545 589545 Shepard, Richard, of Banwell, husbandman 1
3784249 1952863 1952863 defendant Welche William husbandman 589545 589545 Welche, William, of Banwell, husbandman 0
3784250 1952863 1952863 defendant Wylle John husbandman 589545 589545 Wylle, John, of Banwell, husbandman 1
3784251 1952863 1952863 defendant Symon Thomas husbandman 589545 589545 Symon, Thomas, of Banwell, husbandman 2
3784252 1952863 1952863 defendant Vyncott John husbandman 589545 589545 Vyncott, John, of Banwell, husbandman 3
3784253 1952863 1952863 defendant Slefford John husbandman 589545 589545 Slefford, John, of Banwell, husbandman 4
3784254 1952863 1952863 defendant Jervys William husbandman 589545 589545 Jervys, William, of Banwell, husbandman 5
3784255 1952863 1952863 defendant Heyn Thomas husbandman 589545 589545 Heyn, Thomas, of Banwell, husbandman 6
3799609 1957801 1957801 defendant Batewell William husbandman 589545 589545 Batewell, William, of Banwell, husbandman 0
3799610 1957801 1957801 defendant Shephard Richard husbandman 589545 589545 Shephard, Richard, of Banwell, husbandman 1
3839820 1970383 1970383 defendant Sheppard Richard husbandman 589545 589545 Sheppard, Richard, of Banwell, husbandman 0
3844853 1971934 1971934 defendant Recclyff Richard tailor 589545 589545 Recclyff, Richard, of Banwell, tailor 2
3844855 1971934 1971934 defendant Bustell William husbandman 589545 589545 Bustell, William, of Banwell, husbandman 4
3853916 1974861 1974861 defendant Mamyng William husbandman 589545 589545 Mamyng, William, of Banwell, husbandman 0
3864555 1978343 1978343 defendant White William butcher 589545 589545 White, William, of Banwell, butcher 2
3911064 1994027 1994027 defendant Bussell William husbandman 589545 589545 Bussell, William, of Banwell, husbandman 4
3911065 1994027 1994027 defendant Hayne Thomas husbandman 589545 589545 Hayne, Thomas, of Banwell, husbandman 5
3911066 1994027 1994027 defendant Sayer John husbandman 589545 589545 Sayer, John, of Banwell, husbandman 6
3911073 1994029 1994029 defendant Hawkyns Nicholas husbandman 589545 589545 Hawkyns, Nicholas, of Banwell, husbandman 0
3911074 1994029 1994029 defendant Berde John husbandman 589545 589545 Berde, John, of Banwell, husbandman 1
3916895 1996016 1996016 defendant Lynes Francis husbandman 589545 589545 Lynes, Francis, of Banwell, husbandman 0
3920984 1997367 1997367 defendant Ryson Roger miller 589545 589545 Ryson, Roger, of Banwell, miller 0
3937866 2002996 2002996 defendant Bomer Ralph husbandman 589545 589545 Bomer, Ralph, of Banwell, husbandman 0
3937868 2002996 2002996 defendant Poole Thomas husbandman 589545 589545 Poole, Thomas, of Banwell, husbandman 2
3942340 2004451 2004451 defendant Nebbe William   589545 589545 Nebbe, William, of Banwell, vicar 0
3942341 2004451 2004451 defendant Nebbe William husbandman 589545 589545 Nebbe, William, of Banwell, husbandman 1
3992458 2022066 2022066 defendant Hawkyns John husbandman 589545 589545 Hawkyns, John, of Banwell, husbandman 0
4005189 2026633 2026633 defendant Egell Humphrey husbandman 589545 589545 Egell, Humphrey, of Banwell, husbandman 1
4062191 2046765 2046765 defendant Lewes alias Horseman William yeoman 589545 589545 Lewes alias Horseman, William, of Banwell, yeoman 1
4086354 2055395 2055395 defendant Browne Hugh tailor 589545 589545 Browne, Hugh, of Banwell, tailor 0
4086355 2055395 2055395 defendant Browne John   589545 589545 Browne, John, of Banwell, yeoman, his brother 1
4095440 2058694 2058694 defendant Backewell Joan widow 589545 589545 Backewell, Joan, of Banwell, widow 0
4095442 2058694 2058694 defendant Hawkyns John, junior husbandman 589545 589545 Hawkyns, John, junior, of Banwell, husbandman 2
4120270 2067529 2067529 defendant Crey Walter husbandman 589545 589545 Crey, Walter, of Banwell, husbandman 0
4120271 2067529 2067529 defendant Payne John yeoman 589545 589545 Payne, John, of Banwell, yeoman 1
4120272 2067529 2067529 defendant Symons John yeoman 589545 589545 Symons, John, of Banwell, yeoman 2
4120275 2067530 2067530 defendant Symons John yeoman 589545 589545 Symons, John, of Banwell, yeoman 0
4120276 2067530 2067530 defendant Knight Lawrence husbandman 589545 589545 Knight, Lawrence, of Banwell, husbandman 1
4120368 2067559 2067559 defendant Warren Nicholas butcher 589545 589545 Warren, Nicholas, of Banwell, butcher 0
4145734 2076660 2076660 defendant Swetnam John   589545 589545 Swetnam, John, of Banwell, groom 1
4149203 2077851 2077851 defendant Crey Walter yeoman 589545 589545 Crey, Walter, of Banwell, yeoman 1
4175589 2086932 2086932 defendant Dey John husbandman 589545 589545 Dey, John, of Banwell, husbandman 0
4179613 2088343 2088343 defendant Tylley Thomas husbandman or yeoman 589545 589545 Tylley, Thomas, of Banwell, husbandman or yeoman 3
4179618 2088344 2088344 defendant Tylley Thomas husbandman or yeoman 589545 589545 Tylley, Thomas, of Banwell, husbandman or yeoman 3
4186337 2090708 2090708 defendant Carpenter John carpenter 589545 589545 Carpenter, John, of Banwell, carpenter 0
4191672 2092642 2092642 defendant Knyght Lawrence husbandman 589545 589545 Knyght, Lawrence, of Banwell, husbandman 0
4191675 2092643 2092643 defendant Symons John husbandman 589545 589545 Symons, John, of Banwell, husbandman 0
4229664 2105858 2105858 defendant Cesse John yeoman 589545 589545 Cesse, John, of Banwell, yeoman 0
4273957 2120835 2120835 defendant Quarre Edward Soms, yeoman 589545 589545 Quarre Edward, of Banwell, Soms, yeoman 2
4281577 2123464 2123464 defendant Busell William husbandman 589545 589545 Busell, William, of Banwell, husbandman 0
4286038 2125061 2125061 defendant Vale John butcher 589545 589545 Vale, John, of Banwell, butcher 0
4288852 2126065 2126065 defendant Goodridge William husbandman 589545 589545 Goodridge, William, of Banwell, husbandman 0
4302342 2130938 2130938 defendant Sesse John yeoman 589545 589545 Sesse, John, of Banwell, yeoman 0
4304553 2131729 2131729 defendant Blackeburrowe William gent 589545 589545 Blackeburrowe, William, of Banwell, gent 1
4304554 2131729 2131729 defendant Palmer Clement glover 589545 589545 Palmer, Clement, of Banwell, glover 2
4304555 2131729 2131729 defendant Bowne John husbandman 589545 589545 Bowne, John, of Banwell, husbandman 3
4306746 2132498 2132498 defendant Sesse or Cesse John   589545 589545 Sesse or Cesse, John, of Banwell, or of Yatton, Soms yeoman 1
4308067 2132967 2132967 defendant Quarr Edward husbandman 589545 589545 Quarr, Edward, of Banwell, husbandman 1
4309252 2133389 2133389 defendant Nedes Maud widow 589545 589545 Nedes, Maud, of Banwell, widow 0
4309253 2133389 2133389 defendant Luffe Edward tanner 589545 589545 Luffe, Edward, of Banwell, tanner 1
4314075 2135031 2135031 defendant Quarr Edward yeoman 589545 589545 Quarr, Edward, of Banwell, yeoman 0
4314076 2135031 2135031 defendant Blackborowe William yeoman 589545 589545 Blackborowe William, of Banwell, yeoman 1
4317119 2136105 2136105 defendant Quarr Edward yeoman 589545 589545 Quarr, Edward, of Banwell, yeoman 0
4404105 2165942 2165942 defendant Sesse John yeoman 589545 589545 Sesse, John, of Banwell, yeoman 0
4408087 2167276 2167276 defendant Luffe Richard yeoman 589545 589545 Luffe, Richard, of Banwell, yeoman 0
4408779 2167533 2167533 defendant Tucker Thomas husbandman 589545 589545 Tucker, Thomas, of Banwell, or of South Brent, husbandman 0
4511885 2204166 2204166 plaintiff Bocher Robert   589545 589545 Bocher, Robert, of Banwell 0
4569065 2221910 2221910 defendant Frensshe John   589545 589545 Frensshe, John, of Banwell 4
4697036 2264552 2264552 defendant Tytesbury John husbandman 589545 589545 Tytesbury, John, of Banwell, husbandman 0
4697039 2264552 2264552 defendant Bustoll John husbandman 589545 589545 Bustoll, John, of Banwell, husbandman 3
4789960 2292934 2292934 defendant Andrewe Walter husbandman 589545 589545 Andrewe, Walter, of Banwell, husbandman 0
4826434 2304305 2304305 defendant Boucher John husbandman 589545 589545 Boucher, John, of Banwell, husbandman 0
5011436 2360210 2360210 defendant Shipherd John husbandman 589545 589545 Shipherd, John, of Banwell, husbandman 0
5014321 2361044 2361044 defendant Hygon John   589545 589545 Hygon, John, of Banwell, bailiff 2
5151236 2401507 2401507 defendant Selwode Thomas baker 589545 589545 Selwode, Thomas, of Banwell, baker 0
5178469 2409412 2409412 defendant Wyght Thomas husbandman 589545 589545 Wyght, Thomas, of Banwell, husbandman 0
5178470 2409412 2409412 defendant Rede David shoemaker 589545 589545 Rede, David, of Banwell, shoemaker 1
5201454 2416184 2416184 defendant Wyght Thomas husbandman 589545 589545 Wyght, Thomas, of Banwell, husbandman 0
5201455 2416184 2416184 defendant Rede David shoemaker 589545 589545 Rede, David, of Banwell, shoemaker 1
5251117 2430453 2430453 defendant Blandon John, junior grazier 589545 589545 Blandon, John, junior, of Banwell, grazier 0
5301795 2445492 2445492 defendant Mayowe William shoemaker 589545 589545 Mayowe, William, of Banwell, shoemaker 0
5338129 2456494 2456494 defendant Punder John husbandman 589545 589545 Punder, John, of Banwell, 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);