names

60 rows where place_id = 589772

✎ 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
3598690 1867215 1867215 defendant Neuryth John husbandman 589772 589772 Neuryth, John, of Barkyng, Essex, husbandman 1
3640073 1907342 1907342 defendant Waller William barber 589772 589772 Waller, William, of Barkyng, Essex, barber 2
3644467 1908686 1908686 defendant Stonall Thomas husbandman 589772 589772 Stonall, Thomas, of Barkyng, Essex, husbandman 3
3661828 1913983 1913983 defendant Waller William yeoman 589772 589772 Waller, William, of Barkyng, Essex, yeoman 0
3665018 1915004 1915004 defendant Swete John yeoman 589772 589772 Swete, John, of Barkyng, Essex, yeoman 0
3667780 1915865 1915865 plaintiff Wyott William gent 589772 589772 Wyott, William, of Barkyng, Essex, gent 0
3678354 1919285 1919285 plaintiff Mody John (legal representative) 589772 589772 Mody, John, of Barkyng, Essex, clerk, executor of 0
3678521 1919340 1919340 plaintiff Mudy John (legal representative) 589772 589772 Mudy, John, of Barkyng, Essex, clerk, executor of 0
3684649 1921333 1921333 defendant Chapman William yeoman 589772 589772 Chapman, William, of Barkyng, Essex, yeoman 1
3689064 1922741 1922741 defendant Hemyng Robert butcher 589772 589772 Hemyng, Robert, of Barkyng, Essex, butcher 3
3689070 1922742 1922742 defendant Hennyng Robert butcher 589772 589772 Hennyng, Robert, of Barkyng, Essex, butcher 3
3704841 1927807 1927807 defendant Middelton Thomas yeoman 589772 589772 Middelton, Thomas, of Barkyng, Essex, yeoman 3
3718554 1932081 1932081 defendant Bremley Randolph tailor 589772 589772 Bremley, Randolph, of Barkyng, Essex, tailor 0
3751123 1942276 1942276 defendant Bado Robert clerk 589772 589772 Bado, Robert, of Barkyng, Essex, clerk 1
3765812 1946971 1946971 defendant Wattes Thomas yeoman 589772 589772 Wattes, Thomas, of Barkyng, Essex, yeoman 0
3768076 1947653 1947653 defendant Dys William yeoman 589772 589772 Dys, William, of Barkyng, Essex, yeoman 0
3780074 1951491 1951491 defendant Smyth Hugh yeoman 589772 589772 Smyth, Hugh, of Barkyng, Essex, yeoman 0
3790300 1954783 1954783 defendant Estwell Richard tanner 589772 589772 Estwell, Richard, of Barkyng, Essex, tanner 0
3794296 1956090 1956090 defendant Smyth William   589772 589772 Smyth, William, of Barkyng, Essex, singing man 1
3800253 1957999 1957999 defendant Wattes Thomas yeoman 589772 589772 Wattes, Thomas, of Barkyng, Essex, yeoman 0
3815657 1962814 1962814 defendant Morton John yeoman 589772 589772 Morton, John, of Barkyng, Essex, yeoman 2
3822934 1965079 1965079 defendant Stoner Robert   589772 589772 Stoner, Robert, of Barkyng, Essex, gent, keeper of the king's deer, Waltham forest 0
3839818 1970382 1970382 defendant Burre John gent 589772 589772 Burre, John, of Barkyng, Essex, gent 0
3845810 1972240 1972240 defendant Nicolas John yeoman 589772 589772 Nicolas, John, of Barkyng, Essex, yeoman 0
3852351 1974338 1974338 defendant Whyttoft Richard yeoman 589772 589772 Whyttoft, Richard, of Barkyng, Essex, yeoman 1
3852355 1974339 1974339 defendant Whyttoft Richard brewer 589772 589772 Whyttoft, Richard, of Barkyng, Essex, brewer 1
3852359 1974340 1974340 defendant Whyttoft Richard brewer 589772 589772 Whyttoft, Richard, of Barkyng, Essex, brewer 1
3871755 1980788 1980788 defendant Burre Thomas gent 589772 589772 Burre, Thomas, of Barkyng, Essex, gent 0
3886271 1985663 1985663 defendant Grey Richard clerk 589772 589772 Grey, Richard, of Barkyng, Essex, clerk 0
3895032 1988547 1988547 defendant Cople Richard fisherman 589772 589772 Cople, Richard, of Barkyng, Essex, fisherman 1
3897655 1989426 1989426 defendant Tracy Ralph yeoman 589772 589772 Tracy, Ralph, of Barkyng, Essex, yeoman 0
3911113 1994044 1994044 plaintiff Walles Joan (legal representative) 589772 589772 Walles, Joan, of Barkyng, Essex, widow, executor of 0
3911116 1994044 1994044 defendant Page William fisherman 589772 589772 Page, William, of barkyng, Essex, fisherman 1
3937152 2002757 2002757 defendant Carnewell Robert   589772 589772 Carnewell, Robert, of Barkyng, Essex, inn holder 0
3981390 2018112 2018112 defendant Toller Nicholas yeoman 589772 589772 Toller, Nicholas, of Barkyng, Essex, yeoman 1
3985685 2019642 2019642 defendant Bylte Thomas fisherman 589772 589772 Bylte, Thomas, of Barkyng, Essex, fisherman 0
4022009 2032601 2032601 defendant Russell Thomas yeoman 589772 589772 Russell, Thomas, of Barkyng, Essex, yeoman 0
4038192 2038295 2038295 defendant Massy William gent 589772 589772 Massy, William, of Barkyng, Essex, gent 9
4321344 2137558 2137558 defendant Hardware George yeoman 589772 589772 Hardware, George, of Barkyng, Essex, yeoman 0
4333356 2141439 2141439 defendant Hardware George yeoman 589772 589772 Hardware, George, of Barkyng, Essex, yeoman 0
4676193 2258166 2258166 defendant Sweverton Joan esq 589772 589772 Sweverton, Joan, of Barkyng, Essex, widow & formerly wife of Roger Sweverton, esq 1
5000006 2356882 2356882 defendant Burghyld William husbandman 589772 589772 Burghyld, William, of Barkyng, Essex, husbandman 0
5272935 2437157 2437157 defendant Bedyngham Thomas yeoman 589772 589772 Bedyngham, Thomas, of Barkyng, Essex, yeoman 0
5273944 2437458 2437458 defendant Heyward John mariner 589772 589772 Heyward, John, of Barkyng, Essex, mariner 1
5290537 2442233 2442233 defendant Cardynall Geoffrey waterman 589772 589772 Cardynall, Geoffrey, of Barkyng, Essex, waterman 0
5312334 2448724 2448724 defendant Chapman Cecily widow 589772 589772 Chapman, Cecily, of Barkyng, Essex, widow 1
5326410 2452983 2452983 defendant Burre John tanner 589772 589772 Burre, John, of Barkyng, Essex, tanner 8
5341427 2457512 2457512 defendant Bedyngham Thomas yeoman 589772 589772 Bedyngham, Thomas, of Barkyng, Essex, yeoman 1
5343578 2458178 2458178 defendant Corum Viman or Vincent clerk 589772 589772 Corum, Viman or Vincent, of Barkyng, Essex, clerk 2
5356543 2462116 2462116 defendant Connesdewe John, senior husbandman 589772 589772 Connesdewe, John, senior, of Barkyng, Essex, husbandman 0
5426792 2482955 2482955 defendant Phelip John cooper 589772 589772 Phelip, John, of Barkyng, Essex, cooper 0
5443185 2487875 2487875 defendant Frost John yeoman 589772 589772 Frost, John, of Barkyng, Essex, yeoman 1
5451617 2490354 2490354 defendant Grey Robert yeoman 589772 589772 Grey, Robert, of Barkyng, Essex, yeoman 2
5482951 2499842 2499842 defendant Wode John laborer 589772 589772 Wode, John, of Barkyng, Essex, laborer 3
5518865 2510738 2510738 defendant Bardon John husbandman 589772 589772 Bardon, John, of Barkyng, Essex, husbandman 0
5520809 2511329 2511329 defendant Patreke Leonard clerk 589772 589772 Patreke, Leonard, of Barkyng, Essex, clerk 2
5540840 2517268 2517268 defendant Wellys Thomas tanner 589772 589772 Wellys, Thomas, of Barkyng, Essex, tanner 1
5564917 2524326 2524326 defendant Harrys Richard husbandman 589772 589772 Harrys, Richard, of Barkyng, Essex, husbandman 1
5577061 2527872 2527872 defendant Strete John husbandman 589772 589772 Strete, John, of Barkyng, Essex, husbandman 0
5598463 2534404 2534404 defendant Stonall Thomas husbandman 589772 589772 Stonall, Thomas, of Barkyng, Essex, husbandman 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);