names

19 rows where case_id = 1988732

✎ 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
3895588 1988732 1988732 plaintiff Stanley Anne Countess of Derby   Stanley, Anne, Countess of Derby 0
3895589 1988732 1988732 defendant Hawle John chaplain 617615 617615 Hawle, John, of Brymham, chaplain 0
3895590 1988732 1988732 defendant Hardcastell Christopher yeoman 647328 647328 Hardcastell, Christopher, of Daker, Pedderdale, yeoman 1
3895591 1988732 1988732 defendant Bekwyth Marmaduke yeoman 613000 613000 Bekwyth, Marmaduke, of Daker, yeoman 2
3895592 1988732 1988732 defendant Freer Ralph yeoman 647329 647329 Freer, Ralph, of Wersell, yeoman 3
3895593 1988732 1988732 defendant Bayn Roger gent 647330 647330 Bayn, Roger, of Bryggehowse, Nederdayle, gent 4
3895594 1988732 1988732 defendant Tottan William yeoman 647331 647331 Tottan, William, of Studeley, yeoman 5
3895595 1988732 1988732 defendant Gyll William yeoman 647332 647332 Gyll, William, of Ramysgyll, yeoman 6
3895596 1988732 1988732 defendant Thakwra Ralph yeoman 647332 647332 Thakwra, Ralph, of Ramysgyll, yeoman 7
3895597 1988732 1988732 defendant Jakson William yeoman 647332 647332 Jakson, William, of Ramysgyll, yeoman 8
3895598 1988732 1988732 defendant Smyth Christopher yeoman 647333 647333 Smyth, Christopher, of Ramusgyll, yeoman 9
3895599 1988732 1988732 defendant Faily John gent 647334 647334 Faily, John, of Farnlet, gent 10
3895600 1988732 1988732 defendant Keythley Thomas gent 610254 610254 Keythley, Thomas, of Newhall, gent 11
3895601 1988732 1988732 defendant Wright William yeoman 647335 647335 Wright, William, of Hartwythe, yeoman 12
3895602 1988732 1988732 defendant Bucke Lawrence yeoman 647336 647336 Bucke, Lawrence, of Hartwith, yeoman 13
3895603 1988732 1988732 defendant Hardcastell Miles yeoman 647335 647335 Hardcastell, Miles, of Hartwythe, yeoman 14
3895604 1988732 1988732 defendant Dowgill Miles yeoman 647335 647335 Dowgill, Miles, of Hartwythe, yeoman 15
3895605 1988732 1988732 defendant Sharpe Thomas laborer 647337 647337 Sharpe, Thomas, of Padleybryge, laborer 16
3895606 1988732 1988732 defendant Lupton Marmaduke laborer 647338 647338 Lupton, Marmaduke, of Padleybrige, laborer 17

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