names

69 rows where place_id = 599140

✎ 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
3635447 1905882 1905882 defendant Belle John (legal representative) 599140 599140 Belle, John, of Barsham, yeoman, executor of 0
3635448 1905882 1905882 defendant Belle John yeoman 599140 599140 Belle, John, of Barsham, yeoman 1
3677256 1918933 1918933 defendant Belle John yeoman 599140 599140 Belle, John, of Barsham, yeoman 0
3677878 1919134 1919134 defendant Mabbys Geoffrey husbandman 599140 599140 Mabbys, Geoffrey, of Barsham, husbandman 1
3681130 1920179 1920179 defendant Holdernes Thomas husbandman 599140 599140 Holdernes, Thomas, of Barsham, husbandman 3
3711453 1929888 1929888 defendant Belle Thomas laborer 599140 599140 Belle, Thomas, of Barsham, laborer 0
3712369 1930187 1930187 defendant Tofte John husbandman 599140 599140 Tofte, John, of Barsham, husbandman 0
3791679 1955243 1955243 defendant Echyngham Edward (legal representative) 599140 599140 Echyngham, Edward, of Barsham, knight, executors of 0
3791680 1955243 1955243 defendant Echyngham Anne widow 599140 599140 (Echyngham, Anne, of Barsham, widow 1
3793938 1955974 1955974 defendant Bell Thomas husbandman 599140 599140 Bell, Thomas, of Barsham, husbandman 0
3808839 1960645 1960645 defendant Echyngham Edmund (legal representative) 599140 599140 Echyngham, Edmund, of Barsham, knight, executors of 0
3808840 1960645 1960645 defendant Echyngham Anne widow 599140 599140 (Echyngham, Anne, of Barsham, widow 1
3821267 1964542 1964542 defendant Echyngham Anne widow 599140 599140 Echyngham, Anne, of Barsham, widow 0
3821270 1964542 1964542 defendant Bery John yeoman 599140 599140 Bery, John, of Barsham, yeoman 3
3823224 1965177 1965177 defendant Jerard John husbandman 599140 599140 Jerard, John, of Barsham, husbandman 0
3830124 1967321 1967321 plaintiff Ethyngham Anne widow 599140 599140 Ethyngham, Anne, of Barsham, widow 0
3830125 1967321 1967321 defendant Bekett Katherine widow 599140 599140 Bekett, Katherine, of Barsham, widow 0
3846522 1972469 1972469 defendant Beale Thomas butcher 599140 599140 Beale, Thomas, of Barsham, butcher 3
3849720 1973499 1973499 defendant Belle Thomas husbandman 599140 599140 Belle, Thomas, of Barsham, husbandman 0
3888427 1986391 1986391 defendant Tasburgh Edward gent 599140 599140 Tasburgh, Edward, of Barsham, gent 0
3894314 1988316 1988316 defendant Dyngyll John warrener 599140 599140 Dyngyll, John, of Barsham, warrener 3
3899715 1990118 1990118 defendant Morfue John husbandman 599140 599140 Morfue, John, of Barsham, husbandman 3
3907679 1992859 1992859 defendant Pyke John (legal representative) 599140 599140 Pyke, John, of Barsham, carpenter, executors of 2
3907682 1992859 1992859 defendant Baker Richard husbandman 599140 599140 Baker, Richard, of Barsham, husbandman 5
3936214 2002437 2002437 defendant Bryan John tailor 599140 599140 Bryan, John, of Barsham, tailor 1
3938819 2003325 2003325 plaintiff Reve Robert yeoman 599140 599140 Reve, Robert, of Barsham, yeoman 0
3973699 2015374 2015374 defendant Westwyn John husbandman 599140 599140 Westwyn, John, of Barsham, husbandman 1
3973707 2015377 2015377 defendant Westwyn John husbandman 599140 599140 Westwyn, John, of Barsham, husbandman 1
3979869 2017555 2017555 defendant Holmes Richard tailor 599140 599140 Holmes, Richard, of Barsham, tailor 0
3994056 2022624 2022624 defendant Barnewell George husbandman 599140 599140 Barnewell, George, of Barsham, husbandman 0
4001341 2025255 2025255 defendant Beckett William yeoman 599140 599140 Beckett, William, of Barsham, yeoman 0
4013952 2029723 2029723 defendant Holmes John husbandman 599140 599140 Holmes, John, of Barsham, husbandman 0
4045625 2040887 2040887 defendant Holmes Richard husbandman 599140 599140 Holmes, Richard, of Barsham, husbandman 0
4068394 2048996 2048996 defendant Dawson Robert husbandman 599140 599140 Dawson, Robert, of Barsham, husbandman 0
4201482 2096065 2096065 defendant Fylbye William yeoman 599140 599140 Fylbye, William, of Barsham, yeoman 1
4205637 2097525 2097525 defendant Bleverhassett Thomas esq 599140 599140 Bleverhassett, Thomas, of Barsham, or of Westelton, Suff, esq 0
4277463 2122041 2122041 defendant Turnor John husbandman 599140 599140 Turnor, John, of Barsham, husbandman 0
4327566 2139542 2139542 defendant Ellis Arthur yeoman 599140 599140 Ellis, Arthur, of Barsham, yeoman 3
4340595 2143980 2143980 defendant Underwood Robert gent 599140 599140 Underwood, Robert, of Barsham, or of Beccles, gent 0
4343049 2144839 2144839 defendant Blenerhasset Thomas esq 599140 599140 Blenerhasset, Thomas, of Barsham, esq 0
4498937 2200306 2200306 defendant Gardener Robert   599140 599140 Gardener, Robert, of Barsham 2
4610571 2234372 2234372 defendant Boteler Thomas   599140 599140 Boteler, Thomas, of Barsham 2
4613078 2235148 2235148 defendant Smyth Richard   599140 599140 Smyth, Richard, of Barsham 2
4648165 2245526 2245526 defendant atte Chirche Nicholas   599140 599140 atte Chirche, Nicholas, of Barsham 0
4680412 2259487 2259487 defendant Hunte William husbandman 599140 599140 Hunte, William, of Barsham, husbandman 0
4686948 2261525 2261525 defendant Terell Matilda widow 599140 599140 Terell, Matilda, of Barsham, widow 0
4693566 2263490 2263490 defendant Hancok William tailor 599140 599140 Hancok, William, of Barsham, tailor 2
4697393 2264670 2264670 defendant Whiltmaker John   599140 599140 Whiltmaker, John, of Barsham, whilt maker or quilt maker 0
4756113 2282289 2282289 defendant Dawes John husbandman 599140 599140 Dawes, John, of Barsham, husbandman 1
4764004 2284729 2284729 defendant atte Chirche Nicholas   599140 599140 atte Chirche, Nicholas, of Barsham 0
4829367 2305225 2305225 defendant Hunte William yeoman 599140 599140 Hunte, William, of Barsham, yeoman 0
4865368 2316136 2316136 defendant Fraunceys John yeoman 599140 599140 Fraunceys, John, of Barsham, yeoman 2
4878412 2320191 2320191 defendant Debenham Richard yeoman 599140 599140 together with Debenham, Richard, of Barsham, yeoman 1
4984113 2352181 2352181 defendant Bennes Edmund husbandman 599140 599140 Bennes, Edmund, of Barsham, husbandman 0
4995411 2355469 2355469 defendant Baret William husbandman 599140 599140 Baret, William, of Barsham, husbandman 1
4995412 2355469 2355469 defendant Ryngesfeld John husbandman 599140 599140 Ryngesfeld, John, of Barsham, husbandman 2
5094867 2384915 2384915 defendant Bryggys Richard yeoman 599140 599140 Bryggys, Richard, of Barsham, yeoman 1
5107836 2388727 2388727 defendant Warde John gent 599140 599140 Warde, John, of Barsham, gent 0
5197815 2415099 2415099 defendant Brygges Richard yeoman 599140 599140 Brygges, Richard, of Barsham, yeoman 0
5369334 2466011 2466011 defendant Smyth Robert husbandman 599140 599140 Smyth, Robert, of Barsham, husbandman 1
5394731 2473555 2473555 defendant Belle John husbandman 599140 599140 Belle, John, of Barsham, husbandman 1
5536775 2515986 2515986 defendant Baret John husbandman 599140 599140 Baret, John, of Barsham, husbandman 4
5548760 2519682 2519682 defendant Brygges Thomas yeoman 599140 599140 Brygges, Thomas, of Barsham, yeoman 0
5548761 2519682 2519682 defendant Belle John, senior yeoman 599140 599140 Belle, John, senior, of Barsham, yeoman 1
5548870 2519713 2519713 defendant Chayngahm John esq 599140 599140 Chayngahm John, of Barsham, esq 1
5557742 2522213 2522213 defendant Belle John husbandman 599140 599140 Belle, John, of Barsham, husbandman 1
5568323 2525280 2525280 defendant Fermour Henry gent 599140 599140 (Fermour, Henry, of Barsham, gent 4
5588236 2531326 2531326 defendant Belle John (legal representative) 599140 599140 Belle, John, of Barsham, yeoman, executor of 0
5588237 2531326 2531326 defendant Belle John yeoman 599140 599140 Belle, John, of Barsham, yeoman 1

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