names

84 rows where place_id = 593123

✎ 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
3610584 1870975 1870975 defendant Pele Christopher yeoman 593123 593123 Pele, Christopher, of Hornecastell, yeoman 0
3626201 1903053 1903053 defendant FitzWilliam Thomas gent 593123 593123 FitzWilliam, Thomas, of Hornecastell, gent 0
3635650 1905951 1905951 defendant Barros Ralph yeoman 593123 593123 Barros, Ralph, of Hornecastell, yeoman 2
3637930 1906680 1906680 defendant Darwent James weaver 593123 593123 Darwent, James, of Hornecastell, weaver 0
3640512 1907466 1907466 defendant Whryght Robert yeoman 593123 593123 Whryght, Robert, of Hornecastell, yeoman 2
3693416 1924157 1924157 defendant Barwes Ralph gent 593123 593123 Barwes, Ralph, of Hornecastell, gent 1
3693753 1924241 1924241 defendant Wharff Thomas dyer 593123 593123 Wharff, Thomas, of Hornecastell, dyer 0
3693754 1924241 1924241 defendant Wharff William dyer 593123 593123 Wharff, William, of Hornecastell, dyer 1
3694800 1924579 1924579 defendant Hedlyngton Thomas husbandman 593123 593123 Hedlyngton, Thomas, of Hornecastell, husbandman 0
3707592 1928670 1928670 defendant Barwes Ralph coroner 593123 593123 Barwes, Ralph, of Hornecastell, gent, coroner 0
3724741 1934023 1934023 defendant Wytton Richard dyer 593123 593123 Wytton, Richard, of Hornecastell, dyer 0
3735219 1937251 1937251 defendant Wytton Richard dyer 593123 593123 Wytton, Richard, of Hornecastell, dyer 2
3737862 1938061 1938061 defendant Barwes Ralph gent 593123 593123 Barwes, Ralph, of Hornecastell, gent 0
3739979 1938725 1938725 defendant Brasebryge Robert husbandman 593123 593123 Brasebryge, Robert, of Hornecastell, husbandman 0
3780817 1951737 1951737 defendant Burnns Richard butcher 593123 593123 Burnns, Richard, of Hornecastell, butcher 0
3793897 1955960 1955960 defendant Barrowe Ralph yeoman 593123 593123 Barrowe, Ralph, of Hornecastell, yeoman 0
3793899 1955960 1955960 defendant Maydenwell John pardoner 593123 593123 (Maydenwell, John, of Hornecastell, pardoner 2
3798032 1957283 1957283 defendant Nele Robert shoemaker 593123 593123 Nele, Robert, of Hornecastell, shoemaker 0
3802404 1958651 1958651 defendant Stevynson Thomas yeoman 593123 593123 Stevynson, Thomas, of Hornecastell, yeoman 0
3802405 1958651 1958651 defendant Gybson Robert yeoman 593123 593123 Gybson, Robert, of Hornecastell, yeoman 1
3802406 1958651 1958651 defendant Nele Robert shoemaker 593123 593123 Nele, Robert, of Hornecastell, shoemaker 2
3802407 1958651 1958651 defendant Fox Edmund tailor 593123 593123 Fox, Edmund, of Hornecastell, tailor 3
3802408 1958651 1958651 defendant Newall Roger saddler 593123 593123 Newall, Roger, of Hornecastell, saddler 4
3802409 1958651 1958651 defendant Lovell Robert tailor 593123 593123 Lovell, Robert, of Hornecastell, tailor 5
3802410 1958651 1958651 defendant Forman Robert butcher 593123 593123 Forman, Robert, of Hornecastell, butcher 6
3802411 1958651 1958651 defendant Barker John smith 593123 593123 Barker, John, of Hornecastell, smith 7
3803255 1958922 1958922 defendant Wyberd Hilbert butcher 593123 593123 Wyberd, Hilbert, of Hornecastell, butcher 1
3803256 1958922 1958922 defendant Bracebrige Robert butcher 593123 593123 Bracebrige, Robert, of Hornecastell, butcher 2
3839261 1970207 1970207 defendant Salter James shoemaker 593123 593123 Salter, James, of Hornecastell, shoemaker 3
3852203 1974286 1974286 defendant Neve Roger saddler 593123 593123 Neve, Roger, of Hornecastell, saddler 0
3854285 1974974 1974974 defendant Purrell Thomas draper 593123 593123 Purrell, Thomas, of Hornecastell, draper 1
3872878 1981145 1981145 defendant Couper Edmund sadler 593123 593123 Couper, Edmund, of Hornecastell, sadler 0
3878906 1983197 1983197 defendant Barker John blacksmith 593123 593123 Barker, John, of Hornecastell, blacksmith 0
3878907 1983197 1983197 defendant Long Thomas butcher 593123 593123 Long, Thomas, of Hornecastell, butcher 1
3884209 1984985 1984985 defendant Stephynson Thomas yeoman 593123 593123 Stephynson, Thomas, of Hornecastell, yeoman 2
3884211 1984985 1984985 defendant Reynes Richard yeoman 593123 593123 Reynes, Richard, of Hornecastell, yeoman 4
3984320 2019156 2019156 defendant Jenkenson Peter yeoman 593123 593123 Jenkenson, Peter, of Hornecastell, yeoman 0
3984325 2019157 2019157 defendant Jenkynson Peter yeoman 593123 593123 Jenkynson, Peter, of Hornecastell, yeoman 0
3984556 2019234 2019234 defendant Jenkynson alias Taylor Peter yeoman 593123 593123 Jenkynson alias Taylor, Peter, of Hornecastell, yeoman 0
3984557 2019234 2019234 defendant Praty Anthony yeoman 593123 593123 Praty, Anthony, of Hornecastell, yeoman 1
4002834 2025781 2025781 defendant Chapman James (legal representative) 593123 593123 Chapman, James, of Hornecastell, mercer, administratrix of 0
4004690 2026454 2026454 plaintiff Johnson Gerard butcher 593123 593123 Johnson, Gerard, of Hornecastell, butcher 0
4007164 2027337 2027337 plaintiff Lytlor Thomas gent 593123 593123 Lytlor, Thomas, of Hornecastell, gent 0
4007166 2027338 2027338 plaintiff Lytlor Thomas gent 593123 593123 Lytlor, Thomas, of Hornecastell, gent 0
4047505 2041560 2041560 defendant Salmon Bartholomew yeoman 593123 593123 Salmon, Bartholomew, of Hornecastell, yeoman 1
4047509 2041561 2041561 defendant Salmon Bartholomew yeoman 593123 593123 Salmon, Bartholomew, of Hornecastell, yeoman 1
4056229 2044612 2044612 defendant Shake Robert yeoman 593123 593123 Shake, Robert, of Hornecastell, yeoman 2
4067753 2048777 2048777 plaintiff Johnson Gerard butcher 593123 593123 Johnson, Gerard, of Hornecastell, butcher 0
4095476 2058706 2058706 defendant Palfreyman Thomas yeoman 593123 593123 Palfreyman, Thomas, of Hornecastell, yeoman 1
4095479 2058707 2058707 defendant Palfreman Thomas yeoman 593123 593123 Palfreman, Thomas, of Hornecastell, yeoman 1
4102706 2061265 2061265 defendant Kelke Richard yeoman 593123 593123 Kelke, Richard, of Hornecastell, yeoman 0
4106247 2062524 2062524 defendant Walker John saddler 593123 593123 Walker, John, of Hornecastell, saddler 0
4115280 2065755 2065755 defendant Pachett John tanner 593123 593123 Pachett, John, of Hornecastell, tanner 2
4116964 2066365 2066365 defendant Walker John saddler 593123 593123 Walker, John, of Hornecastell, saddler 0
4132083 2071785 2071785 defendant Clarke Robert yeoman 593123 593123 Clarke, Robert, of Hornecastell, yeoman 0
4163286 2082687 2082687 defendant Hamerton Gregory draper 593123 593123 Hamerton, Gregory, of Hornecastell, draper 1
4168264 2084386 2084386 defendant Markham Henry butcher 593123 593123 Markham, Henry, of Hornecastell, butcher 0
4170226 2085083 2085083 defendant Sherwyn John yeoman 593123 593123 Sherwyn, John, of Hornecastell, yeoman 1
4171040 2085353 2085353 defendant Hamon William pedder or peddler 593123 593123 Hamon, William, of Hornecastell, pedder or peddler 3
4174900 2086686 2086686 defendant Hamerton Gregory draper 593123 593123 Hamerton, Gregory, of Hornecastell, draper 0
4182523 2089366 2089366 defendant Hamon William pedder or peddler 593123 593123 Hamon, William, of Hornecastell, pedder or peddler 3
4197988 2094847 2094847 defendant Pell William painter 593123 593123 Pell, William, of Hornecastell, painter 0
4245926 2111617 2111617 defendant Pates Richard gent 593123 593123 Pates, Richard, of Hornecastell, gent 2
4296964 2129012 2129012 defendant Salmon Bartholomew gent 593123 593123 Salmon, Bartholomew, of Hornecastell, gent 0
4354477 2148800 2148800 defendant Parker William gent 593123 593123 Parker, William, of Hornecastell, gent 0
4384303 2159444 2159444 defendant Tupholme William   593123 593123 Tupholme, William, of Hornecastell, chapman, woollen draper 1
4505810 2202322 2202322 plaintiff Stirkeland William de   593123 593123 Stirkeland, William de, of Hornecastell, parson, on his own account 0
4505812 2202323 2202323 plaintiff Stirkeland William de   593123 593123 Stirkeland, William de, of Hornecastell, parson, on his own account 0
4654949 2247431 2247431 defendant Cuff William glover 593123 593123 Cuff, William, of Hornecastell, glover 0
4654950 2247431 2247431 defendant Sadeler Thomas saddler 593123 593123 Sadeler, Thomas, of Hornecastell, saddler 1
4659767 2248904 2248904 defendant Westurne William yeoman 593123 593123 Westurne, William, of Hornecastell, yeoman 0
4690975 2262701 2262701 defendant Carterson John mercer 593123 593123 Carterson, John, of Hornecastell, mercer 1
4821766 2302885 2302885 defendant Grene John dyer 593123 593123 Grene, John, of Hornecastell, dyer 0
4821767 2302885 2302885 defendant Marom William husbandman 593123 593123 Marom, William, of Hornecastell, husbandman 1
4887800 2323014 2323014 plaintiff Stanes William   593123 593123 Stanes, William, of Hornecastell 0
4933954 2336998 2336998 defendant Bullok John husbandman 593123 593123 Bullok, John, of Hornecastell, husbandman 0
5108860 2389014 2389014 defendant Mannyng Thomas husbandman 593123 593123 Mannyng, Thomas, of Hornecastell, husbandman 1
5109132 2389094 2389094 defendant Crobber Thomas husbandman 593123 593123 Crobber, Thomas, of Hornecastell, husbandman 1
5227416 2423648 2423648 defendant Ellerton William yeoman 593123 593123 Ellerton, William, of Hornecastell, yeoman 0
5227417 2423648 2423648 defendant Faukener Robert   593123 593123 Faukener, Robert, of Hornecastell, holy water clerk 1
5248186 2429602 2429602 defendant Flesshewer Robert butcher 593123 593123 Flesshewer, Robert, of Hornecastell, butcher 2
5287613 2441403 2441403 defendant Gegge Thomas walker 593123 593123 Gegge, Thomas, of Hornecastell, walker 0
5326926 2453127 2453127 defendant Stykney Thomas walker 593123 593123 Stykney, Thomas, of Hornecastell, walker 1
5326927 2453127 2453127 defendant Stykney Richard walker 593123 593123 Stykney, Richard, of Hornecastell, walker 2

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