names

115 rows where place_id = 590740

✎ 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
3602134 1868332 1868332 plaintiff Brighwell Thomas yeoman 590740 590740 Brighwell, Thomas, of Rollesby, yeoman 0
3660988 1913709 1913709 defendant Steynford Evan yeoman 590740 590740 Steynford, Evan, of Rollesby, yeoman 1
3674276 1917997 1917997 defendant Ufford Thomas husbandman 590740 590740 Ufford, Thomas, of Rollesby, husbandman 2
3686556 1921945 1921945 defendant Kene Miles gent 590740 590740 Kene, Miles, of Rollesby, gent 0
3701586 1926744 1926744 defendant Ufforth Thomas husbandman 590740 590740 Ufforth, Thomas, of Rollesby, husbandman 0
3711573 1929929 1929929 defendant Ufford Thomas yeoman 590740 590740 Ufford, Thomas, of Rollesby, yeoman 0
3711579 1929930 1929930 defendant Norwyche Thomas yeoman 590740 590740 Norwyche, Thomas, of Rollesby, yeoman 0
3717087 1931629 1931629 defendant Ufford Thomas husbandman 590740 590740 Ufford, Thomas, of Rollesby, husbandman 0
3719522 1932370 1932370 defendant Colt John, junior husbandman 590740 590740 Colt, John, junior, of Rollesby, husbandman 1
3726611 1934583 1934583 defendant Ufforth Thomas yeoman 590740 590740 Ufforth, Thomas, of Rollesby, yeoman 1
3732770 1936479 1936479 defendant Ufford Thomas husbandman 590740 590740 Ufford, Thomas, of Rollesby, husbandman 0
3732774 1936480 1936480 defendant Ufford Thomas husbandman 590740 590740 Ufford, Thomas, of Rollesby, husbandman 0
3757880 1944445 1944445 plaintiff Boys Richard gent 590740 590740 Boys, Richard, of Rollesby, gent 0
3757881 1944445 1944445 defendant Rysyng John husbandman 590740 590740 Rysyng, John, of Rollesby, husbandman 0
3769399 1948085 1948085 defendant Kene Miles yeoman 590740 590740 Kene, Miles, of Rollesby, yeoman 2
3779032 1951165 1951165 defendant Rumpe John (legal representative) 590740 590740 Rumpe, John, of Rollesby, husbandman, executors of 3
3811020 1961339 1961339 plaintiff Bygbank John   590740 590740 Bygbank, John, of Rollesby 0
3811022 1961340 1961340 plaintiff Bygbanke John   590740 590740 Bygbanke, John, of Rollesby 0
3813267 1962061 1962061 defendant Rumpe John (legal representative) 590740 590740 Rumpe, John, of Rollesby, husbandman, executor of 0
3815255 1962687 1962687 defendant Usser Thomas husbandman 590740 590740 Usser, Thomas, of Rollesby, husbandman 1
3822583 1964967 1964967 defendant Ufford Robert husbandman 590740 590740 Ufford, Robert, of Rollesby, husbandman 0
3863405 1977955 1977955 defendant Gappes Robert yeoman 590740 590740 Gappes, Robert, of Rollesby, yeoman 2
3983750 2018962 2018962 defendant Howes John carpenter 590740 590740 Howes, John, of Rollesby, carpenter 1
4000654 2025007 2025007 defendant Bretton Thomas   590740 590740 Bretton, Thomas, of Rollesby 0
4225936 2104539 2104539 defendant Shanke John, junior gent 590740 590740 Shanke, John, junior, of Rollesby, or of Wynterton, gent 0
4229472 2105792 2105792 defendant Shonck William yeoman 590740 590740 Shonck, William, of Rollesby, yeoman 0
4252931 2113975 2113975 defendant Shanke John, junior gent 590740 590740 Shanke, John, junior, of Rollesby, or of Wynterton, gent 0
4324924 2138721 2138721 defendant Durrell John husbandman 590740 590740 Durrell, John, of Rollesby, husbandman 1
4482229 2195151 2195151 defendant Woderove William   590740 590740 Woderove, William, of Rollesby 0
4598278 2230701 2230701 defendant Woderove Simon   590740 590740 Woderove, Simon, of Rollesby 1
4609818 2234163 2234163 plaintiff Bury Peter   590740 590740 Bury, Peter, of Rollesby 0
4619584 2237116 2237116 defendant Rede John   590740 590740 Rede, John, of Rollesby 3
4643528 2244208 2244208 defendant Wryght Nicholas   590740 590740 Wryght, Nicholas, of Rollesby 1
4693649 2263515 2263515 defendant Waterman Robert laborer 590740 590740 Waterman, Robert, of Rollesby, laborer 0
4693650 2263515 2263515 defendant Mough or Mongh William laborer 590740 590740 Mough or Mongh, William, of Rollesby, laborer 1
4693651 2263515 2263515 defendant Mongh John laborer 590740 590740 Mongh, John, of Rollesby, laborer 2
4704596 2266815 2266815 defendant Waterman Robert laborer 590740 590740 Waterman, Robert, of Rollesby, laborer 0
4704597 2266815 2266815 defendant Croft William laborer 590740 590740 Croft, William, of Rollesby, laborer 1
4707202 2267633 2267633 defendant Jackkes John husbandman 590740 590740 Jackkes, John, of Rollesby, husbandman 0
4758973 2283158 2283158 defendant Hoggekyns John husbandman 590740 590740 Hoggekyns, John, of Rollesby, husbandman 2
4768693 2286186 2286186 defendant Kyrkgate John yeoman 590740 590740 Kyrkgate, John, of Rollesby, yeoman 2
4776912 2288765 2288765 plaintiff Arnald Thomas   590740 590740 Arnald, Thomas, of Rollesby 0
4776913 2288765 2288765 defendant Rede Robert husbandman 590740 590740 Rede, Robert, of Rollesby, husbandman 0
4838549 2307976 2307976 defendant Reede Robert husbandman 590740 590740 Reede, Robert, of Rollesby, husbandman 0
4856259 2313330 2313330 defendant Heyward Robert yeoman 590740 590740 Heyward, Robert, of Rollesby, yeoman 0
4872370 2318319 2318319 defendant Kyrkegate John husbandman 590740 590740 Kyrkegate, John, of Rollesby, husbandman 0
4878395 2320189 2320189 defendant Rede Robert yeoman 590740 590740 Rede, Robert, of Rollesby, yeoman 6
4887237 2322847 2322847 defendant Mondford John yeoman 590740 590740 Mondford, John, of Rollesby, yeoman 0
4891658 2324130 2324130 defendant Mondford John yeoman 590740 590740 Mondford, John, of Rollesby, yeoman 0
4901162 2326979 2326979 defendant Kyrgate John husbandman 590740 590740 Kyrgate, John, of Rollesby, husbandman 6
4907778 2328995 2328995 defendant Kyrgard John husbandman 590740 590740 Kyrgard, John, of Rollesby, husbandman 0
4907780 2328995 2328995 defendant Croweston William husbandman 590740 590740 Croweston, William, of Rollesby, husbandman 2
4948722 2341584 2341584 plaintiff Mundford John   590740 590740 Mundford, John, of Rollesby 1
4954592 2343332 2343332 defendant Mundeford John courser 590740 590740 Mundeford, John, of Rollesby, courser 2
4963974 2346134 2346134 defendant Mundforth John yeoman 590740 590740 Mundforth, John, of Rollesby, yeoman 0
4979766 2350903 2350903 defendant Estgate John husbandman 590740 590740 Estgate, John, of Rollesby, husbandman 1
4986026 2352739 2352739 plaintiff Arnold Thomas   590740 590740 Arnold, Thomas, of Rollesby 0
5000408 2356987 2356987 defendant Estgate Richard husbandman 590740 590740 Estgate, Richard, of Rollesby, husbandman 0
5000409 2356987 2356987 defendant Gable John laborer 590740 590740 Gable, John, of Rollesby, laborer 1
5003694 2357973 2357973 defendant Estgate Richard husbandman 590740 590740 Estgate, Richard, of Rollesby, husbandman 0
5051874 2372174 2372174 defendant Sumpter Nicholas barber 590740 590740 Sumpter, Nicholas, of Rollesby, barber 0
5063636 2375657 2375657 plaintiff Jekkys John   590740 590740 Jekkys, John, of Rollesby 0
5063639 2375657 2375657 defendant Mundeford John yeoman 590740 590740 Mundeford, John, of Rollesby, yeoman 2
5063827 2375715 2375715 defendant Jekkys John yeoman 590740 590740 Jekkys, John, of Rollesby, yeoman 0
5095203 2385013 2385013 defendant Mundeford John yeoman 590740 590740 Mundeford, John, of Rollesby, yeoman 0
5116340 2391210 2391210 defendant Barbour Nicholas husbandman 590740 590740 Barbour, Nicholas, of Rollesby, husbandman 1
5116345 2391210 2391210 defendant Kyng John husbandman 590740 590740 Kyng, John, of Rollesby, husbandman 6
5116359 2391211 2391211 defendant Kyng John laborer 590740 590740 Kyng, John, of Rollesby, laborer 7
5118144 2391740 2391740 defendant Moundeford John yeoman 590740 590740 Moundeford, John, of Rollesby, yeoman 2
5119446 2392115 2392115 defendant Moundeford John yeoman 590740 590740 Moundeford, John, of Rollesby, yeoman 0
5144566 2399571 2399571 plaintiff Berkyng John   590740 590740 Berkyng, John, of Rollesby 0
5144568 2399571 2399571 plaintiff Paynot John   590740 590740 Paynot, John, of Rollesby 2
5150408 2401254 2401254 defendant Barbowr Nicholas yeoman 590740 590740 Barbowr, Nicholas, of Rollesby, yeoman 0
5157131 2403224 2403224 defendant Hopper Richard laborer 590740 590740 Hopper, Richard, of Rollesby, laborer 3
5165351 2405613 2405613 plaintiff Berkyng John   590740 590740 Berkyng, John, of Rollesby 0
5165353 2405613 2405613 plaintiff Paynot John   590740 590740 Paynot, John, of Rollesby 2
5168941 2406647 2406647 defendant Barbowre Nicholas yeoman 590740 590740 Barbowre, Nicholas, of Rollesby, yeoman 0
5173173 2407863 2407863 defendant Hopper Richard laborer 590740 590740 Hopper, Richard, of Rollesby, laborer 3
5179294 2409682 2409682 plaintiff Berkyng John   590740 590740 Berkyng, John, of Rollesby 0
5179296 2409682 2409682 plaintiff Paynot John   590740 590740 Paynot, John, of Rollesby 2
5191942 2413375 2413375 defendant Croxton William husbandman 590740 590740 Croxton, William, of Rollesby, husbandman 0
5204720 2417125 2417125 defendant Barbowre Nicholas yeoman 590740 590740 Barbowre, Nicholas, of Rollesby, yeoman 0
5207569 2417953 2417953 defendant Croxton William husbandman 590740 590740 Croxton, William, of Rollesby, husbandman 0
5220672 2421740 2421740 defendant Kyng John laborer 590740 590740 Kyng, John, of Rollesby, laborer 3
5239986 2427270 2427270 defendant Talyor John yeoman 590740 590740 Talyor, John, of Rollesby, yeoman 0
5243652 2428336 2428336 defendant Russe Stephen husbandman 590740 590740 Russe, Stephen, of Rollesby, husbandman 0
5253397 2431164 2431164 defendant Alberd John butcher 590740 590740 Alberd, John, of Rollesby, butcher 0
5260359 2433365 2433365 defendant Mundesford John husbandman 590740 590740 Mundesford, John, of Rollesby, husbandman 4
5262791 2434106 2434106 defendant Ormesby Roger gent 590740 590740 Ormesby, Roger, of Rollesby, gent 0
5262793 2434107 2434107 defendant Ormesby Roger gent 590740 590740 Ormesby, Roger, of Rollesby, gent 0
5266293 2435210 2435210 defendant Floures Robert husbandman 590740 590740 Floures, Robert, of Rollesby, husbandman 1
5273109 2437207 2437207 defendant Sayho John yeoman 590740 590740 Sayho, John, of Rollesby, yeoman 0
5288836 2441745 2441745 defendant Seyne or Seyve John yeoman 590740 590740 Seyne or Seyve, John, of Rollesby, yeoman 0
5336004 2455841 2455841 defendant Sayne John yeoman 590740 590740 Sayne, John, of Rollesby, yeoman 0
5347977 2459507 2459507 defendant Barbour Nicholas husbandman 590740 590740 Barbour, Nicholas, of Rollesby, husbandman 2
5359319 2462951 2462951 defendant Seyve John yeoman 590740 590740 Seyve, John, of Rollesby, yeoman 0
5407592 2477242 2477242 defendant Russe Stephen husbandman 590740 590740 Russe, Stephen, of Rollesby, husbandman 0
5439832 2486853 2486853 defendant Russe Stephen husbandman 590740 590740 Russe, Stephen, of Rollesby, husbandman 0
5439840 2486855 2486855 defendant Russe Stephan husbandman 590740 590740 Russe, Stephan, of Rollesby, husbandman 0
5486748 2500937 2500937 defendant Russe Stephen husbandman 590740 590740 Russe, Stephen, of Rollesby, husbandman 0

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