names

141 rows where place_id = 604829

✎ 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
3659410 1913204 1913204 defendant Ewest Robert draper 604829 604829 Ewest, Robert, of Great Grymesby, draper 0
3666088 1915336 1915336 defendant Johnson Robert carpenter 604829 604829 Johnson, Robert, of Great Grymesby, carpenter 0
3906912 1992600 1992600 plaintiff Myffyn Philip (legal representative) 604829 604829 Myffyn, Philip, of Great Grymesby, alderman, executors of 0
3906915 1992601 1992601 plaintiff Myffyn Philip (legal representative) 604829 604829 Myffyn, Philip, of Great Grymesby, alderman, executors of 0
4495298 2199207 2199207 plaintiff Bynbroke John de   604829 604829 Bynbroke, John de, of Great Grymesby 0
4566045 2220937 2220937 defendant Covenham John de   604829 604829 Covenham, John de, of Great Grymesby, burgess 0
4684708 2260819 2260819 plaintiff Randby John de   604829 604829 Randby, John de, of Great Grymesby 0
4696480 2264375 2264375 defendant Thornton Robert husbandman 604829 604829 Thornton, Robert, of Great Grymesby, husbandman 0
4738047 2277000 2277000 defendant Littester Adam dyer 604829 604829 Littester, Adam, of Great Grymesby, dyer 3
4742877 2278426 2278426 defendant Goldsmyth Peter chapman 604829 604829 Goldsmyth, Peter, of Great Grymesby, chapman 0
4760803 2283716 2283716 defendant Skendylby John butcher 604829 604829 Skendylby, John, of Great Grymesby, butcher 0
4764266 2284817 2284817 defendant Burton Henry shipman 604829 604829 Burton, Henry, of Great Grymesby, shipman 0
4767180 2285720 2285720 defendant Nyvery or Nynery John   604829 604829 Nyvery or Nynery, John, of Great Grymesby, wright 0
4769789 2286524 2286524 defendant Skendylby John butcher 604829 604829 Skendylby, John, of Great Grymesby, butcher 0
4852512 2312209 2312209 defendant (not given) William vicar of Fynche 604829 604829 Fynche, William, of Great Grymesby, vicar of the church of St James 0
4909292 2329448 2329448 defendant Skendelby John butcher 604829 604829 Skendelby, John, of Great Grymesby, butcher 0
4926310 2334654 2334654 defendant Auncell Robert merchant 604829 604829 Auncell, Robert, of Great Grymesby, merchant 0
4997720 2356173 2356173 defendant Pye Robert chaplain 604829 604829 Pye, Robert, of Great Grymesby, chaplain 5
4997721 2356173 2356173 defendant Manfeld Richard chapman 604829 604829 Manfeld, Richard, of Great Grymesby, chapman 6
5042423 2369341 2369341 defendant Dyon John weaver 604829 604829 Dyon, John, of Great Grymesby, weaver 1
5044083 2369858 2369858 defendant Broun William   604829 604829 with Broun, William, of Great Grymesby, "nethird" or net herd 1
5124675 2393692 2393692 plaintiff Afey Richard   604829 604829 Afey, Richard, of Great Grymesby 0
5124814 2393731 2393731 defendant Thomlynson Alan merchant 604829 604829 Thomlynson, Alan, of Great Grymesby, merchant 1
5124815 2393731 2393731 defendant Ladyman John mariner 604829 604829 Ladyman, John, of Great Grymesby, mariner 2
5124891 2393755 2393755 defendant Copes James chapman 604829 604829 Copes, James, of Great Grymesby, chapman 0
5125062 2393803 2393803 defendant Edon Jugh   604829 604829 Edon, Jugh, of Great Grymesby, burgess & merchant 0
5125064 2393803 2393803 defendant Grey William shipman 604829 604829 Grey, William, of Great Grymesby, shipman 2
5125065 2393803 2393803 defendant --ltham John weaver 604829 604829 --ltham, John, of Great Grymesby, weaver 3
5129978 2395256 2395256 defendant Brighton Thomas merchant 604829 604829 Brighton, Thomas, of Great Grymesby, merchant 0
5129980 2395256 2395256 defendant Copes James mariner 604829 604829 Copes, James, of Great Grymesby, mariner 2
5130100 2395291 2395291 defendant Duffeld William gent 604829 604829 Duffeld, William, of Great Grymesby, gent 0
5131342 2395657 2395657 plaintiff Gaunce Joan widow 604829 604829 Gaunce, Joan, of Great Grymesby, widow 0
5131343 2395657 2395657 plaintiff Gaunce John shipman 604829 604829 Gaunce, John, of Great Grymesby, shipman 1
5132443 2395983 2395983 defendant Brughton Thomas merchant 604829 604829 Brughton, Thomas, of Great Grymesby, merchant 7
5132444 2395983 2395983 defendant Sopys James mercer 604829 604829 Sopys, James, of Great Grymesby, mercer 8
5132445 2395983 2395983 defendant Graynesby John merchant 604829 604829 Graynesby, John, of Great Grymesby, merchant 9
5137175 2397385 2397385 defendant Swanland John tanner 604829 604829 Swanland, John, of Great Grymesby, tanner 0
5143374 2399202 2399202 defendant Thomlynson Alan merchant 604829 604829 Thomlynson, Alan, of Great Grymesby, merchant 1
5143375 2399202 2399202 defendant Ladyman John mariner 604829 604829 Ladyman, John, of Great Grymesby, mariner 2
5143377 2399202 2399202 defendant Benyngworth Thomas weaver 604829 604829 Benyngworth, Thomas, of Great Grymesby, weaver 4
5143677 2399285 2399285 defendant Edon Hugh   604829 604829 Edon, Hugh, of Great Grymesby, burgess & merchant 0
5143679 2399285 2399285 defendant Grey William shipman 604829 604829 Grey, William, of Great Grymesby, shipman 2
5143680 2399285 2399285 defendant Waltham John weaver 604829 604829 Waltham, John, of Great Grymesby, weaver 3
5144675 2399598 2399598 defendant Dove William butcher 604829 604829 Dove, William, of Great Grymesby, butcher 0
5144788 2399629 2399629 defendant Broun John carver 604829 604829 Broun, John, of Great Grymesby, carver 0
5149267 2400916 2400916 defendant Broughton Thomas merchant 604829 604829 Broughton, Thomas, of Great Grymesby, merchant 0
5149269 2400916 2400916 defendant Copes Jmaes mariner 604829 604829 Copes, Jmaes, of Great Grymesby, mariner 2
5149412 2400961 2400961 defendant Duffeld William gent 604829 604829 Duffeld, William, of Great Grymesby, gent 0
5149444 2400971 2400971 defendant Brughton Thomas merchant 604829 604829 Brughton, Thomas, of Great Grymesby, merchant 0
5149445 2400971 2400971 defendant Colby Robert carpenter 604829 604829 Colby, Robert, of Great Grymesby, carpenter 1
5149446 2400971 2400971 defendant Copes James mariner 604829 604829 Copes, James, of Great Grymesby, mariner 2
5154132 2402365 2402365 defendant Gaunce Joan widow 604829 604829 Gaunce, Joan, of Great Grymesby, widow 0
5154133 2402365 2402365 defendant Gaunce John shipman 604829 604829 Gaunce, John, of Great Grymesby, shipman 1
5154135 2402366 2402366 defendant Gaunce Joan widow 604829 604829 Gaunce, Joan, of Great Grymesby, widow 0
5154136 2402366 2402366 defendant Gaunce John shipman 604829 604829 Gaunce, John, of Great Grymesby, shipman 1
5156491 2403055 2403055 defendant Barbour Robert   604829 604829 Barbour, Robert, of Great Grymesby, wright 0
5156492 2403055 2403055 defendant Barret Henry   604829 604829 Barret, Henry, of Great Grymesby, wright 1
5161769 2404546 2404546 defendant Koke John   604829 604829 Koke, John, of Great Grymesby, glove maker 0
5163165 2404958 2404958 defendant Copes James chapman 604829 604829 Copes, James, of Great Grymesby, chapman 0
5164650 2405396 2405396 defendant Ladyman John mariner 604829 604829 Ladyman, John, of Great Grymesby, mariner 2
5164652 2405396 2405396 defendant Denyngworth Thomas weaver 604829 604829 Denyngworth, Thomas, of Great Grymesby, weaver 4
5164810 2405439 2405439 plaintiff Asby Richard   604829 604829 Asby, Richard, of Great Grymesby 0
5164819 2405442 2405442 defendant Edon Hugh   604829 604829 Edon, Hugh, of Great Grymesby, burgess & merchant 0
5164821 2405442 2405442 defendant Grey William shipman 604829 604829 Grey, William, of Great Grymesby, shipman 2
5164822 2405442 2405442 defendant Waltham John weaver 604829 604829 Waltham, John, of Great Grymesby, weaver 3
5165497 2405651 2405651 defendant Broun John carver 604829 604829 Broun, John, of Great Grymesby, carver 0
5165644 2405694 2405694 defendant Dove William butcher 604829 604829 Dove, William, of Great Grymesby, butcher 0
5168053 2406368 2406368 defendant Hobson Peter shipman 604829 604829 Hobson, Peter, of Great Grymesby, shipman 0
5168054 2406368 2406368 defendant Pelton Henry mariner 604829 604829 Pelton, Henry, of Great Grymesby, mariner 1
5171690 2407439 2407439 defendant Gaunce Joan widow 604829 604829 Gaunce, Joan, of Great Grymesby, widow 0
5171691 2407439 2407439 defendant Gaunce John shipman 604829 604829 Gaunce, John, of Great Grymesby, shipman 1
5172698 2407744 2407744 defendant Barbour Robert   604829 604829 Barbour, Robert, of Great Grymesby, wright 0
5172699 2407744 2407744 defendant Barret Henry   604829 604829 Barret, Henry, of Great Grymesby, wright 1
5176926 2408944 2408944 defendant Eden Hugh chapman & burgess 604829 604829 Eden, Hugh, of Great Grymesby, chapman & burgess 0
5176943 2408949 2408949 defendant Copes James chapman 604829 604829 Copes, James, of Great Grymesby, chapman 0
5177991 2409269 2409269 defendant Thomlynson Alan merchant 604829 604829 Thomlynson, Alan, of Great Grymesby, merchant 1
5177992 2409269 2409269 defendant Ladyman John mariner 604829 604829 Ladyman, John, of Great Grymesby, mariner 2
5177994 2409269 2409269 defendant Benyngworth Thomas weaver 604829 604829 Benyngworth, Thomas, of Great Grymesby, weaver 4
5178299 2409355 2409355 plaintiff Asseby Richard   604829 604829 Asseby, Richard, of Great Grymesby 0
5178300 2409355 2409355 defendant Edon Hugh merchant 604829 604829 Edon, Hugh, of Great Grymesby, merchant 0
5179481 2409733 2409733 defendant Dove William butcher 604829 604829 Dove, William, of Great Grymesby, butcher 0
5179607 2409771 2409771 defendant Broun John carver 604829 604829 Broun, John, of Great Grymesby, carver 0
5183090 2410797 2410797 defendant Carleton John   604829 604829 Carleton, John, of Great Grymesby, shoe maker 3
5183844 2411012 2411012 defendant Hobson Peter shipman 604829 604829 Hobson, Peter, of Great Grymesby, shipman 0
5183845 2411012 2411012 defendant Pelton Henry mariner 604829 604829 Pelton, Henry, of Great Grymesby, mariner 1
5184450 2411190 2411190 defendant Asby Richard yeoman 604829 604829 Asby, Richard, of Great Grymesby, yeoman 0
5187444 2412049 2412049 defendant Broughton Thomas merchant 604829 604829 Broughton, Thomas, of Great Grymesby, merchant 3
5189663 2412721 2412721 defendant Gaunce Joan widow 604829 604829 Gaunce, Joan, of Great Grymesby, widow 0
5189664 2412721 2412721 defendant Gaunce John shipman 604829 604829 Gaunce, John, of Great Grymesby, shipman 1
5191761 2413328 2413328 defendant Maufeld Richard merchant 604829 604829 Maufeld, Richard, of Great Grymesby, merchant 0
5195746 2414500 2414500 defendant Swanland John (legal representative) 604829 604829 Swanland, John, of Great Grymesby, tanner, executors of 0
5195747 2414500 2414500 defendant Ladyman John shipman 604829 604829 (Ladyman, John, of Great Grymesby, shipman 1
5195748 2414500 2414500 defendant Swanland Margaret   604829 604829 Swanland, Margaret, of Great Grymesby, widow, formerly wife of John Swanland 2
5199548 2415613 2415613 defendant Edon Hugh chapman & burgess 604829 604829 Edon, Hugh, of Great Grymesby, chapman & burgess 0
5199580 2415622 2415622 defendant Copes James chapman 604829 604829 Copes, James, of Great Grymesby, chapman 0
5201901 2416320 2416320 defendant Dove William butcher 604829 604829 Dove, William, of Great Grymesby, butcher 0
5204031 2416930 2416930 defendant Hobson Peter shipman 604829 604829 Hobson, Peter, of Great Grymesby, shipman 0
5204032 2416930 2416930 defendant Pelton Henry mariner 604829 604829 Pelton, Henry, of Great Grymesby, mariner 1
5206521 2417639 2417639 defendant Smyth Thomas (legal representative) 604829 604829 Smyth, Thomas, of Great Grymesby, fishmonger, administrator of 1
5250301 2430201 2430201 defendant Edon Hugh chapman 604829 604829 Edon, Hugh, of Great Grymesby, chapman 0

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