names

21 rows where case_id = 1871355

✎ 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
3611789 1871355 1871355 plaintiff Sheffeld Robert esq   Sheffeld, Robert, esq 0
3611790 1871355 1871355 defendant Percy Leo esq 593430 593430 Percy, Leo, of Flyxburgh, esq 0
3611791 1871355 1871355 defendant Kyrkham John husbandman 593430 593430 Kyrkham, John, of Flyxburgh, husbandman 1
3611792 1871355 1871355 defendant Bagshawe John yeoman 593430 593430 Bagshawe, John, of Flyxburgh, yeoman 2
3611793 1871355 1871355 defendant Davy John husbandman 593430 593430 Davy, John, of Flyxburgh, husbandman 3
3611794 1871355 1871355 defendant Wryght Thomas husbandman 593430 593430 Wryght, Thomas, of Flyxburgh, husbandman 4
3611795 1871355 1871355 defendant Hobden Thomas yeoman 593430 593430 Hobden, Thomas, of Flyxburgh, yeoman 5
3611796 1871355 1871355 defendant Rawelyn William husbandman 593430 593430 Rawelyn, William, of Flyxburgh, husbandman 6
3611797 1871355 1871355 defendant Graunger Reginald husbandman 593430 593430 Graunger, Reginald, of Flyxburgh, husbandman 7
3611798 1871355 1871355 defendant Ryplyngham Christopher laborer 593430 593430 Ryplyngham, Christopher, of Flyxburgh, laborer 8
3611799 1871355 1871355 defendant Smyth Roger laborer 593430 593430 Smyth, Roger, of Flyxburgh, laborer 9
3611800 1871355 1871355 defendant Hynghowe George laborer 593430 593430 Hynghowe, George, of Flyxburgh, laborer 10
3611801 1871355 1871355 defendant Crosse William laborer 593430 593430 Crosse, William, of Flyxburgh, laborer 11
3611802 1871355 1871355 defendant Rawelyn Thomas laborer 593430 593430 Rawelyn, Thomas, of Flyxburgh, laborer 12
3611803 1871355 1871355 defendant Marchaunt Thomas laborer 593430 593430 Marchaunt, Thomas, of Flyxburgh, laborer 13
3611804 1871355 1871355 defendant Rypley John husbandman 593430 593430 Rypley, John, of Flyxburgh, husbandman 14
3611805 1871355 1871355 defendant Skune Alexander yeoman 593431 593431 Skune, Alexander, of Flyxburghstather, yeoman 15
3611806 1871355 1871355 defendant Dubyng William laborer 593431 593431 Dubyng, William, of Flyxburghstather, laborer 16
3611807 1871355 1871355 defendant Haldesworth John yeoman 593431 593431 Haldesworth, John, of Flyxburghstather, yeoman 17
3611808 1871355 1871355 defendant Lyndesey Thomas laborer 593431 593431 Lyndesey, Thomas, of Flyxburghstather, laborer 18
3611809 1871355 1871355 defendant Dubyng John laborer 593431 593431 Dubyng, John, of Flyxburghstather, 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);