names

115 rows where place_id = 587208

✎ 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
3590763 1864750 1864750 defendant Frankysh John mariner 587208 587208 Frankysh, John, of Magna Grymesby, mariner 0
3637377 1906496 1906496 defendant Garyng Robert mariner 587208 587208 Garyng, Robert, of Magna Grymesby, mariner 0
3669011 1916238 1916238 defendant Johnson William mercer 587208 587208 Johnson, William, of Magna Grymesby, mercer 1
3669024 1916242 1916242 defendant Johnson William mercer 587208 587208 Johnson, William, of Magna Grymesby, mercer 1
3676947 1918826 1918826 defendant Johnson William mercer 587208 587208 Johnson, William, of Magna Grymesby, mercer 1
3699386 1926028 1926028 defendant Lorde Robert yeoman 587208 587208 Lorde, Robert, of Magna Grymesby, yeoman 0
3920221 1997102 1997102 defendant Wylliamson Thomas butcher 587208 587208 Wylliamson, Thomas, of Magna Grymesby, butcher 0
3920222 1997102 1997102 defendant Hodshon Edward butcher 587208 587208 Hodshon, Edward, of Magna Grymesby, butcher 1
3920223 1997102 1997102 defendant Porter Robert tanner 587208 587208 Porter, Robert, of Magna Grymesby, tanner 2
4085702 2055157 2055157 defendant Parker Roger yeoman 587208 587208 Parker, Roger, of Magna Grymesby, yeoman 0
4106237 2062521 2062521 defendant Pykerdyke John yeoman 587208 587208 Pykerdyke, John, of Magna Grymesby, yeoman 2
4116694 2066265 2066265 defendant Curteys Thomas gent 587208 587208 Curteys, Thomas, of Magna Grymesby, gent 0
4170225 2085083 2085083 defendant Empryngham Robert gent 587208 587208 Empryngham, Robert, of Magna Grymesby, gent 0
4175683 2086965 2086965 defendant Kyrke Lionel yeoman 587208 587208 Kyrke, Lionel, of Magna Grymesby, yeoman 1
4794349 2294376 2294376 defendant Skendylby John butcher 587208 587208 Skendylby, John, of Magna Grymesby, butcher 0
4854984 2312914 2312914 defendant Shildon John chapman 587208 587208 Shildon, John, of Magna Grymesby, chapman 0
4951514 2342432 2342432 defendant Auncell Robert merchant 587208 587208 Auncell, Robert, of Magna Grymesby, merchant 0
4951519 2342433 2342433 defendant Auncell Robert merchant 587208 587208 Auncell, Robert, of Magna Grymesby, merchant 0
4955384 2343569 2343569 defendant Ormesby John chapman 587208 587208 Ormesby, John, of Magna Grymesby, chapman 1
4968038 2347386 2347386 defendant Belyngton Thomas mariner 587208 587208 Belyngton, Thomas, of Magna Grymesby, mariner 0
5016484 2361714 2361714 defendant Bynbroke Robert merchant 587208 587208 Bynbroke, Robert, of Magna Grymesby, merchant 0
5028288 2365152 2365152 defendant Cok John glover 587208 587208 Cok, John, of Magna Grymesby, glover 1
5028859 2365315 2365315 defendant Est William merchant 587208 587208 Est William, of Magna Grymesby, merchant 0
5052677 2372395 2372395 defendant Dene John merchant 587208 587208 Dene, John, of Magna Grymesby, merchant 0
5054627 2372960 2372960 defendant Bayws John barber 587208 587208 Bayws, John, of Magna Grymesby, barber 0
5057594 2373841 2373841 defendant Neuton Roland esq 587208 587208 Neuton, Roland, of Magna Grymesby, esq 0
5057596 2373841 2373841 defendant Eglyston William esq 587208 587208 Eglyston, William, of Magna Grymesby, esq 2
5057623 2373848 2373848 defendant Bullyngbroke William butcher 587208 587208 Bullyngbroke, William, of Magna Grymesby, butcher 0
5057642 2373852 2373852 defendant Neuton Roland esq 587208 587208 Neuton, Roland, of Magna Grymesby, esq 0
5057644 2373852 2373852 defendant Eglyston William esq 587208 587208 Eglyston, William, of Magna Grymesby, esq 2
5059201 2374316 2374316 defendant Manfeld Richard mariner 587208 587208 Manfeld, Richard, of Magna Grymesby, mariner 0
5059202 2374316 2374316 defendant Edon Hugh merchant 587208 587208 Edon, Hugh, of Magna Grymesby, merchant 1
5059203 2374316 2374316 defendant More Richard mariner 587208 587208 More, Richard, of Magna Grymesby, mariner 2
5067599 2376806 2376806 defendant Bukenay or Bokenall John dyer 587208 587208 Bukenay or Bokenall, John, of Magna Grymesby, dyer 0
5068972 2377216 2377216 defendant Edon Hugh merchant 587208 587208 Edon, Hugh, of Magna Grymesby, merchant 0
5068975 2377216 2377216 defendant Bolyngton Thomas shipman 587208 587208 Bolyngton, Thomas, of Magna Grymesby, shipman 3
5068976 2377216 2377216 defendant Smyth William yeoman 587208 587208 Smyth, William, of Magna Grymesby, yeoman 4
5070936 2377799 2377799 defendant Bothes Robert miller 587208 587208 Bothes, Robert, of Magna Grymesby, miller 2
5071023 2377822 2377822 defendant Markham William mercer 587208 587208 Markham, William, of Magna Grymesby, mercer 0
5071024 2377822 2377822 defendant Dene John mercer 587208 587208 Dene, John, of Magna Grymesby, mercer 1
5072479 2378254 2378254 defendant Neuton Roland esq 587208 587208 Neuton, Roland, of Magna Grymesby, esq 0
5078990 2380200 2380200 defendant Chapman Richard butcher 587208 587208 Chapman, Richard, of Magna Grymesby, butcher 0
5078991 2380200 2380200 defendant atte Hall Richard mariner 587208 587208 atte Hall, Richard, of Magna Grymesby, mariner 1
5080860 2380766 2380766 defendant Neuton Roland esq 587208 587208 Neuton, Roland, of Magna Grymesby, esq 0
5082659 2381318 2381318 defendant Manfeld Richard mariner 587208 587208 Manfeld, Richard, of Magna Grymesby, mariner 0
5084267 2381804 2381804 defendant Hardy William yeoman 587208 587208 Hardy, William, of Magna Grymesby, yeoman 0
5084268 2381804 2381804 defendant Cok John glover 587208 587208 Cok, John, of Magna Grymesby, glover 1
5084269 2381804 2381804 defendant Manfeld Richard yeoman 587208 587208 Manfeld, Richard, of Magna Grymesby, yeoman 2
5084270 2381804 2381804 defendant Edon Henry yeoman 587208 587208 Edon, Henry, of Magna Grymesby, yeoman 3
5085518 2382154 2382154 defendant Baret Henry   587208 587208 Baret, Henry, of Magna Grymesby, wright 0
5090486 2383598 2383598 plaintiff Mathewe John   587208 587208 Mathewe, John, of Magna Grymesby 0
5096921 2385529 2385529 defendant Smyth Thomas, junior mariner 587208 587208 Smyth, Thomas, junior, of Magna Grymesby, mariner 2
5096981 2385551 2385551 defendant Duffeld William gent 587208 587208 Duffeld, William, of Magna Grymesby, gent 0
5098307 2385934 2385934 defendant Laceby Henry shipman 587208 587208 Laceby, Henry, of Magna Grymesby, shipman 0
5098309 2385935 2385935 defendant More Richard merchant 587208 587208 More, Richard, of Magna Grymesby, merchant 0
5101020 2386712 2386712 defendant Smyth alias Tapitur Robert weaver 587208 587208 Smyth alias Tapitur, Robert, of Magna Grymesby, weaver 0
5101980 2387003 2387003 defendant Dene John chapman 587208 587208 Dene, John, of Magna Grymesby, or of Clee, chapman 0
5102184 2387062 2387062 defendant Brughton Thomas merchant 587208 587208 Brughton, Thomas, of Magna Grymesby, merchant 1
5105727 2388125 2388125 defendant Neuton Roland esq 587208 587208 Neuton, Roland, of Magna Grymesby, esq 0
5105908 2388169 2388169 defendant Edon William shipman 587208 587208 Edon, William, of Magna Grymesby, shipman 1
5105913 2388170 2388170 defendant Edon William shipman 587208 587208 Edon, William, of Magna Grymesby, shipman 1
5107672 2388676 2388676 defendant Duffeld William gent 587208 587208 Duffeld, William, of Magna Grymesby, gent 0
5108101 2388809 2388809 defendant Sheriff John merchant 587208 587208 Sheriff, John, of Magna Grymesby, merchant 0
5110139 2389377 2389377 defendant Saxton Robert shipman 587208 587208 Saxton, Robert, of Magna Grymesby, shipman 0
5111035 2389620 2389620 defendant Graynesby John merchant 587208 587208 Graynesby, John, of Magna Grymesby, merchant 2
5111036 2389620 2389620 defendant Brughton Thomas merchant 587208 587208 Brughton, Thomas, of Magna Grymesby, merchant 3
5115740 2391032 2391032 defendant Cope James mariner 587208 587208 Cope, James, of Magna Grymesby, mariner 0
5118553 2391857 2391857 defendant Cope or Scope James merchant 587208 587208 Cope or Scope, James, of Magna Grymesby, merchant 1
5213505 2419682 2419682 defendant Hall Richard mariner 587208 587208 Hall, Richard, of Magna Grymesby, mariner 1
5213506 2419682 2419682 defendant Broughton Thomas merchant 587208 587208 Broughton, Thomas, of Magna Grymesby, merchant 2
5219101 2421312 2421312 defendant Cokke John glover 587208 587208 Cokke, John, of Magna Grymesby, glover 4
5219263 2421360 2421360 defendant Manfeld Richard merchant 587208 587208 Manfeld, Richard, of Magna Grymesby, merchant 0
5219264 2421360 2421360 defendant Hunt William baker 587208 587208 Hunt, William, of Magna Grymesby, baker 1
5219270 2421361 2421361 defendant Manfeld Richard merchant 587208 587208 Manfeld, Richard, of Magna Grymesby, merchant 1
5219271 2421361 2421361 defendant Hunt William baker 587208 587208 Hunt, William, of Magna Grymesby, baker 2
5220844 2421788 2421788 defendant Brughton Thomas merchant 587208 587208 Brughton, Thomas, of Magna Grymesby, merchant 3
5222545 2422310 2422310 defendant Manfeld Richard chapman 587208 587208 Manfeld, Richard, of Magna Grymesby, chapman 0
5229656 2424294 2424294 defendant Ladyman John mariner 587208 587208 Ladyman, John, of Magna Grymesby, mariner 1
5229657 2424294 2424294 defendant Benyngworth Thomas weaver 587208 587208 Benyngworth, Thomas, of Magna Grymesby, weaver 2
5234467 2425671 2425671 defendant Carleton John shoemaker 587208 587208 Carleton, John, of Magna Grymesby, shoemaker 3
5238749 2426924 2426924 defendant Cokke John glover 587208 587208 Cokke, John, of Magna Grymesby, glover 4
5238994 2426995 2426995 defendant Broughton Thomas merchant 587208 587208 Broughton, Thomas, of Magna Grymesby, merchant 0
5245969 2428982 2428982 defendant Manfeld Richard mariner 587208 587208 Manfeld, Richard, of Magna Grymesby, mariner 0
5247458 2429412 2429412 defendant Manfeld Richard shipman 587208 587208 Manfeld, Richard, of Magna Grymesby, shipman 4
5248999 2429830 2429830 defendant Edon Hugh merchant 587208 587208 Edon, Hugh, of Magna Grymesby, merchant 0
5250303 2430202 2430202 defendant Broghton Thomas merchant 587208 587208 Broghton, Thomas, of Magna Grymesby, merchant 0
5255156 2431726 2431726 defendant Wright John shipman 587208 587208 Wright, John, of Magna Grymesby, shipman 1
5255157 2431726 2431726 defendant Barbour Robert   587208 587208 Barbour, Robert, of Magna Grymesby, wright, chamberlain of Grymesby 2
5258822 2432880 2432880 defendant Waltham Robert mariner 587208 587208 Waltham, Robert, of Magna Grymesby, mariner 1
5258823 2432880 2432880 defendant Andewyn or Audewyn John mariner 587208 587208 Andewyn or Audewyn, John, of Magna Grymesby, mariner 2
5258824 2432880 2432880 defendant Saxton Robert mariner 587208 587208 Saxton, Robert, of Magna Grymesby, mariner 3
5260408 2433384 2433384 defendant Duffeld William gent 587208 587208 Duffeld, William, of Magna Grymesby, gent 2
5280959 2439509 2439509 defendant Wythern Robert yeoman 587208 587208 Wythern, Robert, of Magna Grymesby, yeoman 0
5291129 2442411 2442411 plaintiff Peresson John   587208 587208 Peresson, John, of Magna Grymesby 0
5291131 2442411 2442411 defendant Langton Thomas tailor 587208 587208 Langton, Thomas, of Magna Grymesby, tailor 1
5291132 2442412 2442412 plaintiff Peresson John gent 587208 587208 Peresson, John, of Magna Grymesby, gent 0
5291134 2442412 2442412 defendant Langton Thomas tailor 587208 587208 Langton, Thomas, of Magna Grymesby, tailor 1
5311726 2448527 2448527 defendant Duffeld Thomas chapman 587208 587208 Duffeld, Thomas, of Magna Grymesby, chapman 7
5320698 2451285 2451285 defendant Othesee Peter gent 587208 587208 Othesee, Peter, of Magna Grymesby, gent 0
5337087 2456169 2456169 plaintiff Hobson alias Deen Peter   587208 587208 Hobson alias Deen, Peter, of Magna Grymesby 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);