names

41 rows where place_id = 609329

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3677985 1919159 1919159 defendant Mowbrey John husbandman 609329 609329 Mowbrey, John, of Bonsall, husbandman 0
3757356 1944280 1944280 defendant Somarford Oliver husbandman 609329 609329 Somarford, Oliver, of Bonsall, husbandman 0
3766010 1947033 1947033 defendant Adam William husbandman 609329 609329 Adam, William, of Bonsall, husbandman 2
3766011 1947033 1947033 defendant Adam Thomas husbandman 609329 609329 Adam, Thomas, of Bonsall, husbandman 3
3808880 1960658 1960658 defendant Balyden Oliver yeoman 609329 609329 Balyden, Oliver, of Bonsall, yeoman 0
3808881 1960658 1960658 defendant Bowleshawe Henry husbandman 609329 609329 Bowleshawe, Henry, of Bonsall, husbandman 1
3808882 1960658 1960658 defendant Robynson Nicholas miner 609329 609329 Robynson, Nicholas, of Bonsall, miner 2
3813562 1962159 1962159 defendant Hopkynson John husbandman 609329 609329 Hopkynson, John, of Bonsall, husbandman 0
3846572 1972483 1972483 defendant Durrant Stephen gent 609329 609329 Durrant, Stephen, of Bonsall, gent 5
3867283 1979292 1979292 defendant Durrant Stephen husbandman 609329 609329 Durrant, Stephen, of Bonsall, husbandman 0
3894740 1988445 1988445 defendant Durront Stephen yeoman 609329 609329 Durront, Stephen, of Bonsall, yeoman 0
3908999 1993304 1993304 defendant Durront Stephen yeoman 609329 609329 Durront, Stephen, of Bonsall, yeoman 0
3931877 2000961 2000961 defendant Stone Oliver husbandman 609329 609329 Stone, Oliver, of Bonsall, husbandman 0
3931878 2000961 2000961 defendant Gell Thomas usbandman 609329 609329 Gell, Thomas, of Bonsall, usbandman 1
4117655 2066610 2066610 defendant Hopkinson Edward yeoman 609329 609329 Hopkinson, Edward, of Bonsall, yeoman 1
4149111 2077813 2077813 defendant Raynes Henry husbandman 609329 609329 Raynes, Henry, of Bonsall, husbandman 1
4190291 2092113 2092113 defendant Agarsley John husbandman 609329 609329 Agarsley, John, of Bonsall, husbandman 1
4233824 2107356 2107356 defendant Hall John husbandman 609329 609329 Hall, John, of Bonsall, husbandman 0
4310219 2133729 2133729 defendant Bowne George yeoman 609329 609329 Bowne, George, of Bonsall, yeoman 0
4379508 2157756 2157756 defendant Mather George, junior yeoman 609329 609329 Mather, George, junior, of Bonsall, yeoman 0
4384748 2159586 2159586 defendant Gite or Gyte Christopher yeoman 609329 609329 Gite or Gyte, Christopher, of Bonsall, yeoman 0
4384749 2159586 2159586 defendant Gite or Gyte Richard yeoman 609329 609329 Gite or Gyte, Richard, of Bonsall, yeoman 1
4404994 2166241 2166241 defendant Needham James yeoman 609329 609329 Needham, James, of Bonsall, yeoman 0
4409529 2167783 2167783 defendant Mather George, junior yeoman 609329 609329 Mather, George, junior, of Bonsall, yeoman 0
4530209 2209738 2209738 defendant Synley John   609329 609329 Synley, John, of Bonsall 2
4959923 2344928 2344928 defendant Sutton William husbandman 609329 609329 Sutton, William, of Bonsall, husbandman 0
5040434 2368743 2368743 defendant Foster Richard husbandman 609329 609329 Foster, Richard, of Bonsall, husbandman 0
5320734 2451294 2451294 defendant Goyte Henry yeoman 609329 609329 Goyte, Henry, of Bonsall, yeoman 0
5320735 2451294 2451294 defendant Bonne John yeoman 609329 609329 Bonne, John, of Bonsall, yeoman 1
5320736 2451294 2451294 defendant Eyton Nicholas laborer 609329 609329 Eyton, Nicholas, of Bonsall, laborer 2
5320737 2451294 2451294 defendant Bestowe Henry laborer 609329 609329 Bestowe, Henry, of Bonsall, laborer 3
5320738 2451294 2451294 defendant Hayward Thurston yeoman 609329 609329 Hayward, Thurston, of Bonsall, yeoman 4
5320739 2451294 2451294 defendant Balydon William laborer 609329 609329 Balydon, William, of Bonsall, laborer 5
5320740 2451294 2451294 defendant Nedeham Henry laborer 609329 609329 Nedeham, Henry, of Bonsall, laborer 6
5320741 2451294 2451294 defendant Spencer William laborer 609329 609329 Spencer, William, of Bonsall, laborer 7
5320742 2451294 2451294 defendant Somerford John laborer 609329 609329 Somerford, John, of Bonsall, laborer 8
5320743 2451294 2451294 defendant Somerford William laborer 609329 609329 Somerford, William, of Bonsall, laborer 9
5321062 2451394 2451394 defendant Beystowe Richard husbandman 609329 609329 Beystowe, Richard, of Bonsall, husbandman 0
5321063 2451394 2451394 defendant Moubray John husbandman 609329 609329 Moubray, John, of Bonsall, husbandman 1
5543136 2517971 2517971 defendant Burton Richard laborer 609329 609329 Burton, Richard, of Bonsall, laborer 5
5571460 2526207 2526207 defendant Godenough Ralph husbandman 609329 609329 Godenough, Ralph, of Bonsall, husbandman 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);