names

251 rows where place_id = 606682

✎ 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
3666162 1915361 1915361 defendant Crystyan Robert carpenter 606682 606682 Crystyan, Robert, of Waynflet, carpenter 0
3666164 1915362 1915362 defendant German Peter miller 606682 606682 German, Peter, of Waynflet, miller 0
3676882 1918809 1918809 defendant Kygges Richard laborer 606682 606682 Kygges, Richard, of Waynflet, laborer 0
3676883 1918809 1918809 defendant Hyll Thomas laborer 606682 606682 Hyll, Thomas,of Waynflet, laborer 1
3676884 1918809 1918809 defendant Mares Walter   606682 606682 Mares, Walter, of Waynflet 2
3720997 1932865 1932865 defendant Petson Robert husbandman 606682 606682 Petson, Robert, of Waynflet, husbandman 0
3720998 1932865 1932865 defendant Baston John shoemaker 606682 606682 Baston, John, of Waynflet, shoemaker 1
3720999 1932865 1932865 defendant Grysse Alan barber 606682 606682 Grysse, Alan, of Waynflet, barber 2
3721000 1932865 1932865 defendant Bonour William laborer 606682 606682 Bonour, William, of Waynflet, laborer 3
3721001 1932865 1932865 defendant Bryng John laborer 606682 606682 Bryng, John, of Waynflet, laborer 4
3721002 1932865 1932865 defendant Crosse Grace widow 606682 606682 Crosse, Grace, of Waynflet, widow 5
3721003 1932865 1932865 defendant Foster Alice widow 606682 606682 Foster, Alice, of Waynflet, widow 6
3732929 1936522 1936522 defendant Kyggys Thomas husbandman 606682 606682 Kyggys, Thomas, of Waynflet, husbandman 1
3736742 1937743 1937743 defendant Petson Robert husbandman 606682 606682 Petson, Robert, of Waynflet, husbandman 0
3736743 1937743 1937743 defendant Baston John shoemaker 606682 606682 Baston, John, of Waynflet, shoemaker 1
3736744 1937743 1937743 defendant Grisse Alan barber 606682 606682 Grisse, Alan, of Waynflet, barber 2
3736745 1937743 1937743 defendant Dovour or Donour William laborer 606682 606682 Dovour or Donour, William, of Waynflet, laborer 3
3736746 1937743 1937743 defendant Bryng John laborer 606682 606682 Bryng, John, of Waynflet, laborer 4
3736747 1937743 1937743 defendant Crosse Grace widow 606682 606682 Crosse, Grace, of Waynflet, widow 5
3736748 1937743 1937743 defendant Foster Alice widow 606682 606682 Foster, Alice, of Waynflet, widow 6
3798734 1957518 1957518 defendant Quell John husbandman 606682 606682 Quell, John, of Waynflet, husbandman 0
3806033 1959815 1959815 plaintiff Ordyng John husbandman 606682 606682 Ordyng, John, of Waynflet, husbandman 1
3821927 1964751 1964751 defendant Colymbyn Henry yeoman 606682 606682 Colymbyn, Henry, of Waynflet, yeoman 0
3861506 1977310 1977310 defendant Goreley Agnes widow 606682 606682 Goreley, Agnes, of Waynflet, widow 1
3956682 2009403 2009403 defendant Hubbert William yeoman 606682 606682 Hubbert, William, of Waynflet, yeoman 0
4163375 2082716 2082716 defendant Marrys Robert yeoman 606682 606682 Marrys, Robert, of Waynflet, yeoman 2
4413558 2169131 2169131 defendant Eggefeld Ralph de   606682 606682 Eggefeld, Ralph de, of Waynflet, senior, son of Ralph 0
4420353 2171268 2171268 defendant Hudsone John   606682 606682 Hudsone, John, of Waynflet 0
4421394 2171594 2171594 defendant Eggefeld Geoffrey merchant 606682 606682 Eggefeld, Geoffrey, of Waynflet, merchant 0
4421395 2171594 2171594 defendant Eggefeld Ralph de merchant 606682 606682 Eggefeld, Ralph de, of Waynflet, son of Geoffrey, junior, merchant 1
4427248 2173354 2173354 defendant Eggefeld Geoffrey de   606682 606682 Eggefeld, Geoffrey de, of Waynflet 0
4427249 2173354 2173354 defendant Eggefeld Ralph, junior   606682 606682 Eggefeld, Ralph, junior, of Waynflet, son of Geoffrey 1
4428364 2173704 2173704 defendant Cook Peter   606682 606682 Cook, Peter, of Waynflet, son of William 0
4428524 2173732 2173732 defendant Eggefeld Geoffrey de merchant 606682 606682 Eggefeld, Geoffrey de, of Waynflet, merchant 0
4428983 2173866 2173866 plaintiff Toller Guy   606682 606682 Toller, Guy, of Waynflet, son of Alan 0
4430340 2174276 2174276 defendant Eggefeld Geoffrey   606682 606682 Eggefeld, Geoffrey, of Waynflet 0
4431713 2174690 2174690 defendant Hudsone John   606682 606682 Hudsone, John, of Waynflet 0
4436274 2176089 2176089 defendant Elriker Walter   606682 606682 Elriker, Walter, of Waynflet 0
4439744 2181705 2181705 plaintiff Barker Peter   606682 606682 Barker, Peter, of Waynflet 0
4464916 2189700 2189700 defendant Wace Thomas   606682 606682 Wace, Thomas, of Waynflet 0
4482141 2195123 2195123 defendant Walker John   606682 606682 Walker, John, of Waynflet, son of Philip 0
4482177 2195135 2195135 defendant Redheved John   606682 606682 Redheved, John, of Waynflet 0
4490624 2197763 2197763 defendant Ca;seby Adam de   606682 606682 Ca;seby, Adam de, of Waynflet 0
4506125 2202432 2202432 defendant Raudson John   606682 606682 Raudson, John, of Waynflet 0
4546287 2214771 2214771 defendant Plattes John   606682 606682 Plattes, John, of Waynflet 0
4591380 2228659 2228659 plaintiff Mille Simon   606682 606682 Mille, Simon, of Waynflet 0
4591381 2228659 2228659 defendant Loweson John   606682 606682 Loweson, John, of Waynflet 0
4595249 2229763 2229763 plaintiff Randson Walter   606682 606682 Randson, Walter, of Waynflet 0
4595250 2229763 2229763 defendant Michell John   606682 606682 Michell, John, of Waynflet 0
4605064 2232744 2232744 plaintiff Allotson Thomas   606682 606682 Allotson, Thomas, of Waynflet 0
4657147 2248123 2248123 defendant Stretton John   606682 606682 Stretton, John, of Waynflet 0
4668569 2255878 2255878 defendant Michell John husbandman 606682 606682 Michell, John, of Waynflet, husbandman 0
4672120 2256926 2256926 defendant Stretton John   606682 606682 Stretton, John, of Waynflet, bailiff 2
4675939 2258083 2258083 defendant Dandyson Thomas husbandman 606682 606682 Dandyson, Thomas, of Waynflet, husbandman 0
4684470 2260747 2260747 defendant Buntyng John weaver 606682 606682 Buntyng, John, of Waynflet, weaver 0
4686559 2261404 2261404 defendant Rede William   606682 606682 Rede, William, of Waynflet 0
4690005 2262426 2262426 plaintiff Wate William   606682 606682 Wate, William, of Waynflet 0
4690007 2262426 2262426 defendant Michell John yeoman 606682 606682 Michell, John, of Waynflet, yeoman 0
4714982 2270014 2270014 defendant Chamberlayn John   606682 606682 Chamberlayn, John, of Waynflet 0
4718780 2271217 2271217 defendant Halden Robert barber 606682 606682 Halden, Robert, of Waynflet, barber 0
4729511 2274442 2274442 defendant Huchonson Randolf husbandman 606682 606682 Huchonson, Randolf, of Waynflet, husbandman 2
4733615 2275689 2275689 defendant Herryson John husbandman 606682 606682 Herryson, John, of Waynflet, husbandman 0
4772662 2287420 2287420 plaintiff Steppynge John   606682 606682 Steppynge, John, of Waynflet 0
4772664 2287421 2287421 plaintiff Steppynge John   606682 606682 Steppynge, John, of Waynflet 0
4788948 2292597 2292597 defendant Cosyn Thomas butcher 606682 606682 Cosyn, Thomas, of Waynflet, butcher 0
4797998 2295558 2295558 plaintiff Steppyng John   606682 606682 Steppyng, John, of Waynflet 0
4798000 2295559 2295559 plaintiff Steppyng John   606682 606682 Steppyng, John, of Waynflet 0
4802758 2297048 2297048 defendant Fleshewer Thomas butcher 606682 606682 Fleshewer, Thomas, of Waynflet, butcher 0
4803915 2297405 2297405 plaintiff Beldon Ralph   606682 606682 Beldon, Ralph, of Waynflet 0
4810761 2299488 2299488 defendant Lymber William husbandman 606682 606682 Lymber, William, of Waynflet, husbandman 2
4814216 2300551 2300551 defendant Meweson William husbandman 606682 606682 Meweson, William, of Waynflet, husbandman 0
4828320 2304902 2304902 defendant Cottun Lawrence   606682 606682 Cottun, Lawrence, of Waynflet, fish carter 0
4828322 2304903 2304903 plaintiff Allotson William   606682 606682 Allotson, William, of Waynflet 1
4829099 2305143 2305143 plaintiff B_ Thomas   606682 606682 B_, Thomas, of Waynflet, parson of the church of All Saints 0
4830071 2305450 2305450 defendant Wace John   606682 606682 Wace, John, of Waynflet, gent, son of Thomas 0
4830476 2305564 2305564 defendant Donnyng Simon weaver 606682 606682 Donnyng, Simon, of Waynflet, weaver 1
4832475 2306188 2306188 defendant Kytelok Simon husbandman 606682 606682 Kytelok, Simon, of Waynflet, husbandman 2
4832476 2306188 2306188 defendant Plattes Robert husbandman 606682 606682 Plattes, Robert, of Waynflet, husbandman 3
4832478 2306188 2306188 defendant R_dson William husbandman 606682 606682 R_dson, William, of Waynflet, husbandman 5
4832480 2306188 2306188 defendant Hochonson Walter husbandman 606682 606682 Hochonson, Walter, of Waynflet, husbandman 7
4834582 2306823 2306823 defendant Wace John gent 606682 606682 Wace, John, of Waynflet, gent 1
4834583 2306823 2306823 defendant Mieweson William husbandman 606682 606682 Mieweson, William, of Waynflet, husbandman 2
4834585 2306823 2306823 defendant Sawer Simon husbandman 606682 606682 Sawer, Simon, of Waynflet, husbandman 4
4834588 2306823 2306823 defendant Allotson Thomas husbandman 606682 606682 Allotson, Thomas, of Waynflet, husbandman 7
4834589 2306823 2306823 defendant Goderykson William husbandman 606682 606682 Goderykson, William, of Waynflet, husbandman 8
4836613 2307422 2307422 defendant Allotson William husbandman 606682 606682 Allotson, William, of Waynflet, husbandman 3
4839397 2308243 2308243 defendant Wace John gent 606682 606682 Wace, John, of Waynflet, gent 8
4847720 2310780 2310780 defendant atte Hall John husbandman 606682 606682 atte Hall, John, of Waynflet, husbandman 0
4852460 2312187 2312187 defendant Atthall John gent 606682 606682 Atthall, John, of Waynflet, gent 0
4859015 2314199 2314199 defendant Godefrey John husbandman 606682 606682 Godefrey, John, of Waynflet, husbandman 1
4869495 2317427 2317427 defendant Wase John gent 606682 606682 Wase, John, of Waynflet, gent 2
4871353 2318008 2318008 defendant Plattes John husbandman 606682 606682 Plattes, John, of Waynflet, husbandman 1
4874296 2318905 2318905 defendant Halden Robert husbandman 606682 606682 Halden, Robert, of Waynflet, husbandman 1
4874297 2318905 2318905 defendant Hudson Alan husbandman 606682 606682 Hudson, Alan, of Waynflet, husbandman 2
4879444 2320500 2320500 defendant Ryngot William yeoman 606682 606682 Ryngot, William, of Waynflet, yeoman 0
4879445 2320500 2320500 defendant Gysell Walter shipman 606682 606682 Gysell, Walter, of Waynflet, shipman 1
4879446 2320500 2320500 defendant Heryng Robert clerk 606682 606682 Heryng, Robert, of Waynflet, clerk 2
4884330 2322004 2322004 defendant Stanes Robert husbandman 606682 606682 Stanes, Robert, of Waynflet, husbandman 3
4884331 2322004 2322004 defendant Turtell John husbandman 606682 606682 Turtell, John, of Waynflet, husbandman 4
4884332 2322004 2322004 defendant Raufson John fisher 606682 606682 Raufson, John, of Waynflet, fisher 5

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