names

41 rows where case_id = 2515459

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5534898 2515459 2515459 plaintiff Beaufort Margaret Countess of Richmond   Beaufort, Margaret, Countess of Richmond 0
5534899 2515459 2515459 defendant Garnet Edmund yeoman 897343 897343 Garnet, Edmund, of Crostetwhayte, yeoman 0
5534900 2515459 2515459 defendant Gardyner Thomas yeoman 897343 897343 Gardyner, Thomas, of Crostetwhayte, yeoman 1
5534901 2515459 2515459 defendant Huberstye Robert yeoman 897343 897343 Huberstye, Robert, of Crostetwhayte, yeoman 2
5534902 2515459 2515459 defendant Saunderson Thomas yeoman 897343 897343 Saunderson, Thomas, of Crostetwhayte, yeoman 3
5534903 2515459 2515459 defendant Michell William yeoman 897343 897343 Michell, William, of Crostetwhayte, yeoman 4
5534904 2515459 2515459 defendant Coke Thomas yeoman 897343 897343 Coke, Thomas, of Crostetwhayte, yeoman 5
5534905 2515459 2515459 defendant Huberstye Roland yeoman 897343 897343 Huberstye, Roland, of Crostetwhayte, yeoman 6
5534906 2515459 2515459 defendant Levynes William yeoman 897343 897343 Levynes, William, of Crostetwhayte, yeoman 7
5534907 2515459 2515459 defendant Rolandson Richard yeoman 897343 897343 Rolandson, Richard, of Crostetwhayte, yeoman 8
5534908 2515459 2515459 defendant Rolandson John yeoman 897343 897343 Rolandson, John, of Crostetwhayte, yeoman 9
5534909 2515459 2515459 defendant Carpmell James yeoman 897343 897343 Carpmell, James, of Crostetwhayte, yeoman 10
5534910 2515459 2515459 defendant Knype Edmund yeoman 897343 897343 Knype, Edmund, of Crostetwhayte, yeoman 11
5534911 2515459 2515459 defendant Carpmell Thomas yeoman 897343 897343 Carpmell, Thomas, of Crostetwhayte, yeoman 12
5534912 2515459 2515459 defendant Garnet William yeoman 897343 897343 Garnet, William, of Crostetwhayte, yeoman 13
5534913 2515459 2515459 defendant Dicconson William yeoman 897343 897343 Dicconson, William, of Crostetwhayte, yeoman 14
5534914 2515459 2515459 defendant Dicconson Richard     Dicconson, Richard 15
5534915 2515459 2515459 defendant of Crostetwhayte   yeoman   of Crostetwhayte, yeoman 16
5534916 2515459 2515459 defendant Dicconson Thomas     Dicconson, Thomas 17
5534917 2515459 2515459 defendant Hall Robert     Hall, Robert 18
5534918 2515459 2515459 defendant Knype Thomas     Knype, Thomas 19
5534919 2515459 2515459 defendant Herryson James     Herryson, James 20
5534920 2515459 2515459 defendant Walker James     Walker, James 21
5534921 2515459 2515459 defendant Walker John     Walker, John 22
5534922 2515459 2515459 defendant Rychardson Peter     Rychardson, Peter 23
5534923 2515459 2515459 defendant Richardson Richard     Richardson, Richard 24
5534924 2515459 2515459 defendant Huberstye James     Huberstye, James 25
5534925 2515459 2515459 defendant Huberstye Richard     Huberstye, Richard 26
5534926 2515459 2515459 defendant Garnet Miles     Garnet, Miles 27
5534927 2515459 2515459 defendant Crakell Edmund     Crakell, Edmund 28
5534928 2515459 2515459 defendant Rolandson Thomas     Rolandson, Thomas 29
5534929 2515459 2515459 defendant Cok John yeoman 736785 736785 Cok, John, of Lyth, yeoman 30
5534930 2515459 2515459 defendant Danson John     Danson, John 31
5534931 2515459 2515459 defendant Danson Robert     Danson, Robert 32
5534932 2515459 2515459 defendant Fadershall Edmund     Fadershall, Edmund 33
5534933 2515459 2515459 defendant Jakson Peter     Jakson, Peter 34
5534934 2515459 2515459 defendant Symkynson Robert     Symkynson, Robert 35
5534935 2515459 2515459 defendant Bryggys James     Bryggys, James 36
5534936 2515459 2515459 defendant Bryggys Henry     Bryggys, Henry 37
5534937 2515459 2515459 defendant Knype Peter     Knype, Peter 38
5534938 2515459 2515459 defendant Garnet Henry     Garnet, Henry 39

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