names

74 rows where place_id = 610506

✎ 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
3683939 1921111 1921111 defendant Martyn John dyer 610506 610506 Martyn, John, of Barnstaple, dyer 0
3683940 1921111 1921111 defendant Andrewe Simon merchant 610506 610506 Andrewe, Simon, of Barnstaple, merchant 1
3742912 1939637 1939637 defendant Smyth Paul merchant 610506 610506 Smyth, Paul, of Barnstaple, merchant 0
3742913 1939637 1939637 defendant Symon Alice widow 610506 610506 Symon, Alice, of Barnstaple, widow 1
3742914 1939637 1939637 defendant Lewys Hoskin smith 610506 610506 Lewys, Hoskin, of Barnstaple, smith 2
3742918 1939637 1939637 defendant Skynner Richard yeoman 610506 610506 Skynner, Richard, of Barnstaple, yeoman 6
3742919 1939637 1939637 defendant Elys alias Bourcher John husbandman 610506 610506 Elys alias Bourcher, John, of Barnstaple, husbandman 7
3755077 1943537 1943537 defendant Smyth Paul merchant 610506 610506 Smyth, Paul, of Barnstaple, merchant 0
3755078 1943537 1943537 defendant Symon Alice widow 610506 610506 Symon, Alice, of Barnstaple, widow 1
3755079 1943537 1943537 defendant Lewys Husky smith 610506 610506 Lewys, Husky, of Barnstaple, smith 2
3755083 1943537 1943537 defendant Skynner Richard yeoman 610506 610506 Skynner, Richard, of Barnstaple, yeoman 6
3755084 1943537 1943537 defendant Elys alias Boucher John husbandman 610506 610506 Elys alias Boucher, John, of Barnstaple, husbandman 7
3928971 2000027 2000027 defendant Welshe John merchant 610506 610506 Welshe, John, of Barnstaple, merchant 0
3970468 2014268 2014268 plaintiff Delbridge Richard   610506 610506 Delbridge, Richard, of Barnstaple 0
3986328 2019850 2019850 plaintiff Welshe John merchant 610506 610506 Welshe, John, of Barnstaple, merchant 0
4022439 2032751 2032751 plaintiff Apley Robert merchant 610506 610506 Apley, Robert, of Barnstaple, merchant 0
4028549 2034862 2034862 defendant Cade George   610506 610506 Cade, George, of Barnstaple, merchant, his son 1
4028550 2034862 2034862 defendant Ferris Philip merchant 610506 610506 Ferris, Philip, of Barnstaple, merchant 2
4362572 2151667 2151667 defendant Brasyer Richard merchant 610506 610506 Brasyer, Richard, of Barnstaple, merchant 0
4415749 2169812 2169812 defendant atte Woghs Robert   610506 610506 atte Woghs, Robert, of Barnstaple 0
4640562 2243346 2243346 defendant (illegible) John   610506 610506 _, John, of Barnstaple 0
4710591 2268669 2268669 defendant Crokker John vintner 610506 610506 Crokker, John, of Barnstaple, vintner 0
4710592 2268669 2268669 defendant Crokker William husbandman 610506 610506 Crokker, William, of Barnstaple, husbandman 1
4711698 2268982 2268982 defendant Smale Richard   610506 610506 Smale, Richard, of Barnstaple, shoe maker 0
4712053 2269082 2269082 defendant Webber Thomas merchant 610506 610506 Webber, Thomas, of Barnstaple, merchant 0
4713148 2269437 2269437 plaintiff Stery Thomas   610506 610506 Stery, Thomas, of Barnstaple 0
4714366 2269823 2269823 plaintiff Toker John   610506 610506 Toker, John, of Barnstaple 0
4716657 2270529 2270529 defendant Langeston Richard husbandman 610506 610506 Langeston, Richard, of Barnstaple, husbandman 0
4742798 2278401 2278401 defendant Pytman John gent 610506 610506 Pytman, John, of Barnstaple, gent 0
4742799 2278401 2278401 defendant Pytman Henry husbandman 610506 610506 Pytman, Henry, of Barnstaple, husbandman 1
4755525 2282108 2282108 defendant More John merchant 610506 610506 More, John, of Barnstaple, merchant 0
4756814 2282497 2282497 defendant Melkesham Thomas merchant 610506 610506 Melkesham, Thomas, of Barnstaple, merchant 0
4756816 2282498 2282498 defendant Melkysham Thomas merchant 610506 610506 Melkysham, Thomas, of Barnstaple, merchant 0
4762048 2284114 2284114 plaintiff Farmando John merchant 610506 610506 Farmando, John, of Barnstaple, merchant 0
4766398 2285481 2285481 defendant Coule William laborer 610506 610506 Coule, William, of Barnstaple, laborer 0
4767506 2285815 2285815 defendant Stury Thomas merchant 610506 610506 Stury, Thomas, of Barnstaple, merchant 0
4767723 2285886 2285886 defendant Gille Thomas husbandman 610506 610506 Gille, Thomas, of Barnstaple, husbandman 0
4767726 2285886 2285886 defendant Bryd John tailor 610506 610506 Bryd, John, of Barnstaple, tailor 3
4767727 2285886 2285886 defendant Agger John   610506 610506 Agger, John, of Barnstaple, shoe maker 4
4767728 2285886 2285886 defendant Bragge Ralph goldsmith 610506 610506 Bragge, Ralph, of Barnstaple, goldsmith 5
4768320 2286063 2286063 defendant Mayour John merchant 610506 610506 Mayour, John, of Barnstaple, merchant 0
4772319 2287307 2287307 plaintiff Spencer Walter (legal representative) 610506 610506 Spencer, Walter, of Barnstaple, executors of 0
4775182 2288232 2288232 defendant Meyre Thomas merchant 610506 610506 Meyre, Thomas, of Barnstaple, merchant 0
4817019 2301422 2301422 defendant Hogg John shoemaker 610506 610506 Hogg, John, of Barnstaple, shoemaker 1
4843603 2309521 2309521 defendant Beere John baker 610506 610506 Beere, John, of Barnstaple, baker 0
4845645 2310148 2310148 defendant Gole Richard fuller 610506 610506 Gole, Richard, of Barnstaple, fuller 0
4845647 2310148 2310148 defendant Stokehay John dyer 610506 610506 Stokehay, John, of Barnstaple, dyer 2
4850889 2311724 2311724 defendant Toker David fuller of cloth 610506 610506 Toker, David, of Barnstaple, fuller of cloth 2
4985881 2352694 2352694 defendant Colle John shipman 610506 610506 Colle, John, of Barnstaple, shipman 0
5001374 2357286 2357286 defendant Knygford John yeoman 610506 610506 Knygford, John, of Barnstaple, yeoman 1
5007708 2359146 2359146 defendant Quance John husbandman 610506 610506 Quance, John, of Barnstaple, husbandman 2
5007709 2359146 2359146 defendant Upcote Walter merchant 610506 610506 Upcote, Walter, of Barnstaple, merchant 3
5011402 2360198 2360198 defendant Croycche John merchant 610506 610506 Croycche, John, of Barnstaple, merchant 1
5048249 2371110 2371110 defendant Kyngford John yeoman 610506 610506 Kyngford, John, of Barnstaple, yeoman 1
5136476 2397185 2397185 defendant Cole John husbandman 610506 610506 (Cole, John, of Barnstaple, husbandman 2
5169793 2406909 2406909 defendant Babron Richard merchant 610506 610506 Babron, Richard, of Barnstaple, merchant 0
5177620 2409148 2409148 defendant Tapper Connor smith 610506 610506 Tapper, Connor, of Barnstaple, smith 0
5179973 2409875 2409875 defendant Crynche John dyer 610506 610506 Crynche, John, of Barnstaple, dyer 0
5181202 2410245 2410245 defendant Marke Thomas merchant 610506 610506 Marke, Thomas, of Barnstaple, merchant, son of Robert Marke, of Barnestapill, merchant 1
5181205 2410246 2410246 defendant Marke Thomas merchant 610506 610506 Marke, Thomas, of Barnstaple, merchant, son of Robert Marke, of Barnstaple, merchant 1
5197688 2415064 2415064 defendant Neucombe Richard husbandman 610506 610506 Neucombe, Richard, of Barnstaple, husbandman 0
5203867 2416883 2416883 defendant Gommyston Robert husbandman 610506 610506 Gommyston, Robert, of Barnstaple, husbandman 0
5244469 2428564 2428564 defendant Whyte Thomas merchant 610506 610506 Whyte, Thomas, of Barnstaple, merchant 0
5391985 2472786 2472786 defendant White Thomas merchant 610506 610506 White, Thomas, of Barnstaple, merchant 0
5414745 2479346 2479346 defendant Cory Thomas dyer 610506 610506 Cory, Thomas, of Barnstaple, dyer 1
5415192 2479484 2479484 defendant Whyte Thomas merchant 610506 610506 Whyte, Thomas, of Barnstaple, merchant 0
5415193 2479484 2479484 defendant Hochyn Thomas husbandman 610506 610506 Hochyn, Thomas, of Barnstaple, husbandman 1
5422170 2481579 2481579 defendant Whyte Thomas clothier 610506 610506 Whyte, Thomas, of Barnstaple, clothier 0
5426813 2482961 2482961 defendant Whyte Thomas yeoman 610506 610506 Whyte, Thomas, of Barnstaple, yeoman 1
5432445 2484675 2484675 defendant Alyn John clerk 610506 610506 Alyn, John, of Barnstaple, clerk 0
5444808 2488342 2488342 defendant Whyte Thomas yeoman 610506 610506 Whyte, Thomas, of Barnstaple, yeoman 1
5446641 2488887 2488887 defendant Whyte Thomas clothier 610506 610506 Whyte, Thomas, of Barnstaple, clothier 0
5507004 2507106 2507106 defendant Bray John carpenter 610506 610506 Bray, John, of Barnstaple, carpenter 0
5533929 2515154 2515154 defendant Dobyns William merchant 610506 610506 Dobyns, William, of Barnstaple, merchant 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);