names

83 rows where place_id = 592075

✎ 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
3606480 1869698 1869698 defendant Jekes William gent 592075 592075 Jekes, William, of Tomworth, gent 0
3617167 1872994 1872994 defendant Milles Henry weaver 592075 592075 Milles, Henry, of Tomworth, weaver 1
3677063 1918865 1918865 defendant Walden John dyer 592075 592075 Walden, John, of Tomworth, dyer 1
3684141 1921176 1921176 defendant Andertn Gunn husbandman 592075 592075 Andertn, Gunn, of Tomworth, husbandman 1
3707439 1928621 1928621 defendant Harwell John husbandman 592075 592075 Harwell, John, of Tomworth, husbandman 0
3714364 1930791 1930791 defendant Praty Robert husbandman 592075 592075 Praty, Robert, of Tomworth, husbandman 0
3721130 1932906 1932906 defendant Walden John dyer 592075 592075 Walden, John, of Tomworth, dyer 0
3756207 1943899 1943899 defendant Wheyham Oliver husbandman 592075 592075 Wheyham, Oliver, of Tomworth, husbandman 0
3764684 1946617 1946617 defendant Dixson Richard laborer 592075 592075 Dixson, Richard, of Tomworth, laborer 0
3790312 1954788 1954788 defendant Hertill John chapman 592075 592075 Hertill, John, of Tomworth, chapman 1
3835281 1968975 1968975 defendant Ensore Humphrey husbandman 592075 592075 Ensore, Humphrey, of Tomworth, husbandman 0
3835282 1968975 1968975 defendant Howgh Robert butcher 592075 592075 Howgh, Robert, of Tomworth, butcher 1
3836509 1969326 1969326 defendant Ferrers Edward gent 592075 592075 Ferrers, Edward, of Tomworth, gent 1
3836510 1969326 1969326 defendant Bowade Thomas yeoman 592075 592075 Bowade, Thomas, of Tomworth, yeoman 2
3836511 1969326 1969326 defendant Grewe Thomas yeoman 592075 592075 Grewe, Thomas, of Tomworth, yeoman 3
3836512 1969326 1969326 defendant Warde Elias yeoman 592075 592075 Warde, Elias, of Tomworth, yeoman 4
3836513 1969326 1969326 defendant Lee Thomas yeoman 592075 592075 Lee, Thomas, of Tomworth, yeoman 5
3836514 1969326 1969326 defendant Darlaston John yeoman 592075 592075 Darlaston, John, of Tomworth, yeoman 6
3836515 1969326 1969326 defendant Pereson William husbandman 592075 592075 Pereson, William, of Tomworth, husbandman 7
3852590 1974418 1974418 defendant Ferrers Edward gent 592075 592075 Ferrers, Edward, of Tomworth, gent 1
3852591 1974418 1974418 defendant Bowarde Thomas yeoman 592075 592075 Bowarde, Thomas, of Tomworth, yeoman 2
3852592 1974418 1974418 defendant Grewe Thomas yeoman 592075 592075 Grewe, Thomas, of Tomworth, yeoman 3
3852593 1974418 1974418 defendant Wardeley Elias yeoman 592075 592075 Wardeley, Elias, of Tomworth, yeoman 4
3852594 1974418 1974418 defendant Lee Thomas yeoman 592075 592075 Lee, Thomas, of Tomworth, yeoman 5
3852595 1974418 1974418 defendant Darlaston John yeoman 592075 592075 Darlaston, John, of Tomworth, yeoman 6
3852596 1974418 1974418 defendant Pereson William husbandman 592075 592075 Pereson, William, of Tomworth, husbandman 7
3922354 1997792 1997792 defendant Endesore or Gudesore Thomas yeoman 592075 592075 Endesore or Gudesore, Thomas, of Tomworth, yeoman 0
4474390 2192644 2192644 defendant Taillour John   592075 592075 Taillour, John, of Tomworth 0
4504535 2201977 2201977 plaintiff Sadeler John   592075 592075 Sadeler, John, of Tomworth 0
4570018 2222195 2222195 defendant Barker Philip   592075 592075 Barker, Philip, of Tomworth 0
4570019 2222195 2222195 defendant Skynner William   592075 592075 Skynner, William, of Tomworth 1
4570020 2222195 2222195 defendant Lyne John   592075 592075 Lyne, John, of Tomworth 2
4592896 2229106 2229106 defendant Taillour John (legal representative) 592075 592075 Taillour, John, of Tomworth, executors of 0
4594342 2229487 2229487 defendant Crowenhale John   592075 592075 Crowenhale, John, of Tomworth 0
4740627 2277776 2277776 plaintiff Bate Robert   592075 592075 Bate, Robert, of Tomworth 0
4740630 2277777 2277777 plaintiff Bate Robert   592075 592075 Bate, Robert, of Tomworth 0
4740633 2277778 2277778 plaintiff Bate Robert   592075 592075 Bate, Robert, of Tomworth 0
4740636 2277779 2277779 plaintiff Bate Robert   592075 592075 Bate, Robert, of Tomworth 0
4749512 2280337 2280337 defendant Freman Hugh merchant 592075 592075 Freman, Hugh, of Tomworth, merchant 0
4823565 2303462 2303462 defendant Coke William baker 592075 592075 Coke, William, of Tomworth, baker 0
4823566 2303462 2303462 defendant Russell John draper 592075 592075 Russell, John, of Tomworth, draper 1
4861940 2315113 2315113 plaintiff Danyell Ralph   592075 592075 Danyell, Ralph, of Tomworth 0
4869241 2317346 2317346 defendant Danyell Ralph husbandman 592075 592075 Danyell, Ralph, of Tomworth, husbandman 0
4869242 2317346 2317346 defendant Danyell John husbandman 592075 592075 Danyell, John, of Tomworth, husbandman 1
4887313 2322867 2322867 defendant Pacworth Henry dyer 592075 592075 Pacworth, Henry, of Tomworth, dyer 3
4914073 2330911 2330911 defendant Wirley John husbandman 592075 592075 Wirley, John, of Tomworth, husbandman 0
4914074 2330911 2330911 defendant Wirley Walter butcher 592075 592075 Wirley, Walter, of Tomworth, butcher 1
4914075 2330911 2330911 defendant Danyell William butcher 592075 592075 Danyell, William, of Tomworth, butcher 2
4914076 2330911 2330911 defendant Taillour William tailor 592075 592075 Taillour, William, of Tomworth, tailor 3
4914077 2330911 2330911 defendant Coton Thomas goldbether or gold beater 592075 592075 Coton, Thomas, of Tomworth, goldbether or gold beater 4
4914078 2330911 2330911 defendant Turgys Richard chaplain 592075 592075 Turgys, Richard, of Tomworth, chaplain 5
4914079 2330911 2330911 defendant May Richard chaplain 592075 592075 May, Richard, of Tomworth, chaplain 6
4924497 2334100 2334100 defendant Broun Thomas grasier 592075 592075 Broun, Thomas, of Tomworth, grasier 2
4925482 2334404 2334404 defendant Blyke Alexander collier 592075 592075 Blyke, Alexander, of Tomworth, collier 1
4925483 2334404 2334404 defendant craweley Thomas husbandman 592075 592075 craweley, Thomas, of Tomworth, husbandman 2
4956376 2343872 2343872 defendant Smyth Nicholas smith 592075 592075 Smyth, Nicholas, of Tomworth, smith 0
4956377 2343872 2343872 defendant Couper Henry yeoman 592075 592075 Couper, Henry, of Tomworth, yeoman 1
4969321 2347783 2347783 defendant Baylly John hosier 592075 592075 Baylly, John, of Tomworth, hosier 4
4983387 2351939 2351939 defendant Bailly John hosier 592075 592075 Bailly, John, of Tomworth, hosier 0
4983388 2351939 2351939 defendant Baully Nicholas husbandman 592075 592075 Baully, Nicholas, of Tomworth, husbandman 1
4983389 2351939 2351939 defendant Chaumberleyn Walter tailor 592075 592075 Chaumberleyn, Walter, of Tomworth, tailor 2
4984284 2352224 2352224 defendant Bailly John draper 592075 592075 Bailly, John, of Tomworth, draper 1
5071656 2378015 2378015 defendant Nuntyng Richard weaver 592075 592075 Nuntyng, Richard, of Tomworth, weaver 1
5071657 2378015 2378015 defendant Spenser Nicholas baker 592075 592075 Spenser, Nicholas, of Tomworth, baker 2
5313499 2449066 2449066 defendant Waren Alice widow 592075 592075 Waren, Alice, of Tomworth, widow 2
5387269 2471432 2471432 defendant Waryng Thomas gent 592075 592075 Waryng, Thomas, of Tomworth, gent 3
5428017 2483334 2483334 defendant Burgeys John   592075 592075 Burgeys, John, of Tomworth, wright 0
5428019 2483334 2483334 defendant Lawe Robert shoemaker 592075 592075 Lawe, Robert, of Tomworth, shoemaker 2
5428020 2483334 2483334 defendant Symond Nicholas sadler 592075 592075 Symond, Nicholas, of Tomworth, sadler 3
5445551 2488567 2488567 defendant Lawe Robert shoemaker 592075 592075 Lawe, Robert, of Tomworth, shoemaker 2
5458334 2492389 2492389 defendant Lawe Robert shoemaker 592075 592075 Lawe, Robert, of Tomworth, shoemaker 2
5458337 2492390 2492390 defendant Burgeys John   592075 592075 Burgeys, John, of Tomworth, wright 0
5469969 2495941 2495941 defendant Burgeys John baker 592075 592075 Burgeys, John, of Tomworth, wright, together with Alkyn, John, of Tomworth, Warws, baker 0
5469970 2495941 2495941 defendant Lawe Robert shoemaker 592075 592075 Lawe, Robert, of Tomworth, shoemaker 1
5469971 2495941 2495941 defendant Seymond Nicholas sadler 592075 592075 Seymond, Nicholas, of Tomworth, sadler 2
5492521 2502675 2502675 defendant Drake Thomas (legal representative) 592075 592075 Drake, Thomas, of Tomworth, yeoman, executrix of 3
5492522 2502675 2502675 defendant Drake Isabel widow 592075 592075 Drake, Isabel, of Tomworth, widow 4
5492527 2502676 2502676 defendant Drake Thomas (legal representative) 592075 592075 Drake, Thomas, of Tomworth, yeoman, executrix of 3
5492528 2502676 2502676 defendant Drake Isabel widow 592075 592075 (Drake, Isabel, of Tomworth, widow 4
5543425 2518062 2518062 defendant Dorlaston Nicholas yeoman 592075 592075 Dorlaston, Nicholas, of Tomworth, yeoman 0
5543426 2518062 2518062 defendant Peroth John baker 592075 592075 Peroth, John, of Tomworth, baker 1
5567739 2525138 2525138 defendant Dyxson Richard (legal representative) 592075 592075 Dyxson, Richard, of Tomworth, yeoman, executrix of 0
5621294 2550550 2550550 plaintiff Staunford John   592075 592075 Staunford, John, of Tomworth 0

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