names

28 rows where case_id = 2360554

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5012697 2360554 2360554 plaintiff Abbot John     Abbot, John 0
5012698 2360554 2360554 defendant Pynchebek William prior of Spaldyng Priory   Pynchebek, William, prior of Spaldyng Priory 0
5012699 2360554 2360554 defendant Leek Robert monk   Leek, Robert, monk 1
5012700 2360554 2360554 defendant Rede Robert monk   Rede, Robert, monk 2
5012701 2360554 2360554 defendant Byllyngburgh Simon monk   Byllyngburgh, Simon, monk 3
5012702 2360554 2360554 defendant Grantham John monk   Grantham, John, monk 4
5012703 2360554 2360554 defendant Sybsay Robert monk   Sybsay, Robert, monk 5
5012704 2360554 2360554 defendant Repynghale William monk   Repynghale, William, monk 6
5012705 2360554 2360554 defendant Woldrich Hugh monk   Woldrich, Hugh, monk 7
5012706 2360554 2360554 defendant Litelbury William yeoman 589460 589460 Litelbury, William, of Spaldyng, yeoman 8
5012707 2360554 2360554 defendant Rumpe Alexander yeoman 589460 589460 Rumpe, Alexander, of Spaldyng, yeoman 9
5012708 2360554 2360554 defendant Spenser Thomas yeoman 589460 589460 Spenser, Thomas, of Spaldyng, yeoman 10
5012709 2360554 2360554 defendant Wryght Robert yeoman 589460 589460 Wryght, Robert, of Spaldyng, yeoman 11
5012710 2360554 2360554 defendant Ives Richard yeoman 589460 589460 Ives, Richard, of Spaldyng, yeoman 12
5012711 2360554 2360554 defendant Harryson Thomas yeoman 589460 589460 Harryson, Thomas, of Spaldyng, yeoman 13
5012712 2360554 2360554 defendant Harryson Nicholas yeoman 589460 589460 Harryson, Nicholas, of Spaldyng, yeoman 14
5012713 2360554 2360554 defendant Roger Nicholas yeoman 589460 589460 Roger, Nicholas, of Spaldyng, yeoman 15
5012714 2360554 2360554 defendant Barneby William yeoman 589460 589460 Barneby, William, of Spaldyng, yeoman 16
5012715 2360554 2360554 defendant Thorp Robert yeoman 589460 589460 Thorp, Robert, of Spaldyng, yeoman 17
5012716 2360554 2360554 defendant Swanpek John yeoman 589460 589460 Swanpek, John, of Spaldyng, yeoman 18
5012717 2360554 2360554 defendant Oxeherd Robert yeoman 589460 589460 Oxeherd, Robert, of Spaldyng, yeoman 19
5012718 2360554 2360554 defendant Howet Nicholas yeoman 589460 589460 Howet, Nicholas, of Spaldyng, yeoman 20
5012719 2360554 2360554 defendant Howet Robert yeoman 589460 589460 Howet, Robert, of Spaldyng, yeoman 21
5012720 2360554 2360554 defendant Ayleward John yeoman 589460 589460 Ayleward, John, of Spaldyng, yeoman 22
5012721 2360554 2360554 defendant Gamet John yeoman 589460 589460 Gamet, John, of Spaldyng, yeoman 23
5012722 2360554 2360554 defendant Gery Thomas yeoman 589460 589460 Gery, Thomas, of Spaldyng, yeoman 24
5012723 2360554 2360554 defendant Sclater Thomas yeoman 589460 589460 Sclater, Thomas, of Spaldyng, yeoman 25
5012724 2360554 2360554 defendant Graunger William yeoman 589460 589460 Graunger, William, of Spaldyng, yeoman 26

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