names

130 rows where place_id = 596226

✎ 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
3623743 1874959 1874959 defendant Virley Robert butcher 596226 596226 Virley, Robert, of Claveryng, butcher 0
3623744 1874959 1874959 defendant Birlyng Robert tailor 596226 596226 Birlyng, Robert, of Claveryng, tailor 1
3623745 1874959 1874959 defendant Sexten John yeoman 596226 596226 Sexten, John, of Claveryng, yeoman 2
3623746 1874959 1874959 defendant Lorkyn Thomas yeoman 596226 596226 Lorkyn, Thomas, of Claveryng, yeoman 3
3624696 1875262 1875262 defendant Thake John husbandman 596226 596226 (Thake, John, of Claveryng, husbandman 4
3624702 1875263 1875263 defendant Thake John husbandman 596226 596226 (Thake, John, of Claveryng, husbandman 4
3730333 1935719 1935719 defendant Bradbury William gent 596226 596226 Bradbury, William, of Claveryng, gent 0
3745179 1940398 1940398 defendant Brydbery Richard husbandman 596226 596226 Brydbery, Richard, of Claveryng, husbandman 0
3747109 1941013 1941013 defendant Bradbury William gent 596226 596226 Bradbury, William, of Claveryng, gent 0
3747210 1941044 1941044 defendant Burlyng Robert tailor 596226 596226 Burlyng, Robert, of Claveryng, tailor 0
3760685 1945342 1945342 defendant Bradbury William gent 596226 596226 Bradbury, William, of Claveryng, gent 0
3762639 1945951 1945951 defendant Downe Robert clerk 596226 596226 Downe, Robert, of Claveryng, clerk 0
3780740 1951711 1951711 defendant Downe Robert clerk 596226 596226 Downe, Robert, of Claveryng, clerk 0
3790990 1955019 1955019 defendant Cesyn Nicholas (legal representative) 596226 596226 Cesyn, Nicholas, of Claveryng, yeoman, executors of 0
3795277 1956391 1956391 plaintiff Cosyn Nicholas (legal representative) 596226 596226 Cosyn, Nicholas, of Claveryng, executors of 0
3797556 1957129 1957129 defendant Downe Robert clerk 596226 596226 Downe, Robert, of Claveryng, clerk 0
3804599 1959378 1959378 defendant Lorkyn Richard husbandman 596226 596226 Lorkyn, Richard, of Claveryng, husbandman 0
3807860 1960344 1960344 defendant Cosyn Nicholas (legal representative) 596226 596226 Cosyn, Nicholas, of Claveryng, yeoman, executors of 0
3810199 1961082 1961082 defendant Barett John laborer 596226 596226 Barett, John, of Claveryng, laborer 0
3810200 1961082 1961082 defendant Wodcoke Paul husbandman 596226 596226 Wodcoke, Paul, of Claveryng, husbandman 1
3819897 1964103 1964103 defendant Mede Richard yeoman 596226 596226 Mede, Richard, of Claveryng, yeoman 0
3821158 1964510 1964510 defendant Downes Robert chaplain 596226 596226 Downes, Robert, of Claveryng, chaplain 0
3839995 1970436 1970436 defendant Bulleyn Stephen laborer 596226 596226 Bulleyn, Stephen, of Claveryng, laborer 0
3868663 1979760 1979760 defendant Porter John shoemaker 596226 596226 Porter, John, of Claveryng, shoemaker 1
3879400 1983363 1983363 defendant Bell William husbandman 596226 596226 Bell, William, of Claveryng, husbandman 0
3882552 1984428 1984428 plaintiff Thake John (legal representative) 596226 596226 Thake, John, of Claveryng, yeoman, executors of 0
3913115 1994719 1994719 plaintiff Barlee John   596226 596226 Barlee, John, of Claveryng, gent, administrators of 0
3932756 2001257 2001257 defendant Lorkyn Richard husbandman 596226 596226 Lorkyn, Richard, of Claveryng, husbandman 2
3933696 2001562 2001562 plaintiff Hagar John, junior (legal representative) 596226 596226 Hagar, John, junior, of Claveryng, yeoman, executors of 0
3935827 2002292 2002292 defendant Mylles John butcher 596226 596226 Mylles, John, of Claveryng, butcher 0
4477836 2193735 2193735 defendant Turnour Robert   596226 596226 Turnour, Robert, of Claveryng 4
4478331 2193899 2193899 defendant Pruwet William   596226 596226 Pruwet, William, of Claveryng 0
4479919 2194384 2194384 defendant Turnour Robert   596226 596226 Turnour, Robert, of Claveryng 1
4479920 2194384 2194384 defendant Ponde Nicholas   596226 596226 Ponde, Nicholas, of Claveryng 2
4479921 2194384 2194384 defendant Aleyn John   596226 596226 Aleyn, John, of Claveryng 3
4479922 2194384 2194384 defendant Gandre John   596226 596226 Gandre, John, of Claveryng 4
4491935 2198164 2198164 defendant Pounde Nicholas   596226 596226 Pounde, Nicholas, of Claveryng 0
4631587 2240770 2240770 defendant Totenham Thomas   596226 596226 Totenham, Thomas, of Claveryng 1
4631588 2240770 2240770 defendant Pulter John   596226 596226 Pulter, John, of Claveryng 2
4631589 2240770 2240770 defendant Pays William   596226 596226 Pays, William, of Claveryng 3
4658782 2248618 2248618 plaintiff Crulle Peter   596226 596226 Crulle, Peter, of Claveryng 0
4702354 2266146 2266146 defendant Aleyn William chapman 596226 596226 Aleyn, William, of Claveryng, chapman 4
4702365 2266151 2266151 plaintiff Gymore Richard   596226 596226 Gymore, Richard, of Claveryng 0
4702374 2266153 2266153 plaintiff Gynnore Richard   596226 596226 Gynnore, Richard, of Claveryng 0
4718802 2271224 2271224 defendant Bolyngton John   596226 596226 Bolyngton, John, of Claveryng, franklin 0
4718803 2271224 2271224 defendant Bolyngton Richard yeoman 596226 596226 Bolyngton, Richard, of Claveryng, yeoman 1
4722636 2272395 2272395 defendant Algode John miller 596226 596226 Algode, John, of Claveryng, miller 1
4725118 2273153 2273153 defendant Warde John husbandman 596226 596226 Warde, John, of Claveryng, husbandman 2
4725119 2273153 2273153 defendant Mayhewe Henry husbandman 596226 596226 Mayhewe, Henry, of Claveryng, husbandman 3
4725120 2273153 2273153 defendant Northfolk Richard husbandman 596226 596226 Northfolk, Richard, of Claveryng, husbandman 4
4734622 2275990 2275990 defendant Rowene William husbandman 596226 596226 Rowene, William, of Claveryng, husbandman 3
4780197 2289804 2289804 defendant Cam or Cain John yeoman 596226 596226 Cam or Cain, John, of Claveryng, yeoman 0
4780646 2289945 2289945 defendant Borne John scrivener 596226 596226 Borne, John, of Claveryng, scrivener 4
4782982 2290698 2290698 plaintiff Crulle Peter esq 596226 596226 Crulle, Peter, of Claveryng, esq 0
4782983 2290698 2290698 defendant Grynnore Richard husbandman 596226 596226 Grynnore, Richard, of Claveryng, husbandman 0
4788552 2292480 2292480 defendant Carter John husbandman 596226 596226 Carter, John, of Claveryng, husbandman 0
4788553 2292480 2292480 defendant Songger John thatcher 596226 596226 Songger, John, of Claveryng, thatcher 1
4828565 2304974 2304974 defendant Skylfull Richard gent 596226 596226 Skylfull, Richard, of Claveryng, gent 0
4835021 2306955 2306955 plaintiff Dane John   596226 596226 Dane, John, of Claveryng 0
4850470 2311604 2311604 defendant Skylfull Richard gent 596226 596226 Skylfull, Richard, of Claveryng, gent 0
4868041 2316974 2316974 defendant Skylfull Richard gent 596226 596226 Skylfull, Richard, of Claveryng, gent 0
4881061 2320988 2320988 defendant Maihewe Henry husbandman 596226 596226 Maihewe, Henry, of Claveryng, husbandman 1
4881062 2320988 2320988 defendant Warde John husbandman 596226 596226 Warde, John, of Claveryng, husbandman 2
4885504 2322350 2322350 defendant Lyonn Robert yeoman 596226 596226 Lyonn, Robert, of Claveryng, yeoman 0
4888225 2323126 2323126 defendant Gynnour Richard yeoman 596226 596226 Gynnour, Richard, of Claveryng, yeoman 0
4888226 2323126 2323126 defendant Admonde William pulter 596226 596226 Admonde, William, of Claveryng, pulter 1
4896180 2325464 2325464 defendant Bysshop Thomas smith 596226 596226 Bysshop, Thomas, of Claveryng, smith 2
4933688 2336914 2336914 defendant Chynnore Richard yeoman 596226 596226 Chynnore, Richard, of Claveryng, yeoman 1
4933691 2336915 2336915 defendant Chynnore Richard yeoman 596226 596226 Chynnore, Richard, of Claveryng, yeoman 1
4934333 2337127 2337127 defendant Bolyton Richard gent 596226 596226 Bolyton, Richard, of Claveryng, gent 0
4939747 2338818 2338818 defendant Prentys Richard clerk 596226 596226 Prentys, Richard, of Claveryng, clerk 0
4946778 2340994 2340994 defendant Botere alias Ponde Edmund butcher 596226 596226 Botere alias Ponde, Edmund, of Claveryng, butcher 0
4946780 2340995 2340995 defendant Jynnour Richard yeoman 596226 596226 Jynnour, Richard, of Claveryng, yeoman 0
4953573 2343041 2343041 defendant Thake John, senior butcher 596226 596226 Thake, John, senior, of Claveryng, butcher 0
4953574 2343041 2343041 defendant Thake John, junior butcher 596226 596226 Thake, John, junior, of Claveryng, butcher 1
4953575 2343041 2343041 defendant Doraunt John tailor 596226 596226 Doraunt, John, of Claveryng, tailor 2
4958900 2344631 2344631 defendant Chynnore Richard yeoman 596226 596226 Chynnore, Richard, of Claveryng, yeoman 1
4958903 2344632 2344632 defendant Chynnore Richard yeoman 596226 596226 Chynnore, Richard, of Claveryng, yeoman 1
4964236 2346208 2346208 defendant Thake William, senior butcher 596226 596226 Thake, William, senior, of Claveryng, butcher 1
4972451 2348693 2348693 defendant Longe John husbandman 596226 596226 Longe, John, of Claveryng, husbandman 3
4972452 2348693 2348693 defendant Clyfford Geoffrey husbandman 596226 596226 Clyfford, Geoffrey, of Claveryng, husbandman 4
4972456 2348693 2348693 defendant Neweton Thomas husbandman 596226 596226 Neweton, Thomas, of Claveryng, husbandman 8
4988015 2353386 2353386 defendant Bolyngton Richard   596226 596226 Bolyngton, Richard, of Claveryng, yeoman, son & heir of John Bolyngton 0
4991831 2354441 2354441 defendant Bolyton Richard gent 596226 596226 Bolyton, Richard, of Claveryng, gent 0
5015205 2361333 2361333 plaintiff Bonom Robert   596226 596226 Bonom, Robert, of Claveryng 0
5015206 2361333 2361333 plaintiff Bonom Thomas   596226 596226 Bonom, Thomas, of Claveryng 1
5015207 2361333 2361333 defendant Russell John yeoman 596226 596226 Russell, John, of Claveryng, yeoman 0
5033263 2366610 2366610 defendant Raulyn John husbandman 596226 596226 Raulyn, John, of Claveryng, husbandman 1
5055162 2373120 2373120 defendant Joynour Richard husbandman 596226 596226 Joynour, Richard, of Claveryng, husbandman 0
5078285 2379993 2379993 defendant Joynour Richard husbandman 596226 596226 Joynour, Richard, of Claveryng, husbandman 0
5115548 2390974 2390974 defendant Bynnoure John husbandman 596226 596226 Bynnoure, John, of Claveryng, husbandman 2
5216333 2420519 2420519 defendant Bolyngton Richard, senior gent 596226 596226 Bolyngton, Richard, senior, of Claveryng, gent 0
5216337 2420519 2420519 defendant Cole John laborer 596226 596226 Cole, John, of Claveryng, laborer 4
5226223 2423333 2423333 defendant Bolyngton Richard, senior gent 596226 596226 Bolyngton, Richard, senior, of Claveryng, gent 0
5226224 2423333 2423333 defendant Bolyngton Richard, junior gent 596226 596226 Bolyngton, Richard, junior, of Claveryng, gent 1
5252438 2430873 2430873 defendant Tely Nicholas yeoman 596226 596226 Tely, Nicholas, of Claveryng, yeoman 0
5266140 2435160 2435160 defendant Miller Simon miller 596226 596226 Miller, Simon, of Claveryng, miller 0
5298484 2444536 2444536 defendant Grene Robert laborer 596226 596226 Grene, Robert, of Claveryng, laborer 0
5298485 2444536 2444536 defendant Elys Thomas laborer 596226 596226 Elys, Thomas, of Claveryng, laborer 1
5339488 2456918 2456918 defendant Bobyngton Richard husbandman 596226 596226 Bobyngton, Richard, of Claveryng, 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);