names

13 rows where case_id = 2461215

✎ 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
5353662 2461215 2461215 plaintiff Gravener John     Gravener, John 0
5353663 2461215 2461215 defendant Taillour Thomas yeoman 614677 614677 Taillour, Thomas, of Magna Lynton, Cams, yeoman 0
5353664 2461215 2461215 defendant Beye Simon mikller 597925 597925 Beye, Simon, of Magna Lynton, mikller 1
5353665 2461215 2461215 defendant Myncent John barker 597925 597925 Myncent, John, of Magna Lynton, barker 2
5353666 2461215 2461215 defendant Teversham John husbandman 597925 597925 Teversham, John, of Magna Lynton, husbandman 3
5353667 2461215 2461215 defendant Myncent William mercer 597925 597925 Myncent, William, of Magna Lynton, mercer 4
5353668 2461215 2461215 defendant Myncent Thomas husbandman 597925 597925 Myncent, Thomas, of Magna Lynton, husbandman 5
5353669 2461215 2461215 defendant Vyncent William yeoman 597925 597925 Vyncent, William, of Magna Lynton, yeoman 6
5353670 2461215 2461215 defendant Gardener Thomas fuller 597925 597925 Gardener, Thomas, of Magna Lynton, fuller 7
5353671 2461215 2461215 defendant Parkyn Richard yeoman 597925 597925 Parkyn, Richard, of Magna Lynton, yeoman 8
5353672 2461215 2461215 defendant Snareston John yeoman 597925 597925 Snareston, John, of Magna Lynton, yeoman 9
5353673 2461215 2461215 defendant Myncent John baker 597925 597925 Myncent, John, of Magna Lynton, baker 10
5353674 2461215 2461215 defendant Grene John husbandman 597925 597925 Grene, John, of Magna Lynton, husbandman 11

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