names

110 rows where place_id = 587709

✎ 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
3592194 1865176 1865176 defendant Fryshney Lawrence yeoman 587709 587709 Fryshney, Lawrence, of Gayton, yeoman 5
3596481 1866529 1866529 defendant Creton Thomas husbandman 587709 587709 Creton, Thomas, of Gayton, husbandman 0
3596482 1866529 1866529 defendant Chapman Thomas husbandman 587709 587709 Chapman, Thomas, of Gayton, husbandman 1
3596483 1866529 1866529 defendant Fernour Thomas husbandman 587709 587709 Fernour, Thomas, of Gayton, husbandman 2
3630716 1904433 1904433 defendant Smyth Thomas husbandman 587709 587709 Smyth, Thomas, of Gayton, husbandman 0
3630717 1904433 1904433 defendant Shepherd Hugh husbandman 587709 587709 Shepherd, Hugh, of Gayton, husbandman 1
3630718 1904433 1904433 defendant Mayew Henry husbandman 587709 587709 Mayew Henry, of Gayton, husbandman 2
3630719 1904433 1904433 defendant Maxne or Maxue Robert husbandman 587709 587709 Maxne or Maxue, Robert, of Gayton, husbandman 3
3666096 1915340 1915340 defendant Foyster Robert tailor 587709 587709 Foyster, Robert, of Gayton, tailor 0
3716360 1931410 1931410 plaintiff Cobbe William gent 587709 587709 Cobbe, William, of Gayton, gent 0
3716361 1931410 1931410 defendant Howsold William husbandman 587709 587709 Howsold, William, of Gayton, husbandman 0
3716364 1931411 1931411 plaintiff Cobbe William gent 587709 587709 Cobbe, William, of Gayton, gent 0
3716365 1931411 1931411 defendant Howsold William husbandman 587709 587709 Howsold, William, of Gayton, husbandman 0
3718734 1932137 1932137 defendant Howsold William husbandman 587709 587709 Howsold, William, of Gayton, husbandman 0
3721334 1932980 1932980 defendant Smyth Thomas husbandman 587709 587709 Smyth, Thomas, of Gayton, husbandman 0
3727414 1934846 1934846 defendant Tomkyns Richard husbandman 587709 587709 Tomkyns, Richard, of Gayton, husbandman 0
3754448 1943349 1943349 plaintiff Thorysby Thomas esq 587709 587709 Thorysby, Thomas, of Gayton, esq 0
3773729 1949500 1949500 defendant Rolffe Thomas husbandman 587709 587709 Rolffe, Thomas, of Gayton, husbandman 0
3802580 1958701 1958701 defendant Diconson Richard yeoman 587709 587709 Diconson, Richard, of Gayton, yeoman 0
3803528 1959010 1959010 defendant Baront Simon husbandman 587709 587709 Baront, Simon, of Gayton, husbandman 0
3803550 1959017 1959017 defendant Tesdell Ambrose clerk 587709 587709 Tesdell, Ambrose, of Gayton, clerk 0
3852901 1974521 1974521 defendant Brown Henry husbandman 587709 587709 Brown, Henry, of Gayton, husbandman 2
3928024 1999708 1999708 defendant Palmer John husbandman 587709 587709 Palmer, John, of Gayton, husbandman 11
3949699 2006972 2006972 defendant Erdyswyke John gent 587709 587709 Erdyswyke, John, of Gayton, gent 0
3985667 2019636 2019636 plaintiff Waller Ralph gent 587709 587709 Waller, Ralph, of Gayton, gent 0
4002282 2025599 2025599 defendant Grayson Henry yeoman 587709 587709 Grayson, Henry, of Gayton, yeoman 1
4044236 2040391 2040391 defendant Dicconson Philip yeoman 587709 587709 Dicconson, Philip, of Gayton, yeoman 1
4062473 2046871 2046871 defendant Palmer John husbandman 587709 587709 Palmer, John, of Gayton, husbandman 0
4062474 2046871 2046871 defendant Melton Richard husbandman 587709 587709 Melton, Richard, of Gayton, husbandman 1
4084581 2054762 2054762 defendant Hamlyn Reginald husbandman 587709 587709 Hamlyn, Reginald, of Gayton, husbandman 1
4096799 2059188 2059188 defendant Atterby Thomas husbandman 587709 587709 Atterby, Thomas, of Gayton, husbandman 0
4096800 2059188 2059188 defendant White Edward husbandman 587709 587709 White, Edward, of Gayton, husbandman 1
4118944 2067056 2067056 defendant Leake John carpenter or house wright 587709 587709 Leake, John, of Gayton, carpenter or house wright 0
4125251 2069318 2069318 defendant Thornton Henry yeoman 587709 587709 Thornton, Henry, of Gayton, yeoman 0
4125252 2069318 2069318 defendant Freeston Nicholas yeoman 587709 587709 Freeston, Nicholas, of Gayton, yeoman 1
4149712 2078024 2078024 defendant Dickenson Thomas husbandman 587709 587709 Dickenson, Thomas, of Gayton, husbandman 3
4160246 2081650 2081650 defendant Kay Roger yeoman 587709 587709 Kay, Roger, of Gayton, yeoman 0
4185858 2090548 2090548 defendant Wright John butcher 587709 587709 Wright, John, of Gayton, butcher 1
4205451 2097460 2097460 defendant Cragge Ralph gent 587709 587709 Cragge, Ralph, of Gayton, gent 1
4230150 2106031 2106031 defendant Diconson William husbandman 587709 587709 Diconson, William, of Gayton or of Holton, husbandman 0
4233477 2107225 2107225 defendant Prestwicke John yeoman 587709 587709 Prestwicke, John, of Gayton, yeoman 0
4247130 2112014 2112014 defendant Emerson Thomas yeoman 587709 587709 Emerson, Thomas, of Gayton, yeoman 0
4256522 2115150 2115150 defendant Croswood Robert yeoman 587709 587709 Croswood, Robert, of Gayton, yeoman 1
4256523 2115150 2115150 defendant Dobyson William husbandman 587709 587709 Dobyson, William, of Gayton, husbandman 2
4260542 2116492 2116492 defendant Dyconson John (legal representative) 587709 587709 Dyconson, John, of Gayton, yeoman, executors of 0
4262891 2117256 2117256 defendant Barnarde Abraham butcher 587709 587709 Barnarde, Abraham, of Gayton, butcher 0
4273749 2120764 2120764 defendant Asberey William yeoman 587709 587709 Asberey, William, of Gayton, yeoman 2
4276007 2121556 2121556 defendant Teate Robert husbandman 587709 587709 Teate, Robert, of Gayton, husbandman 2
4276008 2121556 2121556 defendant Armesteade Robert husbandman 587709 587709 Armesteade, Robert, of Gayton, husbandman 3
4283029 2123964 2123964 defendant Sympson Robert yeoman 587709 587709 Sympson, Robert, of Gayton, yeoman 2
4294686 2128186 2128186 defendant Skipwith William husbandman 587709 587709 Skipwith, William, of Gayton, husbandman 1
4297508 2129208 2129208 defendant Lancaster Henry yeoman 587709 587709 Lancaster, Henry, of Gayton, yeoman 0
4300985 2130456 2130456 defendant Kaines   yeoman 587709 587709 Kaines, , of Gayton, yeoman 1
4319434 2136904 2136904 defendant Bate Robert husbandman 587709 587709 Bate, Robert, of Gayton, husbandman 1
4333387 2141449 2141449 defendant Leake William laborer 587709 587709 Leake, William, of Gayton, laborer 1
4341386 2144265 2144265 defendant Sleighe William husbandman 587709 587709 Sleighe, William, of Gayton, husbandman 0
4341525 2144311 2144311 defendant Cawforth James yeoman 587709 587709 Cawforth, James, of Gayton, yeoman 1
4349671 2147150 2147150 defendant Houghton alias Pecoye Clement husbandman 587709 587709 Houghton alias Pecoye, Clement, of Gayton, husbandman 1
4356487 2149498 2149498 defendant Cooke Robert, junior husbandman 587709 587709 Cooke, Robert, junior, of Gayton, husbandman 0
4362670 2151708 2151708 defendant Wilberton Mathew husbandman 587709 587709 Wilberton, Mathew, of Gayton, husbandman 0
4367040 2153266 2153266 defendant Franscis George yeoman 587709 587709 Franscis, George, of Gayton, yeoman 2
4379324 2157686 2157686 defendant Laynes Alan yeoman 587709 587709 Laynes, Alan, of Gayton, yeoman 1
4384697 2159567 2159567 defendant Dallyson Richard   587709 587709 Dallyson, Richard, of Gayton, shepherd 0
4384698 2159567 2159567 defendant Greene Henry   587709 587709 Greene, Henry, of Gayton, shepherd 1
4543959 2214018 2214018 plaintiff Bakester Robert (legal representative) 587709 587709 Bakester, Robert, of Gayton, executors of 0
4543961 2214018 2214018 plaintiff Bakester John brother of Robert 587709 587709 Bakester, John, of Gayton, brother of Robert 2
4579076 2224936 2224936 defendant Pakeman Thomas   587709 587709 Pakeman, Thomas, of Gayton 1
4609118 2233958 2233958 plaintiff Broughton Hugh   587709 587709 Broughton, Hugh, of Gayton, parson 0
4653117 2246911 2246911 defendant Chercheyerd John   587709 587709 Chercheyerd, John, of Gayton, shepherd 0
4666105 2250865 2250865 plaintiff Hunte William   587709 587709 Hunte, William, of Gayton 0
4666106 2250865 2250865 defendant Lambard John husbandman 587709 587709 Lambard, John, of Gayton, husbandman 0
4673994 2257482 2257482 defendant Rome Thomas   587709 587709 Rome, Thomas, of Gayton, parson 1
4711873 2269044 2269044 defendant Trenewyth Nicholas husbandman 587709 587709 Trenewyth, Nicholas, of Gayton, husbandman 2
4730759 2274821 2274821 defendant Walssheman John yeoman 587709 587709 Walssheman, John, of Gayton, yeoman 2
4730760 2274821 2274821 defendant Peyntour John yeoman 587709 587709 Peyntour, John, of Gayton, yeoman 3
4786772 2291917 2291917 defendant Skot Robert husbandman 587709 587709 Skot, Robert, of Gayton, husbandman 1
4820311 2302423 2302423 defendant Britche William husbandman 587709 587709 Britche, William, of Gayton, husbandman 0
4838108 2307843 2307843 plaintiff Gentill John (legal representative) 587709 587709 Gentill, John, of Gayton, executors of 0
4838111 2307843 2307843 plaintiff Kyngson John   587709 587709 Kyngson, John, of Gayton 3
4838114 2307844 2307844 plaintiff Gentyll John (legal representative) 587709 587709 Gentyll, John, of Gayton, executors of 0
4838117 2307844 2307844 plaintiff Kyngston John   587709 587709 Kyngston, John, of Gayton 3
4853628 2312552 2312552 plaintiff (not given) Richard rector of Wryght 587709 587709 Wryght, Richard, of Gayton, rector of the church 0
4853632 2312553 2312553 plaintiff (not given) Richard rector of Wryght 587709 587709 Wryght, Richard, of Gayton, rector of the church 0
4860878 2314757 2314757 defendant Bailly William husbandman 587709 587709 Bailly, William, of Gayton, husbandman 1
4862850 2315364 2315364 defendant Farman Richard clerk 587709 587709 Farman, Richard, of Gayton, clerk 4
4884560 2322078 2322078 defendant Trussell Margaret   587709 587709 Trussell, Margaret, of Gayton, widow of Trussell, John, knight 0
4887933 2323035 2323035 plaintiff Kyngson John   587709 587709 Kyngson, John, of Gayton 1
4900189 2326685 2326685 defendant Trussell Margaret   587709 587709 Trussell, Margaret, of Gayton, widow of Trussell, John, knight 0
4915969 2331492 2331492 plaintiff Kengson John   587709 587709 Kengson, John, of Gayton 1
4966421 2346888 2346888 defendant Pakeman John husbandman 587709 587709 Pakeman, John, of Gayton, husbandman 0
4979801 2350915 2350915 plaintiff Skypwyth William   587709 587709 Skypwyth, William, of Gayton 0
5003755 2357990 2357990 defendant Knout Peter   587709 587709 Knout, Peter, of Gayton, vicar 0
5003756 2357990 2357990 defendant Bey Geoffrey husbandman 587709 587709 Bey, Geoffrey, of Gayton, husbandman 1
5019951 2362716 2362716 defendant Pakeman John, senior husbandman 587709 587709 Pakeman, John, senior, of Gayton, husbandman 0
5030273 2365722 2365722 defendant Gay Richard carpenter 587709 587709 Gay, Richard, of Gayton, carpenter 0
5069716 2377440 2377440 defendant Austyn William gent 587709 587709 Austyn, William, of Gayton, gent 4
5069722 2377441 2377441 defendant Austyn William gent 587709 587709 Austyn, William, of Gayton, gent 4
5087488 2382719 2382719 defendant Smyth John husbandman 587709 587709 Smyth, John, of Gayton, husbandman 0
5098947 2386122 2386122 defendant Diconson William husbandman 587709 587709 Diconson, William, of Gayton, husbandman 1
5199908 2415725 2415725 defendant Smyth Roger husbandman 587709 587709 Smyth, Roger, of Gayton, 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);