names

134 rows where place_id = 586929

✎ 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
3590010 1864516 1864516 plaintiff Clerk Richard merchant 586929 586929 Clerk, Richard, of Neweport, merchant 0
3643258 1908317 1908317 defendant Bosse Humphrey chapman 586929 586929 Bosse, Humphrey, of Neweport, chapman 0
3643259 1908317 1908317 defendant Kendall Richard husbandman 586929 586929 Kendall, Richard, of Neweport, husbandman 1
3725140 1934154 1934154 defendant Turnour Thomas butcher 586929 586929 Turnour, Thomas, of Neweport, butcher 1
4461288 2188615 2188615 defendant Fuller John   586929 586929 Fuller, John, of Neweport 0
4461291 2188616 2188616 defendant Fullere John   586929 586929 Fullere, John, of Neweport 0
4469050 2190987 2190987 defendant Skynnere John   586929 586929 Skynnere, John, of Neweport 0
4478472 2193942 2193942 defendant gase William   586929 586929 gase, William, of Neweport 0
4481238 2194813 2194813 plaintiff Lombe John   586929 586929 Lombe, John, of Neweport 0
4517367 2205835 2205835 defendant Gace William (legal representative) 586929 586929 Gace, William, of Neweport, executors of 0
4541712 2213301 2213301 defendant Cok John shoemaker 586929 586929 Cok, John, of Neweport, shoemaker 0
4564910 2220590 2220590 plaintiff Shephurde Thomas   586929 586929 Shephurde, Thomas, of Neweport 0
4614251 2235470 2235470 plaintiff Drapere John   586929 586929 Drapere, John, of Neweport 0
4615106 2235735 2235735 defendant Brydde Thomas   586929 586929 Brydde, Thomas, of Neweport 1
4628002 2239679 2239679 defendant Louk William   586929 586929 Louk, William, of Neweport 0
4654222 2247202 2247202 plaintiff Blanke John   586929 586929 Blanke, John, of Neweport 0
4683414 2260414 2260414 defendant Gilot William draper 586929 586929 Gilot, William, of Neweport, draper 1
4697721 2264779 2264779 defendant Bakere Adam baker 586929 586929 Bakere, Adam, of Neweport, baker 0
4749387 2280300 2280300 defendant Gebon Thomas tailor 586929 586929 Gebon, Thomas, of Neweport, tailor 2
4754483 2281782 2281782 defendant Spycer John spicer 586929 586929 Spycer, John, of Neweport, spicer 0
4756621 2282435 2282435 defendant Staundon William husbandman 586929 586929 Staundon, William, of Neweport, husbandman 0
4769175 2286336 2286336 defendant Rysdon Thomas chapman 586929 586929 Rysdon, Thomas, of Neweport, chapman 0
4777389 2288921 2288921 defendant Ferrur or Smith William husbandman 586929 586929 Ferrur or Smith, William, of Neweport, husbandman 0
4777390 2288921 2288921 defendant Cloche Thomas butcher 586929 586929 Cloche, Thomas, of Neweport, butcher 1
4789649 2292830 2292830 defendant Pope John smith 586929 586929 Pope, John, of Neweport, smith 1
4829508 2305268 2305268 defendant Lisle Thomas esq 586929 586929 Lisle, Thomas, of Neweport, esq 0
4829570 2305290 2305290 defendant Gace John (legal representative) 586929 586929 Gace, John, of Neweport, yeoman, executrix of 0
4829572 2305290 2305290 defendant Hawekyn William fishmonger 586929 586929 Hawekyn, William, of Neweport, fishmonger 2
4846580 2310440 2310440 defendant Kyng John husbandman 586929 586929 Kyng, John, of Neweport, husbandman 2
4855658 2313140 2313140 defendant White John merchant 586929 586929 White, John, of Neweport, merchant 0
4856354 2313361 2313361 defendant Lysle Thomas esq 586929 586929 Lysle, Thomas, of Neweport, esq 0
4856356 2313362 2313362 defendant Lysle Thomas esq 586929 586929 Lysle, Thomas, of Neweport, esq 0
4856390 2313375 2313375 defendant Gace John (legal representative) 586929 586929 Gace, John, of Neweport, yeoman, executrix of 0
4856391 2313375 2313375 defendant Gace Anne widow 586929 586929 Gace, Anne, of Neweport, widow 1
4874227 2318884 2318884 defendant Melet John husbandman 586929 586929 Melet, John, of Neweport, husbandman 1
4874228 2318884 2318884 defendant Kyng John husbandman 586929 586929 Kyng, John, of Neweport, husbandman 2
4874229 2318884 2318884 defendant Gace or Gate Anne widow 586929 586929 Gace or Gate, Anne, of Neweport, widow 3
4874230 2318884 2318884 defendant Mildenhale John husbandman 586929 586929 Mildenhale, John, of Neweport, husbandman 4
4874231 2318884 2318884 defendant Trumpour John husbandman 586929 586929 Trumpour, John, of Neweport, husbandman 5
4904279 2327953 2327953 defendant Hopper John husbandman 586929 586929 Hopper, John, of Neweport, husbandman 0
4908320 2329157 2329157 defendant Trumper John husbandman 586929 586929 Trumper, John, of Neweport, husbandman 0
4930774 2336032 2336032 plaintiff Turnour John   586929 586929 Turnour, John, of Neweport 0
4930775 2336032 2336032 defendant Pecok William   586929 586929 Pecok, William, of Neweport, husbandman, son & heir of Andrew Pecok 0
4953269 2342940 2342940 defendant Turtell Henry husbandman 586929 586929 Turtell, Henry, of Neweport, husbandman 1
4953275 2342941 2342941 defendant Turtell Henry husbandman 586929 586929 Turtell, Henry, of Neweport, husbandman 1
4966243 2346835 2346835 defendant Stobard John husbandman 586929 586929 Stobard, John, of Neweport, husbandman 3
4968136 2347418 2347418 plaintiff Fraunceys John clerk 586929 586929 Fraunceys, John, of Neweport, clerk 0
4968378 2347507 2347507 defendant Fraunceys John chapman 586929 586929 Fraunceys, John, of Neweport, chapman 0
4969280 2347771 2347771 defendant Stonehard John miller 586929 586929 Stonehard, John, of Neweport, miller 2
4970146 2348022 2348022 plaintiff Harlyng John, senior   586929 586929 Harlyng, John, senior, of Neweport 0
4970148 2348022 2348022 defendant Punt Thomas husbandman 586929 586929 Punt, Thomas, of Neweport, husbandman 1
4979615 2350860 2350860 defendant Pount Thomas husbandman 586929 586929 Pount, Thomas, of Neweport, husbandman 1
4979616 2350860 2350860 defendant Gybon Thomas husbandman 586929 586929 Gybon, Thomas, of Neweport, husbandman 2
4979683 2350879 2350879 defendant Pount Thomas husbandman 586929 586929 Pount, Thomas, of Neweport, husbandman 1
4979684 2350879 2350879 defendant Gybon Thomas husbandman 586929 586929 Gybon, Thomas, of Neweport, husbandman 2
4988970 2353640 2353640 defendant Peyseth William miller 586929 586929 Peyseth, William, of Neweport, miller 0
5033078 2366558 2366558 defendant Ponde John husbandman 586929 586929 Ponde, John, of Neweport, husbandman 1
5033082 2366558 2366558 defendant Pount Thomas husbandman 586929 586929 Pount, Thomas, of Neweport, husbandman 5
5033192 2366590 2366590 defendant Ponde John husbandman 586929 586929 Ponde, John, of Neweport, husbandman 1
5037073 2367711 2367711 defendant Gybon Thomas husbandman 586929 586929 Gybon, Thomas, of Neweport, husbandman 0
5037074 2367711 2367711 defendant Gebon John husbandman 586929 586929 Gebon, John, of Neweport, husbandman 1
5037076 2367712 2367712 defendant Gybon Thomas husbandman 586929 586929 Gybon, Thomas, of Neweport, husbandman 0
5037077 2367712 2367712 defendant Gybon John husbandman 586929 586929 Gybon, John, of Neweport, husbandman 1
5075326 2379120 2379120 defendant Martyndale Thomas yeoman 586929 586929 Martyndale, Thomas, of Neweport, yeoman 0
5083105 2381456 2381456 defendant Martyndale Thomas yeoman 586929 586929 together with Martyndale, Thomas, of Neweport, yeoman 1
5083107 2381457 2381457 defendant Martyndale Thomas yeoman 586929 586929 Martyndale, Thomas, of Neweport, yeoman 0
5084044 2381730 2381730 defendant Neweman Alexander smith 586929 586929 Neweman, Alexander, of Neweport, smith 0
5105618 2388093 2388093 defendant Turnour John shoemaker 586929 586929 Turnour, John, of Neweport, shoemaker 1
5105619 2388093 2388093 defendant Pont Thomas husbandman 586929 586929 Pont, Thomas, of Neweport, husbandman 2
5105622 2388094 2388094 defendant Torner John shoemaker 586929 586929 Torner, John, of Neweport, shoemaker 1
5105623 2388094 2388094 defendant Pont Thomas husbandman 586929 586929 Pont, Thomas, of Neweport, husbandman 2
5115313 2390906 2390906 defendant Mot John, senior husbandman 586929 586929 Mot, John, senior, of Neweport, or of Ugle, husbandman 0
5116281 2391192 2391192 defendant Fraunceys John yeoman 586929 586929 Fraunceys, John, of Neweport, yeoman 0
5169187 2406726 2406726 plaintiff Gase Anne (legal representative) 586929 586929 Gase, Anne, of Neweport, administrator of 0
5169189 2406726 2406726 defendant Henham John husbandman 586929 586929 Henham, John, of Neweport, husbandman 0
5179744 2409811 2409811 defendant Hasard William mariner 586929 586929 Hasard, William, of Neweport, mariner 0
5179746 2409812 2409812 defendant Hasard William mariner 586929 586929 Hasard, William, of Neweport, mariner 0
5182164 2410535 2410535 defendant Glover Thomas weaver 586929 586929 Glover, Thomas, of Neweport, weaver 4
5182165 2410535 2410535 defendant Sadeler Thomas sadler 586929 586929 Sadeler, Thomas, of Neweport, sadler 5
5204883 2417180 2417180 plaintiff Gace Anne (legal representative) 586929 586929 Gace, Anne, of Neweport, administrator of 0
5204885 2417180 2417180 defendant Henham John husbandman 586929 586929 Henham, John, of Neweport, husbandman 0
5204887 2417180 2417180 defendant Punte Thomas husbandman 586929 586929 together with Punte, Thomas, of Neweport, husbandman 2
5234771 2425759 2425759 defendant Tanner Thomas chandler 586929 586929 Tanner, Thomas, of Neweport, chandler 1
5247984 2429546 2429546 defendant Markus Edmund chapman 586929 586929 Markus, Edmund, of Neweport, chapman 2
5247988 2429546 2429546 defendant Snell or Suell Robert   586929 586929 Snell or Suell, Robert, of Neweport, 6
5256558 2432171 2432171 plaintiff Draper Thomas   586929 586929 Draper, Thomas, of Neweport, minstrel 0
5269807 2436279 2436279 defendant fitz John Robert yeoman 586929 586929 fitz John, Robert, of Neweport, yeoman 0
5289511 2441934 2441934 defendant Stokker John husbandman 586929 586929 Stokker, John, of Neweport, husbandman 2
5297884 2444389 2444389 plaintiff Austen Thomas (legal representative) 586929 586929 Austen, Thomas, of Neweport, executor of 0
5300873 2445223 2445223 defendant Rodon Thomas hewester 586929 586929 Rodon, Thomas, of Neweport, hewester 1
5301502 2445406 2445406 defendant Salman William husbandman 586929 586929 Salman, William, of Neweport, husbandman 0
5350029 2460135 2460135 defendant Wyrall Roger baker 586929 586929 Wyrall, Roger, of Neweport, baker 1
5350030 2460135 2460135 defendant Lytelhales Thomas weaver 586929 586929 Lytelhales, Thomas, of Neweport, weaver 2
5350031 2460135 2460135 defendant Alceter William cordwainer 586929 586929 Alceter, William, of Neweport, cordwainer 3
5350032 2460135 2460135 defendant Martyn homas dyer 586929 586929 Martyn, homas, of Neweport, dyer 4
5350033 2460135 2460135 defendant Milnere Nicholas miller 586929 586929 Milnere, Nicholas, of Neweport, miller 5
5350034 2460135 2460135 defendant Bulkeley Richard yeoman 586929 586929 Bulkeley, Richard, of Neweport, yeoman 6
5354891 2461605 2461605 defendant Sharp John mercer 586929 586929 Sharp, John, of Neweport, mercer 1
5374410 2467600 2467600 defendant Bulkeley Richard yeoman 586929 586929 Bulkeley, Richard, of Neweport, yeoman 0
5382244 2469981 2469981 defendant Bulkeley Richard yeoman 586929 586929 Bulkeley, Richard, of Neweport, yeoman 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);