names

82 rows where place_id = 600545

✎ 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
3640540 1907478 1907478 defendant Smyth William yeoman 600545 600545 Smyth, William, of Fyssherton Anger, yeoman 1
3640541 1907478 1907478 defendant verton John yeoman 600545 600545 verton, John, of Fyssherton Anger, yeoman 2
3641473 1907792 1907792 defendant Frankleng John yeoman 600545 600545 Frankleng, John, of Fyssherton Ancher, yeoman 0
3671557 1917088 1917088 defendant Regeant John weaver 600545 600545 Regeant, John, of Fyssherton Anger, weaver 0
3686313 1921876 1921876 defendant Ingram Robert husbandman 600545 600545 Ingram, Robert, of Fyssherton Dalamer, husbandman 0
3774205 1949647 1949647 defendant Tyler Richard tiler 600545 600545 Tyler, Richard, of Fyssherton Ancher, tiler 0
3902541 1991085 1991085 defendant Mussell John brewer 600545 600545 Mussell, John, of Fyssherton Anger, brewer 2
3902545 1991085 1991085 defendant Marsshall William (legal representative) 600545 600545 Marsshall, William, of Fyssherton Anger, glover, executors of 6
3902546 1991085 1991085 defendant Marsshall John yeoman 600545 600545 (Marsshall, John, of Fyssherton Anger, yeoman 7
3902547 1991085 1991085 defendant Marsshall Elizabeth widow 600545 600545 Marsshall, Elizabeth, of Fyssherton Anger, widow 8
3960434 2010747 2010747 defendant Marshall John yeoman 600545 600545 Marshall, John, of Fyssherton Anger, yeoman 2
4003206 2025907 2025907 defendant Marshall John yeoman 600545 600545 Marshall, John, of Fyssherton Anger, yeoman 0
4023261 2033026 2033026 defendant Orpytt or Orpyn Robert carpenter 600545 600545 Orpytt or Orpyn, Robert, of Fyssherton Anger, carpenter 1
4455565 2186747 2186747 defendant Leycestre Thomas   600545 600545 Leycestre, Thomas, of Fyssherton Ancher 0
4646111 2244935 2244935 defendant Russell Robert   600545 600545 Russell, Robert, of Fyssherton Anger 0
4654611 2247323 2247323 defendant Broun Robert tanner 600545 600545 Broun, Robert, of Fyssherton Ancher, tanner 1
4654868 2247402 2247402 defendant Smyth Thomas smith 600545 600545 Smyth, Thomas, of Fyssherton Ancher, smith 0
4655022 2247453 2247453 defendant Marleburgh Thomas hosteler 600545 600545 Marleburgh, Thomas, of Fyssherton Ancher, hosteler 0
4667403 2255526 2255526 defendant Grene John husbandman 600545 600545 Grene, John, of Fyssherton, husbandman 1
4674883 2257753 2257753 defendant Bailly John fuller 600545 600545 Bailly, John, of Fyssherton Ancher, fuller 0
4676694 2258329 2258329 defendant Raulton John   600545 600545 Raulton, John, of Fyssherton Ancher, mason 2
4701325 2265814 2265814 defendant Ballard John, sen husbandman 600545 600545 Ballard, John, sen, of Fyssherton Ancher, husbandman 1
4709546 2268342 2268342 defendant Milbourne John gent 600545 600545 Milbourne, John, of Fyssherton Ancher, gent 0
4710788 2268730 2268730 defendant Puse John laborer 600545 600545 Puse, John, of Fyssherton Ancher, laborer 1
4724798 2273053 2273053 defendant Horne John summoner 600545 600545 Horne, John, of Fyssherton Auncher, summoner 0
4732574 2275364 2275364 defendant Benet Thomas haulier 600545 600545 Benet, Thomas, of Fyssherton Auncher, haulier 0
4743739 2278698 2278698 defendant Milbourne John gent 600545 600545 Milbourne, John, of Fyssherton Ancher, gent 0
4755108 2281984 2281984 defendant Webbe Henry weaver 600545 600545 Webbe, Henry, of Fyssherton Ancher, weaver 1
4778957 2289396 2289396 defendant Derlyng John laborer 600545 600545 Derlyng, John, of Fyssherton Ancher, laborer 2
4791056 2293298 2293298 defendant Baker Gregory baker 600545 600545 Baker, Gregory, of Fyssherton Ancher, baker 0
4798590 2295739 2295739 defendant Halle Simon clothmaker 600545 600545 Halle, Simon, of Fyssherton Ancher, clothmaker 1
4826779 2304413 2304413 defendant Trevys Richard chapman 600545 600545 Trevys, Richard, of Fyssherton Ancher, chapman 0
4844093 2309663 2309663 defendant Welles John butcher 600545 600545 Welles, John, of Fyssherton Ancher, butcher 0
4851961 2312046 2312046 plaintiff Wallop John   600545 600545 Wallop, John, of Fyssherton, mason 0
4853105 2312389 2312389 defendant Fontell John husbandman 600545 600545 Fontell, John, of Fyssherton Ancher, husbandman 1
4863382 2315515 2315515 defendant Peny Richard husbandman 600545 600545 Peny, Richard, of Fyssherton Ancher, husbandman 0
4878259 2320152 2320152 plaintiff Wallop John   600545 600545 Wallop, John, of Fyssherton, mason 1
4879961 2320647 2320647 defendant Pese Robert laborer 600545 600545 Pese, Robert, of Fyssherton Ancher, laborer 1
4879962 2320647 2320647 defendant Castell David laborer 600545 600545 together with Castell, David, of Fyssherton Ancher, laborer 2
4879963 2320647 2320647 defendant Gildeprene or Gildepreve Roger brewer 600545 600545 Gildeprene or Gildepreve, Roger, of Fyssherton Ancher, brewer 3
4891623 2324119 2324119 defendant Webbe John weaver 600545 600545 Webbe, John, of Fyssherton, weaver 0
4891624 2324119 2324119 defendant Peny John husbandman 600545 600545 Peny, John, of Fyssherton, husbandman 1
4952851 2342811 2342811 defendant Selby Robert   600545 600545 Selby, Robert, of Fyssherton Ancher, bailiff 1
4962112 2345575 2345575 defendant Cleter John husbandman 600545 600545 Cleter, John, of Fyssherton Anger, husbandman 0
4964730 2346361 2346361 defendant Somerham Thomas carpenter 600545 600545 Somerham, Thomas, of Fyssherton Ancher, carpenter 1
4973023 2348862 2348862 defendant Mundy Thomas laborer 600545 600545 Mundy, Thomas, of Fyssherton Ancher, laborer 0
4976300 2349866 2349866 defendant Purter or Pulter Robert yeoman 600545 600545 Purter or Pulter, Robert, of Fyssherton Ancher, yeoman 1
5030136 2365683 2365683 defendant Messager Walter gent 600545 600545 Messager, Walter, of Fyssherton Ancher, gent 0
5031005 2365946 2365946 defendant Godyslond John saddler 600545 600545 Godyslond, John, of Fyssherton Ancher, saddler 0
5034893 2367062 2367062 defendant Danyell John   600545 600545 Danyell, John, of Fyssherton Ancher, "galegge maker" 1
5057716 2373876 2373876 defendant Wymborne John yeoman 600545 600545 Wymborne, John, of Fyssherton Ancher, yeoman 0
5077253 2379699 2379699 defendant Scotte Mathew husbandman 600545 600545 Scotte, Mathew, of Fyssherton Ancher, husbandman 2
5077254 2379699 2379699 defendant Hoker John yeoman 600545 600545 Hoker, John, of Fyssherton Ancher, yeoman 3
5109375 2389171 2389171 defendant Beverle Thomas yeoman 600545 600545 Beverle, Thomas, of Fyssherton Ancher, yeoman 1
5123718 2393397 2393397 defendant Wymborne John hosteler 600545 600545 Wymborne, John, of Fyssherton Ancher, hosteler 0
5154568 2402489 2402489 defendant Bocher Robert butcher 600545 600545 Bocher, Robert, of Fyssherton Ancher, butcher 3
5158042 2403474 2403474 defendant Danyell John   600545 600545 Danyell, John, of Fyssherton Ancher, paten maker 1
5173762 2408021 2408021 defendant Danyell John   600545 600545 Danyell, John, of Fyssherton Ancher, paten maker 1
5178864 2409544 2409544 defendant Walker Richard merchant 600545 600545 Walker, Richard, of Fyssherton Ancher, merchant 2
5193873 2413933 2413933 defendant Danyell John   600545 600545 Danyell, John, of Fyssherton Ancher, paten maker 0
5201644 2416247 2416247 defendant Walker Richard merchant 600545 600545 Walker, Richard, of Fyssherton Ancher, merchant 0
5208428 2418192 2418192 defendant Danyell John   600545 600545 Danyell, John, of Fyssherton Ancher, paten maker 0
5210716 2418866 2418866 defendant Damell John   600545 600545 Damell, John, of Fyssherton Ancher, galosh maker 5
5212994 2419538 2419538 defendant Beverley Thomas yeoman 600545 600545 Beverley, Thomas, of Fyssherton Ancher, yeoman 0
5231060 2424681 2424681 defendant Beverley Thomas yeoman 600545 600545 Beverley, Thomas, of Fyssherton Ancher, yeoman 3
5241712 2427784 2427784 defendant Cappys John yeoman 600545 600545 Cappys, John, of Fyssherton Ancher, yeoman 0
5257202 2432381 2432381 defendant Beverley Thomas (legal representative) 600545 600545 Beverley, Thomas, of Fyssherton Ancher, executrix of 8
5261119 2433589 2433589 defendant Crede John husbandman 600545 600545 Crede, John, of Fyssherton Anger, husbandman 0
5261120 2433589 2433589 defendant Person John husbandman 600545 600545 Person, John, of Fyssherton Anger, husbandman 1
5263108 2434204 2434204 defendant Hayward Alice widow 600545 600545 Hayward, Alice, of Fyssherton Ancher, widow 3
5282209 2439862 2439862 defendant Hatherant alias Gye John glover 600545 600545 Hatherant alias Gye, John, of Fyssherton, glover 0
5282230 2439867 2439867 defendant Petyn Walter yeoman 600545 600545 Petyn, Walter, of Fyssherton, yeoman 2
5340853 2457341 2457341 defendant Kechyn Alice widow 600545 600545 Kechyn, Alice, of Fyssherton Anger, widow 0
5355844 2461902 2461902 defendant Tayllour William tailor 600545 600545 Tayllour, William, of Fyssherton Ancher, tailor 0
5369497 2466053 2466053 defendant Hall Reginald mercer 600545 600545 Hall, Reginald, of Fyssherton Ancher, mercer 1
5414255 2479197 2479197 defendant Straford Thomas yeoman 600545 600545 Straford, Thomas, of Fyssherton Aucher or Anger, yeoman 2
5429936 2483892 2483892 defendant Straford Thomas yeoman 600545 600545 Straford, Thomas, of Fyssherton Anger, yeoman 1
5429941 2483893 2483893 defendant Stratford Thomas yeoman 600545 600545 Stratford, Thomas, of Fyssherton Ancher, yeoman 2
5512995 2508916 2508916 defendant Dymes John carpenter 600545 600545 Dymes, John, of Fyssherton Ancher, carpenter 1
5516394 2509961 2509961 defendant Hoskyns John husbandman 600545 600545 Hoskyns, John, of Fyssherton Ancher, husbandman 2
5599878 2534846 2534846 defendant Horder William miller 600545 600545 Horder, William, of Fyssherton Anger, miller 2
5604756 2536350 2536350 defendant Wyndon John glover 600545 600545 Wyndon, John, of Fyssherton Anger, glover 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);