names

89 rows where place_id = 592956

✎ 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
3609551 1870651 1870651 defendant White William tailor 592956 592956 White, William, of Bruton, Soms, tailor 0
3671661 1917123 1917123 defendant Samfford William chapman 592956 592956 Samfford, William, of Bruton, Soms, chapman 4
3721099 1932896 1932896 defendant Bleke John dyer 592956 592956 Bleke, John, of Bruton, Soms, dyer 2
3721562 1933049 1933049 plaintiff Love Walter goldsmith 592956 592956 Love, Walter, of Bruton, Soms, goldsmith 0
3741515 1939219 1939219 defendant Love Walter goldsmith 592956 592956 Love, Walter, of Bruton, Soms, goldsmith 0
3753837 1943144 1943144 defendant Love Walter goldsmith 592956 592956 Love, Walter, of Bruton, Soms, goldsmith 0
3758790 1944738 1944738 defendant Love Walter goldsmith 592956 592956 Love, Walter, of Bruton, Soms, goldsmith 1
3781732 1952033 1952033 defendant Acourte John (legal representative) 592956 592956 Acourte, John, of Bruton, Soms, clothier, executors of 0
3794212 1956062 1956062 defendant Love Walter goldsmith 592956 592956 Love, Walter, of Bruton, Soms, goldsmith 0
3837867 1969758 1969758 defendant Samways Robert innholder 592956 592956 Samways, Robert, of Bruton, Soms, innholder 0
3843227 1971414 1971414 defendant Samwyse Robert yeoman 592956 592956 Samwyse, Robert, of Bruton, Soms, yeoman 0
3853972 1974880 1974880 defendant Samways Robert innholder 592956 592956 Samways, Robert, of Bruton, Soms, innholder 0
3856037 1975514 1975514 defendant Samwyse Robert innholder 592956 592956 Samwyse, Robert, of Bruton, Soms, innholder 0
3859362 1976623 1976623 defendant Samwyse Richard yeoman 592956 592956 Samwyse, Richard, of Bruton, Soms, yeoman 0
3869992 1980206 1980206 defendant Collys William mercer 592956 592956 Collys, William, of Bruton, Soms, mercer 0
3883831 1984859 1984859 defendant Collys William mercer 592956 592956 Collys, William, of Bruton, Soms, mercer 0
3893528 1988061 1988061 defendant Chyck Stephen, junior chapman 592956 592956 Chyck, Stephen, junior, of Bruton, Soms, chapman 2
3906368 1992416 1992416 defendant Cheke Stephen, junior chapman 592956 592956 Cheke, Stephen, junior, of Bruton, Soms, chapman 0
3911729 1994249 1994249 defendant Chyke Stephen, junior mercer 592956 592956 Chyke, Stephen, junior, of Bruton, Soms, mercer 1
3911830 1994280 1994280 defendant Larder Ralph gent 592956 592956 Larder, Ralph, of Bruton, Soms, gent 1
3936370 2002487 2002487 defendant Stevyns Christopher mercer & "herderman" 592956 592956 Stevyns, Christopher, of Bruton, Soms, mercer & "herderman" 0
3938406 2003188 2003188 defendant Stevyns Christopher chapman 592956 592956 Stevyns, Christopher, of Bruton, Soms, chapman 0
3973814 2015410 2015410 defendant Gent Thomas chapman 592956 592956 Gent, Thomas, of Bruton, Soms, chapman 0
3993654 2022475 2022475 defendant Lambell Nicholas mercer 592956 592956 Lambell, Nicholas, of Bruton, Soms, mercer 2
4020737 2032144 2032144 defendant Gente Thomas yeoman 592956 592956 Gente, Thomas, of Bruton, Soms, yeoman 1
4228603 2105488 2105488 defendant Applefordes alias Aburforth John gent 592956 592956 Applefordes alias Aburforth, John, of Bruton, Soms, gent 0
4264067 2117634 2117634 defendant Russell Thomas esq 592956 592956 Russell, Thomas, of Bruton, Soms, esq 0
4269988 2119545 2119545 defendant Applefordes or Aburfurth John gent 592956 592956 Applefordes or Aburfurth, John, of Bruton, Soms, gent 0
4298820 2129675 2129675 defendant Bartley John vintner 592956 592956 Bartley, John, of Bruton, Soms, vintner 1
4565892 2220889 2220889 defendant Bury Thomas   592956 592956 Bury, Thomas, of Bruton, Soms 0
4680496 2259513 2259513 plaintiff Loddewyll Walter fuller 592956 592956 Loddewyll, Walter, of Bruton, Soms, fuller 0
4693188 2263371 2263371 defendant Waryner Thomas weaver 592956 592956 Waryner, Thomas, of Bruton, Soms, weaver 2
4703590 2266501 2266501 defendant Launcels John gent 592956 592956 Launcels, John, of Bruton, Soms, gent 0
4725019 2273119 2273119 defendant Cabell John fuller 592956 592956 Cabell, John, of Bruton, Soms, fuller 0
4733736 2275732 2275732 defendant Crouthorn William merchant 592956 592956 Crouthorn, William, of Bruton, Soms, merchant 0
4738907 2277260 2277260 plaintiff Smyth William   592956 592956 Smyth, William, of Bruton, Soms 1
4750342 2280581 2280581 plaintiff Quyk Walter (legal representative) 592956 592956 Quyk, Walter, of Bruton, Soms, executors of 0
4770231 2286664 2286664 defendant Trappe Robert chapman 592956 592956 Trappe, Robert, of Bruton, Soms, chapman 1
4771612 2287098 2287098 defendant Mastall Joan widow 592956 592956 Mastall, Joan, of Bruton, Soms, widow 1
4773732 2287757 2287757 defendant Wulverton John   592956 592956 Wulverton, John, of Bruton, Soms, shoe maker 2
4799133 2295904 2295904 defendant Wulverton John shoemaker 592956 592956 Wulverton, John, of Bruton, Soms, shoemaker 3
4814990 2300798 2300798 defendant Loowode John spicer 592956 592956 Loowode, John, of Bruton, Soms, spicer 2
4834673 2306847 2306847 defendant Smyth William yeoman 592956 592956 Smyth, William, of Bruton, Soms, yeoman 0
4843977 2309631 2309631 defendant Trappe Robert chapman 592956 592956 Trappe, Robert, of Bruton, Soms, chapman 0
4844005 2309636 2309636 defendant Trappe Robert chapman 592956 592956 Trappe, Robert, of Bruton, Soms, chapman 0
4847749 2310788 2310788 defendant Blaneford Thomas   592956 592956 Blaneford, Thomas, of Bruton, Soms, franklin 5
4860685 2314703 2314703 defendant Smyth William smith 592956 592956 Smyth, William, of Bruton, Soms, smith 0
4874885 2319087 2319087 defendant Blaneford Thomas   592956 592956 Blaneford, Thomas, of Bruton, Soms, franklin 2
4929936 2335774 2335774 defendant Dyer alias Hourt Geoffrey dyer 592956 592956 Dyer alias Hourt, Geoffrey, of Bruton, Soms, dyer 0
4936681 2337855 2337855 defendant Hoghekyns William chapman 592956 592956 Hoghekyns, William, of Bruton, Soms, chapman 0
4936684 2337856 2337856 defendant Hoghekyns William chapman 592956 592956 Hoghekyns, William, of Bruton, Soms, chapman 0
4962000 2345547 2345547 defendant Smyth Thomas yeoman 592956 592956 Smyth, Thomas, of Bruton, Soms, yeoman 0
4962067 2345561 2345561 defendant Glede William chapman 592956 592956 Glede, William, of Bruton, Soms, chapman 1
4994984 2355359 2355359 defendant Hert Geoffrey dyer 592956 592956 Hert, Geoffrey, of Bruton, Soms, dyer 1
4994992 2355360 2355360 defendant Hert Geoffrey dyer 592956 592956 Hert, Geoffrey, of Bruton, Soms, dyer 1
5003863 2358020 2358020 defendant Hoggekyns William gent 592956 592956 Hoggekyns, William, of Bruton, Soms, gent 2
5003867 2358021 2358021 defendant Hoggekyns William gent 592956 592956 Hoggekyns, William, of Bruton, Soms, gent 2
5020932 2363017 2363017 defendant Bere William husbandman 592956 592956 Bere, William, of Bruton, Soms, husbandman 4
5024600 2364107 2364107 defendant Hert Geoffrey dyer 592956 592956 Hert, Geoffrey, of Bruton, Soms, dyer 1
5051678 2372115 2372115 defendant Hogekynys William chapman 592956 592956 Hogekynys, William, of Bruton, Soms, chapman 1
5051683 2372116 2372116 defendant Hogekynys William chapman 592956 592956 Hogekynys, William, of Bruton, Soms, chapman 1
5212622 2419440 2419440 defendant Wheler William butcher 592956 592956 Wheler, William, of Bruton, Soms, butcher 1
5227876 2423770 2423770 defendant More Robert chapman 592956 592956 More, Robert, of Bruton, Soms, chapman 2
5246688 2429192 2429192 defendant Barbour George chapman 592956 592956 Barbour, George, of Bruton, Soms, chapman 0
5271183 2436668 2436668 defendant Paytenyn Richard yeoman 592956 592956 Paytenyn, Richard, of Bruton, Soms, yeoman 3
5279737 2439155 2439155 defendant Trent John yeoman 592956 592956 Trent, John, of Bruton, Soms, yeoman 0
5301541 2445415 2445415 defendant Ede Thomas chaplain 592956 592956 Ede, Thomas, of Bruton, Soms, chaplain 0
5303450 2446028 2446028 defendant Hancok John mercer 592956 592956 Hancok, John, of Bruton, Soms, mercer 3
5334896 2455506 2455506 defendant Russeley John gent 592956 592956 Russeley, John, of Bruton, Soms, gent 0
5334898 2455507 2455507 defendant Russheley John   592956 592956 Russheley, John, of Bruton, Soms, gnt 0
5335378 2455648 2455648 defendant Barbour William chapman 592956 592956 Barbour, William, of Bruton, Soms, chapman 4
5342107 2457728 2457728 defendant Blofeld Thomas yeoman 592956 592956 Blofeld, Thomas, of Bruton, Soms, yeoman 0
5347884 2459481 2459481 defendant Hameldon John chapman 592956 592956 Hameldon, John, of Bruton, Soms, chapman 2
5356818 2462197 2462197 defendant Barber William merchant 592956 592956 Barber, William, of Bruton, Soms, merchant 0
5362273 2463860 2463860 defendant Ede Eleanor widow 592956 592956 Ede, Eleanor, of Bruton, Soms, widow 0
5362279 2463861 2463861 defendant Ede Eleanor widow 592956 592956 Ede, Eleanor, of Bruton, Soms, widow 0
5385285 2470867 2470867 defendant Yerbury John   592956 592956 Yerbury, John, of Bruton, Soms 0
5394491 2473486 2473486 defendant Ede William (legal representative) 592956 592956 Ede, William, of Bruton, Soms, mercer, executors of 3
5397359 2474332 2474332 defendant Yerbury John dyer 592956 592956 Yerbury, John, of Bruton, Soms, dyer 0
5397758 2474428 2474428 defendant Tanner William tanner 592956 592956 Tanner, William, of Bruton, Soms, tanner 8
5407782 2477304 2477304 defendant Ede William (legal representative) 592956 592956 Ede, William, of Bruton, Soms, mercer, executors of 3
5410559 2478104 2478104 defendant Yerbury John dyer 592956 592956 Yerbury, John, of Bruton, Soms, dyer 0
5410908 2478212 2478212 defendant Tanner John tanner 592956 592956 Tanner, John, of Bruton, Soms, tanner 8
5459159 2492638 2492638 defendant Barber William merchant 592956 592956 Barber, William, of Bruton, Soms, merchant 1
5470806 2496194 2496194 defendant Barber William merchant 592956 592956 Barber, William, of Bruton, Soms, merchant 1
5484908 2500409 2500409 defendant Yardbury John tucker 592956 592956 Yardbury, John, of Bruton, Soms, tucker 2
5537054 2516073 2516073 defendant Horsey Thomas gent 592956 592956 Horsey, Thomas, of Bruton, Soms, gent 2
5539874 2516951 2516951 defendant Barbur alias Dale William (legal representative) 592956 592956 Barbur alias Dale, William, of Bruton, Soms, mercer, executrix of 0
5539883 2516955 2516955 defendant Barbur alias Dale William (legal representative) 592956 592956 Barbur alias Dale, William, of Bruton, Soms, mercer, executrix of 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);