names

15 rows where case_id = 2350795

✎ 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
4979383 2350795 2350795 plaintiff Seynt Quintyne Anthony     Seynt Quintyne, Anthony 0
4979384 2350795 2350795 defendant Barde Robert esq 591835 591835 Barde, Robert, of Osgodby, esq 0
4979385 2350795 2350795 defendant Aton Ralph husbandman 600894 600894 Aton, Ralph, of Kylwardby, husbandman 1
4979386 2350795 2350795 defendant Tomson Stephen husbandman 591835 591835 together with Tomson, Stephen, of Osgodby, husbandman 2
4979387 2350795 2350795 defendant Watson John husbandman 591835 591835 Watson, John, of Osgodby, husbandman 3
4979388 2350795 2350795 defendant Baron Richard husbandman 591835 591835 Baron, Richard, of Osgodby, husbandman 4
4979389 2350795 2350795 defendant Prat John husbandman 591835 591835 Prat, John, of Osgodby, husbandman 5
4979390 2350795 2350795 defendant Prat William husbandman 591835 591835 Prat, William, of Osgodby, husbandman 6
4979391 2350795 2350795 defendant Heryson Thomas husbandman 600894 600894 Heryson, Thomas, of Kylwardby, husbandman 7
4979392 2350795 2350795 defendant Tomson William husbandman 600894 600894 Tomson, William, of Kylwardby, husbandman 8
4979393 2350795 2350795 defendant Aton Thomas husbandman 600894 600894 Aton, Thomas, of Kylwardby, husbandman 9
4979394 2350795 2350795 defendant Grene Stephen husbandman 600894 600894 Grene, Stephen, of Kylwardby, husbandman 10
4979395 2350795 2350795 defendant Robynson William husbandman 600894 600894 Robynson, William, of Kylwardby, husbandman 11
4979396 2350795 2350795 defendant Smyth John husbandman 776791 776791 Smyth, John, of Kayton, husbandman 12
4979397 2350795 2350795 defendant Nelson Nicholas husbandman 589401 589401 Nelson, Nicholas, of Scardeburgh, husbandman 13

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