names

28 rows where case_id = 1931951

✎ 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
3718079 1931951 1931951 plaintiff Fenys Thomas knight   Fenys, Thomas, knight 0
3718080 1931951 1931951 plaintiff Walsyngham James esq   Walsyngham, James, esq 1
3718081 1931951 1931951 plaintiff Walsyngham Edmund knight   Walsyngham, Edmund, knight 2
3718082 1931951 1931951 plaintiff Feyns Giles     Feyns, Giles 3
3718083 1931951 1931951 plaintiff Belyngeham Richard     Belyngeham, Richard 4
3718084 1931951 1931951 plaintiff Walsyngham William     Walsyngham, William 5
3718085 1931951 1931951 plaintiff Darrell Thomas     Darrell, Thomas 6
3718086 1931951 1931951 plaintiff Cheyne Thomas     Cheyne, Thomas 7
3718087 1931951 1931951 plaintiff Bastard Roger     Bastard, Roger 8
3718088 1931951 1931951 plaintiff Blaknall William     Blaknall, William 9
3718089 1931951 1931951 plaintiff Draper William     Draper, William 10
3718090 1931951 1931951 plaintiff Walter Henry     Walter, Henry 11
3718091 1931951 1931951 plaintiff Moregayne Richard     Moregayne, Richard 12
3718092 1931951 1931951 plaintiff Buckland Richard     Buckland, Richard 13
3718093 1931951 1931951 plaintiff MArche Walter     MArche, Walter 14
3718094 1931951 1931951 plaintiff Hall Edward     Hall, Edward 15
3718095 1931951 1931951 plaintiff Grene John     Grene, John 16
3718096 1931951 1931951 plaintiff Sewall Thomas     Sewall, Thomas 17
3718097 1931951 1931951 plaintiff Kayme John     Kayme, John 18
3718098 1931951 1931951 plaintiff Tuppyn Thomas     Tuppyn, Thomas 19
3718099 1931951 1931951 plaintiff Hollter Robert     Hollter, Robert 20
3718100 1931951 1931951 defendant Wolcy George yeoman 585869 585869 Wolcy, George, of London, yeoman 0
3718101 1931951 1931951 defendant Chamber Thomas gent 586023 586023 Chamber, Thomas, of Laughton, gent 1
3718102 1931951 1931951 defendant Middilton Thomas yeoman 610554 610554 Middilton, Thomas, of Auston, yeoman 2
3718103 1931951 1931951 defendant Milles Nicholas yeoman 589579 589579 Milles, Nicholas, of Glynde, yeoman 3
3718104 1931951 1931951 defendant Tyseherst Hamond yeoman 593312 593312 Tyseherst, Hamond, of Seford, yeoman 4
3718105 1931951 1931951 defendant Roke John yeoman 617160 617160 Roke, John, of Shelmeston, yeoman 5
3718106 1931951 1931951 defendant Roke Richard yeoman 610554 610554 Roke, Richard, of Auston, yeoman 6

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