names

87 rows where place_id = 633918

✎ 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
3815614 1962799 1962799 defendant Trymmell Christopher tucker 633918 633918 Trymmell, Christopher, of Poterne, tucker 2
3902850 1991187 1991187 plaintiff Flower John husbandman 633918 633918 Flower, John, of Poterne, husbandman 0
4530871 2209944 2209944 defendant Floure William   633918 633918 Floure, William, of Poterne 0
4559364 2218881 2218881 defendant Axeford Adam   633918 633918 Axeford, Adam, of Poterne 0
4559367 2218881 2218881 defendant Hyle William in the   633918 633918 Hyle, William in the, of Poterne 3
4576456 2224151 2224151 defendant Carter Adam   633918 633918 Carter, Adam, of Poterne 1
4596699 2230206 2230206 defendant Priour William, sen   633918 633918 Priour, William, sen, of Poterne 0
4596712 2230211 2230211 defendant Barlich John   633918 633918 Barlich, John, of Poterne 1
4596713 2230211 2230211 defendant Lange William   633918 633918 Lange, William, of Poterne 2
4596714 2230211 2230211 defendant Axeford Adam   633918 633918 Axeford, Adam, of Poterne 3
4605835 2232938 2232938 defendant Lange William   633918 633918 Lange, William, of Poterne 0
4616478 2236148 2236148 defendant Poterne Henry   633918 633918 Poterne, Henry, of Poterne 0
4643162 2244108 2244108 defendant Westfeld John   633918 633918 Westfeld, John, of Poterne 3
4653815 2247104 2247104 defendant Godfray William laborer 633918 633918 Godfray, William, of Poterne, laborer 2
4653821 2247106 2247106 defendant Baronye William yeoman 633918 633918 Baronye, William, of Poterne, yeoman 2
4653822 2247106 2247106 defendant Axceford William husbandman 633918 633918 Axceford, William, of Poterne, husbandman 3
4653823 2247106 2247106 defendant Taillour Henry tailor 633918 633918 Taillour, Henry, of Poterne, tailor 4
4653824 2247106 2247106 defendant Pygefige John piper 633918 633918 Pygefige, John, of Poterne, piper 5
4653825 2247106 2247106 defendant Axceford John Williammsservant laborer 633918 633918 Axceford, John Williammsservant, of Poterne, laborer 6
4653826 2247106 2247106 defendant in the Lye John Richardesservant   633918 633918 in the Lye, John Richardesservant, of Poterne, servant 7
4653827 2247106 2247106 defendant Byncome John husbandman 633918 633918 Byncome, John, of Poterne, husbandman 8
4653828 2247106 2247106 defendant Selwode Thomas   633918 633918 Selwode, Thomas, of Poterne, groom 9
4653829 2247106 2247106 defendant atte Nasshe John, junior husbandman 633918 633918 atte Nasshe, John, junior, of Poterne, husbandman 10
4653833 2247107 2247107 defendant Baronye William yeoman 633918 633918 Baronye, William, of Poterne, yeoman 2
4653834 2247107 2247107 defendant Axceford William husbandman 633918 633918 Axceford, William, of Poterne, husbandman 3
4653835 2247107 2247107 defendant Taillour Henry tailor 633918 633918 Taillour, Henry, of Poterne, tailor 4
4653836 2247107 2247107 defendant Pygefige John piper 633918 633918 Pygefige, John, of Poterne, piper 5
4653837 2247107 2247107 defendant Axceford John Williammsservant laborer 633918 633918 Axceford, John Williammsservant, of Poterne, laborer 6
4653838 2247107 2247107 defendant Lye John Richardesservant   633918 633918 Lye, John Richardesservant, of Poterne, servant 7
4653839 2247107 2247107 defendant Byncome John husbandman 633918 633918 Byncome, John, of Poterne, husbandman 8
4653840 2247107 2247107 defendant Selwode Thomas   633918 633918 Selwode, Thomas, of Poterne, groom 9
4653841 2247107 2247107 defendant atte Nasshe John, junior husbandman 633918 633918 atte Nasshe, John, junior, of Poterne, husbandman 10
4728355 2274105 2274105 defendant Axford William husbandman 633918 633918 Axford, William, of Poterne, husbandman 0
4739675 2277483 2277483 defendant Shephurd Robert   633918 633918 Shephurd, Robert, of Poterne, plough man 1
4746391 2279441 2279441 defendant Boucher William butcher 633918 633918 Boucher, William, of Poterne, butcher 0
4758810 2283109 2283109 defendant Stere John husbandman 633918 633918 Stere, John, of Poterne, husbandman 0
4758811 2283109 2283109 defendant Hele Robert butcher 633918 633918 Hele, Robert, of Poterne, butcher 1
4760339 2283585 2283585 defendant Shepherd Robert butcher 633918 633918 Shepherd, Robert, of Poterne, husbandman: Brewer, John, of Devyses, butcher 2
4761290 2283878 2283878 defendant Axeford William husbandman 633918 633918 Axeford, William, of Poterne, husbandman 0
4770629 2286797 2286797 defendant Axeford William husbandman 633918 633918 Axeford, William, of Poterne, husbandman 0
4772417 2287340 2287340 defendant Axford William yeoman 633918 633918 Axford, William, of Poterne, yeoman 0
4772700 2287433 2287433 defendant Lyvedene or Lynedene William   633918 633918 Lyvedene or Lynedene, William, of Poterne 0
4773492 2287680 2287680 defendant Baker John baker 633918 633918 Baker, John, of Poterne, baker 1
4777213 2288859 2288859 defendant Axford William husbandman 633918 633918 Axford, William, of Poterne, husbandman 0
4780983 2290057 2290057 defendant Sterre John husbandman 633918 633918 Sterre, John, of Poterne, husbandman 0
4780984 2290057 2290057 defendant Hole Robert butcher 633918 633918 Hole, Robert, of Poterne, butcher 1
4797510 2295392 2295392 defendant Axford William yeoman 633918 633918 Axford, William, of Poterne, yeoman 0
4811993 2299864 2299864 defendant Aas William husbandman 633918 633918 Aas, William, of Poterne, husbandman 0
4814367 2300602 2300602 defendant Axeford William husbandman 633918 633918 Axeford, William, of Poterne, husbandman 1
4822550 2303127 2303127 defendant Axford William husbandman 633918 633918 Axford, William, of Poterne, husbandman 0
4822552 2303127 2303127 defendant Bocher John butcher 633918 633918 Bocher, John, of Poterne, butcher 2
4822553 2303127 2303127 defendant Smyth Robert husbandman 633918 633918 Smyth, Robert, of Poterne, husbandman 3
4832310 2306136 2306136 defendant Lyneden William husbandman 633918 633918 Lyneden, William, of Poterne, husbandman 0
4834400 2306765 2306765 defendant Axford William husbandman 633918 633918 Axford, William, of Poterne, husbandman 1
4838325 2307904 2307904 defendant Vyner Richard laborer 633918 633918 Vyner, Richard, of Poterne, laborer 0
4838326 2307904 2307904 defendant Clerk Geoffrey husbandman 633918 633918 Clerk, Geoffrey, of Poterne, husbandman 1
4838327 2307904 2307904 defendant Godfrey William husbandman 633918 633918 Godfrey, William, of Poterne, husbandman 2
4838331 2307904 2307904 defendant Holnest John husbandman 633918 633918 Holnest, John, of Poterne, husbandman 6
4875555 2319309 2319309 defendant Taillour Henry husbandman 633918 633918 Taillour, Henry, of Poterne, husbandman 0
4895402 2325225 2325225 defendant Shepherd Robert husbandman 633918 633918 Shepherd, Robert, of Poterne, husbandman 1
4901536 2327084 2327084 defendant Amy William laborer 633918 633918 Amy, William, of Poterne, laborer 1
4912781 2330494 2330494 plaintiff Touker William burcher 633918 633918 Touker, William, of Poterne, burcher 18
4915987 2331499 2331499 defendant Dokeman John weaver 633918 633918 Dokeman, John, of Poterne, weaver 0
4927492 2335032 2335032 defendant Taillour Henry husbandman 633918 633918 Taillour, Henry, of Poterne, husbandman 1
4942249 2339566 2339566 defendant Sterk William husbandman 633918 633918 Sterk, William, of Poterne, husbandman 0
4973373 2348977 2348977 defendant Godfrey William husbandman 633918 633918 Godfrey, William, of Poterne, husbandman 0
4976917 2350049 2350049 defendant atte Welle Robert husbandman 633918 633918 atte Welle, Robert, of Poterne, husbandman 0
5025208 2364267 2364267 defendant Cromdale William butcher 633918 633918 Cromdale, William, of Poterne, butcher 1
5025209 2364267 2364267 defendant Berde Thomas husbandman 633918 633918 Berde, Thomas, of Poterne, husbandman 2
5098581 2386018 2386018 defendant Lylbone John yeoman 633918 633918 Lylbone, John, of Poterne, yeoman 2
5098582 2386018 2386018 defendant Whitok William   633918 633918 Whitok, William, of Poterne, servant 3
5106810 2388420 2388420 defendant Amysse John butcher or chandler 633918 633918 Amysse, John, of Poterne, butcher or chandler 0
5181348 2410288 2410288 defendant Hawekyns William husbandman 633918 633918 Hawekyns, William, of Poterne, husbandman 0
5181349 2410288 2410288 defendant Payne William weaver 633918 633918 Payne, William, of Poterne, weaver 1
5181350 2410288 2410288 defendant Colyn Thomas husbandman 633918 633918 Colyn, Thomas, of Poterne, husbandman 2
5202883 2416606 2416606 defendant Hawekyns William husbandman 633918 633918 Hawekyns, William, of Poterne, husbandman 0
5202884 2416606 2416606 defendant Payne William weaver 633918 633918 Payne, William, of Poterne, weaver 1
5202885 2416606 2416606 defendant Colyn Thomas husbandman 633918 633918 Colyn, Thomas, of Poterne, husbandman 2
5257178 2432379 2432379 defendant Amys John butcher 633918 633918 Amys, John, of Poterne, butcher 1
5399665 2474992 2474992 defendant Cadley John husbandman 633918 633918 Cadley, John, of Poterne, husbandman 0
5412712 2478751 2478751 defendant Cadley John husbandman 633918 633918 Cadley, John, of Poterne, husbandman 0
5427578 2483202 2483202 defendant Cadley John husbandman 633918 633918 Cadley, John, of Poterne, husbandman 0
5445317 2488495 2488495 defendant Cadley John husbandman 633918 633918 Cadley, John, of Poterne, husbandman 0
5597453 2534104 2534104 defendant Frere William husbandman 633918 633918 Frere, William, of Poterne, husbandman 0
5616483 2548956 2548956 defendant Floure Walter   633918 633918 Floure, Walter, of Poterne 0
5616772 2549050 2549050 defendant Whisle William   633918 633918 Whisle, William, of Poterne 0
5616813 2549063 2549063 plaintiff Isman Thomas   633918 633918 Isman, Thomas, of Poterne 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);