names

28 rows where place_id = 587321

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591066 1864835 1864835 defendant Decon John Hill yeoman 587321 587321 Decon, John Hill, of Bosebury, yeoman 0
3642548 1908112 1908112 defendant Bruge Richard husbandman 587321 587321 Bruge, Richard, of Bosebury, husbandman 0
3678441 1919312 1919312 defendant Wallewyn Edward gent 587321 587321 Wallewyn, Edward, of Bosebury, gent 0
3678442 1919312 1919312 defendant Wallewyn Eustace gent 587321 587321 Wallewyn, Eustace, of Bosebury, gent 1
3678443 1919312 1919312 defendant Broun William laborer 587321 587321 Broun, William, of Bosebury, laborer 2
3678444 1919312 1919312 defendant Walshman Griffin laborer 587321 587321 Walshman, Griffin, of Bosebury, laborer 3
3678445 1919312 1919312 defendant Broun Robert laborer 587321 587321 Broun, Robert, of Bosebury, laborer 4
3683381 1920926 1920926 defendant Stockton Katherine widow 587321 587321 Stockton, Katherine, of Bosebury, widow 0
3683382 1920926 1920926 defendant Rogge James laborer 587321 587321 Rogge, James, of Bosebury, laborer 1
3683383 1920926 1920926 defendant Stokton Richard laborer 587321 587321 Stokton, Richard, of Bosebury, laborer 2
3683384 1920926 1920926 defendant Stockton Sevacre laborer 587321 587321 Stockton, Sevacre, of Bosebury, laborer 3
3683385 1920926 1920926 defendant Roper Walter laborer 587321 587321 Roper, Walter, of Bosebury, laborer 4
3771105 1948652 1948652 defendant Warker Thomas laborer 587321 587321 Warker, Thomas, of Bosebury, laborer 4
3825790 1965913 1965913 defendant Monyngton John gent 587321 587321 Monyngton, John, of Bosebury, gent 0
3841665 1970977 1970977 defendant Walweyne Edward gent 587321 587321 Walweyne, Edward, of Bosebury, gent 0
3855713 1975422 1975422 defendant Seyburne Richard yeoman 587321 587321 Seyburne, Richard, of Bosebury, yeoman 0
4102003 2061026 2061026 defendant Browne John husbandman 587321 587321 Browne, John, of Bosebury, husbandman 0
4102004 2061026 2061026 defendant Hawfyld Anthony husbandman 587321 587321 Hawfyld, Anthony, of Bosebury, husbandman 1
4102006 2061027 2061027 defendant Browne John husbandman 587321 587321 Browne, John, of Bosebury, husbandman 0
4102007 2061027 2061027 defendant Hawfyld Anthony yeoman 587321 587321 Hawfyld, Anthony, of Bosebury, yeoman 1
4102009 2061028 2061028 defendant Fareley Humphrey husbandman 587321 587321 Fareley, Humphrey, of Bosebury, husbandman 0
4102012 2061029 2061029 defendant Fareley Humphrey husbandman 587321 587321 Fareley, Humphrey, of Bosebury, husbandman 0
4240105 2109663 2109663 defendant Fynche Richard yeoman 587321 587321 Fynche, Richard, of Bosebury, yeoman 1
4387371 2160422 2160422 defendant Brookynge John shoemaker 587321 587321 Brookynge, John, of Bosebury, shoemaker 0
5218607 2421172 2421172 defendant Brugge Roger yeoman 587321 587321 Brugge, Roger, of Bosebury, yeoman 2
5218611 2421173 2421173 defendant Brugge Roger yeoman 587321 587321 Brugge, Roger, of Bosebury, yeoman 1
5566728 2524866 2524866 defendant Gonne Robert husbandman 587321 587321 Gonne, Robert, of Bosebury, husbandman 2
5619329 2549896 2549896 plaintiff Pedwalle John   587321 587321 Pedwalle, John, of Bosebury 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);