names

24 rows where case_id = 1864838

✎ 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
3591073 1864838 1864838 plaintiff Delves Ellen widow   Delves, Ellen, widow 0
3591074 1864838 1864838 defendant Myners John gent 587325 587325 Myners, John, of Uttoxhater, gent 0
3591075 1864838 1864838 defendant Myners William gent 587325 587325 Myners, William, of Uttoxhater, gent 1
3591076 1864838 1864838 defendant Holys James yeoman 587325 587325 Holys, James, of Uttoxhater, yeoman 2
3591077 1864838 1864838 defendant More William, senior yeoman 587325 587325 More, William, senior, of Uttoxhater, yeoman 3
3591078 1864838 1864838 defendant More William, junior yeoman 587325 587325 More, William, junior, of Uttoxhater, yeoman 4
3591079 1864838 1864838 defendant Hyde Randolph yeoman 587325 587325 Hyde, Randolph, of Uttoxhater, yeoman 5
3591080 1864838 1864838 defendant Wright Thomas yeoman 587325 587325 Wright, Thomas, of Uttoxhater, yeoman 6
3591081 1864838 1864838 defendant Staley Thrustan yeoman 587325 587325 Staley, Thrustan, of Uttoxhater, yeoman 7
3591082 1864838 1864838 defendant Sutton Robert yeoman 587325 587325 Sutton, Robert, of Uttoxhater, yeoman 8
3591083 1864838 1864838 defendant Milward Thomas yeoman 587325 587325 Milward, Thomas, of Uttoxhater, yeoman 9
3591084 1864838 1864838 defendant Smyth John husbandman 587326 587326 Smyth, John, of Crakemershe, husbandman 10
3591085 1864838 1864838 defendant Poker William husbandman 587326 587326 Poker, William, of Crakemershe, husbandman 11
3591086 1864838 1864838 defendant Poker Henry husbandman 587326 587326 Poker, Henry, of Crakemershe, husbandman 12
3591087 1864838 1864838 defendant Wylde John husbandman 587326 587326 Wylde, John, of Crakemershe, husbandman 13
3591088 1864838 1864838 defendant Eton Richard laborer 587325 587325 Eton, Richard, of Uttoxhater, laborer 14
3591089 1864838 1864838 defendant Kyrkeby Richard laborer 587325 587325 Kyrkeby, Richard, of Uttoxhater, laborer 15
3591090 1864838 1864838 defendant Mylward Robert yeoman 587327 587327 Mylward, Robert, of Eton, yeoman 16
3591091 1864838 1864838 defendant Kyrstor Richard   587325 587325 Kyrstor, Richard, of Uttoxhater, hat maker 17
3591092 1864838 1864838 defendant Howette Richard laborer 587325 587325 Howette, Richard, of Uttoxhater, laborer 18
3591093 1864838 1864838 defendant Foxlowe Thomas smith 587325 587325 Foxlowe, Thomas, of Uttoxhater, smith 19
3591094 1864838 1864838 defendant Lelehed William glover 587325 587325 Lelehed, William, of Uttoxhater, glover 20
3591095 1864838 1864838 defendant Harden Thomas tailor 587325 587325 Harden, Thomas, of Uttoxhater, tailor 21
3591096 1864838 1864838 defendant Wright Henry yeoman 587325 587325 Wright, Henry, of Uttoxhater, yeoman 22

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