names

142 rows where place_id = 601348

✎ 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
3637341 1906483 1906483 defendant Marchall John   601348 601348 Marchall, John, of Castelacre, collar maker 1
3644943 1908827 1908827 plaintiff Fuller William   601348 601348 Fuller, William, of Castelacre 0
3680716 1920050 1920050 defendant Blysse John clerk 601348 601348 Blysse, John, of Castelacre, clerk 1
3690043 1923045 1923045 plaintiff Fuller William   601348 601348 Fuller, William, of Castelacre 0
3690045 1923046 1923046 plaintiff Fuller William yeoman 601348 601348 Fuller, William, of Castelacre, yeoman 0
3699744 1926148 1926148 defendant Dallyng Henry butcher 601348 601348 Dallyng, Henry, of Castelacre, butcher 0
3702055 1926897 1926897 defendant Shortyng Richard laborer 601348 601348 Shortyng, Richard, of Castelacre, laborer 0
3715759 1931218 1931218 defendant Dallyng Henry butcher 601348 601348 Dallyng, Henry, of Castelacre, butcher 0
3715760 1931219 1931219 plaintiff Calybut John   601348 601348 Calybut, John, of Castelacre 0
3745789 1940587 1940587 plaintiff Calybutt John   601348 601348 Calybutt, John, of Castelacre 0
3755038 1943525 1943525 defendant Soottyng Agnes widow 601348 601348 (Soottyng, Agnes, of Castelacre, widow 1
3755039 1943525 1943525 defendant Soottyng William baker 601348 601348 Soottyng, William, of Castelacre, baker 2
3756795 1944097 1944097 defendant Lacforth alias Bocher John butcher 601348 601348 Lacforth alias Bocher, John, of Castelacre, butcher 0
3776863 1950504 1950504 plaintiff Calybutt John   601348 601348 Calybutt, John, of Castelacre 0
3780230 1951545 1951545 plaintiff Fuller William (legal representative) 601348 601348 Fuller, William, of Castelacre, executors of 0
3780234 1951546 1951546 plaintiff Fuller William (legal representative) 601348 601348 Fuller, William, of Castelacre, executors of 0
3784194 1952842 1952842 defendant Calybot Anthony gent 601348 601348 Calybot, Anthony, of Castelacre, gent 0
3797104 1956977 1956977 plaintiff Fuller William (legal representative) 601348 601348 Fuller, William, of Castelacre, executors of 0
3802384 1958645 1958645 plaintiff Partryk Richard   601348 601348 Partryk, Richard, of Castelacre 0
3826866 1966252 1966252 defendant Lakeford William butcher 601348 601348 Lakeford, William, of Castelacre, butcher 0
3829983 1967273 1967273 defendant Heye William husbandman 601348 601348 Heye, William, of Castelacre, husbandman 0
3829984 1967273 1967273 defendant Heye Robert husbandman 601348 601348 Heye, Robert, of Castelacre, husbandman 1
3844943 1971964 1971964 defendant Lakford William husbandman 601348 601348 Lakford, William, of Castelacre, husbandman 1
3858676 1976385 1976385 defendant Lowe Thomas gent 601348 601348 Lowe, Thomas, of Castelacre, gent 0
3866571 1979046 1979046 plaintiff Prior Thomas   601348 601348 Prior, Thomas, of Castelacre 0
3866573 1979046 1979046 defendant Stoker Richard laborer 601348 601348 Stoker, Richard, of Castelacre, laborer 1
3873049 1981200 1981200 defendant Lowe Thomas gent 601348 601348 Lowe, Thomas, of Castelacre, gent 0
3886068 1985592 1985592 defendant Lakforth William butcher 601348 601348 Lakforth, William, of Castelacre, butcher 1
3889669 1986779 1986779 defendant Lakford William butcher 601348 601348 Lakford, William, of Castelacre, butcher 0
3890139 1986938 1986938 defendant Lakforth alias Bocher William butcher 601348 601348 Lakforth alias Bocher, William, of Castelacre, butcher 0
3890617 1987126 1987126 defendant Hypgan alias Hyppeham William husbandman 601348 601348 Hypgan alias Hyppeham, William, of Castelacre, husbandman 0
3893241 1987973 1987973 defendant Stoker Richard laborer 601348 601348 Stoker, Richard, of Castelacre, laborer 0
3893242 1987973 1987973 defendant Dale Geoffrey laborer 601348 601348 Dale, Geoffrey, of Castelacre, laborer 1
3893245 1987973 1987973 defendant Barett John husbandman 601348 601348 Barett, John, of Castelacre, husbandman 4
3893246 1987973 1987973 defendant Brown John laborer 601348 601348 Brown, John, of Castelacre, laborer 5
3897927 1989514 1989514 defendant Smyth Robert yeoman 601348 601348 Smyth, Robert, of Castelacre, yeoman 0
3905907 1992259 1992259 defendant Lakford William butcher 601348 601348 Lakford, William, of Castelacre, butcher 1
3907563 1992822 1992822 defendant Stoker Richard laborer 601348 601348 Stoker, Richard, of Castelacre, laborer 0
3907564 1992822 1992822 defendant Dale Geoffrey laborer 601348 601348 Dale, Geoffrey, of Castelacre, laborer 1
3907567 1992822 1992822 defendant Barrett John husbandman 601348 601348 Barrett, John, of Castelacre, husbandman 4
3907568 1992822 1992822 defendant Browne John laborer 601348 601348 Browne, John, of Castelacre, laborer 5
3913279 1994772 1994772 plaintiff Bathcome John   601348 601348 Bathcome, John, of Castelacre 0
3913280 1994772 1994772 defendant Mason Robert baker 601348 601348 Mason, Robert, of Castelacre, baker 0
3920687 1997268 1997268 defendant Lakforth William butcher 601348 601348 Lakforth, William, of Castelacre, butcher 5
3923270 1998094 1998094 defendant Lakforth William butcher 601348 601348 Lakforth, William, of Castelacre, butcher 1
3997031 2023706 2023706 defendant Skynner Giles   601348 601348 Skynner, Giles, of Castelacre, linen draper 0
4056770 2044804 2044804 defendant Bennyar Robert miller 601348 601348 Bennyar, Robert, of Castelacre, miller 1
4150531 2078319 2078319 defendant Bennett Randolph shoemaker 601348 601348 Bennett, Randolph, of Castelacre, shoemaker 0
4181305 2088942 2088942 defendant Lackford James butcher 601348 601348 Lackford, James, of Castelacre, butcher 0
4184510 2090091 2090091 defendant Warde John miller 601348 601348 Warde, John, of Castelacre, miller 0
4192031 2092771 2092771 defendant Buntyn John butcher 601348 601348 Buntyn, John, of Castelacre, butcher 0
4202517 2096419 2096419 defendant Pattricke John husbandman 601348 601348 Pattricke, John, of Castelacre, husbandman 0
4202518 2096419 2096419 defendant Pattricke Edmund husbandman 601348 601348 Pattricke, Edmund, of Castelacre, husbandman 1
4274763 2121119 2121119 defendant Pickeringe John yeoman 601348 601348 Pickeringe, John, of Castelacre, yeoman 0
4437058 2176335 2176335 plaintiff Treweman John   601348 601348 Treweman, John, of Castelacre, son of John 0
4437061 2176336 2176336 plaintiff Treweman John   601348 601348 Treweman, John, of Castelacre, son of John 0
4437063 2176336 2176336 defendant Gorge William   601348 601348 (Gorge, William, of Castelacre 1
4437064 2176336 2176336 defendant atte Gannok John   601348 601348 atte Gannok, John, of Castelacre 2
4491314 2197971 2197971 defendant Ryngolf Adam   601348 601348 Ryngolf, Adam, of Castelacre 0
4521298 2207004 2207004 defendant Wryght Peter   601348 601348 Wryght, Peter, of Castelacre 4
4589811 2228179 2228179 defendant Boocher Andrew   601348 601348 Boocher, Andrew, of Castelacre 0
4682228 2260064 2260064 plaintiff Myryge William   601348 601348 Myryge, William, of Castelacre, on his own account 0
4684838 2260857 2260857 defendant Pryour Peter yeoman 601348 601348 Pryour, Peter, of Castelacre, yeoman 1
4749432 2280315 2280315 plaintiff Brochard John   601348 601348 (Brochard, John, of Castelacre 1
4802295 2296907 2296907 plaintiff Aleyn John   601348 601348 Aleyn, John, of Castelacre 0
4820645 2302528 2302528 defendant Comber John yeoman 601348 601348 Comber, John, of Castelacre, yeoman 3
4915598 2331379 2331379 plaintiff Drachet or Brachet Richard   601348 601348 Drachet or Brachet, Richard, of Castelacre 0
5110222 2389396 2389396 defendant Deye Richard yeoman 601348 601348 Deye, Richard, of Castelacre, yeoman 1
5136901 2397311 2397311 defendant Prentys William gent 601348 601348 Prentys, William, of Castelacre, gent 0
5185361 2411463 2411463 defendant Gedge John (legal representative) 601348 601348 Gedge, John, of Castelacre, yeoman, executor of 0
5232285 2425020 2425020 defendant Maryon Thomas yeoman 601348 601348 Maryon, Thomas, of Castelacre, yeoman 0
5232342 2425035 2425035 defendant Botery John chandler 601348 601348 Botery, John, of Castelacre, chandler 2
5232384 2425040 2425040 defendant Botery John chandler 601348 601348 Botery, John, of Castelacre, chandler 2
5235682 2426016 2426016 defendant Munsewys Robert husbandman 601348 601348 Munsewys, Robert, of Castelacre, husbandman 3
5244823 2428656 2428656 defendant Egle Henry husbandman 601348 601348 Egle, Henry, of Castelacre, husbandman 1
5249956 2430097 2430097 defendant Derby William husbandman 601348 601348 Derby, William, of Castelacre, husbandman 2
5250633 2430308 2430308 defendant Candeler Richard chandler 601348 601348 Candeler, Richard, of Castelacre, chandler 0
5274594 2437651 2437651 defendant Caundeler Richard husbandman 601348 601348 Caundeler, Richard, of Castelacre, husbandman 0
5279493 2439079 2439079 defendant Prentyse William gent 601348 601348 Prentyse, William, of Castelacre, gent 2
5283351 2440187 2440187 defendant Poyntour Richard yeoman 601348 601348 Poyntour, Richard, of Castelacre, yeoman 0
5283352 2440187 2440187 defendant Maryot Thomas yeoman 601348 601348 together with Maryot, Thomas, of Castelacre, yeoman 1
5283353 2440187 2440187 defendant Farle William yeoman 601348 601348 Farle, William, of Castelacre, yeoman 2
5283354 2440187 2440187 defendant Fyssher William yeoman 601348 601348 Fyssher, William, of Castelacre, yeoman 3
5302259 2445638 2445638 defendant Poynter Richard yeoman 601348 601348 Poynter, Richard, of Castelacre, yeoman 0
5354938 2461615 2461615 defendant Farle William (legal representative) 601348 601348 Farle, William, of Castelacre, yeoman, executors of 9
5356337 2462053 2462053 defendant Bakon Thomas yeoman 601348 601348 Bakon, Thomas, of Castelacre, yeoman 2
5358949 2462849 2462849 defendant Skotyn alias Baker John husbandman 601348 601348 Skotyn alias Baker, John, of Castelacre, husbandman 0
5361904 2463748 2463748 defendant Geffrey alias Weldeman Hugh (legal representative) 601348 601348 Geffrey alias Weldeman, Hugh, of Castelacre, administrator of 0
5361905 2463748 2463748 defendant Aleyn John husbandman 601348 601348 Aleyn, John, of Castelacre, husbandman 1
5385417 2470906 2470906 defendant Synnowe John husbandman 601348 601348 Synnowe, John, of Castelacre, husbandman 9
5441672 2487426 2487426 defendant Fox_ John gent 601348 601348 Fox_, John, of Castelacre, gent 0
5481009 2499272 2499272 defendant Horne William clerk 601348 601348 Horne, William, of Castelacre, clerk 3
5481014 2499273 2499273 defendant Horne William clerk 601348 601348 together with Horne, William, of Castelacre, clerk 2
5485857 2500663 2500663 plaintiff Reade John   601348 601348 Reade, John, of Castelacre 0
5485888 2500671 2500671 plaintiff Reede John   601348 601348 Reede, John, of Castelacre 0
5485889 2500671 2500671 defendant Lackford John butcher 601348 601348 Lackford, John, of Castelacre, butcher 0
5485890 2500671 2500671 defendant Maryon James husbandman 601348 601348 Maryon, James, of Castelacre, husbandman 1
5485892 2500672 2500672 plaintiff Reede John   601348 601348 Reede, John, of Castelacre 0
5485893 2500672 2500672 defendant Lackford John butcher 601348 601348 Lackford, John, of Castelacre, butcher 0
5485894 2500672 2500672 defendant Maryon James husbandman 601348 601348 Maryon, James, of Castelacre, husbandman 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);