names

86 rows where place_id = 589402

✎ 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
3597541 1866853 1866853 defendant Watson Robert clerk 589402 589402 Watson, Robert, of Patryngton, clerk 1
3598346 1867112 1867112 defendant Nurre Thomas yeoman 589402 589402 Nurre, Thomas, of Patryngton, yeoman 0
3607519 1870010 1870010 defendant Watson William chaplain 589402 589402 Watson, William, of Patryngton, chaplain 1
3748576 1941486 1941486 defendant Cornelis Roland mercer 589402 589402 Cornelis, Roland, of Patryngton, mercer 1
3756917 1944140 1944140 defendant Thirkeld Richard yeoman 589402 589402 (Thirkeld, Richard, of Patryngton, yeoman 1
3756918 1944140 1944140 defendant Hogeshon Christopher yeoman 589402 589402 Hogeshon, Christopher, of Patryngton, yeoman 2
4101653 2060897 2060897 defendant Lacye Richard husbandman 589402 589402 Lacye, Richard, of Patryngton, husbandman 1
4429670 2174071 2174071 plaintiff Wath Michael de   589402 589402 Wath, Michael de, of Patryngton, parson 0
4429674 2174072 2174072 plaintiff Wath Michael de   589402 589402 Wath, Michael de, of Patryngton, parson 0
4486929 2196628 2196628 defendant Sergeant William   589402 589402 Sergeant, William, of Patryngton 0
4497673 2199918 2199918 defendant Smyth Robert   589402 589402 Smyth, Robert, of Patryngton 5
4497675 2199918 2199918 defendant Smyth Stephen   589402 589402 Smyth, Stephen, of Patryngton 7
4504169 2201857 2201857 defendant Walker Thomas   589402 589402 Walker, Thomas, of Patryngton 0
4535169 2211277 2211277 defendant Ricward Thomas   589402 589402 Ricward, Thomas, of Patryngton 0
4556240 2217890 2217890 defendant Ricwarde Thomas   589402 589402 Ricwarde, Thomas, of Patryngton 1
4564970 2220611 2220611 defendant Ricwa_ Thomas   589402 589402 Ricwa_, Thomas, of Patryngton 1
4600320 2231330 2231330 defendant Smyth Robert   589402 589402 Smyth, Robert, of Patryngton 1
4600324 2231330 2231330 defendant Jonson atte Leghes Stephen   589402 589402 Jonson atte Leghes, Stephen, of Patryngton 5
4652189 2246625 2246625 defendant Ricward Thomas husbandman 589402 589402 Ricward, Thomas, of Patryngton, husbandman 0
4654828 2247387 2247387 defendant Stevenson John husbandman 589402 589402 Stevenson, John, of Patryngton, husbandman 1
4660066 2248991 2248991 defendant Barthram Richard yeoman 589402 589402 Barthram, Richard, of Patryngton, yeoman 4
4694005 2263632 2263632 defendant Percy Thomas   589402 589402 Percy, Thomas, of Patryngton, franklin 1
4738792 2277221 2277221 defendant Tok John husbandman 589402 589402 Tok, John, of Patryngton, husbandman 3
4748624 2280094 2280094 plaintiff Merflete John (legal representative) 589402 589402 Merflete, John, of Patryngton, executor of 0
4748628 2280094 2280094 defendant Golde Alice widow & formerly wife of Testator 589402 589402 Golde, Alice, of Patryngton, widow & formerly wife of Testator 2
4758832 2283115 2283115 defendant Redmere William   589402 589402 Redmere, William, of Patryngton, shoe maker 2
4762486 2284248 2284248 defendant Coker John husbandman 589402 589402 Coker, John, of Patryngton, husbandman 1
4762487 2284248 2284248 defendant White John husbandman 589402 589402 White, John, of Patryngton, husbandman 2
4762488 2284248 2284248 defendant Lewyn John husbandman 589402 589402 Lewyn, John, of Patryngton, husbandman 3
4762489 2284248 2284248 defendant Goodbarne John husbandman 589402 589402 Goodbarne, John, of Patryngton, husbandman 4
4771049 2286924 2286924 defendant Oubarn John husbandman 589402 589402 Oubarn, John, of Patryngton, husbandman 0
4771050 2286924 2286924 defendant Oubarn Richard husbandman 589402 589402 Oubarn, Richard, of Patryngton, husbandman 1
4776543 2288657 2288657 defendant Redemer William cordwainer 589402 589402 Redemer, William, of Patryngton, cordwainer 0
4776544 2288657 2288657 defendant Garland John husbandman 589402 589402 Garland, John, of Patryngton, husbandman 1
4783984 2291000 2291000 defendant Lemyng John husbandman 589402 589402 Lemyng, John, of Patryngton, husbandman 2
4793735 2294159 2294159 defendant Tok John smith 589402 589402 Tok, John, of Patryngton, smith 0
4793736 2294159 2294159 defendant Halman John husbandman 589402 589402 Halman, John, of Patryngton, husbandman 1
4793737 2294159 2294159 defendant Garland John husbandman 589402 589402 Garland, John, of Patryngton, husbandman 2
4795297 2294681 2294681 plaintiff Redmer William   589402 589402 Redmer, William, of Patryngton 0
4802694 2297028 2297028 defendant Cok John husbandman 589402 589402 Cok, John, of Patryngton, husbandman 4
4802695 2297028 2297028 defendant Owebarn Richard husbandman 589402 589402 Owebarn, Richard, of Patryngton, husbandman 5
4817048 2301430 2301430 defendant Raynes Stephen husbandman 589402 589402 Raynes, Stephen, of Patryngton, husbandman 0
4821569 2302829 2302829 plaintiff Rykwardes Thomas husbandman 589402 589402 Rykwardes, Thomas, of Patryngton, husbandman 0
4821570 2302829 2302829 plaintiff Loker Robert chaplain 589402 589402 (Loker, Robert, of Patryngton, chaplain 1
4821571 2302829 2302829 plaintiff Cartwryght Thomas   589402 589402 Cartwryght, Thomas, of Patryngton, wright 2
4824897 2303825 2303825 plaintiff Tok John   589402 589402 Tok, John, of Patryngton 0
4824899 2303825 2303825 defendant Hodson Richard laborer 589402 589402 Hodson, Richard, of Patryngton, laborer 1
4828799 2305044 2305044 defendant Percy Thomas esq 589402 589402 Percy, Thomas, of Patryngton, esq 0
4828802 2305044 2305044 defendant Reynes Peter husbandman 589402 589402 Reynes, Peter, of Patryngton, husbandman 3
4843716 2309557 2309557 defendant Reynes Peter husbandman 589402 589402 Reynes, Peter, of Patryngton, husbandman 1
4843755 2309568 2309568 defendant Hauton John tailor 589402 589402 Hauton, John, of Patryngton, tailor 1
4847571 2310738 2310738 defendant Reynes Stephen   589402 589402 Reynes, Stephen, of Patryngton, wright 0
4854212 2312727 2312727 defendant Antyn or Autyn John tailor 589402 589402 Antyn or Autyn, John, of Patryngton, tailor 0
4854213 2312727 2312727 defendant Lowen John husbandman 589402 589402 Lowen, John, of Patryngton, husbandman 1
4854214 2312727 2312727 defendant Dood John husbandman 589402 589402 Dood, John, of Patryngton, husbandman 2
4854216 2312728 2312728 defendant Smyth Thomas husbandman 589402 589402 Smyth, Thomas, of Patryngton, husbandman 0
4855543 2313097 2313097 defendant Percy Thomas esq 589402 589402 Percy, Thomas, of Patryngton, esq 0
4855547 2313098 2313098 defendant Raynes Peter husbandman 589402 589402 Raynes, Peter, of Patryngton, husbandman 0
4867375 2316763 2316763 defendant of the Hille Robert miller 589402 589402 of the Hille, Robert, of Patryngton, miller 0
4867940 2316941 2316941 defendant Inthehirne Richard clerk 589402 589402 Inthehirne, Richard, of Patryngton, clerk 2
4919003 2332456 2332456 defendant Walker John shipman 589402 589402 Walker, John, of Patryngton, shipman 0
4923496 2333781 2333781 defendant Nodson John husbandman 589402 589402 Nodson, John, of Patryngton, husbandman 1
4941013 2339209 2339209 defendant Westiby John yeoman 589402 589402 Westiby, John, of Patryngton, yeoman 0
4959513 2344811 2344811 defendant Alcoke William butcher 589402 589402 Alcoke, William, of Patryngton, butcher 1
4970922 2348247 2348247 defendant Walker John yeoman 589402 589402 Walker, John, of Patryngton, yeoman 0
4997483 2356097 2356097 defendant Mountenay Robert gent 589402 589402 Mountenay, Robert, of Patryngton, gent 0
5013224 2360701 2360701 defendant Howbarn Robert husbandman 589402 589402 Howbarn, Robert, of Patryngton, husbandman 0
5024145 2363971 2363971 defendant Mountenay Robert gent 589402 589402 Mountenay, Robert, of Patryngton, gent 0
5035066 2367118 2367118 defendant Raynes Robert husbandman 589402 589402 Raynes, Robert, of Patryngton, husbandman 0
5035067 2367118 2367118 defendant Thorgot Robert husbandman 589402 589402 Thorgot, Robert, of Patryngton, husbandman 1
5041748 2369134 2369134 defendant Smyth Robert husbandman 589402 589402 Smyth, Robert, of Patryngton, husbandman 0
5050069 2371642 2371642 defendant Rauenes Clemency widow 589402 589402 Rauenes, Clemency, of Patryngton, widow 1
5097012 2385560 2385560 defendant William Thomas shipman 589402 589402 William, Thomas, of Patryngton, shipman 1
5097013 2385560 2385560 defendant Wynscalys William shipman 589402 589402 Wynscalys, William, of Patryngton, shipman 2
5097016 2385560 2385560 defendant Danson or Dauson Robert shipman 589402 589402 Danson or Dauson, Robert, of Patryngton, shipman 5
5097017 2385560 2385560 defendant Yonge Thomas shipman 589402 589402 Yonge, Thomas, of Patryngton, shipman 6
5097018 2385560 2385560 defendant Hertley John shipman 589402 589402 Hertley, John, of Patryngton, shipman 7
5126432 2394204 2394204 defendant Moskyn John   589402 589402 Moskyn, John, of Patryngton, administrators of 4
5126434 2394204 2394204 defendant Wylflete John chapman 589402 589402 Wylflete, John, of Patryngton, chapman 6
5541124 2517344 2517344 defendant Andrewe Richard shipman 589402 589402 Andrewe, Richard, of Patryngton, shipman 3
5541125 2517344 2517344 defendant Andrewe Thomas shipman 589402 589402 Andrewe, Thomas, of Patryngton, shipman 4
5611156 2547216 2547216 defendant Metham John de   589402 589402 Metham, John de, of Patryngton, parson 0
5618369 2549568 2549568 plaintiff Metham John de   589402 589402 Metham, John de, of Patryngton, parson 0
5618370 2549568 2549568 defendant Thorgot John   589402 589402 Thorgot, John, of Patryngton 0
5627121 2552449 2552449 defendant Wormeston Thomas husbandman 589402 589402 Wormeston, Thomas, of Patryngton, husbandman 0
5628366 2552832 2552832 defendant Tok John yeoman 589402 589402 Tok, John, of Patryngton, yeoman 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);