names

21 rows where case_id = 2515354

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5534550 2515354 2515354 plaintiff Babyngton Thomas     Babyngton, Thomas 0
5534551 2515354 2515354 defendant Boun William yeoman 897299 897299 Boun, William, of Matlokke, yeoman 0
5534552 2515354 2515354 defendant Flynt Henry laborer 897299 897299 Flynt, Henry, of Matlokke, laborer 1
5534553 2515354 2515354 defendant Mader John laborer 897299 897299 Mader, John, of Matlokke, laborer 2
5534554 2515354 2515354 defendant Keyn James laborer 897299 897299 Keyn, James, of Matlokke, laborer 3
5534555 2515354 2515354 defendant Warde Henry laborer 897299 897299 Warde, Henry, of Matlokke, laborer 4
5534556 2515354 2515354 defendant Wyllymotte Nicholas laborer 897299 897299 Wyllymotte, Nicholas, of Matlokke, laborer 5
5534557 2515354 2515354 defendant Etwall William laborer 897300 897300 Etwall, William, of Allerwalsley, laborer 6
5534558 2515354 2515354 defendant Warde Nicholas laborer 897301 897301 Warde, Nicholas, of Allerwalsle, laborer 7
5534559 2515354 2515354 defendant Stone William laborer 597306 597306 Stone, William, of Elton, laborer 8
5534560 2515354 2515354 defendant Nicols Hugh laborer 593727 593727 Nicols, Hugh, of Codnore, laborer 9
5534561 2515354 2515354 defendant Adam Henry laborer 897302 897302 Adam, Henry, of Croumford, laborer 10
5534562 2515354 2515354 defendant Bere William laborer 897302 897302 Bere, William, of Croumford, laborer 11
5534563 2515354 2515354 defendant Batemon William labnorer 752215 752215 Batemon, William, of Botesale, labnorer 12
5534564 2515354 2515354 defendant Wryght Robert laborer 598843 598843 Wryght, Robert, of Bonsale, laborer 13
5534565 2515354 2515354 defendant Robothom Gilbert laborer 897303 897303 Robothom, Gilbert, of Ryber, laborer 14
5534566 2515354 2515354 defendant Spenser Nicholas laborer 897303 897303 Spenser, Nicholas, of Ryber, laborer 15
5534567 2515354 2515354 defendant Smyth John walker 601413 601413 Smyth, John, of Bealper, walker 16
5534568 2515354 2515354 defendant Mylner William   592500 592500 Mylner, William, of Horseley, scythe smith 17
5534569 2515354 2515354 defendant SMyth Thomas laborer 897299 897299 SMyth, Thomas, of Matlokke, laborer 18
5534570 2515354 2515354 defendant Hunt Thomas laborer 593361 593361 Hunt, Thomas, of Derley, laborer 19

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