names

63 rows where place_id = 593353

✎ 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
3611461 1871258 1871258 defendant Joynour John, junior yeoman 593353 593353 Joynour, John, junior, of Bishops Frome, yeoman 3
3702583 1927075 1927075 defendant Fitzurse John gent 593353 593353 Fitzurse, John, of Bishops Frome, gent 0
3730876 1935884 1935884 defendant Fysor John gent 593353 593353 Fysor, John, of Bishops Frome, gent 0
3730877 1935884 1935884 defendant Jones William husbandman 593353 593353 Jones, William, of Bishops Frome, husbandman 1
3755064 1943533 1943533 defendant Benet Thomas yeoman 593353 593353 Benet, Thomas, of Bishops Frome, yeoman 2
3756260 1943916 1943916 defendant Fitz Urse John gent 593353 593353 Fitz Urse, John, of Bishops Frome, gent 0
3757119 1944206 1944206 defendant Jones William husbandman 593353 593353 Jones, William, of Bishops Frome, husbandman 2
3757315 1944267 1944267 defendant Stocton Thomas husbandman 593353 593353 Stocton, Thomas, of Bishops Frome, husbandman 0
3769278 1948045 1948045 defendant Churche John carpenter 593353 593353 Churche, John, of Bishops Frome, carpenter 0
3769434 1948100 1948100 defendant Lorymer Henry husbandman 593353 593353 Lorymer, Henry, of Bishops Frome, husbandman 2
3769435 1948100 1948100 defendant Jones William husbandman 593353 593353 Jones, William, of Bishops Frome, husbandman 3
3838924 1970100 1970100 defendant Fitzhurst John gent 593353 593353 Fitzhurst, John, of Bishops Frome, gent 0
3976268 2016267 2016267 defendant Page alias Wigon John tailor 593353 593353 Page alias Wigon, John, of Bishops Frome, tailor 0
3976269 2016267 2016267 defendant Gethyn alias Eyton John laborer 593353 593353 Gethyn alias Eyton, John, of Bishops Frome, laborer 1
3980619 2017833 2017833 defendant Shurtegove Henry husbandman 593353 593353 Shurtegove, Henry, of Bishops Frome, husbandman 0
3994807 2022894 2022894 defendant Sotman Thomas laborer 593353 593353 Sotman, Thomas, of Bishops Frome, laborer 2
3994808 2022894 2022894 defendant Pychard John gent 593353 593353 Pychard, John, of Bishops Frome, gent 3
4004915 2026541 2026541 plaintiff Joyner Thomas, senior yeoman 593353 593353 Joyner, Thomas, senior, of Bishops Frome, yeoman 0
4004916 2026541 2026541 defendant Barwell Elizabeth widow 593353 593353 Barwell, Elizabeth, of Bishops Frome, widow 0
4022675 2032834 2032834 plaintiff Aston Thomas laborer 593353 593353 Aston, Thomas, of Bishops Frome, laborer 0
4022678 2032835 2032835 plaintiff Aston Thomas laborer 593353 593353 Aston, Thomas, of Bishops Frome, laborer 0
4079595 2053001 2053001 defendant Pytcher John gent 593353 593353 Pytcher, John, of Bishops Frome, gent 0
4080907 2053485 2053485 defendant Lovell John butcher 593353 593353 Lovell, John, of Bishops Frome, butcher 0
4105753 2062346 2062346 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 3
4121418 2067953 2067953 defendant Nesce or Neste Thomas gent 593353 593353 Nesce or Neste, Thomas, of Bishops Frome, gent 0
4121419 2067953 2067953 defendant Nesce or Neste Eleanor widow 593353 593353 Eleanor his wife, alias Eleanor Browne, of Bishops Frome, widow 1
4122982 2068518 2068518 defendant Jones Christipher husbandman 593353 593353 Jones, Christipher, of Bishops Frome, husbandman 1
4122987 2068519 2068519 defendant Jones Christopher husbandman 593353 593353 Jones, Christopher, of Bishops Frome, husbandman 1
4144482 2076232 2076232 defendant Neste Thomas gent 593353 593353 Neste, Thomas, of Bishops Frome, gent 0
4144483 2076232 2076232 defendant Neste Eleanor widow 593353 593353 Eleanor his wife, alias Eleanor Browne, of Bishops Frome, widow 1
4150574 2078335 2078335 defendant Bagard John yeoman 593353 593353 Bagard, John, of Bishops Frome, yeoman 1
4157945 2080849 2080849 defendant Smythe Richard husbandman 593353 593353 Smythe, Richard, of Bishops Frome, husbandman 0
4165209 2083340 2083340 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 0
4165212 2083341 2083341 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 0
4165213 2083341 2083341 defendant Stallarde Robert gent 593353 593353 Stallarde, Robert, of Bishops Frome, gent 1
4218772 2102065 2102065 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 0
4227883 2105235 2105235 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 0
4230101 2106018 2106018 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 1
4231042 2106357 2106357 defendant Cowdinge Francis yeoman 593353 593353 Cowdinge, Francis, of Bishops Frome, yeoman 0
4231043 2106357 2106357 defendant Somner John husbandman 593353 593353 Somner, John, of Bishops Frome, husbandman 1
4238756 2109175 2109175 defendant Jones Christopher yeoman 593353 593353 Jones, Christopher, of Bishops Frome, yeoman 1
4299077 2129768 2129768 defendant Bayly Richard husbandman 593353 593353 Bayly, Richard, of Bishops Frome, husbandman 0
4300433 2130255 2130255 defendant Browne Christopher yeoman 593353 593353 Browne, Christopher, of Bishops Frome, yeoman 0
4307496 2132760 2132760 defendant Bayly Richard husbandman 593353 593353 Bayly, Richard, of Bishops Frome, husbandman 0
4311257 2134084 2134084 defendant Dowdinge Richard gent 593353 593353 Dowdinge, Richard, of Bishops Frome, gent 0
4322966 2138096 2138096 defendant Dowdinge Richard gent 593353 593353 Dowdinge, Richard, of Bishops Frome, gent 0
4322968 2138096 2138096 defendant Dowdinge Francis yeoman 593353 593353 Dowdinge, Francis, of Bishops Frome, yeoman 2
4331248 2140747 2140747 defendant Browne Christopher yeoman 593353 593353 (Browne, Christopher, of Bishops Frome, yeoman 4
4331249 2140747 2140747 defendant Browne Roger yeoman 593353 593353 Browne, Roger, of Bishops Frome, yeoman 5
4334075 2141678 2141678 defendant Dowdynge John yeoman 593353 593353 Dowdynge, John, of Bishops Frome, yeoman 1
4377660 2157082 2157082 defendant Abrahall Thomas gent 593353 593353 Abrahall, Thomas, of Bishops Frome, gent 3
4398123 2163952 2163952 defendant Gayley Edward carpenter 593353 593353 Gayley, Edward, of Bishops Frome, carpenter 0
4403494 2165740 2165740 defendant Dowdinge Richard gent 593353 593353 Dowdinge, Richard, of Bishops Frome, gent 0
4411902 2168574 2168574 defendant Dowdinge Richard gent 593353 593353 Dowdinge, Richard, of Bishops Frome, gent 0
4411914 2168578 2168578 defendant Dowdinge Richard gent 593353 593353 Dowdinge, Richard, of Bishops Frome, gent 0
4794397 2294391 2294391 defendant Brawede John husbandman 593353 593353 Brawede, John, of Bishops Frome, husbandman 0
4894331 2324908 2324908 defendant Kynge Simon yeoman 593353 593353 Kynge, Simon, of Bishops Frome, yeoman 11
4896591 2325599 2325599 defendant Kynge Simon yeoman 593353 593353 Kynge, Simon, of Bishops Frome, yeoman 11
4947878 2341318 2341318 defendant Brande Richard husbandman 593353 593353 Brande, Richard, of Bishops Frome, husbandman 2
5033669 2366727 2366727 defendant Brande Richard husbandman 593353 593353 Brande, Richard, of Bishops Frome, husbandman 0
5256517 2432161 2432161 plaintiff Dovyle Thomas (legal representative) 593353 593353 Dovyle, Thomas, of Bishops Frome, or of Kynges Taneford, executors of 0
5256534 2432164 2432164 plaintiff Dowyle or Dovyle Thomas (legal representative) 593353 593353 Dowyle or Dovyle, Thomas, of Bishops Frome, or of Kyngestaneford, executors of 0
5572522 2526505 2526505 defendant Halfehyde John yeoman 593353 593353 Halfehyde, John, of Bishops Frome, yeoman 1

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