names

157 rows where place_id = 589140

✎ 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
3596662 1866592 1866592 defendant Burneham Henry mariner 589140 589140 Burneham, Henry, of Briggewater, Soms, mariner 0
3597297 1866775 1866775 defendant Mareys John merchant 589140 589140 Mareys, John, of Briggewater, Soms, merchant 0
3597299 1866776 1866776 defendant Mareys John merchant 589140 589140 Mareys, John, of Briggewater, Soms, merchant 0
3599669 1867538 1867538 defendant Baker Thomas merchant 589140 589140 Baker, Thomas, of Briggewater, Soms, merchant 0
3599672 1867539 1867539 defendant West William merchant 589140 589140 West, William, of Briggewater, Soms, merchant 0
3603742 1868842 1868842 defendant Saunders John chapman 589140 589140 Saunders, John, of Briggewater, Soms, chapman 0
3605361 1869344 1869344 defendant Capner Thomas innholder 589140 589140 Capner, Thomas, of Briggewater, Soms, innholder 2
3616945 1872924 1872924 defendant Saunders John mercer 589140 589140 Saunders, John, of Briggewater, Soms, mercer 0
3630383 1904338 1904338 defendant Osgood Richard merchant 589140 589140 (Osgood, Richard, of Briggewater, Soms, merchant 1
3630814 1904459 1904459 defendant Faunte Peter merchant 589140 589140 Faunte, Peter, of Briggewater, Soms, merchant 0
3632541 1904994 1904994 defendant Hopkyns Thomas chapman 589140 589140 Hopkyns, Thomas, of Briggewater, Soms, chapman 0
3635983 1906050 1906050 defendant Sawnders John merchant 589140 589140 Sawnders, John, of Briggewater, Soms, merchant 0
3645486 1908990 1908990 defendant Nawdyn John merchant 589140 589140 Nawdyn, John, of Briggewater, Soms, merchant 1
3703430 1927347 1927347 defendant Synnagh Thomas merchant 589140 589140 Synnagh, Thomas, of Briggewater, Soms, merchant 0
3713345 1930487 1930487 defendant Bevyn Thomas gent 589140 589140 Bevyn, Thomas, of Briggewater, Soms, gent 0
3720346 1932641 1932641 defendant Sanders John merchant 589140 589140 Sanders, John, of Briggewater, Soms, merchant 3
3752058 1942566 1942566 defendant Tyrrell Richard merchant 589140 589140 Tyrrell, Richard, of Briggewater, Soms, merchant 0
3761820 1945707 1945707 defendant Tyrell Richard merchant 589140 589140 Tyrell, Richard, of Briggewater, Soms, merchant 0
3793390 1955794 1955794 defendant Benett Ralph yeoman 589140 589140 Benett, Ralph, of Briggewater, Soms, yeoman 0
4654772 2247372 2247372 defendant Brode John butcher 589140 589140 Brode, John, of Briggewater, Soms, butcher 1
4657888 2248352 2248352 defendant Bartelot Roger husbandman 589140 589140 Bartelot, Roger, of Briggewater, Soms, husbandman 0
4662746 2249806 2249806 defendant Chepman John yeoman 589140 589140 (Chepman, John, of Briggewater, Soms, yeoman 1
4686441 2261363 2261363 defendant Tynner Thomas merchant 589140 589140 Tynner, Thomas, of Briggewater, Soms, merchant 0
4700160 2265472 2265472 defendant Tought William merchant 589140 589140 Tought, William, of Briggewater, Soms, merchant 0
4706779 2267506 2267506 defendant Dyrbourgh Ralph esq 589140 589140 Dyrbourgh, Ralph, of Briggewater, Soms, esq 0
4710584 2268667 2268667 defendant Baker Walter chapman 589140 589140 Baker, Walter, of Briggewater, Soms, chapman 3
4742942 2278448 2278448 defendant Hert John mercer 589140 589140 Hert, John, of Briggewater, Soms, mercer 0
4754854 2281897 2281897 defendant Makeney Lambert esq 589140 589140 Makeney, Lambert, of Briggewater, Soms, esq 0
4783539 2290868 2290868 defendant Pytte John merchant 589140 589140 Pytte, John, of Briggewater, Soms, merchant 0
4798856 2295816 2295816 defendant Makney Lambert esq 589140 589140 Makney, Lambert, of Briggewater, Soms, esq 0
4799291 2295954 2295954 defendant Broghton Nicholas gent 589140 589140 Broghton, Nicholas, of Briggewater, Soms, gent 1
4805864 2298042 2298042 defendant Pytte John merchant 589140 589140 Pytte, John, of Briggewater, Soms, merchant 0
4823325 2303381 2303381 defendant Cheselet Thomas husbandman 589140 589140 Cheselet, Thomas, of Briggewater, Soms, husbandman 0
4825294 2303953 2303953 defendant Andrewe John skinner 589140 589140 Andrewe, John, of Briggewater, Soms, skinner 0
4836735 2307455 2307455 defendant Clewere William draper 589140 589140 Clewere, William, of Briggewater, Soms, draper 0
4836881 2307492 2307492 defendant Hakworthy Thomas (legal representative) 589140 589140 Hakworthy, Thomas, of Briggewater, Soms, chapman, executrix of 5
4854867 2312875 2312875 defendant Grendon alias Tailour Henry merchant 589140 589140 Grendon alias Tailour, Henry, of Briggewater, Soms, merchant 0
4855385 2313041 2313041 defendant Seyntbarbe Richard gent 589140 589140 Seyntbarbe, Richard, of Briggewater, Soms, gent 1
4855400 2313047 2313047 defendant Seyntbarbe Richard gent 589140 589140 Seyntbarbe, Richard, of Briggewater, Soms, gent 1
4864031 2315726 2315726 defendant Clewere alias Draper William draper 589140 589140 Clewere alias Draper, William, of Briggewater, Soms, draper 0
4867587 2316833 2316833 defendant Gardyner Richard merchant 589140 589140 Gardyner, Richard, of Briggewater, Soms, merchant 0
4872552 2318372 2318372 defendant Pytte John   589140 589140 Pytte, John, of Briggewater, Soms, franklin 0
4875120 2319173 2319173 defendant Hert John mercer 589140 589140 Hert, John, of Briggewater, Soms, mercer 0
4876188 2319511 2319511 defendant Toky William husbandman 589140 589140 Toky, William, of Briggewater, Soms, husbandman 0
4877587 2319947 2319947 defendant Benne John merchant 589140 589140 Benne, John, of Briggewater, Soms, merchant 2
4877592 2319948 2319948 defendant Benne John merchant 589140 589140 Benne, John, of Briggewater, Soms, merchant 2
4881236 2321036 2321036 defendant Bythewater William chapman 589140 589140 Bythewater, William, of Briggewater, soms, chapman 3
4886420 2322613 2322613 defendant Fageler John chapman 589140 589140 Fageler, John, of Briggewater, Soms, chapman 1
4889157 2323397 2323397 defendant Ales William chapman 589140 589140 Ales, William, of Briggewater, Soms, chapman 0
4896115 2325442 2325442 defendant Ales William chapman 589140 589140 Ales, William, of Briggewater, Soms, chapman 0
4903506 2327706 2327706 defendant Seynbarbe Thomas esq 589140 589140 Seynbarbe, Thomas, of Briggewater, Soms, esq 1
4910573 2329816 2329816 defendant Gardener William merchant 589140 589140 Gardener, William, of Briggewater, Soms, merchant 1
4911261 2330027 2330027 defendant of Thomas William gent 589140 589140 of Thomas, William, of Briggewater, Soms, gent 0
4928785 2335426 2335426 defendant Herte John merchant 589140 589140 Herte, John, of Briggewater, Soms, merchant 2
4933747 2336932 2336932 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4933749 2336933 2336933 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4937589 2338132 2338132 defendant Craddok Thomas merchant 589140 589140 Craddok, Thomas, of Briggewater, Soms, merchant 1
4940114 2338936 2338936 defendant Ayleward John merchant 589140 589140 Ayleward, John, of Briggewater, Soms, merchant 0
4948286 2341442 2341442 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4948288 2341443 2341443 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4948290 2341444 2341444 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4948294 2341445 2341445 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4954698 2343359 2343359 defendant Mey John chapman 589140 589140 Mey, John, of Briggewater, Soms, chapman 2
4960375 2345071 2345071 defendant Eyleward John merchant 589140 589140 Eyleward, John, of Briggewater, Soms, merchant 0
4960377 2345071 2345071 defendant Hert John merchant 589140 589140 Hert, John, of Briggewater, Soms, merchant 2
4979127 2350714 2350714 defendant Michell William mercer 589140 589140 Michell, William, of Briggewater, Soms, mercer 0
4988119 2353423 2353423 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 1
4988125 2353424 2353424 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 1
4992594 2354668 2354668 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 0
4996966 2355948 2355948 defendant St Barbe Thomas esq 589140 589140 St Barbe, Thomas, of Briggewater, Soms, esq 0
5006677 2358849 2358849 defendant Acton Thomas grocer 589140 589140 Acton, Thomas, of Briggewater, Soms, grocer 4
5008703 2359438 2359438 defendant Mey John merchant 589140 589140 Mey, John, of Briggewater, Soms, merchant 1
5011589 2360251 2360251 defendant May John chapman 589140 589140 May, John, of Briggewater, Soms, chapman 1
5051641 2372109 2372109 defendant May John chapman 589140 589140 May, John, of Briggewater, Soms, chapman 0
5058565 2374117 2374117 defendant Smyth John chapman 589140 589140 Smyth, John, of Briggewater, Soms, chapman 0
5077807 2379855 2379855 defendant Parys John hosier 589140 589140 Parys, John, of Briggewater, Soms, hosier 2
5077817 2379856 2379856 defendant Parys John hosier 589140 589140 Parys, John, of Briggewater, Soms, hosier 2
5091353 2383869 2383869 defendant Senbarbe Thomas esq 589140 589140 Senbarbe, Thomas, of Briggewater, Soms, esq 0
5095067 2384971 2384971 plaintiff Michell William mercer 589140 589140 Michell, William, of Briggewater, Soms, mercer 1
5096628 2385448 2385448 defendant Smyth John chapman 589140 589140 Smyth, John, of Briggewater, Soms, chapman 0
5113948 2390468 2390468 defendant Haccheford John gent 589140 589140 Haccheford, John, of Briggewater, Soms, gent 0
5114158 2390541 2390541 defendant Haccheford John gent 589140 589140 Haccheford, John, of Briggewater, Soms, gent 0
5138629 2397793 2397793 defendant Clement John yeoman 589140 589140 Clement, John, of Briggewater, Soms, yeoman 1
5138747 2397828 2397828 defendant Howchon Robert chapman 589140 589140 Howchon, Robert, of Briggewater, Soms, chapman 1
5140985 2398483 2398483 defendant Wyse John merchant 589140 589140 Wyse, John, of Briggewater, Soms, merchant 0
5147000 2400264 2400264 defendant William David   589140 589140 William, David, of Briggewater, Soms, franklin 6
5159389 2403861 2403861 defendant Clement John yeoman 589140 589140 Clement, John, of Briggewater, Soms, yeoman 1
5162116 2404653 2404653 defendant Wyse John merchant 589140 589140 Wyse, John, of Briggewater, Soms, merchant 0
5174547 2408256 2408256 defendant Clement John yeoman 589140 589140 Clement, John, of Briggewater, Soms, yeoman 1
5174550 2408257 2408257 defendant Clement John yeoman 589140 589140 Clement, John, of Briggewater, Soms, yeoman 1
5213725 2419745 2419745 defendant FitzJames James merchant 589140 589140 (FitzJames, James, of Briggewater, Soms, merchant 1
5213803 2419764 2419764 defendant mainpernors for Seyntbarbe Thomas esq 589140 589140 mainpernors for Seyntbarbe, Thomas, of Briggewater, Soms, esq 4
5218147 2421041 2421041 defendant Gosse William gent 589140 589140 Gosse, William, of Briggewater, Soms, gent 0
5227330 2423619 2423619 defendant Wheler John chapman 589140 589140 Wheler, John, of Briggewater, Soms, chapman 3
5227338 2423621 2423621 defendant Wheler John chaplain 589140 589140 Wheler, John, of Briggewater, Soms, chaplain 4
5229816 2424341 2424341 defendant Hylle John merchant 589140 589140 Hylle, John, of Briggewater, Soms, merchant 1
5233962 2425523 2425523 defendant Gosse William esq 589140 589140 Gosse, William, of Briggewater, Soms, esq 1
5235750 2426032 2426032 defendant Hochons Robert chapman 589140 589140 Hochons, Robert, of Briggewater, Soms, chapman 0
5252108 2430770 2430770 defendant FitzJames James merchant 589140 589140 FitzJames, James, of Briggewater, Soms, merchant 0
5252110 2430771 2430771 defendant FitzJames James merchant 589140 589140 FitzJames, James, of Briggewater, Soms, merchant 0

Next page

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);