names

98 rows where place_id = 589611

✎ 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
3598174 1867059 1867059 defendant Carmald Robert yeoman 589611 589611 Carmald, Robert, of Hekyngton, yeoman 0
3616975 1872930 1872930 defendant Pygge Thomas gent 589611 589611 Pygge, Thomas, of Hekyngton, gent 1
3619234 1873618 1873618 defendant Cawedron Henry yeoman 589611 589611 Cawedron, Henry, of Hekyngton, yeoman 0
3630847 1904468 1904468 defendant Jenvy Robert sherman 589611 589611 Jenvy, Robert, of Hekyngton, sherman 0
3644023 1908560 1908560 defendant Kendall John husbandman 589611 589611 Kendall, John, of Hekyngton, husbandman 0
3644681 1908744 1908744 defendant Loundesdale Richard weaver 589611 589611 Loundesdale, Richard, of Hekyngton, weaver 0
3644682 1908744 1908744 defendant Juvey and Invey Richard sherman 589611 589611 Juvey and Invey, Richard, of Hekyngton, sherman 1
3644683 1908744 1908744 defendant Mathey Robert husbandman 589611 589611 Mathey, Robert, of Hekyngton, husbandman 2
3725973 1934394 1934394 defendant Wryght Robert husbandman 589611 589611 Wryght, Robert, of Hekyngton, husbandman 0
3833925 1968548 1968548 defendant Dyans William yeoman 589611 589611 Dyans, William, of Hekyngton, yeoman 0
3833927 1968548 1968548 defendant Harvy Thomas husbandman 589611 589611 Harvy, Thomas, of Hekyngton, husbandman 2
3846356 1972414 1972414 defendant Deans alias Deyneys William yeoman 589611 589611 Deans alias Deyneys, William, of Hekyngton, yeoman 1
3855203 1975259 1975259 defendant Copland Alan husbandman 589611 589611 Copland, Alan, of Hekyngton, husbandman 1
3889726 1986800 1986800 defendant Wynnesworth George yeoman 589611 589611 Wynnesworth, George, of Hekyngton, yeoman 1
3889835 1986840 1986840 defendant Foster homas yeoman 589611 589611 Foster, homas, of Hekyngton, yeoman 1
3889836 1986840 1986840 defendant Taillor John husbandman 589611 589611 Taillor, John, of Hekyngton, husbandman 2
3889837 1986840 1986840 defendant Ledam Richard husbandman 589611 589611 Ledam, Richard, of Hekyngton, husbandman 3
3948991 2006712 2006712 defendant Motley Richard husbandman 589611 589611 Motley, Richard, of Hekyngton, husbandman 4
3958066 2009889 2009889 defendant Warner Thomas husbandman 589611 589611 Warner, Thomas, of Hekyngton, husbandman 2
4088590 2056223 2056223 defendant Garland John husbandman 589611 589611 Garland, John, of Hekyngton, husbandman 0
4088591 2056223 2056223 defendant Wyersdale Richard husbandman 589611 589611 Wyersdale, Richard, of Hekyngton, husbandman 1
4088592 2056223 2056223 defendant Tayler Percival husbandman 589611 589611 Tayler, Percival, of Hekyngton, husbandman 2
4110545 2064032 2064032 defendant Clayre Robert husbandman 589611 589611 Clayre, Robert, of Hekyngton, husbandman 2
4117471 2066543 2066543 defendant Garwell Hugh husbandman 589611 589611 Garwell, Hugh, of Hekyngton, husbandman 3
4196762 2094414 2094414 defendant Grantham Thomas gent 589611 589611 Grantham, Thomas, of Hekyngton, gent 0
4419171 2170866 2170866 defendant Engleys Walter   589611 589611 Engleys, Walter, of Hekyngton 1
4422555 2171916 2171916 plaintiff English Thomas   589611 589611 English, Thomas, of Hekyngton, son of Robert 0
4422556 2171916 2171916 defendant Cole Stephen   589611 589611 Cole, Stephen, of Hekyngton 0
4422557 2171916 2171916 defendant Cole John   589611 589611 Cole, John, of Hekyngton, son of Robert 1
4422558 2171916 2171916 defendant Jugge Roger   589611 589611 Jugge, Roger, of Hekyngton 2
4426588 2173126 2173126 plaintiff Pateshull John de   589611 589611 Pateshull, John de, of Hekyngton 0
4430920 2174431 2174431 defendant Engleys Walter   589611 589611 Engleys, Walter, of Hekyngton 1
4450312 2185057 2185057 defendant Inge John   589611 589611 Inge, John, of Hekyngton, son of William 1
4450313 2185057 2185057 defendant Howell William de   589611 589611 Howell, William de, of Hekyngton 2
4461213 2188589 2188589 plaintiff St Bothe William de   589611 589611 St Bothe, William de, of Hekyngton 0
4464549 2189581 2189581 plaintiff Watton Robert de (legal representative) 589611 589611 Watton, Robert de, of Hekyngton, formerly vicar, executors of 0
4464550 2189581 2189581 plaintiff Gerdener John chaplain 589611 589611 (Gerdener, John, of Hekyngton, chaplain 1
4464551 2189581 2189581 plaintiff Clere John   589611 589611 Clere, John, of Hekyngton 2
4464552 2189581 2189581 defendant Tournour Richard   589611 589611 Tournour, Richard, of Hekyngton 0
4482039 2195094 2195094 plaintiff Marsshall Robert chaplain of the altar of St Nicholas 589611 589611 Marsshall, Robert, of Hekyngton, chaplain of the altar of St Nicholas, on his own account 0
4482040 2195094 2195094 defendant Long William   589611 589611 Long, William, of Hekyngton, formerly chantry chaplain, at the alter of St Nicholas 0
4523672 2207732 2207732 defendant Smyth Alan   589611 589611 Smyth, Alan, of Hekyngton 0
4523678 2207735 2207735 defendant Smyth Alan   589611 589611 Smyth, Alan, of Hekyngton 0
4526911 2208696 2208696 defendant Boston Thomas de   589611 589611 Boston, Thomas de, of Hekyngton 0
4548849 2215575 2215575 defendant Barbour Richard   589611 589611 Barbour, Richard, of Hekyngton 0
4569799 2222128 2222128 defendant Ingoldesby John de   589611 589611 Ingoldesby, John de, of Hekyngton 10
4569868 2222146 2222146 defendant Bayton Thomas de   589611 589611 Bayton, Thomas de, of Hekyngton 0
4598994 2230909 2230909 defendant Humme Thomas   589611 589611 Humme, Thomas, of Hekyngton 0
4604521 2232581 2232581 defendant Cole John   589611 589611 Cole, John, of Hekyngton 0
4682514 2260157 2260157 defendant Gysburn John yeoman 589611 589611 Gysburn, John, of Hekyngton, yeoman 4
4693224 2263380 2263380 defendant Bryan John husbandman 589611 589611 Bryan, John, of Hekyngton, husbandman 0
4696783 2264472 2264472 plaintiff Chauntre Robert   589611 589611 Chauntre, Robert, of Hekyngton 0
4710132 2268521 2268521 defendant Milner Richard husbandman 589611 589611 Milner, Richard, of Hekyngton, husbandman 0
4714133 2269751 2269751 plaintiff Thornemanby (illegible)   589611 589611 Thornemanby, _, of Hekyngton 0
4750735 2280698 2280698 defendant Gysburn John husbandman 589611 589611 Gysburn, John, of Hekyngton, husbandman 4
4761757 2284017 2284017 defendant Hochonson John   589611 589611 Hochonson, John, of Hekyngton, butcher Rideley, John, of Hanbek, quarry man 0
4771878 2287180 2287180 defendant Hochonson John butcher 589611 589611 Hochonson, John, of Hekyngton, butcher 0
4783434 2290837 2290837 defendant Smyth Henry   589611 589611 Smyth, Henry, of Hekyngton 0
4857332 2313677 2313677 defendant Boston Isabel   589611 589611 Boston, Isabel, of Hekyngton, widow of Boston, Thomas 2
4864464 2315861 2315861 defendant Keteryngham Roger chaplain 589611 589611 Keteryngham, Roger, of Hekyngton, chaplain 2
4871121 2317945 2317945 defendant Hundmanby Robert husbandman 589611 589611 Hundmanby, Robert, of Hekyngton, husbandman 0
4886077 2322504 2322504 defendant Dekyn Richard yeoman 589611 589611 Dekyn, Richard, of Hekyngton, yeoman 0
4925186 2334311 2334311 defendant Payntour John yeoman 589611 589611 Payntour, John, of Hekyngton, yeoman 0
4926063 2334580 2334580 defendant Payntour John yeoman 589611 589611 Payntour, John, of Hekyngton, yeoman 0
4948020 2341363 2341363 defendant Payntour John   589611 589611 Payntour, John, of Hekyngton, bailiff 3
4948034 2341365 2341365 defendant Payntour John   589611 589611 Payntour, John, of Hekyngton, bailiff 3
4948051 2341368 2341368 defendant Payntour John   589611 589611 Payntour, John, of Hekyngton, bailiff 0
4948054 2341368 2341368 defendant Holme John husbandman 589611 589611 Holme, John, of Hekyngton, husbandman 3
4970770 2348199 2348199 defendant Holme John husbandman 589611 589611 Holme, John, of Hekyngton, husbandman 0
4970773 2348200 2348200 defendant Holme John husbandman 589611 589611 Holme, John, of Hekyngton, husbandman 0
4983614 2352021 2352021 defendant Payntour John   589611 589611 Payntour, John, of Hekyngton, bailiff 0
4985410 2352559 2352559 defendant Payntour John yeoman 589611 589611 Payntour, John, of Hekyngton, yeoman 0
4985411 2352559 2352559 defendant Bocher Thomas yeoman 589611 589611 Bocher, Thomas, of Hekyngton, yeoman 1
4993441 2354907 2354907 plaintiff Hovemanby Robert   589611 589611 Hovemanby, Robert, of Hekyngton 1
5001615 2357364 2357364 defendant Payntour John yeoman 589611 589611 Payntour, John, of Hekyngton, yeoman 0
5001616 2357364 2357364 defendant Bocher Thomas yeoman 589611 589611 Bocher, Thomas, of Hekyngton, yeoman 1
5001617 2357364 2357364 defendant Snaynton Robert yeoman 589611 589611 Snaynton, Robert, of Hekyngton, yeoman 2
5103930 2387575 2387575 defendant Bertilmewe Thomas fishmonger 589611 589611 Bertilmewe, Thomas, of Hekyngton, fishmonger 0
5127213 2394437 2394437 defendant Warner John yeoman 589611 589611 Warner, John, of Hekyngton, yeoman 0
5127214 2394437 2394437 defendant Cawdron John husbandman 589611 589611 Cawdron, John, of Hekyngton, husbandman 1
5198029 2415164 2415164 defendant Warner John yeoman 589611 589611 Warner, John, of Hekyngton, yeoman 0
5255468 2431832 2431832 defendant Cawedron John yeoman 589611 589611 Cawedron, John, of Hekyngton, yeoman 1
5259092 2432960 2432960 defendant Jennay John shoemaker 589611 589611 Jennay, John, of of Hekyngton, shoemaker 0
5263310 2434273 2434273 defendant Dykson Thomas husbandman 589611 589611 Dykson, Thomas, of Hekyngton, husbandman 0
5339572 2456950 2456950 defendant Crathorn Henry husbandman 589611 589611 Crathorn, Henry, of Hekyngton, husbandman 0
5340552 2457242 2457242 defendant Dyconson Thomas chapman 589611 589611 Dyconson, Thomas, of Hekyngton, chapman 0
5340554 2457242 2457242 defendant Hummanby Robert yeoman 589611 589611 Hummanby, Robert, of Hekyngton, yeoman 2
5348732 2459731 2459731 defendant Foster William husbandman 589611 589611 Foster, William, of Hekyngton, husbandman 1
5360772 2463401 2463401 defendant Candurn John husbandman 589611 589611 Candurn, John, of Hekyngton, husbandman 1
5366463 2465165 2465165 defendant Foster William husbandman 589611 589611 Foster, William, of Hekyngton, husbandman 2
5397162 2474272 2474272 defendant Foster William husbandman 589611 589611 Foster, William, of Hekyngton, husbandman 2
5410347 2478047 2478047 defendant Foster William husbandman 589611 589611 Foster, William, of Hekyngton, husbandman 3
5410354 2478049 2478049 defendant Foster William husbandman 589611 589611 Foster, William, of Hekyngton, husbandman 1
5438639 2486493 2486493 defendant Kylner Adam laborer 589611 589611 Kylner, Adam, of Hekyngton, laborer 0
5496332 2503806 2503806 defendant Hancok William husbandman 589611 589611 Hancok, William, of Hekyngton, husbandman 2
5527182 2513080 2513080 defendant Lodon John chaplain 589611 589611 Lodon, John, of Hekyngton, chaplain 0
5623216 2551196 2551196 plaintiff Wotton Robert de (legal representative) 589611 589611 Wotton, Robert de, of Hekyngton, formerly vicar, executors of 0
5623218 2551196 2551196 plaintiff Clerk John   589611 589611 Clerk, John, of Hekyngton 2

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