names

218 rows where place_id = 587191

✎ 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
3590714 1864737 1864737 defendant Howell William yeoman 587191 587191 Howell, William, of Arundell, yeoman 4
3592131 1865156 1865156 plaintiff Frankeleyn John   587191 587191 Frankeleyn, John, of Arundell 0
3596247 1866453 1866453 defendant Harry John husbandman 587191 587191 Harry, John, of Arundell, husbandman 2
3605211 1869297 1869297 defendant Cleyton Stephen butcher 587191 587191 Cleyton, Stephen, of Arundell, butcher 0
3676348 1918646 1918646 defendant Vyncent William yeoman 587191 587191 Vyncent, William, of Arundell, yeoman 1
3676507 1918696 1918696 defendant Vyncent William yeoman 587191 587191 Vyncent, William, of Arundell, yeoman 0
3706536 1928328 1928328 defendant Vyncent William yeoman 587191 587191 Vyncent, William, of Arundell, yeoman 1
3725229 1934178 1934178 defendant Cooke Thomas husbandman 587191 587191 Cooke, Thomas, of Arundell, husbandman 0
3725232 1934179 1934179 defendant Cooke Thomas husbandman 587191 587191 Cooke, Thomas, of Arundell, husbandman 0
3745825 1940597 1940597 defendant Crane Thomas yeoman 587191 587191 Crane, Thomas, of Arundell, yeoman 0
3746755 1940900 1940900 defendant Campyon John husbandman 587191 587191 Campyon, John, of Arundell, husbandman 0
3758805 1944742 1944742 defendant Crane Thomas yeoman 587191 587191 Crane, Thomas, of Arundell, yeoman 0
3788073 1954059 1954059 defendant Busby William chaplain 587191 587191 Busby, William, of Arundell, chaplain 3
3850144 1973635 1973635 defendant Towneley Alice widow 587191 587191 Towneley, Alice, of Arundell, widow 3
3855226 1975267 1975267 defendant Symcocke John yeoman 587191 587191 Symcocke, John, of Arundell, yeoman 1
3883407 1984719 1984719 defendant Henynge alias Robert William yeoman 587191 587191 Henynge alias Robert, William, of Arundell, yeoman 0
3913049 1994694 1994694 defendant Frenche Thomas   587191 587191 Frenche, Thomas, of Arundell 1
3928712 1999939 1999939 defendant Wethyer Philip butcher 587191 587191 Wethyer, Philip, of Arundell, butcher 0
3940542 2003848 2003848 defendant Norton John merchant & Burgess 587191 587191 Norton, John, of Arundell, merchant & Burgess 0
3971519 2014599 2014599 defendant Bedowe Nicholas merchant 587191 587191 Bedowe, Nicholas, of Arundell, merchant 0
3971521 2014600 2014600 defendant Bedowe Nicholas merchant 587191 587191 Bedowe, Nicholas, of Arundell, merchant 0
3972960 2015115 2015115 defendant Foster Richard   587191 587191 Foster, Richard, of Arundell, mason 1
3995918 2023293 2023293 defendant Taverner Thomas (legal representative) 587191 587191 Taverner, Thomas, of Arundell, administrator of 0
4041114 2039314 2039314 defendant Platt John glover 587191 587191 Platt, John, of Arundell, glover 2
4077890 2052393 2052393 defendant Blundell William merchant 587191 587191 Blundell, William, of Arundell, merchant 0
4078585 2052642 2052642 defendant Strudwyke Henry yeoman 587191 587191 Strudwyke, Henry, of Arundell, yeoman 0
4080103 2053192 2053192 defendant Blundell William merchant 587191 587191 Blundell, William, of Arundell, merchant 0
4099332 2060085 2060085 defendant Bever John glover 587191 587191 Bever, John, of Arundell, glover 0
4107823 2063074 2063074 defendant Shepperd Edmund yeoman 587191 587191 Shepperd, Edmund, of Arundell, yeoman 1
4138310 2074068 2074068 defendant Gravesend John   587191 587191 Gravesend, John, of Arundell, sailor 0
4244112 2111015 2111015 defendant Lypryde Robert carpenter 587191 587191 Lypryde, Robert, of Arundell, carpenter 0
4361699 2151341 2151341 defendant Holland James beer brewer 587191 587191 Holland, James, of Arundell, or of Steninge, beer brewer 0
4362126 2151499 2151499 defendant Wagland Richard beer brewer 587191 587191 Wagland, Richard, of Arundell, yeoman, beer brewer 0
4371792 2154971 2154971 defendant Palmer Thomas gent 587191 587191 (Palmer, Thomas, of Arundell, gent 2
4377165 2156906 2156906 defendant Farneley William carpenter 587191 587191 Farneley, William, of Arundell, yeoman, carpenter 2
4412129 2168649 2168649 defendant Holland James mercer 587191 587191 Holland, James, of Arundell, or of Steninge, mercer 0
4415071 2169613 2169613 plaintiff Gate Henry de   587191 587191 Gate, Henry de, of Arundell 0
4417787 2170440 2170440 defendant Gate Henry de   587191 587191 Gate, Henry de, of Arundell 0
4423129 2172090 2172090 plaintiff Gate Henry de   587191 587191 Gate, Henry de, of Arundell 0
4471067 2191608 2191608 defendant Sparowe John   587191 587191 Sparowe, John, of Arundell 0
4487518 2196813 2196813 plaintiff Smyth Robert   587191 587191 Smyth, Robert, of Arundell 0
4495077 2199147 2199147 defendant Bern Thomas   587191 587191 Bern, Thomas, of Arundell 1
4508944 2203275 2203275 defendant Sparowe John   587191 587191 Sparowe, John, of Arundell 0
4509224 2203364 2203364 plaintiff atte Berne Thomas   587191 587191 atte Berne, Thomas, of Arundell 0
4509226 2203364 2203364 defendant Russell John   587191 587191 Russell, John, of Arundell 1
4528044 2209053 2209053 defendant Cook John   587191 587191 Cook, John, of Arundell 2
4572971 2223084 2223084 defendant Douns William smith 587191 587191 Douns, William, of Arundell, smith 0
4575519 2223851 2223851 defendant Leukenore John   587191 587191 Leukenore, John, of Arundell 0
4592743 2229071 2229071 defendant Legemore John   587191 587191 Legemore, John, of Arundell 1
4592750 2229072 2229072 defendant Legennore John   587191 587191 Legennore, John, of Arundell 1
4603045 2232164 2232164 plaintiff Whyte William clerk & master of Holy Trinity college 587191 587191 Whyte, William, of Arundell, clerk & master of Holy Trinity college 0
4603048 2232165 2232165 plaintiff Whyte William master of Holy Trinity college 587191 587191 Whyte, William, of Arundell, master of Holy Trinity college 0
4610064 2234233 2234233 defendant Pacchyng John   587191 587191 Pacchyng, John, of Arundell 0
4610803 2234450 2234450 plaintiff Chapman William   587191 587191 Chapman, William, of Arundell 0
4618711 2236861 2236861 defendant Fissher William   587191 587191 Fissher, William, of Arundell 0
4629231 2240076 2240076 plaintiff Smyth Richard   587191 587191 Smyth, Richard, of Arundell 0
4643807 2244284 2244284 defendant Fysshere William   587191 587191 Fysshere, William, of Arundell 2
4645814 2244843 2244843 defendant Heywod William weaver 587191 587191 Heywod, William, of Arundell, weaver 0
4647748 2245401 2245401 plaintiff Smyth Richard   587191 587191 Smyth, Richard, of Arundell 0
4666280 2250925 2250925 defendant Reynold Thomas butcher 587191 587191 Reynold, Thomas, of Arundell, butcher 0
4670750 2256528 2256528 defendant North Isabel widow 587191 587191 North, Isabel, of Arundell, widow 3
4671740 2256805 2256805 plaintiff Chapman William   587191 587191 Chapman, William, of Arundell 0
4676298 2258198 2258198 defendant Fissher William husbandman 587191 587191 Fissher, William, of Arundell, husbandman 3
4679157 2259090 2259090 defendant Pursull Thomas hosteler 587191 587191 Pursull, Thomas, of Arundell, hosteler 1
4685021 2260912 2260912 defendant Trot William   587191 587191 Trot, William, of Arundell, notary 0
4692140 2263071 2263071 defendant Warre William esq 587191 587191 Warre, William, of Arundell, esq 0
4694433 2263755 2263755 defendant Warnecamp William fisher man 587191 587191 Warnecamp, William, of Arundell, fisher man 3
4694440 2263755 2263755 defendant Danvere John fisherman 587191 587191 Danvere, John, of Arundell, fisherman 10
4709947 2268468 2268468 defendant Wiltshire John   587191 587191 Wiltshire, John, of Arundell, knight 2
4709950 2268469 2268469 defendant Short Nicholas yeoman 587191 587191 Short, Nicholas, of Arundell, yeoman 0
4709954 2268469 2268469 defendant Wiltshire John   587191 587191 Wiltshire, John, of Arundell, knight 4
4711380 2268892 2268892 defendant Trot William husbandman 587191 587191 Trot, William, of Arundell, husbandman 0
4715028 2270027 2270027 defendant Okherst William gent 587191 587191 Okherst, William, of Arundell, gent 8
4715671 2270228 2270228 defendant White William master of the New College 587191 587191 White, William, of Arundell, master of the New College 0
4721696 2272121 2272121 defendant North Isabel widow 587191 587191 North, Isabel, of Arundell, widow 0
4734221 2275882 2275882 defendant Yonge Robert butcher 587191 587191 Yonge, Robert, of Arundell, butcher 3
4739964 2277577 2277577 defendant Warre William gent 587191 587191 Warre, William, of Arundell, gent 0
4744375 2278879 2278879 defendant Hendyman Richard gent 587191 587191 Hendyman, Richard, of Arundell, gent 0
4754724 2281861 2281861 defendant Catour Thomas baker 587191 587191 Catour, Thomas, of Arundell, baker 0
4759022 2283173 2283173 defendant Pedelyn John butcher 587191 587191 Pedelyn, John, of Arundell, butcher 0
4767686 2285872 2285872 defendant Capelayn Richard carpenter 587191 587191 Capelayn, Richard, of Arundell, carpenter 1
4775048 2288190 2288190 defendant Aune Richard   587191 587191 Aune, Richard, of Arundell 4
4775049 2288190 2288190 defendant Abbot Robert   587191 587191 Abbot, Robert, of Arundell 5
4775050 2288190 2288190 defendant Sadeler Robert   587191 587191 Sadeler, Robert, of Arundell 6
4775051 2288190 2288190 defendant North John   587191 587191 North, John, of Arundell 7
4776976 2288781 2288781 defendant Gerveys John husbandman 587191 587191 together with Gerveys, John, of Arundell, husbandman 2
4776987 2288783 2288783 defendant Gerveys John husbandman 587191 587191 Gerveys, John, of Arundell, husbandman 6
4783042 2290714 2290714 defendant Roulond Richard laborer 587191 587191 Roulond, Richard, of Arundell, laborer 1
4786890 2291960 2291960 defendant Kyng Thomas yeoman 587191 587191 Kyng, Thomas, of Arundell, yeoman 1
4788190 2292378 2292378 defendant Hawekyn Joan widow 587191 587191 Hawekyn, Joan, of Arundell, widow 0
4789533 2292798 2292798 plaintiff Hylle John   587191 587191 Hylle, John, of Arundell 0
4794488 2294414 2294414 defendant Burnell John gent 587191 587191 Burnell, John, of Arundell, gent 0
4794490 2294415 2294415 defendant Burnell John gent 587191 587191 Burnell, John, of Arundell, gent 0
4807639 2298580 2298580 plaintiff Colmorde John Master of Holy Trinity College 587191 587191 Colmorde, John, of Arundell, Master of Holy Trinity College 0
4840003 2308422 2308422 defendant atte Welle William husbandman 587191 587191 atte Welle, William, of Arundell, husbandman 0
4844049 2309648 2309648 defendant Cobehay John husbandman 587191 587191 Cobehay, John, of Arundell, husbandman 0
4850998 2311760 2311760 defendant Warnecamp William gent 587191 587191 Warnecamp, William, of Arundell, gent 0
4851294 2311852 2311852 defendant Colmorde John master of Holy Trinity College 587191 587191 Colmorde, John, of Arundell, master of Holy Trinity College 0
4855501 2313081 2313081 defendant Bocher Peter butcher 587191 587191 Bocher, Peter, of Arundell, butcher 3
4855502 2313081 2313081 defendant Pedelyn John butcher 587191 587191 Pedelyn, John, of Arundell, butcher 4

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