names

140 rows where place_id = 589427

✎ 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
3597625 1866882 1866882 defendant Vyell George gent 589427 589427 Vyell, George, of Alyngton, gent 0
3627732 1903534 1903534 defendant Graunt Robert husbandman 589427 589427 Graunt, Robert, of Alyngton, husbandman 0
3627733 1903534 1903534 defendant Kellom Hugh husbandman 589427 589427 Kellom, Hugh, of Alyngton, husbandman 1
3630768 1904448 1904448 defendant Hayle Robert singleman 589427 589427 Hayle, Robert, of Alyngton, singleman 3
3634194 1905496 1905496 defendant Crosse Robert chaplain 589427 589427 Crosse, Robert, of Alyngton, chaplain 1
3636758 1906290 1906290 defendant Russhe Edward clerk 589427 589427 (Russhe, Edward, of Alyngton, clerk 1
3636759 1906290 1906290 defendant Russhe Sybil widow 589427 589427 Russhe, Sybil, of Alyngton, widow 2
3641758 1907874 1907874 defendant Graunt Robert   589427 589427 Graunt, Robert, of Alyngton 0
3641759 1907874 1907874 defendant Kellom Hugh husbandman 589427 589427 Kellom, Hugh, of Alyngton, husbandman 1
3654843 1911773 1911773 defendant Coysshe Walter   589427 589427 Coysshe, Walter, of Alyngton, mason 2
3669336 1916347 1916347 defendant Lynsey John husbandman 589427 589427 Lynsey, John, of Alyngton, husbandman 2
3672114 1917278 1917278 defendant Terry William husbandman 589427 589427 Terry, William, of Alyngton, husbandman 0
3689700 1922935 1922935 defendant Wright William husbandman 589427 589427 Wright, William, of Alyngton, husbandman 0
3710549 1929621 1929621 defendant Crawley Walter husbandman 589427 589427 Crawley, Walter, of Alyngton, husbandman 0
3740663 1938941 1938941 defendant Medelond John   589427 589427 Medelond, John, of Alyngton, groom 1
3765929 1947010 1947010 defendant Hiscook John, senior husbandman 589427 589427 Hiscook, John, senior, of Alyngton, husbandman 1
3765930 1947010 1947010 defendant Hiscook John, junior husbandman 589427 589427 Hiscook, John, junior, of Alyngton, husbandman 2
3768621 1947834 1947834 defendant Turenppeny Robert husbandman 589427 589427 Turenppeny, Robert, of Alyngton, husbandman 0
3768622 1947834 1947834 defendant Pateman Richard husbandman 589427 589427 Pateman, Richard, of Alyngton, husbandman 1
3768623 1947834 1947834 defendant Kellome Hugh husbandman 589427 589427 Kellome, Hugh, of Alyngton, husbandman 2
3768624 1947834 1947834 defendant Gunthopr Thomas husbandman 589427 589427 Gunthopr, Thomas, of Alyngton, husbandman 3
3782181 1952179 1952179 defendant Hawen Robert clerk 589427 589427 Hawen, Robert, of Alyngton, clerk 0
3782182 1952179 1952179 defendant Westby John yeoman 589427 589427 Westby, John, of Alyngton, yeoman 1
3782183 1952179 1952179 defendant Seyvell John yeoman 589427 589427 Seyvell, John, of Alyngton, yeoman 2
3788219 1954113 1954113 defendant Crawley Walter husbandman 589427 589427 Crawley, Walter, of Alyngton, husbandman 4
3795217 1956371 1956371 defendant Hayle Guy tanner 589427 589427 Hayle, Guy, of Alyngton, tanner 2
3795218 1956371 1956371 defendant Mumforth William tanner 589427 589427 Mumforth, William, of Alyngton, tanner 3
3821251 1964538 1964538 defendant Baugh Michael husbandman 589427 589427 Baugh, Michael, of Alyngton, husbandman 0
3896268 1988961 1988961 defendant Kelhom Hugh husbandman 589427 589427 Kelhom, Hugh, of Alyngton, husbandman 1
3924065 1998359 1998359 defendant Swanborawe John husbandman 589427 589427 Swanborawe, John, of Alyngton, husbandman 0
4014328 2029849 2029849 defendant Peretre William yeoman 589427 589427 Peretre, William, of Alyngton, yeoman 4
4045952 2040999 2040999 defendant Hartroppe William yeoman 589427 589427 Hartroppe, William, of Alyngton, yeoman 0
4430315 2174266 2174266 defendant Crispyng Robert   589427 589427 Crispyng, Robert, of Alyngton 0
4432599 2174953 2174953 defendant Northdien William   589427 589427 Northdien, William,of Alyngton 13
4436142 2176045 2176045 defendant Doyle William   589427 589427 Doyle, William, of Alyngton 1
4448134 2184336 2184336 defendant Amethull William   589427 589427 Amethull, William, of Alyngton 0
4468427 2190788 2190788 plaintiff Batte William clerk 589427 589427 Batte, William, of Alyngton, clerk 0
4493799 2198754 2198754 defendant Clerk John   589427 589427 Clerk, John, of Alyngton 2
4544956 2214344 2214344 defendant Baudewyne Henry   589427 589427 Baudewyne, Henry, of Alyngton 1
4580047 2225247 2225247 defendant Gerveys John clerk 589427 589427 Gerveys, John, of Alyngton, clerk 0
4594911 2229662 2229662 defendant Bever John   589427 589427 Bever, John, of Alyngton 1
4641602 2243644 2243644 defendant Horton Thomas   589427 589427 Horton, Thomas, of Alyngton 3
4652040 2246572 2246572 defendant Baudewyne John, senior husbandman 589427 589427 Baudewyne, John, senior, of Alyngton, husbandman 0
4652041 2246572 2246572 defendant Baudewyne John, junior husbandman 589427 589427 Baudewyne, John, junior, of Alyngton, husbandman 1
4681921 2259962 2259962 defendant White Robert clerk 589427 589427 White, Robert, of Alyngton, clerk 0
4684443 2260738 2260738 defendant Olyver Richard clerk 589427 589427 Olyver, Richard, of Alyngton, clerk 0
4688881 2262077 2262077 defendant Scorff William yeoman 589427 589427 Scorff, William, of Alyngton, yeoman 0
4690834 2262664 2262664 defendant Prenendre Robert husbandman 589427 589427 Prenendre, Robert, of Alyngton, husbandman 1
4701717 2265932 2265932 defendant Godman John   589427 589427 Godman, John, of Alyngton, plough man 1
4708170 2267933 2267933 defendant Reygate John husbadman 589427 589427 Reygate, John, of Alyngton, husbadman 1
4708172 2267933 2267933 defendant Dyn Thomas laborer 589427 589427 Dyn, Thomas, of Alyngton, laborer 3
4726561 2273584 2273584 defendant Godboy William husbandman 589427 589427 Godboy, William, of Alyngton, husbandman 0
4726562 2273584 2273584 defendant Godboy Thomas husbandman 589427 589427 Godboy, Thomas, of Alyngton, husbandman 1
4726563 2273584 2273584 defendant Rase William husbandman 589427 589427 Rase, William, of Alyngton, husbandman 2
4726564 2273584 2273584 defendant Kirot John husbandman 589427 589427 Kirot, John, of Alyngton, husbandman 3
4726966 2273700 2273700 defendant Gorford John carpenter 589427 589427 Gorford, John, of Alyngton, carpenter 4
4727046 2273722 2273722 defendant Fort Robert yeoman 589427 589427 Fort, Robert, of Alyngton, yeoman 0
4727047 2273722 2273722 defendant Scurth or Smyth William yeoman 589427 589427 Scurth or Smyth, William, of Alyngton, yeoman 1
4727049 2273723 2273723 defendant Fort Robert yeoman 589427 589427 Fort, Robert, of Alyngton, yeoman 0
4727050 2273723 2273723 defendant Scurth William yeoman 589427 589427 Scurth, William, of Alyngton, yeoman 1
4734595 2275984 2275984 defendant Qweymond Robert yeoman 589427 589427 Qweymond, Robert, of Alyngton, yeoman 0
4739121 2277326 2277326 defendant Bernesey William husbandman 589427 589427 Bernesey, William, of Alyngton, husbandman 0
4748881 2280163 2280163 defendant Shepherde Hugh   589427 589427 Shepherde, Hugh, of Alyngton, shepherd 0
4749758 2280408 2280408 defendant Bever John husbandman 589427 589427 Bever, John, of Alyngton, husbandman 0
4750713 2280694 2280694 defendant Scurf William   589427 589427 Scurf, William, of Alyngton, bailiff 2
4751498 2280921 2280921 defendant Wodecok Richard husbandman 589427 589427 Wodecok, Richard, of Alyngton, husbandman 1
4805913 2298058 2298058 defendant Mey John tanner 589427 589427 Mey, John, of Alyngton, tanner 0
4808733 2298898 2298898 defendant Godman John   589427 589427 Godman, John, of Alyngton, franklin 2
4818125 2301743 2301743 defendant Rase William husbandman 589427 589427 Rase, William, of Alyngton, husbandman 4
4830624 2305601 2305601 plaintiff Bokeland John (legal representative) 589427 589427 Bokeland, John, of Alyngton, parson of All Saints church, executors of 0
4830644 2305607 2305607 plaintiff Bokland alias Stoke John (legal representative) 589427 589427 Bokland alias Stoke, John, of Alyngton, parson of All Saints church, executors of 0
4834399 2306765 2306765 defendant Provender John gent 589427 589427 Provender, John, of Alyngton, gent 0
4835304 2307041 2307041 defendant Webbe John husbandman 589427 589427 Webbe, John, of Alyngton, husbandman 0
4835305 2307041 2307041 defendant Yve John laborer 589427 589427 Yve, John, of Alyngton, laborer 1
4843055 2309361 2309361 defendant Bartelot William husbandman 589427 589427 Bartelot, William, of Alyngton, husbandman 0
4843056 2309361 2309361 defendant Holter Thomas husbandman 589427 589427 Holter, Thomas, of Alyngton, husbandman 1
4844516 2309801 2309801 defendant Godbey Thomas husbandman 589427 589427 Godbey, Thomas, of Alyngton, husbandman 0
4844518 2309802 2309802 defendant Whytte Richard   589427 589427 Whytte, Richard, of Alyngton, parson 0
4844520 2309803 2309803 defendant White Richard   589427 589427 White, Richard, of Alyngton 0
4844660 2309847 2309847 defendant White Richard   589427 589427 White, Richard, of Alyngton, parson 0
4857379 2313697 2313697 defendant Rase William husbandman 589427 589427 Rase, William, of Alyngton, husbandman 1
4857380 2313697 2313697 defendant Godeboye John husbandman 589427 589427 Godeboye, John, of Alyngton, husbandman 2
4868620 2317160 2317160 defendant Rase or Rafe William husbandman 589427 589427 Rase or Rafe, William, of Alyngton, husbandman 0
4870909 2317877 2317877 defendant Holter Thomas husbandman 589427 589427 Holter, Thomas, of Alyngton, husbandman 0
4878386 2320188 2320188 defendant Bettes Hugh yeoman 589427 589427 Bettes, Hugh, of Alyngton, yeoman 0
4893043 2324544 2324544 defendant Slye John husbandman 589427 589427 Slye, John, of Alyngton, husbandman 1
4893598 2324699 2324699 defendant Coffyn John esq 589427 589427 Coffyn, John, of Alyngton, esq 0
4900051 2326646 2326646 defendant Skurf William yeoman 589427 589427 Skurf, William, of Alyngton, yeoman 2
4902438 2327375 2327375 defendant Godebay Thomas husbandman 589427 589427 Godebay, Thomas, of Alyngton, husbandman 4
4910860 2329907 2329907 defendant Warner John husbandman 589427 589427 Warner, John, of Alyngton, husbandman 0
5022025 2363335 2363335 defendant Freford Thomas husbandman 589427 589427 Freford, Thomas, of Alyngton, husbandman 3
5040963 2368919 2368919 defendant Vyell Baldwin gent 589427 589427 Vyell, Baldwin, of Alyngton, gent 3
5048235 2371106 2371106 defendant Webbe John husbandman 589427 589427 Webbe, John, of Alyngton, husbandman 1
5095826 2385205 2385205 defendant Wryght John husbandman 589427 589427 Wryght, John, of Alyngton, husbandman 0
5106768 2388406 2388406 defendant Pitte William husbandman 589427 589427 Pitte, William, of Alyngton, husbandman 0
5116635 2391297 2391297 defendant Blakbourne John yeoman 589427 589427 Blakbourne, John, of Alyngton, yeoman 1
5127051 2394388 2394388 defendant Westfeld John husbandman 589427 589427 Westfeld, John, of Alyngton, husbandman 0
5128747 2394892 2394892 defendant Folkerd Thomas   589427 589427 Folkerd, Thomas, of Alyngton 0
5146436 2400089 2400089 defendant Folkard Thomas husbandman 589427 589427 Folkard, Thomas, of Alyngton, husbandman 0
5147936 2400541 2400541 defendant Folkerd Thomas husbandman 589427 589427 Folkerd, Thomas, of Alyngton, 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);