names

79 rows where place_id = 608299

✎ 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
3673072 1917586 1917586 defendant Wylkynson Wylkynson   608299 608299 Wylkynson, Wylkynson, of Seyton 0
3683519 1920977 1920977 defendant Shyffyld Edmund gent 608299 608299 Shyffyld, Edmund, of Seyton, gent 0
3683520 1920977 1920977 defendant Haux or Hanx Robert husbandman 608299 608299 Haux or Hanx, Robert, of Seyton, husbandman 1
3761027 1945452 1945452 defendant Clipsam Nicholas husbandman 608299 608299 Clipsam, Nicholas, of Seyton, husbandman 0
3797765 1957201 1957201 defendant Sterr John husbandman 608299 608299 Sterr, John, of Seyton, husbandman 0
3797766 1957201 1957201 defendant Sterr Richard husbandman 608299 608299 Sterr, Richard, of Seyton, husbandman 1
3797767 1957201 1957201 defendant Dare Thomas laborer 608299 608299 Dare, Thomas, of Seyton, laborer 2
3797768 1957201 1957201 defendant Heydon John   608299 608299 Heydon, John, of Seyton, mason 3
3797769 1957201 1957201 defendant Polglasse John turner 608299 608299 Polglasse, John, of Seyton, turner 4
3797770 1957201 1957201 defendant Genyns William husbandman 608299 608299 Genyns, William, of Seyton, husbandman 5
3811142 1961380 1961380 defendant Sheffelde John gent 608299 608299 Sheffelde, John, of Seyton, gent 4
3868755 1979790 1979790 defendant Howull Robert merchant 608299 608299 Howull, Robert, of Seyton, merchant 0
3909804 1993587 1993587 defendant Sheffeld Christopher gent 608299 608299 Sheffeld, Christopher, of Seyton, gent 0
3953159 2008172 2008172 defendant Tyghe Alexander husbandman 608299 608299 Tyghe, Alexander, of Seyton, husbandman 0
3991803 2021821 2021821 plaintiff Broughton Mark gent 608299 608299 Broughton, Mark, of Seyton, gent 0
4043425 2040110 2040110 defendant Chydley John husbandman 608299 608299 Chydley, John, of Seyton, husbandman 0
4144131 2076109 2076109 defendant Catesbye Richard gent 608299 608299 Catesbye, Richard, of Seyton, gent 0
4315052 2135378 2135378 defendant Aske Henry husbandman 608299 608299 Aske, Henry, of Seyton, husbandman 1
4362252 2151546 2151546 defendant Beilbie James husbandman 608299 608299 together with Beilbie, James, of Seyton, husbandman 1
4440854 2182054 2182054 plaintiff Beyvvyll Thomas Master & parson 608299 608299 Beyvvyll, Thomas, of Seyton, Master & parson 0
4440856 2182055 2182055 plaintiff Beyvvyll Thomas   608299 608299 Beyvvyll, Thomas, of Seyton, parson 0
4504848 2202060 2202060 plaintiff Senlys Rollmans   608299 608299 Senlys, Rollmans, of Seyton 0
4564862 2220571 2220571 defendant Grymmesby Henry de   608299 608299 Grymmesby, Henry de, of Seyton 0
4564864 2220572 2220572 defendant Hughsone William   608299 608299 Hughsone, William, of Seyton 0
4564865 2220572 2220572 defendant Bury John   608299 608299 Bury, John, of Seyton 1
4671915 2256863 2256863 plaintiff Cook Robert   608299 608299 Cook, Robert, of Seyton 2
4697009 2264542 2264542 defendant Breton Henry   608299 608299 Breton, Henry, of Seyton, bailiff 2
4797474 2295381 2295381 defendant Prouns Ralph yeoman 608299 608299 Prouns, Ralph, of Seyton, yeoman 2
4797478 2295382 2295382 defendant Prouns or Promis Ralph yeoman 608299 608299 Prouns or Promis, Ralph, of Seyton, yeoman 2
4856678 2313464 2313464 defendant Beaufou William esq 608299 608299 Beaufou, William, of Seyton, esq 0
4856679 2313464 2313464 defendant Prouns Ralph yeoman 608299 608299 Prouns, Ralph, of Seyton, yeoman 1
4856680 2313464 2313464 defendant Beaufou Ralph esq 608299 608299 Beaufou, Ralph, of Seyton, esq 2
4882621 2321477 2321477 defendant Bufo William esq 608299 608299 Bufo, William, of Seyton, esq 0
4911173 2330004 2330004 defendant Watkyns John husbandman 608299 608299 Watkyns, John, of Seyton, husbandman 0
4928053 2335206 2335206 defendant Beuafo William esq 608299 608299 Beuafo, William, of Seyton, esq 0
4928054 2335206 2335206 defendant Prouns John yeoman 608299 608299 Prouns, John, of Seyton, yeoman 1
4928055 2335206 2335206 defendant Haryot Thomas husbandman 608299 608299 Haryot, Thomas, of Seyton, husbandman 2
4928057 2335207 2335207 defendant Pronus John yeoman 608299 608299 Pronus, John, of Seyton, yeoman 0
4936667 2337852 2337852 defendant Prouns John yeoman 608299 608299 Prouns, John, of Seyton, yeoman 2
5075521 2379176 2379176 defendant Beauson William gent 608299 608299 Beauson, William, of Seyton, gent 0
5079590 2380386 2380386 defendant Worthe John miller or wright 608299 608299 Worthe, John, of Seyton, miller or wright 0
5082779 2381354 2381354 defendant Shefeld John gent 608299 608299 Shefeld, John, of Seyton, gent 0
5082781 2381355 2381355 defendant Yonge Roger yeoman 608299 608299 Yonge, Roger, of Seyton, yeoman 0
5082794 2381359 2381359 defendant Dexter Nicholas yeoman 608299 608299 Dexter, Nicholas, of Seyton, yeoman 0
5130889 2395517 2395517 defendant Atkyns Henry husbandman 608299 608299 Atkyns, Henry, of Seyton, husbandman 0
5130890 2395517 2395517 defendant Kent John husbandman 608299 608299 Kent, John, of Seyton, husbandman 1
5140307 2398269 2398269 defendant Banfo--- William esq 608299 608299 Banfo---, William, of Seyton, esq 0
5143401 2399208 2399208 defendant Beaufeu William gent 608299 608299 Beaufeu, William, of Seyton, gent 0
5149513 2400986 2400986 defendant Yonge Roger yeoman 608299 608299 Yonge, Roger, of Seyton, yeoman 0
5150336 2401229 2401229 defendant Atkyns Henry husbandman 608299 608299 Atkyns, Henry, of Seyton, husbandman 0
5150337 2401229 2401229 defendant Kent John husbandman 608299 608299 Kent, John, of Seyton, husbandman 1
5168433 2406482 2406482 defendant Yonge Roger yeoman 608299 608299 Yonge, Roger, of Seyton, yeoman 0
5168903 2406634 2406634 defendant Atkyns Henry husbandman 608299 608299 Atkyns, Henry, of Seyton, husbandman 0
5168904 2406634 2406634 defendant Kent John husbandman 608299 608299 Kent, John, of Seyton, husbandman 1
5178044 2409280 2409280 defendant Beaufeu William gent 608299 608299 Beaufeu, William, of Seyton, gent 0
5181958 2410473 2410473 defendant Deyster Nicholas yeoman 608299 608299 Deyster, Nicholas, of Seyton, yeoman 0
5185161 2411406 2411406 defendant Atkyns Henry husbandman 608299 608299 Atkyns, Henry, of Seyton, husbandman 0
5185162 2411406 2411406 defendant Kent John husbandman 608299 608299 Kent, John, of Seyton, husbandman 1
5187317 2412015 2412015 defendant Deyster Nicholas husbandman 608299 608299 Deyster, Nicholas, of Seyton, husbandman 0
5201221 2416115 2416115 defendant Beaufou William gent 608299 608299 Beaufou, William, of Seyton, gent 0
5214701 2420028 2420028 defendant Beaufo William esq 608299 608299 Beaufo, William, of Seyton, esq 0
5248472 2429680 2429680 plaintiff Styward Thomas   608299 608299 Styward, Thomas, of Seyton 0
5306416 2446905 2446905 defendant Beaufo Elizaabeth   608299 608299 Beaufo, Elizaabeth, of Seyton, widow, formerly wife of William Beaufo 0
5410614 2478119 2478119 defendant Harryes Richard husbandman 608299 608299 Harryes, Richard, of Seyton, husbandman 3
5425844 2482694 2482694 defendant Baxter John laborer 608299 608299 Baxter, John, of Seyton, laborer 0
5425845 2482694 2482694 defendant Baxter Thomas laborer 608299 608299 Baxter, Thomas, of Seyton, laborer 1
5425846 2482694 2482694 defendant Baxter Robert laborer 608299 608299 Baxter, Robert, of Seyton, laborer 2
5441408 2487349 2487349 defendant Baxter John laborer 608299 608299 Baxter, John, of Seyton, laborer 0
5441409 2487349 2487349 defendant Baxter Thomas laborer 608299 608299 together with Baxter, Thomas, of Seyton, laborer 1
5441410 2487349 2487349 defendant Baxter Robert laborer 608299 608299 Baxter, Robert, of Seyton, laborer 2
5441412 2487350 2487350 defendant Baxter Thomas laborer 608299 608299 Baxter, Thomas, of Seyton, laborer 0
5441413 2487350 2487350 defendant Baxter Robert laborer 608299 608299 Baxter, Robert, of Seyton, laborer 1
5529648 2513772 2513772 defendant Berege Henry yeoman 608299 608299 Berege, Henry, of Seyton, yeoman 2
5529654 2513774 2513774 defendant Berege Henry yeoman 608299 608299 Berege, Henry, of Seyton, yeoman 2
5564153 2524128 2524128 defendant Dussell Robert husbandman 608299 608299 Dussell, Robert, of Seyton, husbandman 2
5611557 2547348 2547348 plaintiff Boyvyll Thomas   608299 608299 Boyvyll, Thomas, of Seyton, parson 0
5619261 2549872 2549872 plaintiff Parkere Robert   608299 608299 Parkere, Robert, of Seyton 0
5629234 2553119 2553119 defendant Beupho Nicholas esq 608299 608299 Beupho, Nicholas, of Seyton, esq 0
5630887 2553670 2553670 defendant Hynkyn Richard husbandman 608299 608299 Hynkyn, Richard, of Seyton, husbandman 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);