names

90 rows where place_id = 606860

✎ 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
3666786 1915555 1915555 defendant Michell Philippa widow 606860 606860 Michell, Philippa, of Flore, widow 0
3673130 1917607 1917607 defendant Michell Henry (legal representative) 606860 606860 Michell, Henry, of Flore, gent, executrix of 0
3673131 1917607 1917607 defendant Mychell Philippa widow 606860 606860 Mychell, Philippa, of Flore, widow 1
3683409 1920933 1920933 defendant Michell Philippa widow 606860 606860 Michell, Philippa, of Flore, widow 0
3723065 1933481 1933481 defendant Tempull Thomas husbandman 606860 606860 Tempull, Thomas, of Flore, husbandman 0
3738795 1938339 1938339 defendant Temple Thomas husbandman 606860 606860 Temple, Thomas, of Flore, husbandman 0
4417984 2170500 2170500 defendant Mauntel Nicholas   606860 606860 Mauntel, Nicholas, of Flore 0
4454214 2186334 2186334 defendant Webbe John, senior   606860 606860 Webbe, John, senior, of Flore 0
4454217 2186334 2186334 defendant Webbe John   606860 606860 Webbe, John, of Flore 3
4454218 2186334 2186334 defendant West Richard   606860 606860 West, Richard, of Flore 4
4454996 2186569 2186569 plaintiff Mauntell John   606860 606860 Mauntell, John, of Flore 0
4487502 2196807 2196807 plaintiff Mauntell John   606860 606860 Mauntell, John, of Flore 2
4506373 2202492 2202492 defendant Warker John   606860 606860 Warker, John, of Flore 3
4506374 2202492 2202492 defendant Warner Thomas   606860 606860 Warner, Thomas, of Flore 4
4506376 2202492 2202492 defendant Smyth Nicholas   606860 606860 Smyth, Nicholas, of Flore 6
4506377 2202492 2202492 defendant Carter Thomas   606860 606860 Carter, Thomas, of Flore 7
4506379 2202492 2202492 defendant Boteler John   606860 606860 Boteler, John, of Flore 9
4506381 2202492 2202492 defendant Munk John   606860 606860 Munk, John, of Flore 11
4506382 2202492 2202492 defendant Stowe John   606860 606860 Stowe, John, of Flore 12
4532147 2210320 2210320 defendant Heyford John   606860 606860 Heyford, John, of Flore 0
4542392 2213512 2213512 plaintiff Youn John   606860 606860 Youn, John, of Flore 0
4576138 2224038 2224038 defendant Walker Richard   606860 606860 Walker, Richard, of Flore 1
4585830 2226989 2226989 defendant Taillour John   606860 606860 Taillour, John, of Flore 8
4592361 2228960 2228960 defendant Walker John   606860 606860 Walker, John, of Flore 0
4592362 2228960 2228960 defendant Lycche John   606860 606860 Lycche, John, of Flore 1
4592364 2228961 2228961 defendant Wykele William   606860 606860 Wykele, William, of Flore 0
4638624 2242832 2242832 defendant Walker John   606860 606860 Walker, John, of Flore 2
4642943 2244042 2244042 defendant Walker John   606860 606860 Walker, John, of Flore 4
4681232 2259756 2259756 defendant Fylle William shoemaker 606860 606860 Fylle, William, of Flore, shoemaker 2
4708074 2267902 2267902 defendant Linche John husbandman 606860 606860 Linche, John, of Flore, husbandman 0
4729357 2274400 2274400 defendant Trussell John   606860 606860 Trussell, John, of Flore, knight 0
4730756 2274821 2274821 plaintiff Mauncell Nicholas   606860 606860 Mauncell, Nicholas, of Flore 0
4730757 2274821 2274821 defendant Stanbrigge John yeoman 606860 606860 Stanbrigge, John, of Flore, yeoman 0
4730758 2274821 2274821 defendant Fill William yeoman 606860 606860 Fill, William, of Flore, yeoman 1
4759900 2283431 2283431 defendant Cappe William husbandman 606860 606860 Cappe, William, of Flore, husbandman 0
4767836 2285915 2285915 defendant Starbrigge John yeoman 606860 606860 Starbrigge, John, of Flore, yeoman 0
4769309 2286377 2286377 defendant Fille William   606860 606860 Fille, William, of Flore, horse dealer 1
4780872 2290018 2290018 plaintiff Cappe William   606860 606860 Cappe, William, of Flore 0
4780873 2290018 2290018 defendant Wykeley William   606860 606860 Wykeley, William, of Flore 0
4783429 2290835 2290835 defendant Lynne Thomas husbandman 606860 606860 Lynne, Thomas, of Flore, husbandman 1
4793813 2294186 2294186 defendant Fylle William courser 606860 606860 Fylle, William, of Flore, courser 0
4820312 2302423 2302423 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 1
4874342 2318918 2318918 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 3
4890010 2323658 2323658 defendant Garo John tailor 606860 606860 Garo, John, of Flore, tailor 1
4890012 2323658 2323658 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 3
4890345 2323748 2323748 defendant Stafford John yeoman 606860 606860 Stafford, John, of Flore, yeoman 2
4899724 2326546 2326546 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 0
4899745 2326553 2326553 defendant Gare John tailor 606860 606860 Gare, John, of Flore, tailor 1
4899747 2326553 2326553 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 3
4902758 2327482 2327482 defendant Gare John tailor 606860 606860 Gare, John, of Flore, tailor 2
4933380 2336827 2336827 defendant Hatton John husbandman 606860 606860 Hatton, John, of Flore, husbandman 0
4954189 2343226 2343226 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 0
4954190 2343226 2343226 defendant Stafford Clement   606860 606860 Stafford, Clement, of Flore, servant 1
4958653 2344557 2344557 plaintiff Yann John   606860 606860 Yann, John, of Flore 0
4958654 2344557 2344557 plaintiff Ichauck John   606860 606860 Ichauck, John, of Flore 1
4963176 2345892 2345892 defendant Atturbury John yeoman 606860 606860 Atturbury, John, of Flore, yeoman 0
4963177 2345892 2345892 defendant Cardeston Thomas   606860 606860 together with Cardeston, Thomas, of Flore, knight 1
4986666 2352946 2352946 defendant (not given) Thomas vicar of Walton 606860 606860 Walton, Thomas, of Flore, vicar of the church 0
4986667 2352946 2352946 defendant Stafford John husbandman 606860 606860 Stafford, John, of Flore, husbandman 1
5010434 2359924 2359924 plaintiff Walton Thomas   606860 606860 Walton, Thomas, of Flore, vicar 0
5010435 2359924 2359924 plaintiff Yon John, sen   606860 606860 Yon, John, sen, of Flore 1
5010437 2359924 2359924 defendant Yon William husbandman 606860 606860 Yon, William, of Flore, husbandman 1
5023090 2363661 2363661 defendant Jonkyn John husbandman 606860 606860 Jonkyn, John, of Flore, husbandman 0
5034016 2366819 2366819 defendant Basset Ralph esq 606860 606860 Basset, Ralph, of Flore, esq 0
5034018 2366819 2366819 defendant Meverell Richard gent 606860 606860 Meverell, Richard, of Flore, gent 2
5034019 2366819 2366819 defendant Thornbury William yeoman 606860 606860 Thornbury, William, of Flore, yeoman 3
5034870 2367055 2367055 defendant Danby or Dauby John butcher 606860 606860 Danby or Dauby, John, of Flore, butcher 0
5070052 2377536 2377536 defendant Adderbury John husbandman 606860 606860 Adderbury, John, of Flore, husbandman 2
5120147 2392328 2392328 defendant Lucche Nicholas husbandman 606860 606860 Lucche, Nicholas, of Flore, husbandman 2
5120148 2392328 2392328 defendant Warner John husbandman 606860 606860 Warner, John, of Flore, husbandman 3
5222214 2422202 2422202 defendant Mason Richard husbandman 606860 606860 Mason, Richard, of Flore, husbandman 3
5334253 2455312 2455312 defendant Michell Henry gent 606860 606860 Michell, Henry, of Flore, gent 0
5339331 2456877 2456877 defendant Heythley John laborer 606860 606860 Heythley, John, of Flore, laborer 0
5339332 2456877 2456877 defendant Preston John laborer 606860 606860 Preston, John, of Flore, laborer 1
5339333 2456877 2456877 defendant Bastoke Ralph laborer 606860 606860 Bastoke, Ralph, of Flore, laborer 2
5339334 2456877 2456877 defendant Wheler John laborer 606860 606860 Wheler, John, of Flore, laborer 3
5339338 2456877 2456877 defendant Burgeys James laborer 606860 606860 Burgeys, James, of Flore, laborer 7
5497873 2504306 2504306 defendant Muscot William husbandman 606860 606860 Muscot, William, of Flore, husbandman 1
5497874 2504306 2504306 defendant Mason Henry husbandman 606860 606860 Mason, Henry, of Flore, husbandman 2
5497875 2504306 2504306 defendant Arkewryght alias Myller Robert yeoman 606860 606860 Arkewryght alias Myller, Robert, of Flore, yeoman 3
5506105 2506828 2506828 defendant Kent John yeoman 606860 606860 Kent, John, of Flore, yeoman 2
5626857 2552374 2552374 defendant Stanbrygge John husbandman 606860 606860 Stanbrygge, John, of Flore, husbandman 0
5633243 2554404 2554404 defendant Fylle John husbandman 606860 606860 Fylle, John, of Flore, husbandman 0
5633244 2554404 2554404 defendant Tommesson John husbandman 606860 606860 Tommesson, John, of Flore, husbandman 1
5633245 2554404 2554404 defendant Fylle Thomas husbandman 606860 606860 Fylle, Thomas, of Flore, husbandman 2
5633246 2554404 2554404 defendant Fylle William husbandman 606860 606860 Fylle, William, of Flore, husbandman 3
5633247 2554404 2554404 defendant Fylle Richard husbandman 606860 606860 Fylle, Richard, of Flore, husbandman 4
5633248 2554404 2554404 defendant Sterre John husbandman 606860 606860 Sterre, John, of Flore, husbandman 5
5633249 2554404 2554404 defendant Laye William husbandman 606860 606860 Laye, William, of Flore, husbandman 6
5633250 2554404 2554404 defendant Werley Thomas husbandman 606860 606860 Werley, Thomas, of Flore, husbandman 7

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