names

122 rows where place_id = 602796

✎ 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
3651811 1910925 1910925 defendant Syre William gent 602796 602796 Syre, William, of Dunham, gent 1
3656592 1912316 1912316 defendant Cave William butcher 602796 602796 Cave, William, of Dunham, butcher 0
3710664 1929656 1929656 defendant Woodcok John husbandman 602796 602796 Woodcok, John, of Dunham, husbandman 1
3711987 1930067 1930067 defendant Marham Richard husbandman 602796 602796 Marham, Richard, of Dunham, husbandman 0
3718170 1931968 1931968 defendant Frost Adam carpenter 602796 602796 Frost, Adam, of Dunham, carpenter 4
3731328 1936020 1936020 defendant Cutler Thomas baker 602796 602796 Cutler, Thomas, of Dunham, baker 1
3736701 1937731 1937731 defendant Baldyng John husbandman 602796 602796 Baldyng, John, of Dunham, husbandman 0
3752250 1942626 1942626 defendant Spencer John yeoman 602796 602796 Spencer, John, of Dunham, yeoman 2
3770419 1948425 1948425 defendant Dey Richard husbandman 602796 602796 Dey, Richard, of Dunham, husbandman 0
3786658 1953621 1953621 defendant Walman Thomas laborer 602796 602796 Walman, Thomas, of Dunham, laborer 2
3802076 1958545 1958545 defendant Hollonde Richard yeoman 602796 602796 Hollonde, Richard, of Dunham, yeoman 4
3817232 1963304 1963304 defendant Blomfeld George husbandman 602796 602796 Blomfeld, George, of Dunham, husbandman 6
3848860 1973234 1973234 defendant Blomfeld George husbandman 602796 602796 Blomfeld, George, of Dunham, husbandman 1
3901768 1990814 1990814 defendant Woode William husbandman 602796 602796 Woode, William, of Dunham, husbandman 1
3903958 1991562 1991562 defendant Alpe Thomas gent 602796 602796 Alpe, Thomas, of Dunham, gent 0
3927161 1999419 1999419 defendant Blomfeld George yeoman 602796 602796 Blomfeld, George, of Dunham, yeoman 1
3927167 1999420 1999420 defendant Blomfeld George yeoman 602796 602796 Blomfeld, George, of Dunham, yeoman 1
3933201 2001399 2001399 defendant Warde John laborer 602796 602796 Warde, John, of Dunham, laborer 3
3966734 2012998 2012998 defendant Kocket William yeoman 602796 602796 Kocket, William, of Dunham, yeoman 2
4001034 2025144 2025144 defendant Blomfyld William husbandman 602796 602796 Blomfyld, William, of Dunham, husbandman 0
4015836 2030349 2030349 defendant Bennett William husbandman 602796 602796 Bennett, William, of Dunham, husbandman 0
4015838 2030350 2030350 defendant Bennett William husbandman 602796 602796 Bennett, William, of Dunham, husbandman 0
4015839 2030350 2030350 defendant Clarson William cooper 602796 602796 Clarson, William, of Dunham, cooper 1
4024757 2033537 2033537 defendant Stafford Humphrey sherman 602796 602796 Stafford, Humphrey, of Dunham, sherman 0
4064879 2047724 2047724 defendant Booth William   602796 602796 Booth, William, of Dunham, knight 1
4106523 2062622 2062622 defendant Blomefeld William yeoman 602796 602796 Blomefeld, William, of Dunham, yeoman 0
4129923 2071013 2071013 defendant Stafforde Humphrey yeoman 602796 602796 Stafforde, Humphrey, of Dunham, yeoman 0
4133026 2072140 2072140 defendant Harryson Hames clerk 602796 602796 Harryson, Hames, of Dunham, clerk 1
4247551 2112169 2112169 defendant Barker Robert yeoman 602796 602796 Barker, Robert, of Dunham, yeoman 1
4247555 2112170 2112170 defendant Barker Robert yeoman 602796 602796 Barker, Robert, of Dunham, yeoman 1
4284793 2124608 2124608 defendant Norton Robert yeoman 602796 602796 Norton, Robert, of Dunham, yeoman 1
4319509 2136936 2136936 defendant Braddenham Oswald husbandman 602796 602796 Braddenham, Oswald, of Dunham, husbandman 3
4323632 2138319 2138319 defendant Markham Jervase esq 602796 602796 Markham, Jervase, of Dunham, esq 0
4346414 2146001 2146001 defendant Norton John husbandman 602796 602796 Norton, John, of Dunham, husbandman 3
4370580 2154528 2154528 defendant Howytt Henry yeoman 602796 602796 Howytt, Henry, of Dunham, yeoman 0
4374165 2155834 2155834 defendant Howell Henry yeoman 602796 602796 Howell, Henry, of Dunham, yeoman 1
4395515 2163082 2163082 defendant Barker Robert yeoman 602796 602796 Barker, Robert, of Dunham, yeoman 2
4417680 2170409 2170409 plaintiff Stagg Lawrence   602796 602796 Stagg, Lawrence, of Dunham 0
4428175 2173643 2173643 defendant White Robert le (legal representative) 602796 602796 White, Robert le, of Dunham, executrix of 0
4428176 2173643 2173643 defendant White Alice le   602796 602796 White, Alice le, of Dunham, formerly wife of Robert 1
4437982 2181196 2181196 defendant Soureby Thomas   602796 602796 Soureby, Thomas, of Dunham 5
4437986 2181197 2181197 defendant Soureby Thomas   602796 602796 Soureby, Thomas, of Dunham 2
4446232 2183733 2183733 plaintiff Dawe Robert   602796 602796 Dawe, Robert, of Dunham 0
4462873 2189079 2189079 defendant Davy William   602796 602796 Davy, William, of Dunham 0
4472089 2191935 2191935 plaintiff Clerk John   602796 602796 Clerk, John, of Dunham 0
4490737 2197803 2197803 defendant Staunton William   602796 602796 Staunton, William, of Dunham 0
4530526 2209845 2209845 plaintiff Olyve Thomas   602796 602796 Olyve, Thomas, of Dunham 0
4538221 2212241 2212241 defendant Wryght John   602796 602796 Wryght, John, of Dunham 0
4540533 2212936 2212936 defendant Melkes Thomas   602796 602796 Melkes, Thomas, of Dunham 1
4559025 2218783 2218783 plaintiff Ropere Roger   602796 602796 Ropere, Roger, of Dunham 2
4580295 2225318 2225318 defendant Seeme Hugh   602796 602796 Seeme, Hugh, of Dunham 0
4580296 2225318 2225318 defendant Forsete William   602796 602796 Forsete, William, of Dunham 1
4580297 2225318 2225318 defendant Bakster Richard   602796 602796 Bakster, Richard, of Dunham 2
4583688 2226314 2226314 plaintiff Fuller William (legal representative) 602796 602796 Fuller, William, of Dunham, executors of 0
4591426 2228673 2228673 defendant Monk William   602796 602796 Monk, William, of Dunham 1
4635663 2242002 2242002 defendant Cavell or Canell Thomas   602796 602796 Cavell or Canell, Thomas, of Dunham 3
4681804 2259920 2259920 plaintiff Milveton Matilda   602796 602796 Milveton, Matilda, of Dunham, formerly wife of John Milveton 0
4682951 2260283 2260283 plaintiff Othehull Lawrence   602796 602796 Othehull, Lawrence, of Dunham 0
4698063 2264881 2264881 plaintiff Couper Thomas   602796 602796 Couper, Thomas, of Dunham 0
4699434 2265281 2265281 defendant Smyth Thomas yeoman 602796 602796 Smyth, Thomas, of Dunham, yeoman 0
4700885 2265679 2265679 plaintiff Forsett Thomas   602796 602796 Forsett, Thomas, of Dunham 0
4707094 2267604 2267604 plaintiff Maundevyle Henry   602796 602796 Maundevyle, Henry, of Dunham 0
4714990 2270017 2270017 plaintiff Tynton Thomas   602796 602796 Tynton, Thomas, of Dunham, vicar 0
4716084 2270338 2270338 defendant Fowne Thomas   602796 602796 Fowne, Thomas, of Dunham, bailiff 0
4727222 2273774 2273774 defendant Matyne John husbandman 602796 602796 Matyne, John, of Dunham, husbandman 3
4729881 2274551 2274551 defendant Calowe William husbandman 602796 602796 Calowe, William, of Dunham, husbandman 3
4730274 2274672 2274672 defendant Calawe William yeoman 602796 602796 Calawe, William, of Dunham, yeoman 2
4731699 2275107 2275107 defendant Calale Wilaim yeoman 602796 602796 Calale, Wilaim, of Dunham, yeoman 6
4731700 2275107 2275107 defendant Page William fishmonger 602796 602796 Page, William, of Dunham, fishmonger 7
4738006 2276991 2276991 plaintiff Forset Thomas   602796 602796 Forset, Thomas, of Dunham 1
4739087 2277316 2277316 defendant Pyhilipson John husbandman 602796 602796 Pyhilipson, John, of Dunham, husbandman 1
4755415 2282076 2282076 plaintiff atte Water Richard (legal representative) 602796 602796 atte Water, Richard, of Dunham, vicar, executors of 0
4755416 2282076 2282076 plaintiff Forsette Thomas   602796 602796 (Forsette, Thomas, of Dunham 1
4762413 2284230 2284230 plaintiff Forsette Thomas   602796 602796 Forsette, Thomas, of Dunham 0
4769236 2286357 2286357 defendant Forset Thomas gent 602796 602796 Forset, Thomas, of Dunham, gent 0
4775706 2288398 2288398 defendant Philipson John husbandman 602796 602796 Philipson, John, of Dunham, husbandman 1
4775707 2288398 2288398 defendant Silston Thomas smith 602796 602796 Silston, Thomas, of Dunham, smith 2
4781787 2290319 2290319 defendant Santon or Sauton Richard mercer 602796 602796 Santon or Sauton, Richard, of Dunham, mercer 0
4785991 2291658 2291658 plaintiff Forsette Thomas   602796 602796 Forsette, Thomas, of Dunham 0
4785994 2291659 2291659 plaintiff Forsette Thomas   602796 602796 Forsette, Thomas, of Dunham 0
4804964 2297757 2297757 defendant Kendale John husbandman 602796 602796 Kendale, John, of Dunham, husbandman 1
4809620 2299172 2299172 defendant Spaldyng William husbandman 602796 602796 Spaldyng, William, of Dunham, husbandman 0
4818300 2301803 2301803 defendant Harry William   602796 602796 Harry, William, of Dunham, wright 0
4835858 2307202 2307202 defendant Othehill (illegible) husbandman 602796 602796 Othehill, _, of Dunham, husbandman 1
4842575 2309214 2309214 defendant Silkeston Thomas husbandman 602796 602796 Silkeston, Thomas, of Dunham, husbandman 1
4843828 2309590 2309590 defendant Braunspath John gent 602796 602796 Braunspath, John, of Dunham, gent 0
4843829 2309590 2309590 defendant Braunspath Thomas gent 602796 602796 Braunspath, Thomas, of Dunham, gent 1
4843830 2309590 2309590 defendant Cavell or Canell Thomas chapman 602796 602796 Cavell or Canell, Thomas, of Dunham, chapman 2
4869036 2317286 2317286 defendant Moreby John gent 602796 602796 Moreby, John, of Dunham, gent 0
4869203 2317341 2317341 defendant of the Hill John yeoman 602796 602796 of the Hill, John, of Dunham, yeoman 8
4871233 2317978 2317978 defendant Braunspath John gent 602796 602796 Braunspath, John, of Dunham, gent 0
4871234 2317978 2317978 defendant Braunspath Thomas gent 602796 602796 Braunspath, Thomas, of Dunham, gent 1
4871235 2317978 2317978 defendant Canell or Cavell Thomas chapman 602796 602796 Canell or Cavell, Thomas, of Dunham, chapman 2
4872124 2318243 2318243 defendant Holme John walker 602796 602796 Holme, John, of Dunham, walker 0
4875417 2319268 2319268 defendant Welton John husbandman 602796 602796 Welton, John, of Dunham, husbandman 0
4888420 2323177 2323177 defendant Coupere Henry yeoman 602796 602796 Coupere, Henry, of Dunham, yeoman 1
4931470 2336223 2336223 defendant Pege Robert chaplain 602796 602796 Pege, Robert, of Dunham, chaplain 0
4951390 2342396 2342396 defendant Buk John husbandman 602796 602796 Buk, John, of Dunham, husbandman 2
4954649 2343348 2343348 defendant Porter John yeoman 602796 602796 Porter, John, of Dunham, yeoman 1
4954650 2343348 2343348 defendant Clerke John yeoman 602796 602796 Clerke, John, of Dunham, yeoman 2

Next page

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