names

150 rows where place_id = 624989

✎ 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
3761472 1945600 1945600 defendant Cook John yeoman 624989 624989 Cook, John, of Glaston, yeoman 0
3761473 1945600 1945600 defendant Mitton John yeoman 624989 624989 Mitton, John, of Glaston, yeoman 1
3780871 1951751 1951751 defendant Rokys John yeoman 624989 624989 Rokys, John, of Glaston, yeoman 0
3975840 2016112 2016112 defendant Jekes John yeoman 624989 624989 Jekes, John, of Glaston, yeoman 0
4181882 2089144 2089144 defendant Collye Anthony esq 624989 624989 Collye, Anthony, of Glaston, esq 1
4215994 2101087 2101087 defendant Sharpe William yeoman 624989 624989 Sharpe, William, of Glaston, yeoman 0
4282881 2123911 2123911 defendant Roper Thomas, senior yeoman 624989 624989 Roper, Thomas, senior, of Glaston, yeoman 0
4282882 2123911 2123911 defendant Roper Thomas, junior laborer 624989 624989 Roper, Thomas, junior, of Glaston, laborer 1
4314716 2135261 2135261 defendant Kinge Edward gent 624989 624989 Kinge, Edward, of Glaston, gent 0
4314717 2135261 2135261 defendant Kinge Elizabeth widow 624989 624989 Elizabeth his wife, alias Elizabeth Colly, of Glaston, widow 1
4318081 2136433 2136433 defendant Brudenell Thomas gent 624989 624989 Brudenell, Thomas, of Glaston, gent 0
4320906 2137406 2137406 defendant Martyn William yeoman 624989 624989 Martyn, William, of Glaston, yeoman 0
4330422 2140475 2140475 defendant Colley John gent 624989 624989 Colley, John, of Glaston, gent 0
4345947 2145845 2145845 defendant Harryson William husbandman 624989 624989 Harryson, William, of Glaston, husbandman 1
4345948 2145845 2145845 defendant Luffe of Love William husbandman 624989 624989 Luffe of Love, William, of Glaston, husbandman 2
4388089 2160643 2160643 defendant Harryson John yeoman 624989 624989 Harryson, John, of Glaston, yeoman 0
4403456 2165728 2165728 defendant Bowdell Thomas husbandman 624989 624989 Bowdell, Thomas, of Glaston, husbandman 0
4403457 2165728 2165728 defendant Harrison John husbandman 624989 624989 Harrison, John, of Glaston, husbandman 1
4403458 2165728 2165728 defendant Luffe William husbandman 624989 624989 Luffe, William, of Glaston, husbandman 2
4403459 2165728 2165728 defendant Wytt William husbandman 624989 624989 Wytt, William, of Glaston, husbandman 3
4435484 2175856 2175856 defendant Smyth Robert le   624989 624989 Smyth, Robert le, of Glaston 0
4455487 2186721 2186721 defendant Gamelyn John   624989 624989 Gamelyn, John, of Glaston 0
4455923 2186868 2186868 defendant Tybold Thomas   624989 624989 Tybold, Thomas, of Glaston 1
4464574 2189589 2189589 plaintiff Wayster John   624989 624989 Wayster, John, of Glaston 0
4470630 2191462 2191462 plaintiff Bryght Edward   624989 624989 Bryght, Edward, of Glaston 0
4470632 2191463 2191463 plaintiff Bryght Edward   624989 624989 Bryght, Edward, of Glaston 0
4483257 2195462 2195462 defendant Skynner William   624989 624989 Skynner, William, of Glaston 0
4489557 2197454 2197454 plaintiff Tomer John   624989 624989 Tomer, John, of Glaston 0
4489561 2197454 2197454 defendant Chapman Richard   624989 624989 Chapman, Richard, of Glaston 3
4490158 2197641 2197641 defendant Dare William   624989 624989 Dare, William, of Glaston 0
4497853 2199971 2199971 defendant Kyng Hicholas   624989 624989 Kyng, Hicholas, of Glaston 0
4497854 2199971 2199971 defendant Brous John hostler 624989 624989 Brous, John, of Glaston, hostler 1
4503278 2201593 2201593 plaintiff Parl Richard   624989 624989 Parl, Richard, of Glaston 0
4506330 2202481 2202481 plaintiff Taverner John   624989 624989 Taverner, John, of Glaston 0
4533087 2210612 2210612 defendant Ostiler Robert   624989 624989 Ostiler, Robert, of Glaston 0
4533089 2210612 2210612 defendant Dyches John shoemaker 624989 624989 Dyches, John, of Glaston, shoemaker 2
4542323 2213489 2213489 defendant Leche Peter   624989 624989 Leche, Peter, of Glaston 0
4552751 2216810 2216810 defendant Blew Stephen   624989 624989 Blew, Stephen, of Glaston 2
4552753 2216810 2216810 defendant Merfeld William chapman 624989 624989 Merfeld, William, of Glaston, chapman 4
4552762 2216812 2216812 defendant Blewe Stephen   624989 624989 Blewe, Stephen, of Glaston 3
4552764 2216812 2216812 defendant Merfeld William chapman 624989 624989 Merfeld, William, of Glaston, chapman 5
4556203 2217881 2217881 defendant Neweton Ralph   624989 624989 Neweton, Ralph, of Glaston 6
4558596 2218642 2218642 plaintiff Lyndon John   624989 624989 Lyndon, John, of Glaston, parson 0
4566017 2220926 2220926 plaintiff Sprot John   624989 624989 Sprot, John, of Glaston 0
4567933 2221540 2221540 plaintiff Trap Richard   624989 624989 Trap, Richard, of Glaston 0
4569342 2222001 2222001 defendant Smyth Richard   624989 624989 Smyth, Richard, of Glaston 0
4570217 2222255 2222255 plaintiff Woderove (illegible)   624989 624989 Woderove, _, of Glaston 0
4572640 2222981 2222981 plaintiff atte Mulle Robert   624989 624989 atte Mulle, Robert, of Glaston 0
4572644 2222981 2222981 defendant Broke Richard   624989 624989 Broke, Richard, of Glaston 3
4572645 2222981 2222981 defendant Geffreys Richard drover 624989 624989 Geffreys, Richard, of Glaston, drover 4
4576321 2224101 2224101 defendant Wymark Roger (legal representative) 624989 624989 Wymark, Roger, of Glaston, executrix of 1
4581572 2225681 2225681 defendant Marchall William   624989 624989 Marchall, William, of Glaston 0
4594554 2229555 2229555 plaintiff Porter Thomas   624989 624989 Porter, Thomas, of Glaston 0
4594555 2229555 2229555 defendant Geffrey Richard drover 624989 624989 Geffrey, Richard, of Glaston, drover 0
4594556 2229555 2229555 defendant Bat Thomas chapman 624989 624989 Bat, Thomas, of Glaston, chapman 1
4595240 2229760 2229760 plaintiff Randolf William   624989 624989 Randolf, William, of Glaston 0
4595241 2229760 2229760 defendant Jones John   624989 624989 Jones, John, of Glaston 0
4598239 2230687 2230687 defendant Trefrawell Richard   624989 624989 Trefrawell, Richard, of Glaston 0
4604119 2232455 2232455 defendant Stokaston Thomas   624989 624989 Stokaston, Thomas, of Glaston 2
4611185 2234561 2234561 plaintiff Chynnok John   624989 624989 Chynnok, John, of Glaston, abbot 0
4611187 2234562 2234562 plaintiff Chynnok John   624989 624989 Chynnok, John, of Glaston, abbot 0
4621228 2237628 2237628 plaintiff Kyng Nicholas   624989 624989 Kyng, Nicholas, of Glaston 0
4637447 2242504 2242504 defendant Skynnere Reginald   624989 624989 Skynnere, Reginald, of Glaston 0
4663934 2250204 2250204 defendant Shokeston Thomas husbandman 624989 624989 Shokeston, Thomas, of Glaston, husbandman 0
4671244 2256660 2256660 defendant Haryes Robert butcher 624989 624989 Haryes, Robert, of Glaston, butcher 3
4671250 2256661 2256661 defendant Haryes Robert butcher 624989 624989 Haryes, Robert, of Glaston, butcher 3
4684630 2260792 2260792 plaintiff Pyper John   624989 624989 Pyper, John, of Glaston, on his own account 0
4688309 2261912 2261912 defendant Frensshe John shoemaker 624989 624989 Frensshe, John, of Glaston, shoemaker 0
4688912 2262087 2262087 plaintiff Trappe Richard   624989 624989 Trappe, Richard, of Glaston 0
4689599 2262306 2262306 defendant Hunton Peter yeoman 624989 624989 Hunton, Peter, of Glaston, yeoman 0
4705325 2267038 2267038 plaintiff Kyng Nicholas   624989 624989 Kyng, Nicholas, of Glaston 0
4705326 2267038 2267038 defendant Bocher John husbandman 624989 624989 Bocher, John, of Glaston, husbandman 0
4707458 2267709 2267709 defendant Holylond Thomas husbandman 624989 624989 Holylond, Thomas, of Glaston, husbandman 0
4722706 2272419 2272419 plaintiff Cork alias Lavender John   624989 624989 Cork alias Lavender, John, of Glaston 0
4728956 2274294 2274294 plaintiff Kyng Nicholas   624989 624989 Kyng, Nicholas, of Glaston 0
4728957 2274294 2274294 defendant Boole John husbandman 624989 624989 Boole, John, of Glaston, husbandman 0
4736960 2276688 2276688 defendant Leget John husbandman 624989 624989 Leget, John, of Glaston, husbandman 0
4743335 2278578 2278578 plaintiff Cork alias Lavender John   624989 624989 Cork alias Lavender, John, of Glaston, on his own account 0
4747531 2279783 2279783 plaintiff Kyng Nicholas   624989 624989 Kyng, Nicholas, of Glaston, on his own account 0
4758220 2282945 2282945 defendant Trefrawell Richard husbandman 624989 624989 Trefrawell, Richard, of Glaston, husbandman 0
4758221 2282945 2282945 defendant Body Thomas baker 624989 624989 Body, Thomas, of Glaston, baker 1
4758222 2282945 2282945 defendant Welet John weaver 624989 624989 Welet, John, of Glaston, weaver 2
4761621 2283979 2283979 defendant Forstehulle John husbandman 624989 624989 Forstehulle, John, of Glaston, husbandman 1
4767875 2285927 2285927 plaintiff Merfeld John   624989 624989 Merfeld, John, of Glaston 0
4810894 2299525 2299525 defendant Holt John laborer 624989 624989 Holt, John, of Glaston, laborer 0
4810950 2299540 2299540 defendant Stokewode Mathew carpenter 624989 624989 Stokewode, Mathew, of Glaston, carpenter 0
4810951 2299540 2299540 defendant Gryme John   624989 624989 Gryme, John, of Glaston, mason 1
4811274 2299635 2299635 defendant Dygon John butcher 624989 624989 Dygon, John, of Glaston, butcher 0
4811275 2299635 2299635 defendant Puxton Roger husbandman 624989 624989 Puxton, Roger, of Glaston, husbandman 1
4811771 2299793 2299793 defendant Forest John ostler 624989 624989 Forest, John, of Glaston, ostler 1
4820175 2302382 2302382 defendant Baker Giles baker 624989 624989 Baker, Giles, of Glaston, baker 0
4826351 2304280 2304280 defendant Mers Thomas husbandman 624989 624989 Mers, Thomas, of Glaston, husbandman 0
4827591 2304680 2304680 defendant Forsthull alias Mynhede John fisher 624989 624989 Forsthull alias Mynhede, John, of Glaston, fisher 0
4828614 2304989 2304989 defendant Doo John   624989 624989 Doo, John, of Glaston, bailiff 0
4833162 2306384 2306384 defendant Muryfeld John mercer 624989 624989 Muryfeld, John, of Glaston, mercer 0
4833459 2306470 2306470 defendant Greylake Richard weaver 624989 624989 Greylake, Richard, of Glaston, weaver 0
4833467 2306474 2306474 defendant Greylake Richard weaver 624989 624989 Greylake, Richard, of Glaston, weaver 0
4834119 2306680 2306680 defendant Marke John   624989 624989 Marke, John, of Glaston, school master 0
4834120 2306680 2306680 defendant Hille John tailor 624989 624989 Hille, John, of Glaston, tailor 1
4847613 2310744 2310744 defendant Blakwell Agnes shepster 624989 624989 Blakwell, Agnes, of Glaston, shepster 4

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