names

162 rows where place_id = 587531

✎ 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
3591676 1865014 1865014 defendant Hunt Henry gent 587531 587531 Hunt, Henry, of Asshewell, Herts, gent 1
3597923 1866973 1866973 defendant Warde William chapman or smith 587531 587531 Warde, William, of Asshewell, Herts, chapman or smith 0
3607466 1869994 1869994 defendant Borell John husbandman 587531 587531 Borell, John, of Asshewell, Herts, husbandman 1
3617880 1873216 1873216 plaintiff Wendy Thomas   587531 587531 Wendy, Thomas, of Asshewell, Herts 1
3709235 1929184 1929184 defendant Smyth William butcher 587531 587531 Smyth, William, of Asshewell, Herts, butcher 2
3718612 1932098 1932098 defendant Blewett Henry husbandman 587531 587531 Blewett, Henry, of Asshewell, Herts, husbandman 1
3737904 1938074 1938074 defendant Byll John draper 587531 587531 Byll, John, of Asshewell, Herts, draper 2
3787034 1953740 1953740 defendant Pynke Thomas draper 587531 587531 Pynke, Thomas, of Asshewell, Herts, draper 1
3816598 1963091 1963091 defendant Smyth William butcher 587531 587531 Smyth, William, of Asshewell, Herts, butcher 0
3832058 1967927 1967927 defendant Wynshyp Richard draper 587531 587531 Wynshyp, Richard, of Asshewell, Herts, draper 0
3836688 1969374 1969374 defendant Wynchepe Richard draper 587531 587531 Wynchepe, Richard, of Asshewell, Herts, draper 0
3878903 1983196 1983196 defendant Ward John chapman 587531 587531 Ward, John, of Asshewell, Herts, chapman 0
3880715 1983815 1983815 defendant Smyth William butcher 587531 587531 Smyth, William, of Asshewell, Herts, butcher 0
3911962 1994326 1994326 defendant Browne Robert husbandman 587531 587531 Browne, Robert, of Asshewell, Herts, husbandman 0
3927867 1999658 1999658 defendant Sawster John gent 587531 587531 Sawster, John, of Asshewell, Herts, gent 0
3932337 2001119 2001119 defendant Orwell James esq 587531 587531 Orwell, James, of Asshewell, Herts, esq 0
3935558 2002203 2002203 plaintiff Lacheworth John yeoman 587531 587531 Lacheworth, John, of Asshewell, Herts, yeoman 0
4001232 2025220 2025220 defendant Barley John yeoman 587531 587531 Barley, John, of Asshewell, Herts, yeoman 0
4001426 2025287 2025287 defendant Halle John maltster 587531 587531 Halle, John, of Asshewell, Herts, yeoman, maltster 1
4030515 2035570 2035570 defendant Biggrave Robert   587531 587531 Biggrave, Robert, of Asshewell, Herts, mason 0
4030572 2035594 2035594 defendant Biggrave Robert   587531 587531 Biggrave, Robert, of Asshewell, Herts, mason 0
4066981 2048487 2048487 defendant Bygrave Robert yeoman 587531 587531 Bygrave, Robert, of Asshewell, Herts, yeoman 1
4089443 2056510 2056510 defendant Sewster Geoffrey gent 587531 587531 Sewster, Geoffrey, of Asshewell, Herts, gent 0
4115378 2065789 2065789 defendant Chapman Thomas mercer 587531 587531 Chapman, Thomas, of Asshewell, Herts, mercer 0
4131650 2071639 2071639 defendant Hardye John yeoman 587531 587531 Hardye, John, of Asshewell, Herts, yeoman 1
4174816 2086660 2086660 defendant Trygge Henry yeoman 587531 587531 Trygge, Henry, of Asshewell, Herts, or of Crisshall, Essex, yeoman 0
4481999 2195076 2195076 defendant Tym Philip   587531 587531 Tym, Philip, of Asshewell, Herts 0
4482001 2195077 2195077 defendant Tym Philip   587531 587531 Tym, Philip, of Asshewell, Herts 0
4598303 2230708 2230708 defendant Bleche John, sen   587531 587531 Bleche, John, sen, of Asshewell, Herts 2
4659646 2248870 2248870 defendant Bonde Robert husbandman 587531 587531 Bonde, Robert, of Asshewell, Herts, husbandman 0
4685672 2261109 2261109 defendant Heuxtwyeth John gent 587531 587531 Heuxtwyeth, John, of Asshewell, Herts, gent 4
4686069 2261232 2261232 defendant Sautre Henry gent 587531 587531 Sautre, Henry, of Asshewell, Herts, gent 0
4688212 2261881 2261881 defendant Porter John chaplain 587531 587531 Porter, John, of Asshewell, Herts, chaplain 0
4694382 2263742 2263742 defendant Bocher Edmund butcher 587531 587531 Bocher, Edmund, of Asshewell, Herts, butcher 1
4715187 2270079 2270079 defendant Draper John yeoman 587531 587531 Draper, John, of Asshewell, Herts, yeoman 0
4734988 2276093 2276093 plaintiff Skynner Robert   587531 587531 Skynner, Robert, of Asshewell, Herts 0
4737701 2276896 2276896 defendant Martyn Thomas yeoman 587531 587531 Martyn, Thomas, of Asshewell, Herts, yeoman 0
4748362 2280027 2280027 defendant Glover Robert glover 587531 587531 Glover, Robert, of Asshewell, Herts, glover 4
4748368 2280028 2280028 defendant Glover Robert glover 587531 587531 Glover, Robert, of Asshewell, Herts, glover 4
4759219 2283227 2283227 defendant Lost William gent 587531 587531 Lost, William, of Asshewell, Herts, gent 0
4759220 2283227 2283227 defendant Chaureth John yeoman 587531 587531 Chaureth, John, of Asshewell, Herts, yeoman 1
4767577 2285840 2285840 defendant Bocher Edmund butcher 587531 587531 Bocher, Edmund, of Asshewell, Herts, butcher 1
4769742 2286507 2286507 defendant Everton William yeoman 587531 587531 Everton, William, of Asshewell, Herts, yeoman 2
4783119 2290736 2290736 defendant Gernon Benedict husbandman 587531 587531 Gernon, Benedict, of Asshewell, Herts, husbandman 2
4792567 2293766 2293766 defendant Chaureth John maltman 587531 587531 Chaureth, John, of Asshewell, Herts, maltman 0
4794265 2294346 2294346 defendant Everton William yeoman 587531 587531 Everton, William, of Asshewell, Herts, yeoman 2
4794583 2294446 2294446 defendant Gernon Benedict husbandman 587531 587531 Gernon, Benedict, of Asshewell, Herts, or of Edworth, Beds, husbandman 0
4796342 2295004 2295004 defendant Everton William yeoman 587531 587531 Everton, William, of Asshewell, Herts, yeoman 0
4798162 2295619 2295619 defendant Everton William husbandman 587531 587531 Everton, William, of Asshewell, Herts, husbandman 0
4801508 2296651 2296651 defendant Everton William yeoman 587531 587531 Everton, William, of Asshewell, Herts, yeoman 0
4804441 2297574 2297574 defendant Botcher Edmund butcher 587531 587531 Botcher, Edmund, of Asshewell, Herts, butcher 0
4816614 2301288 2301288 defendant Sewester John gent 587531 587531 Sewester, John, of Asshewell, Herts, gent 0
4824556 2303730 2303730 defendant Barlee William husbandman 587531 587531 Barlee, William, of Asshewell, Herts, husbandman 1
4836871 2307491 2307491 defendant Asshewell William chapman 587531 587531 Asshewell, William, of Asshewell, Herts, chapman 1
4836877 2307492 2307492 defendant Asshewell William chapman 587531 587531 Asshewell, William, of Asshewell, Herts, chapman 1
4837569 2307684 2307684 defendant Everton William yeoman 587531 587531 Everton, William, of Asshewell, Herts, yeoman 0
4839583 2308299 2308299 defendant Burdon John yeoman 587531 587531 Burdon, John, of Asshewell, Herts, yeoman 3
4852632 2312245 2312245 defendant Everdon William yeoman 587531 587531 Everdon, William, of Asshewell, Herts, yeoman 3
4864125 2315756 2315756 defendant Asshewell William chapman 587531 587531 Asshewell, William, of Asshewell, Herts, chapman 4
4869004 2317279 2317279 defendant atte Well Peter pulter 587531 587531 atte Well, Peter, of Asshewell, Herts, pulter 3
4869423 2317405 2317405 defendant Paton Joan widow 587531 587531 Paton, Joan, of Asshewell, Herts, widow 0
4914546 2331071 2331071 defendant Kirkeby John gent 587531 587531 Kirkeby, John, of Asshewell, Herts, gent 0
4921338 2333185 2333185 defendant Bryd John smith 587531 587531 Bryd, John, of Asshewell, Herts, smith 4
4921344 2333186 2333186 defendant Bryd John smith 587531 587531 Bryd, John, of Asshewell, Herts, smith 4
4924875 2334212 2334212 defendant Herst Thomas barber 587531 587531 Herst, Thomas, of Asshewell, Herts, barber 1
4929543 2335651 2335651 defendant Garle John maltman 587531 587531 Garle, John, of Asshewell, Herts, maltman 1
4940084 2338924 2338924 defendant Bereford alias Clerk Thomas husbandman or hosier 587531 587531 Bereford alias Clerk, Thomas, of Asshewell, Herts, husbandman or hosier 4
4940575 2339078 2339078 defendant Michell John husbandman 587531 587531 Michell, John, of Asshewell, Herts, husbandman 0
4945552 2340587 2340587 defendant Colston John   587531 587531 Colston, John, of Asshewell, Herts, franklin 1
4973046 2348870 2348870 defendant Hurste John barber 587531 587531 Hurste, John, of Asshewell, Herts, barber 0
4974098 2349215 2349215 defendant Walkerne Thomas gent 587531 587531 Walkerne, Thomas, of Asshewell, Herts, gent 2
4978974 2350669 2350669 defendant Michell John husbandman 587531 587531 Michell, John, of Asshewell, Herts, husbandman 0
4988743 2353590 2353590 defendant Borell Henry   587531 587531 Borell, Henry, of Asshewell, Herts, husbandman, son of Thomas 1
5004987 2358355 2358355 defendant Mone William tiler 587531 587531 Mone, William, of Asshewell, Herts, tiler 1
5042703 2369425 2369425 defendant Michell John husbandman 587531 587531 Michell, John, of Asshewell, Herts, husbandman 1
5045513 2370286 2370286 defendant Byll Thomas merchant 587531 587531 Byll, Thomas, of Asshewell, Herts, merchant 2
5069016 2377231 2377231 plaintiff Pylche Thomas   587531 587531 Pylche, Thomas, of Asshewell, Herts 0
5071409 2377944 2377944 defendant Buryell Henry yeoman 587531 587531 Buryell, Henry, of Asshewell, Herts, yeoman 0
5071838 2378071 2378071 defendant Parlet John butcher 587531 587531 (Parlet, John, of Asshewell, Herts, butcher 5
5076582 2379499 2379499 defendant Fuller alias Yape Walter (legal representative) 587531 587531 Fuller alias Yape, Walter, of Asshewell, Herts, executrix of 2
5093158 2384390 2384390 defendant Bill Thomas husbandman 587531 587531 Bill, Thomas, of Asshewell, Herts, husbandman 1
5112037 2389906 2389906 defendant Byrell William yeoman 587531 587531 Byrell, William, of Asshewell, Herts, yeoman 1
5126740 2394297 2394297 defendant Pylche Thomas husbandman 587531 587531 Pylche, Thomas, of Asshewell, Herts, husbandman 0
5137814 2397570 2397570 plaintiff Pylche Thomas   587531 587531 Pylche, Thomas, of Asshewell, Herts 0
5138912 2397880 2397880 defendant Bodell Henry yeoman 587531 587531 Bodell, Henry, of Asshewell, Herts, yeoman 3
5141807 2398719 2398719 defendant Weste John smith 587531 587531 Weste, John, of Asshewell, Herts, smith 1
5141816 2398722 2398722 defendant Weste John smith 587531 587531 Weste, John, of Asshewell, Herts, smith 1
5143835 2399332 2399332 defendant West Thomas smith 587531 587531 West, Thomas, of Asshewell, Herts, smith 2
5143838 2399333 2399333 defendant West Thomas smith 587531 587531 West, Thomas, of Asshewell, Herts, smith 1
5143896 2399354 2399354 defendant Fuller John fuller 587531 587531 Fuller, John, of Asshewell, Herts, fuller 4
5144599 2399578 2399578 defendant Michell John husbandman 587531 587531 Michell, John, of Asshewell, Herts, husbandman 4
5145452 2399813 2399813 defendant Pilche Thomas husbandman 587531 587531 Pilche, Thomas, of Asshewell, Herts, husbandman 0
5159822 2403971 2403971 defendant Borell Henry yeoman 587531 587531 Borell, Henry, of Asshewell, Herts, yeoman 3
5160028 2404034 2404034 defendant Yokflete John draper 587531 587531 Yokflete, John, of Asshewell, Herts, draper 0
5162908 2404874 2404874 defendant West John smith 587531 587531 West, John, of Asshewell, Herts, smith 1
5164937 2405481 2405481 defendant Fuller John fuller 587531 587531 Fuller, John, of Asshewell, Herts, fuller 4
5165375 2405620 2405620 defendant Michell John husbandman 587531 587531 Michell, John, of Asshewell, Herts, husbandman 4
5174771 2408322 2408322 defendant Borell Henry yeoman 587531 587531 Borell, Henry, of Asshewell, Herts, yeoman 3
5182925 2410754 2410754 defendant Lodes William   587531 587531 Lodes, William, of Asshewell, Herts, free mason 3
5190918 2413090 2413090 defendant Borell Henry husbandman 587531 587531 Borell, Henry, of Asshewell, Herts, 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);