names

49 rows where place_id = 595789

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621897 1874392 1874392 plaintiff Wolny Robert   595789 595789 Wolny, Robert, of Reynham St Mary 2
3639167 1907064 1907064 defendant Burgeys Agnes widow 595789 595789 Burgeys, Agnes, of Reynham St Mary, widow 0
3712817 1930328 1930328 plaintiff Wolby Robert yeoman 595789 595789 Wolby, Robert, of Reynham St Mary, yeoman 0
3712827 1930332 1930332 plaintiff Wollevy or Wolleby Robert yeoman 595789 595789 Wollevy or Wolleby, Robert, of Reynham St Mary, yeoman 0
3712829 1930333 1930333 plaintiff Wollevy Robert   595789 595789 Wollevy, Robert, of Reynham St Mary, wool chapman 0
3712831 1930334 1930334 plaintiff Wollvy Robert woolman 595789 595789 Wollvy, Robert, of Reynham St Mary, woolman 0
3712837 1930336 1930336 plaintiff Wolvy Robert woolman 595789 595789 Wolvy, Robert, of Reynham St Mary, woolman 0
3718241 1931989 1931989 defendant Wulby John husbandman 595789 595789 Wulby, John, of Reynham St Mary, husbandman 0
3825160 1965736 1965736 plaintiff Wulvy Robert (legal representative) 595789 595789 Wulvy, Robert, of Reynham St Mary, executor of 0
3825164 1965737 1965737 plaintiff Wulvy Robert (legal representative) 595789 595789 Wulvy, Robert, of Reynham St Mary, executor of 0
3893989 1988209 1988209 defendant Short Robert mercer 595789 595789 Short, Robert, of Reynham St Mary, mercer 0
3893995 1988210 1988210 defendant Short Robert mercer 595789 595789 Short, Robert, of Reynham St Mary, mercer 0
4245076 2111337 2111337 defendant Clyfton Stephen gent 595789 595789 Clyfton, Stephen, of Reynham St Mary, gent 0
4258163 2115703 2115703 defendant Clyfton Stephen   595789 595789 Clyfton, Stephen, of Reynham St Mary gent 0
4985251 2352516 2352516 defendant Bekham John butcher 595789 595789 Bekham, John, of Reynham St Mary, butcher 0
4985252 2352516 2352516 defendant Bekham Richard butcher 595789 595789 Bekham, Richard, of Reynham St Mary, butcher 1
5119587 2392161 2392161 plaintiff Warcop John   595789 595789 Warcop, John, of Reynham St Mary 1
5142102 2398810 2398810 defendant Bole John husbandman 595789 595789 Bole, John, of Reynham St Mary, husbandman 4
5147226 2400330 2400330 plaintiff Chirche John   595789 595789 Chirche, John, of Reynham St Mary 0
5147267 2400343 2400343 plaintiff Chyrche John   595789 595789 Chyrche, John, of Reynham St Mary 0
5167006 2406084 2406084 plaintiff Chirche John   595789 595789 Chirche, John, of Reynham St Mary 0
5182232 2410556 2410556 plaintiff Chirche John   595789 595789 Chirche, John, of Reynham St Mary 0
5252957 2431038 2431038 defendant Groute John butcher 595789 595789 Groute, John, of Reynham St Mary, butcher 1
5299790 2444908 2444908 defendant Murrok John husbandman 595789 595789 Murrok, John, of Reynham St Mary, husbandman 0
5304110 2446238 2446238 defendant Groute John yeoman 595789 595789 Groute, John, of Reynham St Mary, yeoman 0
5313170 2448970 2448970 defendant Murrok John husbandman 595789 595789 Murrok, John, of Reynham St Mary, husbandman 0
5313172 2448971 2448971 defendant Murrok John husbandman 595789 595789 Murrok, John, of Reynham St Mary, husbandman 0
5321560 2451536 2451536 defendant Anger Clement husbandman 595789 595789 Anger, Clement, of Reynham St Mary, husbandman 1
5321563 2451537 2451537 defendant Anger Clement husbandman 595789 595789 Anger, Clement, of Reynham St Mary, husbandman 1
5325014 2452563 2452563 defendant Murrok John husbandman 595789 595789 Murrok, John, of Reynham St Mary, husbandman 0
5362372 2463888 2463888 defendant Wolvy Robert, senior husbandman 595789 595789 Wolvy, Robert, senior, of Reynham St Mary, husbandman 0
5362383 2463891 2463891 defendant Wolvy Robert, senior husbandman 595789 595789 Wolvy, Robert, senior, of Reynham St Mary, husbandman 0
5406212 2476852 2476852 defendant Smyth Thomas clerk 595789 595789 Smyth, Thomas, of Reynham St Mary, clerk 2
5406958 2477053 2477053 defendant Wolny or Wolvy Robert, senior husbandman 595789 595789 Wolny or Wolvy, Robert, senior, of Reynham St Mary, husbandman 0
5408362 2477473 2477473 defendant Smyth Thomas   595789 595789 Smyth, Thomas, of Reynham St Mary 2
5420152 2480945 2480945 defendant Wolvy Robert, sen husbandman 595789 595789 Wolvy, Robert, sen, of Reynham St Mary, husbandman 0
5420157 2480947 2480947 defendant Wolny Robert, sen husbandman 595789 595789 Wolny, Robert, sen, of Reynham St Mary, husbandman 0
5438881 2486551 2486551 defendant Wolvy Robert, sen husbandman 595789 595789 Wolvy, Robert, sen, of Reynham St Mary, husbandman 0
5459839 2492872 2492872 defendant Whitlak Thomas smith 595789 595789 Whitlak, Thomas, of Reynham St Mary, smith 1
5464699 2494355 2494355 defendant Wolvy Robert, sen husbandman 595789 595789 Wolvy, Robert, sen, of Reynham St Mary, husbandman 0
5490467 2502043 2502043 plaintiff Bole John (legal representative) 595789 595789 Bole John, of Reynham St Mary, executors of 0
5533026 2514871 2514871 defendant Hopper John husbandman 595789 595789 Hopper, John, of Reynham St Mary, husbandman 4
5535825 2515710 2515710 defendant Gygges Thomas gent 595789 595789 Gygges, Thomas, of Reynham St Mary, gent 1
5538035 2516384 2516384 defendant Burgeys John yeoman 595789 595789 Burgeys, John, of reynham St Mary, yeoman 3
5546511 2518981 2518981 plaintiff Towneshend Eleanor (legal representative) 595789 595789 Towneshend, Eleanor, of Reynham St Mary, widow of Touneshend, Roger, knight, Justice, executor of 0
5546521 2518982 2518982 plaintiff Towneshend Eleanor (legal representative) 595789 595789 Towneshend, Eleanor, of Reynham St Mary, widow of Touneshend, Roger, knight, Justice, executor of 0
5561222 2523264 2523264 plaintiff Touneshend Eleanor (legal representative) 595789 595789 Touneshend, Eleanor, of Reynham St Mary, widow, executrix of Touneshend, Roger, knight, Justice, executor of 0
5603715 2536029 2536029 defendant Reve Robert yeoman 595789 595789 Reve, Robert, of Reynham St Mary, yeoman 1
5626799 2552352 2552352 defendant Westlond John laborer 595789 595789 Westlond, John, of Reynham St Mary, laborer 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);