names

48 rows where place_id = 586923

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589994 1864512 1864512 defendant Okke Richard husbandman 586923 586923 Okke, Richard, of Styfkey, husbandman 1
3589996 1864512 1864512 defendant Styfkey John husbandman 586923 586923 Styfkey, John, of Styfkey, husbandman 3
3589997 1864512 1864512 defendant Broun John husbandman 586923 586923 Broun, John, of Styfkey, husbandman 4
3589998 1864512 1864512 defendant Bartram Roger husbandman 586923 586923 Bartram, Roger, of Styfkey, husbandman 5
3589999 1864512 1864512 defendant Bartram Thomas husbandman 586923 586923 Bartram, Thomas, of Styfkey, husbandman 6
3716510 1931460 1931460 defendant Pawe Andrew husbandman 586923 586923 Pawe, Andrew, of Styfkey, husbandman 0
3825529 1965837 1965837 defendant Pynchyn John husbandman 586923 586923 Pynchyn, John, of Styfkey, husbandman 0
3825530 1965837 1965837 defendant Walet William   586923 586923 Walet, William, of Styfkey, shepherd 1
3825531 1965837 1965837 defendant Bartram John husbandman 586923 586923 Bartram, John, of Styfkey, husbandman 2
3845791 1972233 1972233 plaintiff Framyngham John   586923 586923 Framyngham, John, of Styfkey 0
3888988 1986558 1986558 plaintiff Framyngham John yeoman 586923 586923 Framyngham, John, of Styfkey, yeoman 0
3923500 1998167 1998167 plaintiff Greve John   586923 586923 Greve, John, of Styfkey 2
3947362 2006149 2006149 defendant Calthorpe Thomas gent 586923 586923 Calthorpe, Thomas, of Styfkey, gent 0
3947364 2006150 2006150 defendant Calthorp Thomas gent 586923 586923 Calthorp, Thomas, of Styfkey, gent 0
3947366 2006151 2006151 defendant Calthorpe Thomas gent 586923 586923 Calthorpe, Thomas, of Styfkey, gent 0
3950173 2007143 2007143 plaintiff Framyngham Edmund yeoman 586923 586923 Framyngham, Edmund, of Styfkey, yeoman 0
3972163 2014826 2014826 plaintiff Framyngham Edmund   586923 586923 Framyngham, Edmund, of Styfkey 0
3972167 2014828 2014828 plaintiff Framyngham Robert yeoman 586923 586923 Framyngham, Robert, of Styfkey, yeoman 0
3973047 2015143 2015143 defendant Framyngham Robert yeoman 586923 586923 Framyngham, Robert, of Styfkey, yeoman 2
3982297 2018439 2018439 defendant Framyngham Robert yeoman 586923 586923 Framyngham, Robert, of Styfkey, yeoman 0
3989726 2021071 2021071 defendant Framyngham Robert yeoman 586923 586923 Framyngham, Robert, of Styfkey, yeoman 0
4015312 2030171 2030171 defendant Newton Peter husbandman 586923 586923 Newton, Peter, of Styfkey, husbandman 1
4027342 2034425 2034425 defendant Framyngham Robert merchant 586923 586923 Framyngham, Robert, of Styfkey, merchant 7
4062273 2046798 2046798 defendant Calthorpe Thomas gent 586923 586923 Calthorpe, Thomas, of Styfkey, gent 2
4201644 2096118 2096118 defendant Newby William yeoman 586923 586923 Newby, William, of Styfkey, yeoman 2
4272229 2120280 2120280 defendant Narffolke John yeoman 586923 586923 Narffolke, John, of Styfkey, yeoman 0
4313341 2134773 2134773 defendant Lightfoote John yeoman 586923 586923 Lightfoote, John, of Styfkey, yeoman 0
4704559 2266802 2266802 defendant Cat John yeoman 586923 586923 Cat, John, of Styfkey, yeoman 0
4897814 2325981 2325981 defendant Clerk Robert husbandman 586923 586923 Clerk, Robert, of Styfkey, husbandman 0
4952398 2342673 2342673 defendant Greve John, junior   586923 586923 Greve, John, junior, of Styfkey, shepherd 0
4959788 2344891 2344891 defendant Cat Nicholas husbandman 586923 586923 Cat, Nicholas, of Styfkey, husbandman 1
5141142 2398533 2398533 defendant Est William   586923 586923 Est, William, of Styfkey 0
5180321 2409984 2409984 defendant Mason William husbandman 586923 586923 Mason, William, of Styfkey, husbandman 0
5180322 2409984 2409984 defendant Est John laborer 586923 586923 Est, John, of Styfkey, laborer 1
5202343 2416447 2416447 defendant Mason William husbandman 586923 586923 Mason, William, of Styfkey, husbandman 0
5202344 2416447 2416447 defendant Est John laborer 586923 586923 Est, John, of Styfkey, laborer 1
5258413 2432745 2432745 defendant Broune John mariner 586923 586923 Broune, John, of Styfkey, mariner 1
5264947 2434794 2434794 defendant Helme Peter laborer 586923 586923 Helme, Peter, of Styfkey, laborer 1
5276490 2438196 2438196 defendant Letcher Andrew shipman 586923 586923 Letcher, Andrew, of Styfkey, shipman 0
5285358 2440738 2440738 defendant Skynner Gilbert   586923 586923 Skynner, Gilbert, of Styfkey 0
5286611 2441095 2441095 defendant Broun John husbandman 586923 586923 Broun, John, of Styfkey, husbandman 0
5319877 2451031 2451031 defendant Broun John mariner 586923 586923 Broun, John, of Styfkey, mariner 3
5384528 2470659 2470659 defendant Smyth John husbandman 586923 586923 Smyth, John, of Styfkey, husbandman 0
5396371 2474054 2474054 defendant Smyth alias Richardson John husbandman 586923 586923 Smyth alias Richardson, John, of Styfkey, husbandman 0
5459264 2492677 2492677 plaintiff Gyllowe William   586923 586923 Gyllowe, William, of Styfkey 0
5470908 2496231 2496231 plaintiff Gyllowe William   586923 586923 Gyllowe, William, of Styfkey 0
5478709 2498657 2498657 defendant Clerk Nicholas clerk 586923 586923 Clerk, Nicholas, of Styfkey, clerk 1
5578806 2528432 2528432 defendant Thorp John baker 586923 586923 Thorp, John, of Styfkey, baker 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);