names

92 rows where place_id = 590859

✎ 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
3602536 1868454 1868454 defendant Hake John yeoman 590859 590859 Hake, John, of Navestoke, yeoman 0
3707446 1928624 1928624 defendant Nevebek or Nevelek John husbandman 590859 590859 Nevebek or Nevelek, John, of Navestoke, husbandman 0
3707456 1928626 1928626 defendant Neveloke John husbandman 590859 590859 Neveloke, John, of Navestoke, husbandman 0
3710926 1929734 1929734 defendant Hawe or Halke John, senior husbandman 590859 590859 Hawe or Halke, John, senior, of Navestoke, husbandman 3
3740634 1938932 1938932 defendant Comyn Ralph tanner 590859 590859 Comyn, Ralph, of Navestoke, tanner 1
4413815 2169216 2169216 defendant Boxere William   590859 590859 Boxere, William, of Navestoke 6
4413816 2169216 2169216 defendant Richard William   590859 590859 Richard William, of Navestoke 7
4413817 2169216 2169216 defendant Pymchoun John   590859 590859 Pymchoun, John, of Navestoke 8
4521132 2206948 2206948 defendant Fraunceys John   590859 590859 Fraunceys, John, of Navestoke 5
4563342 2220107 2220107 defendant Hirstman Walter   590859 590859 Hirstman, Walter, of Navestoke 0
4590559 2228405 2228405 defendant Dod John   590859 590859 Dod, John, of Navestoke 1
4621432 2237695 2237695 defendant Gardyner Francis   590859 590859 Gardyner, Francis, of Navestoke 0
4627248 2239471 2239471 defendant Bocher John   590859 590859 Bocher, John, of Navestoke 3
4655157 2247493 2247493 defendant Clerk William husbandman 590859 590859 Clerk, William, of Navestoke, husbandman 0
4655159 2247494 2247494 defendant Clerk William husbandman 590859 590859 Clerk, William, of Navestoke, husbandman 0
4655161 2247495 2247495 defendant Clerk William husbandman 590859 590859 Clerk, William, of Navestoke, husbandman 0
4655223 2247517 2247517 defendant Clerk William husbandman 590859 590859 Clerk, William, of Navestoke, , husbandman 0
4655224 2247517 2247517 defendant Clerk John husbandman 590859 590859 Clerk, John, of Navestoke, husbandman 1
4655226 2247518 2247518 defendant Clerk William husbandman 590859 590859 Clerk, William, of Navestoke, husbandman 0
4655227 2247518 2247518 defendant Clerk John husbandman 590859 590859 Clerk, John, of Navestoke, husbandman 1
4659375 2248792 2248792 defendant Passelewe Roger husbandman 590859 590859 Passelewe, Roger, of Navestoke, husbandman 0
4713023 2269393 2269393 defendant Bocher John butcher 590859 590859 Bocher, John, of Navestoke, butcher 1
4729840 2274538 2274538 defendant Gippe Robert husbandman 590859 590859 Gippe, Robert, of Navestoke, husbandman 1
4734429 2275936 2275936 defendant Turgys John husbandman 590859 590859 Turgys, John, of Navestoke, husbandman 0
4746463 2279457 2279457 defendant Herry John skinner 590859 590859 Herry, John, of Navestoke, skinner 0
4746464 2279457 2279457 defendant Herd William drover 590859 590859 Herd, William, of Navestoke, drover 1
4748063 2279945 2279945 defendant Olyve John   590859 590859 Olyve, John, of Navestoke, bailiff 2
4751963 2281067 2281067 defendant Olyve Thomas   590859 590859 Olyve, Thomas, of Navestoke, bailiff 0
4766079 2285380 2285380 plaintiff Kyrkeby Richard   590859 590859 Kyrkeby, Richard, of Navestoke 0
4766082 2285381 2285381 plaintiff Kyrkeby Richard   590859 590859 Kyrkeby, Richard, of Navestoke 0
4766087 2285382 2285382 plaintiff Kyrkeby Richard   590859 590859 Kyrkeby, Richard, of Navestoke 0
4766089 2285383 2285383 plaintiff Kyrkeby Richard   590859 590859 Kyrkeby, Richard, of Navestoke 0
4769419 2286410 2286410 defendant Sunday Nicholas husbandman 590859 590859 Sunday, Nicholas, of Navestoke, husbandman 0
4786756 2291912 2291912 defendant Coupere Richard shoemaker 590859 590859 Coupere, Richard, of Navestoke, shoemaker 0
4790261 2293037 2293037 plaintiff Kirkeby Richard   590859 590859 Kirkeby, Richard, of Navestoke 0
4790476 2293111 2293111 plaintiff Kyrkeby Richard   590859 590859 Kyrkeby, Richard, of Navestoke 0
4790478 2293112 2293112 plaintiff Kyrkeby Richard   590859 590859 Kyrkeby, Richard, of Navestoke 0
4801466 2296639 2296639 defendant Scarlet Richard carpenter 590859 590859 Scarlet, Richard, of Navestoke, carpenter 2
4809849 2299243 2299243 defendant Bette William husbandman 590859 590859 Bette, William, of Navestoke, husbandman 0
4817790 2301647 2301647 defendant Bette William   590859 590859 Bette, William, of Navestoke 0
4836143 2307284 2307284 defendant Morys John husbandman 590859 590859 Morys, John, of Navestoke, husbandman 0
4863560 2315572 2315572 defendant Morys John husbandman 590859 590859 Morys, John, of Navestoke, husbandman 0
4898059 2326063 2326063 defendant Ferrour or Smith John smith 590859 590859 Ferrour or Smith, John, of Navestoke, smith 0
4898060 2326063 2326063 defendant Salysbury John husbandman 590859 590859 Salysbury, John, of Navestoke, husbandman 1
4946213 2340800 2340800 plaintiff Clerk John, junior   590859 590859 Clerk, John, junior, of Navestoke 4
4947973 2341353 2341353 defendant Hedelff alias Heerde John husbandman 590859 590859 Hedelff alias Heerde, John, of Navestoke, husbandman 0
4987536 2353228 2353228 defendant Bury John husbandman 590859 590859 Bury, John, of Navestoke, husbandman 0
4987537 2353228 2353228 defendant Bette Henry husbandman 590859 590859 Bette, Henry, of Navestoke, husbandman 1
4987539 2353228 2353228 defendant Herry John skinner 590859 590859 Herry, John, of Navestoke, skinner 3
4987540 2353228 2353228 defendant Clerk John baker 590859 590859 Clerk, John, of Navestoke, baker 4
5010421 2359918 2359918 defendant Rukke John yeoman 590859 590859 Rukke, John, of Navestoke, yeoman 0
5010422 2359918 2359918 defendant Bette William yeoman 590859 590859 Bette, William, of Navestoke, yeoman 1
5010423 2359918 2359918 defendant Rukke William yeoman 590859 590859 Rukke, William, of Navestoke, yeoman 2
5035261 2367175 2367175 defendant Clerk John husbandman 590859 590859 Clerk, John, of Navestoke, husbandman 1
5035262 2367175 2367175 defendant Clerk William husbandman 590859 590859 Clerk, William, of Navestoke, husbandman 2
5079996 2380496 2380496 defendant Etholf John husbandman 590859 590859 Etholf, John, of Navestoke, husbandman 4
5084072 2381739 2381739 defendant Olyve Nicholas laborer 590859 590859 Olyve, Nicholas, of Navestoke, laborer 0
5116808 2391346 2391346 defendant Martyn Thomas husbandman 590859 590859 Martyn, Thomas, of Navestoke, husbandman 0
5131056 2395569 2395569 defendant Smyth William, junior husbandman 590859 590859 Smyth, William, junior, of Navestoke, husbandman 2
5246072 2429017 2429017 defendant Clerk John husbandman 590859 590859 Clerk, John, of Navestoke, husbandman 0
5246073 2429017 2429017 defendant Pelham John husbandman 590859 590859 Pelham, John, of Navestoke, husbandman 1
5246074 2429017 2429017 defendant Rukke Thomas husbandman 590859 590859 Rukke, Thomas, of Navestoke, husbandman 2
5246075 2429017 2429017 defendant Harry John husbandman 590859 590859 Harry, John, of Navestoke, husbandman 3
5284306 2440429 2440429 defendant Partryche Roger butcher 590859 590859 Partryche, Roger, of Navestoke, butcher 0
5308034 2447425 2447425 defendant Conners John husbandman 590859 590859 Conners, John, of Navestoke, husbandman 0
5310532 2448186 2448186 defendant Brygges Edward husbandman 590859 590859 Brygges, Edward, of Navestoke, husbandman 2
5315648 2449743 2449743 defendant Jenyn Richard yeoman 590859 590859 Jenyn, Richard, of Navestoke, yeoman 0
5315650 2449744 2449744 defendant Jenyn Richard yeoman 590859 590859 Jenyn, Richard, of Navestoke, yeoman 0
5324771 2452485 2452485 defendant Maram Richard laborer 590859 590859 Maram, Richard, of Navestoke, laborer 3
5327833 2453392 2453392 defendant Janyn Richard yeoman 590859 590859 Janyn, Richard, of Navestoke, yeoman 0
5334134 2455274 2455274 defendant Bette Richard smith 590859 590859 Bette, Richard, of Navestoke, smith 1
5334972 2455528 2455528 defendant Jenyn Thomas carpenter 590859 590859 Jenyn, Thomas, of Navestoke, carpenter 3
5341899 2457665 2457665 defendant Haukyn or Hankyn William husbandman 590859 590859 Haukyn or Hankyn, William, of Navestoke, husbandman 0
5352261 2460806 2460806 defendant Partrich Roger yeoman 590859 590859 Partrich, Roger, of Navestoke, yeoman 0
5357372 2462372 2462372 defendant Monger William carpenter 590859 590859 Monger, William, of Navestoke, carpenter 0
5358298 2462650 2462650 plaintiff Parterich Roger   590859 590859 Parterich, Roger, of Navestoke 0
5358301 2462650 2462650 defendant Jenyn John butcher 590859 590859 Jenyn, John, of Navestoke, butcher 2
5358302 2462650 2462650 defendant Jenyne Thomas carpenter 590859 590859 Jenyne, Thomas, of Navestoke, carpenter 3
5358303 2462650 2462650 defendant Colnord John smith 590859 590859 Colnord, John, of Navestoke, smith 4
5390654 2472390 2472390 defendant Lambe John laborer 590859 590859 Lambe, John, of Navestoke, laborer 1
5415097 2479455 2479455 defendant Comers John husbandman 590859 590859 Comers, John, of Navestoke, husbandman 1
5416693 2479910 2479910 defendant Lambe (illegible) laborer 590859 590859 Lambe,_, of Navestoke, laborer 1
5464860 2494404 2494404 defendant Pellam John tanner 590859 590859 Pellam, John, of Navestoke, tanner 0
5476370 2497937 2497937 defendant Pelham John tanner 590859 590859 Pelham, John, of Navestoke, tanner 0
5486770 2500944 2500944 defendant Lyncolne John smith 590859 590859 Lyncolne, John, of Navestoke, smith 1
5510093 2507993 2507993 defendant Slye William husbandman 590859 590859 Slye, William, of Navestoke, husbandman 0
5510094 2507993 2507993 defendant Bettys Thomas husbandman 590859 590859 Bettys, Thomas, of Navestoke, husbandman 1
5542798 2517868 2517868 defendant Brokase Geoffrey husbandman 590859 590859 Brokase, Geoffrey, of Navestoke, husbandman 4
5602448 2535658 2535658 defendant Skynner John husbandman 590859 590859 Skynner, John, of Navestoke, husbandman 0
5604912 2536406 2536406 defendant A More Robert miller 590859 590859 A More, Robert, of Navestoke, miller 3
5608933 2537694 2537694 defendant Pelham John tanner 590859 590859 Pelham, John, of Navestoke, tanner 3
5627930 2552704 2552704 defendant Passhelewe Roger yeoman 590859 590859 Passhelewe, Roger, of Navestoke, yeoman 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);