names

77 rows where place_id = 601078

✎ 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
3643754 1908475 1908475 plaintiff Dawys Anne (legal representative) 601078 601078 Dawys, Anne, of Framesden, widow, executor of 0
3643756 1908475 1908475 defendant Stroger Robert husbandman 601078 601078 Stroger, Robert, of Framesden, husbandman 0
3643757 1908475 1908475 defendant Wythe James husbandman 601078 601078 Wythe, James, of Framesden, husbandman 1
3643758 1908475 1908475 defendant Wright Robert husbandman 601078 601078 Wright, Robert, of Framesden, husbandman 2
3730163 1935659 1935659 defendant Peke Edmund husbandman 601078 601078 Peke, Edmund, of Framesden, husbandman 0
3749259 1941696 1941696 defendant Corbold Richard butcher 601078 601078 Corbold, Richard, of Framesden, butcher 1
3753192 1942938 1942938 defendant Corbold Richard butcher 601078 601078 Corbold, Richard, of Framesden, butcher 0
3758546 1944670 1944670 defendant Kendale John husbandman 601078 601078 Kendale, John, of Framesden, husbandman 1
3781619 1951989 1951989 defendant Baker Richard clerk 601078 601078 Baker, Richard, of Framesden, clerk 2
3791600 1955212 1955212 defendant Sympson William husbandman 601078 601078 Sympson, William, of Framesden, husbandman 2
3937196 2002771 2002771 defendant Godbold John husbandman 601078 601078 Godbold, John, of Framesden, husbandman 3
4187433 2091103 2091103 defendant Martyn alias Cawston Nicholas yeoman 601078 601078 Martyn alias Cawston, Nicholas, of Framesden, yeoman 0
4325633 2138950 2138950 defendant Denny Richard butcher 601078 601078 Denny, Richard, of Framesden, butcher 2
4325634 2138950 2138950 defendant Sewell Robert thatcher 601078 601078 Sewell, Robert, of Framesden, thatcher 3
4335502 2142148 2142148 defendant Peartree John yeoman 601078 601078 Peartree, John, of Framesden, or of Alington, yeoman 0
4336567 2142518 2142518 defendant Bell Nicholas gent 601078 601078 Bell, Nicholas, of Framesden, gent 25
4469019 2190982 2190982 defendant Page John   601078 601078 Page, John, of Framesden 6
4469033 2190983 2190983 defendant atte Cros Thomas   601078 601078 atte Cros, Thomas, of Framesden 5
4483735 2195605 2195605 defendant Mors Roger   601078 601078 Mors, Roger, of Framesden 0
4483754 2195610 2195610 defendant Mors Roger   601078 601078 Mors, Roger, of Framesden 0
4592317 2228947 2228947 defendant Smyth Thomas   601078 601078 Smyth, Thomas, of Framesden 0
4638103 2242678 2242678 defendant Hore John   601078 601078 Hore, John, of Framesden 7
4719563 2271459 2271459 defendant Colchestre John   601078 601078 Colchestre, John, of Framesden, bailiff 1
4749888 2280440 2280440 defendant Suckelyng John, senior husbandman 601078 601078 Suckelyng, John, senior, of Framesden, husbandman 0
4749889 2280440 2280440 defendant Suckelyng John, junior husbandman 601078 601078 Suckelyng, John, junior, of Framesden, husbandman 1
4829076 2305135 2305135 defendant Suklyng John yeoman 601078 601078 Suklyng, John, of Framesden, yeoman 0
4843205 2309398 2309398 defendant Mason John husbandman 601078 601078 Mason, John, of Framesden, husbandman 2
4843206 2309398 2309398 defendant Saunfaill Margery widow 601078 601078 Saunfaill, Margery, of Framesden, widow 3
4877943 2320055 2320055 defendant Suckyng John husbandman 601078 601078 Suckyng, John, of Framesden, husbandman 3
4886654 2322690 2322690 defendant Sterlyng Robert husbandman 601078 601078 Sterlyng, Robert, of Framesden, husbandman 0
4911714 2330164 2330164 defendant Tolet William   601078 601078 Tolet, William, of Framesden, vicar 2
4927325 2334977 2334977 defendant Reve John yeoman 601078 601078 Reve, John, of Framesden, yeoman 1
4974976 2349488 2349488 defendant Hayll Robert cooper 601078 601078 Hayll, Robert, of Framesden, cooper 0
4978127 2350423 2350423 defendant Taillour William chaplain 601078 601078 Taillour, William, of Framesden, chaplain 0
4981457 2351369 2351369 defendant Suclyng John yeoman 601078 601078 Suclyng, John, of Framesden, yeoman 3
4989621 2353818 2353818 defendant Starlyng Robert husbandman 601078 601078 Starlyng, Robert, of Framesden, husbandman 15
5011533 2360241 2360241 defendant Overe John yeoman 601078 601078 Overe, John, of Framesden, yeoman 0
5012234 2360428 2360428 defendant Peke Maud   601078 601078 Peke, Maud, of Framesden, servant 0
5024366 2364040 2364040 defendant Suklyng John yeoman 601078 601078 Suklyng, John, of Framesden, yeoman 6
5032918 2366515 2366515 defendant Abelot John (legal representative) 601078 601078 Abelot, John, of Framesden, husbandman, executrix of 2
5032919 2366515 2366515 defendant Abelot Agnes widow 601078 601078 Abelot, Agnes, of Framesden, widow 3
5069069 2377247 2377247 defendant Bybbey Ralph gent 601078 601078 Bybbey, Ralph, of Framesden, gent 1
5069070 2377247 2377247 defendant Bybbey Thomas gent 601078 601078 Bybbey, Thomas, of Framesden, gent 2
5069082 2377248 2377248 defendant Straunge Joan widow 601078 601078 together with Straunge, Joan, of Framesden, widow 6
5069084 2377249 2377249 defendant Straunge Joan widow 601078 601078 Straunge, Joan, of Framesden, widow 0
5069086 2377249 2377249 defendant Bylbey Ralph gent 601078 601078 Bylbey, Ralph, of Framesden, gent 2
5069087 2377249 2377249 defendant Bylbey Thomas gent 601078 601078 Bylbey, Thomas, of Framesden, gent 3
5069094 2377250 2377250 defendant Bybbey Ralph gent 601078 601078 Bybbey, Ralph, of Framesden, gent 2
5069095 2377250 2377250 defendant Bybbey Thomas gent 601078 601078 Bybbey, Thomas, of Framesden, gent 3
5069102 2377251 2377251 defendant Bybbey Ralph gent 601078 601078 Bybbey, Ralph, of Framesden, gent 2
5069103 2377251 2377251 defendant Bybbey Thomas gent 601078 601078 Bybbey, Thomas, of Framesden, gent 3
5107150 2388520 2388520 defendant Suklyng John yeoman 601078 601078 Suklyng, John, of Framesden, yeoman 1
5142393 2398898 2398898 defendant Abelot Edmund husbandman 601078 601078 Abelot, Edmund, of Framesden, husbandman 1
5142779 2399017 2399017 defendant Radclyff Geoffrey   601078 601078 Radclyff, Geoffrey, of Framesden, knight 0
5147390 2400382 2400382 defendant Dawes Thomas butcher 601078 601078 Dawes, Thomas, of Framesden, butcher 0
5167120 2406116 2406116 defendant Dawes Thomas butcher 601078 601078 Dawes, Thomas, of Framesden, butcher 0
5177716 2409183 2409183 defendant Basse William husbandman 601078 601078 Basse, William, of Framesden, husbandman 0
5204699 2417119 2417119 defendant Boteler Robert laborer 601078 601078 Boteler, Robert, of Framesden, laborer 3
5211413 2419071 2419071 defendant Basse William husbandman 601078 601078 Basse, William, of Framesden, husbandman 0
5219955 2421548 2421548 defendant Starlyng Robert yeoman 601078 601078 Starlyng, Robert, of Framesden, yeoman 1
5219956 2421548 2421548 defendant Pethawe Robert yeoman 601078 601078 Pethawe, Robert, of Framesden, yeoman 2
5219957 2421548 2421548 defendant Basse William yeoman 601078 601078 Basse, William, of Framesden, yeoman 3
5233845 2425485 2425485 plaintiff Codlyng Joan (legal representative) 601078 601078 Codlyng, Joan, of Framesden, widow of Codlyng, Robert, of Horham, executor of 0
5350907 2460393 2460393 defendant Pethawe John husbandman 601078 601078 Pethawe, John, of Framesden, husbandman 3
5403504 2476072 2476072 defendant Godyng John husbandman 601078 601078 Godyng, John, of Framesden, husbandman 1
5430866 2484173 2484173 defendant Mason William laborer 601078 601078 Mason, William, of Framesden, laborer 0
5430870 2484174 2484174 defendant Mason William laborer 601078 601078 Mason, William, of Framesden, laborer 0
5433515 2484986 2484986 defendant Godyng John husbandman 601078 601078 Godyng, John, of Framesden, husbandman 0
5433518 2484987 2484987 defendant Godyng John husbandman 601078 601078 Godyng, John, of Framesden, husbandman 0
5433523 2484989 2484989 defendant Godyng John husbandman 601078 601078 Godyng, John, of Framesden, husbandman 0
5449295 2489679 2489679 defendant Wodyng John husbandman 601078 601078 Wodyng, John, of Framesden, husbandman 0
5600302 2534981 2534981 plaintiff Heryng William yeoman 601078 601078 Heryng, William, of Framesden, yeoman 0
5600303 2534981 2534981 defendant Abell William yeoman 601078 601078 Abell, William, of Framesden, yeoman 0
5622782 2551057 2551057 plaintiff Weale Robert le   601078 601078 Weale, Robert le, of Framesden 0
5622804 2551063 2551063 defendant Peek John   601078 601078 Peek, John, of Framesden 5
5626739 2552335 2552335 defendant Page John, senior yeoman 601078 601078 Page, John, senior, of Framesden, yeoman 1
5627205 2552474 2552474 defendant Smyth Bratrice widow of Thomas Smyth 601078 601078 Smyth, Bratrice, of Framesden, widow of Thomas Smyth 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);