names

41 rows where place_id = 588591

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595008 1866070 1866070 defendant Sutton Robert esq 588591 588591 Sutton, Robert, of Averham, esq 0
3599059 1867342 1867342 defendant Sutton Roland gent 588591 588591 Sutton, Roland, of Averham, gent 0
3606179 1869603 1869603 defendant Sutton Roland gent 588591 588591 Sutton, Roland, of Averham, gent 0
3606182 1869604 1869604 defendant Sutton Roland gent 588591 588591 Sutton, Roland, of Averham, gent 0
3606209 1869611 1869611 defendant Barwykke Richard gent 588591 588591 Barwykke, Richard, of Averham, gent 0
3615387 1872455 1872455 defendant Sutton Roland gent 588591 588591 Sutton, Roland, of Averham, gent 0
3615388 1872455 1872455 defendant Undurn John husbandman 588591 588591 Undurn, John, of Averham, husbandman 1
3615393 1872456 1872456 defendant Undern John husbandman 588591 588591 Undern, John, of Averham, husbandman 0
3615398 1872457 1872457 defendant Undurn John husbandman 588591 588591 Undurn, John, of Averham, husbandman 0
3795143 1956346 1956346 defendant Payntour John yeoman 588591 588591 Payntour, John, of Averham, yeoman 0
3830540 1967429 1967429 defendant Sutton Henry   588591 588591 Sutton, Henry, of Averham, knight 0
3830541 1967429 1967429 defendant Salven Henry yeoman 588591 588591 Salven, Henry, of Averham, yeoman 1
3830542 1967429 1967429 defendant Thomlynson Lawrence yeoman 588591 588591 Thomlynson, Lawrence, of Averham, yeoman 2
3830546 1967430 1967430 defendant Sutton Henry   588591 588591 Sutton, Henry, of Averham, knight 0
3830547 1967430 1967430 defendant Salven Henry yeoman 588591 588591 Salven, Henry, of Averham, yeoman 1
3830548 1967430 1967430 defendant Thomlynson Lawrence yeoman 588591 588591 Thomlynson, Lawrence, of Averham, yeoman 2
3914188 1995088 1995088 defendant Leverton George husbandman 588591 588591 Leverton, George, of Averham, husbandman 1
3984215 2019122 2019122 plaintiff Sutton William esq 588591 588591 Sutton, William, of Averham, esq 0
4047833 2041674 2041674 plaintiff Studburye or Sudbury Robert husbandman 588591 588591 Studburye or Sudbury, Robert, of Averham, husbandman 0
4360367 2150875 2150875 defendant Okes William yeoman 588591 588591 Okes, William, of Averham, yeoman 1
4422021 2171767 2171767 defendant Sutton John de   588591 588591 Sutton, John de, of Averham 2
4570818 2222442 2222442 defendant Bold Andrew   588591 588591 Bold, Andrew, of Averham, parson 0
4630827 2240531 2240531 plaintiff Sutton Henry de   588591 588591 Sutton, Henry de, of Averham 0
4871806 2318154 2318154 defendant Cokman Thomas husbandman 588591 588591 Cokman, Thomas, of Averham, husbandman 1
5047001 2370727 2370727 defendant Sutton William   588591 588591 Sutton, William, of Averham, parson 1
5161950 2404607 2404607 defendant Sutton Richard esq 588591 588591 Sutton, Richard, of Averham, esq 0
5176181 2408725 2408725 defendant Sutton Richard esq 588591 588591 Sutton, Richard, of Averham, esq 0
5198130 2415200 2415200 defendant Sutton Richard esq 588591 588591 Sutton, Richard, of Averham, esq 0
5287688 2441425 2441425 defendant Sutton Robert esq 588591 588591 Sutton, Robert, of Averham, esq, son of Sutton, Richard, of Averham, esq 2
5392463 2472921 2472921 defendant Sutton William clerk 588591 588591 Sutton, William, of Averham, clerk 3
5392464 2472921 2472921 defendant Oldham Ralph laborer 588591 588591 Oldham, Ralph, of Averham, laborer 4
5405507 2476655 2476655 defendant Sutton William clerk 588591 588591 Sutton, William, of Averham, clerk 3
5405508 2476655 2476655 defendant Oldham Ralph laborer 588591 588591 Oldham, Ralph, of Averham, laborer 4
5418579 2480483 2480483 defendant Sutton William clerk 588591 588591 Sutton, William, of Averham, clerk 3
5418580 2480483 2480483 defendant Oldham Ralph laborer 588591 588591 Oldham, Ralph, of Averham, laborer 4
5436527 2485860 2485860 defendant Sutton William clerk 588591 588591 Sutton, William, of Averham, clerk 3
5436528 2485860 2485860 defendant Oldham Ralph laborer 588591 588591 Oldham, Ralph, of Averham, laborer 4
5436533 2485861 2485861 defendant Sutton William clerk 588591 588591 Sutton, William, of Averham, clerk 3
5436534 2485861 2485861 defendant Oldham Ralph laborer 588591 588591 Oldham, Ralph, of Averham, laborer 4
5497258 2504118 2504118 defendant Sutton Robert esq 588591 588591 Sutton, Robert, of Averham, esq 0
5512089 2508642 2508642 defendant Sutton Robert esq 588591 588591 Sutton, Robert, of Averham, esq 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);