names

155 rows where place_id = 586098

✎ 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
3587939 1863879 1863879 defendant Starkewedyr Roger husbandman 586098 586098 Starkewedyr, Roger, of Snape, husbandman 0
3612247 1871465 1871465 defendant Lane Nicholas yeoman 586098 586098 Lane, Nicholas, of Snape, yeoman 0
3680730 1920053 1920053 defendant Wellys Reginald chaplain 586098 586098 Wellys, Reginald, of Snape, chaplain 0
3681653 1920357 1920357 plaintiff Snath alias Cooke John   586098 586098 Snath alias Cooke, John, of Snape 0
3698393 1925718 1925718 defendant Redberd John tailor 586098 586098 Redberd, John, of Snape, tailor 3
3708305 1928891 1928891 plaintiff Nevile John   586098 586098 Nevile, John, of Snape 0
3708307 1928892 1928892 plaintiff Nevile John   586098 586098 Nevile, John, of Snape, knight 0
3708309 1928893 1928893 plaintiff Nevile John   586098 586098 Nevile, John, of Snape, knight 0
3712960 1930377 1930377 defendant Snayth John   586098 586098 Snayth, John, of Snape, yeoman, bailiff of Heversham 0
3739137 1938449 1938449 defendant Palmer Henry yeoman 586098 586098 Palmer, Henry, of Snape, yeoman 0
3743826 1939955 1939955 defendant Hunt Richard yeoman 586098 586098 Hunt, Richard, of Snape, yeoman 0
3785287 1953186 1953186 defendant Crosby Lawrence yeoman 586098 586098 Crosby, Lawrence, of Snape, yeoman 0
3785295 1953188 1953188 plaintiff Nevile John   586098 586098 Nevile, John, of Snape, knight 0
3887258 1986004 1986004 defendant Style John laborer 586098 586098 Style, John, of Snape, laborer 2
3932120 2001047 2001047 plaintiff Fawconer John (legal representative) 586098 586098 Fawconer, John, of Snape, administrator of 0
3942223 2004415 2004415 defendant Blanchard Robert   586098 586098 Blanchard, Robert, of Snape, shoe maker 3
3951847 2007706 2007706 defendant Kayes alias Bryckman Francis husbandman 586098 586098 (Kayes alias Bryckman, Francis, of Snape, husbandman 1
3986522 2019921 2019921 defendant Palmer Thomas yeoman 586098 586098 Palmer, Thomas, of Snape, yeoman 0
4009477 2028156 2028156 defendant Smarthwayte John yeoman 586098 586098 Smarthwayte, John, of Snape, yeoman 5
4010056 2028362 2028362 defendant Broun William husbandman 586098 586098 Broun, William, of Snape, husbandman 0
4035445 2037347 2037347 defendant Jacobe alias Bradley Robert innholder 586098 586098 Jacobe alias Bradley, Robert, of Snape, innholder 0
4092010 2057436 2057436 defendant Fryar John yeoman 586098 586098 Fryar, John, of Snape, yeoman 1
4092011 2057436 2057436 defendant Hill William yeoman 586098 586098 Hill, William, of Snape, yeoman 2
4092012 2057436 2057436 defendant Cooke Julia spinster 586098 586098 Cooke, Julia, of Snape, spinster 3
4114548 2065492 2065492 defendant Thackwraye Thomas yeoman 586098 586098 Thackwraye, Thomas, of Snape, yeoman 1
4124642 2069110 2069110 defendant Maye Mathew   586098 586098 Maye, Mathew, of Snape, twill weaver 1
4172805 2085945 2085945 defendant Maye Mathew   586098 586098 Maye, Mathew, of Snape, twill weaver 0
4172806 2085945 2085945 defendant Maye Robert   586098 586098 Maye, Robert, of Snape, twill weaver 1
4175596 2086933 2086933 defendant Wright Daniel tailor 586098 586098 Wright, Daniel, of Snape, tailor 3
4195674 2094042 2094042 defendant Dux William innholder 586098 586098 Dux, William, of Snape, innholder 0
4198087 2094878 2094878 defendant Wright James yeoman 586098 586098 Wright, James, of Snape, yeoman 0
4220035 2102507 2102507 defendant Jeffrysson John yeoman 586098 586098 Jeffrysson, John, of Snape, yeoman 1
4233105 2107086 2107086 defendant Seare Thomas husbandman 586098 586098 Seare, Thomas, of Snape, husbandman 0
4238945 2109240 2109240 defendant Lingwood Anthony gent 586098 586098 Lingwood, Anthony, of Snape, gent 1
4248523 2112494 2112494 defendant Corboulde John yeoman 586098 586098 Corboulde, John, of Snape, yeoman 1
4258929 2115958 2115958 defendant Venables James clerk 586098 586098 Venables, James, of Snape, clerk 0
4276474 2121714 2121714 defendant Lawrence William clerk 586098 586098 Lawrence, William, of Snape, or of Ellingham, Norf, clerk 3
4276842 2121829 2121829 defendant Lawrence William clerk 586098 586098 Lawrence, William, of Snape, clerk 0
4276843 2121829 2121829 defendant Jefferson John yeoman 586098 586098 Jefferson, John, of Snape, yeoman 1
4301324 2130583 2130583 defendant Jefferson John yeoman 586098 586098 Jefferson, John, of Snape, yeoman 1
4325088 2138774 2138774 defendant Jefferson John yeoman 586098 586098 Jefferson, John, of Snape, yeoman 0
4327317 2139460 2139460 defendant Newson Richard husbandman 586098 586098 Newson, Richard, of Snape, husbandman 0
4327807 2139623 2139623 defendant Knappett John husbandman 586098 586098 Knappett, John, of Snape, husbandman 3
4336675 2142555 2142555 defendant Holdinge Ralph bricklayer 586098 586098 Holdinge, Ralph, of Snape, or of Henhall, bricklayer 2
4339763 2143678 2143678 defendant Corbold John husbandman 586098 586098 Corbold, John, of Snape, husbandman 3
4344482 2145349 2145349 defendant Lawrence William clerk 586098 586098 Lawrence, William, of Snape, clerk 0
4379353 2157698 2157698 defendant Jeffersone John tailor 586098 586098 Jeffersone, John, of Snape, yeoman, or of Farmham, tailor 0
4385779 2159935 2159935 defendant Lawrence William clerk 586098 586098 Lawrence, William, of Snape, or of Froston, clerk 0
4385780 2159935 2159935 defendant Fletcher Robert yeoman 586098 586098 Fletcher, Robert, of Snape, yeoman 1
4398567 2164101 2164101 defendant Jeffersone John yeoman 586098 586098 Jeffersone, John, of Snape, yeoman 0
4403427 2165715 2165715 defendant Lawrence William clerk 586098 586098 Lawrence, William, of Snape, clerk 0
4403513 2165747 2165747 defendant Llud Francis miller 586098 586098 Llud, Francis, of Snape, miller 0
4403514 2165747 2165747 defendant Chapham John husbandman 586098 586098 Chapham, John, of Snape, husbandman 1
4404022 2165916 2165916 defendant Fleamynge George yeoman 586098 586098 Fleamynge, George, of Snape, yeoman 0
4404023 2165916 2165916 defendant Fleamynge Edmund yeoman 586098 586098 Fleamynge, Edmund, of Snape, yeoman 1
4410649 2168153 2168153 defendant Fleminge George yeoman 586098 586098 Fleminge, George, of Snape, yeoman 0
4418313 2170610 2170610 defendant Thyngelove Walter   586098 586098 Thyngelove, Walter, of Snape 0
4539981 2212773 2212773 defendant Robynson John   586098 586098 Robynson, John, of Snape 0
4571167 2222553 2222553 defendant Milner William   586098 586098 Milner, William, of Snape, formerly miller of Brynyston 2
4582514 2225973 2225973 defendant Taillour Richard dealer 586098 586098 Taillour, Richard, of Snape, dealer 0
4582517 2225974 2225974 defendant Taillour Richard shoemaker 586098 586098 Taillour, Richard, of Snape, shoemaker 0
4602775 2232083 2232083 defendant Hauthorn John de   586098 586098 Hauthorn, John de, of Snape 3
4611822 2234761 2234761 defendant Merly Thomas   586098 586098 Merly, Thomas, of Snape 0
4639583 2243090 2243090 plaintiff Coupere John   586098 586098 Coupere, John, of Snape 0
4664794 2250464 2250464 defendant Hunton Thomas shoemaker 586098 586098 Hunton, Thomas, of Snape, shoemaker 0
4664795 2250464 2250464 defendant Alburgh Robert smith 586098 586098 Alburgh, Robert, of Snape, smith 1
4664796 2250464 2250464 defendant Wrighteson John weaver 586098 586098 Wrighteson, John, of Snape, weaver 2
4664797 2250464 2250464 defendant Forluffe Robert laborer 586098 586098 Forluffe, Robert, of Snape, laborer 3
4664798 2250464 2250464 defendant Totty John laborer 586098 586098 Totty, John, of Snape, laborer 4
4665327 2250644 2250644 defendant Salter John barker 586098 586098 Salter, John, of Snape, barker 0
4682366 2260106 2260106 defendant Oundel Thomas husbandman 586098 586098 Oundel, Thomas, of Snape, husbandman 2
4682367 2260106 2260106 defendant Hunton Thomas shoemaker 586098 586098 Hunton, Thomas, of Snape, shoemaker 3
4685658 2261106 2261106 defendant Huland John   586098 586098 Huland, John, of Snape, wright 1
4713872 2269663 2269663 defendant Gille William laborer 586098 586098 Gille, William, of Snape, laborer 2
4730936 2274874 2274874 plaintiff Mersey John   586098 586098 Mersey, John, of Snape, prior 0
4730937 2274874 2274874 defendant Soutere Richard shoemaker 586098 586098 Soutere, Richard, of Snape, shoemaker 0
4740695 2277797 2277797 defendant Couper John butcher 586098 586098 Couper, John, of Snape, butcher 2
4748702 2280104 2280104 plaintiff Merseye John   586098 586098 Merseye, John, of Snape, prior 0
4749885 2280439 2280439 defendant skeyton John yeoman 586098 586098 skeyton, John, of Snape, yeoman 1
4749886 2280439 2280439 defendant Sweyn William yeoman 586098 586098 Sweyn, William, of Snape, yeoman 2
4752652 2281237 2281237 defendant Rode John husbandman 586098 586098 Rode, John, of Snape, husbandman 1
4774356 2287960 2287960 defendant Hardy Thomas husbandman 586098 586098 Hardy, Thomas, of Snape, husbandman 0
4774357 2287960 2287960 defendant Hardy John husbandman 586098 586098 Hardy, John, of Snape, husbandman 1
4774358 2287960 2287960 defendant Hardy Richard husbandman 586098 586098 Hardy, Richard, of Snape, husbandman 2
4774359 2287960 2287960 defendant Tomson John laborer 586098 586098 together with Tomson, John, of Snape, laborer 3
4810611 2299465 2299465 defendant Beeston William yeoman 586098 586098 Beeston, William, of Snape, yeoman 0
4810612 2299465 2299465 defendant Cundall Thomas tanner 586098 586098 Cundall, Thomas, of Snape, tanner 1
4810613 2299465 2299465 defendant Fell Adam del yeoman 586098 586098 Fell, Adam del, of Snape, yeoman 2
4810625 2299466 2299466 defendant Beeston William yeoman 586098 586098 Beeston, William, of Snape, yeoman 0
4810626 2299466 2299466 defendant Cundall Thomas tanner 586098 586098 Cundall, Thomas, of Snape, tanner 1
4810627 2299466 2299466 defendant Fell Adam del yeoman 586098 586098 Fell, Adam del, of Snape, yeoman 2
4810662 2299469 2299469 defendant Beeston Wiliam yeoman 586098 586098 Beeston, Wiliam, of Snape, yeoman 0
4810663 2299469 2299469 defendant Cundall Thomas tanner 586098 586098 Cundall, Thomas, of Snape, tanner 1
4810664 2299469 2299469 defendant Fell Adam del yeoman 586098 586098 Fell, Adam del, of Snape, yeoman 2
4810677 2299470 2299470 defendant Beeston Wiliam yeoman 586098 586098 Beeston, Wiliam, of Snape, yeoman 0
4810678 2299470 2299470 defendant Cundall Thomas tanner 586098 586098 Cundall, Thomas, of Snape, tanner 1
4810679 2299470 2299470 defendant Fell Adam del yeoman 586098 586098 Fell, Adam del, of Snape, yeoman 2
4849589 2311346 2311346 defendant Snape John husbandman 586098 586098 Snape, John, of Snape, husbandman 0
4888589 2323231 2323231 defendant Beeston William yeoman 586098 586098 Beeston, William, of Snape, yeoman 0
4888590 2323231 2323231 defendant Cundall Thomas barker 586098 586098 Cundall, Thomas, of Snape, barker 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);