names

224 rows where place_id = 587177

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590666 1864724 1864724 defendant Langton John glover 587177 587177 Langton, John, of Staunford, Lincs, glover 0
3601242 1868050 1868050 defendant Thomson Robert yeoman 587177 587177 Thomson, Robert, of Staunford, Lincs, yeoman 2
3623748 1874960 1874960 defendant Parnell Thomas mercer 587177 587177 Parnell, Thomas, of Staunford, Lincs, mercer 0
3624793 1875289 1875289 defendant Broune Christopher merchant 587177 587177 Broune, Christopher, of Staunford, Lincs, merchant 0
3705621 1928040 1928040 defendant Wytton Mathew glover 587177 587177 Wytton, Mathew, of Staunford, Lincs, glover 0
3727985 1935021 1935021 defendant Cob Agnes widow 587177 587177 Cob, Agnes, of Staunford, Lincs, widow 0
3810562 1961201 1961201 defendant Leveyns Thomas fletcher 587177 587177 Leveyns, Thomas, of Staunford, Lincs, fletcher 1
3869071 1979901 1979901 plaintiff Trygge William clerk 587177 587177 Trygge, William, of Staunford, Lincs, clerk 0
3889614 1986756 1986756 defendant Gedney Thomas glover 587177 587177 Gedney, Thomas, of Staunford, Lincs, glover 1
3917621 1996252 1996252 defendant Gedney Thomas glover 587177 587177 Gedney, Thomas, of Staunford, Lincs, glover 0
3922842 1997941 1997941 defendant Hardgrave John gent 587177 587177 Hardgrave, John, of Staunford, Lincs, gent 0
3922848 1997943 1997943 defendant Wytton William glover 587177 587177 Wytton, William, of Staunford, Lincs, glover 0
3946501 2005844 2005844 defendant Hopkyns Richard chapman 587177 587177 Hopkyns, Richard, of Staunford, Lincs, chapman 2
3947504 2006198 2006198 defendant Peppar John chapman 587177 587177 Peppar, John, of Staunford, Lincs, chapman 3
4030943 2035733 2035733 defendant Tampyon Henry gent 587177 587177 Tampyon, Henry, of Staunford, Lincs, gent 0
4036716 2037817 2037817 defendant Hynman Henry gent 587177 587177 Hynman, Henry, of Staunford, Lincs, gent 0
4038104 2038270 2038270 defendant Tampyon Henry yeoman 587177 587177 Tampyon, Henry, of Staunford, Lincs, yeoman 0
4038130 2038278 2038278 defendant Tampion Henry yeoman 587177 587177 Tampion, Henry, of Staunford, Lincs, yeoman 0
4039051 2038591 2038591 plaintiff Loveday Christopher glover 587177 587177 Loveday, Christopher, of Staunford, Lincs, glover 0
4058251 2045335 2045335 defendant Clark Henry mercer 587177 587177 Clark, Henry, of Staunford, Lincs, mercer 0
4078816 2052720 2052720 defendant Fetherstone Robert gent 587177 587177 Fetherstone, Robert, of Staunford, Lincs, or of Forram Streete, York, gent 0
4156128 2080218 2080218 defendant Beale Roger gent 587177 587177 Beale, Roger, of Staunford, Lincs, gent 0
4178344 2087897 2087897 defendant Harruppe alias Baker Geoffrey innholder 587177 587177 Harruppe alias Baker, Geoffrey, of Staunford, Lincs, innholder 0
4285085 2124717 2124717 defendant Dickonson Richard vintner 587177 587177 Dickonson, Richard, of Staunford, Lincs, vintner 0
4304604 2131745 2131745 defendant More William chapman 587177 587177 More, William, of Staunford, Lincs, chapman 0
4310611 2133858 2133858 defendant Sheriff John mercer 587177 587177 Sheriff, John, of Staunford, Lincs, mercer 1
4312288 2134434 2134434 defendant Shutt Richard gent 587177 587177 Shutt, Richard, of Staunford, Lincs, gent 0
4353370 2148403 2148403 defendant Dickenson Richard vintner 587177 587177 Dickenson, Richard, of Staunford, Lincs, vintner 0
4353372 2148404 2148404 defendant Langton Robert gent 587177 587177 Langton, Robert, of Staunford, Lincs, gent 0
4353376 2148406 2148406 defendant Litler John baker 587177 587177 Litler, John, of Staunford, Lincs, baker 0
4368159 2153665 2153665 defendant Fell Oliver chapman 587177 587177 Fell, Oliver, of Staunford, Lincs, chapman 0
4369299 2154084 2154084 defendant Fell Oliver chapman 587177 587177 Fell, Oliver, of Staunford, Lincs, chapman 0
4513456 2204630 2204630 defendant Holme Thomas   587177 587177 Holme, Thomas, of Staunford, Lincs 0
4559631 2218965 2218965 defendant Aldirwych John dyer 587177 587177 Aldirwych, John, of Staunford, Lincs, dyer 0
4655587 2247636 2247636 defendant Effeld John clerk 587177 587177 Effeld, John, of Staunford, Lincs, clerk 2
4670292 2256414 2256414 defendant Draper John hosier 587177 587177 Draper, John, of Staunford, Lincs, hosier 0
4699373 2265265 2265265 defendant Wade John   587177 587177 Wade, John, of Staunford, Lincs, tile maker 3
4712367 2269183 2269183 defendant Everyngham John   587177 587177 Everyngham, John, of Staunford, Lincs, tapestry maker 0
4713800 2269642 2269642 defendant Everyngham John tapiser or tapestry maker 587177 587177 Everyngham, John, of Staunford, Lincs, tapiser or tapestry maker 0
4734673 2276000 2276000 defendant Prat John chapman 587177 587177 Prat, John, of Staunford, Lincs, chapman 0
4750799 2280715 2280715 defendant Warner John merchant 587177 587177 Warner, John, of Staunford, Lincs, merchant 3
4754037 2281645 2281645 defendant Long John husbandman 587177 587177 Long, John, of Staunford, Lincs, husbandman 0
4769627 2286476 2286476 defendant Chapman Walter yeoman 587177 587177 Chapman, Walter, of Staunford, Lincs, yeoman 0
4774931 2288155 2288155 defendant Birde John chaplain 587177 587177 Birde, John, of Staunford, Lincs, chaplain 0
4793000 2293900 2293900 defendant Mercer Alexander mercer 587177 587177 Mercer, Alexander, of Staunford, Lincs, mercer 0
4794104 2294290 2294290 defendant Bocher Robert butcher 587177 587177 Bocher, Robert, of Staunford, Lincs, butcher 0
4794111 2294293 2294293 defendant Chapman Walter yeoman 587177 587177 Chapman, Walter, of Staunford, Lincs, yeoman 0
4800753 2296420 2296420 defendant Knyght William chapman 587177 587177 Knyght, William, of Staunford, Lincs, chapman 0
4803426 2297260 2297260 defendant Apethorp John chapman 587177 587177 Apethorp, John, of Staunford, Lincs, chapman 1
4805426 2297904 2297904 defendant Knyght William draper 587177 587177 Knyght, William, of Staunford, Lincs, draper 0
4807868 2298646 2298646 defendant Knyght William yeoman 587177 587177 Knyght, William, of Staunford, Lincs, yeoman 0
4807871 2298647 2298647 defendant Knyght William yeoman 587177 587177 Knyght, William, of Staunford, Lincs, yeoman 0
4815730 2301021 2301021 defendant Cloke Thomas butcher 587177 587177 Cloke, Thomas, of Staunford, Lincs, butcher 0
4819872 2302289 2302289 defendant Goodberd Nicholas glover 587177 587177 Goodberd, Nicholas, of Staunford, Lincs, glover 0
4823687 2303500 2303500 defendant Knyght William chapman 587177 587177 Knyght, William, of Staunford, Lincs, chapman 0
4824620 2303752 2303752 defendant Cade Alan chapman 587177 587177 Cade, Alan, of Staunford, Lincs, chapman 0
4824627 2303753 2303753 defendant Cade Alan chapman 587177 587177 Cade, Alan, of Staunford, Lincs, chapman 0
4825285 2303950 2303950 defendant Broune Thomas butcher 587177 587177 Broune, Thomas, of Staunford, Lincs, butcher 0
4827394 2304617 2304617 defendant Knyght William draper 587177 587177 Knyght, William, of Staunford, Lincs, draper 0
4836870 2307491 2307491 defendant Page Alexander mercer 587177 587177 Page, Alexander, of Staunford, Lincs, mercer 0
4836876 2307492 2307492 defendant Page Alexander mercer 587177 587177 Page, Alexander, of Staunford, Lincs, mercer 0
4837993 2307808 2307808 defendant Browe John gent 587177 587177 Browe, John, of Staunford, Lincs, gent 1
4845891 2310225 2310225 defendant Cook John   587177 587177 Cook, John, of Staunford, Lincs, cook 1
4847067 2310585 2310585 defendant Porter John yeoman 587177 587177 Porter, John, of Staunford, Lincs, yeoman 5
4855507 2313083 2313083 defendant Popyngton John dyer 587177 587177 Popyngton, John, of Staunford, Lincs, dyer 0
4866090 2316366 2316366 defendant Bocher Robert yeoman 587177 587177 Bocher, Robert, of Staunford, Lincs, yeoman 0
4869683 2317484 2317484 defendant Basset Thomas gent 587177 587177 Basset, Thomas, of Staunford, Lincs, gent 0
4883464 2321747 2321747 defendant Sapcote Richard merchant 587177 587177 Sapcote, Richard, of Staunford, Lincs, merchant 4
4890045 2323668 2323668 defendant Grynder William   587177 587177 Grynder, William, of Staunford, Lincs, furbour or furbisher 0
4890065 2323673 2323673 defendant Palfrey William husbandman 587177 587177 Palfrey, William, of Staunford, Lincs, husbandman 2
4890066 2323673 2323673 defendant Cloke Thomas butcher 587177 587177 Cloke, Thomas, of Staunford, Lincs, butcher 3
4894756 2325030 2325030 defendant Sapcote Richard merchant 587177 587177 Sapcote, Richard, of Staunford, Lincs, merchant 4
4906230 2328540 2328540 defendant Longe John gent 587177 587177 Longe, John, of Staunford, Lincs, gent 0
4910877 2329912 2329912 defendant Knyght William draper 587177 587177 Knyght, William, of Staunford, Lincs, draper 0
4911621 2330137 2330137 plaintiff Browene William draper 587177 587177 Browene, William, of Staunford, Lincs, draper 0
4912669 2330467 2330467 defendant Gretory William chapman 587177 587177 Gretory, William, of Staunford, Lincs, chapman 2
4913614 2330754 2330754 defendant Ryppyngale William butcher 587177 587177 Ryppyngale, William, of Staunford, Lincs, butcher 3
4915754 2331427 2331427 defendant Chevercourt John gent 587177 587177 Chevercourt, John, of Staunford, Lincs, gent 0
4916613 2331703 2331703 defendant Mekenesse William husbandman 587177 587177 Mekenesse, William, of Staunford, Lincs, husbandman 0
4920433 2332907 2332907 defendant Bernard Robert shoemaker 587177 587177 Bernard, Robert, of Staunford, Lincs, shoemaker 0
4921033 2333090 2333090 defendant Garlond Robert husbandman 587177 587177 Garlond, Robert, of Staunford, Lincs, husbandman 2
4921034 2333090 2333090 defendant Berneby Hugh yeoman 587177 587177 Berneby, Hugh, of Staunford, Lincs, yeoman 3
4922064 2333310 2333310 defendant Hanworth Hugh vintner 587177 587177 Hanworth, Hugh, of Staunford, Lincs, vintner 7
4922905 2333581 2333581 defendant Warde Nicholas baker 587177 587177 Warde, Nicholas, of Staunford, Lincs, baker 0
4923144 2333655 2333655 plaintiff Marchaunt William   587177 587177 Marchaunt, William, of Staunford, Lincs 2
4932275 2336497 2336497 defendant Smyth Richard dyer 587177 587177 Smyth, Richard, of Staunford, Lincs, dyer 0
4933649 2336902 2336902 defendant Wryght Robert chapman 587177 587177 Wryght, Robert, of Staunford, Lincs, chapman 0
4952611 2342742 2342742 defendant Lytster Richard dyer 587177 587177 Lytster, Richard, of Staunford, Lincs, dyer 1
4952615 2342743 2342743 defendant Lytster Richard dyer 587177 587177 Lytster, Richard, of Staunford, Lincs, dyer 1
4962643 2345734 2345734 defendant Holm Anise or Avise widow 587177 587177 Holm, Anise or Avise, of Staunford, Lincs, widow 1
4963632 2346037 2346037 defendant Holme William skinner 587177 587177 Holme, William, of Staunford, Lincs, skinner 0
4972120 2348601 2348601 defendant Fyssher John butcher 587177 587177 Fyssher, John, of Staunford, Lincs, butcher 0
4972547 2348719 2348719 defendant Orwyn Robert merchant 587177 587177 Orwyn, Robert, of Staunford, Lincs, merchant 0
4984544 2352306 2352306 defendant Garlond Robert hosteler 587177 587177 Garlond, Robert, of Staunford, Lincs, hosteler 2
4985987 2352727 2352727 defendant Morwode William gent 587177 587177 Morwode, William, of Staunford, Lincs, gent 3
4992031 2354504 2354504 defendant Crakke Hugh yeoman 587177 587177 Crakke, Hugh, of Staunford, Lincs, yeoman 0
4993254 2354861 2354861 defendant Bewedon William chaplain 587177 587177 Bewedon, William, of Staunford, Lincs, chaplain 3
4998178 2356323 2356323 defendant Hareby Simon yeoman 587177 587177 (Hareby, Simon, of Staunford, Lincs, yeoman 1
5004368 2358173 2358173 defendant Warde John chapman 587177 587177 Warde, John, of Staunford, Lincs, chapman 4
5008999 2359523 2359523 defendant Chevercourt John gent 587177 587177 Chevercourt, John, of Staunford, Lincs, gent 3

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