names

135 rows where place_id = 652921

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3926377 1999147 1999147 defendant Newall William gent 652921 652921 Newall, William, of Shrewsbury, Shrops, gent 0
3927091 1999397 1999397 defendant Hoode Richard mercer 652921 652921 Hoode, Richard, of Shrewsbury, Shrops, mercer 0
3930434 2000525 2000525 defendant Haryson Robert mercer 652921 652921 Haryson, Robert, of Shrewsbury, Shrops, mercer 2
3933430 2001472 2001472 defendant Hosyer Edward gent 652921 652921 Hosyer, Edward, of Shrewsbury, Shrops, gent 0
3934506 2001835 2001835 defendant Harryson Robert chapman 652921 652921 Harryson, Robert, of Shrewsbury, Shrops, chapman 2
3935233 2002094 2002094 defendant Beanes Roger chapman & draper 652921 652921 Beanes, Roger, of Shrewsbury, Shrops, chapman & draper 1
3935844 2002298 2002298 defendant Milton Adam   652921 652921 Milton, Adam, of Shrewsbury, Shrops, knight & Town Bailiff 0
3937202 2002774 2002774 defendant Done Thomas draper 652921 652921 Done, Thomas, of Shrewsbury, Shrops, draper 0
3939320 2003457 2003457 defendant Hoode William chapman 652921 652921 Hoode, William, of Shrewsbury, Shrops, chapman 0
4669844 2256267 2256267 defendant Dyer Hugh   652921 652921 Dyer, Hugh, of Shrewsbury, Shrops, dyer, son & heir of James Dyer 4
4671407 2256706 2256706 defendant Forster Roger gent 652921 652921 Forster, Roger, of Shrewsbury, Shrops, gent 0
4673107 2257232 2257232 defendant Hampton John draper 652921 652921 (Hampton, John, of Shrewsbury, Shrops, draper 1
4674908 2257762 2257762 defendant Forster Roger heuster 652921 652921 Forster, Roger, of Shrewsbury, Shrops, heuster 0
4679188 2259099 2259099 defendant Holbach David gent 652921 652921 Holbach, David, of Shrewsbury, Shrops, gent 0
4693438 2263448 2263448 defendant Benteley Richard gent 652921 652921 Benteley, Richard, of Shrewsbury, Shrops, gent 0
4712921 2269353 2269353 defendant Forster Robert hewester 652921 652921 Forster, Robert, of Shrewsbury, Shrops, hewester 0
4718856 2271240 2271240 defendant Benteley Richard gent 652921 652921 Benteley, Richard, of Shrewsbury, Shrops, gent 1
4733575 2275677 2275677 defendant Akton Edward yeoman 652921 652921 Akton, Edward, of Shrewsbury, Shrops, yeoman 0
4733578 2275678 2275678 defendant Alton Edward yeoman 652921 652921 Alton, Edward, of Shrewsbury, Shrops, yeoman 0
4749811 2280419 2280419 defendant Altemere Richard shoemaker 652921 652921 Altemere, Richard, of Shrewsbury, Shrops, shoemaker 1
4765051 2285044 2285044 defendant Peerle John gent 652921 652921 Peerle, John, of Shrewsbury, Shrops, gent 0
4774916 2288149 2288149 defendant Childe William chaplain 652921 652921 Childe, William, of Shrewsbury, Shrops, chaplain 0
4828972 2305105 2305105 defendant Lounde John clerk 652921 652921 Lounde, John, of Shrewsbury, Shrops, clerk 1
4836418 2307365 2307365 defendant Trenche Thomas vintner 652921 652921 Trenche, Thomas, of Shrewsbury, Shrops, vintner 0
4840430 2308545 2308545 defendant Mede Richard dyer 652921 652921 Mede, Richard, of Shrewsbury, Shrops, dyer 2
4840871 2308682 2308682 defendant Atherley Richard ironmonger 652921 652921 Atherley, Richard, of Shrewsbury, Shrops, ironmonger 0
4840920 2308696 2308696 defendant Archerley Richard   652921 652921 Archerley, Richard, of Shrewsbury, Shrops, iron monger 0
4845079 2309977 2309977 defendant Acherle Richard mercer 652921 652921 Acherle, Richard, of Shrewsbury, Shrops, mercer 0
4907806 2329003 2329003 defendant Elsmere Richard heuster 652921 652921 Elsmere, Richard, of Shrewsbury, Shrops, heuster 0
4908587 2329241 2329241 defendant Thornton William taverner 652921 652921 Thornton, William, of Shrewsbury, Shrops, taverner 3
4909879 2329613 2329613 defendant Bentley John merchant 652921 652921 Bentley, John, of Shrewsbury, Shrops, merchant 2
4911259 2330026 2330026 defendant Shorton Nichlas gent 652921 652921 Shorton, Nichlas, of Shrewsbury, Shrops, gent 0
4915668 2331401 2331401 defendant Twyford alias Nowbold John   652921 652921 Twyford alias Nowbold, John, of Shrewsbury, Shrops 2
4918227 2332221 2332221 defendant Shatton John merchant 652921 652921 Shatton, John, of Shrewsbury, Shrops, merchant 0
4918232 2332223 2332223 defendant Hawkyn John (legal representative) 652921 652921 Hawkyn, John, of Shrewsbury, Shrops, executrix of 0
4921049 2333094 2333094 defendant Brygge William draper 652921 652921 Brygge, William, of Shrewsbury, Shrops, draper 2
4921989 2333286 2333286 defendant Alspath Thomas husbandman 652921 652921 Alspath, Thomas, of Shrewsbury, Shrops, husbandman 0
4922840 2333558 2333558 defendant Massefon Richard gent 652921 652921 Massefon, Richard, of Shrewsbury, Shrops, gent 1
4922843 2333559 2333559 defendant Masseson Richard gent 652921 652921 Masseson, Richard, of Shrewsbury, Shrops, gent 1
4925206 2334316 2334316 defendant Heuster Richard heuster or dyer 652921 652921 Heuster, Richard, of Shrewsbury, Shrops, heuster or dyer 0
4925612 2334444 2334444 defendant Glover Philip glover 652921 652921 Glover, Philip, of Shrewsbury, Shrops, glover 0
4926936 2334853 2334853 defendant Gosenhull John sheerman 652921 652921 Gosenhull, John, of Shrewsbury, Shrops, sheerman 1
4930211 2335852 2335852 defendant Phelipp John mercer 652921 652921 Phelipp, John, of Shrewsbury, Shrops, mercer 1
4986430 2352868 2352868 defendant Burley Richard gent 652921 652921 Burley, Richard, of Shrewsbury, Shrops, gent 0
4986432 2352869 2352869 defendant Burley Richard gent 652921 652921 Burley, Richard, of Shrewsbury, Shrops, gent 0
4989969 2353909 2353909 plaintiff Stone Thomas   652921 652921 Stone, Thomas, of Shrewsbury, Shrops 1
5001135 2357209 2357209 defendant Collvall John merchant 652921 652921 Collvall, John, of Shrewsbury, Shrops, merchant 0
5001597 2357360 2357360 defendant Boerley William gent 652921 652921 Boerley, William, of Shrewsbury, Shrops, gent 0
5002716 2357707 2357707 defendant Appulby John mercer 652921 652921 Appulby, John, of Shrewsbury, Shrops, mercer 1
5002722 2357708 2357708 defendant Apulby John mercer 652921 652921 Apulby, John, of Shrewsbury, Shrops, mercer 1
5009128 2359552 2359552 defendant Boraston William gent 652921 652921 Boraston, William, of Shrewsbury, Shrops, gent 1
5047363 2370828 2370828 defendant Bromley Thomas merchant 652921 652921 Bromley, Thomas, of Shrewsbury, Shrops, merchant 4
5048420 2371166 2371166 defendant Lardener John gent 652921 652921 Lardener, John, of Shrewsbury, Shrops, gent 0
5135247 2396807 2396807 defendant Umfroston William chapman 652921 652921 Umfroston, William, of Shrewsbury, Shrops, chapman 3
5138996 2397898 2397898 defendant Pontesbury Roger mercer 652921 652921 Pontesbury, Roger, of Shrewsbury, Shrops, mercer 1
5140277 2398258 2398258 defendant Brymley Thomas merchant 652921 652921 Brymley, Thomas, of Shrewsbury, Shrops, merchant 2
5140938 2398468 2398468 defendant Knyght John merchant 652921 652921 Knyght, John, of Shrewsbury, Shrops, merchant 3
5140944 2398469 2398469 defendant Knyght John merchant 652921 652921 Knyght, John, of Shrewsbury, Shrops, merchant 3
5143188 2399143 2399143 defendant Selke William butcher 652921 652921 Selke, William, of Shrewsbury, Shrops, butcher 2
5143194 2399144 2399144 defendant Selke William butcher 652921 652921 Selke, William, of Shrewsbury, Shrops, butcher 2
5146315 2400051 2400051 defendant Baker Robert tanner 652921 652921 Baker, Robert, of Shrewsbury, Shrops, tanner 0
5155373 2402722 2402722 defendant Umfroston William chapman 652921 652921 Umfroston, William, of Shrewsbury, Shrops, chapman 3
5159542 2403907 2403907 defendant Abylyum Thomas mercer 652921 652921 Abylyum, Thomas, of Shrewsbury, Shrops, mercer 1
5159875 2403984 2403984 defendant Pontesbury Roger mercer 652921 652921 Pontesbury, Roger, of Shrewsbury, Shrops, mercer 1
5162059 2404638 2404638 defendant Knyght John merchant 652921 652921 Knyght, John, of Shrewsbury, Shrops, merchant 3
5162065 2404639 2404639 defendant Knyght John merchant 652921 652921 Knyght, John, of Shrewsbury, Shrops, merchant 3
5170666 2407139 2407139 defendant Sherman Thomas chapman 652921 652921 Sherman, Thomas, of Shrewsbury, Shrops, chapman 1
5172040 2407538 2407538 defendant Umfroston William chapman 652921 652921 Umfroston, William, of Shrewsbury, Shrops, chapman 0
5174860 2408341 2408341 defendant Pontesbury Roger merchant 652921 652921 Pontesbury, Roger, of Shrewsbury, Shrops, merchant 1
5180048 2409900 2409900 defendant Yonge Thomas gent 652921 652921 Yonge, Thomas, of Shrewsbury, Shrops, gent 0
5180704 2410097 2410097 defendant Hervy John brewer 652921 652921 Hervy, John, of Shrewsbury, Shrops, brewer 0
5180707 2410098 2410098 defendant Hervy John brewer 652921 652921 Hervy, John, of Shrewsbury, Shrops, brewer 0
5180710 2410099 2410099 defendant Hervy John brewer 652921 652921 Hervy, John, of Shrewsbury, Shrops, brewer 0
5188456 2412340 2412340 defendant Sherman Thomas chapman 652921 652921 Sherman, Thomas, of Shrewsbury, Shrops, chapman 1
5190547 2412982 2412982 defendant Buttyn David   652921 652921 Buttyn, David, of Shrewsbury, Shrops, Welsh draper 1
5190984 2413108 2413108 defendant Umfroston William chapman 652921 652921 Umfroston, William, of Shrewsbury, Shrops, chapman 0
5195711 2414487 2414487 defendant Pontesbury Roger merchant 652921 652921 Pontesbury, Roger, of Shrewsbury, Shrops, merchant 1
5200719 2415965 2415965 defendant Thornys Thomas gent 652921 652921 Thornys, Thomas, of Shrewsbury, Shrops, gent 0
5200722 2415966 2415966 defendant Thornys Thomas gent 652921 652921 Thornys, Thomas, of Shrewsbury, Shrops, gent 0
5202214 2416410 2416410 defendant Yonge Thomas gent 652921 652921 Yonge, Thomas, of Shrewsbury, Shrops, gent 0
5202533 2416502 2416502 defendant Hervy John brewer 652921 652921 Hervy, John, of Shrewsbury, Shrops, brewer 0
5206994 2417783 2417783 defendant Guttyn David   652921 652921 Guttyn, David, of Shrewsbury, Shrops, welsh draper 1
5206998 2417784 2417784 defendant Guttyn David   652921 652921 Guttyn, David, of Shrewsbury, Shrops, welsh draper 1
5272148 2436937 2436937 defendant (illegible) (illegible)   652921 652921 ----, ----, of Shrewsbury, Shrops, bow maker 0
5273071 2437198 2437198 defendant Horton Roger baker 652921 652921 Horton, Roger, of Shrewsbury, Shrops, baker 3
5273934 2437456 2437456 defendant Pountesbury Roger chapman 652921 652921 Pountesbury, Roger, of Shrewsbury, Shrops, chapman 0
5275692 2437957 2437957 defendant Adys Roger mercer 652921 652921 Adys, Roger, of Shrewsbury, Shrops, mercer 0
5303046 2445902 2445902 defendant Knyght Roger esq 652921 652921 Knyght, Roger, of Shrewsbury, Shrops, esq 1
5303192 2445947 2445947 defendant Abylyon or Avylyon Thomas hosier 652921 652921 Abylyon or Avylyon, Thomas, of Shrewsbury, Shrops, hosier 0
5306433 2446912 2446912 defendant Browenrygge William heuster 652921 652921 Browenrygge, William, of Shrewsbury, Shrops, heuster 0
5309381 2447844 2447844 defendant Mitton Thomas esq 652921 652921 Mitton, Thomas, of Shrewsbury, Shrops, esq 4
5309615 2447915 2447915 defendant Draper Lawrence hosier 652921 652921 Draper, Lawrence, of Shrewsbury, Shrops, hosier 0
5311625 2448499 2448499 defendant Knyght Roger merchant of the Calais Staple 652921 652921 Knyght, Roger, of Shrewsbury, Shrops, merchant of the Calais Staple 1
5365015 2464729 2464729 defendant Adys Roger chapman 652921 652921 Adys, Roger, of Shrewsbury, Shrops, chapman 1
5367530 2465492 2465492 defendant Umfreyston Thomas chapman 652921 652921 Umfreyston, Thomas, of Shrewsbury, Shrops, chapman 0
5389314 2471990 2471990 defendant Philip Mongomery shoemaker 652921 652921 Philip, Mongomery, of Shrewsbury, Shrops, shoemaker 0
5402007 2475636 2475636 defendant Mongomery Philip   652921 652921 Mongomery, Philip, of Shrewsbury, Shrops, shoe maker 0
5413882 2479079 2479079 defendant Bowyer alias Sheter Robert   652921 652921 Bowyer alias Sheter, Robert, of Shrewsbury, Shrops, bow maker 1
5416797 2479939 2479939 defendant Bent William mercer 652921 652921 Bent, William, of Shrewsbury, Shrops, mercer 0
5418433 2480441 2480441 defendant and Glasier John glasier 652921 652921 and Glasier, John, of Shrewsbury, Shrops, glasier 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);