names

105 rows where place_id = 595431

✎ 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
3620450 1873972 1873972 defendant Twysell Robert yeoman 595431 595431 Twysell, Robert, of North Cave, yeoman 18
3620451 1873972 1873972 defendant Abbot Thomas yeoman 595431 595431 Abbot, Thomas, of North Cave, yeoman 19
3620965 1874120 1874120 defendant Clyff Peter husbandman 595431 595431 Clyff, Peter, of North Cave, husbandman 0
3703573 1927394 1927394 defendant Gyles Thomas miller 595431 595431 Gyles, Thomas, of North Cave, miller 0
3703577 1927395 1927395 defendant Gyles Thomas miller 595431 595431 Gyles, Thomas, of North Cave, miller 0
3746269 1940742 1940742 defendant Jeneson William yeoman 595431 595431 Jeneson, William, of North Cave, yeoman 1
3811882 1961619 1961619 defendant Wade Robert clerk 595431 595431 Wade, Robert, of North Cave, clerk 2
3816451 1963055 1963055 defendant Wever Nicholas glover 595431 595431 Wever, Nicholas, of North Cave, glover 0
3843855 1971617 1971617 defendant Hadlowe Robert yeoman 595431 595431 (Hadlowe, Robert, of North Cave, yeoman 1
3843856 1971617 1971617 defendant Monketon Marmaduke gent 595431 595431 Monketon, Marmaduke, of North Cave, gent 2
3850439 1973727 1973727 defendant Stevyn Thomas husbandman 595431 595431 Stevyn, Thomas, of North Cave, husbandman 6
3850440 1973727 1973727 defendant Jennyson Agnes widow 595431 595431 Jennyson, Agnes, of North Cave, widow 7
3850441 1973727 1973727 defendant Fanden or Fauden Lawrence husbandman 595431 595431 Fanden or Fauden, Lawrence, of North Cave, husbandman 8
3850442 1973727 1973727 defendant Forster William husbandman 595431 595431 Forster, William, of North Cave, husbandman 9
3850443 1973727 1973727 defendant Westmorland John husbandman 595431 595431 Westmorland, John, of North Cave, husbandman 10
3965775 2012644 2012644 plaintiff Benns Ralph   595431 595431 Benns, Ralph, of North Cave 0
3965779 2012645 2012645 plaintiff Benns Ralph   595431 595431 Benns, Ralph, of North Cave 0
4392440 2162095 2162095 defendant Watson John yeoman 595431 595431 Watson, John, of North Cave, yeoman 1
4423836 2172305 2172305 defendant Hakun Geoffrey   595431 595431 Hakun, Geoffrey, of North Cave, parson 0
4472625 2192107 2192107 defendant Dighton Nicholas   595431 595431 Dighton, Nicholas, of North Cave, vicar 0
4486640 2196533 2196533 plaintiff Sauton or Santon Richard de   595431 595431 Sauton or Santon, Richard de, of North Cave 0
4486642 2196533 2196533 defendant Ellerkar John   595431 595431 Ellerkar, John, of North Cave 1
4497259 2199790 2199790 defendant Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4502323 2201316 2201316 defendant Daweson William smith 595431 595431 Daweson, William, of North Cave, smith 0
4502328 2201316 2201316 defendant Pay William   595431 595431 Pay, William, of North Cave 5
4504673 2202005 2202005 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave, on his own account 0
4504680 2202006 2202006 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave, on his own account 0
4532684 2210490 2210490 defendant Fippyers John   595431 595431 Fippyers, John, of North Cave 0
4534379 2211023 2211023 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4534381 2211024 2211024 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4534384 2211025 2211025 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4564514 2220463 2220463 defendant Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4594573 2229560 2229560 defendant Surhill Nicholas   595431 595431 Surhill, Nicholas, of North Cave 0
4628209 2239749 2239749 defendant Noure John   595431 595431 Noure, John, of North Cave 1
4628267 2239768 2239768 defendant Ripley Richard (legal representative) 595431 595431 Ripley, Richard, of North Cave, executors of 0
4644173 2244389 2244389 defendant smyth Robert   595431 595431 smyth, Robert, of North Cave 2
4647286 2245260 2245260 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4685746 2261132 2261132 plaintiff Santon Richard de   595431 595431 Santon, Richard de, of North Cave 0
4697320 2264641 2264641 plaintiff Clyf William   595431 595431 Clyf, William, of North Cave 0
4697321 2264641 2264641 defendant Hill Thomas de yeoman 595431 595431 Hill, Thomas de, of North Cave, yeoman 0
4697322 2264641 2264641 defendant Daynyll or Dayvyll John yeoman 595431 595431 Daynyll or Dayvyll, John, of North Cave, yeoman 1
4699832 2265392 2265392 defendant Shepherd Peter husbandman 595431 595431 Shepherd, Peter, of North Cave, husbandman 2
4708063 2267897 2267897 defendant Comyn Thomas yeoman 595431 595431 Comyn, Thomas, of North Cave, yeoman 0
4708064 2267897 2267897 defendant Broune Richard husbandman 595431 595431 Broune, Richard, of North Cave, husbandman 1
4708319 2267974 2267974 defendant Syther Thomas laborer 595431 595431 Syther, Thomas, of North Cave, laborer 4
4708320 2267974 2267974 defendant Hill Thomas yeoman 595431 595431 Hill, Thomas, of North Cave, yeoman 5
4720476 2271740 2271740 defendant Sydehare Thomas husbandman 595431 595431 Sydehare, Thomas, of North Cave, husbandman 0
4734338 2275910 2275910 plaintiff Santon Richard   595431 595431 Santon, Richard, of North Cave 0
4738448 2277115 2277115 defendant del Hill Thomas yeoman 595431 595431 del Hill, Thomas, of North Cave, yeoman 0
4738449 2277115 2277115 defendant Dayvell John yeoman 595431 595431 Dayvell, John, of North Cave, yeoman 1
4821841 2302905 2302905 plaintiff Santon Robert   595431 595431 Santon, Robert, of North Cave 0
4829110 2305146 2305146 defendant atte Lane John   595431 595431 atte Lane, John, of North Cave, shepherd 2
4829111 2305146 2305146 defendant atte Hill Richard laborer 595431 595431 atte Hill, Richard, of North Cave, laborer 3
4829112 2305146 2305146 defendant Stayther William laborer 595431 595431 together with Stayther, William, of North Cave, laborer 4
4829116 2305148 2305148 defendant Stayther William laborer 595431 595431 Stayther, William, of North Cave, laborer 0
4829119 2305148 2305148 defendant atte lane John   595431 595431 atte lane, John, of North Cave, shepherd 3
4829120 2305148 2305148 defendant atte Hill Richard laborer 595431 595431 atte Hill, Richard, of North Cave, laborer 4
4848038 2310855 2310855 plaintiff Santon Robert (legal representative) 595431 595431 Santon, Robert, of North Cave, esq, executor of Grenake, William, of Scrayngham, parson, executors of 0
4848046 2310855 2310855 plaintiff Accom John   595431 595431 Accom, John, of North Cave, vicar 8
4857981 2313864 2313864 defendant Comyn Thomas husbandman 595431 595431 Comyn, Thomas, of North Cave, husbandman 1
4858644 2314076 2314076 defendant Santon or Sauton Peter gent 595431 595431 Santon or Sauton, Peter, of North Cave, gent 0
4858645 2314076 2314076 defendant Marton John husbandman 595431 595431 Marton, John, of North Cave, husbandman 1
4858646 2314076 2314076 defendant Dayvell John   595431 595431 Dayvell, John, of North Cave, "pynder" or impounder 2
4860582 2314667 2314667 defendant Hill Thomas yeoman 595431 595431 Hill, Thomas, of North Cave, yeoman 0
4871001 2317905 2317905 defendant Dayvell William husbandman 595431 595431 Dayvell, William, of North Cave, husbandman 4
4875641 2319339 2319339 defendant Kyrkeby Robert miller 595431 595431 Kyrkeby, Robert, of North Cave, miller 0
4875642 2319339 2319339 defendant Nayr Robert husbandman 595431 595431 Nayr, Robert, of North Cave, husbandman 1
4875643 2319339 2319339 defendant Wessell William husbandman 595431 595431 Wessell, William, of North Cave, husbandman 2
4875644 2319339 2319339 defendant Catell Thomas smith 595431 595431 Catell, Thomas, of North Cave, smith 3
4875645 2319339 2319339 defendant Hill Richard laborer 595431 595431 Hill, Richard, of North Cave, laborer 4
4890477 2323786 2323786 defendant Hyll Thomas yeoman 595431 595431 Hyll, Thomas, of North Cave, yeoman 1
4947751 2341283 2341283 defendant Nare Robert husbandman 595431 595431 Nare, Robert, of North Cave, husbandman 1
4948932 2341648 2341648 defendant Thornton Robert husbandman 595431 595431 Thornton, Robert, of North Cave, husbandman 2
4948937 2341650 2341650 defendant Hundeslay Robert husbandman 595431 595431 Hundeslay, Robert, of North Cave, husbandman 0
4948938 2341650 2341650 defendant Nutbroune Robert husbandman 595431 595431 Nutbroune, Robert, of North Cave, husbandman 1
4948939 2341650 2341650 defendant Warner Richard husbandman 595431 595431 Warner, Richard, of North Cave, husbandman 2
4948940 2341650 2341650 defendant del Hall Richard, senior husbandman 595431 595431 del Hall, Richard, senior, of North Cave, husbandman 3
4996582 2355832 2355832 defendant Clyffe Edward husbandman 595431 595431 Clyffe, Edward, of North Cave, husbandman 0
5017399 2361977 2361977 defendant Oustiby Richard yeoman 595431 595431 Oustiby, Richard, of North Cave, yeoman 0
5017400 2361977 2361977 defendant Warner Richard hiusbandman 595431 595431 Warner, Richard, of North Cave, hiusbandman 1
5037980 2367991 2367991 defendant Brichefeld Roger esq 595431 595431 Brichefeld, Roger, of North Cave, esq 0
5078632 2380104 2380104 defendant Smyth Thomas smith 595431 595431 Smyth, Thomas, of North Cave, smith 0
5078633 2380104 2380104 defendant Cooke John husbandman 595431 595431 Cooke, John, of North Cave, husbandman 1
5145790 2399905 2399905 defendant Peirson Robert husbandman 595431 595431 Peirson, Robert, of North Cave, husbandman 6
5159573 2403916 2403916 defendant Smyth John husbandman 595431 595431 Smyth, John, of North Cave, husbandman 0
5159574 2403916 2403916 defendant Thornton Richard husbandman 595431 595431 Thornton, Richard, of North Cave, husbandman 1
5159575 2403916 2403916 defendant Waldeby William husbandman 595431 595431 Waldeby, William, of North Cave, husbandman 2
5159576 2403916 2403916 defendant Wryght John butcher 595431 595431 Wryght, John, of North Cave, butcher 3
5159577 2403916 2403916 defendant Saunderson Thomas butcher 595431 595431 Saunderson, Thomas, of North Cave, butcher 4
5166135 2405828 2405828 defendant Peirson Robert husbandman 595431 595431 Peirson, Robert, of North Cave, husbandman 9
5223033 2422452 2422452 defendant Wright Robert miller 595431 595431 Wright, Robert, of North Cave, miller 7
5223034 2422452 2422452 defendant Brettan Thomas hosteler 595431 595431 Brettan, Thomas, of North Cave, hosteler 8
5223035 2422452 2422452 defendant Clerk John   595431 595431 Clerk, John, of North Cave, servant 9
5228911 2424062 2424062 defendant Watson John yeoman 595431 595431 Watson, John, of North Cave, yeoman 2
5228912 2424062 2424062 defendant Boucher John husbandman 595431 595431 Boucher, John, of North Cave, husbandman 3
5228913 2424062 2424062 defendant Tailliour Thomas husbandman 595431 595431 Tailliour, Thomas, of North Cave, husbandman 4
5228918 2424062 2424062 defendant Kune William yeoman 595431 595431 together with Kune, William, of North Cave, yeoman 9
5228919 2424062 2424062 defendant del Hill William husbandman 595431 595431 del Hill, William, of North Cave, husbandman 10
5228920 2424062 2424062 defendant Wright Robert husbandman 595431 595431 Wright, Robert, of North Cave, husbandman 11
5228921 2424062 2424062 defendant Warner Thomas husbandman 595431 595431 Warner, Thomas, of North Cave, husbandman 12

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