names

59 rows where place_id = 593668

✎ 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
3612864 1871672 1871672 defendant Knyfesmyth John husbandman 593668 593668 Knyfesmyth, John, of Rolston, husbandman 0
3672018 1917248 1917248 defendant Caldwall Robert husbandman 593668 593668 Caldwall, Robert, of Rolston, husbandman 0
3729317 1935421 1935421 defendant Scote or Stote Christopher husbandman 593668 593668 Scote or Stote, Christopher, of Rolston, husbandman 0
3739517 1938568 1938568 defendant Cotton John yeoman 593668 593668 Cotton, John, of Rolston, yeoman 0
3809864 1960973 1960973 defendant Caldwall Thomas husbandman 593668 593668 Caldwall, Thomas, of Rolston, husbandman 0
3845600 1972166 1972166 defendant Sheperde John husbandman 593668 593668 Sheperde, John, of Rolston, husbandman 1
3845601 1972166 1972166 defendant Caldewell Robert husbandman 593668 593668 Caldewell, Robert, of Rolston, husbandman 2
3854828 1975155 1975155 defendant Rolston Thomas esq 593668 593668 Rolston, Thomas, of Rolston, esq 0
3906601 1992502 1992502 plaintiff Meryng James gent 593668 593668 Meryng, James, of Rolston, gent 0
3906604 1992503 1992503 plaintiff Meryng James gent 593668 593668 Meryng, James, of Rolston, gent 0
3924739 1998590 1998590 defendant Meryng James gent 593668 593668 (Meryng, James, of Rolston, gent 1
3959574 2010440 2010440 defendant Watson William husbandman 593668 593668 Watson, William, of Rolston, husbandman 1
3959575 2010440 2010440 defendant Snape John husbandman 593668 593668 Snape, John, of Rolston, husbandman 2
3959576 2010440 2010440 defendant Presseberye John husbandman 593668 593668 Presseberye, John, of Rolston, husbandman 3
3959577 2010440 2010440 defendant Clerke Thomas husbandman 593668 593668 Clerke, Thomas, of Rolston, husbandman 4
3959578 2010440 2010440 defendant Stubb John husbandman 593668 593668 Stubb, John, of Rolston, husbandman 5
3988437 2020607 2020607 defendant Davyd James Thomas husbandman 593668 593668 Davyd, James Thomas, of Rolston, husbandman 0
4020068 2031904 2031904 defendant Merynge Peter gent 593668 593668 Merynge, Peter, of Rolston, gent 3
4020082 2031906 2031906 defendant Merynge Anthony gent 593668 593668 Merynge, Anthony, of Rolston, gent 2
4020083 2031906 2031906 defendant Merynge Peter gent 593668 593668 Merynge, Peter, of Rolston, gent 3
4028803 2034949 2034949 defendant Bromyche George husbandman 593668 593668 Bromyche, George, of Rolston, husbandman 1
4053512 2043630 2043630 defendant Powell Philip   593668 593668 Powell, Philip, of Rolston, mason 3
4056268 2044627 2044627 plaintiff Bracebridge Simon gent 593668 593668 Bracebridge, Simon, of Rolston, gent 0
4060471 2046148 2046148 defendant Meredith Howell William yeoman 593668 593668 Meredith, Howell William, of Rolston, yeoman 0
4060473 2046149 2046149 defendant Phylpott Anne David widow 593668 593668 Phylpott, Anne David, of Rolston, widow 0
4120369 2067559 2067559 defendant Sawyer John husbandman 593668 593668 Sawyer, John, of Rolston, husbandman 1
4176687 2087316 2087316 defendant William Henry Thomas yeoman 593668 593668 William, Henry Thomas, of Rolston, yeoman 0
4187088 2090975 2090975 defendant William Thomas yeoman 593668 593668 William, Thomas, of Rolston, yeoman 0
4218380 2101928 2101928 defendant Pricherd alias Vergh James Allona widow 593668 593668 Pricherd alias Vergh James, Allona, of Rolston, widow 0
4237861 2108845 2108845 defendant Harper David yeoman 593668 593668 Harper, David, of Rolston, yeoman 2
4300311 2130212 2130212 defendant Wyse George yeoman 593668 593668 Wyse, George, of Rolston, yeoman 0
4322464 2137927 2137927 defendant William Henry Thomas yeoman 593668 593668 William, Henry Thomas, of Rolston, yeoman 0
4322465 2137927 2137927 defendant Morgan Watkin Philip yeoman 593668 593668 Morgan, Watkin Philip, of Rolston, yeoman 1
4322466 2137927 2137927 defendant David Rethergh John yeoman 593668 593668 David, Rethergh John, of Rolston, yeoman 2
4370437 2154476 2154476 defendant Longe Henry husbandman 593668 593668 Longe, Henry, of Rolston, husbandman 1
4568265 2221646 2221646 defendant Eton Adam de   593668 593668 Eton, Adam de, of Rolston 0
4568269 2221647 2221647 defendant Eton Adam de   593668 593668 Eton, Adam de, of Rolston 0
4729262 2274370 2274370 plaintiff Lanham Hugh   593668 593668 Lanham, Hugh, of Rolston, vicar 0
4823274 2303369 2303369 defendant Wodman John husbandman 593668 593668 Wodman, John, of Rolston, husbandman 0
4882485 2321431 2321431 defendant Brounsale John husbandman 593668 593668 Brounsale, John, of Rolston, husbandman 0
4946454 2340887 2340887 defendant Barley Philip gent 593668 593668 Barley, Philip, of Rolston, gent 0
4983525 2351988 2351988 defendant Torkesay Thomas yeoman 593668 593668 Torkesay, Thomas, of Rolston, yeoman 1
5014891 2361232 2361232 defendant Clerk William husbandman 593668 593668 Clerk, William, of Rolston, husbandman 6
5014892 2361232 2361232 defendant Smyth Thomas husbandman 593668 593668 Smyth, Thomas, of Rolston, husbandman 7
5014893 2361232 2361232 defendant Smyth John husbandman 593668 593668 Smyth, John, of Rolston, husbandman 8
5029254 2365435 2365435 defendant Clerk Thomas husbandman 593668 593668 Clerk, Thomas, of Rolston, husbandman 3
5029255 2365435 2365435 defendant Smyth Thomas husbandman 593668 593668 Smyth, Thomas, of Rolston, husbandman 4
5029260 2365436 2365436 defendant Barley John husbandman 593668 593668 Barley, John, of Rolston, husbandman 3
5063821 2375713 2375713 defendant Johnson Thomas husbandman 593668 593668 Johnson, Thomas, of Rolston, husbandman 3
5268174 2435817 2435817 defendant Orchard Thomas husbandman 593668 593668 Orchard, Thomas, of Rolston, husbandman 0
5447709 2489189 2489189 defendant Lewete Roger yeoman 593668 593668 Lewete, Roger, of Rolston, yeoman 0
5502070 2505568 2505568 defendant Grene William (legal representative) 593668 593668 Grene, William, of Rolston, chaplain, executor of 6
5526946 2512994 2512994 defendant Bull William husbandman 593668 593668 Bull, William, of Rolston, husbandman 0
5531238 2514285 2514285 defendant Venner John husbandman 593668 593668 Venner, John, of Rolston, husbandman 4
5545008 2518544 2518544 defendant Venner John husbandman 593668 593668 Venner, John, of Rolston, husbandman 4
5623364 2551238 2551238 defendant Nevill William   593668 593668 Nevill, William, of Rolston, knight, son & heir of Thomas 0
5628613 2552915 2552915 defendant Wodeman Henry husbandman 593668 593668 Wodeman, Henry, of Rolston, husbandman 2
5635398 2555035 2555035 defendant de Barley Philip gent 593668 593668 (de Barley, Philip, of Rolston, gent 1
5635439 2555049 2555049 defendant de Barley Philip gent 593668 593668 together with de Barley, Philip, of Rolston, gent 4

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