names

124 rows where place_id = 619528

✎ 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
3730413 1935744 1935744 defendant Slyght Thomas fisher 619528 619528 Slyght, Thomas, of Sybsey, fisher 1
3730420 1935745 1935745 defendant Slyght Thomas fisher 619528 619528 Slyght, Thomas, of Sybsey, fisher 3
3750292 1942008 1942008 defendant Thakker William husbandman 619528 619528 Thakker, William, of Sybsey, husbandman 0
3768119 1947664 1947664 defendant Came George yeoman 619528 619528 Came, George, of Sybsey, yeoman 0
3768121 1947665 1947665 defendant Cayme George yeoman 619528 619528 Cayme, George, of Sybsey, yeoman 0
3786613 1953609 1953609 defendant Leke Christopher gent 619528 619528 Leke, Christopher, of Sybsey, gent 0
3869822 1980152 1980152 plaintiff West James yeoman 619528 619528 West, James, of Sybsey, yeoman 0
3869823 1980152 1980152 defendant West Alexander yeoman 619528 619528 West, Alexander, of Sybsey, yeoman 0
3921144 1997424 1997424 defendant West James yeoman 619528 619528 West, James, of Sybsey, yeoman 0
3929762 2000293 2000293 defendant Cole Alan husbandman 619528 619528 Cole, Alan, of Sybsey, husbandman 0
3993219 2022319 2022319 defendant Valentyne Richard husbandman 619528 619528 Valentyne, Richard, of Sybsey, husbandman 1
4001739 2025398 2025398 defendant Thacker William yeoman 619528 619528 Thacker, William, of Sybsey, yeoman 0
4044069 2040331 2040331 defendant Turpyn Richard husbandman 619528 619528 Turpyn, Richard, of Sybsey, husbandman 0
4048641 2041963 2041963 plaintiff Thorne Richard gent 619528 619528 Thorne, Richard, of Sybsey, gent 0
4066257 2048221 2048221 plaintiff Battes John husbandman 619528 619528 Battes, John, of Sybsey, husbandman 2
4139021 2074327 2074327 defendant Smyth John carpenter 619528 619528 Smyth, John, of Sybsey, carpenter 0
4139022 2074327 2074327 defendant Baldocke Henry carpenter 619528 619528 Baldocke, Henry, of Sybsey, carpenter 1
4173767 2086281 2086281 defendant Lightfote Thomas husbandman 619528 619528 together with Lightfote, Thomas, of Sybsey, husbandman 1
4190008 2092007 2092007 defendant Stapleton Robert yeoman 619528 619528 Stapleton, Robert, of Sybsey, yeoman 1
4209168 2098758 2098758 defendant Yaxley William, junior gent 619528 619528 Yaxley, William, junior, of Sybsey, gent 0
4233822 2107355 2107355 defendant Fawkner Christopher yeoman 619528 619528 Fawkner, Christopher, of Sybsey, yeoman 0
4236977 2108512 2108512 defendant Thakker Christopher yeoman 619528 619528 Thakker, Christopher, of Sybsey, yeoman 0
4277382 2122011 2122011 defendant Falkener Christopher yeoman 619528 619528 Falkener, Christopher, of Sybsey, yeoman 1
4277385 2122012 2122012 defendant Valentyne Robert yeoman 619528 619528 Valentyne, Robert, of Sybsey, yeoman 0
4277386 2122012 2122012 defendant West John yeoman 619528 619528 West, John, of Sybsey, yeoman 1
4279341 2122700 2122700 defendant Parlebeane Thomas yeoman 619528 619528 Parlebeane, Thomas, of Sybsey, yeoman 0
4283549 2124155 2124155 defendant Draper Robert, senior husbandman 619528 619528 Draper, Robert, senior, of Sybsey, husbandman 0
4283557 2124157 2124157 defendant Clarke John, junior yeoman 619528 619528 Clarke, John, junior, of Sybsey, yeoman 1
4322520 2137944 2137944 defendant Phillipp John husbandman 619528 619528 Phillipp, John, of Sybsey, husbandman 0
4360690 2150992 2150992 defendant Fawkner Christopher yeoman 619528 619528 Fawkner, Christopher, of Sybsey, yeoman 1
4376432 2156640 2156640 defendant Pyshye Robert husbandman 619528 619528 Pyshye, Robert, of Sybsey, husbandman 0
4506082 2202416 2202416 defendant Hagon John   619528 619528 Hagon, John, of Sybsey, senior 0
4533264 2210662 2210662 defendant Kemp William   619528 619528 Kemp, William, of Sybsey 0
4553547 2217039 2217039 defendant Scotte John   619528 619528 Scotte, John, of sybsey 0
4557985 2218431 2218431 plaintiff Leverton Walter   619528 619528 Leverton, Walter, of Sybsey 0
4579762 2225156 2225156 defendant Balle John   619528 619528 Balle, John, of Sybsey 0
4600657 2231433 2231433 defendant Ball John   619528 619528 Ball, John, of Sybsey 0
4615918 2235976 2235976 defendant Redy Stephen   619528 619528 Redy, Stephen, of Sybsey 0
4621539 2237726 2237726 defendant Walnot John   619528 619528 Walnot, John, of Sybsey 0
4655308 2247548 2247548 defendant Walles Maud widow of William Walles 619528 619528 Walles, Maud, of Sybsey, brewster, widow of William Walles 1
4765006 2285030 2285030 defendant Enderby John   619528 619528 Enderby, John, of Sybsey, vicar 1
4795951 2294880 2294880 defendant Neweham William husbandman 619528 619528 Neweham, William, of Sybsey, husbandman 0
4795953 2294880 2294880 defendant Welle William   619528 619528 Welle, William, of Sybsey, groom 2
4808767 2298910 2298910 defendant Overey John husbandman 619528 619528 Overey, John, of Sybsey, husbandman 0
4822836 2303225 2303225 defendant Enderby John clerk 619528 619528 Enderby, John, of Sybsey, clerk 0
4835432 2307077 2307077 defendant Walnet John husbandman 619528 619528 Walnet, John, of Sybsey, husbandman 2
4837140 2307568 2307568 defendant Byllyngay Thomas husbandman 619528 619528 Byllyngay, Thomas, of Sybsey, husbandman 1
4839394 2308243 2308243 defendant Jowetson Alan husbandman 619528 619528 together with Jowetson, Alan, of Sybsey, husbandman 5
4839398 2308243 2308243 defendant Overey John carpenter 619528 619528 Overey, John, of Sybsey, carpenter 9
4847438 2310702 2310702 defendant Danson Thomas husbandman 619528 619528 Danson, Thomas, of Sybsey, husbandman 0
4857819 2313815 2313815 defendant Slye Robert husbandman 619528 619528 Slye, Robert, of Sybsey, husbandman 3
4857820 2313815 2313815 defendant Mayre Robert husbandman 619528 619528 Mayre, Robert, of Sybsey, husbandman 4
4863159 2315455 2315455 defendant Jowetson Alan laborer 619528 619528 Jowetson, Alan, of Sybsey, laborer 0
4863160 2315455 2315455 defendant Jowetson John laborer 619528 619528 Jowetson, John, of Sybsey, laborer 1
4903099 2327583 2327583 defendant Dyconson alias Jonson Henry husbandman 619528 619528 Dyconson alias Jonson, Henry, of Sybsey, or of Thorp juxta Waynflet, husbandman 0
4951182 2342333 2342333 defendant Fauconer William smith 619528 619528 Fauconer, William, of Sybsey, smith 0
4955314 2343544 2343544 defendant Lyard Henry husbandman 619528 619528 Lyard, Henry, of Sybsey, husbandman 8
4955316 2343544 2343544 defendant Hode John husbandman 619528 619528 Hode, John, of Sybsey, husbandman 10
5009256 2359592 2359592 defendant Daudson Thomas husbandman 619528 619528 Daudson, Thomas, of Sybsey, husbandman 0
5010365 2359900 2359900 defendant West Thomas husbandman 619528 619528 West, Thomas, of Sybsey, husbandman 0
5035999 2367387 2367387 defendant Godebody Richard, junior husbandman 619528 619528 Godebody, Richard, junior, of Sybsey, husbandman 0
5036000 2367387 2367387 defendant Wormesley John husbandman 619528 619528 Wormesley, John, of Sybsey, husbandman 1
5058507 2374097 2374097 defendant Howse Gilbert husbandman 619528 619528 Howse, Gilbert, of Sybsey, husbandman 0
5059620 2374444 2374444 defendant Redy Robert husbandman 619528 619528 Redy, Robert, of Sybsey, husbandman 9
5081752 2381043 2381043 defendant of the House Gilbert thatcher 619528 619528 of the House, Gilbert, of Sybsey, thatcher 1
5083194 2381470 2381470 defendant Redy Robert husbandman 619528 619528 Redy, Robert, of Sybsey, husbandman 11
5121160 2392615 2392615 defendant Cotyngham Robert husbandman 619528 619528 Cotyngham, Robert, of Sybsey, husbandman 0
5125634 2393987 2393987 defendant Godebode John (legal representative) 619528 619528 Godebode, John, of Sybsey, husbandman, executor of 0
5125635 2393987 2393987 defendant Godebode Richard husbandman 619528 619528 Godebode, Richard, of Sybsey, husbandman 1
5126441 2394207 2394207 defendant Wyllyamson Robert gent 619528 619528 Wyllyamson, Robert, of Sybsey, gent 0
5128470 2394798 2394798 defendant Cotyngham Robert husbandman 619528 619528 Cotyngham, Robert, of Sybsey, husbandman 5
5144298 2399488 2399488 defendant Godebode John (legal representative) 619528 619528 Godebode, John, of Sybsey, husbandman, executor of 0
5144299 2399488 2399488 defendant Godebode Richard husbandman 619528 619528 Godebode, Richard, of Sybsey, husbandman 1
5144301 2399489 2399489 defendant Godebode John (legal representative) 619528 619528 Godebode, John, of Sybsey, husbandman, executor of 0
5144302 2399489 2399489 defendant Godebode Richard husbandman 619528 619528 Godebode, Richard, of Sybsey, husbandman 1
5145117 2399712 2399712 defendant Willyamson Robert gent 619528 619528 Willyamson, Robert, of Sybsey, gent 0
5146773 2400199 2400199 defendant Godebody William husbandman 619528 619528 Godebody, William, of Sybsey, husbandman 1
5147569 2400428 2400428 defendant Cotyngham Robert husbandman 619528 619528 Cotyngham, Robert, of Sybsey, husbandman 5
5151145 2401475 2401475 defendant Chapell John chaplain & vicar 619528 619528 Chapell, John, of Sybsey, chaplain & vicar 0
5161139 2404356 2404356 defendant Clerk Robert laborer 619528 619528 Clerk, Robert, of Sybsey, laborer 2
5163047 2404919 2404919 defendant Walyssh Mathew husbandman 619528 619528 Walyssh, Mathew, of Sybsey, husbandman 0
5163048 2404919 2404919 defendant Clerk Geoffrey husbandman 619528 619528 Clerk, Geoffrey, of Sybsey, husbandman 1
5165700 2405711 2405711 defendant Willyamson Robert gent 619528 619528 Willyamson, Robert, of Sybsey, gent 0
5166747 2406000 2406000 defendant Gadebody William husbandman 619528 619528 Gadebody, William, of Sybsey, husbandman 1
5167214 2406143 2406143 defendant Cotyngham Robert husbandman 619528 619528 Cotyngham, Robert, of Sybsey, husbandman 1
5169414 2406789 2406789 defendant Chapell John chaplain & vicar 619528 619528 Chapell, John, of Sybsey, chaplain & vicar 0
5175636 2408559 2408559 defendant Clerk Robert laborer 619528 619528 Clerk, Robert, of Sybsey, laborer 1
5177260 2409042 2409042 defendant Walyssh Mathew husbandman 619528 619528 Walyssh, Mathew, of Sybsey, husbandman 0
5177261 2409042 2409042 defendant Clerk Geoffrey husbandman 619528 619528 Clerk, Geoffrey, of Sybsey, husbandman 1
5180050 2409901 2409901 defendant Wyllyamson Robert gent 619528 619528 Wyllyamson, Robert, of Sybsey, gent 0
5182545 2410646 2410646 defendant Cotyngham Robert husbandman 619528 619528 Cotyngham, Robert, of Sybsey, husbandman 1
5186105 2411687 2411687 defendant Chapell John chaplain & vicar 619528 619528 Chapell, John, of Sybsey, chaplain & vicar 0
5198978 2415453 2415453 defendant Busshe Thomas husbandman 619528 619528 Busshe, Thomas, of Sybsey, husbandman 0
5200162 2415801 2415801 defendant Walyssh Mathewe husbandman 619528 619528 Walyssh, Mathewe, of Sybsey, husbandman 0
5200163 2415801 2415801 defendant Clerk Geoffrey husbandman 619528 619528 Clerk, Geoffrey, of Sybsey, husbandman 1
5217209 2420769 2420769 defendant Walys Mathew husbandman 619528 619528 Walys, Mathew, of Sybsey, husbandman 0
5249494 2429964 2429964 defendant Williamson Stephen yeoman 619528 619528 Williamson, Stephen, of Sybsey, yeoman 0
5256984 2432314 2432314 defendant Walys Mathew husbandman 619528 619528 Walys, Mathew, of Sybsey, husbandman 7
5260531 2433428 2433428 defendant Tallour Walter husbandman 619528 619528 Tallour, Walter, of Sybsey, husbandman 0
5264841 2434762 2434762 defendant Colle John husbandman 619528 619528 Colle, John, of Sybsey, husbandman 8

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