names

52 rows where place_id = 599029

✎ 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
3634916 1905722 1905722 defendant Wallop Robert gent 599029 599029 Wallop, Robert, of Farley, gent 0
3699646 1926119 1926119 defendant Pope alias Poke John yeoman 599029 599029 Pope alias Poke, John, of Farley, yeoman 0
3708141 1928845 1928845 defendant Wallop Robert esq 599029 599029 Wallop, Robert, of Farley, esq 0
3847053 1972628 1972628 defendant Wallop Rose widow 599029 599029 Wallop, Rose, of Farley, widow 1
3847056 1972629 1972629 defendant Wallop Rose widow 599029 599029 Wallop, Rose, of Farley, widow 1
3847058 1972630 1972630 defendant Wallop Robert (legal representative) 599029 599029 Wallop, Robert, of Farley, knight, executrix of 0
3851138 1973945 1973945 defendant Sympson John clerk 599029 599029 Sympson, John, of Farley, clerk 0
3851141 1973946 1973946 defendant Symson John clerk 599029 599029 Symson, John, of Farley, clerk 0
3883037 1984593 1984593 defendant Sympson John clerk 599029 599029 Sympson, John, of Farley, clerk 0
3925945 1998992 1998992 defendant Sympson John clerk 599029 599029 Sympson, John, of Farley, clerk 2
4315182 2135427 2135427 defendant Farley Reginald gent 599029 599029 Farley, Reginald, of Farley, gent 0
4318897 2136721 2136721 defendant Mils Thomas gent 599029 599029 Mils, Thomas, of Farley, gent 1
4366745 2153152 2153152 defendant Heathe Stephen husbandman 599029 599029 Heathe, Stephen, of Farley, husbandman 0
4379422 2157719 2157719 defendant Heath Stephen yeoman 599029 599029 Heath, Stephen, of Farley, yeoman 0
4488341 2197072 2197072 defendant Shaffyngdon Stephen de   599029 599029 Shaffyngdon, Stephen de, of Farley 0
4546004 2214691 2214691 defendant Bover John   599029 599029 Bover, John, of Farley 1
4581561 2225677 2225677 defendant Blessed William   599029 599029 Blessed, William, of Farley 1
4592459 2228995 2228995 defendant Coster John   599029 599029 Coster, John, of Farley Mortymer 0
4628029 2239688 2239688 defendant Guy Robert   599029 599029 Guy, Robert, of Farley 1
4690305 2262523 2262523 defendant Bloxworth John tailor 599029 599029 Bloxworth, John, of Farley, tailor 0
4755186 2282009 2282009 defendant Shephurd John husbandman 599029 599029 Shephurd, John, of Farley, husbandman 0
4766008 2285360 2285360 defendant Henet John husbandman 599029 599029 Henet, John, of Farley, husbandman 1
4792229 2293658 2293658 defendant Blode John husbandman 599029 599029 Blode, John, of Farley, husbandman 4
4792236 2293659 2293659 defendant Blode John husbandman 599029 599029 Blode, John, of Farley, husbandman 3
4814137 2300521 2300521 defendant Barry Richard husbandman 599029 599029 Barry, Richard, of Farley, husbandman 0
4836753 2307463 2307463 defendant Barry John, sen husbandman 599029 599029 Barry, John, sen, of Farley, husbandman 0
4836754 2307463 2307463 defendant Doune William   599029 599029 Doune, William, of Farley, servant 1
4836755 2307463 2307463 defendant Wyndelsore John husbandman 599029 599029 Wyndelsore, John, of Farley, husbandman 2
4836756 2307463 2307463 defendant Annotres Edward husbandman 599029 599029 Annotres, Edward, of Farley, husbandman 3
4847881 2310822 2310822 defendant Uphill John laborer 599029 599029 Uphill, John, of Farley, laborer 0
4849772 2311398 2311398 defendant (not given) John prior of Hole 599029 599029 Hole, John, of Farley, prior of the monastery of the BMM 0
4953180 2342912 2342912 defendant Blode John husbandman 599029 599029 Blode, John, of Farley, husbandman 1
4953181 2342912 2342912 defendant Barres Joan widow 599029 599029 Barres, Joan, of Farley, widow 2
4953182 2342912 2342912 defendant Auntres Edward husbandman 599029 599029 Auntres, Edward, of Farley, husbandman 3
4953183 2342912 2342912 defendant Barres Richard husbandman 599029 599029 Barres, Richard, of Farley, husbandman 4
5007968 2359220 2359220 defendant Blode John husbandman 599029 599029 Blode, John, of Farley, husbandman 1
5040397 2368730 2368730 plaintiff Brugge John   599029 599029 Brugge, John, of Farley, prior 0
5073574 2378579 2378579 defendant Kysthill Stephen husbandman 599029 599029 Kysthill, Stephen, of Farley, husbandman 0
5094676 2384856 2384856 defendant Blode John husbandman 599029 599029 Blode, John, of Farley, husbandman 0
5133429 2396267 2396267 defendant Barry Robert   599029 599029 Barry, Robert, of Farley 0
5133430 2396267 2396267 defendant Barry Richard husbandman 599029 599029 Barry, Richard, of Farley, husbandman 1
5153247 2402099 2402099 defendant Barry Robert husbandman 599029 599029 Barry, Robert, of Farley, husbandman 0
5153248 2402099 2402099 defendant Barry Richard husbandman 599029 599029 Barry, Richard, of Farley, husbandman 1
5190696 2413027 2413027 defendant Vergeley John husbandman 599029 599029 Vergeley, John, of Farley, husbandman 0
5190698 2413028 2413028 defendant Vergeley John husbandman 599029 599029 Vergeley, John, of Farley, husbandman 0
5207058 2417800 2417800 defendant Vergeley John husbandman 599029 599029 Vergeley, John, of Farley, husbandman 0
5215964 2420397 2420397 defendant Wylkyns John yeoman 599029 599029 Wylkyns, John, of Farley, yeoman 1
5215966 2420397 2420397 defendant Hode William   599029 599029 Hode, William, of Farley, servant 3
5278063 2438673 2438673 defendant Brytte William clerk 599029 599029 Brytte, William, of Farley, clerk 0
5375297 2467860 2467860 plaintiff Priour John   599029 599029 Priour, John, of Farley 0
5551285 2520408 2520408 defendant Wallop Elizabeth widow 599029 599029 Wallop, Elizabeth, of Farley, widow 1
5574822 2527205 2527205 defendant Stere Edward husbandman 599029 599029 Stere, Edward, of Farley, husbandman 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);