names

109 rows where place_id = 593778

✎ 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
3613267 1871802 1871802 defendant Norres John husbandman 593778 593778 Norres, John, of Ledys, husbandman 0
3613269 1871802 1871802 defendant Sydale Thomas weaver 593778 593778 Sydale, Thomas, of Ledys, weaver 2
3620196 1873894 1873894 defendant Otys George chapman 593778 593778 Otys, George, of Ledys, chapman 0
3632594 1905013 1905013 defendant Welles William yeoman 593778 593778 Welles, William, of Ledys, yeoman 0
3633774 1905377 1905377 defendant Sergeantson William merchant 593778 593778 Sergeantson, William, of Ledys, merchant 0
3669455 1916384 1916384 defendant Reme John laborer 593778 593778 Reme, John, of Ledys, laborer 0
3669498 1916398 1916398 defendant Kyllyngbek Francis husbandman 593778 593778 Kyllyngbek, Francis, of Ledys, husbandman 1
3673388 1917697 1917697 defendant Redshay Ralph weaver 593778 593778 Redshay, Ralph, of Ledys, weaver 0
3680170 1919869 1919869 defendant Harryson Richard laborer 593778 593778 Harryson, Richard, of Ledys, laborer 0
3687094 1922134 1922134 defendant Smyth Richard butcher 593778 593778 Smyth, Richard, of Ledys, butcher 0
3714055 1930696 1930696 defendant Brame Peter draper 593778 593778 Brame, Peter, of Ledys, draper 0
3715119 1931026 1931026 defendant Rysley alias A Ryeley Thomas clothier 593778 593778 Rysley alias A Ryeley, Thomas, of Ledys, clothier 0
3715120 1931026 1931026 defendant Eton alias Hetton Richard clothier 593778 593778 Eton alias Hetton, Richard, of Ledys, clothier 1
3716588 1931484 1931484 defendant Brig Thomas chaplain 593778 593778 Brig, Thomas, of Ledys, chaplain 1
3723738 1933700 1933700 defendant Dobbys William weaver 593778 593778 Dobbys, William, of Ledys, weaver 0
3726636 1934590 1934590 defendant Rilay Thomas clothier 593778 593778 Rilay, Thomas, of Ledys, clothier 0
3735095 1937218 1937218 defendant Rylay Thomas clothmaker 593778 593778 Rylay, Thomas, of Ledys, clothmaker 0
3735289 1937272 1937272 defendant Tomson James yeoman 593778 593778 Tomson, James, of Ledys, yeoman 2
3737916 1938078 1938078 defendant Pak John carpenter 593778 593778 Pak, John, of Ledys, carpenter 1
3745992 1940652 1940652 defendant Guldeford Henry   593778 593778 Guldeford, Henry, of Ledys, knight 0
3753793 1943127 1943127 defendant Bassok Stephen fuller 593778 593778 Bassok, Stephen, of Ledys, fuller 0
3753959 1943188 1943188 plaintiff Stokedale Geoffrey   593778 593778 Stokedale, Geoffrey, of Ledys 0
3759021 1944808 1944808 defendant Guldeford Henry   593778 593778 Guldeford, Henry, of Ledys, knight 0
3763747 1946307 1946307 defendant Sayer John husbandman 593778 593778 Sayer, John, of Ledys, husbandman 1
3763749 1946307 1946307 defendant Pak Richard chapman 593778 593778 Pak, Richard, of Ledys, chapman 3
3766750 1947261 1947261 defendant Maskall Robert yeoman 593778 593778 Maskall, Robert, of Ledys, yeoman 1
3767130 1947370 1947370 defendant Bell Peter yeoman 593778 593778 Bell, Peter, of Ledys, yeoman 1
3767131 1947370 1947370 defendant Lyndeley Percival yeoman 593778 593778 Lyndeley, Percival, of Ledys, yeoman 2
3772633 1949133 1949133 defendant Pacche Edmund mercer 593778 593778 Pacche, Edmund, of Ledys, mercer 1
3781121 1951831 1951831 defendant Alcoke John clerk 593778 593778 Alcoke, John, of Ledys, clerk 3
3781122 1951831 1951831 defendant Alcoke Thomas clerk 593778 593778 Alcoke, Thomas, of Ledys, clerk 4
3781123 1951831 1951831 defendant Alcoke Ralph yeoman 593778 593778 Alcoke, Ralph, of Ledys, yeoman 5
3783952 1952758 1952758 defendant Arnott John baker 593778 593778 Arnott, John, of Ledys, baker 1
3784472 1952928 1952928 defendant Syllyman Richard weaver 593778 593778 Syllyman, Richard, of Ledys, weaver 0
3784473 1952928 1952928 defendant Syllyman William weaver 593778 593778 Syllyman, William, of Ledys, weaver 1
3784474 1952928 1952928 defendant Smyth Henry chaplain 593778 593778 Smyth, Henry, of Ledys, chaplain 2
3786079 1953437 1953437 defendant Ryley Thomas sherman 593778 593778 Ryley, Thomas, of Ledys, sherman 2
3786080 1953437 1953437 defendant Ellys John weaver 593778 593778 Ellys, John, of Ledys, weaver 3
3786081 1953437 1953437 defendant Marton Henry sherman 593778 593778 Marton, Henry, of Ledys, sherman 4
3791399 1955145 1955145 defendant Bassok Stephen fuller 593778 593778 Bassok, Stephen, of Ledys, fuller 1
3798241 1957347 1957347 defendant Pak John carpenter 593778 593778 Pak, John, of Ledys, carpenter 4
3802423 1958654 1958654 defendant Ellys John weaver 593778 593778 Ellys, John, of Ledys, weaver 4
3803946 1959150 1959150 defendant Smekergyll Christopher clothman 593778 593778 Smekergyll, Christopher, of Ledys, clothman 0
3805011 1959512 1959512 defendant Hoddyswell John yeoman 593778 593778 Hoddyswell, John, of Ledys, yeoman 1
3805021 1959514 1959514 defendant Pattys Edmund yeoman 593778 593778 Pattys, Edmund, of Ledys, yeoman 1
3820022 1964143 1964143 defendant Gyllett William laborer 593778 593778 Gyllett, William, of Ledys, laborer 2
3847975 1972941 1972941 defendant Tomson James yeoman 593778 593778 Tomson, James, of Ledys, yeoman 1
3850406 1973715 1973715 defendant Milngat John husbandman 593778 593778 Milngat, John, of Ledys, husbandman 2
3875632 1982092 1982092 defendant Champnes John shoemaker 593778 593778 Champnes, John, of Ledys, shoemaker 1
3889986 1986886 1986886 defendant Kyllyngbek John yeoman 593778 593778 Kyllyngbek, John, of Ledys, yeoman 0
3891851 1987527 1987527 defendant Wyllyams John sawyer 593778 593778 Wyllyams, John, of Ledys, sawyer 2
4648149 2245519 2245519 defendant Fourneys John   593778 593778 Fourneys, John, of Ledys, bailiff of Skirawe & Morley 2
4745771 2279270 2279270 defendant Rome Peter del gent 593778 593778 Rome, Peter del, of Ledys, gent 1
4806998 2298386 2298386 defendant Hale William husbandman 593778 593778 Hale, William, of Ledys, husbandman 2
4811875 2299826 2299826 defendant Spencer John carpenter 593778 593778 Spencer, John, of Ledys, carpenter 0
4883712 2321817 2321817 defendant Dene Christian husbandman 593778 593778 Dene, Christian, of Ledys, husbandman 1
4961177 2345306 2345306 defendant Burgeys Thomas gent 593778 593778 Burgeys, Thomas, of Ledys, gent 0
4961181 2345307 2345307 defendant Burgeys Thomas gent 593778 593778 Burgeys, Thomas, of Ledys, gent 0
4978268 2350448 2350448 defendant More Richard butcher 593778 593778 More, Richard, of Ledys, butcher 0
4978269 2350448 2350448 defendant Banke Henry yeoman 593778 593778 Banke, Henry, of Ledys, yeoman 1
4978270 2350448 2350448 defendant Menston William yeoman 593778 593778 Menston, William, of Ledys, yeoman 2
4978271 2350448 2350448 defendant Stonele John (legal representative) 593778 593778 Stonele, John, of Ledys, executrix of 3
4978272 2350448 2350448 defendant Stonele Joan widow 593778 593778 Stonele, Joan, of Ledys, widow 4
5058147 2373998 2373998 defendant Grene John butcher 593778 593778 Grene, John, of Ledys, butcher 4
5064450 2375908 2375908 defendant Menston William yeoman 593778 593778 Menston, William, of Ledys, yeoman 0
5068693 2377132 2377132 defendant Grayson Thomas chapman or draper 593778 593778 Grayson, Thomas, of Ledys, chapman or draper 0
5070042 2377533 2377533 defendant Atkynson Robert dyer 593778 593778 Atkynson, Robert, of Ledys, dyer 1
5095008 2384953 2384953 defendant Worchynden Robert cordwainer 593778 593778 Worchynden, Robert, of Ledys, cordwainer 0
5290165 2442127 2442127 defendant Symson Peter yeoman 593778 593778 Symson, Peter, of Ledys, yeoman 1
5329203 2453813 2453813 defendant Pymberton Richard   593778 593778 Pymberton, Richard, of Ledys, parish clerk 0
5379866 2469288 2469288 defendant Emson Thomas yeoman 593778 593778 Emson, Thomas, of Ledys, yeoman 0
5386362 2471166 2471166 defendant Emson Thomas yeoman 593778 593778 Emson, Thomas, of Ledys, yeoman 0
5428857 2483546 2483546 defendant Marchall William yeoman 593778 593778 Marchall, William, of Ledys, yeoman 0
5428858 2483546 2483546 defendant Bryan Richard yeoman 593778 593778 Bryan, Richard, of Ledys, yeoman 1
5490103 2501922 2501922 defendant Emson Thomas   593778 593778 Emson, Thomas, of Ledys, wright 1
5492897 2502786 2502786 defendant Threlsall John yeoman 593778 593778 Threlsall, John, of Ledys, yeoman 0
5498267 2504439 2504439 defendant Fox John laborer 593778 593778 Fox, John, of Ledys, laborer 0
5498268 2504439 2504439 defendant Fox William laborer 593778 593778 Fox, William, of Ledys, laborer 1
5501862 2505508 2505508 defendant Jopson Hugh clothier 593778 593778 Jopson, Hugh, of Ledys, clothier 2
5501868 2505509 2505509 defendant Jopson Hugh clothier 593778 593778 Jopson, Hugh, of Ledys, clothier 1
5503876 2506128 2506128 defendant Dryver William chaplain 593778 593778 Dryver, William, of Ledys, chaplain 0
5505070 2506495 2506495 defendant Bryghton Thomas laborer 593778 593778 Bryghton, Thomas, of Ledys, laborer 0
5505071 2506495 2506495 defendant Bryghton John laborer 593778 593778 Bryghton, John, of Ledys, laborer 1
5519138 2510833 2510833 defendant Arthyngton John tailor 593778 593778 Arthyngton, John, of Ledys, tailor 1
5534458 2515321 2515321 defendant Casewell John laborer 593778 593778 Casewell, John, of Ledys, laborer 2
5537874 2516333 2516333 defendant Pend Thomas yeoman 593778 593778 Pend, Thomas, of Ledys, yeoman 0
5540565 2517177 2517177 defendant Hirst Thomas clothmaker 593778 593778 Hirst, Thomas, of Ledys, clothmaker 0
5547423 2519258 2519258 defendant Franke Robert dyer 593778 593778 Franke, Robert, of Ledys, dyer 0
5547467 2519275 2519275 defendant Franke Robert dyer 593778 593778 Franke, Robert, of Ledys, dyer 0
5555348 2521567 2521567 defendant Francke Robert dyer 593778 593778 Francke, Robert, of Ledys, dyer 0
5561457 2523329 2523329 defendant Middilton James clothman 593778 593778 Middilton, James, of Ledys, clothman 0
5564443 2524221 2524221 defendant Cawdrey Thomas woolman 593778 593778 Cawdrey, Thomas, of Ledys, woolman 1
5565003 2524350 2524350 defendant Lynden Henry clothmaker 593778 593778 Lynden, Henry, of Ledys, clothmaker 3
5572190 2526416 2526416 defendant Leyland John butcher 593778 593778 Leyland, John, of Ledys, butcher 1
5572838 2526607 2526607 defendant Joy Henry yeoman 593778 593778 Joy, Henry, of Ledys, yeoman 1
5574811 2527201 2527201 defendant Lymden Richard yeoman 593778 593778 Lymden, Richard, of Ledys, yeoman 2
5574812 2527201 2527201 defendant Lymden Valentine yeoman 593778 593778 Lymden, Valentine, of Ledys, yeoman 3
5575695 2527486 2527486 defendant Strangwyssh Robert clerk 593778 593778 Strangwyssh, Robert, of Ledys, clerk 1
5586915 2530943 2530943 defendant Wilson William draper 593778 593778 Wilson, William, of Ledys, draper 1
5586916 2530943 2530943 defendant Brame Peter draper 593778 593778 Brame, Peter, of Ledys, draper 2

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