names

83 rows where place_id = 599132

✎ 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
3629943 1904221 1904221 defendant Eglyn John   599132 599132 Eglyn, John, of Brandon Fery, shepherd 3
3635420 1905875 1905875 plaintiff Parker Hugh   599132 599132 Parker, Hugh, of Brandon Fery 0
3635422 1905875 1905875 defendant Page Thomas husbandman 599132 599132 Page, Thomas, of Brandon Fery, husbandman 1
3639474 1907151 1907151 defendant Johnson Lawrence innholder 599132 599132 Johnson, Lawrence, of Brandon Fery, innholder 0
3652912 1911237 1911237 defendant Johnson Lawrence yeoman 599132 599132 Johnson, Lawrence, of Brandon Fery, yeoman 0
3683265 1920887 1920887 defendant Alison John waterman 599132 599132 Alison, John, of Brandon Fery, waterman 0
3683266 1920888 1920888 plaintiff Walden Robert   599132 599132 Walden, Robert, of Brandon Fery 0
3683267 1920888 1920888 defendant Cosyn John yeoman 599132 599132 Cosyn, John, of Brandon Fery, yeoman 0
3683268 1920889 1920889 plaintiff Walden Robert   599132 599132 Walden, Robert, of Brandon Fery 0
3683269 1920889 1920889 defendant Sawnder John draper 599132 599132 Sawnder, John, of Brandon Fery, draper 0
3685577 1921641 1921641 plaintiff Turnour Richard   599132 599132 Turnour, Richard, of Brandon Fery 1
3686631 1921971 1921971 defendant Jakson Richard innkeeper 599132 599132 Jakson, Richard, of Brandon Fery, innkeeper 0
3734618 1937074 1937074 defendant Woodstokke William tailor 599132 599132 Woodstokke, William, of Brandon Fery, tailor 3
3756522 1944017 1944017 defendant Bellamy Thomas husbandman 599132 599132 Bellamy, Thomas, of Brandon Fery, husbandman 0
3756523 1944017 1944017 defendant Baron Ralph innholder 599132 599132 Baron, Ralph, of Brandon Fery, innholder 1
3756525 1944017 1944017 defendant Lylly Robert husbandman 599132 599132 Lylly, Robert, of Brandon Fery, husbandman 3
3756531 1944019 1944019 defendant Page Thomas laborer 599132 599132 Page, Thomas, of Brandon Fery, laborer 0
3774422 1949723 1949723 defendant Page Thomas laborer 599132 599132 Page, Thomas, of Brandon Fery, laborer 0
3774426 1949725 1949725 defendant Smere John yeoman 599132 599132 Smere, John, of Brandon Fery, yeoman 0
3775087 1949939 1949939 defendant Hardwyk Edmund mercer 599132 599132 Hardwyk, Edmund, of Brandon Fery, mercer 2
3789130 1954409 1954409 defendant Atmer John   599132 599132 Atmer, John, of Brandon Fery, Suff. Yeoman 0
3808737 1960612 1960612 plaintiff Atmere John yeoman 599132 599132 Atmere, John, of brandon Fery, yeoman 0
3837737 1969717 1969717 defendant Leme Thomas husbandman 599132 599132 Leme, Thomas, of Brandon Fery, husbandman 0
3866856 1979151 1979151 defendant at Mere John yeoman 599132 599132 at Mere, John, of Brandon Fery, yeoman 0
3868524 1979714 1979714 defendant Adam John innholder 599132 599132 Adam, John, of Brandon Fery, innholder 1
3878202 1982957 1982957 defendant Crowe John innholder 599132 599132 Crowe, John, of Brandon Fery, innholder 0
3881595 1984106 1984106 defendant Drake Richard warrener 599132 599132 Drake, Richard, of Brandon Fery, warrener 1
3881596 1984106 1984106 defendant Clarke Thomas yeoman 599132 599132 Clarke, Thomas, of Brandon Fery, yeoman 2
3911998 1994337 1994337 defendant Day Nicholas husbandman 599132 599132 Day, Nicholas, of Brandon Fery, husbandman 0
3912030 1994348 1994348 defendant Davy Nicholas husbandman 599132 599132 Davy, Nicholas, of Brandon Fery, husbandman 0
3912810 1994617 1994617 plaintiff Atmere Edmund   599132 599132 Atmere, Edmund, of Brandon Fery 0
3912813 1994618 1994618 defendant Carre James clerk 599132 599132 Carre, James, of Brandon Fery, clerk 0
3921922 1997677 1997677 defendant Carre James clerk 599132 599132 Carre, James, of Brandon Fery, clerk 1
3923489 1998163 1998163 defendant Carre James clerk 599132 599132 Carre, James, of Brandon Fery, clerk 1
3924802 1998613 1998613 defendant Dey Nicholas husbandman 599132 599132 Dey, Nicholas, of Brandon Fery, husbandman 0
3950191 2007151 2007151 plaintiff Francys Edmund mercer 599132 599132 Francys, Edmund, of Brandon Fery, mercer 0
3955223 2008891 2008891 defendant Fayerfax William yeoman 599132 599132 Fayerfax, William, of Brandon Fery, yeoman 0
3955224 2008891 2008891 defendant Tylbroke William husbandman 599132 599132 Tylbroke, William, of Brandon Fery, husbandman 1
4004402 2026354 2026354 defendant Crowe Robert grocer 599132 599132 Crowe, Robert, of Brandon Fery, grocer 0
4032554 2036291 2036291 defendant Fyncham Thomas husbandman 599132 599132 Fyncham, Thomas, of Brandon Fery, husbandman 0
4096004 2058900 2058900 defendant Masse Robert yeoman 599132 599132 Masse, Robert, of Brandon Fery, yeoman 3
4135861 2073156 2073156 defendant Shipley John yeoman 599132 599132 Shipley, John, of Brandon Fery, yeoman 0
4135862 2073156 2073156 defendant Hemyngton John yeoman 599132 599132 Hemyngton, John, of Brandon Fery, yeoman 1
4137033 2073595 2073595 defendant Hemyngton John yeoman 599132 599132 Hemyngton, John, of Brandon Fery, yeoman 0
4137035 2073596 2073596 defendant Hemyngton John yeoman 599132 599132 Hemyngton, John, of Brandon Fery, yeoman 0
4137036 2073596 2073596 defendant Hobson John yeoman 599132 599132 Hobson, John, of Brandon Fery, yeoman 1
4137037 2073596 2073596 defendant Tylbrooke Nicholas yeoman 599132 599132 Tylbrooke, Nicholas, of Brandon Fery, yeoman 2
4137039 2073597 2073597 defendant Hemyngton John yeoman 599132 599132 Hemyngton, John, of Brandon Fery, yeoman 0
4137040 2073597 2073597 defendant Hobson John yeoman 599132 599132 Hobson, John, of Brandon Fery, yeoman 1
4137041 2073597 2073597 defendant Tylbroke Nicholas yeoman 599132 599132 Tylbroke, Nicholas, of Brandon Fery, yeoman 2
4466693 2190256 2190256 defendant Sadeler William   599132 599132 Sadeler, William, of Brandon Fery 1
4466694 2190256 2190256 defendant Beeston Thomas   599132 599132 Beeston, Thomas, of Brandon Fery 2
4466695 2190256 2190256 defendant Litster John   599132 599132 Litster, John, of Brandon Fery 3
4653230 2246948 2246948 defendant Kyrton Thomas chapman 599132 599132 Kyrton, Thomas, of Brandon Fery, son of Lawrence Kyrton, of Bury St Edmunds, chapman 0
4682062 2260008 2260008 defendant Lakynghethe John yeoman 599132 599132 Lakynghethe, John, of Brandon Fery, yeoman 0
4683939 2260588 2260588 defendant Kyrton Thomas yeoman 599132 599132 Kyrton, Thomas, of Brandon Fery, yeoman 0
4798332 2295664 2295664 defendant Nook Thomas baker 599132 599132 Nook, Thomas, of Brandon Fery, baker 0
4809498 2299144 2299144 defendant Fordham John   599132 599132 Fordham, John, of Brandon Fery, bailiff 0
4882970 2321593 2321593 defendant Barker John yeoman 599132 599132 Barker, John, of Brandon Fery, yeoman 1
4984765 2352373 2352373 defendant Ram or Rain William husbandman 599132 599132 Ram or Rain, William, of Brandon Fery, husbandman 2
5064660 2375969 2375969 defendant Swaston or Swafton Thomas husbandman 599132 599132 Swaston or Swafton, Thomas, of Brandon Fery, husbandman 0
5064661 2375969 2375969 defendant Brydde or Birde John butcher 599132 599132 Brydde or Birde, John, of Brandon Fery, butcher 1
5081290 2380913 2380913 defendant Leem Thomas yeoman 599132 599132 Leem, Thomas, of Brandon Fery, yeoman 7
5082930 2381396 2381396 plaintiff Edward William yeoman 599132 599132 Edward, William, of Brandon Fery, yeoman 0
5211883 2419214 2419214 defendant Skarlet Guy husbandman 599132 599132 Skarlet, Guy, of Brandon Fery, husbandman 2
5217590 2420885 2420885 defendant Pepyr John yeoman 599132 599132 Pepyr, John, of Brandon Fery, yeoman 1
5260538 2433430 2433430 defendant Pyper John yeoman 599132 599132 Pyper, John, of Brandon Fery, yeoman 0
5481057 2499285 2499285 defendant George Robert warrener 599132 599132 George, Robert, of Brandon Fery, warrener 0
5493063 2502837 2502837 defendant George Robert husbandman 599132 599132 George, Robert, of Brandon Fery, husbandman 0
5493064 2502837 2502837 defendant George Roger husbandman 599132 599132 George, Roger, of Brandon Fery, husbandman 1
5496996 2504039 2504039 plaintiff Leeme William yeoman 599132 599132 Leeme, William, of Brandon Fery, yeoman 0
5497003 2504040 2504040 plaintiff Leeme William yeoman 599132 599132 Leeme, William, of Brandon Fery, yeoman 0
5500419 2505069 2505069 defendant Standon William baker 599132 599132 Standon, William, of Brandon Fery, baker 0
5507315 2507184 2507184 defendant Chamberleyn Roger husbandman 599132 599132 Chamberleyn, Roger, of Brandon Fery, husbandman 1
5537411 2516195 2516195 plaintiff Cosyn John yeoman 599132 599132 Cosyn, John, of Brandon Fery, yeoman 0
5556700 2521918 2521918 defendant Leeham Thomas husbandman 599132 599132 Leeham, Thomas, of Brandon Fery, husbandman 2
5559984 2522876 2522876 defendant Talbot Giles gent 599132 599132 Talbot, Giles, of Brandon Fery, gent 0
5559985 2522876 2522876 defendant Elys John husbandman 599132 599132 Elys, John, of Brandon Fery, husbandman 1
5559986 2522876 2522876 defendant Jermyn Richard yeoman 599132 599132 Jermyn, Richard, of Brandon Fery, yeoman 2
5580766 2529064 2529064 defendant Anslak Thomas chapman 599132 599132 Anslak, Thomas, of Brandon Fery, chapman 0
5605693 2536665 2536665 defendant Babysdyk William barber 599132 599132 Babysdyk, William, of Brandon Fery, barber 0
5605699 2536668 2536668 defendant Parker Henry yeoman 599132 599132 Parker, Henry, of Brandon Fery, yeoman 0
5607462 2537229 2537229 defendant Johnson Lawrence yeoman 599132 599132 Johnson, Lawrence, of Brandon Fery, yeoman 0

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