names

107 rows where place_id = 589914

✎ 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
3599249 1867409 1867409 defendant Grene John cooper 589914 589914 Grene, John, of Navenby, cooper 0
3599254 1867409 1867409 defendant Skyrmore Robert (legal representative) 589914 589914 Skyrmore, Robert, of Navenby, executor of 5
3599255 1867409 1867409 defendant Skyrmore Thomas husbandman 589914 589914 Skyrmore, Thomas, of Navenby, husbandman 6
3686680 1921989 1921989 plaintiff (not given) Richard churchwardens of Gray 589914 589914 Gray, Richard, of Navenby, tailor, churchwardens of Navenby 1
3726584 1934571 1934571 defendant Levessay William yeoman 589914 589914 Levessay, William, of Navenby, yeoman 0
3726585 1934571 1934571 defendant Clyff William husbandman 589914 589914 Clyff, William, of Navenby, husbandman 1
4342736 2144732 2144732 defendant Buckshawe Thomas yeoman 589914 589914 Buckshawe, Thomas, of Navenby, yeoman 0
4342738 2144732 2144732 defendant Bucke Robert husbandman 589914 589914 Bucke, Robert, of Navenby, husbandman 2
4342739 2144732 2144732 defendant Cooke Robert husbandman 589914 589914 Cooke, Robert, of Navenby, husbandman 3
4365572 2152753 2152753 defendant Cocke Robert husbandman 589914 589914 Cocke, Robert, of Navenby, husbandman 0
4365573 2152753 2152753 defendant Thorpe Richard husbandman 589914 589914 Thorpe, Richard, of Navenby, husbandman 1
4373507 2155593 2155593 defendant Bell John husbandman 589914 589914 Bell, John, of Navenby, husbandman 0
4373508 2155593 2155593 defendant Girswell Hugh husbandman 589914 589914 Girswell, Hugh, of Navenby, husbandman 1
4373509 2155593 2155593 defendant Thompson Leonard husbandman 589914 589914 Thompson, Leonard, of Navenby, husbandman 2
4373510 2155593 2155593 defendant Bent William husbandman 589914 589914 Bent, William, of Navenby, husbandman 3
4378964 2157555 2157555 defendant Hackworth Christopher husbandman 589914 589914 Hackworth, Christopher, of Navenby, husbandman 1
4426312 2173038 2173038 defendant Godewyn Thomas   589914 589914 Godewyn, Thomas, of Navenby 0
4438262 2181264 2181264 plaintiff Stretton Margaret   589914 589914 (Stretton, Margaret, of Navenby 1
4443805 2183037 2183037 defendant Rynglay Robert de   589914 589914 Rynglay, Robert de, of Navenby 0
4448339 2184407 2184407 defendant Redemenre Matilda   589914 589914 Redemenre, Matilda, of Navenby 1
4459726 2188094 2188094 defendant Fissher John   589914 589914 Fissher, John, of Navenby 7
4501390 2201038 2201038 defendant Smyth John   589914 589914 Smyth, John, of Navenby 5
4511024 2203899 2203899 plaintiff Beek Henry   589914 589914 Beek, Henry, of Navenby, parson 0
4511030 2203900 2203900 plaintiff Beek Henry   589914 589914 Beek, Henry, of Navenby, parson 0
4542904 2213674 2213674 plaintiff Ancotes Thomas   589914 589914 Ancotes, Thomas, of Navenby 0
4545644 2214561 2214561 defendant Mayre Maud   589914 589914 Mayre, Maud, of Navenby 0
4564713 2220527 2220527 defendant Smyth John   589914 589914 Smyth, John, of Navenby 2
4565152 2220672 2220672 plaintiff Skirmour Robert   589914 589914 Skirmour, Robert, of Navenby 0
4565153 2220672 2220672 defendant Sturdy Richard   589914 589914 Sturdy, Richard, of Navenby 0
4606771 2233230 2233230 defendant Stele Richard   589914 589914 Stele, Richard, of Navenby 4
4607888 2233583 2233583 defendant Matte Peter   589914 589914 Matte, Peter, of Navenby 0
4610370 2234324 2234324 defendant Smyth John   589914 589914 Smyth, John, of Navenby 1
4610378 2234325 2234325 defendant Caysawe John   589914 589914 Caysawe, John, of Navenby 0
4631349 2240696 2240696 defendant Stele Richard   589914 589914 Stele, Richard, of Navenby 0
4633763 2241412 2241412 defendant Barbour Joan   589914 589914 Barbour, Joan, of Navenby 3
4633764 2241412 2241412 defendant Pregeon John   589914 589914 Pregeon, John, of Navenby 4
4633765 2241412 2241412 defendant Wylcokes John   589914 589914 Wylcokes, John, of Navenby 5
4633766 2241412 2241412 defendant Wright Thomas   589914 589914 Wright, Thomas, of Navenby 6
4637878 2242616 2242616 defendant Stele Richard   589914 589914 Stele, Richard, of Navenby 0
4642328 2243876 2243876 defendant Skirmour Robert   589914 589914 Skirmour, Robert, of Navenby 0
4642329 2243876 2243876 defendant Whassyngburgh Peter   589914 589914 Whassyngburgh, Peter, of Navenby 1
4650083 2246040 2246040 defendant Matte Philip   589914 589914 Matte, Philip, of Navenby 0
4657127 2248121 2248121 defendant Page William   589914 589914 Page, William, of Navenby, bailiff 0
4657129 2248121 2248121 defendant Burton John, senior yeoman 589914 589914 Burton, John, senior, of Navenby, yeoman 2
4657135 2248122 2248122 defendant Page William   589914 589914 Page, William, of Navenby 0
4665351 2250650 2250650 defendant Page William husbandman 589914 589914 Page, William, of Navenby, husbandman 4
4682539 2260161 2260161 defendant Page William yeoman 589914 589914 Page, William, of Navenby, yeoman 3
4682565 2260165 2260165 defendant Page William, junior   589914 589914 Page, William, junior, of Navenby, bailiff 2
4684613 2260786 2260786 defendant Bocher Robert butcher 589914 589914 Bocher, Robert, of Navenby, butcher 1
4696758 2264465 2264465 defendant Skyrmore Robert yeoman 589914 589914 Skyrmore, Robert, of Navenby, yeoman 0
4718612 2271159 2271159 defendant Chaundeler John husbandman 589914 589914 Chaundeler, John, of Navenby, husbandman 0
4727071 2273728 2273728 defendant Chaundeller John   589914 589914 Chaundeller, John, of Navenby, bailiff 0
4729532 2274447 2274447 defendant Preston Henry husbandman 589914 589914 Preston, Henry, of Navenby, husbandman 0
4733172 2275552 2275552 defendant Skirmour Robert yeoman 589914 589914 Skirmour, Robert, of Navenby, yeoman 0
4737550 2276856 2276856 defendant Petyte William husbandman 589914 589914 Petyte, William, of Navenby, husbandman 2
4742417 2278277 2278277 plaintiff Carpenter John   589914 589914 Carpenter, John, of Navenby, parson 0
4742419 2278278 2278278 plaintiff Carpenter John   589914 589914 Carpenter, John, of Navenby, parson 0
4742420 2278278 2278278 defendant Preston John husbandman 589914 589914 Preston, John, of Navenby, husbandman 0
4742422 2278279 2278279 defendant Preston John husbandman 589914 589914 Preston, John, of Navenby, husbandman 0
4760380 2283601 2283601 defendant Petit Simon husbandman 589914 589914 Petit, Simon, of Navenby, husbandman 0
4773428 2287662 2287662 defendant Chaundeler John   589914 589914 Chaundeler, John, of Navenby, bailiff 2
4782786 2290632 2290632 defendant Petit Simon husbandman 589914 589914 Petit, Simon, of Navenby, husbandman 0
4782788 2290633 2290633 defendant Whassyngburgh Peter husbandman 589914 589914 Whassyngburgh, Peter, of Navenby, husbandman 0
4800972 2296494 2296494 defendant Silkeby Ellen   589914 589914 Silkeby, Ellen, of Navenby, servant 0
4800974 2296495 2296495 defendant Skyrmour Robert husbandman 589914 589914 Skyrmour, Robert, of Navenby, husbandman 0
4806158 2298133 2298133 defendant Matte Peter milner 589914 589914 Matte, Peter, of Navenby, milner 2
4808928 2298967 2298967 defendant Bukke William shoemaker 589914 589914 Bukke, William, of Navenby, shoemaker 3
4808929 2298967 2298967 defendant Taillour William tailor 589914 589914 Taillour, William, of Navenby, tailor 4
4821948 2302937 2302937 defendant Sely William husbandman 589914 589914 Sely, William, of Navenby, husbandman 1
4858045 2313884 2313884 defendant Bowke William shoemaker 589914 589914 Bowke, William, of Navenby, shoemaker 0
4858849 2314144 2314144 defendant Bowle William shoemaker 589914 589914 Bowle, William, of Navenby, shoemaker 0
4865819 2316278 2316278 defendant Basset Robert husbandman 589914 589914 Basset, Robert, of Navenby, husbandman 0
4882356 2321393 2321393 defendant Preston Henry husbandman 589914 589914 Preston, Henry, of Navenby, husbandman 0
4886102 2322511 2322511 defendant Bouke William shoemaker 589914 589914 Bouke, William, of Navenby, shoemaker 0
4886117 2322517 2322517 defendant Hull Thomas husbandman 589914 589914 Hull, Thomas, of Navenby, husbandman 0
4886118 2322517 2322517 defendant Keller Robert husbandman 589914 589914 Keller, Robert, of Navenby, husbandman 1
4928376 2335298 2335298 defendant Preston Henry chaplain 589914 589914 Preston, Henry, of Navenby, chaplain 0
4952092 2342592 2342592 defendant Bentley John thatcher 589914 589914 Bentley, John, of Navenby, thatcher 0
4960232 2345035 2345035 defendant Bulk William shoemaker 589914 589914 Bulk, William, of Navenby, shoemaker 0
4988449 2353506 2353506 defendant Couper Thomas cooper 589914 589914 Couper, Thomas, of Navenby, cooper 0
4988450 2353506 2353506 defendant Hull Richard husbandman 589914 589914 Hull, Richard, of Navenby, husbandman 1
4988457 2353507 2353507 defendant Whassyngburgh Simon husbandman 589914 589914 Whassyngburgh, Simon, of Navenby, husbandman 4
4989059 2353665 2353665 defendant Seely William husbandman 589914 589914 Seely, William, of Navenby, husbandman 0
5007579 2359114 2359114 defendant Sely William   589914 589914 Sely, William, of Navenby 0
5007581 2359115 2359115 defendant Herman John butcher 589914 589914 Herman, John, of Navenby, butcher 0
5213422 2419656 2419656 defendant Garnet John   589914 589914 Garnet, John, of Navenby, parish clerk 1
5213710 2419742 2419742 defendant Whasshyngburgh Simon husbandman 589914 589914 Whasshyngburgh, Simon, of Navenby, husbandman 5
5213711 2419742 2419742 defendant Gregge Robert husbandman 589914 589914 Gregge, Robert, of Navenby, husbandman 6
5282468 2439934 2439934 defendant Bate Thomas husbandman 589914 589914 Bate, Thomas, of Navenby, husbandman 0
5294058 2443236 2443236 defendant Sherman John husbandman 589914 589914 Sherman, John, of Navenby, husbandman 0
5294059 2443236 2443236 defendant Skyrmore Robert husbandman 589914 589914 Skyrmore, Robert, of Navenby, husbandman 1
5294060 2443236 2443236 defendant Sheperd Richard   589914 589914 Sheperd, Richard, of Navenby, shepherd 2
5337329 2456236 2456236 defendant Peycok Richard husbandman 589914 589914 Peycok, Richard, of Navenby, husbandman 0
5369862 2466163 2466163 defendant Tynghyll William husbandman 589914 589914 Tynghyll, William, of Navenby, husbandman 0
5377286 2468485 2468485 defendant Bell John, junior husbandman 589914 589914 Bell, John, junior, of Navenby, husbandman 0
5377287 2468485 2468485 defendant Bell Robert husbandman 589914 589914 Bell, Robert, of Navenby, husbandman 1
5377288 2468485 2468485 defendant Blymyson Alexander yeoman 589914 589914 Blymyson, Alexander, of Navenby, yeoman 2
5377289 2468485 2468485 defendant Burton John husbandman 589914 589914 Burton, John, of Navenby, husbandman 3
5407772 2477302 2477302 defendant Langton John husbandman 589914 589914 Langton, John, of Navenby, husbandman 0
5407773 2477302 2477302 defendant Sampson John laborer 589914 589914 Sampson, John, of Navenby, laborer 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);